Title :
The Modeling of Power Data Warehouse based on CIM
Author :
He, Xiaofeng ; Wang, Gang ; Zha, Jiancang ; Li, Haifeng
Author_Institution :
Coll. of Electr. Eng., South China Univ. of Technol., Guangzhou
Abstract :
The system structure of data warehouse (DW) for power system is presented, and the design of subject for DW is discussed. Based on common information model (CIM), a general method of dimension modeling for star model of power DW is shown. Five characteristic values are used to validate the model. An example of data modeling for DW of dispatching automation system is shown and validated. The storage strategy will be discussed in detail. After rough estimate, how to select the granularity for DW is shown. In order to enhance performance of query, alter-granularity storage strategy and time rolling compress algorithm are presented for DW.
Keywords :
data warehouses; power engineering computing; power systems; alter-granularity storage strategy; common information model; dimension modeling; dispatching automation system; power data warehouse; power system; star model; time rolling compress algorithm; Computer integrated manufacturing; Data analysis; Data models; Data warehouses; Dispatching; Helium; Object oriented modeling; Power system modeling; Relational databases; Transaction databases; Common information model; data warehouse; dimension modeling; granularity; power system;
Conference_Titel :
Power System Technology, 2006. PowerCon 2006. International Conference on
Conference_Location :
Chongqing
Print_ISBN :
1-4244-0110-0
Electronic_ISBN :
1-4244-0111-9
DOI :
10.1109/ICPST.2006.321913
