系統識別號 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頁。
13.林婷(2010),「GS1 MobileCom 在零售業的加值應用」,GS1 TW夏季刊,10-11頁。
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上網查得。
27.陳賢明、李萬利(2001),「e 世代營建管理系統」,中華技術,第52期,26-37頁。
  • 同意授權校內瀏覽/列印電子全文服務,於2019-07-22起公開。
  • 同意授權校外瀏覽/列印電子全文服務,於2019-07-22起公開。

  • 如您有疑問,請聯絡圖書館