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

fYear

2006

Firstpage

1

Lastpage

6

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;

fLanguage

English

Publisher

ieee

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

Type

conf

DOI

10.1109/ICPST.2006.321913

Filename

4116234