Research On The Technology Of Database Real-time Construction And Management For High-speed Craft Automatic Steering Simulator System

High-speed craft (in short, HSC) automatic steering simulator database is an importantpart of the HSC simulator systems. By dynamic storing the data of steering and operatingsimulation and quickly recording the data for the HSC simulator system, it can be used forsteering training simulation operation and training process, reduced HSC steering training riskand shorten the training cycle. This paper has an important theoretical significance andpractical application value.According to the simulating demand of HSC steering training and based on the basicdesign principle of database, a low redundancy, query convenient and fast database is set up toprovide some functions, such as steering training data recording and training process retrieval.First of all the basic data tables of the simulator database and the correlative globalrelationship model are constructed through the collection of entity data of the HSC. Throughthe conception design, the logic design and the physics design respectively, the simulatordatabase is constructed.The second based on the SQL Server2000and Qt developing platform, the real-timesimulator database is developed and the flow chart is provided accordingly. The storage andaccess interface for simulator database is designed and the constructing data sheets of thesimulator database are accomplished by static data storage and dynamic data storage.The third two query modes are proposed in this paper, exact query mode and fuzzy querymode. The research of optimizing methods of database query are researched in this paper,those are the query optimizing method based on index query, the adaptive SQL query and theadaptive paging algorithm. The optimizing query methods promote the query efficiency of thesimulator database.At last the simulator database management interfaces are developed and can provide thefriendly human-machine service, such as account logging, dynamic data display and efficientdata query and so on. The safe way can be provided by account logging, the training data canbe supplied by dynamic data display and the instruction of drillmaster analysis can beprovided by efficient data queryThe real time data storage and management of HSC steering training simulator databasehas been accomplished through the research of database construct and managementtechnologies, which are very important to the analysis and evaluate the HSC steering trainingprocess.