Design And Implementation Of Hydropower Dispatching Warning System Based On Simple Main Memory Database

In recent years, along with the development of Information Technology, a great amount of data need to be dealt with and analyzed. The traditional database system based on disk doesn't fulfill the demand of real-time data access, so people begin to consider one of new technology, which is Main Memory Database (MMDB). The main theory of MMDB is that by taking out data from disk to memory, and making use of the random access characteristic of the memory, imitating the building of table structure and index structure which can realize high access speed, and greatly increase the dispose ability of Database System, so it is very suitable for those real-time systems with strict requirement of time limit and those transaction processing platforms with enormous high-performance data. In addition, because the amazingly improving of the integration of semiconductor storage chip and the price reduction of the memory, MMDB technology develops rapidly in many fields.First of all, this paper holds forth the necessary of using the MMDB technology in the hydropower dispatching automation and warning system according to the characteristic of the application system. Then, the paper introduces the concepts and traits of MMDB, presents the difference between MMDB and Traditional DB, analyzes its predominance, and investigates its physical structure, index, transaction processing, query optimize, subsequent control and data resume in detail. At last, the paper put forward the solutions of establishing a reasonable memory database to reduce the times of inquiries, shorten the processing time and improve the implementation of the system efficiency.Based on above theoretic analysis, the paper focuses on the data organization and index mode, uses the block-segment structure and T-tree index technology, designs and implements a hydropower dispatching automation and warning system based on simple MMDB. All of its modules are realized and the aim is achieved. The study on this task has lessons for other systems using MMDB technology.