Research And Implementation On Key Technologies Of Real-time Database In EMS System

RTDB (Real-time database) is a new type of database, with constraining time, which is organically integrated by real-time system and database. Presently, the research about RTDB is becoming hotspot, because the traditional database is very difficult to meet the demand of the time-critical applications, the research of RTDB is hotspot. With the rapid development of the power grid scale, the requirements of sheduling and resource allocation are becoming higher and higher. The reliability, stability and scalability of old EMS's (Energy Management System) architecture are facing challenges, and all these are affected by RTDB's structure and performance. Therefore, it is necessary to resarch RTDB's architecture, real-time index and concurrency control.This paper has made detail research about key technologies of RTDB in EMS and the main works are as follows:1) The article describes the development of RTDB, and analyzes the RTDB's impotance. To be combined with EMS's feature, Main-memory database is uesd to serve as undlying support of EMS-RTDB, and designes the function and structure of EMS-RTDB.2) The article analyzes the index technology. In memory, data accessing or pointer moving is fast, and it requires a higher utilization of space, traditonal index can't meet the demand. In this paper, T-st index is proposed, it is improved base on T-tree index, the successor and tail pointer are added, and the corresponding algorithm is designed, the ability of range searching, inserting, and deletion are all improved. According to the different demands of EMS's applications, RTDB typically support range query and random search, based on this, this paper implements two methods to achievs configuration options: one is based on T-st index and the other is based on hash index, the tests show high performance.3) The article analyzes the concurrency control technology. To be combined with EMS's feature,the paper designs multi-granularity locking mechanism and a varity of locking model for EMS-RTDB, then adds the orderly sharing mechanism to meet the requirements of data consistency, then this method is relized, the tests show that it can meet the demand of EMS.