Design And Optimization Of Log Database For Railway Dispatching Command System

Good maintenance program is the important guarantee to the safe and stable operation of the railway dispatching command system. Log information is the important data source in system maintenance. Log information of railway dispatching command system is stored in text file. This kind of unstructured storage greatly limits the efficiency of inquiry. And the high redundancy is in the log information, which wastes much storage space. Storing log information into relational database can greatly improve the query efficiency, and save storage space. In this way, log information can be effectively managed.In this paper, railway dispatching command system structure and the characteristics of the daily maintenance is further analyzed. Demand foundation is acquired, and the system E-R model figure is designed on this basis. After that, we design the log database table structure. In the process of designing table structure, data redundancy and information relevance are key considerations, in order to ensure that the log information storage structure is an organic whole.Log database records the accurate historical information of the system state and action. System will write large amounts of data into database, in a very short period of time. In this case, we need to build an efficient index mechanism to help database quickly and accurately positioning disk space. Aiming at the demand characteristic, this paper designed a T*-H two-dimensional index, which can find the disk physical addresses from two aspects, time labels and device ID. T*-H two-dimensional index laid a foundation to high-speed access operating.Finally, according to the characteristics of log information, several aimed data compression schemes are designed, which are of great significance to save disk space and ascend database performance.