The Research And Design Of Real-time Historical Database In Rail Transit Integrated Supervisory Control System

The integrated supervisory control system of rail transit can enhance the adaptability to various emergencies of metro and increase the reaction speed, security of passengers’ lives and property security, improvement of subway service quality and service level, high technical difficulty, is the focus of the State encourages independent innovation.The core technology of integrated supervisory control system of rail transit is mainly reflected in the software technology of real-time database and historical database etc, directly affect the system scale, function, performance and reliability of integrated supervisory control system. Accumulation of our country in the technology is weak, the development time is short, and the gap between the level of foreign advanced technology is large. Therefore, the research on the key technology of real-time database and historical database, the formation of independent intellectual property rights of the integrated supervisory control system of rail transit, to improve public services, improve the ability to track traffic of orbit traffic electromechanical system localization rate, reduce the cost of construction, safeguarding national traffic safety has important theoretical and practical significance.The main analysis and design of real-time database and historical database system for integrated supervisory control system of rail transit in this thesis, the main research and technology.1, based on the integrated supervisory control system for domestic urban rail transit industry demand, completed the integrated supervisory control system software platform architecture design of urban rail transit, including real-time database, real-time historical database, data acquisition, man-machine interface and service engineering configuration of five modules.2, completed based on relational database for micro kernel memory the analysis and design of the real-time database system, the kernel and constantly changing user-oriented business applications in isolation, improve the scalability of real-time database, at the same time, the stability of the kernel will greatly improve the stability of the real-time database. At the same time, the integrated use of related technologies, completed a fully distributed architecture of real-time database, based on priority ruling machine redundancy, and processes in the quad state level fault isolation and so on several key functional requirements analysis and design, these design greatly improves the system reliability and ease of use.3, finished the design of historical database that can be applied to the integrated supervisory control system of rail transit. Study and comparison of the various compression technology, integrated with dead zone compression, lossy compression of revolving door and Snappy lossless compression technology, data compression rate can be up to now, save all the historical data of 25 station 1 year 1087.5 GB, save historical data scattered in each station, each station only 43.5 GB. To solve the current rail transit comprehensive monitoring of the high frequency sampling, huge amounts of data application scenarios, a relational database in read/write performance and storage capacity bottlenecks. At the same time, in view of the modern computer architecture, research and design of the high speed data read and write. By caching, data compression, jump table, freezing table, writing techniques, such as disk order to realize high speed data reading and writing history, without a lossy compression data writing can reach 150000/SEC, data read up to 100000 m/SEC.