数据仓库在城市公共建筑能耗管理中的应用

当前众多城市公共建筑能耗监测系统中已收集了大量的建筑能耗数据。针对这些数据源存在的各自独立而且分散,不能够提供全局的数据分析环境,不能够有效支持建筑能耗的评估与建筑节能的研究等问题,提出将数据仓库技术应用于城市公共建筑能耗监管系统的解决方法。通过对建筑能耗监测系统的研究,以及对建筑能耗管理的应用需求的调研,建立城市级公共建筑能耗数据仓库的多维数据模型,对主题设计、指标设计和维度模型设计进行了探讨,并在实验阶段已成功构建了某高校公共建筑能耗数据仓库的实例。实验结果表明,该方法能够有效地为建筑能耗的管理与决策提供良好的数据分析环境。

Application of data warehouse technology in energy management of urban public buildings

Currently, many urban public building energy consumption monitoring systems have collected a large amount of building energy consumption data. Because these data sources are independent and scattered of each other, they cannot provide the environment of global data analysis, and they cannot effectively support the assessment of building energy consumption and the research of building energy-saving. A solution that applied the data warehouse technology to the energy consumption monitoring system of urban public buildings was proposed. Through the research of building energy consumption monitoring system and the investigation of the demand of application in the buildings' energy management, the multi-dimensional data model of the energy consumption data warehouse of urban public buildings was established. The theme design, index design and dimensional model design were studied. The instance of a college public buildings' energy consumption data warehouse was successfully built in the experimental phase. The result indicates that the solution can effectively provide good environment of data analysis for the management and decision-making of buildings' energy consumption.