臺灣博碩士論文加值系統

現今智慧建築及能源節約議題越來越受重視，智慧照明設計亦是眾人關心的主題。傳統照明伴隨著照度不均、耗電問題，且需手動開啟、關閉照明電源，對於大型公共建築管理較為繁雜、長期用電量不容小覷，使得智慧照明逐漸受到眾人所重視。本文提出以低功耗藍牙結合平板燈，建立藍牙網狀網路環境，運用MQTT通訊協定雙向傳遞用戶端與伺服器端資訊，實現智慧型DALI平板燈燈具開關與調光控制，並以網頁技術設計與實作智慧照明控制與管理系統，分為單盞燈具獨立操作、多盞燈具管理及操作兩部分，達到智慧型照明控制與管理物聯網系統，未來可作為智慧建築、智慧照明應用發展參考。

Nowadays, Smart Building and Energy conservation issues are gradually being valued, and Smart Lighting design is also a topic that most people care about it. Traditional lighting has problems with uneven illumination and power consumption, and it is necessary to manually turn on and turn off the power switch. The management of large-scale public buildings is complicated and long-term electricity consumption cannot be ignored. Makes Smart Lighting gradually attract the attention of most people. This article proposes to combine Bluetooth Low Energy with LED Panel Lights to establish a Bluetooth Mesh Network environment. Use MQTT Protocol to Packet switching from the client and server in both directions to realize the on-off and dimming control of the intelligent DALI LED Panel Lights. Use Web Technology to design and implement a Smart Lighting control and management system, which is divided into two categories: single LED Panel Light independent operation, multiple LED Panel Lights management and operation. Achieve Smart Lighting control and management Internet of Things system. In the future, it can be used as a reference for the development of Smart Buildings and Smart Lighting applications.

摘要......i
Abstract......ii
誌謝......iii
目錄......iv
表目錄......vi
圖目錄......vii
第一章 緒論......1
1.1 研究背景與動機......1
1.2 研究目的......1
1.3 論文內容大綱......2
第二章 相關技術探討......3
2.1 藍牙網狀網路通訊技術......3
2.1.1 低功耗藍牙主要架構......3
2.1.2 藍牙網狀網路通訊技術......5
2.2 MQTT通訊技術......8
2.2.1 MQTT通訊技術主要架構......10
2.2.2 訊息傳輸服務品質......11
2.3 DALI 通訊技術......13
2.3.1 DALI封包架構......13
2.3.2 DALI定址型態......15
2.3.3 DALI指令說明......16
第三章 系統架構......19
3.1 系統架構......19
3.2 智慧型燈具控制架構......20
3.3 網頁技術架構......22
第四章 系統設計與實作......23
4.1 實驗場域......23
4.2 實驗設備......25
4.3 藍牙網狀網路環境建構......28
4.4 關聯式資料庫建構......33
4.5 智慧型燈具控制與物聯網設計......34
4.5.1 網頁設計......34
4.5.2 燈具控制功能......36
4.5.3 燈具群組控制功能......41
第五章 系統實測與效能分析......46
5.1 系統實測......46
5.1.1 燈具控制介面管理功能......46
5.1.2 燈具介面控制功能......49
5.2 系統效能分析......50
5.2.1 反應時間......50
5.2.2 不同訊息傳輸服務品質差異......53
第六章 結論與未來展望......55
參考文獻......56
Extended Abstract......58

[1]胡安（2021,06.01）。照明系統現在已經成為智慧城市最重要的組成部分。智慧照明領域有哪些重要的技術發展趨勢？取自https://www.edntaiwan.com/20210601nt61-4-trends-in-smart-lighting/
[2]M. -L. Wu, C. -M. Kung and Y. -N. Lin, "DALI-2 Intelligent Lighting Control System," 2020 International Symposium on Computer, Consumer and Control (IS3C), 2020, pp. 158-161.
[3]亭竹技術筆記（2018,11.30）。3.低功耗藍牙規範-架構。取自https://tingchuchi.github.io/2018/11/30/ble_ch3/
[4]YuChun Lin（2016,03.04）。[003]藍芽筆記。取自https://medium.com/@yuchunlin/003-%E8%97%8D%E8%8A%BD%E7%AD%86%E8%A8%98-975b4f44ccc8
[5]JOE（2014,10.13）。BLE 簡介：Bluetooth low energy。取自http://shyuanliang.blogspot.com/2014/10/v-behaviorurldefaultvmlo.html
[6]流云IoT（2020,07.18）。Bluetooth 技術系列。取自https://blog.csdn.net/m0_37621078/article/details/106995704
[7]James C. Lin, Konstantina S. Nikita（2011）。Wireless Mobile Communication andHealthcare: Second International ICST Conference, MobiHealth 2010, Ayia Napa, Cyprus, October 18 - 20, 2010. James C. Lin ; Revised Selected Papers。Spain：Springer。
[8]鄭福炯（2016）。物聯網技術理論與實作（附實驗學習手冊）。新北市：全華圖書。
[9]鄒奇洋，2018，“基於低功耗藍牙與九軸姿態感測室內定位系統之設計與實作”，國立虎尾科技大學電機工程系研究所碩士論文。
[10]Programming Guide: DIN-DALI-2（2018）. Programming Guide: DIN-DALI-2. Retrieved from https://nanopdf.com/download/programming-guide-din-dali-2_pdf
[11]Crestron DIN-DALI-2（2013）. DIN Rail 2 Channel DALI Interface ProgrammingGuide. Retrieved from https://www.crestron.com/getmedia/d66bfe27-dd33-44a8-a7b0-c6599a58ff4d/mg_pg_din-dali-2
[12]N. Tantitharanukul, K. Osathanunkul, K. Hantrakul, P. Pramokchon and P. Khoenkaw, "MQTT-Topics Management System for sharing of Open Data," 2017 International Conference on Digital Arts, Media and Technology (ICDAMT), 2017, pp. 62-65, doi: 10.1109/ICDAMT.2017.7904935.
[13]Bo Zhao, Xiaoman Huang, Guoping Wu, “OGC Web services based on Ajax engine,” Proceedings of SPIE - The International Society for Optical Engineering DOI:10.1117/12.712902.
[14]TP-link官方網站（2016）。TL-WDR4300 N750 無線雙頻Gigabit路由器。取自https://www.tp-link.com/tw/home-networking/wifi-router/tl-wdr4300/#overview
[15]ASUS官網（2020）。ZenFone 7智慧型手機。取自https://www.asus.com/tw/Mobile/Phones/ZenFone/ZenFone-7/
[16]蘋果官方網站（2021）。iPad Pro技術規格。取自https://www.apple.com/tw/ipad-pro/specs/
[17]NORDIC SEMICONDUCTOR（2017）. nRF52832 Product Specification v1.4. Retrieved from https://infocenter.nordicsemi.com/pdf/nRF52832_PS_v1.4.pdf
[18]WeiYuan（2016,12.09）。資料庫系統應用 - 關聯式資料庫。取自https://ithelp.ithome.com.tw/articles/10185512
[19]Bootstrap官網（2021）。Bootstrap 4.0。取自https://getbootstrap.com/docs/4.0/getting-started/introduction/
[20]程式前沿（2018）。jQuery Ajax 例項詳解 ($.ajax、$.post、$.get)。取自https://codertw.com/%E5%89%8D%E7%AB%AF%E9%96%8B%E7%99%BC/386168/
[21]Fooish程式技術（2017,04.29）。jQuery教學。取自https://www.fooish.com/jquery/
[22]N. Tantitharanukul, K. Osathanunkul, K. Hantrakul, P. Pramokchon and P. Khoenkaw, "MQTT-Topics Management System for sharing of Open Data," 2017 International Conference on Digital Arts, Media and Technology (ICDAMT), 2017, pp. 62-65, doi: 10.1109/ICDAMT.2017.7904935.
[23]Fooish程式技術（2017,09.10）。SQL教學。取自https://www.fooish.com/sql/
[24]W3Schools（2017）。Python MySQL。取自https://www.w3schools.com/python/python_mysql_getstarted.asp
[25]S. Lee, H. Kim, D. Hong and H. Ju, "Correlation analysis of MQTT loss and delay according to QoS level," The International Conference on Information Networking 2013 (ICOIN), 2013, pp. 714-717, doi: 10.1109/ICOIN.2013.6496715.
[26]J. Toldinas, B. Lozinskis, E. Baranauskas and A. Dobrovolskis, "MQTT Quality of Service versus Energy Consumption," 2019 23rd International Conference Electronics, 2019, pp. 1-4, doi: 10.1109/ELECTRONICS.2019.8765692.