A kind of drilling well real time data quick storage and dissemination method
Technical field
The present invention relates to the drilling well real-time data memory field of oil-gas exploration and development, a kind of drilling well is specifically related to real-time
Data quick storage and dissemination method.
Background technology
Drilling well is one of important step in petroleum exploration and development operation flow.And to all kinds of of generation in drilling process
Information is acquired and analyzed and processed, and is to grasp drilling state, subsurface picture found out, so as to adjust drillng operation in time, it is ensured that
The important means that drilling well mesh is realized, wherein again mostly important with the acquisition process of drilling well real time data.Drilling well real time data is by boring
The various kinds of sensors at well scene is gathered in real time, is broadly divided into three classes, a class is the project data relevant with drilling engineering machinery, such as
The data such as the pressure of the drill, weight on hook, well depth, vertical pressure, pump speed, rotary speed, TORQ, a class is the drilling fluid relevant with drilling well
Data, such as drilling fluid temperature, density, electrical conductivity, volume flow data, a class be by a class be with concentration of natural gas and its into
Relevant gas is divided to survey data, such as total hydrocarbon, hydrocarbon component, CQ2, H2, H2S, in recent years, with well logging, the hair of guiding technique
Exhibition, it is newly-increased to acquire with oblique, lithology of drilling well etc. with brill real time data.Drilling well real time data as situ of drilling well first-hand money
Material, is monitoring drilling state, finds in time and the extremely necessary significant process data of predictive engine, is also optimization drilling plan
Important achievement reference with carrying out drilling geology research.So domestic and international oil drilling enterprise all greatly develops brill since the eighties
Well real-time data acquisition delivery system, by being managed for site operation personnel and rear end and scientific research personnel provides showing promptly and accurately
Drilling well real time data, to ensure smoothly completing for Drilling Design and construction task.
Drilling well real-time data acquisition delivery system to the storage issue of drilling well real time data it is ageing have with uniformity compared with
High requirement, such as drilling well real-time data acquisition storing frequencies are all 1-3 seconds interval Coutinuous stores, and drilling well real time data is remotely supervised
The control application requirement drilling well real-time data warehouse time is not later than the on-site data gathering time 2 seconds, and data coincidence must reach
100%.The continuous drilling well real-time data memory of magnanimity and processing work, traditional structured database are completed at the appointed time
There is many bottlenecks.So the base end central database of drilling well real-time data acquisition delivery system is mainly counted in real time using industry
The long-range storage and issuing service of drilling well real time data are carried out according to storehouse(See Fig. 1).RTDB in Industry Control is in conventional relationship data
On the basis of storehouse, it can be docked with drilling well real-time data acquisition system, with efficient data compression and storage efficiency, branch
Real time data second level Coutinuous store, real-time release and historical query are held, is to build industrial production Dispatching monitor and control system, commander system
System, the indispensable basic software at production real-time history data center.Live domestic conventional real-time data base have GE,
InfoPlus, PI, Uniformance, ONSPEC etc..Compared to traditional relevant database, RTDB in Industry Control is to real-time
The storage of data and efficiency for issuing are higher.
With the strengthened research of drilling well real time data, RTDB in Industry Control industry exposes some problem and shortage:First,
With the development of the work of distance drilling support in recent years work integrated with producing scientific research, the historical query to drilling well real time data is sent out
Cloth demand all increases with year, but RTDB in Industry Control emphasizes the Efficient Compression and mass memory of data, and the history of real time data is looked into
Function deficiency is ask, the specified a certain interval censored data inquiry of individual well is needed 1 minute or even the longer time, it is impossible to meet newly
Drilling well real time data application demand.Second, although RTDB in Industry Control has preferable real-time storage efficiency, but industry is in real time
Database is from traditional relevant database because data tissue is different with access mode so that using the drilling well of real-time data base
Real-time monitoring system can not be docked directly with using the drilling geology analysis classes system software of relevant database so that drilling well is real
When data sharing issue it is difficult, have impact on drilling well real time data application effect.3rd, RTDB in Industry Control expense is compared with relationship type
Data are high, and real-time data base, which is installed, safeguards also cumbersome, higher to personnel's technical requirements.Cause the purchase of RTDB in Industry Control
With maintenance cost also high, the more difficult burden of general medium-sized and small enterprises compared with traditional database.
The content of the invention
It is contemplated that for the defect present in above-mentioned prior art and deficiency, there is provided a kind of drilling well real time data is quick
Storage and dissemination method, using this method, in the efficiency for ensureing drilling well real time data quick storage and real-time release simultaneously, can be solved
The problem of certainly RTDB in Industry Control the inquiry of historical data inefficiency and working service cost are higher.
The present invention is realized by using following technical proposals:
A kind of drilling well real time data quick storage and dissemination method, it is characterised in that:Including Multi-thread synchronization memory module, in real time
Memory module, historical storage module, real-time release module and historical query module, wherein:Multi-thread synchronization memory module will be adopted
The drilling well real time data collected is synchronized to real-time storage module and historical storage module respectively;Real-time storage module is only to nearest one
The real time data of section time carries out storage management;Historical storage module stores all drilling well real time datas;Real-time release module
Real time data is called to carry out real-time release from real-time storage module;Historical query module polls are called to be deposited in historical storage module
The drilling well real time data of storage.
Described Multi-thread synchronization module, the drilling well real-time data synchronization collected is stored to specified multiple databases
In, each database data entry time and integrality are consistent.
Described real-time storage module, drilling well real time data real-time storage is carried out using KV databases, supports the reality of second level
When data storage and processing task, the real-time data memory term of validity is traditionally arranged to be 2 hours or so, stores over the reality of 2 hours
When data remove automatically.
Described historical storage module, can be according to business relations using all real time datas of relational data library storage
Such as individual well distribution storage drilling well real time data, there is provided structuralized query service.
Described Multi-thread synchronization memory module, real-time storage module and historical storage module, is the innovation institute of the present invention
Its principle is as follows:Traditional single RTDB in Industry Control storage mode is changed into non-relational database and relationship type number
Storage mode is combined according to storehouse.Real-time storage and historical storage are carried out respectively according to application, and real-time release is provided separately and is looked into history
Ask service.
Compared with prior art, what the present invention was reached has the beneficial effect that:
First, drilling well real time data historical query efficiency is improved, traditional RTDB in Industry Control the inquiry of historical data is with 1 mouthful
Exemplified by 1 day the inquiry of historical data of well, 1-5 minutes are generally required, the single structured database of use carries out history number
According to storage issue, the 1 day the inquiry of historical data time of 1 mouthful of well was foreshortened within 10 seconds.
Second, drilling well real time data real-time storage and efficiency for issuing are improved, because real-time storage module is only responsible for reality
Shi Fabu provides data, services, it is not necessary to undertake historical storage task, it is only necessary to storage nearest a period of time(2-12 hours)'s
Real time data, it is to avoid the when queueing delay problem that occurs that magnanimity real time data is stored, resource occupation amount is also smaller, in real time
Efficiency for issuing is higher.
3rd, distributed data storage method, multiple users are simultaneously when can avoid the storage issue of traditional centralized database
To request in real time and historical data issue when cause to delay machine the problem of, improve the stability of whole real-time dataBase system, again
Take into account real-time issue and issue two functions with history quick search.
4th, non-relational data can carry out quick real-time storage, it is ensured that the promptness of drilling well real-time data memory, simultaneously
Historical storage is individually carried out using relevant database, more complicated data query and application can be supported, can be more efficiently
Other users or systems with data interface service.
5th, using the non-pass relational data increased income with relevant database as compared with RTDB in Industry Control, its is soft
Part cost is lower, and popularization degree is also higher, and technical staff is also higher to familiarity, requires relatively low to technical staff, is easy to number
Safeguard and developed with data application according to storehouse, be adapted to general medium-sized and small enterprises application.
Brief description of the drawings
Below in conjunction with specification drawings and specific embodiments, the present invention is described in further detail, wherein:
Fig. 1 is RTDB in Industry Control data storage release model figure;
Fig. 2 is logical constitution figure of the invention.
Embodiment
Embodiment 1
As the better embodiment of the present invention, in original drilling well real-time data acquisition delivery system(Fig. 1)On the basis of, newly
Increase data multi-wire journey with cloth memory module, real-time data memory mode is changed into real-time storage and deposited with history by historical storage module
Two parts are stored up, real-time release and historical query service is separately provided.Whole method is made up of 5 technology modules.
Multi-thread synchronization memory module, the drilling well real time data received is stored to real-time storage respectively by multithreading
Module(Non-relational database)With historical storage module(Relevant database).
Real-time storage module, replaces traditional industry real-time data base to carry out real-time using the KV databases of non-relational
Storage and issue, data are stored directly in memory block and issued.
Historical storage module, is stored using relevant database to drilling well real time data, real-time according to well relation pair
Data carry out structured storage.
Real-time release module, reads and is stored in real time data in internal memory KV databases, by SOCKET or
WEBSERVICE modes are issued, and support real time data continuously to visualize application.
Historical query module can carry out interval and essence there is provided the SQL query service of versatility, user to drilling well real time data
Really inquiry.
The innovative point of the present invention is:Non-relational database+relevant database combination realizes that drilling well is counted in real time
According to quick storage and issue.Its principle is as follows:
Traditional single RTDB in Industry Control storage mode is changed into non-relational database combined with relevant database and deposited
Storage mode.
Real-time storage and historical storage are carried out respectively according to application, and real-time release and historical query service is provided separately.
Embodiment 2
As the preferred forms of the present invention, passed as shown in Fig. 2 will first gather and be transmitted back to next drilling well real time data from data
After defeated queue is taken out, synchronous storage(Using multiple threads)To KV databases and SQLite databases.KV real-time data bases enter
The quick real-time storage of row, only stores the drilling well real time data within nearest 2 hours, the data more than 2 hours are removed automatically.
SQLite databases carry out historical storage, store all drilling well real time datas.Pass through real-time release module(Real-time SOCKET)
With historical query module(History SOCKET)The real-time release and historical query demand of user is met respectively.Real-time release module pair
Data in KV databases carry out real-time release, generation real time data list and curve.Historical query module is adjusted by SQL query
With the data in SQLite databases, drilling well real time data can be issued on a time period, and data are provided and is downloaded and migration service.