臺灣博碩士論文加值系統

本研究目的在於，以無線監測配合資料庫伺服器，遠端連結的校園設施監控系統。針對學校的重要設施與場所整合控管，以達到安全性與效率的提升。本系統分為三大部分，ZigBee無線監控網路、RFID管理系統與伺服器資料庫。
以Zigbee為主架構，使用MCU的功能，設計具有溫度、濕度、日照、紫外線等，感測資料收集的感測節點，可根據使用者需求，擴充其它的感測器，再加上RFID管理系統。將資料用Zigbee的無線功能傳遞資料至伺服器，建立完整的資料庫，並且將資料上傳至網頁，發展出一套完整的校園設施監控系統。

The purpose of this study is to design a system for monitoring campus facilities. By utilizing wireless control of the school facilities and sites through this system, we would be able to achieve improved security and efficiency. This system is divided into three parts, ZigBee wireless monitoring network, RFID management systems and the server database.

Based on ZigBee architecture, the wireless sensor can detect changes in temperature, humidity, sunlight and ultraviolet radiation. Additional sensors may also be added to the system according to user needs. Moreover, RFID management system is connected through ZigBee wireless monitoring network. Our Zigbee wireless network is able to transfer data to the server, compile a complete database, and upload data to the website in order to develop a complete campus facility monitoring system.

摘要 I
Abstract II
誌謝 III
目錄 IV
圖目錄 VI
表目錄 VIII
第一章 緒論 1
1-1 前言 1
1-2 研究目的與動機 1
第二章 無線技術與資料庫介紹 3
2-1 常用無線技術介紹與應用於校園設施 3
2-1-1 藍牙無線通訊 3
2-1-2 紅外線通訊技術 3
2-1-3 Wi-Fi通訊技術 4
2-1-4 ZigBee通訊技術 4
2-1-5 無線通訊技術比較 5
2-2 ZigBee無線通訊網路 6
2-2-1 ZigBee介紹 6
2-2-2 ZigBee頻段 7
2-2-3 ZigBee網路組成 8
2-3 ZigBee晶片介紹 10
2-3-1 CC2430晶片介紹 11
2-4 資料庫伺服器介紹與應用於校園設施 13
2-4-1 常用資料庫介紹 13
2-4-2 SQL Server介紹 16
第三章 實驗方法與步驟 18
3-1 系統架構簡介 18
3-2 ZigBee無線網路拓墣架構 20
3-2-1 協調器(Coordinator) 設定 21
3-2-2 感測節點 24
3-2-3 門禁節點 37
3-3 伺服器端設置 39
3-3-1 VB人機介面 40
3-3-2 SQL Server 2008 40
3-3-3 VWD 網頁設計 41
3-3-4 IIS伺服器 42
第四章 結果與討論 43
4-1 ZigBee無線感測網路架 43
4-2 VB人機介面 46
4-3 SQL Server 47
4-4 IIS網頁架設 48
第五章 結論 50
5-1 結論 50

[1]Wan-Ki Park, Chang-Sic Choi, Jinsoo Han, Intark Han, Member , ”Design and Implementation of ZigBee based URC Applicable to Legacy Home Appliances,” proceeding of IEEE ISCE 2007,20-23 June 2007 Page(s):1 – 6.
[2] Yao-Ting Wu, ”ZigBee source route technology in home application,” proceeding of IEEE SUTC‘08, 11-13 June 2008 Page(s):302 – 305.
[3] Ying-Wen Bai,Chi-Huang Hung, ” Remote power On/Off control and current measurement for home electric outlets based on a low-power embedded board and ZigBee communication,”proceeding of IEEE ISCE, 14-16 April 2008 Page(s):1 – 4
[4] Kuk-Se Kim, Chanmo Park, Kyung-Sik Seo, Il-Yong Chung, Joon Lee,” ZigBee and The UPnP Expansion for Home Network Electrical Appliance Control on the Internet,” the IEEE 9thInternational Conference on Advanced Communication Technology, Volume 3, 12-14 Feb. 2007Page(s):1857 – 1860.
[5] Woo-Chool Park, Myung-Hyun Yoon,” The Implementation of Indoor Location System to Control ZigBee Home Network,” proceeding of SICE-ICASE 2006, Oct. 18-2 1, 2006 in Bexco, Busan,Korea.
[6] Zhou Yiming, Yang Xianglong, Guo Xishan, Zhou Mingang, Wang Liren,” A Design of Greenhouse Monitoring & Control System Based on ZigBee Wireless Sensor Network,” proceeding of WiCom 2007, 21-25 Sept. 2007 Page(s):2563 – 2567.
[7] “Texas Instruments,” http://www.ti.com/
[8] Il-Kyu Hwang,Jin-Wook Baek,” Wireless Access Monitoring and Control System based on Digital Door Lock,” IEEE on Consumer Electronics 2007, Volume 53, Issue 4, Nov. 2007 Page(s):1724 – 1730.
[9] Maoheng Sun, Qian Liu, Min Jiang,” An Implementation of Remote Lighting Control System Based on Zigbee Technology and Soc Solution,” proceeding of IEEE ICALIP 2008, 7-9 July 2008 Page(s):629 – 632.
[10] Meijuan Gao, Jin Xu, Jingwen Tian, Fan Zhang ,” ZigBee Wireless Mesh Networks for Remote Monitoring System of Pumping Unit,” proceeding of IEEE WCICA 2008, 25-27 June 2008 Page(s):5901 – 5905.
[11] Taehong Kim, Daeyoung Kim, Noseong Park, Seong-eun Yoo, ” Shortcut Tree Routing in ZigBee Networks,” proceeding of IEEE ISWPC ‘07, 5-7 Feb. 2007.
[12] Bonam Kim, Youngjoon Kim, InSung Lee, Ilsun You , “Design and Implementation of a Ubiquitous ECG Monitoring System Using SIP and the Zigbee Network,” Future generation communication and networking (fgcn 2007), Volume 2, 6-8 Dec. 2007 Page(s):599 – 604
[13] Jin-Shyan Lee, Yu-Wei Su, Chung-Chou Shen, “A Comparative Study of Wireless Protocols: Bluetooth, UWB, ZigBee, and Wi-Fi,” proceeding of IEEE IECON 2007, 5-8 Nov. 2007 Page(s):46 - 51.
[14] “ZigBee Alliance,“ http://www.zigbee.org/
[15] “IEEE,” http://ieeexplore.ieee.org/Xplore/guesthome.jsp
[16] “Bluetooth,” http://www.bluetooth.com/Bluetooth/