民用建筑“四节一环保”数据建模与存储方法研究  

Research on Data Modeling and Storage Method of "Resources Saving and Environment Protection" in Civil Buildings

作　　者：陈昉 杜战朝 倪翊龙 邵高峰[2] 李丹丹 徐高 Chen Fang;Du Zhan-chao;Ni Yi-long;Shao Gao-feng;Li Dan-dan;Xu Gao(China Electric Power Planning&Engineering Institute Co.,Ltd.,Beijing 100105,China;Center of Science and Technology and Industrialization Development,MOHURD,Beijing 100831,China;Beijing North-Star Technology Development Co.,Ltd.,Beijing 100105,China)

机构地区：[1]电力规划总院有限公司,北京100105 [2]住房和城乡建设部科技与产业化发展中心,北京100831 [3]北京洛斯达科技发展有限公司,北京100105

出　　处：《建筑科学》2020年第S02期382-389,共8页Building Science

基　　金：国家重点研发计划项目“民用建筑‘四节一环保’大数据及数据获取机制构建”(2018YFC0704300)

摘　　要：为适应民用建筑"四节一环保"范围广、类型多、渠道不一等特点,提出了四节一环保数据的概念模型与数据指标管理模型。结合"四节一环保"分析应用需求,构建了基于Hadoop与MySQL的分布式大数据存储服务,设计实现了4层结构的四节一环保数据仓库。以住建部民用建筑"四节一环保"数据仓库建设为例,开发了数据主题查询、数据渠道查询、数据指标查询、全文检索、数据指标体系管理、数据权限与安全控制等功能,验证了所设计的建模和存储方法的有效性。结果表明,所提方法既满足了宏观决策对大数据的需求,又很好满足"四节一环保"数据动态更新的需要,减少了数据搬运成本,提升了经济性。The concept model and data index management model are put forward in view of the characteristics of"Resources Saving and Environment Protection"in civil buildings,such as wide range,many types and inconsistent channels.Combined with the analysis of application requirements of"Resources Saving and Environment Protection",a distributed big data storage service based on Hadoop and MySQL was built,and a 4-layer data warehouse was designed and implemented.Taking the construction of the"Resources Saving and Environment Protection"data warehouse for civil buildings of the Ministry of Housing and Urban-Rural Development of the People’s Republic of China as an example,the functions of data subject query,data channel query,data index query,full-text search,data index system management,data authority and security control are developed to verify the effectiveness of the modeling and storage method designed.The results show that the proposed method not only meets the need of big data for macro decision-making,but also well meets the need of dynamic updating of"Resources Saving and Environment Protection"data,reduces the cost of data handling and improves the economy.

关 键 词：民用建筑 四节一环保 数据仓库 数据模型 大数据 

分 类 号：TU201.5[建筑科学—建筑设计及理论]