煤矿安全监控历史数据库动态维护研究及应用

The Research about Dynamic Maintenance of Historic Database in Monitoring System for Mine Safety and Its Applicatio

摘要: 在大型监控系统中,历史数据的海量增长成为影响服务器运行稳定性和效率的主要障碍。文章结合淮北煤矿安全监控系统的实际情况,就SQL Server2000数据库在煤矿监控系统的动态维护过程中,如何保障数据库安全、动态创建和读/写配置文件及动态维护数据库中海量数据提出了具体的解决办法,实现了数据的动态维护。为大型数据库的自动维护提供了一种切实有效的参考方法。
- 煤矿 /
- 安全监控 /
- SQLServer数据库 /
- 数据安全 /
- 数据维护
Abstract: The increasing of historic data is the main obstruction of the server’s stability and efficiency in large monitoring system.Combining with the monitoring system for coal mine safety of Huaibei,the paper put forward a solution scheme how to ensure the safety of database,configuration file of automation creation/writing/reading,and realized the data maintenance,which provided an effective and realiable method for automation maintenance of large database.
- coal mine /
- monitoring for safety /
- SQL Server database /
- data safety /
- data maintenance