進階搜尋


下載電子全文  
系統識別號 U0026-1707201915355900
論文名稱(中文) 物聯網於施工階段管理資訊架構之建立
論文名稱(英文) Internet of Things Framework Establishment for Management Information during Building Construction
校院名稱 成功大學
系所名稱(中) 土木工程學系
系所名稱(英) Department of Civil Engineering
學年度 107
學期 2
出版年 108
研究生(中文) 葉文智
研究生(英文) Wen-Chih Yeh
學號 N66061414
學位類別 碩士
語文別 中文
論文頁數 99頁
口試委員 指導教授-張行道
口試委員-莊子壽
口試委員-范自強
口試委員-劉述舜
中文關鍵字 物聯網  施工階段  工程管理  資訊架構  工作單元 
英文關鍵字 Internet of Things (IoT)  construction phase  project management  information architecture  work package 
學科別分類
中文摘要 近年來隨著物聯網(Internet of Things, IoT)技術的興起,大量資料的收集與分析受到重視,有系統的資料收集、資料分析模型的建置也成了重要議題。
營建工程施工階段會產生許多工程管理資料如成本、進度、品質等,而其資料收集大都仰賴現場人員填寫表單,此項作業耗費人力,且資料量隨著工程進展日趨龐大,需要有效的資料收集系統。
本研究建立一套物聯網於施工階段管理資訊之架構,有系統的收集資料,並予以資料聯網、運算、大數據分析之雲端功能,便於工程管理人員使用。研究使用物聯網平台ThingWorx Platform為輔助軟體,導入實際施工資料,說明從物聯網基本架構最底層的感知層資料收集開始,經由網路層到達最後應用層的資料傳遞連結方法。
工程管理系統透過工作單元(work package, WP)為核心的資料庫,歸納與整理工程資料後,將資料庫與物聯網平台連結,建立可模擬感測器之人為輸入使用者介面(User Interface, UI),與視覺化便於瀏覽資訊之工程管理資料查詢UI。
將焊接的焊道組立品質資料,導入分析平台ThingWorx Analytics,建立焊道組立缺失預測模型後,比較七種演算法之模型優劣,選擇最優之類神經網路模型,並將模型導入ThingWorx Platform中,建立施作前分析該組合是否可行之焊道組立預測模式UI。
英文摘要 With the rise of the Internet of Things (IoT) technology in recent years, the collection and analysis of a large amount of data have been valued. Thus, the systematic data collection and data analysis have become important issues.
During the building construction process, there are many management forms such as cost, schedule, quality, etc., and most of the data collection relies on the on-site workers to fill out the forms. This kind of operations is labor-intensive, and the amount of data is increasing as the project progresses, so they require an effective data collection system.
This study established an IoT framework for the systematic data collection and thansfer for management information during the construction phase. It developed cloud functions for data networking, computing, and big data analysis. By using the IoT platform (ThingWorx Platform) as the auxiliary software and importing actual construction data, this study described the data transfer connection from the underlying IoT infrastructure to the top-level application layer.
The database of the project management system uses the work package (WP) as the core to summarize and organize the project data, link the database to the IoT platform, create a user interface (UI) that can simulate the sensors, and query the UI for visualizing the project management data for easy browsing.
The quality data of weld assembling are imported into the analysis platform (ThingWorx Analytics). After the defect prediction model was established, the advantages and disadvantages of the seven algorithms compared, the optimal neural network model selected, and the model imported into the ThingWorx Platform, a predicted model UI was established to help with the work arrangement before construction.
論文目次 摘要 i
Abstract ii
誌謝 vi
目錄 vii
表目錄 ix
圖目錄 x
第一章 緒論 1
1.1 研究動機與目的 1
1.2 研究方法與流程 2
1.3 研究範圍與限制 3
第二章 文獻回顧 4
2.1 物聯網概況 4
2.1.1 物聯網的發展 4
2.1.2 物聯網架構與平台 7
2.1.3 物聯網與大數據 9
2.2 營建業IoT概況 11
2.2.1 營建業IoT應用與感測器 11
2.2.2 營建業IoT與BIM應用 13
第三章 將資料導入物聯網平台 16
3.1 物聯網平台之一般連結方法 16
3.1.1 主要的連結類型與方法 17
3.1.2 REST API連結 18
3.1.3 協議適配器連結 24
3.1.4 Edge SDK連結 25
3.1.5 Edge Microserver連結 29
3.1.6 Industrial Connectivity連結 31
3.2 物聯網平台之資料庫連結方法 34
3.2.1 各種資料庫 35
3.2.2 資料庫(Microsoft SQL)連結 36
第四章 建立應用層 40
4.1 一般維護營運應用層建立 40
4.1.1 資料庫系統UI介面建立 40
4.1.2 具時間序列系統UI介面建立 43
4.2 大數據分析應用層建立 46
4.2.1 分析平台演算法 46
4.2.2 分析平台與物聯網平台連結、UI呈現 54
第五章 興建工程之物聯網系統 59
5.1 WP資料庫設計 59
5.1.1 現有資料預處理 59
5.1.2 資料庫系統建置 62
5.2 大數據分析應用 65
5.2.1 焊道組立分析模型建立 65
5.2.2 焊道組立模型分析結果 75
5.3 工程管理系統 79
5.3.1 基本架構 79
5.3.2 系統建立與UI呈現 81
第六章 結論與建議 89
6.1 結論 89
6.2 建議 91
參考文獻 93
參考文獻 英文文獻
1.Atkinson, R. D. (2014), ICT Innovation Policy in China: A Review. Information Technology and Innovation Foundation.
2.Bonaccorso, G. (2017), Machine Learning Algorithms, Packt, UK.
com/en/resources/guides/thingworx-rest-api-quickstart, accessed on 11/05/2018.
3.Dave, B., Buda, A., Nurminen, A., and Främling, K. (2018), “A framework for integrating BIM and IoT through open standards.” Journal of Automation in Construction, No. 95, pp. 35~45.
4.Dohr, A., Modre-Opsrian, R., Drobics, M., Hayn, D., and Schreier, G. (2010), “The Internet of Things for ambient assisted living.” Journal of Computer Society, 2010 Seventh International Conference on Information Technology: New Generations, April 12~14, USA, Las Vegas.
eb /resources/guides/choosing-connectivity-method, accessed on 11/02/2018.
5.IBM (2010), “What is big data?” https://developer.ibm.com/, accessed on 2/27/2019。
6.ITU (2005), The Internet Report 2005 executive summary-Internet of Things, International Telecommunication Union, Geneva.
7.Java Documentation (2014), “Ava Platform, Enterprise Edition: The Java EE Tutorial,” https://docs.oracle.com/javaee/7/tutorial/overview008.htm, accessed on 11/03/2018.
8.Jenkov (2014), “Web Service Message Formats,” http://tutorials.jenkov.com/web-services/message-formats.html, accessed on 11/02/2018.
9.Kanan, R., Elhassan, O., and Bensalem, R. (2018), “An IoT-based autonomous system for workers' safety in construction sites with real-time alarming, monitoring, and positioning strategies.” Journal of Automation in Construction, Vol. 88, pp.73~86.
10.Kochovski, P., and Stankovski, V. (2018), “Supporting smart construction with dependable edge computing infrastructures and applications.” Journal of Automation in Construction, Vol. 85, pp.182~192.
11.Lee, I., and Lee, K. (2015), “The Internet of Things (IoT): Applications,investments, and challenges for enterprises.” Journal of Business Horizons, Vol. 58, No. 4, pp. 431~440.
12.Li, C. Z., Xue, F., Li, X., Hong, J., and Shen, G. Q. (2018), “An Internet of Things-enabled BIM platform for on-site assembly services in prefabricated construction.” Journal of Automation in Construction, No. 89, pp. 146~161.
13.Lilis, G., Conus, G., & Kayal, M. (2015), “A distributed, event-driven building management platform on web technologies.” 2015 International Conference on Event-based Control, Communication, and Signal Processing (EBCCSP), 6/17, Poland.
m/en/resources/guides/operationalize-analytics-model, accessed on 2/18/2019.
14.NBIMS (2012), National building information modeling standard, Version 2.0, NBIMS, U.S.
orx.com/en/resources/guides/thingworx-industrial-conne ctivity-guide, accessed on 11/15/2018.
15.Park, J., and Cai, H. (2017), “WBS-based dynamic multi-dimensional BIM database for total construction as-built documentation.” Journal of Automation in Construction, No. 77, pp. 15~23.
16.Perera, C., Liu, C. H., and Jayawardena, S. (2015), “The Emerging Internet of Things Marketplace From an Industrial Perspective: A Survey.” Journal of Transactions on Emerging Topics in Computing, Vol. 3, No. 4, pp. 585~598.
17.Perera, C., Zaslavsky, A., Christen, P., and Georgakopoulos, D. (2013), “Context aware computing for the Internet of Things: A survey.” Journal of Communications Surveys & Tutorials, Vol. 16, No. 1, pp. 414~454.
18.PTC (2018a), “Choose a Connectivity Method,” https://developer.thingworx.com/
19.PTC (2018b), “Use REST API to Access ThingWorx,” http://developer.thingworx.
20.PTC (2018c), “Java SDK Reference Guide,” http://developer.thingworx.com/en/ /resources/guides/java-sdk-reference, accessed on 11/12/2018.
21.PTC (2018d), “The Edge Microserver proxies connections via AlwaysOn,” https://developer.thingworx.com/en/platform/connect, accessed on 11/14/2018.
22.PTC (2018e), “Connect Industrial Devices and Systems,” http://developer.thingw
23.PTC (2018f), “Display Values in a Time Series Chart,” http://developer.thingworx. com/en/resources/guides /time-series-chart-microguide, accessed on 2/03/2019.
24.PTC (2018g), “Thingworx Analytics Builder Help Document,” http://support.ptc. com/help/thingworx_hc/thingworx_analytics_7/index.html#page/thingworx_analytics_7%2Fanalytics-builder-overview.html%23, accessed on 2/05/2019.
25.PTC (2018h), “Build a Predictive Analytics Model,” http://developer.thingworx.c om/ en/resources/guides/analytics-builder-quickstart, accessed on 2/16/2019.
26.PTC (2018i), “Operationalize an Analytics Model,” http://developer.thingworx.co
27.Steyerberg, E. W., Vickers, A. J., Cook, N. R., Gerds, T., Gonen, M., Obuchowski, N., Pencina, M. J., and Kattan, M. (2010), “Assessing the Performance of Prediction Models A Framework for Traditional and Novel Measures.” Journal of  Epidemiology, Vol. 21, No. 1, pp.128~138.
28.Tang, S., Shelden, D. R., Eastman, C. M., Bozorgi, P. P., and Gao, X. (2019), “A review of building information modeling (BIM) and the internet of things (IoT) devices integration: Present status and future trends.” Journal of Automation in Construction, No. 101, pp. 127~139.
29.Tsai, C. W., Lai, C. F., Chiang, M. C., and Yang, L. T. (2014), “ Data Mining for Internet of Things: A Survey.” Journal of Communications Society, Vol. 16, No. 1, pp.77~97.
30.Wu,Y., Sheng, Q. Z., and Zeadally, S. (2013), “RFID: Opportunities and challenges.” Journal of Next-Generation Wireless Technologies, No. 7, pp. 105~129.
31.Zhang, L., Atkins, A. S., and Yu, H. (2012), “Knowledge Management Application of Internet of Things in Construction Waste Logistics with RFID Technology.” Journal of Computing Science and Communication Technologies, Vol. 5, No. 1, pp.760~767.
32.Zhong, R. Y., Peng, Y., Xue, F., Fang, J., Zou, W., Luo, H., Ng, S. T., Lu, W., Shen, G. Q. P., and Huang, G. Q. (2017), “Prefabricated construction enabled by the Internet-of-Things.” Journal of Automation in Construction, No. 76, pp. 59~70.

中文文獻
1.Microsoft SQL (2017),資料類型 (Transact-SQL),https://docs.microsoft.com/zh-tw/sql/t-sql/data-types/data-types-transact-sql/data-types/data-types-transactsql?vi ew=sql-server-2017,4/22/2019上網查得。
2.PostgreSQL (2017),資料庫常見問題,https://faq.postgresql.tw/,11/28/2018上網查得。
3.SAS (2013),羅吉斯迴歸,http://www.sasresource.com/faq161.html,2/06/2019上網查得。
4.尹相志(2007),SQL Server 2008 Data Mining資料採礦,悅知文化出版,台灣。
5.毛志兵(2017),「推進智慧工地建設 助力建築業的持續建科發展」,工程管理學報,第31卷,第5期,80-84頁。
6.吳韻吾、李景亮、田耀遠、溫明輝(2017),「具有物聯網之橋梁安全監測系統架構之研究」,技師期刊,第76期,39-44頁。
7.李航(2012),統計學習方法,清華大學,北京。
8.李嘉泰(2018),三元檢驗試劑資料之ROC曲面下體積分析,國立台北大學統計所碩士論文。
9.邢雨、梁慧、連俊英(2012),「物聯網技術在土木工程施工中的應用分析」,河南科技:上半月,第5期,57-58頁。
10.周立德、曾家偉(2017),「物聯網與大數據」,財團法人台灣網路資訊中心電子報,第184期。
11.於化龍(2017),類別不平衡學習:理論與算法,清華大學,北京。
12.林柏君(2017),「我國營造業之發展現況與趨勢」,經濟前瞻,第174期,43-48頁。
13.林婷(2010),「GS1 MobileCom 在零售業的加值應用」,GS1 TW夏季刊,10-11頁。
14.河村雅人(2015),圖解物聯網:感測器的架構與運用,碁峰出版社,台灣。
15.邱皓政(2019),量化研究與統計分析(六版):SPSS與R資料分析範例解析,五南圖書出版,台灣。
16.飛揚博客(2018),線性模型之一:線性迴歸的原理,https://www.cnblogs.com/aviator999/p/9966533.html,6/02/2019上網查得。
17.夏聃(2017),「國外物聯網產業發展概覽—物聯網產業化新進展」,中國信息安全,第8期,53-57頁。
18.張云濤、龔玲(2007),資料探勘原理與技術,五南圖書出版,台灣。
19.張立新、楊程(2014),「一種基於物聯網技術的智能路燈監控系統設計」,寧夏工程技術,第13卷,第3期,234-237頁。
20.張志勇、石貴平、廖文華、游國忠(2017),物聯網與穿戴式裝置概論與實務應用,碁峰出版社,台灣。
21.張志勇、陳正昌(2014),「物物相聯的龐大網路—物聯網」,科學月刊,第534期,19-27頁
22.張浩禎、朱彥煒(2013),「使用機器學習與特徵選擇預測明膠酶的受質切位」,TANET2013臺灣網際網路研討會論文集,10月23日,中興大學。
23.曹慶、劉博、趙鳴(2016),「基於物聯網的結構施工監測技術應用」,電子量測技術,第39卷,第4期,169-172頁。
24.莊均緯(2013),「營建工程應導入專案管理的思維」,技師報,第873期。
25.逍遙文工作室(2012),支持向量機器 (Support Vector Machine),https://cg2010studio.com/2012/05/20/%E6%94%AF%E6%8C%81%E5%90%91%E9%87%8F%E6%A9%9F%E5%99%A8-support-vector-machine/,2/07/2019上網查得。
26.陳建翰(2018),應用物聯網於冰水系統支能源管理,國立成功大學土木工程研究所碩士論文。
27.陳賢明、李萬利(2001),「e 世代營建管理系統」,中華技術,第52期,26-37頁。
28.童啟晟(2017),從雲端運算與物聯網之匯流,談臺灣產業發展策略思維,財團法人資訊工業策進會專家觀點。
29.廖肇昌、賴鈺蒨、楊子儁(2013),「以智慧化行動裝置開創走動式工程管理作業」,中華技術,第97期,114-121頁。
30.劉欣(2015),工業4.0:結合物聯網與大數據的第四次工業革命,四塊玉文創出版,台灣。
31.劉哲宇(2013),物聯網技術應用於資產管理,華梵大學資訊管理系碩士論文。
32.鄭夏翊、李慧萍、駱王成、胡成功(2013),「物聯網技術在項目質量安全管理中的應用」,土木建築工程信息技術,第5卷,第2期,101-106頁。
33.鄭福炯、王岱鑫、劉威成(2017),「智慧物聯網系統平台—以智慧家庭為例」,電腦稽核,第35期,36-49頁。
34.盧舜年(2001),企業e化的真正價值,資訊與電腦,第255期,62-65頁。
論文全文使用權限
  • 同意授權校內瀏覽/列印電子全文服務,於2019-07-22起公開。
  • 同意授權校外瀏覽/列印電子全文服務,於2019-07-22起公開。


  • 如您有疑問,請聯絡圖書館
    聯絡電話:(06)2757575#65773
    聯絡E-mail:etds@email.ncku.edu.tw