Marshalling Yard Operations Simulation Platform Database Structural Design And Access Technologies

Development of the situation raised new requirements on rail transport, as the continuous development of modern railway technology. Simulation platform to establish the purpose is to develop rail transport professional and technical management talents. It solves the problem of the gap between teaching and field applications in the professional teaching of the rail transport. In this study, the performance of the marshalling yard mode of operation, job settings, and man-machine interface design are based on the mode of CIPS environment under the North Marshalling Station in Chengdu. Marshalling yard operations of the Railroad Bureau true process is moved into the laboratory. Students may experience the actual situation of the field.operations. So that students master the work of the marshalling yard.The database is the core of the marshalling yard operation simulation system. It includes the dynamic representation of the system, then the grid management system,the signal to operate the system, hook plan assisted the preparation of the system, now cat management system, operating a large table. The overall planning and design of the simulation platform database based on database technology. SQL Server2008to complete the establishment of the database and optimization.The main contents of this article:a) First, the paper analyzes the job of marshalling yard operating organizational processes and job set, then design the overall structure of the marshalling yard operations simulation platform.b) This paper analyzes the processes of marshalling station, complete simulation platform database needs analysis.c) Logical database design of Simulation platform database. The system uses a centralized database structure. This study to determine the database’s data storage model and data access model.d) The physical design of the Simulation platform database. The database information is divided into dynamic and static information. Data partition is stored, then, this way can improve the efficiency of database access,and enhance the security of the database.e) Trigger to complete the simulation platform interlocking control functions. Database trigger simulation platform interlocking control function to ensure data consistency and integrity, to ensure accurate reading and writing the database.f) Simulation platform database access technology. Identified using ADO technology to access the database, by analyzing the system. The system to read the database every5seconds.