利用雲端技術進行營建行動裝置查驗及大數據統計之研究

USING CLOUD TECHNOLOGY FOR CONSTRUCTION MOBILE DEVICE INSPECTION AND BIG DATA STATISTICS

10.6652/JoCICHE.202210_34(6).0003

陳懿佐(Yih-Tzoo Chen)；鍾增煌(Tseng-Huang Chung)

行動裝置 ； 雲端資料庫 ； 施工查驗 ； 電子表單 ； 大數據 ； mobile device ； app ； cloud-based database ； construction inspection ； electronic forms ； big data

中國土木水利工程學刊

34卷6期（2022 / 10 / 01）

479 - 488

英文

本研究以鋼構廠二級品管工作為例，採無須撰寫程式碼方式開發行動裝置APP及建資料庫大數據分析系統架構，達成以行動裝置電子表單進行現場查驗，並將定性、定量化成果儲存於雲端關聯式資料庫。除可隨時檢視查驗成果及匯出至業主制式格式的表單外，亦可連接雲端資料庫、製作大數據分析，以行動裝置檢視統計報表，掌握最新的工地進度及品質、職安衛等管理資訊。期能提供營建業以低成本、低資訊技術門檻方式，將施工查驗、職安衛檢查、材料試驗等成果以電子表單方式填報，並儲存於雲端資料庫以提供大數據分析之e化可行實務解決方案。

This study takes the secondary quality assurance work of a steel structure factory as an example, develops a mobile device APP and builds a database big data analysis system framework without writing code, so as to achieve on-site inspection with mobile device electronic form, and the qualitative and quantitative data analysis results are stored in a cloud-based relational database. In addition to viewing the inspection results at any time and exporting them to the owner's standard form format, it can also connect to the cloud database, create big data analysis, view statistical reports with mobile devices, and visualize the latest construction site progress and quality, occupational safety and health and other management information. It is expected to provide the construction industry with a low-cost and low-information technology threshold method to fill in the results of construction inspection, occupational safety and health inspection, material testing and other results in electronic forms, and store them in the cloud database to provide practical e-based big data analysis feasible solution.

1. 什麼是 Power BI 服務？https://docs.microsoft.com/zh-tw/powerbi/fundamentals/power-bi-service-overview
2. KKNEWS，2017-08-04 由 e 建築發表于科技，https://kknews.cc/tech/nplbr42.html。
3. 為什麼雲端服務是企業數位化的必經之路？完整介紹讓您更瞭解雲端優勢。https://www.sysage.com.tw/News/TechnicalDetail/711
4. APPSheet Cusomer support，https://www.APPsheet.com/Support
5. (2019).19 APPs for Contractors to Consider Using in 2019.New Orleans CityBusiness
6. Chao, L.(2013).Cloud Database Development and Management.Auerbach Publications.
7. Davis, F. D.(1985).Sloan School of Management, MIT.
8. Di Pietro, Gianfranco,Rinnone, Fabio,Parisi, Claudia M.,Caprì, Salvatore,Bianco, Giovanni(2019).STATUS APP: A mobile data collection tool for buildings adjacent to tunneling works.Buildings,10(1),7.
9. Lin, Y. C.(2013).Construction network-based interface management system.Automation in Construction,30,117-241.
10. Liu, Tong,Mathrani, Anuradha,Mbachu, Jasper(2019).Benefits and Barriers in Uptake of Mobile APPs in New Zealand Construction Industry.Facilities,37(5/6),254-265.
11. Liu, Tong,Mbachu, Jasper,Mathrani, Anuradha,Jones, Beatrix,McDonald, Barry(2017).The Perceived Benefits of APPs by Construction Professionals in New Zealand.Buildings,7(4),111.
12. Mascort-Albea, Emilio J.,Canivell, Jacinto,Jaramillo-Morilla, Antonio,Romero-Hernández, Rocío,Ruiz-Jaramillo, Jonathan,Soriano-Cuesta, Cristina(2019).Action Protocols for Seismic Evaluation of Structures and Damage Restoration of Residential Buildings in Andalusia (Spain): ‘IT-Sismo’ APP.Buildings,9(5),104.
13. Rolfsen, Christian Nordahl,Lassen, Ann Karina(2020).On-Site inspections: The shift from forms to digital capture.Organization, technology & management in construction,12(1),2064-2071.
14. Tsai, Meng-Han,Chan, Hao-Yung,Liu, Liang-Yuan(2020).Conversation-Based School Building Inspection Support System.Applied sciences,10(11),3739.
15. Veseláa, Lucie,Radiměřskýa, Miroslav(2014).The development of electronic document exchange.Procedia Economics and Finance,12,743-751.
16. 吳榮煌,李萬利,賴建中,賴鈺蒨(2009)。整合智慧工程管理建構新一代工程專案決策中樞系統。中華技術專題報導，81，246-255。
17. 李怡姍(2020)。國立高雄科技大學土木工程系土木工程與防災科技碩士在職專班。
18. 林昭嘉(2012)。國立台北科技大學土木工程系土木與防災碩士班。
19. 孫弘錡(2019)。國立雲林科技大學營建工程系營建與物業管理組。
20. 張凱筌(2014)。國立台灣科技大學營建工程系。
21. 葉永鑫(2020)。國立金門大學土木與工程管理學系碩士班。
22. 廖肇昌,賴鈺蒨,楊子儁(2013)。以智慧化行動裝置開創走動式工程管理作業。中華技術專題報導，97，114-121。
23. 蔡偉雅(2017)。國立雲林科技大學營建工程系。
24. 謝邦昌,鄭宇庭,宋龍華,陳妙華(2019).大數據分析 Excel Power BI 全方位應用.
25. 謝宗安(2009)。國立台灣科技大學建築系。