A multidimensional data model design for building energy management

Abstract Data organization is a critical aspect in Building Energy Data Management. Yet, despite the importance of the topic, no sound reference model for energy data has been proposed in the literature that has been developed according to well-founded methodologies. This article proposes a reference data model developed according to standard multidimensional modeling methodologies and improved iteratively in review meetings with expert users (in the building energy management domain). The quality of the model is evaluated according to complexity, usability, and design metrics thus achieving a high-quality re-usable multidimensional data model that can be applied to create or improve on the data model designs of building energy management systems.

[1]  Jane P. Laudon,et al.  Management Information Systems: Managing the Digital Firm , 2010 .

[2]  Ivar Jacobson,et al.  The unified modeling language reference manual , 2010 .

[3]  Panos Vassiliadis,et al.  A Survey of Extract-Transform-Load Technology , 2009, Int. J. Data Warehous. Min..

[4]  Aris Tsangrassoulis,et al.  On the energy consumption in residential buildings , 2002 .

[5]  Sandhya Patidar,et al.  Understanding the energy consumption and occupancy of a multi-purpose academic building , 2015 .

[6]  Kenneth C. Laudon,et al.  Management Information Systems: Managing the Digital Firm Plus MyMISLab with Pearson eText -- Access Card Package , 2015 .

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

[8]  Klemens Böhm,et al.  Re-identification of Smart Meter data , 2012, Personal and Ubiquitous Computing.

[9]  Yan Li,et al.  A Data Warehouse Architecture supporting Energy Management of Intelligent Electricity System , 2013 .

[10]  Jessica Granderson,et al.  Energy Information Handbook: Applications for Energy-Efficient Building Operations , 2013 .

[11]  Galal H. Galal-Edeen,et al.  Data warehouse testing , 2013, EDBT '13.

[12]  Luis Pérez-Lombard,et al.  A review of HVAC systems requirements in building energy regulations , 2011 .

[13]  Yu Sun,et al.  Supervisory and Energy Management System of large public buildings , 2010, 2010 IEEE International Conference on Mechatronics and Automation.

[14]  Ramesh Sharda,et al.  Reflections on the Past and Future of Decision Support Systems: Perspective of Eleven Pioneers , 2011, Decision Support - An Examination of the DSS Discipline.

[15]  F. Maghsoodlou,et al.  Energy management systems , 2004, IEEE Power and Energy Magazine.

[16]  Geert Deconinck,et al.  Analysis of State-of-the-art Smart Metering Communication Standards , 2010 .

[17]  Matthias Goeken,et al.  Multidimensional Reference Models for Data Warehouse Development , 2007, ICEIS.

[18]  Abraham Silberschatz,et al.  Database System Concepts , 1980 .

[19]  Barney L. Capehart,et al.  Guide to Energy Management , 1969 .

[20]  Barney L. Capehart.  Information Technology for Energy Managers , 2004 .

[21]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling , 2013 .

[22]  Peter A. O'Donnell,et al.  Databases and Data Warehouses for Decision Support , 2008 .

[23]  Using MODBUS for Process Control and Automation , 2007 .

[24]  Ali M. Malkawi,et al.  A new methodology for building energy performance benchmarking: An approach based on intelligent clustering algorithm , 2014 .

[25]  Robert J. Hitchcock.  Metracker version 1.5: Life-cycle performance metricstracking , 2002 .

[26]  Mario Piattini,et al.  Experimental validation of multidimensional data models metrics , 2003, 36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the.

[27]  C. H. Kriebel.  Management information systems , 1970, ACM '70.

[28]  Daniel L. Moody,et al.  Theoretical and practical issues in evaluating the quality of conceptual models: current state and future directions , 2005, Data Knowl. Eng..

[29]  Bruce McMillin,et al.  Software engineering: What is it? , 2018, 2018 IEEE Aerospace Conference.

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

[31]  Henry Mintzberg,et al.  Structure in 5's: A Synthesis of the Research on Organization Design , 1980, Management Science.

[32]  J. Wyatt.  Decision support systems. , 2000, Journal of the Royal Society of Medicine.

[33]  Christoph G. Schütz,et al.  Customization of Domain-Specific Reference Models for Data Warehouses , 2014, 2014 IEEE 18th International Enterprise Distributed Object Computing Conference.

[34]  Taskin Koçak,et al.  Smart Grid Technologies: Communication Technologies and Standards , 2011, IEEE Transactions on Industrial Informatics.

[35]  Matteo Golfarelli,et al.  Data Warehouse Design: Modern Principles and Methodologies , 2009 .

[36]  John C. Van Gorp.  Maximizing Energy Savings with Energy Management Systems , 2004 .

[37]  Ozgur Turetken,et al.  Comparing the understandability of alternative data warehouse schemas: An empirical study , 2011, Decis. Support Syst..

[38]  Michael D. Brown,et al.  Revisions to ANSI/MSE 2000, the energy management system Standard , 2006 .

[39]  G. Harrison,et al.  Analyzing the Impact of Climate Change on Future Electricity Demand in Thailand , 2008, IEEE Transactions on Power Systems.

[40]  R. Kahn,et al.  Organizational psychology. , 1967, Annual review of psychology.

[41]  P ? ? ? ? ? ? ? % ? ? ? ? , 1991 .

[42]  Alistair B. Sproul,et al.  Optimisation of energy management in commercial buildings with weather forecasting inputs: A review , 2014 .

[43]  Recitation.  Entity-Relationship Model , 2009, Encyclopedia of Database Systems.

[44]  Wil M. P. van der Aalst,et al.  A configurable reference modelling language , 2007, Inf. Syst..

[45]  Il-Yeol Song,et al.  Entity Relationship Model , 2009, Encyclopedia of Database Systems.

[46]  Il-Yeol Song,et al.  An Analysis of Many-to-Many Relationships Between Fact and Dimension Tables in Dimensional Modeling , 2001, DMDW.

[47]  Mario Piattini,et al.  Empirical studies to assess the understandability of data warehouse schemas using structural metrics , 2008, Software Quality Journal.

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

[49]  Anjana Gosain,et al.  Literature Review of Data Model Quality Metrics of Data Warehouse , 2015 .

[50]  Helmut Krcmar,et al.  Data Warehouse Design , 2008 .

[51]  Henk Visscher,et al.  The effect of occupancy and building characteristics on energy use for space and water heating in Dutch residential stock , 2009 .

[52]  Oscar Newman,et al.  Creating defensible space , 1996 .

[53]  Shamkant B. Navathe,et al.  Conceptual Database Design: An Entity-Relationship Approach , 1991 .

[54]  Nelson Fumo,et al.  A review on the basics of building energy estimation , 2014 .

[55]  Xue Hong-ye,et al.  Measurement of the Energy Real-Time Data Warehouse System Design and Implementation , 2012, 2012 International Conference on Computer Science and Service System.

[56]  John Psarras,et al.  Intelligent building energy management system using rule sets , 2007 .

[57]  Clyde W. Holsapple,et al.  Decisions and Knowledge , 2008 .

[58]  Hein Schreuder,et al.  Economic Approaches to Organizations , 1993 .

[59]  Ralph H. Sprague,et al.  A Framework for the Development of Decision Support Systems , 1993 .

[60]  Á. Pardo,et al.  Temperature and seasonality influences on Spanish electricity load , 2002 .

[61]  Ralph H. Sprague,et al.  Invited Article: A Framework for the Development of Decisoin Support Systems , 1980, MIS Q..

[62]  Ivar Jacobson,et al.  Unified Modeling Language Reference Manual, The (2nd Edition) , 2004 .

[63]  Roland Bouman,et al.  Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL , 2009 .

[64]  S. Tassou,et al.  Measures used to lower building energy consumption and their cost effectiveness , 2002 .

[65]  Anjana Gosain,et al.  Theoretical and empirical validation of comprehensive complexity metric for multidimensional models for data warehouse , 2012, International Journal of System Assurance Engineering and Management.

[66]  Luis Pérez-Lombard,et al.  A review on buildings energy consumption information , 2008 .

[67]  Adrian Thomas Sobotta,et al.  Greening IT , 2010 .

[68]  Kelvin K. W. Yau,et al.  Predicting electricity energy consumption: A comparison of regression analysis, decision tree and neural networks , 2007 .

[69]  Warren E. Walker,et al.  Defining Uncertainty: A Conceptual Basis for Uncertainty Management in Model-Based Decision Support , 2003 .

[70]  D. Gyalistras,et al.  Climate warming impact on degree-days and building energy demand in Switzerland , 2006 .

[71]  Mary Ann Piette,et al.  Web-based energy information systems for energy management and demand response in commercial buildings , 2003 .

[72]  P. Verdelho,et al.  Determination of time-of-day schedules in the Portuguese electric sector , 2006, 2006 IEEE Power Engineering Society General Meeting.

[73]  Luca Evangelisti,et al.  Building energy performance analysis: A case study , 2015 .

[74]  Tiago Cardoso.  A Framework towards Efficient Integration of Energy Data , 2013 .

[75]  K. Umut Gökçe,et al.  Multi dimensional energy monitoring, analysis and optimization system for energy efficient building operations , 2014 .

[76]  Effy Oz,et al.  Management Information Systems, Sixth Edition , 2008 .

[77]  Michael Stadler,et al.  Improving energy efficiency via smart building energy management systems. A comparison with policy measures , 2015 .

[78]  Paulo Carreira,et al.  Towards an energy management maturity model , 2014 .

[79]  Matteo Golfarelli,et al.  Data Warehouse Testing , 2011, Int. J. Data Warehous. Min..

[80]  Ralph Kimball,et al.  The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling , 1996 .

[81]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit , 2009 .

[82]  Karsten Menzel,et al.  Multi-dimensional building performance data management for continuous commissioning , 2010, Adv. Eng. Informatics.