Open Real-time Database and it´s Application in Dispatching Automation Systems

Traditional databases such as ORACLE, SQL SERVER have powerful data processing functions, and become a standard component of automation systems. However, such database use hard disk as its storage media with low speed. Most dispatching automation systems use both real-time and traditional databases to achieve high speed. Today, most real-time databases are developed by automation system providers, the interfaces are non-standard. So, it´s hard to develop and data interchange. Especially, function of data synchronization among different nodes in a automation system is also developed by the providers, which are not reliable, this may reduce the stability of the systems. This article lay out a scheme of open real-time database based on memory. The database supports standard SQL language and data replication among different nodes. It also supports transaction to make sure the data consistency. This article describes the implementation technology of data I/O from memory and the arithmetic of data synchronization between real-time and traditional database, and make real-time and traditional database cooperate together. Technology developed by this article will help to reduce the development investment, improve the system´s reliability, make progress in the standardization of real-time data processing in dispatching automation systems and perhaps will be widely used.