基于SQL Server的矿井通风信息实时共享模块的设计

Design of the Real Time Share Module for Mine Ventilation Information Based on SQL Server

为了实现煤矿的安全生产及信息化管理,大多数煤矿安装了具有相应功能的系统,但各系统均存在信息量大、系统之间不能兼容、实时数据共享性差等不足。针对上述问题,提出了一种基于SQL Server的实现实时数据共享的方法。该方法首先设计、建立基于SQL的共享数据库,采用自定义存储过程,然后利用创建应用程序定时调用存储过程,实现了矿区安全生产监测监控系统数据与通风系统信息的实时共享。该方法具有可行性与实用性,可以实现系统的兼容、实时数据的共享、减小系统数据库的负担、增强系统可靠性。

In order to realize the safe production and information-oriented management for coalmines, most of coalmines have at present installed the systems with such corresponding functions as the monitoring system for safe production, assistant system for ventilation and prevention of disasters, and so on. But there are some deficiencies in these systems like huge information, incompatibility among the systems, and bad sharing of the real time data. According to such deficiencies, a method is provided to realize the real time data share based on SQL server. Firstly, this method designs and creates the shared database based on SQL server by using self-defined storage process; then, it creates the program to call the storage process by setting time. This method is used in the coalmines, realizing the share of monitoring data and ventilation system information. The method has its feasibility and practicability, and the method can realize the system compatibility, the share of real time data, decrease the burden of monitoring system database, and enhance the system reliability.