The Integrated Application Of Database Technology In The Gas Transferring Monitor System

Real-time database is used to store the production data acquired by variety of monitoring equipments. The production control system relies on the data provided by real-time database to show the production process, critical components and regional state. This provides a data query and statistics. Real-time database focuses on real-time data, so it is designed by emphasizing the high-speed reading and writing, simple storage structures, efficient data management and simplified historical database. Therefore, data consistency, security and other requirements are ignored, and this result some data are invalid. Real-time database is unable to support large-scale integration while providing data to applicated system due to its huge amount of storage. Besides, it can not provide effective guidance and analysis in managing or decision-making.This article through a combination of China National Petrochemical gas transmission pipeline of a company to monitor the project's actual case history, with a focus on study and discussion on gas pipeline monitoring, live production data in the database through the data synchronization tool in the transport to the relational database ORACLE, scheduled data synchronization tool to start its operation, to package data transfer via a SOCKET interface to the relationship after the database server data on the receiving end. Receive programs in unpacking, restructure, filter the data meaningless data, added to the production data in a relational database. The functional separation of the application data.Database to collect and store field collection data in real time, only to the local control system provides status information for each monitoring point of querying and monitoring using statistical functions. Using relationship database storage by data synchronization tools sent to of production data, to various application system provides production data query, to support daily management in the various large query, implementation production data value of maximize, and provides perfect of data interface, on data of effective and consistency provides protection, can to MIS system, and OA system, and various production report, and data statistics, and games dimension system, and decision support system, provides production data.