Data recording method, device and system for top drive drilling mechanism and medium
Through real-time data acquisition and automation processing of industrial micro-hosts and programmable logic controllers, the problems of untimely monitoring of the operating status of the top-drive drilling mechanism and inaccurate data recording are solved, and the efficiency and safety of drilling operations are improved.
Patent Information
- Application Number
- CN202411003797.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-25
- Publication Date
- 2024-11-12
AI Technical Summary
In oil drilling operations, the operating status of the top drive drilling mechanism requires manual monitoring and recording, resulting in untimely monitoring, inaccurate data recording and slow acquisition rate, which affects the efficiency and safety of drilling operations and cannot meet the increasing application requirements.
Through the S7 protocol communication connection between the industrial micro-host and the programmable logic controller, the operation data of the top-drive drilling mechanism is read in real time and saved in a timing database. It is classified and transferred according to the data type, and the fault processing and processing is automated. Alarm data to reduce manual intervention.
It realizes efficient and accurate data recording, improves the safety and efficiency of drilling operations, reduces the dependence of manual monitoring, and ensures data accuracy and timeliness.
Smart Images

Figure CN118940179A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of communication technology, and in particular to a data recording method, device, system and medium for a top drive drilling mechanism. Background Art
[0002] Top Drive Drilling System (TDS) is a mechanical device used for oil drilling. It is located under the big hook of the drilling rig and can provide clockwise torque for the drill string to perform the drilling process. In actual use, TDS can directly rotate the drill string from the space above the derrick and send it downward along a special guide rail to complete various drilling operations such as drill string rotation drilling, circulating drilling fluid, single root connection, make-up and breakout, and back-marking.
[0003] In oil drilling operations, the TDS operating status of related technologies needs to be manually monitored and recorded, which may lead to problems such as untimely monitoring, inaccurate data recording and slow acquisition rate, affecting the efficiency and safety of drilling operations and failing to meet the increasingly high application requirements. Summary of the invention
[0004] In view of the above-mentioned defects or deficiencies in the related art, it is desired to provide a data recording method, device, system and medium for a top drive drilling mechanism, which can record data efficiently and accurately and improve the efficiency and safety of drilling operations.
[0005] In a first aspect, the present application provides a data recording method for a top drive drilling mechanism, the data recording method being executed by an industrial micro host, the data recording method comprising:
[0006] Establishing a communication connection between the industrial micro host and the programmable logic controller through the S7 protocol;
[0007] According to a first preset frequency, real-time reading of the operation data of the top drive drilling mechanism collected by the programmable logic controller, the operation data including normal data and fault and alarm data;
[0008] The operation data is stored in a time series database for a first preset time period, and the operation data is classified and transferred according to a type identifier of the operation data.
[0009] Optionally, in some embodiments of the present application, the classifying and transferring the operating data according to the type identifier of the operating data includes:
[0010] If the type identifier corresponds to the normal data, transferring the normal data to a relational database at a second preset frequency;
[0011] Alternatively, if the type identifier corresponds to the fault and alarm data, then the data within a second preset time length before the fault and alarm data and the data within a third preset time length after the fault and alarm data are obtained, and the data within the second preset time length and the data within the third preset time length are transferred to the relational database at the first preset frequency.
[0012] Optionally, in some embodiments of the present application, the data recording method further includes exporting the operating data into a CSV format file or a Json format file.
[0013] Optionally, in some embodiments of the present application, establishing a communication connection between the industrial micro host and the programmable logic controller through the S7 protocol includes:
[0014] Detecting the heartbeat of the programmable logic controller;
[0015] When the heartbeat does not exist, the communication connection between the industrial micro host and the programmable logic controller is reestablished.
[0016] Optionally, in some embodiments of the present application, the data recording method further includes synchronizing the time of the industrial micro host and the time of the programmable logic controller.
[0017] Optionally, in some embodiments of the present application, the first preset frequency is 50 milliseconds per time.
[0018] In a second aspect, the present application provides a data recording device for a top drive drilling mechanism, the data recording device being located in an industrial micro host, and the data recording device comprising:
[0019] A communication connection module, configured to establish a communication connection between the industrial micro host and the programmable logic controller through the S7 protocol;
[0020] A data reading module, configured to read in real time the operation data of the top drive drilling mechanism collected by the programmable logic controller according to a first preset frequency, wherein the operation data includes normal data and fault and alarm data;
[0021] The data storage module is configured to store the operation data in a time series database for a first preset time period, and classify and transfer the operation data according to a type identifier of the operation data.
[0022] Optionally, in some embodiments of the present application, the data storage module is further configured to transfer the normal data to a relational database at a second preset frequency if the type identifier corresponds to the normal data;
[0023] Alternatively, if the type identifier corresponds to the fault and alarm data, then the data within a second preset time length before the fault and alarm data and the data within a third preset time length after the fault and alarm data are obtained, and the data within the second preset time length and the data within the third preset time length are transferred to the relational database at the first preset frequency.
[0024] In a third aspect, the present application provides a data recording system for a top drive drilling mechanism, the data recording system comprising a control center, a frequency converter, a programmable logic controller, a switch, and an industrial micro host according to any one of the second aspects,
[0025] The control center, the frequency converter, the programmable logic controller and the industrial micro host are connected via the switch, wherein the control center is configured to display an operation interface, and the frequency converter is configured to control the top drive rotation speed.
[0026] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the steps of the data recording method described in any one of the first aspects.
[0027] It can be seen from the above technical solutions that the embodiments of the present application have the following advantages:
[0028] The embodiments of the present application provide a data recording method, device, system and medium for a top drive drilling mechanism, which directly reads the operating data of the top drive drilling mechanism collected by the programmable logic controller in real time through an industrial micro host, and the operating data includes normal data as well as fault and alarm data, does not require manual monitoring, has no delay, and has high accuracy. After the operating data is saved in a time series database for a preset period of time, it can be automatically classified and transferred according to the type identification of the operating data, with clear entries, convenient for subsequent event tracing and analysis, and improved The safety of drilling operations. BRIEF DESCRIPTION OF THE DRAWINGS
[0029] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0030] Figure 1 A basic flow chart of a data recording method for a top drive drilling mechanism provided in an embodiment of the present application;
[0031] Figure 2A structural block diagram of a data recording device for a top drive drilling mechanism provided in an embodiment of the present application;
[0032] Figure 3 A structural block diagram of another data recording device for a top drive drilling mechanism provided in an embodiment of the present application;
[0033] Figure 4 A structural block diagram of another data recording device for a top drive drilling mechanism provided in an embodiment of the present application;
[0034] Figure 5 A structural block diagram of another data recording device for a top drive drilling mechanism provided in an embodiment of the present application;
[0035] Figure 6 A structural block diagram of a data recording system for a top drive drilling mechanism provided in an embodiment of the present application. DETAILED DESCRIPTION
[0036] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.
[0037] In order to make the above-mentioned objects, features and advantages of the present application more obvious and easy to understand, the present application is further described in detail below in conjunction with the accompanying drawings and specific implementation methods.
[0038] It should be noted that, in the absence of conflict, the embodiments and features in the embodiments of the present application can be combined with each other. Figures 1 to 6 The data recording method, device, system and medium for a top drive drilling mechanism provided in the embodiments of the present application are described in detail.
[0039] Please refer to Figure 1 , which is a basic flow chart of a data recording method for a top drive drilling mechanism provided in an embodiment of the present application. The data recording method is executed by an industrial micro host, and the data recording method specifically includes the following steps:
[0040] S101, establishing a communication connection between the industrial micro host and the programmable logic controller through the S7 protocol.
[0041] For example, the embodiment of the present application can continuously detect the heartbeat of the programmable logic controller (PLC) during the process of establishing a communication connection, and when the heartbeat does not exist, re-establish the communication connection between the industrial micro host and the programmable logic controller. The advantage of such a setting is that it can ensure uninterrupted data recording without changing the architecture of the original PLC control system, and has a wide range of applications. Furthermore, the embodiment of the present application can also synchronize the time of the industrial micro host and the time of the programmable logic controller, thereby facilitating subsequent event tracing.
[0042] S102, reading in real time the operation data of the top drive drilling mechanism collected by the programmable logic controller according to a first preset frequency, the operation data including normal data and fault and alarm data.
[0043] Exemplarily, in the embodiment of the present application, the first preset frequency can be 50 milliseconds / time, that is, the operating data of the top drive drilling mechanism is read at high frequency. The operating data can be environmental parameters such as temperature and humidity, operating parameters such as speed, torque and drilling depth, operating parameters such as opening and closing, and fault and alarm parameters such as motor failure, excessive current, smoke, overspeed, overtorque, overload and overtemperature. The environmental parameters, operating parameters and operating parameters correspond to normal data, and the fault and alarm parameters correspond to fault and alarm data.
[0044] S103, saving the operation data in a time series database for a first preset time period, and classifying and transferring the operation data according to a type identifier of the operation data.
[0045] Exemplarily, in the embodiment of the present application, the first preset time length may be 24 hours, the type identifier of normal data may be 1, and the type identifier of fault and alarm data may be 2. Further, if the type identifier corresponds to normal data, the normal data is transferred to the relational database at a second preset frequency, for example, the second preset frequency may be 2 seconds / time. Alternatively, if the type identifier corresponds to fault and alarm data, the data within the second preset time length before the fault and alarm data and the data within the third preset time length after the fault and alarm data are obtained, and the data within the second preset time length and the data within the third preset time length are transferred to the relational database at the first preset frequency, wherein the second preset time length and the third preset time length may be equal, for example, both are 30 minutes, or the second preset time length and the third preset time length may not be equal, and there is no limitation on this.
[0046] It should be noted that the time series database in the embodiment of the present application can store and process time series data, which organizes the data into pairs of timestamps and collection values, and can more efficiently store and query time-related information. The relational database uses a table structure to organize data, where data is stored in the form of rows and columns, data tables are connected through relationships, and query and operate using structured query language (SQL).
[0047] Optionally, the embodiment of the present application can also export the operation data as a CSV (Comma-Separated Value) format file or a Json format file. The advantage of this setting is that the user can view and analyze various parameters of the top drive operation process by copying the data, and accurately determine the cause of the fault, which greatly improves the safety of the operation.
[0048] The data recording method for a top drive drilling mechanism provided in an embodiment of the present application directly reads the operating data of the top drive drilling mechanism collected by the programmable logic controller in real time through an industrial micro host, and the operating data includes normal data as well as fault and alarm data, and does not require manual monitoring, has no delay, and has high accuracy. After the operating data is saved in a time series database for a preset period of time, it can be automatically classified and transferred according to the type identification of the operating data, with clear entries, convenient subsequent event tracing and analysis, and improved safety of drilling operations.
[0049] Based on the above embodiments, the present application provides a data recording device for a top drive drilling mechanism. The data recording device 100 is located in an industrial microcomputer 200. Please refer to Figure 2 , the data recording device 100 comprises:
[0050] The communication connection module 101 is configured to establish a communication connection between the industrial micro host and the programmable logic controller through the S7 protocol;
[0051] The data reading module 102 is configured to read the operation data of the top drive drilling mechanism collected by the programmable logic controller in real time according to a first preset frequency, the operation data including normal data and fault and alarm data;
[0052] The data storage module 103 is configured to store the operation data in a time series database for a first preset time period, and classify and transfer the operation data according to a type identifier of the operation data.
[0053] Optionally, in some embodiments of the present application, the data storage module 102 is further configured to transfer the normal data to a relational database at a second preset frequency if the type identifier corresponds to normal data;
[0054] Alternatively, if the type identifier corresponds to fault and alarm data, data within a second preset time length before the fault and alarm data and data within a third preset time length after the fault and alarm data are obtained, and the data within the second preset time length and the data within the third preset time length are transferred to the relational database at a first preset frequency.
[0055] Alternatively, if Figure 3 As shown, in some embodiments of the present application, the data recording device 100 further includes a data export module 104, and the data export module 104 is configured to export the operating data into a CSV format file or a Json format file.
[0056] Alternatively, if Figure 4 As shown, in some embodiments of the present application, the communication connection module 101 further includes:
[0057] A detection unit 1011 is configured to detect the heartbeat of a programmable logic controller;
[0058] The reconstruction unit 1012 is configured to re-establish the communication connection between the industrial micro host and the programmable logic controller when the heartbeat does not exist.
[0059] Alternatively, if Figure 5 As shown, in some embodiments of the present application, the communication connection module 101 further includes a time synchronization unit 1013, and the time synchronization unit 1013 is configured to synchronize the time of the industrial micro host and the time of the programmable logic controller.
[0060] Optionally, in some embodiments of the present application, the first preset frequency is 50 milliseconds per time.
[0061] It should be noted that, for the description of the same steps and the same contents in this embodiment as those in other embodiments, reference can be made to the description in other embodiments and will not be repeated here.
[0062] The data recording device for a top drive drilling mechanism provided in an embodiment of the present application directly reads the operating data of the top drive drilling mechanism collected by a programmable logic controller in real time through a data reading module. The operating data includes normal data as well as fault and alarm data. It does not require manual monitoring, has no delay, and has high accuracy. After the data storage module saves the operating data in a time series database for a preset period of time, it can automatically classify and transfer the operating data according to the type identification of the operating data. The entries are clear, which facilitates subsequent event tracing and analysis, and improves the safety of drilling operations.
[0063] Based on the above embodiments, the present application provides a data recording system for a top drive drilling mechanism. Figure 6The data recording system 300 may include a control center 301, a frequency converter 302, a programmable logic controller 303, a switch 304 and Figures 2 to 5 Corresponding to any one of the industrial micro-hosts 200 in the embodiments, the control center 301, the frequency converter 302, the programmable logic controller 303 and the industrial micro-host 200 are connected via a switch 304, wherein the control center 301 can display the operation interface, and the frequency converter 302 can control the top drive speed.
[0064] It should be noted that, for the description of the same contents in this embodiment as those in other embodiments, reference can be made to the description in other embodiments and will not be repeated here.
[0065] As another aspect, the present application provides a computer-readable storage medium for storing one or more programs written in Python scripts, wherein the one or more programs are executed by one or more processors to implement the aforementioned Figure 1 Any implementation of the data recording method of the corresponding embodiment.
[0066] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and modules described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.
[0067] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the modules is only a logical function division. There may be other division methods in actual implementation, such as multiple modules or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or modules, which can be electrical, mechanical or other forms. The modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the scheme of this embodiment.
[0068] In addition, each functional module in each embodiment of the present application may be integrated into a processing unit, or each module may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of a software functional unit. If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it may be stored in a computer-readable storage medium.
[0069] Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art, or the whole or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the data recording method of each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM), random access memory (RAM), disk or optical disk, etc., various media that can store program codes.
[0070] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0071] This article uses specific examples to illustrate the principles and implementation methods of this application. The description of the above embodiments is only used to help understand the method and core ideas of this application. At the same time, for those skilled in the art, according to the ideas of this application, there will be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be understood as limiting this application.
Claims
1. A data recording method for a top drive drilling mechanism, characterized in that: The data recording method is executed by an industrial micro host, and the data recording method comprises: Establishing a communication connection between the industrial micro host and the programmable logic controller through the S7 protocol; According to a first preset frequency, real-time reading of the operation data of the top drive drilling mechanism collected by the programmable logic controller, the operation data including normal data and fault and alarm data; The operation data is stored in a time series database for a first preset time period, and the operation data is classified and transferred according to a type identifier of the operation data.
2. The data recording method according to claim 1, characterized in that: The classifying and transferring the operation data according to the type identifier of the operation data includes: If the type identifier corresponds to the normal data, transferring the normal data to a relational database at a second preset frequency; Alternatively, if the type identifier corresponds to the fault and alarm data, then the data within a second preset time length before the fault and alarm data and the data within a third preset time length after the fault and alarm data are obtained, and the data within the second preset time length and the data within the third preset time length are transferred to the relational database at the first preset frequency.
3. The data recording method according to claim 1, characterized in that: The data recording method also includes exporting the operating data into a CSV format file or a Json format file.
4. The data recording method according to any one of claims 1 to 3, characterized in that: The communication connection between the industrial micro host and the programmable logic controller is established through the S7 protocol, including: Detecting the heartbeat of the programmable logic controller; When the heartbeat does not exist, the communication connection between the industrial micro host and the programmable logic controller is reestablished.
5. The data recording method according to claim 4, characterized in that: The data recording method further includes synchronizing the time of the industrial micro host and the time of the programmable logic controller.
6. The data recording method according to claim 4, characterized in that: The first preset frequency is 50 milliseconds per time.
7. A data recording device for a top drive drilling mechanism, characterized in that: The data recording device is located in the industrial micro host, and the data recording device includes: A communication connection module, configured to establish a communication connection between the industrial micro host and the programmable logic controller through the S7 protocol; A data reading module, configured to read in real time the operation data of the top drive drilling mechanism collected by the programmable logic controller according to a first preset frequency, wherein the operation data includes normal data and fault and alarm data; The data storage module is configured to store the operation data in a time series database for a first preset time period, and classify and transfer the operation data according to a type identifier of the operation data.
8. The data recording device according to claim 7, characterized in that The data storage module is further configured to transfer the normal data to a relational database at a second preset frequency if the type identifier corresponds to the normal data; Alternatively, if the type identifier corresponds to the fault and alarm data, then the data within a second preset time length before the fault and alarm data and the data within a third preset time length after the fault and alarm data are obtained, and the data within the second preset time length and the data within the third preset time length are transferred to the relational database at the first preset frequency.
9. A data recording system for a top drive drilling mechanism, characterized in that: The data recording system comprises a control center, a frequency converter, a programmable logic controller, a switch and an industrial micro host according to any one of claims 7 to 8, The control center, the frequency converter, the programmable logic controller and the industrial micro host are connected via the switch, wherein the control center is configured to display an operation interface, and the frequency converter is configured to control the top drive rotation speed.
10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the steps of the data recording method according to any one of claims 1 to 6.
Citation Information
Patent Citations
Intelligent operation and maintenance method based on Internet of Things technology
CN114297265A
Diagnostic data storage method and device and computer readable storage medium
CN114327982A
Abnormal data processing method and apparatus, and electronic device
WO2023147731A1
