The Yunnan Electric Power Regulatory Information System Database Design And Realization

Manage Information System(MIS) have made full application in every walk of life for its network manage pattern. MIS have powerful capability of data storage, query, analysis and transact. It has become the important part of Electric Power Information and the database is the core of the MIS. Today, how to structure high efficient database are the important research items in Electric Power trade for the excessive data, complex operations and data.Applying computer-assistant design, and making use of the tools of Powerdesigner, the paper have designed and implemented the database of Electric Power Technology Supervisory Manage Information System in YunNan province on basis of general database design theory. On the one hand, the paper discussed the key technology such as the security and integrity of database, optimizing the database, as well as database backup an recovery. On the other hand , as to the deployment of database, the paper introduce the advanced technology of Computer Cluster , and structure the High Available cluster database server on basis of IBM pSeries630 and Brower/Server(B/s) frame. Some key technology on imployment have been researched which includes the sharing Disk Array, the Storage Area Network(SAN), components redundancy, and High Availability Cluster Multi-Processing/6000(HACMP) etc.. The background DataBase Manage System (DBMS) are 0racle9i on AIX platform. The paper also farther expound the technology of database self- startup, self-close, self-switch and self-backup under the circumstances of cluster, moreover ,these technology has been applied the database system.The practice have show that these technology enhance the relaibiliy and the ability of contain errors of the system, as well as to ensure the system running constantly and stablely with 24X7. Up to present, the Electronic Power Technology Supervisory MIS under support of the database system has been running stablely and effectively in every city, prefecture and state in this province.