The Modeling of Power Data Warehouse based on CIM

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.

[1]  Gang Wang,et al.  Research on the SCADA /EMS System Data Warehouse Technology , 2005, 2005 IEEE/PES Transmission & Distribution Conference & Exposition: Asia and Pacific.

[2]  János Abonyi,et al.  Process-data-warehousing-based operator support system for complex production technologies , 2006, IEEE Transactions on Systems, Man, and Cybernetics - Part A: Systems and Humans.

[3]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[4]  Cao Yijia,et al.  Model of electric market operation support system based on UML , 2001, Proceedings 2001 International Conference on Computer Networks and Mobile Computing.

[5]  Manuel Palomar,et al.  Designing Data Warehouses with OO Conceptual Models , 2001, Computer.

[6]  Timon C. Du,et al.  Designing data warehouses for supply chain management , 2004, Proceedings. IEEE International Conference on e-Commerce Technology, 2004. CEC 2004..

[7]  Walid G. Aref,et al.  Digital government security infrastructure design challenges , 2001 .

[8]  Adriana Marotta,et al.  Data warehouse design: a schema-transformation approach , 2002, 12th International Conference of the Chilean Computer Science Society, 2002. Proceedings..

[9]  João Eduardo Ferreira,et al.  Synchronization options for data warehouse designs , 2006, Computer.