APPARATUS AND METHOD FOR CONSTRUCTING DATAWAREHOUSE TO MASS BUILDING ENERGY INFORMATION MANAGEMENT

摘要

PURPOSE: A data warehouse construction method and a device thereof are provided to improve the performance of an energy management service when the same are requested and to solve loads of the system caused by the generation of frequent transaction. CONSTITUTION: An initial database generator constructs initial database by each building based on energy control point information received from a plurality of control object buildings (S610). A time series data warehouse generator generates a data warehouse of time series based on the constructed initial database (S620). A construction series data warehouse generator generates a data warehouse of construction series by reconstructing the data warehouse of the time series generated based on an object construction information table including space information of an object on a control point of a control object building (S630). A view database generator generates view database by search conditions based on the data warehouse of the construction series according to the search conditions on energy consumption information. [Reference numerals] (AA) Start; (BB) End; (S610) Construct initial database by analyzed energy information collected from a plurality of buildings; (S620) Generate a data warehouse of time series by extracting and converting information stored in the initial database; (S630) Generate a schedule-based data warehouse of construction series based on the constructed data warehouse of time series