臺灣博碩士論文加值系統

近年來隨著行動作業系統與雲端科技的進步，同時改變了人們的生活型態，為了提升人類的居家生活品質，居家智慧系統已逐漸發展成型。現今多數的新建房屋大多包含智慧家庭系統，智慧家庭系統不僅擁有防盜功能，使用者更可透過觸控介面或行動裝置，觀看家中狀況或遠端遙控各種電器。
現今擁有居家智慧系統的房屋大多為建造前已規劃在內，對於老舊房屋事想加裝居家智慧系統，不僅金額昂貴且須破壞裝潢，為此我們以系統靈活性與擴充性為優先考量，開發一基於雲端之智慧家庭自動化系統，讓使用者可擴充舊有保全系統，同時增加居家智慧系統的功能，提供濟實惠的解決方案給有需要的家庭。
為降低硬體需求，採用Arduino MEGA作為居家防護的核心，我們將其命名為「HSG」。並整合多項Google所提供的免費服務，開發一低成本且具擴展性的雲端服務平台，使HSG透過此平台相互溝通。

In recent years, Mobile Operating System and Cloud Computing Technologies are grows rapidly and changed the behavior of human being. To increase the quality of human life, the Smart Home System has been developed gradually. Nowadays, most of the new construction project contains smart home system. Smart Home System not only has security function but also can provide user remote control the household electric appliance.
Most of the smart home system has been planning before the construction. If people want to retrofitting smart home system, not only take high cost but also have to refit the house. Therefore, we propose a Cloud-based Smart Home Automation to provide users an affordable solution.
In order to cost down the information technology hardware requirements, a low-end Arduino MEGA board is used to implement the critical hardware module for the proposed idea. We named it as home safety gateway (HSG) which module utilizes the public network, internet, to communicate to the other alliance HSG modules. We not only integration multiple Google service but also bring most management and hairy tasks to the nearly free cloud-based service platform, Google app engine, to develop a cheap and extensible web service.

第一章 緒論 1
1.1 研究動機與目的 1
1.2 系統概述 2
1.3 論文架構 4
第二章 背景研究 5
2.1 居家智慧系統 5
2.1.1 市場現況 5
2.1.2 產品分析 6
2.1.3 分析結果 8
2.2 雲端科技 8
2.2.1 雲端優勢 8
2.3 行動作業系統 9
第三章 居家安全對外匝道 10
3.1 開發語言 10
3.1.1 C語言 10
3.2 Arduinod開發板 10
3.2.1 Arduino MEGA 10
3.2.2 Arduino Ethernet shield 11
3.2.3 Arduino GSM shield 12
3.3 感測器 12
3.3.1 溫度感測器 13
3.3.2 磁簧感測器 13
3.3.3 煙霧感測器 14
3.3.4 拉力感測器 14
3.4 遠端遙控與感測器佈防 15
3.4.1 Web Server DNS 15
3.4.2 遠端遙控 16
3.4.3 狀態回傳 16
3.4.4 感測器佈防 17
3.4.5 感測器例外排除 17
3.5 簡訊派送 18
第四章 資料庫與雲端服務 19
4.1 開發平台與服務簡介 19
4.1.1 Python 19
4.1.2 Google App Engine 20
4.1.3 Fusion Tables 20
4.1.4 SQL 21
4.1.5 Google maps API 22
4.1.6 Google APIs Console 23
4.1.7 OAuth 23
4.2 資料庫結構 24
4.2.1 帳戶資料 24
4.2.2 連絡人資料 25
4.2.3 電器資料 25
4.2.4 排程資料 25
4.2.5 防區資料 26
4.2.6 事件紀錄 26
4.3 GAE實作 26
4.3.1 Webapp 架構 26
4.3.2 雲端與資料庫連結 27
4.3.3 Service Account認證 27
4.3.4 應用程式資料存取 29
4.3.5 警報派送 32
第五章 APP實作 34
5.1 開發平台 34
5.1.1 MIT App Inventor 34
5.2 實作方法 35
5.2.1 以FusiontablesControl套件實現 35
5.2.2 以GAE實現 39
第六章 結論與未來展望 41
參考文獻 42

[1]內政部統計處, 2013, 101年底人口結構分析, 內政部, Avaliable: http://www.moi.gov.tw/stat/news_content.aspx?sn=7121
[2]Michael Margolis , “Arduino Cookbook”, 2nd Edition, O'Reilly Media, 2011
[3]Massimo Banzi , “Getting Started with Arduino”, O'Reilly Media, 2008
[4] 尚茂智能科技股份有限公司, [Online], 2013, Avaliable: http://www.sunmoretek.com/index.php
[5]Arduino Ethernet Library Web Server, [Online], Feb 12, 2013, Avaliable: http://arduino.cc/en/Tutorial/WebServer
[6]Arduino Ethernet Library Web Client, [Online], April 23, 2012, Avaliable: http://arduino.cc/en/Tutorial/WebClient
[7]TIOBE Software BV. Jul.2013. TIOBE Programming Community Index for July 2013. TIOBE Software BV. Avaliable: http://www.tiobe.com/index.php/content/paperinfo/tpci/index.html
[8]Arduino Mega, [Online], April 26 2012, Avaliable: http://arduino.cc/en/Main/arduinoBoardMega
[9]Arduino Ethernet Shield, [Online], May 16, 2013, Avaliable: http://arduino.cc/en/reference/ethernet
[10]Arduino GSM Shield, [Online], Mar 11, 2013, Avaliable: http://arduino.cc/en/Main/ArduinoGSMShield
[11]David Beazley, Brian K. Jones , “Python Cookbook”, 3rd Edition, O'Reilly Media, 2013
[12]Google App Engine for Python, [Online], Jun 20, 2013, Avaliable: https://developers.google.com/appengine/docs/python/overview?hl=zh-tw
[13]Row and Query SQL Reference, [Online], May 8, 2013, Avaliable: https://developers.google.com/fusiontables/docs/v1/sql-reference
[14] SQL語法教學, [Online], 2013, Avaliable: www.1keydata.com/tw/sql/sql.html
[15]Google Maps API, [Online], Feb 1, 2013, Avaliable: https://developers.google.com/maps/
[16]Google APIs Console Help, [Online], Mar 13, 2013, Avaliable: https://developers.google.com/console/help/?hl=zh-TW
[17]Google Accounts Authentication and Authorization, [Online], Feb 16, 2013. Avaliable: https://developers.google.com/accounts/docs/OAuth2
[18]Use Application-owned Accounts, [Online], July 17, 2013, Avaliable: https://developers.google.com/drive/service-accounts#google_apis_console_project_service_accounts
[19]Support for Using MIT App Inventor, [Online], 2013, Avaliable: http://appinventor.mit.edu/explore/support.html