关键词: 城市公共建筑, 能耗, 数据仓库, 维度, 粒度

Abstract: 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.

Key words: urban public building, energy consumption, data warehouse, dimensionality, granularity