Automated mapping from an IFC data model to a relational database model

GUO Hongling; ZHOU Ying; YE Xiaotian; LUO Zhubang; XUE Fan

doi:10.16511/j.cnki.qhdxxb.2020.22.030

PDF(8532 KB)

Journal of Tsinghua University(Science and Technology) ›› 2021, Vol. 61 ›› Issue (2) : 152-160. DOI: 10.16511/j.cnki.qhdxxb.2020.22.030

CONSTRUCTION MANAGEMENT

Automated mapping from an IFC data model to a relational database model

{{article.zuoZhe_EN}}

Author information +

History +

Abstract

Building information modelling (BIM) is important in the construction industry, while industry foundation classes (IFC), an international data exchange model, are widely used for BIM research and applications. However, the limitations of IFC complicate the use of IFC as the main data format for redevelopment projects. Therefore, an automatic mapping method is developed to map an IFC data model to a relational database model. The IFC data model mapping has mapping rules for entity, type, function, rule, property set, and quantity set for the data analysis, data mapping, and information retrieval. Two tests are conducted to evaluate the validity of this method. The results show that the relational database provides better information integrity and data management than the IFC files with the mapping improving the integrity and efficiency of the BIM data management and also promoting the use of intelligent construction methods as well as the development of informatization in the construction industry.

Key words

building information modelling (BIM) / industry foundation classes (IFC) / relational database / automatic mapping

Cite this article

EndNote

Ris (Procite)

Bibtex

Download Citations

GUO Hongling, ZHOU Ying, YE Xiaotian, LUO Zhubang, XUE Fan. Automated mapping from an IFC data model to a relational database model[J]. Journal of Tsinghua University(Science and Technology). 2021, 61(2): 152-160 https://doi.org/10.16511/j.cnki.qhdxxb.2020.22.030

References

[1] 成于思, 李启明, 成虎. IFC数据在关系数据库上的实现研究与应用[J]. 计算机应用与软件, 2014, 31(11):34-44.CHENG Y S, LI Q M, CHENG H. On implementing IFC data in rational database and its application[J]. Computer Applications and Software, 2014, 31(11):34-44. (in Chinese)
[2] 赖华辉, 邓雪原, 刘西拉. 基于IFC标准的BIM数据共享与交换[J]. 土木工程学报, 2018, 51(4):121-128.LAI H H, DENG X Y, LIU X L. IFC-based BIM data sharing and exchange[J]. China Civil Engineering Journal, 2018, 51(4):121-128. (in Chinese)
[3] 何关培. 实现BIM价值的三大支柱:IFC/IDM/IFD[J]. 土木建筑工程信息技术, 2011, 3(1):108-116.HE G P. Three pillars to realize the value of BIM:IFC/IDM/IFD[J]. Journal of Information Technology in Civil Engineering and Architecture, 2011, 3(1):108-116. (in Chinese)
[4] BuildingSMART International. Industry foundation classes (IFC):An introduction[S/OL].[2020-06-30]. https://technical.buildingsmart.org/standards/ifc/.
[5] SUN J, LIU Y S, GAO G, et al. IFCCompressor:A content-based compression algorithm for optimizing Industry Foundation Classes files[J]. Automation in Construction, 2015, 50:1-15.
[6] 周颖, 郭红领, 罗柱邦. IFC数据到关系型数据库的自动映射方法研究[C]//第4届全国BIM学术会议论文集. 合肥, 2018:311-317.ZHOU Y, GUO H L, LUO Z B. Research on automatic mapping method from IFC data to relational database[C]//Proceedings of the 4th National BIM Academic Conference. Hefei, 2018:311-317. (in Chinese)
[7] 张洋. 基于BIM的建筑工程信息集成与管理研究[D]. 北京:清华大学, 2009.ZHANG Y. Research on BIM-based building information integration and management[D]. Beijing:Tsinghua University, 2009. (in Chinese)
[8] 张巨俭. 数据库基础案例教程与实验指导[M]. 北京:机械工业出版社, 2011.ZHANG J J. Basic database case tutorial and experimental guidance[M]. Beijing:China Machinery Industry Press, 2011. (in Chinese)
[9] 李小林, 易红, 吴锡英. EXPRESS数据模式在关系数据库上的实现[J]. 计算机集成制造系统, 1999(1):64-68.LI X L, YI H, WU X Y. Implementation of EXPRESS data mode on relational database[J]. Computer Integrated Manufacturing System, 1999(1):64-68. (in Chinese)
[10] SOLIHIN W, EASTMAN C, LEE Y C, et al. A simplified relational database schema for transformation of BIM data into a query-efficient and spatially enabled database[J]. Automation in Construction, 2017, 84:367-383.
[11] FARAJ I, ALSHAWI M, AOUAD G, et al. An industry foundation classes web-based collaborative construction computer environment:WISPER[J]. Automation in Construction, 2000, 10(1):79-99.
[12] TANYER A M, AOUAD G. Moving beyond the fourth dimension with an IFC-based single project database[J]. Automation in Construction, 2005, 14(1):15-32.
[13] LEE G, JEONG J, WON J, et al. Query performance of the IFC model server using an object-relational database approach and a traditional relational database approach[J]. Journal of Computing in Civil Engineering, 2014, 28(2):210-222.
[14] 张迪, 刘华, 李航. 基于对象关系型数据库的IFC存储模型[J]. 城市建筑, 2018(2):38-40.ZHANG D, LIU H, LI H. On database IFC storage model based on the object-relational type[J]. Urban and Architecture, 2018(2):38-40. (in Chinese)
[15] 黄忠东, 杨小虎, 董金祥. SDAI实现中若干关键技术的研究[J]. 计算机辅助设计与图形学学报, 2001, 13(11):977-982.HUANG Z D, YANG X H, DONG J X. Research on key techniques in SDAI implementation[J]. Journal of Computer-Aided Design & Computer Graphics, 2001, 13(11):977-982. (in Chinese)
[16] JEONG J, LEE G, KANG H. Preliminary performance evaluation of an ORDB-based IFC server and an RDB-based IFC server by using the BUCKY benchmark method[C]//Proceedings of CIB World Congress 2010. Salford, UK, 2010:192-200.
[17] 陆宁, 马智亮. 利用面向对象数据库与关系数据库管理IFC数据的比较[J]. 清华大学学报(自然科学版), 2012, 52(6):836-842.LU N, MA Z L. Comparison of managing IFC data using object-oriented and relational databases[J]. Journal of Tsinghua University (Science and Technology), 2012, 52(6):836-842. (in Chinese)
[18] 丁士昭. 工程项目管理[M]. 2版. 北京:中国建筑工业出版社, 2014.DING S Z. Engineering project management[M]. 2nd ed. Beijing:China Construction Industry Press, 2014. (in Chinese)
[19] KANG S, MIRANDA E. Planning and visualization for automated robotic crane erection processes in construction[J]. Automation in Construction, 2006, 15(4):398-414.
[20] 潘在怡. 虚拟施工场景下移动式起重机自动选型与定位方法研究[D]. 北京:清华大学, 2018.PAN Z Y. Method of automated selection and location of mobile cranes in virtual construction[D]. Beijing:Tsinghua University, 2018. (in Chinese)