A Study Of Data Storage System And Indexing Structure For The Railway Dispatching System

Along with the advancement of railway informatization construction, railway dispatching system obtained fast popularization and application, now it has become the important equipment in the railway transport industry technical. In this system, a large amount of data is stored, which is the important guarantee of the stable operation. And it is the basis data, which the maintenance personnel can use to judge fault and make the maintenance plan. But the data is isolated stored in each node of the system, and their formats are not unified. All of this greatly limits the data access efficiency. This paper adopts the distributed database technology to solve these problems.According to the analyses of the daily operation and maintenance, this paper summarizes the importance and advantages of constructing distributed database system. Then it researches the related technology of distributed database system, such as the key problems of database and their solutions.The content of chapter 3 is the logical design. In this chapter the logic structure of system is studied, as also as the content of scattered data and its transmission path, which are the foundation for further database design. In this chapter, we show up the E-R model figure, and construct the relation table structure. In the process of constructing table structure, the connections between the various data are mainly considered, and we eliminate the unnecessary data redundancy on the basis of data model standardization theory. At the last of this chapter, we discuss the scheme of data copies distribution.Chapter 4 and chapter 5 explain physical process of the database design. In the physical design stage, IP-SAN storage network is selected as the storage model of database. And we the data unified algorithm is designed, which is based on XML. This algorithm can ensure the integrity of the data model. Then this paper introduces the data transmission agreement. Reasonable index mechanism can greatly improve the performance of database, this paper designs a B+-HASH tree index structure, and presents the mathematical definition of index. B+-HASH tree index can satisfy the single data query and range query.In chapter 6, this paper designs a set of experiment based on the fault diagnosis model, in order to testing the performance of database.