Dongyuan Shi, Yinhong Lee, Xianzhong Duan, Q'H' WuDongyuan Shi Yinhong Lee Xianzhong Duan Wu, Q'H'Co

1

• Dongyuan Shi, Yinhong Lee, Xianzhong Duan, Q.H.
  WuDongyuan Shi Yinhong Lee Xianzhong Duan Wu,
  Q.H.Computer Applications in Power,
• IEEE , Volume 14 Issue 3 , July 2001 Page(s)
  49 -55

Instructs professor ??? Graduate student
??? No9217295 Date04/12/2003
2
Outline

• Definition
• Characteristics
• Technological Requirements
• Design and Implementation
• Potential Power System Applications
• Conclusion

3
Definition

• Data warehouse ? W.H. Inmon ?
• - subject-oriented, integrated, time-variant,
  and nonvolatile
• - support managers decision-making process
• power systems
• - real-time industrial system responsible for
  the generation,
• transmission, and dispatch of electricity,
  charge of the
• supervision, control, and operation

4
Characteristics

• Subject
• The data classification corresponding to a
  macroscopic field.
• Integration
• The data contained within the boundaries of
  the warehouse are integrated.
• Time Variance
• The data has wider time range ,updateable,
  cannot be updated once correctly recorded.
• Nonvolatile
• The users can do is to use some tools to
  access
• the data rather than to update it.

5
The solid platform of integrated, analysis over a
long historical time perspective can be done
6
Technological Requirements

• The efficient loading, indexing, and monitoring
  of the data.
• The SQLlike language.
• Physical location can be achieved.
• The metadata securable, and a perfect tool.
• The parallel processing, data compression,
  recovery.

7
Data Warehouse Architectures
Include data model, data structure, data
conversion rules, data summarizing algorithms,
and so on.
Data mart is a subset of the overall enterprise
data warehouse.
The ECTL tool acts as a single point of data
extraction that provides  coordinated access to
source data.  
8
Design and Implementation

• Top-down implementation
• Bottom up implementation
• Parallel implementation
• -the combination of the top-down approach and
  bottom-up approach in order to achieve maximal
  effects.

9
A global data warehouse covering all the
workgroups,  departments, or lines of businesses
is constructed first, and data marts according to
different subjects will be built afterward.
It can be significant. But it is time-consuming
and can delay actual implementation, benefits,
and return on investment.
10
It is more easily evaluated and can result in
much faster harvest and payback
implementation means that data marts are designed
and constructed before, or in parallel with, a
global data warehouse .
11
Potential Power System Applications

• A power system
• determine the successive state
• show the future trend of the system state
• An accurate state
• improve the control, operation, and planning of
  the power system

12
Supervisory Control and Data Acquisition, a
computer system for gathering and analyzing real
time data. EMS Energy Management Services
13
Conclusion

• The reach
• A global accepted data is difficult to achieve.
• It is arduous and time-consuming work.
• The leading software corporations should be
  evaluated.