隨著物聯網（Internet of Things）時代來臨，人們希望能夠達成“物物聯網”，而其中如何解決傳輸距離以及耗電量的問題是至關重要的。因此，許多長距離、低功耗的無線通訊協定相繼被提出，當中廣受討論的不外乎就是LoRa無線傳輸技術。而LoRaWAN目前所提出的相關規範中，許多細節上並未完整規範，導致各家廠商所製造之相關產品上設計有所不一，造成管理與使用上之瓶頸。其中包括LoRaWAN中閘道器在最初的設計上，並沒有考慮資料傳送路徑的問題，也就是說，當閘道器收到LoRaWAN中的任何認可之資料時，會直接全部轉送至同一MQTT伺服器中之同一特定主題，如此一來，容易造成節點資料之混亂與使用上之不便。另外，當一節點欲加入至該LoRaWAN網域時，必須手動分別於各閘道器中置入與該節點相對應之金鑰，其所傳送之資料方能被認可及解密。
在此篇論文中，為了解決單個或多個LoRaWAN閘道器之金鑰管理問題與收集資料後之傳遞路徑問題，我們設計並實作了針對LoRaWAN無線通訊協議之網路管理系統，當中包括資料前置處理與分類，以及實作金鑰管理，並提供使用者介面以方便管理。實驗結果顯示，使用者透過我們所設計之管理系統，可快速及方便地佈署LoRaWAN閘道器與裝置節點，並且能夠更容易地擷取裝置節點之資料，突破了在LoRaWAN中管理與使用上之瓶頸。

As the Internet of Things (IoT) try to make almost everything in our lives able to connect to the Internet, how to solve the problems of transmission distance and power consumption is essential. Therefore, many long-range and low-power wireless protocols have been proposed. Among these protocols, LoRa wireless transmission technology is in the limelight and has been widely discussed. However, in the latest specification of LoRaWAN protocol, there are still many details are not fully standardized, resulting in different designs of products and the bottleneck of managements in LoRaWAN. For example, the data transmission path was not taken into account in the original design of LoRaWAN gateways, that is, when gateways receive recognized data, they will be transferred directly to the same specific MQTT topic. As a result, it is likely to cause confusion and inconvenience of data utilization. In addition, when a node wants to join the LoRaWAN, it is necessary to manually place the keys corresponding to the node in each gateway, so the information transmitted can be recognized and decrypted.
In this thesis, we have designed and implemented a network management system for LoRaWAN wireless communication protocol in order to solve the problems of key management of single or multiple LoRaWAN gateways and the data transmission path after collecting data. We have implemented data preprocessing and classification, key management, and an easy-to-use user interface in the system. The results show that users can quickly and easily deploy LoRaWAN gateways and device nodes through the management system we designed, and can more easily retrieve the data of device nodes, breaking through the bottleneck of managements in LoRaWAN.

Contents
Abstract I
中文摘要 II
Contents III
List of Figures V
List of Tables VII
Chapter 1 Introduction 1
Chapter 2 Related Works 4
2.1 LoRa and LoRaWAN 4
2.1.1 LoRaWAN Architecture 6
2.1.2 LoRaWAN Security 8
2.2 LoRaWAN Network Management 10
2.2.1 LoRaWAN Key Management 10
2.2.2 LoRaWAN Data Management 11
2.3 Related Works of LoRaWAN Network Management System 13
2.3.1 GIoT 14
2.3.2 LORIOT 16
2.3.3 LoRa Server Project 18
Chapter 3 System Design and Implementation 21
3.1 System Overview 21
3.1.1 API Server 22
3.1.2 Application Server 26
3.1.3 Flow of User Request 27
3.2 System Implementation 30
3.2.1 Tools for Developing the Web Service 30
3.2.2 The Web Service 31
Chapter 4 Experiment and Evaluation 34
4.1 Experiment Environment 34
4.2 Experiment Result 37
Chapter 5 Conclusion and Future Works 44
References 46

[1] Ericsson, “Ericsson mobility report,” White paper, 2015.
[2] LoRa Alliance, “LoRaWAN specification,” Jul. 2016, Available: http://lora-alliance.org
[3] “Sigfox,” [Online]. Available: http://www.sigfox.com.
[4] Weightless open standard, [Online]. Available: http://www.weightless.org.
[5] Semtech, “LoRa Packet Forwarder,” [Online]. Available: https://github.com/Lora-net/packet_forwarder
[6] “MQTT,” [Online]. Available: http://mqtt.org
[7] Gemtek, “GIoT,” [Online]. Available: www.giotnetwork.com
[8] “LORIOT,” [Online]. Available: www.loriot.io
[9] Broccar, “LoRa Server,” [Online]. Available: http://docs.loraserver.io/loraserver/
[10] “MQTT 3.1.1 specification”. OASIS. December 10, 2015. Retrieved April 25, 2017.
[11] Network Working Group of the IETF, January 2006, RFC 4251, The Secure Shell (SSH) Protocol Architecture.
[12] “More deeply, the framework exists to separate the representation of information from user interaction.” The DCI Architecture: A New Vision of Object-Oriented Programming – Trygve Reenskaug and James Coplien – March 20, 2009.
[13] “Puma,” [Online]. Available: https://github.com/puma/puma
[14] “Rack,” [Online]. Available: http://rack.github.io
[15] “Sinatra,” [Online]. Available: http://www.sinatrarb.com
[16] “SQLite,” [Online]. Available: https://www.sqlite.org
[17] “PostgreSQL,” [Online]. Available: https://www.postgresql.org
[18] “LinkIt ONE,” [Online]. Available: https://labs.mediatek.com/zh-tw/platform/linkit-one
[19] Qian Dong and Waltenegus Dargie, “Evaluation of the Reliability of RSSI for Indoor Localization”, 2012 International Conference on Wireless Communications in Underground and Confined Areas, 2012.
[20] Martin Bor, John Vidler, Utz Roedig, “LoRa for the Internet of Things”, Proceedings of the 2016 International Conference on Embedded Wireless Systems and Networks, February 15-17, 2016, Graz, Austria.
[21] K. Mikhaylov, J. Petäjäjärvi, T. Haenninen. “Analysis of Capacity and Scalability of the LoRa Low Power Wide Area Network Technology”, European Wireless 2016 22th European Wireless Conference Proceedings of. VDE VERLAG GmbH, 2016.
[22] Sarra Naoui, Mohamed Elhoucine Elhdhili, Leila Azouz Saidane. “Enhancing the security of the IoT LoraWAN architecture”, 2016 International Conference on Performance Evaluation and Modeling in Wired and Wireless Networks (PEMWN), 2016.
[23] Semtech Ltd, “LoRaWAN Network Server Demonstration: Gateway to Server Interface Definition,” 2015.
[24] Semtech Ltd, “LoRaWAN Network Server Demonstration: Inter-Server interface definition,” 2015.
[25] ECMA International, The JSON Data Interchange Format, 2013.
[26] Tony Rosati, “LoRaWAN Security Overview,” 2017, [Online]. Available: http://www.trustpointinnovation.com/blog/2017/01/17/lorawan-security-overview/