隨著無線通信技術的快速發展，在我們身邊可以看到許多利用衛星定位或Wi-Fi fingerprint等技術，告訴使用者目前位置，使生活變得更便利的例子。導航系統和智慧型手機發明出來後，幾乎能馬上瀏覽周邊地圖。Google map利用使用者提供的位置資訊來獲知道路是否雍塞，替使用者找出最佳路徑及所需時間。利用位置資訊可以發展許多不同的應用，也因此有了所謂的適地性服務(Location Based Service)。
我們提出一個圖書館無線導覽系統，利用在圖書館每層樓放置Linux嵌入系統(Controller)連接多個藍芽節點，使用藍芽無線技術，了解使用者目前的位置資訊，並利用此位置資訊來告知使用者所在區域為圖書館的哪個區域，並提供此區域的導覽檔案(圖片、文字、影音、影像)，讓使用者能夠有方便且深入的無線導覽服務。
本論文建立內容管理伺服器端，開發內容管理系統，實現接收、處理、傳送伺服器三個角色，並在伺服器端架設網頁應用程式提供圖形化介面，讓管理員操作圖書館無線導覽管理系統。網頁應用程式結合OASIS規範中的MQTT協定與Controller端合作，實現伺服器端初始化設定功能、樓層管理功能、監測節點功能、統計資訊功能。達到Controller端自動化設定、下載伺服器端導覽檔案、並收集藍芽節點資料回饋給管理員，使圖書館能夠藉由偵測資訊了解藍芽節點是否故障，及利用統計資訊改善圖書館配置。

As the fast growth of Wireless Communication Technology, It’s easy to find many implementations of telling user their location via GPS or Wi-Fi fingerprint technology in our life. For example, Google map take the advantages of user’s locations to notice them if there is traffic congestion on their route. Thus Google will help them to find the best route. We could develop numerous applications with utilizing user’s location to provide them useful service. And this is so-called Location Based Service.
We proposed a library wireless tour guide system to provide the user library tour service. With placing at least one Linux-based embedded system(Controller) in every floor and numbers of Bluetooth USB dongles will be connected by controller via USB HUB. In this system we choose Bluetooth USB dongles as tour node. Here’s the situation as follow, when a user is in the coverage of a tour node via Bluetooth technology, the APP of library tour will show which area the user is in. And will provide tour file of this area (e.g., Photo, introduction, audio, video…). The thesis focus on how to manage Controllers of every floor and so many nodes. By building the content management server, the thesis implement three features of server: receiving, processing, sending. Developing the web application as geographic user interface(GUI) on server-side, so that admin could operate the system easily. The web application using the MQTT protocol which is standardized by OASIS to communicate with Controller. By the design of MQTT topic and messages, the thesis implemented the initializing feature, floor management feature, monitor Bluetooth nodes feature, and statistics feature. With monitor feature, the admin will know the status of nodes (no response or alive), and statistics feature will let the admin know the hits of each file type. By that they will know how to improve user experience.

誌謝 i
中文摘要 ii
ABSTRACT iii
目錄 iv
圖目錄 vii
表目錄 x
第1章 緒論 1
1.1 研究動機 1
1.2 系統目標 3
1.3 系統架構 4
第2章 背景與相關研究 7
2.1 選擇通訊協定 7
2.2 The Shell Script 8
2.2.2 執行權限 9
2.2.3 Shell Script自動執行 10
第3章 MQTT 通訊協定 11
3.1 Overview of MQTT 11
3.2 MQTT 通訊架構 11
3.3 MQTT 訊息格式 13
3.4 MQTT Quality of Service and Flows 15
3.5 MQTT Topic 18
第4章 伺服器端實現設計與架設 20
4.1 伺服器端系統架構 20
4.2 架設平台 22
4.3 HTTP Server 22
4.4 Database Scheme 23
4.4.1 MySQL資料欄位設計 23
4.4.2 安裝測試與流程 26
4.5 PHP 27
4.6 MQTT client for Browsers 28
第5章 LINUX嵌入系統實現設計與架設 30
5.1 需求 30
5.1.1 硬體需求 30
5.1.2 軟體需求 31
5.2 實現MQTT 32
5.2.1 MQTT Broker選擇 32
5.2.2 實現Mosquitto於Controller端 33
5.3 Utilities Usage 33
5.3.1 Mosquitto Utilities 33
5.3.2 cURL 34
5.3.3 GNU Wget 36
5.3.4 Bluetooth Utilities 37

5.3.5 udev管理工具 39
5.4 Working with Content Management Server 41
5.4.1 Controller端系統設計 41
5.4.2 Shell Script流程 42
第6章 系統實現介面與流程 46
6.1 圖書館導覽系統管理登入 47
6.2 初始化設定功能 48
6.2.1 初始化設定功能流程 48
6.2.2 初始化設定功能介面 50
6.3 樓層管理功能 52
6.3.1 樓層管理功能流程 52
6.3.2 樓層管理功能介面 54
6.4 監測節點功能 58
6.4.1 監測節點功能流程 58
6.4.2 監測節點功能介面 59
6.5 統計資訊功能 60
6.5.1 統計資訊功能流程 60
6.5.2 統計資訊功能介面 61
第7章 結論與未來展望 62
7.1 結論 62
7.2 未來展望 62
參考文獻 63

[1] 適地性服務(LBS)
https://zh.wikipedia.org/wiki/地理位置服务
[2] Top IT Trends & Predictions in 2016
http://www.gartner.com/technology/topics/trends.jsp
[3] Arvin Kumar and Suchi Johari, Push Notification as a Business Enhancement Technique for E-commerce, 2015 Third International Conference on Image Information Processing, pp. 450-454。
[4] MQTT official site
http://mqtt.org
[5] MQTT V3.1.1 Protocol Specification
http://docs.oasis-open.org/mqtt/mqtt/v3.1.1/errata01/os/mqtt-v3.1.1-errata01-os-complete.pdf
[6] A simple php class to connect/publish/subscribe to an MQTT broker
https://github.com/bluerhinos/phpMQTT
[7] Project SAM library
https://github.com/tokudu/PhpMQTTClient
[8] Introduction of Raspberry Pi
https://www.raspberrypi.org
[9] Introduction of BeagleBone Black
https://beagleboard.org/black
[10] Install and test Mosquitto
http://iotchef.cc/posts/2015-09-16-install-and-test-mosquitto.html
[11] Mosquitto.org
http://Mosquitto.org
[12] cURL options
https://zh.scribd.com/document/317349275/Curl
[13] Wget options
https://www.gnu.org/software/wget/
[14] Bluetooth model
http://www.embeddedlinux.org.cn/EssentialLinuxDeviceDrivers/final/ch16lev1sec1.html
[15] Introduction of Udev
https://wiki.archlinux.org/index.php/Udev