CN106649181B - A method of for being drilled well scene while integrating WITS data and WITSML data - Google Patents

Abstract

The invention discloses a kind of methods for being drilled well scene while integrated WITS data and WITSML data, comprising: Step 1: acquiring WITS data source using socket communication and serial communication two ways；Soap protocol is used to acquire WITSML data source in a manner of XML stream；Step 2: the table of storage WITSML normal data is main table according to the various objects of WITSML standard, Object node is field, and the child node recurrence of object establishes sublist, establishes database table storing data with tree structure；Log Object table increases a data table name field, corresponding WITS data table name in WITSML, and Log object child node table LogCurveinfo table increases the field name of corresponding this Log object data table, WITS and WITSML is made to establish corresponding relationship；Step 3: the data seamless of well site database is synchronized to server on base with unified WTISML reference format by data in well database according to WITSML object tissue at WITSML data flow, and shares arrive each service provider and user simultaneously.

Description

Method for simultaneously integrating WITS data and WITSML data on drilling and completion site

Technical Field

The invention relates to a data information integration technology of a drilling and completion field in the petroleum industry, in particular to a method for simultaneously integrating WITS data and WITSML data in the drilling and completion field.

Background

The real-time integration of drilling and completion field data is a technology for collecting, storing and transmitting data of different drilling service providers in real time by adopting a computer technology, and solves the problem that well site data cannot be remotely and seamlessly shared.

For technical secrecy or other commercial reasons, the data formats provided by different drilling services to third parties are generally inconsistent, such as supporting WITS (Wellsite Information transfer Standard) format data and supporting witsms ml (Wellsite Information transfer Standard Markup Languages) format data. Some domestic mainstream software can only integrate one type of WITS data or WITSML data, and can not integrate two types of standard data at the same time, so that the drilling and completion real-time data system has data formats of different standards, the efficiency of data seamless circulation is influenced, and even a data island is formed. Under the common conditions, the drilling and completion sites are in remote areas, the network environment between the base and the sites is poor, a large amount of data can be transmitted back to the base by the data transmission software systems supporting different formats, the network bandwidth can be occupied by the data transmission software systems, network congestion is caused, the satellite network bandwidth is not conveniently and efficiently utilized, the data can be delayed to different degrees, and efficient real-time data support cannot be provided for base experts.

Disclosure of Invention

The invention aims to reduce the circulation link of well site data, remove the sharing barriers of data in different formats, provide a method for integrating WITS data and WITSML data on a drilling and completion site, store and transmit the data in a uniform format, save network bandwidth and improve the data circulation efficiency.

The technical scheme provided by the invention is as follows:

a method for simultaneously integrating WITS data and WITSML data in a drilling and completion site, comprising:

step one, adopting a socket communication or serial port communication mode to collect WITS data source; collecting WITSML data source in XML stream mode by using SOAP protocol;

step two, storing a table of WITSML standard data, taking various objects according to the WITSML standard as a main table, taking object nodes as fields, recursively establishing sub-tables by the sub-nodes of the objects, and establishing a database table by a tree structure to store data; each time a data table name field is added to a Log object table in the WITSML, the data table name field corresponds to the WITS data table name, and a field name corresponding to the Log object data table is added to a Log object sub-node table Log Curveinfo table, so that the WITS and the WITSML establish a corresponding relationship;

organizing the data in the well site database into a WITSML data stream according to the WITSML object, synchronizing the data of the well site database to a base server in a uniform WTISML standard format, and simultaneously sharing the data to each service provider and/or user.

Preferably, in the first step, the WITS data acquisition step includes:

establishing communication connection with a data source by socket or serial communication;

acquiring a data set A1 collected by a session;

read start & end flags! | A Defining a data range;

dividing the data content into data items by carriage return line feed < CR > < LF >;

splitting each data item into an identifier and a value;

and pushing the data organization to a data storage layer and storing the data storage layer into a database after the data organization is finished.

Preferably, in the first step, the WITSML data acquisition step includes:

establishing connection with a WITSML data source by adopting an SOAP protocol, and authenticating through a data source server;

acquiring information of a well W1 and a borehole WB1 which have authority and need to be transmitted;

acquiring list information of all Log objects under W1 and WB1, and selecting a Log object L1 needing to be acquired;

w1, WB1 and L1 are pushed to the data store layer and stored into the database.

Preferably, in the step two, the data storage process is as follows:

a. checking whether a public database exists in the database, creating the public database without the public database, and establishing a well basic information table to store the library name, the well name and the well hole name of the well database;

b. establishing a well database, storing WITS data table structures, and defined by the table structures defined by WITS standards; storing a WITSML data table structure, setting Log object data with the same table name as the WITS standard definition by taking an object defined by the WITSML standard as a main table, adding a field of the WITS data table name in the Log object data table, storing the WITS table name, and establishing association between the Log object and the WITS data table;

c. data from the acquisition layer is received.

Preferably, receiving data from the acquisition layer comprises the steps of:

if the data is WITS data, storing the WITS data in a corresponding WITS data table according to the field identification and the data;

when the inclinometry data of the WITS standard is received, converting the inclinometry data into a Tracjectory object in real time;

and if the data is WITSML object data, corresponding fields and node names in the object to fields in a Well table, and storing field values and node values of the object into a database.

Preferably, in step three, the step of synchronizing the data of the wellsite database to the base server comprises:

a. the communication module establishes a channel for transmitting with the base station and passes the authentication;

b. organizing WITSML object information into an XML document, compressing the XML document in a standard ZIP mode, encrypting by DES and transmitting to a base service interface;

when a Log object is transmitted, a corresponding Log data table is determined according to a data table field value defined in the Log table, a sub-object Log Curveinfo is defined as an identification field to query data in the data table, a Log data set is divided and organized by commas according to the sequence defined by the Log Cuveinfo and is merged into an XML document of the Log object, and the purpose of uniformly transmitting the data sent by a WITSML interface to the base is achieved.

Preferably, in the step one, the acquired data is filtered by using the following formula:

Y(k)＝αX(k)+(1-α)Y(k-1)

wherein,

x (k) is the original data of the k sampling period, Y (k) is the data of the k sampling period after filtering, omega is the sampling frequency,n is the raw data average value and the raw data number.

The invention has the beneficial effects that: the method for integrating WITS data and WITSML data simultaneously on the drilling and completion site provides a whole set of data acquisition, storage and transmission method for the integration of data information on the drilling and completion site, so that data can form seamless circulation and sharing among different service providers and users. The method can reduce the circulation link of well site data, remove the sharing barriers of data in different formats, improve the well site data circulation efficiency, reduce the data integration cost among different service providers of the well site, finally realize the well site data sharing of drilling and completion, and provide real-time data support for the real-time risk decision and the real-time exploration and development decision of drilling engineering.

Drawings

FIG. 1 is a flow chart of a method for simultaneously integrating WITS data and WITSML data at a well completion site in accordance with the present invention.

Detailed Description

The present invention is further described in detail below with reference to the attached drawings so that those skilled in the art can implement the invention by referring to the description text.

As shown in fig. 1, the present invention provides a method for simultaneously integrating WITS data and WITSML data in a drilling and completion site, which integrates data of two different standards by using a specific data integration algorithm and a database structure according to the existing WITS standard and WITSML standard, and stores and transmits the data in a uniform format, thereby finally achieving the purposes of saving network bandwidth and improving data transfer efficiency.

The invention describes a technical scheme from three parts, specifically as follows:

step one S110, data acquisition

The data sources of data acquisition are divided into a WITS data source and a WITSML data source, the data standards and protocols adopted by the two data sources are different, and the two data sources are acquired separately. The WITS data source acquisition adopts two modes of socket communication and serial port communication, and the WITSML data source adopts an SOAP protocol to acquire data in an XML stream mode.

a. WITS data acquisition step:

establishing communication connection with a data source by socket or serial communication;

acquiring a data set A1 collected by a session;

read start & end flags! | A Defining a data range;

splitting the data content into data items with carriage return linefeed < CR > < LF >, such as 08133561.35;

splitting each data item into an identifier and a value, such as a 0813 identifier, representing the 13-way of the WITS _8 table, 3561.35 representing the value;

and pushing the data organization to a data storage layer and storing the data storage layer into a database after the data organization is finished.

b. WITSML data acquisition step:

establishing connection with a WITSML data source by adopting an SOAP protocol, and authenticating through a data source server;

acquiring Well (Well) W1 and borehole (Well) WB1 (object information;

acquiring list information of all Log objects under W1 and WB1, and selecting a Log object L1 needing to be acquired;

w1, WB1 and L1 are pushed to the data store layer and stored into the database.

Step two S120, data storage

The database is divided into a public database and a well database, the public database stores the basic information of all wells, the well database stores the real-time data information of the well drilling and completion, and each well corresponds to a separate well database. And establishing a table for storing WITS standard data in the well database according to a structure defined by the WITS standard, adding Greenwich time label fields, and reserving a plurality of standby fields for system expansion. The table for storing WITSML standard data takes various objects of WITSML standard as a main table, object nodes as fields, sub-nodes of the objects recursively establish sub-tables, and a database table is established by a tree structure to store data. A data table name field is added in a Log object table in the WITSML and corresponds to the WITS data table name, and a field name corresponding to the Log object data table is added in a Log object sub-node table Log Curveinfo table, so that the WITS and the WITSML establish a corresponding relationship.

a. And checking whether a public database exists in the database, creating the public database without the public database, and establishing a well basic information table to store configuration information such as a library name, a well bore name and the like of the well database.

b. The well database is established, the WITS data table structure is stored and defined by the table structure defined by the WITS standard, for example, as defined in the WITS _8 standard, shortMnemonic is used as the field name, the field type is the type defined by the standard, and 15 spare fields are added to be used as the system extension. Storing the WITSML data table structure, taking objects defined by WITSML standard as a main table, such as appendix Well Well W1, wherein Well is a table name, fields in the objects and node names are fields in the Well table, such as uid, name and the like, and field types are field types defined by the Well objects, creating a sub-table when multiple levels of different word nodes exist, such as Welllocation nodes, creating a Welllocation table, and adding a parent object name field and an identification field of a parent object to establish the master-slave association of the parent object name field and the identification field of the parent object. The system is internally provided with Log object data with the same table name as that defined by the WITS standard, a field of the WITS data table name is added in the Log object data table, and the WITS table name is stored, so that the Log object and the WITS data table are associated. And adding a field name corresponding to the data table corresponding to the Log object in the Log object child node table Log Curveinfo table, so that the WITS and WITSMLLog object parameters establish a corresponding relation.

c. Receiving data from the acquisition layer:

if the data is WITS data, the data is stored in a corresponding WITS data table according to the field identification and the data. The invalid data verification method of the depth reference table comprises the following steps: if the depth of the data is less than the depth data of the depth reference table, the data belongs to invalid data, and the data is written into a log file and is not written into a database. The gas meter invalid data verification method comprises the following steps: if the depth of the data is larger than the depth data of the depth reference table, the data belongs to invalid data, and the data is written into a log file and is not written into a database. The WITS table adds a specific greenwich time field, the greenwich time format storing the time stamp is year (4 bits) month (2 bits) day (2 bits) + seconds of the day (5 bits), the total number of bits is 13 bits, e.g., 0 point 0 minute 0 second expressed as 2016010100000 for 1 month 1 year 2016;

when the inclinometry data of the WITS standard is received, the inclinometry data is converted into a Tracjectory object in real time according to the configuration parameters;

if the object data is WITSML data such as appendix W1, corresponding fields and node names in the object to fields in a Well table, and storing field values and node values of the object in a database;

when a Log object is received, firstly, an identifier defined by the Log object is used as a data table name, an identifier of a defined curve set is used as a field name, and a floating point is used for establishing a Log object data table for a data type. When the Log object is analyzed to the data set Log data, each data is divided according to commas, and the data is stored in a Log object data table according to a defined curve sequence.

Step three S130, data transmission

Organizing data in the well database into WITSML data streams according to WITSML objects, seamlessly synchronizing the data of the well site database to a base server in a unified WTISML standard format, and simultaneously sharing the data to various service providers and users.

a. The communication module establishes a channel for transmission with the base station, and passes authentication thereof.

b. And selecting WITSML object information needing to be transmitted.

c. Organizing WITSML object information into an XML document, such as a Well object, organizing data according to format information defined by the standard, corresponding fields in a Well table in a Well database to fields and node names of the Well object to obtain value information of the Well object, filling the value information into the Well object to form the Well object XML document, compressing the XML document in a standard ZIP mode, encrypting the XML document by DES (data encryption standard) and transmitting the encrypted XML document to a base service interface. When a Log object is transmitted, a corresponding Log data table is determined according to a data table field value defined in the Log table, a curve parameter data field defined by a sub object Log Curveinfo of the Log data table is used as an identification field to query data in the data table, a Log data set is formed by comma division according to the sequence defined by the Log Cuveinfo and is combined into an XML document of the Log object, and the purpose of uniformly transmitting data to a base by a WITSML interface is achieved.

The invention provides a whole set of data acquisition, storage and transmission method for the integration of the data information of the drilling and completion field, so that the data can be seamlessly transferred and shared among different service providers and users. The method can reduce the circulation link of well site data, remove the sharing barriers of data in different formats, improve the well site data circulation efficiency, reduce the data integration cost among different service providers of the well site, finally realize the well site data sharing of drilling and completion, and provide real-time data support for the real-time risk decision and the real-time exploration and development decision of drilling engineering.

While embodiments of the invention have been described above, it is not limited to the applications set forth in the description and the embodiments, which are fully applicable in various fields of endeavor to which the invention pertains, and further modifications may readily be made by those skilled in the art, it being understood that the invention is not limited to the details shown and described herein without departing from the general concept defined by the appended claims and their equivalents.

Claims (5)

1. A method for simultaneously integrating WITS data and WITSML data in a well drilling and completion site, comprising:

step one, adopting a socket communication or serial port communication mode to collect WITS data source; collecting WITSML data source in XML stream mode by using SOAP protocol; and filtering the acquired data by adopting the following formula:

Y(k)＝αX(k)+(1-α)Y(k-1)

wherein,

x (k) is the original data of the k sampling period, Y (k) is the data of the k sampling period after filtering, omega is the sampling frequency,the average value of the original data is obtained, and n is the number of the original data;

step two, storing a table of WITSML standard data, taking various objects according to the WITSML standard as a main table, taking object nodes as fields, recursively establishing sub-tables by the sub-nodes of the objects, and establishing a database table by a tree structure to store data; each time a data table name field is added to a Log object table in the WITSML, the data table name field corresponds to the WITS data table name, and a field name corresponding to the Log object data table is added to a Log object sub-node table Log Curveinfo table, so that the WITS and the WITSML establish a corresponding relationship;

the data storage process comprises the following steps:

a. checking whether a public database exists in the database, creating the public database without the public database, and establishing a well basic information table to store the library name, the well name and the well hole name of the well database;

b. establishing a well database, storing WITS data table structures, and defined by the table structures defined by WITS standards; storing a WITSML data table structure, setting Log object data with the same table name as the WITS standard definition by taking an object defined by the WITSML standard as a main table, adding a field of the WITS data table name in the Log object data table, storing the WITS table name, and establishing association between the Log object and the WITS data table;

c. receiving data from an acquisition layer;

organizing the data in the well site database into a WITSML data stream according to the WITSML object, synchronizing the data of the well site database to a base server in a uniform WTISML standard format, and simultaneously sharing the data to each service provider and/or user.

2. The method for simultaneously integrating WITS data and WITSML data in a drilling and completion site as recited in claim 1 wherein in step one, the WITS data collection step comprises:

establishing communication connection with a data source by socket or serial communication;

acquiring a data set A1 collected by a session;

read start & end flags! | A Defining a data range;

dividing the data content into data items by carriage return line feed < CR > < LF >;

splitting each data item into an identifier and a value;

and pushing the data organization to a data storage layer and storing the data storage layer into a database after the data organization is finished.

3. The method for simultaneously integrating WITS data and WITSML data in a drilling and completion site as recited in claim 1 wherein in step one, the WITSML data collection step comprises:

establishing connection with a WITSML data source by adopting an SOAP protocol, and authenticating through a data source server;

acquiring information of a well W1 and a borehole WB1 which have authority and need to be transmitted;

acquiring list information of all Log objects under W1 and WB1, and selecting a Log object L1 needing to be acquired;

w1, WB1 and L1 are pushed to the data store layer and stored into the database.

4. The method for simultaneously integrating WITS data and WITSML data in a drilling and completion site according to claim 3 wherein receiving data from the acquisition layer comprises the steps of:

if the data is WITS data, storing the WITS data in a corresponding WITS data table according to the field identification and the data;

when the inclinometry data of the WITS standard is received, converting the inclinometry data into a Tracjectory object in real time;

and if the data is WITSML object data, corresponding fields and node names in the object to fields in a Well table, and storing field values and node values of the object into a database.

5. The method for simultaneously integrating WITS data and WITSML data in a drilling and completion site of claim 1, wherein in step three, the step of synchronizing the wellsite database data to the base server comprises:

a. the communication module establishes a channel for transmitting with the base station and passes the authentication;

b. organizing WITSML object information into an XML document, compressing the XML document in a standard ZIP mode, encrypting by DES and transmitting to a base service interface;

when a Log object is transmitted, a corresponding Log data table is determined according to a data table field value defined in the Log table, a sub-object Log Curveinfo is defined as an identification field to query data in the data table, a Log data set is divided and organized by commas according to the sequence defined by the Log Cuveinfo and is merged into an XML document of the Log object, and the purpose of uniformly transmitting the data sent by a WITSML interface to the base is achieved.