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

被引：0
作者：
Guo H. [1 ]
Zhou Y. [1 ]
Ye X. [1 ]
Luo Z. [1 ]
Xue F. [2 ]
机构：
[1] Department of Construction Management, Tsinghua University, Beijing
[2] Department of Real Estate and Construction, The University of Hong Kong
来源：
Qinghua Daxue Xuebao/Journal of Tsinghua University | 2021年 / 61卷 / 02期
关键词：
Automatic mapping; Building information modelling (BIM); Industry foundation classes (IFC); Relational database;
D O I：
10.16511/j.cnki.qhdxxb.2020.22.030
中图分类号：
学科分类号：
摘要：
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. © 2021, Tsinghua University Press. All right reserved.
引用
收藏
页码：152 / 160
页数：8
相关论文
共 20 条
  • [1] CHENG Y S, LI Q M, CHENG H., On implementing IFC data in rational database and its application, Computer Applications and Software, 31, 11, pp. 34-44, (2014)
  • [2] LAI H H, DENG X Y, LIU X L., IFC-based BIM data sharing and exchange, China Civil Engineering Journal, 51, 4, pp. 121-128, (2018)
  • [3] HE G P., Three pillars to realize the value of BIM: IFC/IDM/IFD, Journal of Information Technology in Civil Engineering and Architecture, 3, 1, pp. 108-116, (2011)
  • [4] Industry foundation classes (IFC): An introduction
  • [5] SUN J, LIU Y S, GAO G, Et al., IFCCompressor: A content-based compression algorithm for optimizing Industry Foundation Classes files, Automation in Construction, 50, pp. 1-15, (2015)
  • [6] ZHOU Y, GUO H L, LUO Z B., Research on automatic mapping method from IFC data to relational database, Proceedings of the 4th National BIM Academic Conference, pp. 311-317, (2018)
  • [7] ZHANG Y., Research on BIM-based building information integration and management, (2009)
  • [8] ZHANG J J., Basic database case tutorial and experimental guidance, (2011)
  • [9] LI X L, YI H, WU X Y., Implementation of EXPRESS data mode on relational database, Computer Integrated Manufacturing System, 1, pp. 64-68, (1999)
  • [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, Automation in Construction, 84, pp. 367-383, (2017)
12