Digital mining and transmitting system for drilling and completion engineering

Abstract

The invention discloses a digital acquisition and transmission system for drilling and completion engineering. The system comprises data acquisition equipment and a data processing terminal, the data processing terminal comprises a data standardization module; the data acquisition equipment is used for acquiring data related to each drilling well, converting the data into digital signals and transmitting the digital signals to the data processing terminal through a communication interface; the data standardization module is used for conducting standardization processing on the data, received by the data processing terminal, of the different drilling wells according to set data standards and storing the data obtained after standardization processing in a database. By means of the scheme, the informatization degree of engineering technology production operation management of overseas projects can be improved.

Description

Technical Field

[0001] The invention relates to the field of digitalization of drilling and completion engineering, and in particular to a digital acquisition and transmission system for drilling and completion engineering. Background Art

[0002] At present, the informatization of production and operation management of domestic drilling and completion engineering technology has made great progress, but overseas projects are still in the primary stage. Overseas projects are scattered, and the language, unit, time, file, and data format are not unified, which brings great difficulties to the standardized data collection; most overseas projects use satellite small station communication (VSAT), and its maximum rate is only 2Mbps, that is, 3G speed, which brings serious challenges to the efficient, stable and secure transmission of data; the databases and application systems between professions are independent of each other, lacking an overall data sharing architecture, forming data islands, single data statistical analysis methods, low data integration efficiency, and difficulty in realizing efficient data sharing and application. The data management and data use systems are not well connected, and data acquisition, processing, review, loading, data return calculation and update cannot be completed in time, which directly affects the next step of work. Summary of the invention

[0003] The present invention provides a digital acquisition and transmission system for drilling and completion engineering to improve the informatization level of engineering technology, production and operation management of overseas projects.

[0004] To this end, the present invention provides the following technical solutions:

[0005] A digital data acquisition and transmission system for drilling and completion engineering, the system comprising: a data acquisition device and a data processing terminal; the data processing terminal comprises a data standardization module;

[0006] The data acquisition device is used to collect the drilling related data, convert the data into digital signals, and transmit them to the data processing terminal through the communication interface;

[0007] The data standardization module is used to perform standardization processing on the data of different wells received by the data processing terminal according to the set data standard, and store the standardized data in the database.

[0008] Optionally, the database is a relational database, and the table structure of the relational database includes: table name, field name, data type, and index.

[0009] Optionally, the data standardization module includes:

[0010] A preprocessing unit, used for cleaning and preprocessing the data;

[0011] A mapping alignment unit, used to map the data processed by the preprocessing unit to target data, and perform field alignment and conversion to obtain standardized data;

[0012] A verification unit is used to verify the standardized data.

[0013] Optionally, the preprocessing includes any one or more of the following: removing noise in the data, and supplementing missing values.

[0014] Optionally, the conversion includes multi-language and multi-time zone conversion.

[0015] Optionally, the data processing terminal further includes: a data analysis module, configured to perform data analysis and mining on the standardized data, and generate analysis results and reports.

[0016] Optionally, the analysis results and reports include any one or more of the following information: visual charts, statistical data.

[0017] Optionally, the data processing terminal further includes: a data monitoring module, which is used to periodically obtain real-time data from the database or cache and display the real-time data on a monitoring interface.

[0018] Optionally, the data processing terminal further comprises: a query module, configured to provide a user with a query function for the database.

[0019] Optionally, the system further comprises: an application terminal, used for displaying the standardized data, the analysis results and the report to a user.

[0020] The digital data collection and transmission system for drilling and completion projects provided by the present invention can simultaneously collect relevant data at different stages of drilling and completion projects in real time, such as drilling, logging, directional, logging, cementing, drilling fluid and other data, realize automatic collection, analysis and transmission of dynamic data from different service providers, different instruments and different data transmission methods, support data access from a variety of mainstream instruments in the world; realize automatic generation and export of complex production reports such as drilling monthly reports and drilling rig operation reports.

[0021] Furthermore, the digital data collection and transmission system for drilling and completion engineering provided by the present invention can realize the switching of English and Chinese languages ​​of the underlying data and the automatic conversion of metric, imperial and mixed units in different application terminals. BRIEF DESCRIPTION OF THE DRAWINGS

[0022] Figure 1 It is a structural schematic diagram of a digital acquisition and transmission system for drilling and completion engineering provided by the present invention;

[0023] Figure 2 is a structural diagram of a data standardization module in an embodiment of the present invention;

[0024] Figure 3 It is a structural schematic diagram of a data processing terminal in the system of the present invention;

[0025] Figure 4 It is a structural schematic diagram of a data processing terminal in the system of the present invention;

[0026] Figure 5 It is another structural schematic diagram of the digital acquisition and transmission system for drilling and completion engineering provided by the present invention. DETAILED DESCRIPTION

[0027] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention, and for ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0028] The present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments. The embodiments cannot be described one by one here, but the embodiments of the present invention are not therefore limited to the following embodiments.

[0029] Due to the scattered distribution of overseas drilling projects, the language, unit, time, file, and data format are not unified, which brings great difficulties to the standardized data collection, low transmission rate, lack of overall architecture design, imperfect data docking between data management and data use systems, and data acquisition, processing, review, loading, data return calculation and update cannot be completed in time, which directly affects the next step of work. To this end, the present invention provides a digital acquisition and transmission system for drilling and completion engineering to effectively improve the informatization level of engineering technology production and operation management of overseas projects.

[0030] like Figure 1 The figure shows a structural schematic diagram of the digital acquisition and transmission system for drilling and completion engineering provided by the present invention.

[0031] The digital data acquisition and transmission system for drilling and completion engineering includes the following modules: data acquisition equipment 100 and data processing terminal 200; the data processing terminal 200 includes a data standardization module 201. Among them:

[0032] The data acquisition device 100 is used to collect drilling related data, convert the data into digital signals, and transmit them to the data processing terminal 200 through a communication interface;

[0033] The data standardization module 201 is used to standardize the data of different wells received by the data processing terminal 200 according to a set data standard, and store the standardized data in the database 300.

[0034] Reference Figure 1 The data acquisition device 100 can obtain various drilling related data from the field device 400. Specifically, these data can be obtained through the corresponding data interface, such as by reading the memory of the field device, or the field device actively transmits the data to the data acquisition device 100, such as through a serial port data line, or Ethernet, or VSAT (Very Small Aperture Terminal), etc. to achieve data transmission, which is not limited in this embodiment of the present invention.

[0035] The field equipment may generally include, but is not limited to, measurement while drilling (MWD) and logging while drilling (LWD) equipment.

[0036] MWD (Measurement While Drilling) refers to the process of measuring some information near the drill bit and transmitting the information to the ground without interrupting normal drilling operations. MWD generally refers to the measurement of drilling engineering parameters. The measured information mainly includes the following categories: (1) directional data (well inclination, azimuth, tool face angle); (2) formation characteristics (gamma ray, resistivity logging records); (3) drilling parameters (biting pressure, torque, number of revolutions).

[0037] LWD (Logging While Drilling) generally refers to measuring formation rock physical parameters during the drilling process, and using a data telemetry system to send the measurement results to the ground for processing in real time.

[0038] In actual applications, before data collection, the data collection device 100 needs to be configured, including connecting sensors, setting collection parameters, and other operations.

[0039] The data acquisition device 100 needs to convert the collected data into digital signals and transmit them to the data processing terminal 200 through a communication interface (such as a serial port, Ethernet, etc.). Accordingly, the data processing terminal 200 processes the received data and stores the processed data in a database or cache for subsequent query and display.

[0040] The data acquisition device 100 can collect various data of the well site in real time, including but not limited to any one or more of the following: well depth, late well depth, hook height, drilling time, hook load, drilling pressure, rotary table speed, torque, vertical pressure, casing pressure, pump stroke 1, pump stroke 2, pump stroke 3, inlet flow rate, outlet flow rate, inlet density, outlet density, inlet temperature, outlet temperature, inlet conductivity, outlet conductivity, pool volume 1, pool volume 2, pool volume 3, pool volume 4, pool volume 5, total pool volume, pool overflow, total hydrocarbons, C1, C2, C3, iC4, nC4, iC5, nC5, H2S, CO2, etc.

[0041] In the embodiment of the present invention, the data processing terminal 200 can use stream processing technology to clean, process, analyze and other operations on the data to ensure the accuracy and real-time performance of the data.

[0042] In a non-limiting embodiment, the data processing terminal 200 may include a data standardization module 201 , which processes the data of different wells received by the data processing terminal 200 and stores the processed data in the database 300 .

[0043] The database is a relational database, and the table structure of the relational database includes but is not limited to: table name, field name, data type, index, etc. For example, a relational database Oracle 11 may be used. The data processed by the data standardization module 201 will be stored according to the table structure to ensure the integrity and consistency of the data.

[0044] like Figure 2 FIG. 2 is a schematic diagram of a structure of a data standardization module in an embodiment of the present invention. The data standardization module 201 may include the following units:

[0045] A preprocessing unit 211, used for cleaning and preprocessing the data;

[0046] A mapping alignment unit 212, used to map the data processed by the preprocessing unit to target data, and perform field alignment and conversion to obtain standardized data;

[0047] The verification unit 213 is used to verify the standardized data.

[0048] The preprocessing may include any one or more of the following: removing noise from the data, supplementing missing values, etc. The conversion may include but is not limited to multi-language, multi-time zone conversion, etc.

[0049] In the embodiment of the present invention, data standardization is to unify data of different formats or structures into a specific data standard so that it has consistency and interoperability. The steps to achieve data standardization are as follows:

[0050] (1) Determine data standards: Determine unified data standards by defining data structure, fields, and specifications.

[0051] (2) Data cleaning and conversion: Clean the raw data according to data standards, including removing duplicates, filling missing values, converting field types, etc.

[0052] (3) Data mapping and alignment: Map data from different sources to the target data standard and perform field alignment and conversion.

[0053] (3) Data verification and validation: Through verification rules and verification mechanisms, ensure that data complies with data standards, such as data uniqueness and data scope legitimacy.

[0054] Furthermore, the data acquisition device 100 can also transmit the collected data to the data processing terminal 200 in the form of a file, or the data processing terminal 200 can write the received data into a corresponding file, such as converting different types of files into a unified file format to facilitate data storage and processing. The steps to achieve file format unification are as follows:

[0055] (1) Determine the target file format: Select a common file format, such as CSV (Comma-Separated Values), JSON (JavaScript Object Notation), XML (Extensible Markup Language), etc.

[0056] (2) File format conversion: Use corresponding tools or programming languages ​​to parse and convert the original file into the target file format.

[0057] (3) Data mapping and conversion: Map and convert the data in the original file according to the data structure and field requirements of the target file format.

[0058] (4) File output and storage: Output the converted files to the target location and ensure the integrity and consistency of the data.

[0059] Furthermore, considering the differences in languages ​​and time zones in different countries and regions, data also needs to be converted into multiple languages ​​and time zones.

[0060] The multi-language and multi-time zone conversion is to adapt data and applications to different language and time zone environments to meet the needs of different users. The steps to achieve multi-language and multi-time zone conversion include:

[0061] (1) Multi-language support: Design data models and database structures suitable for multiple languages, and use internationalization and localization technologies to achieve multi-language support.

[0062] (2) Language resource management: Organize and store translation resources of different language versions into a unified resource file or database, and load the corresponding resources according to the user's language selection.

[0063] (3) Time zone conversion: The time data is converted to the time zone according to the user's time zone, and the time zone conversion is achieved using the relevant date and time library and time zone database.

[0064] (4) User interface adaptation: Adjust the application interface and display content according to the user's language and time zone to ensure the correct presentation of text and date and time in the user interface.

[0065] In an embodiment of the present invention, based on RDMA (Remote Direct Memory Access) technology and nvMe (NVM Express, non-volatile memory host controller interface specification) multi-level cache technology, combined with IADC (International Association of Drilling Contractors), WITSML (Wellsite Information Transfer Standard Markup Language, wellsite information transfer standard markup language) / WITS (Wellsite Information Transfer Specification) standards, a three-dimensional relational database of well depth, time, and data can be established to achieve data standard, file format unification and multi-language, multi-time zone conversion.

[0066] In the embodiment of the present invention, the Oracle database can be constructed in the following manner:

[0067] (1) Design the logical structure of the database, including determining the required tables, fields, and relationships.

[0068] (2) Use SQL language to create databases and tables, specify field types, lengths, constraints, etc.

[0069] (3) Design primary keys and foreign keys and establish relationships between tables.

[0070] (4) Insert and update data, perform INSERT, UPDATE and other operations.

[0071] (5) Perform data query and execute the SELECT statement to obtain the required data.

[0072] (6) Optimize performance based on query requirements, such as creating indexes and optimizing query statements.

[0073] It should be noted that when storing data in the database, it can be stored according to single wells, that is, data from different wells are stored separately. For example, a database table is created to store single well data, and corresponding fields are defined including well number, time, measurement parameters, etc.

[0074] Accordingly, after the data processing terminal 200 receives the new data, the data standardization module 201 can insert the new data into the database table of the corresponding well. Specifically, the data can be inserted manually, imported from a file, or through a data acquisition device, etc., which is not limited in this embodiment of the present invention.

[0075] The database table structure can be designed according to business needs and can include the definition of tables and fields of multiple databases to ensure that the data source structure matches the report requirements.

[0076] like Figure 3 The figure is a schematic diagram of the structure of the data processing terminal in the system of the present invention.

[0077] The data processing terminal 200 includes: a data standardization module 201 and a data monitoring module 202 .

[0078] in:

[0079] The data standardization module 201 is used to standardize the data of different drillings received by the data processing terminal 200 according to the set data standard, and store the standardized data in the database 300;

[0080] The data monitoring module 202 is used to periodically obtain real-time data from the database or cache and display the real-time data on the monitoring interface.

[0081] The data monitoring module 202 can also update the visual display of the data in real time, for example, it can display the collected data in an intuitive and easy-to-understand manner through charts, dashboards, etc.

[0082] Furthermore, the data monitoring module 202 can also be used to monitor the real-time data according to preset rules and thresholds, and to issue an alarm when the data is abnormal. For example, if the data reaches or exceeds the set threshold, an audible and visual alarm can be issued, and a notification can also be sent to relevant personnel so that relevant personnel can be notified in time and take corresponding measures in time.

[0083] like Figure 4 The figure is a schematic diagram of the structure of the data processing terminal in the system of the present invention.

[0084] and Figure 3 The difference between the illustrated embodiment is that, in this embodiment, the data processing terminal 200 includes not only a data standardization module 201 and a data monitoring module 202 , but also a data analysis module 203 .

[0085] The data analysis module 203 is used to perform data analysis and mining on the standardized data to generate analysis results and reports. For example, the data analysis module 203 can calculate the drilling efficiency, evaluate the downhole conditions, monitor safety, etc. in real time.

[0086] In actual applications, the data analysis module 203 can push the analysis results and reports to corresponding users, or store them in a database for users to view, download, and use.

[0087] Furthermore, considering that the database stores data of multiple different wells, and users sometimes need to query related well data according to different application requirements, for this reason, in a non-limiting embodiment, the data processing terminal 200 may also include: a query module (not shown) for providing users with a query function for the database.

[0088] For example, the query module uses the query language of the database to write query statements, and extracts the required single well data from the database by specifying conditions (such as well number, time range, etc.); the query results are displayed on the front end, and can be visualized in the form of tables, charts, etc. Further, the query module can also use the database's aggregate functions (such as SUM, AVG, COUNT, etc.) and grouping operations to perform statistical calculations on multi-well data. Specifically, according to application requirements, a large number of API (Application Programming Interface) development and research can be carried out based on the .NET and .NET Core platforms, and an API server can be built to process requests sent by the application end and return data; and an API interface related to cross-library and cross-table reading and associated calculation is established, and multiple data sources are accessed through the interface to query and process data, so as to realize cross-library / table reading and associated calculation of multi-source data, and ensure that complex report data is automatically and accurately generated; a report layered design is adopted to accurately control report controls to realize standardized generation and batch export of complex reports.

[0089] The above query function can be completed by the corresponding query unit in the query module.

[0090] Furthermore, the query module can also provide multilingual services for users. Specifically, the architecture and components of a multilingual high-performance microservice framework can be designed based on XML technology, including data transmission, syntax analysis, lexical analysis, processing units, etc.

[0091] Accordingly, the query module may further include the following units: a configuration unit, an analysis unit, a processing and switching unit, and a response unit.

[0092] The configuration unit is used to configure a configuration file to define grammar and lexical rules, and may specifically include: (1) creating an XML configuration file to define grammar and lexical rules for Chinese and foreign languages ​​(such as English); (2) defining keywords, sentence structures, grammar rules, etc., as well as corresponding Chinese-English translations in the configuration file.

[0093] The analysis unit is used to perform grammatical and lexical analysis on the request sent by the client, match the sentence structure and keywords of the request with the rules defined in the XML configuration file, and determine the processing unit and translation rules that need to be generated based on the matching results.

[0094] The processing and switching unit is used to generate corresponding processing units according to the results of grammatical and lexical analysis, including business logic, data processing, translation rules, etc.; associate the generated processing units with corresponding languages, and dynamically switch the processing units at runtime to respond to requests in different languages.

[0095] The response unit responds to the client request, dynamically selects the corresponding processing unit for processing and translation according to the language or environment settings specified by the client, and returns the processing result to the client. For example, the multi-language support function provided by the framework can be used to dynamically translate the result generated by the processing unit and return it to the client.

[0096] like Figure 5 FIG. 1 is another structural schematic diagram of the digital acquisition and transmission system for drilling and completion engineering provided by the present invention.

[0097] In this embodiment, the digital data collection and transmission system for drilling and completion engineering further includes: an application terminal 500, which is used to display the standardized data, the analysis results and the report to the user.

[0098] Specifically, the application terminal 500 can send query, download and other requests to the data processing terminal 200 according to the user's request. Correspondingly, the data processing terminal 200 sends the data or files requested by the user to the application terminal 500; moreover, the corresponding information can also be converted into language and time zone according to the language selected by the user. For example, resource files in different languages ​​are designed and prepared, and corresponding resource files are loaded according to the language selection. The translated text in the corresponding resource files is used in the client interface to realize the multilingualization of interface elements. For another example, an XML plug-in unit conversion library is established, and the unit conversion rules and calculation methods are obtained by reading and parsing the XML configuration files. According to the unit information in the data transmitted by the client, the unit conversion is performed through the XML plug-in unit conversion library to realize the seamless association of data between multiple disciplines.

[0099] It should be noted that the data transmission in the digital acquisition and transmission system of drilling and completion engineering includes static data transmission and dynamic data transmission. Static data transmission can ensure data transmission security and realize breakpoint resumption through Socket asynchronous communication technology, MD5 encryption technology, and CRC32 verification technology; dynamic data transmission can utilize the heartbeat mechanism of TCP (Transmission Control Protocol) to realize long connection of data transmission through multi-core programming transmission and wavelet transform video compression remote transmission technology, so as to realize remote and secure transmission of field data.

[0100] The digital data collection and transmission system for drilling and completion engineering provided by the present invention can simultaneously collect multiple data of different professions such as drilling, logging, directional drilling, logging, cementing, drilling fluid, etc., and supports one-key import of reports and migration and entry of old well data. The professional data coverage rate has increased by 100% year-on-year, and the entry efficiency has increased by 3 times year-on-year; it solves the problems of automatic collection, analysis and transmission of dynamic data of different service providers, different instruments and different data sending methods, and supports data access of multiple mainstream instruments in the world; it realizes the automatic generation and export of complex production reports such as drilling monthly reports and drilling rig operation reports; it can realize the switching of English and Chinese languages ​​of the underlying data in different application terminals, and the automatic conversion of metric, imperial and mixed units, and integrates a one-key group meeting function to realize well site video monitoring and video conferencing functions.

[0101] By utilizing the solution of the present invention, multi-source data fusion applications can be realized to facilitate remote support of overseas engineering technology.

[0102] It should be noted that the terms "including" and "having" and any variations thereof in the specification and claims of the present invention and the above-mentioned drawings are intended to cover non-exclusive inclusions. For example, a process, method, system, product or apparatus comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or apparatus.

[0103] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. Moreover, the system embodiments described above are merely schematic, in which the modules and units described as separate components may or may not be physically separated, that is, they may be located on one network unit, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without creative work.

[0104] The embodiments of the present invention are described in detail above. The present invention is described in detail using specific implementation methods herein. The description of the above embodiments is only used to help understand the method and system of the present invention. It is only a part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should belong to the scope of protection of the present invention, and the content of this specification should not be understood as limiting the present invention. Therefore, any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A digital data collection and transmission system for drilling and completion engineering, characterized in that: The system comprises: a data acquisition device and a data processing terminal; the data processing terminal comprises a data standardization module; The data acquisition device is used to collect the drilling related data, convert the data into digital signals, and transmit them to the data processing terminal through the communication interface; The data standardization module is used to perform standardization processing on the data of different wells received by the data processing terminal according to the set data standard, and store the standardized data in the database.

2. The digital data collection and transmission system for drilling and completion engineering according to claim 1 is characterized in that: The database is a relational database, and the table structure of the relational database includes: table name, field name, data type, and index.

3. The digital data collection and transmission system for drilling and completion engineering according to claim 1 is characterized in that: The data standardization module includes: A preprocessing unit, used for cleaning and preprocessing the data; A mapping alignment unit, used to map the data processed by the preprocessing unit to target data, and perform field alignment and conversion to obtain standardized data; A verification unit is used to verify the standardized data.

4. The digital data collection and transmission system for drilling and completion engineering according to claim 3 is characterized in that: The preprocessing includes any one or more of the following: removing noise in the data and supplementing missing values.

5. The digital data collection and transmission system for drilling and completion engineering according to claim 3 is characterized in that: The conversion includes multi-language and multi-time zone conversion.

6. The digital acquisition and transmission system for drilling and completion engineering according to any one of claims 1 to 5, characterized in that: The data processing terminal also includes: The data analysis module is used to perform data analysis and mining on the standardized data and generate analysis results and reports.

7. The digital data collection and transmission system for drilling and completion engineering according to claim 6 is characterized in that: The analysis results and reports include any one or more of the following information: visualization charts, statistical data.

8. The digital data collection and transmission system for drilling and completion engineering according to claim 6 is characterized in that: The data processing terminal also includes: The data monitoring module is used to periodically obtain real-time data from the database or cache and display the real-time data on the monitoring interface.

9. The digital data collection and transmission system for drilling and completion engineering according to claim 8, characterized in that: The data processing terminal also includes: The query module is used to provide users with a query function for the database.

10. The digital data collection and transmission system for drilling and completion engineering according to claim 8, characterized in that: The system further comprises: The application terminal is used to display the standardized data, the analysis results and the report to the user.

Images