Research On Network-version Of Mine Ventilation Simulation System Database Key Technology

The Network-version of Mine Ventilation Simulation System which is developed by Liaoning Technical University is not only the most powerful tools for mine ventilation of the daily management, analysis and evaluation, design ,optimization and modification but also could meet the needs of office automation for the Mining Group.Tt is a set of network information for intelligent ventilation management system. This article research and design of the database technology for the system which is based onNetwork-version of Mine Ventilation Simulation System. In this paper, some technology are theoretical studied , for example the database backup, data replication, concurrency control, locking mechanism and so on.On this basis, it establish the database model ofNetwork-version of Mine Ventilation Simulation System. The model realizes the data synchronization and database query between databases of client at all levels of Network-version of Mine Ventilation Simulation System.Tt makes the backup database to have a real-time replication on the master database and solve the conflict when multi-user simultaneous access to the same data in the database through the concurrency control theory and the database locking and isolation mechanisms of the SQL Server. Ensure integrity and consistency of the data.In this paper, the study of the database technology and the realization of database model have brought new ideas for theNetwork-version of Mine Ventilation Simulation Systemto improve and ensure it's normal operation.