CN107180086A - A kind of drilling well real time data quick storage and dissemination method - Google Patents
A kind of drilling well real time data quick storage and dissemination method Download PDFInfo
- Publication number
- CN107180086A CN107180086A CN201710320836.3A CN201710320836A CN107180086A CN 107180086 A CN107180086 A CN 107180086A CN 201710320836 A CN201710320836 A CN 201710320836A CN 107180086 A CN107180086 A CN 107180086A
- Authority
- CN
- China
- Prior art keywords
- real
- storage
- time
- drilling well
- time data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of drilling well real time data quick storage and dissemination method, including Multi-thread synchronization memory module, real-time storage module, historical storage module, real-time release module and historical query module, wherein：The drilling well real time data collected is synchronized to real-time storage module and historical storage module by Multi-thread synchronization memory module respectively；Real-time storage module only carries out storage management to the real time data of nearest a period of time；Historical storage module stores all drilling well real time datas；Real-time release module calls real time data to carry out real-time release from real-time storage module；Historical query module polls call the drilling well real time data stored in historical storage module.Using this method, in the efficiency for ensureing drilling well real time data quick storage and real-time release simultaneously, the problem of RTDB in Industry Control the inquiry of historical data inefficiency and higher working service cost can be solved.
Description
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.
Claims (4)
1. a kind of drilling well real time data quick storage and dissemination method, it is characterised in that：Including Multi-thread synchronization memory module, reality
When memory module, historical storage module, real-time release module and historical query module, wherein：Multi-thread synchronization memory module will
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
The real time data of a period of time carries out storage management；Historical storage module stores all drilling well real time datas；Real-time release mould
Block calls real time data to carry out real-time release from real-time storage module；Historical query module polls are called in historical storage module
The drilling well real time data of storage.
2. a kind of drilling well real time data quick storage according to claim 1 and dissemination method, it is characterised in that：Described
Multi-thread synchronization module, the drilling well real-time data synchronization collected is stored into specified multiple databases, each database number
It is consistent according to entry time and integrality.
3. a kind of drilling well real time data quick storage according to claim 1 and dissemination method, it is characterised in that：Described
Real-time storage module, carries out drilling well real time data real-time storage, it is small that the real-time data memory term of validity is set to 2 using KV databases
When, the real time data for storing over 2 hours is removed automatically.
4. a kind of drilling well real time data quick storage according to claim 1 and dissemination method, it is characterised in that：Described
Historical storage module is using all real time datas of relational data library storage, according to business relations such as individual well distribution storage drilling well
There is provided structuralized query service for real time data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710320836.3A CN107180086A (en) | 2017-05-09 | 2017-05-09 | A kind of drilling well real time data quick storage and dissemination method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710320836.3A CN107180086A (en) | 2017-05-09 | 2017-05-09 | A kind of drilling well real time data quick storage and dissemination method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107180086A true CN107180086A (en) | 2017-09-19 |
Family
ID=59832473
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710320836.3A Pending CN107180086A (en) | 2017-05-09 | 2017-05-09 | A kind of drilling well real time data quick storage and dissemination method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107180086A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109040280A (en) * | 2018-08-21 | 2018-12-18 | 杭州安恒信息技术股份有限公司 | A kind of method and system based on Web monitoring industrial control equipment realtime curve |
| CN109704199A (en) * | 2018-12-29 | 2019-05-03 | 明光利拓智能科技有限公司 | A kind of multithreading bridge crane data acquisition processing system and method |
| CN109710580A (en) * | 2018-12-29 | 2019-05-03 | 明光利拓智能科技有限公司 | A kind of multithreading bridge crane data collection system and method |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101916292A (en) * | 2010-08-26 | 2010-12-15 | 中国石油集团川庆钻探工程有限公司 | Petroleum well field real-time data storage management method based on industrial real-time database |
| CN104424210A (en) * | 2013-08-22 | 2015-03-18 | 腾讯科技（深圳）有限公司 | Information recommendation method, information recommendation system and server |
-
2017
- 2017-05-09 CN CN201710320836.3A patent/CN107180086A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101916292A (en) * | 2010-08-26 | 2010-12-15 | 中国石油集团川庆钻探工程有限公司 | Petroleum well field real-time data storage management method based on industrial real-time database |
| CN104424210A (en) * | 2013-08-22 | 2015-03-18 | 腾讯科技（深圳）有限公司 | Information recommendation method, information recommendation system and server |
Non-Patent Citations (1)
| Title |
|---|
| 张崭: "基于组态软件的电力系统实时数据库设计与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109040280A (en) * | 2018-08-21 | 2018-12-18 | 杭州安恒信息技术股份有限公司 | A kind of method and system based on Web monitoring industrial control equipment realtime curve |
| CN109704199A (en) * | 2018-12-29 | 2019-05-03 | 明光利拓智能科技有限公司 | A kind of multithreading bridge crane data acquisition processing system and method |
| CN109710580A (en) * | 2018-12-29 | 2019-05-03 | 明光利拓智能科技有限公司 | A kind of multithreading bridge crane data collection system and method |
| CN109704199B (en) * | 2018-12-29 | 2020-02-04 | 明光利拓智能科技有限公司 | Multithreading bridge crane data acquisition processing system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107168263B (en) | A kind of knitting MES Production-Plan and scheduling method excavated based on big data | |
| CN105005570B (en) | Magnanimity intelligent power data digging method and device based on cloud computing | |
| CN105608144B (en) | A kind of big data analysis stage apparatus and method based on multilayered model iteration | |
| CN105427193B (en) | A kind of big data analysis device and method based on distributed time series data service | |
| CN104462314B (en) | Power grid data processing method and device | |
| CN110599034B (en) | Dynamic management tracking system of oil extraction plant and early warning method thereof | |
| CN106651633A (en) | Power utilization information acquisition system and method based on big data technology | |
| CN107180086A (en) | A kind of drilling well real time data quick storage and dissemination method | |
| CN106897839A (en) | A kind of data integrated collaboration platform in well site | |
| CN105549557A (en) | Real-time dynamic 3D water balance monitoring system of power plant and working method of system | |
| CN101566981A (en) | Method for establishing dynamic virtual data base in analyzing and processing system | |
| CN106202346A (en) | A kind of data load and clean engine, dispatch and storage system | |
| US20140180461A1 (en) | Real-time activity planning and monitoring of activity execution | |
| CN101964081A (en) | Production information system based on factory management infrastructure platform | |
| CN103902537A (en) | Multi-service log data storage processing and inquiring system and method thereof | |
| CN108733850A (en) | A kind of power grid big data analysis excavation application system | |
| CN106022617A (en) | Inspection control system based on marketing multi-system data center | |
| CN105956016A (en) | Associated information visualization processing system | |
| CN103366248A (en) | Construction method of petroleum exploration and development multi-specialized information integrated platform | |
| CN105205185B (en) | The method of data interaction and data modeling between monitoring system and management information system | |
| CN107844964A (en) | A kind of shield construction information management system | |
| CN109242248A (en) | Cigarette machine multidimensional data comprehensive analysis platform and method | |
| CN111538720B (en) | Method and system for cleaning basic data of power industry | |
| CN109711658A (en) | A kind of industrial production optimizing detection system and method | |
| Hongliang et al. | Management and instant query of distributed oil and gas production dynamic data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200924 Address after: 100007 Beijing, Dongzhimen, North Street, No. 9, No. Applicant after: CHINA NATIONAL PETROLEUM Corp. Applicant after: CNPC Chuanqing Drilling Engineering Co.,Ltd. Address before: Chenghua District Green Road 610051 Chengdu City, Sichuan province 1 No. 3 Chuanqing drilling Department of Science & Technology Applicant before: CNPC Chuanqing Drilling Engineering Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170919 |
|
| RJ01 | Rejection of invention patent application after publication |