计算机应用 ›› 2011, Vol. 31 ›› Issue (10): 2853-2857.DOI: 10.3724/SP.J.1087.2011.02853

• 典型应用 • 上一篇    下一篇

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

罗先贤   

  1. 华南理工大学 软件学院, 广州 510006
  • 收稿日期:2011-04-28 修回日期:2011-06-13 发布日期:2011-10-11 出版日期:2011-10-01
  • 通讯作者: 罗先贤
  • 作者简介:罗先贤(1983-),男,河南罗山人,硕士研究生,主要研究方向:数据仓库、数据挖掘、商务智能。

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

LUO Xian-xian   

  1. Software School, South China University of Technology, Guangzhou Guangdong 510006, China
  • Received:2011-04-28 Revised:2011-06-13 Online:2011-10-11 Published:2011-10-01
  • Contact: Xian-xian LUO

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

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

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

中图分类号: