Please wait a minute...
 首页  期刊介绍 期刊订阅 联系我们 横山亮次奖 百年刊庆
 
最新录用  |  预出版  |  当期目录  |  过刊浏览  |  阅读排行  |  下载排行  |  引用排行  |  横山亮次奖  |  百年刊庆
清华大学学报(自然科学版)  2021, Vol. 61 Issue (2): 152-160    DOI: 10.16511/j.cnki.qhdxxb.2020.22.030
  建设管理 本期目录 | 过刊浏览 | 高级检索 |
IFC数据模型至关系型数据库模型的自动映射
郭红领1, 周颖1, 叶啸天1, 罗柱邦1, 薛帆2
1. 清华大学 建设管理系, 北京 100084;
2. 香港大学 房地产与建设系, 香港 999077
Automated mapping from an IFC data model to a relational database model
GUO Hongling1, ZHOU Ying1, YE Xiaotian1, LUO Zhubang1, XUE Fan2
1. Department of Construction Management, Tsinghua University, Beijing 100084, China;
2. Department of Real Estate and Construction, The University of Hong Kong, Hong Kong 999077, China
全文: PDF(8532 KB)   HTML
输出: BibTeX | EndNote (RIS)      
摘要 建筑信息模型(BIM)为建筑业信息化提供重要支撑,而工业基础类(IFC)作为国际通用的数据模型,则为BIM的研究与应用提供了有效支持。然而,IFC的局限性使其不宜作为信息系统二次开发时数据存储的主要形式。为此,该文提出一种自动映射方法,实现IFC数据模型到关系型数据库模型的自动映射。根据IFC数据模型结构,依次定义实体、类型、函数、规则、属性集和数量集的映射规则,实现数据解析、数据映射存取和信息检索处理。通过2个案例探索映射得到的关系型数据库的专业应用前景,结果表明:映射得到的关系型数据库在信息传递完整性和数据管理效率方面均优于直接操作IFC文件,不仅能提高BIM数据管理的完整性和效率,还能促进智能建造的拓展应用和建筑业信息化的发展。
服务
把本文推荐给朋友
加入引用管理器
E-mail Alert
RSS
作者相关文章
郭红领
周颖
叶啸天
罗柱邦
薛帆
关键词 建筑信息模型(BIM)工业基础类(IFC)关系型数据库自动映射    
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 wordsbuilding information modelling (BIM)    industry foundation classes (IFC)    relational database    automatic mapping
收稿日期: 2020-07-10      出版日期: 2020-12-29
引用本文:   
郭红领, 周颖, 叶啸天, 罗柱邦, 薛帆. IFC数据模型至关系型数据库模型的自动映射[J]. 清华大学学报(自然科学版), 2021, 61(2): 152-160.
GUO Hongling, ZHOU Ying, YE Xiaotian, LUO Zhubang, XUE Fan. Automated mapping from an IFC data model to a relational database model. Journal of Tsinghua University(Science and Technology), 2021, 61(2): 152-160.
链接本文:  
http://jst.tsinghuajournals.com/CN/10.16511/j.cnki.qhdxxb.2020.22.030  或          http://jst.tsinghuajournals.com/CN/Y2021/V61/I2/152
  
  
  
  
  
  
  
  
  
  
[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)
[1] 刘广宇, 安芃, 伍震, 胡振中. 基于本体的公路工程安全领域知识建模和应用[J]. 清华大学学报(自然科学版), 2024, 64(2): 224-234.
[2] 曹新颖, 孟凡凡, 李小冬. 基于精益管理的装配式建造过程返工风险智能识别[J]. 清华大学学报(自然科学版), 2023, 63(2): 201-209.
[3] 郭红领, 叶啸天, 任琦鹏, 罗柱邦. 基于BIM和规则推理的施工进度计划自动编排[J]. 清华大学学报(自然科学版), 2022, 62(2): 189-198.
[4] 胡振中, 冷烁, 袁爽. 基于BIM和数据驱动的智能运维管理方法[J]. 清华大学学报(自然科学版), 2022, 62(2): 199-207.
[5] 林佳瑞, 郭建锋. 基于BIM的合规性自动审查[J]. 清华大学学报(自然科学版), 2020, 60(10): 873-879.
[6] 林佳瑞, 张建平. 基于IFC的绿色性能分析数据转换与共享[J]. 清华大学学报(自然科学版), 2016, 56(9): 997-1002.
[7] 刘强, 张建平, 胡振中. 基于键-值缓存的IFC模型Web应用技术[J]. 清华大学学报(自然科学版), 2016, 56(4): 348-353,359.
[8] 胡振中, 陈祥祥, 王亮, 何田丰. 基于BIM的管道预制构件设计技术与系统研发[J]. 清华大学学报(自然科学版), 2015, 55(12): 1269-1275.
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
版权所有 © 《清华大学学报(自然科学版)》编辑部
本系统由北京玛格泰克科技发展有限公司设计开发 技术支持:support@magtech.com.cn