Multi-dimensional building performance data management for continuous commissioning

Current buildings' performance assessment tools are deficient in their ability to integrate and process building monitoring data to generate actionable information that can assist in achieving a higher level of building performance. Therefore, this paper addresses this problem by proposing the design and implementation of a multi-dimensional data analysis concept for building monitoring data. Firstly, the development of the multi-dimensional performance data model is described based on data warehouse technology. Secondly, a dedicated graphical user interface is introduced bringing the benefits of the multi-dimensional model to different stakeholders. Finally, the advantages of multi-dimensional performance data management is demonstrated in a real life case study for on-site and e-service performance management.

[1]  W. H. Inmon,et al.  The data warehouse and data mining , 1996, CACM.

[2]  Wolfgang Kastner,et al.  Communication systems for building automation and control , 2005, Proceedings of the IEEE.

[3]  Karsten Menzel,et al.  Context sensitive mobile devices in architecture, engineering and construction , 2004, J. Inf. Technol. Constr..

[4]  Yang Jun,et al.  Utilizing exchanged documents in construction projects for decision support based on data warehousing technique , 2005 .

[5]  David E. Claridge,et al.  Improving building energy system performance by continuous commissioning , 1997, IECEC-97 Proceedings of the Thirty-Second Intersociety Energy Conversion Engineering Conference (Cat. No.97CH6203).

[6]  Richard Niemiec.  Oracle Database 10g Performance Tuning Tips & Techniques , 2007 .

[7]  Jong Kook Lee,et al.  Principles and Strategies for Applying Data Warehouse Technology to Construction Industry , 2003 .

[8]  Marcus M. Keane,et al.  Improving building operation by tracking performance metrics throughout the building lifecycle (BLC) , 2004 .

[9]  Jeffrey F. Naughton,et al.  Materialized View Selection for Multidimensional Datasets , 1998, VLDB.

[10]  Petra Perner,et al.  Data Mining - Concepts and Techniques , 2002, Künstliche Intell..

[11]  Steve Hoberman,et al.  Data Modeling Made Simple: A Practical Guide for Business and IT Professionals, , 2009 .

[12]  Mary Ann Piette,et al.  Case studies of energy information systems and related technology: Operational practices, costs, and benefits , 2003 .

[13]  A Karavan,et al.  Merging Building Automation Network Design and IFC 2x Construction Projects , 2005 .

[14]  Hani Hagras,et al.  A hierarchical fuzzy-genetic multi-agent architecture for intelligent buildings online learning, adaptation and control , 2003, Inf. Sci..

[15]  Graham Clarke,et al.  A Multi-Agent Architecture For Intelligent Building Sensing and Control , 1999 .

[16]  I. Ahmad,et al.  Data warehousing in the construction industry: organizing and processing data for decision-making , 1999 .

[17]  Godfried Augenbroe,et al.  Quantification methods of technical building performance , 2005 .

[18]  A Min Tjoa,et al.  Data Warehousing and Knowledge Discovery , 2010, Lecture Notes in Computer Science.

[19]  Ralph Kimball,et al.  The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data , 2004 .

[20]  J M Lauritsen,et al.  [Data collection and analysis]. , 1999, Ugeskrift for laeger.

[21]  Torben Bach Pedersen,et al.  Multidimensional Database Technology , 2001, Computer.

[22]  J. Ploennigs,et al.  Analyse building performance data for energy-efficient building operation , 2009 .

[23]  Dirk Pesch,et al.  Towards a Wireless Sensor Platform for Energy Efficient Building Operation , 2008 .

[24]  Ambuj K. Singh,et al.  Efficient view maintenance at data warehouses , 1997, SIGMOD '97.

[25]  Farhan Manzoor Ahmed Khan,et al.  TRACKING OCCUPANTS AND INVENTORY ITEMS IN BUILDINGS USING RADIO FREQUENCY IDENTIFICATION (RFID) TECHNOLOGY , 2010 .

[26]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.

[27]  Irtishad Ahmad,et al.  Development of a decision support system using data warehousing to assist builders/developers in site selection , 2004 .

[28]  Ronald G. Ross.  Data base systems: Design, implementation, and management , 1978 .

[29]  Paul Raftery,et al.  KEY FACTORS-METHODOLOGY FOR ENHANCEMENT AND SUPPORT OF BUILDING ENERGY PERFORMANCE , 2009 .

[30]  Raimar Scherer,et al.  eWork and eBusiness in Architecture, Engineering and Construction: ECPPM 2008 , 2008 .

[31]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[32]  W. Granzer,et al.  Wireless Technologies in Home and Building Automation , 2007, 2007 5th IEEE International Conference on Industrial Informatics.

[33]  Kwok-wing Chau,et al.  Application of data warehouse and Decision Support System in construction management , 2003 .

[34]  Peter Rob,et al.  Database systems : design, implementation, and management , 2000 .

[35]  Carolyn L Murdaugh,et al.  Handbook of Data Analysis , 2006 .

[36]  Philip Haves,et al.  Analysis of an information monitoring and diagnostic system to improve building operations , 2001 .

[37]  Richard C. Diamond,et al.  Performance validation and energy analysis of HVAC systems using simulation , 2000 .

[38]  G. G. Stokes.  "J." , 1890, The New Yale Book of Quotations.

[39]  W. H. Inmon,et al.  Building the data warehouse (2nd ed.) , 1996 .

[40]  Wolfgang F. E. Preiser,et al.  Assessing building performance , 2005 .

[41]  Vincent Rainardi,et al.  Building a Data Warehouse: With Examples in SQL Server , 2008 .

[42]  Tetsuo Tomiyama,et al.  Advanced Engineering Informatics , 2007, Adv. Eng. Informatics.

[43]  Inderpal Singh Mumick,et al.  The Stanford Data Warehousing Project , 1995 .