Graphical configuration-based advanced computing engine and data processing method thereof

Abstract

The invention provides an advanced computing engine and method based on graphical configuration and a real-time database system, and the engine comprises a model building module which is used for building a visual model by dragging and connecting graphical configuration elements through a mouse; the data acquisition module is used for determining a calculation object and acquiring parameter information of the calculation object from the real-time database by using the read-write communication component; the advanced calculation module is used for associating parameter information of a calculation object, downloading a calculation task and carrying out advanced calculation on a visual model built based on a graphical configuration element; and the storage management module is used for writing the calculation result of the advanced calculation module back to the real-time database of the calculation object by using the read-write communication component. According to the method, various complex data processing and calculation tasks are completed by means of the read-write communication component specially used for real-time database interaction in a mode of quickly building a visual model for calculation by using graphical configuration, and the functions of high-speed calculation, real-time output and the like of a large amount of real-time data are realized.

Description

Technical Field

[0001] The present invention relates to a data processing method for real-time data, and in particular to an advanced computing engine based on a graphical configuration and a real-time database system and a data processing method thereof. Background Art

[0002] With the development of modern industrial production and the popularization of application scenarios such as real-time analysis, people's requirements for data processing and response speed are getting higher and higher. Traditional relational databases may not be able to meet the needs of large-scale real-time data processing in these scenarios. Real-time databases are gradually replacing traditional relational databases due to their high performance, low latency, large-scale data processing capabilities and flexible data models, becoming the preferred solution to meet real-time data processing needs.

[0003] With the digital transformation of industrial production and manufacturing, people have a growing demand for computing industrial real-time data. On the one hand, computing real-time data can help companies monitor the operating status of equipment, discover problems in a timely manner and take countermeasures for maintenance, thereby improving production efficiency and reducing equipment failure rates; on the other hand, analyzing real-time data can help companies discover potential problems in the production process, optimize the production process, save energy consumption, and reduce production costs. By computing and analyzing real-time data, industrial companies can improve their competitiveness and achieve efficient production and operation management.

[0004] At present, in the actual production process, most users complete the calculation and analysis of real-time data through traditional text programming.

[0005] However, using traditional text programming to complete real-time data calculation and analysis is not only complicated, but also cannot guarantee the accuracy and integrity of the code, and cannot meet the flexibility and scalability of business development. On the other hand, for users who lack programming knowledge, it is extremely inconvenient to use, and the user experience and reliability are poor. Summary of the invention

[0006] The purpose of the present invention is to solve the above problems and provide an advanced computing engine and method based on graphical configuration and real-time database system.

[0007] This application applies graphical configuration to real-time databases, and performs data transmission and calculation between the visualization model built by graphical configuration and the real-time database background. In the graphical configuration module, a read-write communication component dedicated to real-time database interaction is integrated to realize information interaction between graphical configuration and real-time database.

[0008] The present application provides an advanced computing engine based on graphical configuration and real-time database system, including:

[0009] Model building module, used to drag and connect graphical configuration components with the mouse to build a visual model;

[0010] The data acquisition module is used to determine the calculation object and obtain the parameter information of the calculation object from the real-time database using the read-write communication component;

[0011] Advanced calculation module, used to associate the parameter information of the calculation object and download the calculation task, and perform advanced calculations on the visual model built based on the graphical configuration components;

[0012] The storage management module is used to use the read-write communication component to write the calculation results of the advanced calculation module back to the real-time database of the calculation object.

[0013] The present application also provides a data processing method for real-time data, which uses the above-mentioned advanced computing engine to process data, and the method includes:

[0014] S1: Use the model building module to drag and connect graphical configuration components to build a visual model;

[0015] S2: Determine the calculation object using the data acquisition module, and obtain parameter information of the calculation object from the real-time database using the read-write communication component;

[0016] S3: Use the advanced calculation module to associate the parameter information of the calculation object and download the calculation task, and perform advanced calculations on the visual model built based on the graphical configuration components;

[0017] S4: The calculation results of the advanced calculation module are written back to the real-time database of the calculation object by using the read-write communication component through the storage management module.

[0018] In at least one embodiment, step S1 comprises:

[0019] Preset the calculation model according to the business scenario requirements, create a project, and use the mouse to drag and connect graphical configuration components, establish logical relationships, and build a visual model.

[0020] In at least one embodiment, step S2 comprises:

[0021] Establish the corresponding relationship between the visualization model parameters and the physical equipment, and determine the calculation object;

[0022] By means of a read-write communication component dedicated to real-time database interaction, a connection with the real-time database is established, parameter information of the calculation object is obtained from the real-time database, and information interaction between the graphical configuration and the real-time database is realized.

[0023] In at least one embodiment, step S3 comprises:

[0024] The parameter information of the calculation object is associated and the calculation task is downloaded. For the visualization model built based on the graphical configuration element, the script task of the visualization model is executed to perform real-time calculation.

[0025] In at least one embodiment, step S4 comprises:

[0026] The final calculation result of the advanced calculation module is output, and the calculation result is written back and stored in the real-time database of the calculation object through the read-write communication component dedicated to real-time database interaction.

[0027] In at least one embodiment, in step S1,

[0028] According to business needs and scenarios, clarify the problems to be solved, plan the mathematical model or algorithm model to be built and conduct preliminary design, including the model structure, parameter selection, and evaluation indicators;

[0029] Using graphical configuration components to build a visual model includes creating a new project, opening a project, editing files, and saving files.

[0030] In at least one embodiment, in step S2, the step of obtaining parameter information of the calculation object from the real-time database includes:

[0031] S21: Corresponding the parameters of the visualization model described in step S1 to the physical device, establishing a corresponding relationship between the visualization model parameters and the physical device, thereby determining the calculation object;

[0032] S22: With the help of a read-write component dedicated to the real-time database, edit the configuration attribute information according to the computing object determined in step S21, and establish a connection with the real-time database, the attribute information including the real-time database IP, port, bit number ID, etc.;

[0033] S23: Acquire parameter information of the computing object from a real-time database through a specific communication protocol, wherein the communication protocol includes TCP, OPC, GRPC, MQTT, etc.

[0034] In at least one embodiment, step S3 comprises:

[0035] S31: Associating data, mapping the parameters involved in the calculation model into the graphical configuration elements of the visualization model, using the data obtained in step S2 to associate parameters of each graphical configuration element, and storing the data carried by each graphical configuration element in a corresponding data area according to the visualization model;

[0036] S32: Execute calculations, download calculation tasks and call the underlying interface functions of each component through the corresponding processing mechanism according to the logical order of the visualization model, execute the functions of each component, transfer data along the connection lines, and obtain the final calculation results after processing and calculation by each graphical configuration component.

[0037] In at least one embodiment, in step S4, the step of writing the calculation result back to the real-time database includes:

[0038] S41: The final calculation result of the advanced calculation module is presented in the result display module, and the calculation result is further processed or exported as needed;

[0039] S42: writing back the result, writing back the final calculation result of the advanced calculation module to the real-time database of the calculation object through the read-write communication component.

[0040] The method of the present invention applies graphical configuration and advanced computing engine to real-time database, and uses graphical configuration to quickly build visual models for computing, and with the help of read-write communication components dedicated to real-time database interaction, completes various complex data processing and computing tasks, and realizes functions such as high-speed computing and real-time output of large amounts of real-time data. This method avoids traditional text programming, simplifies the computing process, and solves the problems of complex operation process, low work efficiency, and poor flexibility. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] The following will further explain the above characteristics, technical features, advantages and implementation methods of the present application in a clear and understandable manner through the description of the preferred embodiments and in combination with the accompanying drawings. The following drawings are only intended to illustrate and explain the present application, and do not limit the scope of the present application. Among them:

[0042] Figure 1 It is a flow chart of the data processing method of the advanced computing engine based on the graphical configuration and real-time database system;

[0043] Figure 2 It is a schematic diagram of the application process of the advanced computing engine based on graphical configuration and real-time database system;

[0044] Figure 3 It is a schematic diagram of data transmission of advanced computing engine based on graphical configuration and real-time database system. DETAILED DESCRIPTION

[0045] In order to have a clearer understanding of the technical features, purposes and effects of the present application, the specific implementation methods of the present application are now described with reference to the accompanying drawings.

[0046] Graphical configuration is an engineering application software based on computer technology. It is usually used in monitoring, control and automation systems. It mainly relies on computer graphics, database technology, various programming languages ​​and other technologies to achieve graphical configuration functions through the design of graphical user interfaces and development toolkits. Based on the configuration of graphical interface development, there is no need to write code during the development process. The layout of the graphical interface, the association of data and the design of human-computer interaction response are completed in a WYSIWYG visual design mode. In addition, graphical configuration technology also has the advantages of easy expansion, easy maintenance and easy operation, and has been widely used in modern industrial production and artificial intelligence fields.

[0047] The present invention proposes an advanced computing engine based on graphical configuration and real-time database system, comprising the following modules:

[0048] Model building module, used to connect graphical configuration components by dragging the mouse to quickly build a visual model;

[0049] A data acquisition module is used to determine a calculation object and obtain parameter information of the calculation object from a real-time database using a read-write communication component;

[0050] Advanced calculation module, used to associate the parameter information of the calculation object and download the calculation task, and perform advanced calculations on the visual model built based on the graphical configuration components;

[0051] The storage management module is used to use the read-write communication component to write the calculation results of the advanced calculation module back to the real-time database of the calculation object.

[0052] The present invention applies graphical configuration and advanced computing engine to real-time database, and uses graphical configuration to quickly build visual models for computing. With the help of read-write communication components dedicated to real-time database interaction, various complex data processing and computing tasks are completed, and functions such as high-speed computing and real-time output of large amounts of real-time data are realized. This method avoids traditional text programming, simplifies the computing process, and solves the problems of complex operation process, low work efficiency, and poor flexibility.

[0053] The following will refer to the attached Figure 1-3 The present invention is described in detail. Figure 1 shows the data processing method of the advanced computing engine, Figure 2 The application process of the engine is shown. Figure 3 The data transmission process of the computing engine is shown.

[0054] According to one embodiment of the present invention, a data processing method based on an advanced computing engine of a graphical configuration and real-time database system is provided. Figure 1 As shown, the method comprises the following steps:

[0055] S1: Model building: preset the calculation model according to the business scenario requirements, create a project and use the mouse to drag and connect graphical configuration components, establish logical relationships, and build a visual model;

[0056] S2: Data acquisition, establishing the corresponding relationship between the calculation model parameters and the physical equipment, and determining the calculation object; using the read-write communication component dedicated to the real-time database interaction, establishing a connection with the real-time database, obtaining the parameter information of the calculation object from the real-time database, and realizing the information interaction between the graphical configuration and the real-time database;

[0057] S3: Advanced calculation, associating the parameter information of the calculation object and downloading the calculation task, for the visualization model built based on the graphical configuration element, executing the visualization model script task for real-time calculation;

[0058] S4: Data transmission and storage, outputting the final calculation results of the advanced calculation module, and writing and storing the calculation results back to the real-time database of the calculation object through the read-write communication component dedicated to real-time database interaction.

[0059] Furthermore, in step S1, according to business needs and scenarios, the problems to be solved are clarified, and the mathematical model or algorithm model to be constructed is planned and pre-designed, including the structure of the model, parameter selection, evaluation indicators, etc. The visual model is built using graphical configuration components, including new project, project opening, file editing, and file saving operations. The specific implementation process is as follows:

[0060] S11: Create a new project and fill in the name of the project;

[0061] The new project includes a graphical design page and a graphical configuration element, and the preset calculation model construction work described in step S1 is performed in the design page;

[0062] S12: according to the preset calculation model described in step S11, enter the graphical design interface described in step S11, browse the model resource management module, select a required graphical configuration element according to the demand, and use the mouse to drag the graphical configuration element to the graphical design interface to add the graphical configuration element to the visualization model;

[0063] The model resource management module includes various graphical configuration elements;

[0064] The graphical configuration components include: components that graphically encapsulate various calculation formulas, intelligent algorithms, logical judgments, data reading, data writing, etc. into modules, each of which represents a specific calculation function; by clicking and dragging the graphical configuration component icons, the arrangement order of the icons is changed to change the calculation logic of the model; by corresponding operations on the component icons, operations such as deleting the components and adjusting the size of the component icons can be realized;

[0065] S13: connecting the graphical configuration elements by creating lines between the output and input ports of the graphical configuration elements, and establishing connection relationships of the graphical configuration elements, such as data flow direction, collaboration relationship, etc.;

[0066] S14: After confirming that the model is built correctly, click the Save button to save the model and complete the construction of the visualization model.

[0067] Furthermore, in step S2, data is obtained from the real-time database, and the specific implementation process is as follows:

[0068] S21: Corresponding the parameters of the calculation model in step S1 to the physical device, establishing a corresponding relationship between the calculation model parameters and the physical device, thereby determining the calculation object;

[0069] S22: With the help of a read / write component dedicated to the real-time database, edit the configuration attribute information (such as the real-time database IP, port, bit ID, etc.) of the computing object in S21 to establish a connection with the real-time database;

[0070] S23: Obtain parameter information of the computing object from a real-time database through a specific communication protocol (eg, TCP, OPC, GRPC, MQTT, etc.).

[0071] Furthermore, in step S3, the object data is associated and advanced calculations are performed, and the specific implementation process is as follows:

[0072] S31: Associating data, mapping the parameters involved in the calculation model into the graphical configuration elements of the visualization model, using the data obtained in step S2 to associate parameters of each graphical configuration element, and storing the data carried by each element in a corresponding data area according to the visualization model;

[0073] S32: Execute calculations, download calculation tasks and call the underlying interface functions of each component through the corresponding processing mechanism according to the logical order of the visualization model, execute the functions of each component, transmit data along the connection lines, and obtain the final calculation results after processing and calculation by each component.

[0074] Furthermore, in step S4, the calculation result is written back to the real-time database, and the specific implementation process is as follows:

[0075] S41: The final calculation results of the advanced calculation module will be presented in the result display module. If necessary, the calculation results can be further processed or exported;

[0076] S42: writing back the result, writing back the final calculation result of the advanced calculation module to the real-time database of the calculation object through the read-write communication component.

[0077] The present application provides an advanced computing engine and method based on graphical configuration and real-time database system. By using graphical configuration to quickly build a visual model for calculation, various complex data processing and computing tasks are completed with the help of read-write communication components dedicated to real-time database interaction, thereby realizing functions such as high-speed calculation and real-time output of large amounts of real-time data.

[0078] The above description is only an illustrative embodiment of the present application and is not intended to limit the scope of the present application. Any equivalent changes, modifications and combinations made by any technician in the field without departing from the concept and principle of the present application shall fall within the scope of protection of the present application.

Claims

1. An advanced computing engine based on graphical configuration and real-time database system, including: Model building module, used to drag and connect graphical configuration components with the mouse to build a visual model; The data acquisition module is used to determine the calculation object and obtain the parameter information of the calculation object from the real-time database using the read-write communication component; Advanced calculation module, used to associate the parameter information of the calculation object and download the calculation task, and perform advanced calculations on the visual model built based on the graphical configuration components; The storage management module is used to use the read-write communication component to write the calculation results of the advanced calculation module back to the real-time database of the calculation object.

2. A method for processing real-time data, using the advanced computing engine according to claim 1 to process data, the method comprising: S1: Use the model building module to drag and connect graphical configuration components to build a visual model; S2: Determine the calculation object using the data acquisition module, and obtain parameter information of the calculation object from the real-time database using the read-write communication component; S3: Use the advanced calculation module to associate the parameter information of the calculation object and download the calculation task, and perform advanced calculations on the visual model built based on the graphical configuration components; S4: The calculation results of the advanced calculation module are written back to the real-time database of the calculation object by using the read-write communication component through the storage management module.

3. The method according to claim 2, wherein step S1 comprises: Preset the calculation model according to the business scenario requirements, create a project, and use the mouse to drag and connect graphical configuration components, establish logical relationships, and build a visual model.

4. The method according to claim 2, wherein step S2 comprises: Establish the corresponding relationship between the visualization model parameters and the physical equipment, and determine the calculation object; By means of a read-write communication component dedicated to real-time database interaction, a connection with the real-time database is established, parameter information of the calculation object is obtained from the real-time database, and information interaction between the graphical configuration and the real-time database is realized.

5. The method according to claim 2, wherein step S3 comprises: The parameter information of the calculation object is associated and the calculation task is downloaded. For the visualization model built based on the graphical configuration element, the script task of the visualization model is executed to perform real-time calculation.

6. The method according to claim 2, wherein step S4 comprises: The final calculation result of the advanced calculation module is output, and the calculation result is written back and stored in the real-time database of the calculation object through the read-write communication component dedicated to real-time database interaction.

7. The method according to claim 2, wherein in step S1, According to business needs and scenarios, clarify the problems to be solved, plan the mathematical model or algorithm model to be built and conduct preliminary design, including the model structure, parameter selection, and evaluation indicators; Using graphical configuration components to build a visual model includes creating a new project, opening a project, editing files, and saving files.

8. The method according to claim 2, wherein in step S2, the step of obtaining parameter information of the calculation object from the real-time database comprises: S21: Corresponding the parameters of the visualization model described in step S1 to the physical device, establishing a corresponding relationship between the visualization model parameters and the physical device, thereby determining the calculation object; S22: With the help of a read-write component dedicated to the real-time database, edit the configuration attribute information of the computing object determined in step S21 to establish a connection with the real-time database, wherein the attribute information includes the real-time database IP, port, and bit ID; S23: Acquire parameter information of the computing object from a real-time database through a specific communication protocol, wherein the communication protocol includes TCP, OPC, GRPC, and MQTT.

9. The method according to claim 3, wherein step S3 comprises: S31: Associating data, mapping the parameters involved in the calculation model into the graphical configuration elements of the visualization model, using the data obtained in step S2 to associate parameters of each graphical configuration element, and storing the data carried by each graphical configuration element in a corresponding data area according to the visualization model; S32: Execute calculations, download calculation tasks and call the underlying interface functions of each component through the corresponding processing mechanism according to the logical order of the visualization model, execute the functions of each component, transfer data along the connection lines, and obtain the final calculation results after processing and calculation by each graphical configuration component.

10. The method according to claim 2, wherein in step S4, the step of writing the calculation result back to the real-time database comprises: S41: The final calculation result of the advanced calculation module is presented in the result display module, and the calculation result is further processed or exported as needed; S42: writing back the result, writing back the final calculation result of the advanced calculation module to the real-time database of the calculation object through the read-write communication component.

Images