Construction Research Congress 2020
A Relational Database Schema of Construction Costs Tracking from BIM Model to Final Costs
Publication: Construction Research Congress 2020: Project Management and Controls, Materials, and Contracts
ABSTRACT
Advanced conceptual cost estimation is based on historical project data. Cost estimators are still experiencing the difficulty of obtaining supportive information because most of the raw data is stored separately and cannot be easily traced. Previously proposed building information modeling (BIM)-based database did not produce cross-project historical data and also required extra effort in the design phase. To address the limitations, this paper considers building an independent relational database (RDB) as a data tracking tool. A preliminary RDB schema for conceptual estimating was developed in this paper. This RDB extracted and fused data from BIM models, bill of quantities (BoQs), and payment records using open tool MySQL. Simulated cost data of VDC Research Center was used as a case study. Three queries were coded and tested as validation. It can be concluded that BIM and cross-project RDB integrated data tracking method is helpful in conceptual cost estimating. It fills the current gap between the project-level BIM implementation and the enterprise-level database evolution by interoperating data of domain-oriented specifications.
Get full access to this article
View all available purchase options and get full access to this chapter.
REFERENCES
BuildingSMART, International Alliance for Interoperability Industry Foundation Classes IFC2x Edition 3, available at: https://standards.buildingsmart.org/IFC/RELEASE/IFC2x3/FINAL/HTML/
KPMG, 2016. Building a Technology Advantage, Global Construction Survey 2016, Armstrong, Gilge.
Oracle, 2018. The State of Construction Project Management Technology. Available at: https://www.oracle.com/a/ocom/docs/dc/ne/stateofconstprjmanagementtechnology.pdf?elqTrackId=9bfa97b8386b45e8afac8447f3e5aed7elqaid=73878elqat=2.
EL-OMARI, S. & MOSELHI, O. 2011. Integrating automated data acquisition technologies for progress reporting of construction projects. Automation in Construction, 20,699-705.
GARDNER, B. J., GRANSBERG, D. D. & JEONG, H. D. 2016. Reducing data-collection efforts for conceptual cost estimating at a highway agency. Journal of Construction Engineering and Management,142, 04016057.
HOVNANIAN, G., KROLL, K. & SJöDIN, E. 2019. How Analytics can Drive Smarter Engineering and Construction Decisions. McKinsey & Company Capital Projects & Infrastructure.
KUO, W.-L., LEE, H.-X. & HSIEH, S.-H. 2019. Designing a Database Schema for Supporting Visual Management of Variable Parameters in BIM Models. Computing in Civil Engineering 2019: Visualization, Information Modeling, and Simulation. American Society of Civil Engineers Reston, VA.
LEE, G., JEONG, J., WON, J., CHO, C., YOU, S.-J., HAM, S. & KANG, H. 2012. Query performance of the IFC model server using an object-relational database approach and a traditional relational database approach. Journal of Computing in Civil Engineering, 28, 210-222.
LEE, Y.-C., EASTMAN, C. M. & SOLIHIN, W. 2018. Logic for ensuring the data exchange integrity of building information models. Automation in Construction, 85,249-262.
MARTíNEZ-ROJAS, M., MARíN, N., MOLINA, C. & VILA, M. Cost analysis in construction projects using fuzzy OLAP cubes. 2015 IEEE International Conference on Fuzzy Systems (FUZZ-IEEE), 2015. IEEE, 1-8.
MARTíNEZ-ROJAS, M., MARíN, N., MOLINA, C. & VILA, M. A. An intelligent system for cost data handling in construction projects. 2016 IEEE International Conference on Fuzzy Systems (FUZZ-IEEE), 2016. IEEE, 359-366.
PARK, J. & CAI, H. 2017. WBS-based dynamic multi-dimensional BIM database for total construction as-built documentation. Automation in Construction, 77,15-23.
PARK, J., CAI, H., DUNSTON, P. S. & GHASEMKHANI, H. 2017. Database-supported and web-based visualization for daily 4D BIM. Journal of Construction Engineering and Management,143,04017078.
SOLIHIN, W., EASTMAN, C., LEE, Y.-C. & YANG, D.-H. 2017. A simplified relational database schema for transformation of BIM data into a query-efficient and spatially enabled database. Automation in Construction,84,367-383.
XU, Z., HUANG, T., LI, B., LI, H. & LI, Q. 2018. Developing an IFC-Based Database for Construction Quality Evaluation. Advances in Civil Engineering, 2018.
Information & Authors
Information
Published In
Construction Research Congress 2020: Project Management and Controls, Materials, and Contracts
Pages: 784 - 792
Editors: David Grau, Ph.D., Arizona State University, Pingbo Tang, Ph.D., Arizona State University, and Mounir El Asmar, Ph.D., Arizona State University
ISBN (Online): 978-0-7844-8288-9
Copyright
© 2020 American Society of Civil Engineers.
History
Published online: Nov 9, 2020
Published in print: Nov 9, 2020
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.