Visual state detection and mechanism mapping analysis system, method, equipment and medium

Abstract

The invention discloses a visual state detection and mechanism mapping analysis system, method, equipment and medium, and relates to the field of petroleum drilling equipment hydraulic system mechanism simulation monitoring. A data acquisition module is used for acquiring real-time data and historical data of a top drive tilting device hydraulic system; the twin system database is used for acquiring and storing real-time data and historical data; the twinborn system bottom layer computing platform is used for acquiring the simulation operation data sent by the twinborn system database, performing analogue simulation operation on the simulation operation data and sending an operation result to the twinborn system database; the digital twin monitoring system is used for acquiring an operation result created and sent by the twin system database based on locally stored data and real-time data and historical data sent by the data acquisition module; based on the operation result, the real-time data and the historical data, visual state detection and mechanism mapping analysis of the hydraulic system of the top drive inclination device are achieved, and the accuracy of visual state detection and mechanism mapping analysis is improved.

Description

Technical Field

[0001] The invention relates to the field of mechanism simulation monitoring of hydraulic systems of oil drilling equipment, and in particular to a visual state detection and mechanism mapping analysis system, method, equipment and medium. Background Art

[0002] As an important equipment in the field of petrochemicals, the top drive drilling rig undertakes important drilling and production tasks. Once a failure occurs and causes downtime, it will cause huge safety hazards and cause significant economic losses. The tilting device under the top drive is a mechanical device that contains key components such as tilting cylinders, lifting rings, and hanging cards. The device realizes the forward and backward tilting of the boom and the lifting rings and hanging cards connected to it through the telescopic movement of the hydraulic cylinder to complete the disassembly of the drill pipe. The existing technology only takes into account the data collected by the sensor to realize the overall status monitoring of the drilling rig. The accuracy is not high, and it is also impossible to realize the detection of the hydraulic system of the top drive tilting device.

[0003] It can be seen from the above that how to realize the visual state detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device and improve the accuracy of the visual state detection and mechanism mapping analysis are problems to be solved in this field. Summary of the invention

[0004] In view of this, the purpose of the present invention is to provide a visual state detection and mechanism mapping analysis system, method, device and medium, which can realize the visual state detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device, and improve the accuracy of the visual state detection and mechanism mapping analysis. The specific scheme is as follows:

[0005] In a first aspect, the present application discloses a visual state detection and mechanism mapping analysis system, comprising:

[0006] A data acquisition module, used to acquire real-time data and historical data of the hydraulic system of the top drive tilting device;

[0007] A twin system database, used to acquire and store the real-time data and the historical data from the data acquisition module;

[0008] The underlying computing platform of the twin system is used to obtain the simulation operation data sent by the twin system database, perform simulation operation on the simulation operation data to obtain operation results, and send the operation results to the twin system database;

[0009] The digital twin monitoring system is used to obtain the calculation results created and sent by the twin system database based on locally stored data, as well as the real-time data and the historical data sent by the data acquisition module, and based on the calculation results, the real-time data and the historical data, realize the visual status detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device.

[0010] Optionally, the data acquisition module includes:

[0011] A connection module is used to establish a connection relationship with a hardware monitoring and control device of a hydraulic system of a top drive tilting device; the hardware monitoring and control device includes a sensor and an industrial computer; the sensor includes a temperature sensor, a pressure sensor and a position sensor; the industrial computer includes a programmable logic controller;

[0012] An acquisition module is used to acquire real-time data and historical data of the hydraulic system of the top drive tilting device through the connection relationship; the real-time data and historical data include hydraulic oil temperature, pressure, hydraulic valve status, hydraulic cylinder position and hydraulic pump status.

[0013] Optionally, the twin system database includes:

[0014] A database building module, used to build a twin system database using a relational database; the relational database includes a MySQL database;

[0015] A data storage module, used for acquiring and storing the real-time data and the historical data from the data acquisition module through a data communication interface;

[0016] The database management module is used to manage the twin system database using a database visualization management tool; the database visualization management tool includes Navicat.

[0017] Optionally, the underlying computing platform of the twin system includes:

[0018] A platform construction module is used to construct a twin system underlying computing platform of the hydraulic system mechanism of the top drive tilting device; the twin system underlying computing platform includes an AMESim simulation model;

[0019] A simulation operation module is used to obtain the simulation operation data sent by the twin system database through the data communication interface, and use the AMESim simulation model to perform simulation operation on the simulation operation data to obtain the operation result;

[0020] The calculation result sending module is used to send the calculation result to the twin system database through the data communication interface.

[0021] Optionally, the simulation operation module further includes:

[0022] The component attribute parameter acquisition module is used to acquire the attribute parameters of the mechanical hydraulic components of the hydraulic system of the top drive tilting device; the mechanical hydraulic components include a hydraulic pump, a hydraulic valve, a hydraulic motor, a hydraulic cylinder and a hydraulic pipeline;

[0023] A simulation operation data acquisition module, used to acquire the simulation operation data sent by the twin system database through the data communication interface;

[0024] An operation result determination module, used for performing simulation operation on the simulation operation data by using the AMESim simulation model and based on the attribute parameters in the component attribute parameter acquisition module to obtain an operation result;

[0025] Among them, the relevant hydraulic calculation formulas include flow equations, basic equations of fluid dynamics, pressure equations for describing the relationship between pressure and force in hydraulic components, hydraulic cylinder motion equations for describing the relationship between the speed and flow of the hydraulic cylinder, Darcy-Weisbach formula for calculating fluid resistance losses in pipelines, hydraulic power formulas for calculating hydraulic system power, hydraulic efficiency formulas for calculating hydraulic component efficiency, continuity equations for calculating inlet and outlet flow in hydraulic systems, and formulas for the influence of temperature on viscosity and fluid properties in hydraulic systems.

[0026] Optionally, the visual state detection and mechanism mapping analysis system further includes:

[0027] Monitoring system building module, used to build a digital twin monitoring system based on a real-time 3D interactive content creation and operation platform;

[0028] Accordingly, the digital twin monitoring system includes:

[0029] A visualization status detection module, for realizing various aspects of visualization status detection of the hydraulic system of the top drive tilting device by using the three-dimensional model and user interface of Unity3D and based on the calculation results, the real-time data and the historical data;

[0030] The mechanism mapping analysis module is used to perform mechanism mapping analysis and fault alarm on the hydraulic system of the top drive tilting device.

[0031] Optionally, the visual state detection and mechanism mapping analysis system further includes:

[0032] A data communication interface is used to construct a data communication interface through an open database connection interface and using a programming language;

[0033] Parameter table, used to obtain and store key parameters of the hydraulic system of the top drive tilting device through the data communication interface;

[0034] The variable browser is used to obtain and store the calculation results sent by the underlying computing platform of the twin system through the data communication interface, and then send the calculation results to the twin system database, so that the twin system database forwards the calculation results to the digital twin monitoring system for visual status detection and mechanism mapping analysis.

[0035] In a second aspect, the present application discloses a visual state detection and mechanism mapping analysis method, comprising:

[0036] Acquire real-time data and historical data of the hydraulic system of the top drive tilting device through the data acquisition module;

[0037] Acquire and store the real-time data and the historical data from the data acquisition module through a twin system database;

[0038] Acquire the simulation operation data sent by the twin system database, perform simulation operation on the simulation operation data to obtain operation results, and send the operation results to the twin system database;

[0039] Obtain the calculation results created and sent by the twin system database based on locally stored data, as well as the real-time data and the historical data sent by the data acquisition module, and implement visual status detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device based on the calculation results, the real-time data and the historical data.

[0040] In a third aspect, the present application discloses an electronic device, comprising:

[0041] Memory, used to store computer programs;

[0042] The processor is used to execute the computer program to implement the aforementioned visual state detection and mechanism mapping analysis method.

[0043] In a fourth aspect, the present application discloses a computer storage medium for storing a computer program; wherein, when the computer program is executed by a processor, the steps of the aforementioned disclosed visualization state detection and mechanism mapping analysis method are implemented.

[0044] It can be seen that the present application provides a visual state detection and mechanism mapping analysis system, including a data acquisition module for acquiring real-time data and historical data of the hydraulic system of the top drive tilting device; a twin system database for acquiring and storing the real-time data and the historical data from the data acquisition module; a twin system underlying computing platform for acquiring the simulation operation data sent by the twin system database, and performing simulation operation on the simulation operation data to obtain the operation result, and sending the operation result to the twin system database; a digital twin monitoring system for acquiring the operation result created and sent by the twin system database based on the locally stored data and the real-time data and the historical data sent by the data acquisition module, and based on the operation result, the real-time data and the historical data, realize the visual state detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device. This application utilizes the underlying computing platform of the twin system to perform simulation operations on the simulation operation data sent by the twin system database to obtain the operation results, and utilizes the digital twin monitoring system to realize the visual state detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device based on the operation results, real-time data and historical data. The operation results are complemented by the real-time data and historical data, and various aspects of data are considered and transmitted to the digital twin monitoring system for visual display, thereby realizing the visual state detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device, and improving the accuracy of the visual state detection and mechanism mapping analysis. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] 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 or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying creative work.

[0046] Figure 1 A schematic diagram of the structure of a visual state detection and mechanism mapping analysis system disclosed in this application;

[0047] Figure 2 A schematic diagram of a real-time data collection and transmission process disclosed in this application;

[0048] Figure 3 A schematic diagram of an AMESim simulation model disclosed in this application;

[0049] Figure 4 A schematic diagram of the specific structure of the visual state detection and mechanism mapping analysis disclosed in this application;

[0050] Figure 5A flow chart of visual state detection and mechanism mapping analysis disclosed in this application;

[0051] Figure 6 A schematic diagram of the structure of an electronic device provided in this application. DETAILED DESCRIPTION

[0052] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only 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 are within the scope of protection of the present invention.

[0053] As an important equipment in the field of petrochemical industry, the top drive drilling rig undertakes important drilling and production tasks. Once a failure occurs and causes downtime, it will cause huge safety hazards and cause significant economic losses. The tilting device under the top drive is a mechanical equipment, which contains key components such as tilting cylinders, lifting rings, and hanging cards. The device realizes the forward and backward tilting of the boom and the lifting rings and hanging cards connected to it through the telescopic movement of the hydraulic cylinder to complete the disassembly of the drill pipe. The prior art only considers the data collected by the sensor to realize the status monitoring of the entire drilling rig, the accuracy is not high, and it is also impossible to realize the detection of the hydraulic system of the top drive tilting device. As can be seen from the above, how to realize the visual status detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device and improve the accuracy of the visual status detection and mechanism mapping analysis are problems to be solved in this field.

[0054] See also Figure 1 As shown, the embodiment of the present application discloses a visual state detection and mechanism mapping analysis system, including:

[0055] The data acquisition module 11 is used to acquire real-time data and historical data of the hydraulic system of the top drive tilting device.

[0056] In this embodiment, the data acquisition module 11 includes: a connection module 111, which is used to establish a connection relationship with the hardware monitoring and control equipment of the hydraulic system of the top drive tilting device; the hardware monitoring and control equipment includes a sensor and an industrial computer; the sensor includes a temperature sensor, a pressure sensor and a position sensor; the industrial computer includes a programmable logic controller; an acquisition module 112, which is used to acquire real-time data and historical data of the hydraulic system of the top drive tilting device through the connection relationship; the real-time data and historical data include hydraulic oil temperature, pressure, hydraulic valve status, hydraulic cylinder position and hydraulic pump status.

[0057] That is, hardware monitoring and control devices such as sensors and industrial computers are used to provide the system with real data sources (including real-time data and historical data). The real-time data collected by the sensors is aggregated and processed and then transmitted to the twin system database12. The process of real-time data collection and transmission is as follows Figure 2 As shown, the sensors and industrial computers and other hardware monitoring and control equipment that have been built during the physical entity construction of the top drive equipment tilting device are used to obtain real-time data and historical data, including hydraulic oil temperature, pressure, hydraulic valve status, hydraulic cylinder position, hydraulic pump status, etc. The real-time collected data is processed and classified by PLC (Programmable Logic Controller) and industrial computers, and then transmitted to the twin system database 12 through the data communication interface, so that the twin system database 12 can provide real-time input parameters and monitoring parameters for the twin system underlying computing platform 13 and the digital twin monitoring system 14.

[0058] The twin system database 12 is used to obtain and store the real-time data and the historical data from the data acquisition module.

[0059] In this embodiment, the twin system database 12 includes: a database building module 121, which is used to build a twin system database using a relational database; the relational database includes a MySQL database; a data storage module 122, which is used to obtain and store the real-time data and the historical data from the data acquisition module through a data communication interface; a database management module 123, which is used to manage the twin system database using a database visualization management tool; the database visualization management tool includes Navicat.

[0060] Specifically, the twin system database 12 is built using a general relational database, using a MySQL database that is highly compatible, lightweight, has superior performance, and is easy to deploy, and uses SQL (Structured Query Language) to implement the classification construction of the twin system database. The database visualization management tool Navicat can be used to manage and modify the database. In addition, based on the Qt framework, the twin system database visualization management system can be built using the C++ programming language, and the Python programming language can be used to implement data communication between the database management system and the twin system database. The twin system database S12 further transmits real-time data and historical data to the twin system underlying computing platform 13 as input parameters through the data communication interface, or directly transmits it to the digital twin monitoring system 14 to achieve visualization and status monitoring analysis. The twin system database 12 serves as the data transmission intermediary and data storage center of the twin system's underlying computing platform 13, the data acquisition module 11, and the digital twin monitoring system 14. It can receive real-time data and historical data from physical entity sensors and hardware monitoring and control devices such as industrial computers, receive and transmit the calculation results of the twin system's underlying computing platform 13, realize real-time mapping between twin physical entities and digital twin monitoring systems, and realize two-way data transmission.

[0061] The twin system underlying computing platform 13 is used to obtain the simulation operation data sent by the twin system database, perform simulation operation on the simulation operation data to obtain the operation result, and send the operation result to the twin system database.

[0062] In this embodiment, the twin system underlying computing platform 13 includes: a platform construction module 131, which is used to construct the twin system underlying computing platform of the hydraulic system mechanism of the top drive tilting device; the twin system underlying computing platform includes the AMESim simulation model; a simulation operation module 132, which is used to obtain the simulation operation data sent by the twin system database through the data communication interface, and use the AMESim simulation model to perform simulation operation on the simulation operation data to obtain the operation result; an operation result sending module 133, which is used to send the operation result to the twin system database through the data communication interface.

[0063] The simulation operation module 132 further includes: an element attribute parameter acquisition module 1321, which is used to acquire the attribute parameters of the mechanical hydraulic elements of the hydraulic system of the top drive tilting device; the mechanical hydraulic elements include hydraulic pumps, hydraulic valves, hydraulic motors, hydraulic cylinders and hydraulic pipelines; a simulation operation data acquisition module 1322, which is used to acquire the simulation operation data sent by the twin system database through the data communication interface; an operation result determination module 1323, which is used to perform simulation operation on the simulation operation data using the AMESim simulation model and based on the attribute parameters in the element attribute parameter acquisition module to obtain the operation result;

[0064] Among them, the relevant hydraulic calculation formulas include flow equations, basic equations of fluid dynamics, pressure equations for describing the relationship between pressure and force in hydraulic components, hydraulic cylinder motion equations for describing the relationship between the speed and flow of the hydraulic cylinder, Darcy-Weisbach formula for calculating fluid resistance losses in pipelines, hydraulic power formulas for calculating hydraulic system power, hydraulic efficiency formulas for calculating hydraulic component efficiency, continuity equations for calculating inlet and outlet flow in hydraulic systems, and formulas for the influence of temperature on viscosity and fluid properties in hydraulic systems.

[0065] The specific relevant hydraulic calculation formula is as follows:

[0066] Flow equation, the formula for flow Q through a pipe, valve or other hydraulic component:

[0067] ;

[0068] Where Q is the flow rate ( ), A is the cross-sectional area ( ), v is the fluid velocity (m / s);

[0069] The basic equations of fluid dynamics, such as Bernoulli's equation:

[0070] ;

[0071] Where P is pressure (Pa), v is fluid velocity (m / s), is the fluid density ( ), h is the height (m), is the head loss due to friction (m);

[0072] The pressure equation describes the relationship between pressure and force in hydraulic components:

[0073] ;

[0074] Where P is pressure (Pa), F is force (N), and A is the force area ( );

[0075] The hydraulic cylinder motion equation is used to describe the relationship between the speed and flow of the hydraulic cylinder:

[0076] ;

[0077] Where v is the speed of the piston (m / s), Q is the flow rate into the hydraulic cylinder ( ), A is the piston area ( );

[0078] The Darcy–Weisbach equation is used to calculate the flow resistance loss in a pipe:

[0079] ;

[0080] Where f is the friction coefficient, L is the pipe length (m), D is the pipe diameter (m), is the fluid density ( ), v is the flow velocity (m / s);

[0081] Hydraulic power formula, used to calculate the power of the hydraulic system:

[0082] ;

[0083] Where P is power (kW), Q is flow rate (L / min), and ΔP is pressure difference (MPa)

[0084] Hydraulic efficiency formula, used to calculate the efficiency of hydraulic components:

[0085] ;

[0086] in, is efficiency, P out is the output power, P in is the input power;

[0087] Continuity equation, used to calculate inlet and outlet flow in hydraulic systems:

[0088] ;

[0089] in, is the import flow, is the export flow;

[0090] The effect of temperature on viscosity and fluid properties in hydraulic systems is shown in the formula:

[0091] ;

[0092] in, is the viscosity at temperature T (Pa·s), is the initial viscosity (Pa·s), is a constant related to the physical properties of the fluid (K -1 ), T is temperature (K).

[0093] In this embodiment, the process of constructing the twin system underlying computing platform of the hydraulic system mechanism of the top drive tilting device is as follows: according to the working mechanism of the hydraulic system of the top drive tilting device, an AMESim simulation model of the hydraulic system mechanism of the top drive tilting device is constructed. The schematic diagram of the AMESim simulation model is shown in FIG. Figure 3 As shown in the figure, according to the hydraulic oil property information in the hydraulic system, the hydraulic oil physical property information of the AMESim simulation model is set in detail. Based on the physical entity of the hydraulic system of the top drive tilting device, mechanical hydraulic components such as hydraulic pumps, hydraulic valves, hydraulic motors, hydraulic cylinders, and hydraulic pipelines are added. The property parameters of the above components can be designed in detail to improve the restoration degree of the AMESim simulation model. Specifically: the flow, power, and pressure of the hydraulic pump, the power and speed of the hydraulic motor, the geometric parameters of the hydraulic valve (valve opening area, valve core diameter and stroke, valve geometry and flow channel size), hydraulic characteristics (valve rated flow, pressure drop characteristics, leakage characteristics), dynamic parameters (valve response time, valve core quality, valve spring stiffness and preload, valve damping coefficient), control parameters (control signal type, control signal amplitude and frequency, control logic and mode), hydraulic cylinder geometric parameters (cylinder barrel inner and outer diameters, piston rod diameter, piston stroke length), hydraulic parameters (working pressure range, hydraulic cylinder rated flow, leakage characteristics, sealing characteristics), friction and damping parameters, length and diameter of hydraulic pipelines, etc. The constructed AMESim simulation model can simulate the temperature, pressure, displacement and other state information of the hydraulic oil tank, hydraulic pump, hydraulic valve, hydraulic cylinder, hydraulic motor, pipeline and joint, actuator and other key components of the actual top drive tilting device hydraulic system in a relatively accurate manner, and perform real-time simulation calculations at the bottom layer as the underlying computing platform 13 of the twin system. Using the multidisciplinary complex system modeling and simulation platform AMESim, based on the physical entity of the hydraulic system of the top drive tilting device, the parameters of each component are designed in detail to simulate the hydraulic system. The underlying computing platform of the twin system has strong compatibility with different types of top drive tilting device hydraulic systems, and can calculate the key parameters of the hydraulic system that are difficult or impossible to collect by sensors; the sensor collected data is used as the simulation operation input parameter of the AMESim model, and the model operation results complement the sensor collected data, effectively improving the integrity of the real-time state monitoring and mechanism analysis of the hydraulic system of the top drive tilting device.

[0094] In this embodiment, the visual state detection and mechanism mapping analysis system also includes: a data communication interface 16, which is used to construct a data communication interface through an open database connection interface and using a programming language; a parameter table 17, which is used to obtain and store key parameters of the hydraulic system of the top drive tilting device through the data communication interface; a variable browser 18, which is used to obtain and store the calculation results sent by the underlying computing platform of the twin system through the data communication interface, and then send the calculation results to the twin system database, so that the twin system database forwards the calculation results to the digital twin monitoring system for visual state detection and mechanism mapping analysis.

[0095] Specifically, the data communication interface 16 provides two-way communication interface conditions for each part of the top drive tilting device hydraulic system mechanism simulation monitoring system based on digital twin, and stores the key parameters of the AMESim top drive tilting device hydraulic system simulation model corresponding to the key parameters of the actual working mechanism in the Parameter Table (parameter table 17) and Variable Browser (variable browser 18) of AMESim. The parameter table 17 allows all unit operation parameters and hydraulic parameters on the AMESim simulation model to be stored and edited, and the setting parameters of the simulation model can be directly modified by modifying the data in the parameter table 17. At the same time, the variable browser 18 is used to monitor and analyze the changes in key parameters during the simulation process. In addition, the key parameters in the parameter table and variable browser can be read and transmitted using a programming language through the ODBC (Open Database Connectivity) interface. The data collected by the sensor in real time is used as the model input parameter, and the sensor collected data is stored in the twin system database through PLC, industrial computer, etc. The interface programming software runs the communication interface program to read the sensor collected data in the twin database in real time and input it into AMESim, and the model dynamic calculation is performed in real time. At the same time, the model calculation result data of AMESim is stored in the parameter table 17 and the variable browser 18, read by the interface programming software in real time and transmitted back to the twin system database 12, and transmitted to the digital twin monitoring system 14 in real time for visualization and monitoring analysis.

[0096] The digital twin monitoring system 14 is used to obtain the calculation results created and sent by the twin system database based on the locally stored data, as well as the real-time data and the historical data sent by the data acquisition module, and based on the calculation results, the real-time data and the historical data, realize the visual status detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device.

[0097] In addition, the visual state detection and mechanism mapping analysis system also includes: a monitoring system building module 15, which is used to build a digital twin monitoring system based on a real-time 3D interactive content creation and operation platform.

[0098] Correspondingly, the digital twin monitoring system 14 includes: a visualization status detection module 141, which is used to utilize the three-dimensional model and user interface of Unity3D, and based on the calculation results, the real-time data and the historical data, realize multi-faceted visualization status detection of the hydraulic system of the top drive tilting device; a mechanism mapping analysis module 142, which is used to perform mechanism mapping analysis and fault alarm on the hydraulic system of the top drive tilting device.

[0099] In this embodiment, the digital twin monitoring system 14 is built based on the real-time 3D (3-Dimensions) interactive content creation and operation platform, which can realize the two-dimensional interface display and the creation and import of three-dimensional interactive models. The digital twin monitoring system is built based on the real-time 3D interactive content creation and operation platform, and the real-time two-dimensional monitoring interface and 3D animation model of the digital twin monitoring system of the top drive tilting device hydraulic system are created and imported using the Unity3D creation platform with advantages such as cross-platform support, scalability, real-time rendering and physical engine. Based on the three-dimensional model building and UI (User Interface, interface design) functions of Unity3D, the C# programming language provided by the Unity3D platform is used to mount the driver scripts for interface display, hiding, switching and other functions. For example, the monitoring interface of the hydraulic system of the top drive tilting device is built, and the working status of the hydraulic system of the top drive tilting device can be displayed in a two-dimensional plane in the interface. At the same time, the display window interface containing attribute information and status information can be built for the main components such as the hydraulic pump, hydraulic cylinder, hydraulic valve, and key section hydraulic pipeline in the hydraulic system, such as the inlet and outlet pressure, valve opening, flow rate, etc. of the hydraulic valve. The window interface data is connected to the twin system database 12 in real time, and can display the monitoring and control data of sensors and industrial computers in the physical entity of the data acquisition module 11 in real time. If the sensor components are not deployed, the results of the AMESim model simulation operation in the bottom computing platform 13 of the twin system are displayed. In addition, a three-dimensional real-time monitoring interface of the hydraulic system of the top drive tilting device is built. The three-dimensional hydraulic system of the top drive tilting device is generally built using the powerful three-dimensional modeling software Solidworks. After outputting the .stp format commonly used by the three-dimensional modeling software, it is imported into the 3DMax software for rendering and outputting the .fbx format, and then imported into the Unity3D platform for three-dimensional interface construction. Using C# programming, a real-time status information display interface is built next to key equipment such as hydraulic pumps, hydraulic cylinders, hydraulic valves, and key hydraulic pipelines in the three-dimensional model of the hydraulic system of the top drive tilting device. The sensor acquisition data is also displayed. If the sensor components or hydraulic pipelines are not deployed, the results of the AMESim model simulation operation in the bottom computing platform 13 of the twin system are displayed. This interface can be hidden and displayed through C# programming. For the above-mentioned status data, a historical data monitoring interface can be built to display the historical data in curves, and the fault diagnosis algorithm can be integrated into the C# script to supplement the threshold alarm function, thereby realizing fault alarm. In addition, based on C# programming, animation effects can be added to the three-dimensional hydraulic system of the top drive tilting device, such as adding animation effects to the hydraulic pipeline based on the collected data or the result data of the AMESim model simulation operation, which can display the flow rate and flow rate in real time, and adding animation effects to other components such as hydraulic valves, which can display the valve movement process in real time.

[0100] The specific structural diagram of the visual state detection and mechanism mapping analysis of this application is as follows Figure 4 As shown, it includes a data acquisition module 11 (using sensors carried in the physical entity within the data acquisition module 11 and hardware monitoring and control equipment such as industrial computers to obtain real-time data and historical data of the hydraulic system of the top drive tilting device), a twin system database 12 built based on a commonly used relational database, a twin system underlying computing platform 13 based on the AMESim top drive tilting device hydraulic system mechanism simulation model, a digital twin monitoring system 14 built based on a real-time 3D interactive content creation and operation platform, and a data communication interface. On the one hand, the present invention builds a top drive tilt device hydraulic system mechanism simulation model based on AMESim, a general multidisciplinary complex system modeling and simulation platform, adds hydraulic components and sets attribute parameters according to the working mechanism of the hydraulic system, and uses the AMESim simulation model as the underlying computing platform of the twin system, which has high restoration degree, strong compatibility, high flexibility and wide adaptability. On the other hand, the data provided by the existing sensors in the top drive device and hardware monitoring and control equipment such as industrial computers are used as the driving data source. The application deployment cost of the monitoring system is low, the deployment is rapid and the application range is wide. In addition, the twin system database is built by using the MySQL database with high reliability, high scalability, small size and easy deployment, and the Python with rich functions and strong applicability is used. on, C# and other programming languages ​​to build data communication interfaces, realize two-way data communication between the underlying computing platform of the twin system, sensors on physical entities, hardware monitoring and control equipment such as industrial computers, and the digital twin monitoring system; use the sensor collected data as the simulation operation input parameter of the AMESim model of the underlying computing platform of the twin system, and the model operation results complement the sensor collected data, and transmit them together to the digital twin monitoring system for visual display; use the Unity3D platform to develop the digital twin monitoring system, build the system human-computer interaction interface (system login, exit, function selection, etc.), and build the monitoring system for the multi-faceted online monitoring, mechanism mapping analysis, and fault alarm functions of the working mechanism of the hydraulic system of the top drive tilting device. Finally, a mechanism simulation monitoring system for the hydraulic system of the top drive tilting device based on digital twin is formed, which can realize the multi-faceted online status monitoring and mechanism mapping analysis of the working mechanism of the hydraulic system of the top drive tilting device, and has good scalability, and the function development and expansion can be carried out according to actual needs in the future.

[0101] In this embodiment, the data acquisition module is used to acquire the real-time data and historical data of the hydraulic system of the top drive tilting device; the twin system database is used to acquire and store the real-time data and the historical data from the data acquisition module; the twin system underlying computing platform is used to acquire the simulation operation data sent by the twin system database, and perform simulation operation on the simulation operation data to obtain the operation result, and send the operation result to the twin system database; the digital twin monitoring system is used to acquire the operation result created and sent by the twin system database based on the locally stored data and the real-time data and the historical data sent by the data acquisition module, and based on the operation result, the real-time data and the historical data, realize the visual status detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device. This application utilizes the underlying computing platform of the twin system to perform simulation operations on the simulation operation data sent by the twin system database to obtain the operation results, and utilizes the digital twin monitoring system to realize the visual state detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device based on the operation results, real-time data and historical data. The operation results are complemented by the real-time data and historical data, and various aspects of data are considered and transmitted to the digital twin monitoring system for visual display, thereby realizing the visual state detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device, and improving the accuracy of the visual state detection and mechanism mapping analysis.

[0102] See also Figure 5 As shown, the embodiment of the present invention discloses a visual state detection and mechanism mapping analysis method, including:

[0103] Step S21: acquiring real-time data and historical data of the hydraulic system of the top drive tilting device through a data acquisition module.

[0104] Step S22: Acquire and store the real-time data and the historical data from the data acquisition module through the twin system database.

[0105] Step S23: Acquire the simulation operation data sent by the twin system database, perform simulation operation on the simulation operation data to obtain operation results, and send the operation results to the twin system database.

[0106] Step S24: Obtain the calculation results created and sent by the twin system database based on the locally stored data, as well as the real-time data and the historical data sent by the data acquisition module, and implement visual status detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device based on the calculation results, the real-time data and the historical data.

[0107] This application uses AMEsim to establish a hydraulic system mechanism simulation model as the underlying computing platform, supplements the calculation of state parameters that cannot be monitored by sensors, and complements the real-time data collected by sensors; builds a communication interface and a system communication database; builds a digital twin system visualization monitoring platform, and connects the above parts through a data communication interface, thereby realizing a more comprehensive online monitoring and mechanism simulation analysis of the hydraulic system mechanism of the top drive tilting device, so as to improve the real-time state monitoring and mechanism mapping analysis level of the working mechanism of the hydraulic system of the top drive tilting device, which is helpful to improve the intelligent operation and maintenance capabilities of the top drive equipment.

[0108] In this embodiment, the real-time data and historical data of the hydraulic system of the top drive tilting device are acquired through the data acquisition module; the real-time data and the historical data are acquired and stored from the data acquisition module through the twin system database; the simulation operation data sent by the twin system database are acquired, and the simulation operation data are simulated to obtain the operation result, and the operation result is sent to the twin system database; the operation result created and sent by the twin system database based on the locally stored data and the real-time data and the historical data sent by the data acquisition module are acquired, and based on the operation result, the real-time data and the historical data, the visual state detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device are realized. This application utilizes the underlying computing platform of the twin system to perform simulation operations on the simulation operation data sent by the twin system database to obtain the operation results, and utilizes the digital twin monitoring system to realize the visual state detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device based on the operation results, real-time data and historical data. The operation results are complemented by the real-time data and historical data, and various aspects of data are considered and transmitted to the digital twin monitoring system for visual display, thereby realizing the visual state detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device, and improving the accuracy of the visual state detection and mechanism mapping analysis.

[0109] Figure 6 A structural diagram of a visual state detection and mechanism mapping analysis device provided in an embodiment of the present application. The visual state detection and mechanism mapping analysis device 20 may specifically include: at least one processor 21, at least one memory 22, a power supply 23, a communication interface 24, an input / output interface 25, and a communication bus 26. The memory 22 is used to store a computer program, which is loaded and executed by the processor 21 to implement the relevant steps in the visual state detection and mechanism mapping analysis method performed by an electronic device disclosed in any of the aforementioned embodiments.

[0110] In this embodiment, the power supply 23 is used to provide working voltage for each hardware device on the visualization state detection and mechanism mapping analysis device 20; the communication interface 24 can create a data transmission channel between the visualization state detection and mechanism mapping analysis device 20 and external devices, and the communication protocol it follows is any communication protocol that can be applied to the technical solution of the present application, and is not specifically limited here; the input and output interface 25 is used to obtain external input data or output data to the outside world, and its specific interface type can be selected according to specific application needs, and is not specifically limited here.

[0111] In addition, the memory 22, as a carrier for storing resources, can be a read-only memory, a random access memory, a disk or an optical disk, etc. The resources stored thereon include an operating system 221, a computer program 222 and data 223, etc. The storage method can be temporary storage or permanent storage.

[0112] Among them, the operating system 221 is used to manage and control the hardware devices and computer programs 222 on the visualization state detection and mechanism mapping analysis device 20, so as to realize the operation and processing of the data 223 in the memory 22 by the processor 21, which can be Windows, Unix, Linux, etc. In addition to including a computer program that can be used to complete the visualization state detection and mechanism mapping analysis method performed by the visualization state detection and mechanism mapping analysis device 20 disclosed in any of the aforementioned embodiments, the computer program 222 can also further include a computer program that can be used to complete other specific tasks. In addition to including data transmitted from an external device received by the visualization state detection and mechanism mapping analysis device, the data 223 can also include data collected by its own input and output interface 25, etc.

[0113] The steps of the method or algorithm described in conjunction with the embodiments disclosed herein may be implemented directly using hardware, a software module executed by a processor, or a combination of the two. The software module may be placed in a random access memory (RAM), a memory, a read-only memory (ROM), an electrically programmable ROM, an electrically erasable programmable ROM, a register, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.

[0114] Furthermore, an embodiment of the present application also discloses a computer-readable storage medium, in which a computer program is stored. When the computer program is loaded and executed by a processor, the steps of the visualization state detection and mechanism mapping analysis method disclosed in any of the aforementioned embodiments are implemented.

[0115] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0116] The above is a detailed introduction to a visual state detection and mechanism mapping analysis system, method, device and storage medium provided by the present invention. Specific examples are used in this article to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea; at the same time, for general technical personnel in this field, according to the idea of ​​the present invention, there will be changes in the specific implementation method and application scope. In summary, the content of this specification should not be understood as a limitation on the present invention.

Claims

1. A visual state detection and mechanism mapping analysis system, characterized in that: include: A data acquisition module, used to acquire real-time data and historical data of the hydraulic system of the top drive tilting device; A twin system database, used to acquire and store the real-time data and the historical data from the data acquisition module; The underlying computing platform of the twin system is used to obtain the simulation operation data sent by the twin system database, perform simulation operation on the simulation operation data to obtain operation results, and send the operation results to the twin system database; The digital twin monitoring system is used to obtain the calculation results created and sent by the twin system database based on locally stored data, as well as the real-time data and the historical data sent by the data acquisition module, and based on the calculation results, the real-time data and the historical data, realize the visual status detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device.

2. The visual state detection and mechanism mapping analysis system according to claim 1 is characterized in that: The data acquisition module comprises: A connection module is used to establish a connection relationship with a hardware monitoring and control device of a hydraulic system of a top drive tilting device; the hardware monitoring and control device includes a sensor and an industrial computer; the sensor includes a temperature sensor, a pressure sensor and a position sensor; the industrial computer includes a programmable logic controller; An acquisition module is used to acquire real-time data and historical data of the hydraulic system of the top drive tilting device through the connection relationship; the real-time data and historical data include hydraulic oil temperature, pressure, hydraulic valve status, hydraulic cylinder position and hydraulic pump status.

3. The visual state detection and mechanism mapping analysis system according to claim 1 is characterized in that: The twin system database includes: A database building module, used to build a twin system database using a relational database; the relational database includes a MySQL database; A data storage module, used for acquiring and storing the real-time data and the historical data from the data acquisition module through a data communication interface; The database management module is used to manage the twin system database using a database visualization management tool; the database visualization management tool includes Navicat.

4. The visual state detection and mechanism mapping analysis system according to claim 1 is characterized in that: The underlying computing platform of the twin system includes: A platform construction module is used to construct a twin system underlying computing platform of the hydraulic system mechanism of the top drive tilting device; the twin system underlying computing platform includes an AMESim simulation model; A simulation operation module is used to obtain the simulation operation data sent by the twin system database through the data communication interface, and use the AMESim simulation model to perform simulation operation on the simulation operation data to obtain the operation result; The calculation result sending module is used to send the calculation result to the twin system database through the data communication interface.

5. The visual state detection and mechanism mapping analysis system according to claim 4 is characterized in that: The simulation operation module further includes: The component attribute parameter acquisition module is used to acquire the attribute parameters of the mechanical hydraulic components of the hydraulic system of the top drive tilting device; the mechanical hydraulic components include a hydraulic pump, a hydraulic valve, a hydraulic motor, a hydraulic cylinder and a hydraulic pipeline; A simulation operation data acquisition module, used to acquire the simulation operation data sent by the twin system database through the data communication interface; A calculation result determination module, used for performing simulation calculation on the simulation calculation data by using the AMESim simulation model and based on the attribute parameters in the component attribute parameter acquisition module and related hydraulic calculation formulas to obtain a calculation result; Among them, the relevant hydraulic calculation formulas include flow equations, basic equations of fluid dynamics, pressure equations for describing the relationship between pressure and force in hydraulic components, hydraulic cylinder motion equations for describing the relationship between the speed and flow of the hydraulic cylinder, Darcy-Weisbach formula for calculating fluid resistance losses in pipelines, hydraulic power formulas for calculating hydraulic system power, hydraulic efficiency formulas for calculating hydraulic component efficiency, continuity equations for calculating inlet and outlet flow in hydraulic systems, and formulas for the influence of temperature on viscosity and fluid properties in hydraulic systems.

6. The visual state detection and mechanism mapping analysis system according to claim 1 is characterized in that: Also includes: Monitoring system building module, used to build a digital twin monitoring system based on a real-time 3D interactive content creation and operation platform; Accordingly, the digital twin monitoring system includes: A visualization status detection module, for realizing various aspects of visualization status detection of the hydraulic system of the top drive tilting device by using the three-dimensional model and user interface of Unity3D and based on the calculation results, the real-time data and the historical data; The mechanism mapping analysis module is used to perform mechanism mapping analysis and fault alarm on the hydraulic system of the top drive tilting device.

7. The visual state detection and mechanism mapping analysis system according to any one of claims 1 to 6, characterized in that: Also includes: A data communication interface is used to construct a data communication interface through an open database connection interface and using a programming language; Parameter table, used to obtain and store key parameters of the hydraulic system of the top drive tilting device through the data communication interface; The variable browser is used to obtain and store the calculation results sent by the underlying computing platform of the twin system through the data communication interface, and then send the calculation results to the twin system database, so that the twin system database forwards the calculation results to the digital twin monitoring system for visual status detection and mechanism mapping analysis.

8. A visual state detection and mechanism mapping analysis method, characterized in that: include: Acquire real-time data and historical data of the hydraulic system of the top drive tilting device through the data acquisition module; Acquire and store the real-time data and the historical data from the data acquisition module through a twin system database; Acquire the simulation operation data sent by the twin system database, perform simulation operation on the simulation operation data to obtain operation results, and send the operation results to the twin system database; Obtain the calculation results created and sent by the twin system database based on locally stored data, as well as the real-time data and the historical data sent by the data acquisition module, and implement visual status detection and mechanism mapping analysis of the hydraulic system of the top drive tilting device based on the calculation results, the real-time data and the historical data.

9. An electronic device, characterized in that: include: Memory, used to store computer programs; A processor is used to execute the computer program to implement the visualization state detection and mechanism mapping analysis method as claimed in claim 8.

10. A computer-readable storage medium, characterized in that: Used to store a computer program; wherein, when the computer program is executed by a processor, the visualization state detection and mechanism mapping analysis method as described in claim 8 is implemented.

Images