臺灣博碩士論文加值系統

本論文實作網路管理平台，系統能顯示所有路由器和交換器的狀況及位置。利用Cisco CDP技術追蹤連接的網路設備，取得設備名稱、型號、IP、MAC、port以及網路連線相對應的關係後，並且寫入資料庫，再以D3圖像技術繪製網路拓樸圖。本系統分為「監控功能」及「自動偵測動態網路設備功能」兩大部分，監控功能部分則利用Google Map API的技術，以Google Map顯示追蹤到的網路設備，本系統具有即時監控網路設備的功能，若網路設備有異常時，錯誤訊息會存入資料庫，並且在Google Map提示。在Google Map的畫面，可以設定所有已追蹤網路設備的位置，除了設定大樓位置、縮放位置，也可以將網路設備設置於大樓平面圖，以供網管人員方便查修異常網路設備。而自動偵測動態網路設備的功能，會將新偵測的網路設備，寫入資料庫中，D3的Collapsible Tree 技術依資料庫內容顯示動態網路拓樸圖。

In this thesis, we implement a network management system which can expose the locations and show the connection of those connected routes and switches. We apply Cisco CDP (Cisco Discovery Protocol) technology to track network devices which are currently connected, and get the device name, model, IP, MAC, port, link relation. We then use D3 imaging technology to derive the network topology. With the help of Google Map API technology, the monitor system tracks the targeted network device and shows it on Google Map. The proposed real-time network management system enables network managers to examine whether the network is acting normal or weird. When the network of devices acts weird, the real-time network management system will detect the network error. And the error message will be saved to the database and displays on Google Map. On Google Map, user can be setting device position.

摘 要 i
ABSTRACT ii
誌 謝 iii
目錄 iv
表目錄 vii
圖目錄 viii
第一章 緒 論 1
1.1 研究背景 1
1.2 研究動機 2
1.3 研究目的 2
1.4 論文章節編排 3
第二章 相關研究 4
2.1 OSI 4
2.2 乙太網路交換器 7
2.3 路由器 7
2.4 Telnet 9
2.5 CDP 協定 9
2.6 ICMP協議 10
2.7 GNS3 15
2.8 Json 15
2.9 Google Maps API 17
2.10 D3.js 17
第三章 系統設計 19
3.1 系統架構 19
3.2 CDP Trace設計 21
3.3 Manager Interface設計 22
3.4 Network Topology設計 24
第四章 系統實作 27
4.1 系統環境需求 27
4.2 資料庫設計 28
4.3 CDP Trace 實作 32
4.4 Manager Interface設計與實作 35
4.5 Network Topology實作 39
第五章 系統實測 44
5.1 系統實作介面說明 44
5.2 定時偵測系統參數差異結果 81
5.3 定時偵測系統測試數據 86
5.4 網路裝置異常偵測測試 88
5.3.1 網路裝置異常(重覆位置、單個異常) 88
5.3.2 網路裝置異常(重覆位置、多個異常) 92
5.3.3 網路裝置異常(不同位置、多個異常) 95
第六章 結論與未來展望 98
6.1 結論 98
6.2 未來展望 99
參考文獻 100

[1]M. GAST, "802.11 wireless networks: the definitive guide, " OReilly Media, Inc, 2005.
[2]Y. Bejerano, "Taking the skeletons out of the closets: a simple and efficient topology discovery scheme for large ethernet LANs," IEEE/ACM Transactions on Networking, vol. 17, no. 5, 2009, pp.1385-1398.
[3]S. R. Rodriguez, "Topology discovery using cisco discovery protocol," arXiv preprint arXiv, 2009.
[4]T. Hongsuda, G. Ramesh, J. Sugih, S. Scott and W. Walter, "Network topology generators: Degree-based vs. structural," ACM SIGCOMM Computer Communication Review, vol. 32, no. 4, 2002, pp. 147-159.
[5]D3.js, https://d3js.org/, June 2016
[6]ISO/IEC 7498-1, http://www.iso.org/iso/catalogue_detail.htm?csnumber=20269, June 2016
[7]ARP, https://msdn.microsoft.com/zh-tw/library/cc758357(v=ws.10).aspx, June 2016
[8]PHP Telnet , http://www.geckotribe.com/php-telnet/, June 2016
[9]C. S. Carr, "Network subsystem for time sharing hosts," RFC 15, 1969.
[10]J. Postel, J. Reynolds, "Telnet Protocol Specification," RFC 495, 1983.
[11]T. Dierks, C. Allen, "The TLS Protocol Version 1.0," RFC 2246, 1999
[12]J. Myers, "Simple Authentication and Security Layer (SASL)," RFC 4422, 1997
[13]Cisco, http://www.cisco.com/, June 2016
[14]K. Czajkowski, L. Foster, C.Kesselman, V. Sander, S. Tuecke, "SNAP: A protocol for negotiating service level agreements and coordinating resource management in distributed systems," Workshop on Job Scheduling Strategies for Parallel Processing. Springer Berlin Heidelberg, 2002, pp. 153-183.
[15]ICMP Parameter, http://www.iana.org/assignments/icmp-parameters/icmp-parameters.xhtml#icmp-parameters-codes-0, June 2016
[16]J. Postel, "Internet Control Message Protocol," RFC 792, 1981
[17]VMware, http://www.vmware.com/tw, June 2016
[18]Json, http://www.json.org/, June 2016
[19]瞭解 街景服務, https://www.google.com/maps/streetview/understand/, June 2016
[20]M. Morrison, "Head first javascript," OReilly Media, Inc, 2007.
[21]H. Jeffrey, S. K. Card and A. L. James, "Prefuse: a toolkit for interactive information visualization," Proceedings of the SIGCHI conference on Human factors in computing systems, 2005, pp. 421-430.
[22]Flare, http://flare.prefuse.org/, June 2016
[23]Protovis, http://mbostock.github.io/protovis/, June 2016
[24]B. Ryan and C. Ronan, "Head first jquery," OReilly Media, Inc, 2011.
[25]B. Bear and K. Yehuda 著，林信良譯，jQuery 實戰手冊(第二版)，台北市：碁峰資訊，2011。
[26]H. Ellis, S. Sartaj and A. F. Susan, "Fundamentals of Data Structures in C," Silicon Pr, 2008.
[27]F. B. Zhan, "Three fastest shortest path algorithms on real road networks: Data structures and procedures," Journal of geographic information and decision analysis, 1997, pp. 69-82.
[28]鄧文淵，挑戰 PHP5. MySQL 程式設計樂活學，台北市：碁峰資訊，2008。
[29]陳會安，(新觀念) 資料庫系統: 理論與設計實務，台北市：學貫行銷股份有限公司，2013。