Data processing method and system, electronic equipment, storage medium and program product

Abstract

The invention discloses a data processing method and system, electronic equipment, a storage medium and a program product, and the method comprises the steps: responding to first user input, and according to a first data range specified by the first user input, creating a first display control for representing the first data range; the first data range comprises at least part of data in the first database; in response to a second user input, creating a second display control for representing a second data range according to the second data range specified by the second user input; the second data range comprises at least part of data in the second database; displaying fused data of the first data range and the second data range in response to a third user input; the third user input comprises an association interaction operation used for associating the first display control with the second display control. According to the method and the device, data fusion of different databases is realized through visual association interaction operation on the two display controls, so that the operation modes of query and fusion are more intuitive.

Description

Technical Field

[0001] The present application relates to the field of database technology, and in particular to a data processing method, system, electronic device, storage medium and program product. Background Art

[0002] In related technologies, when querying data in a database, queries and integration are usually performed by writing Structured Query Language (SQL) statements. However, if the enterprise personnel using the database are not proficient in database operation statements, it is not easy to perform the required operations on the data in the database. Summary of the Invention

[0003] In response to the above-mentioned deficiencies in the prior art, the present application proposes a data processing method, system, electronic device, storage medium and program product, which can perform associated interactive operations on data from different databases in a visual manner, thereby obtaining the fusion results of data from different databases.

[0004] A first aspect of the present application provides a data processing method, the method comprising:

[0005] In response to a first user input, creating a first display control for representing a first data range according to a first data range specified by the first user input; the first data range includes at least part of the data in the first database;

[0006] In response to a second user input, creating a second display control for representing a second data range according to a second data range specified by the second user input; the second data range includes at least part of the data in the second database;

[0007] In response to a third user input, fused data of the first data range and the second data range is displayed; the third user input includes an associating interaction operation for associating the first display control with the second display control.

[0008] A first aspect of the present application provides a data processing system, the system comprising:

[0009] Multiple databases;

[0010] A data processing device is used to create a first display control for representing a first data range in response to a first user input, based on a first data range specified by the first user input; the first data range includes at least part of the data in a first database; in response to a second user input, create a second display control for representing a second data range in response to a second user input, based on a second data range specified by the second user input; the second data range includes at least part of the data in a second database; in response to a third user input, display fused data of the first data range and the second data range; the third user input includes an associated interactive operation for associating the first display control with the second display control; the multiple databases include a first database and a second database.

[0011] The third aspect of the present application proposes an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the method described in the first aspect above.

[0012] A fourth aspect of the present application provides a computer-readable storage medium having a computer program stored thereon, wherein the program is executed by a processor to implement the method described in the first aspect above.

[0013] An embodiment of the fifth aspect of the present application provides a computer program product, including a computer program, which is executed by a processor to implement the method described in the first aspect above.

[0014] Based on the data processing method described in the first aspect above, this application has at least the following beneficial effects or advantages:

[0015] Based on the data range specified by the first user input in the first database, the data range included in the first data range is determined, and a first display control for representing the first data range is created. Based on the data range specified by the second user input in the second database, the data range included in the second data range is determined, and a second display control for representing the second data range is created. Then, the user can fuse the data of the first data range and the second data range through the associated interactive operation of the first display control and the second display control to obtain and display the fused data. This method of jointly querying different databases uses explicit controls rather than database names, field names, etc. to represent the data range that the user wants to query, so that the fused data expected by the user can be obtained through the associated interactive operation of the two display controls. The query and fusion operation methods are more intuitive and simpler, which reduces the technical threshold for querying data. In addition, in the prior art, if a user needs data from different databases, the user needs to be familiar with the field semantics, query operations, etc. in different databases and view the data in different databases separately. However, the embodiment of the present application can fuse the data from different databases, making it convenient for the user to view the data from different databases at the same time, thereby making it more convenient for the user to analyze and compare related data.

[0016] The above description is only an overview of the technical solution of this application. In order to more clearly understand the technical means of this application, it can be implemented in accordance with the contents of the specification. In order to make the above and other purposes, features and advantages of this application more obvious and easy to understand, the specific implementation methods of this application are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] The drawings described herein are used to provide a further understanding of the present application and constitute a part of the present application. The illustrative embodiments of the present application and their descriptions are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:

[0018] Figure 1 is a flow chart of a data processing method according to some exemplary embodiments;

[0019] Figure 2 is a schematic diagram of an interface of a data processing method according to some exemplary embodiments;

[0020] Figure 3 is a schematic diagram of an interface of a data processing method according to some further exemplary embodiments;

[0021] Figure 4 is a schematic diagram of an interface of a data processing method according to some further exemplary embodiments;

[0022] Figure 5 is a schematic diagram of an interface of a data processing method according to some further exemplary embodiments;

[0023] Figure 6 is a schematic diagram of an interface of a data processing method according to some further exemplary embodiments;

[0024] Figure 7 is a schematic diagram of an interface of a data processing method according to some further exemplary embodiments;

[0025] Figure 8 is a structural diagram of a data processing system according to an exemplary embodiment;

[0026] Figure 9 is a structural diagram of a data processing device according to an exemplary embodiment;

[0027] Figure 10 The figure is a schematic diagram of the hardware structure of an electronic device according to an exemplary embodiment. DETAILED DESCRIPTION

[0028] Exemplary embodiments will be described in detail herein, with examples illustrated in the accompanying drawings. In the following description, when referring to the drawings, identical numerals in different figures represent identical or similar elements, unless otherwise indicated. The embodiments described in the following exemplary embodiments are not intended to represent all embodiments consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present application, as detailed in the appended claims.

[0029] The terms used in this application are for the purpose of describing specific embodiments only and are not intended to limit this application. As used in this application and the appended claims, the singular forms "a," "an," "the," and "the" are intended to include the plural forms, unless the context clearly indicates otherwise. It should also be understood that the term "and / or" as used herein refers to and encompasses any and all possible combinations of one or more of the associated listed items.

[0030] It should be understood that although the terms first, second, third, etc. may be used in this application to describe various information, such information should not be limited to these terms. These terms are only used to distinguish information of the same type from each other. For example, without departing from the scope of this application, first information may also be referred to as second information, and similarly, second information may also be referred to as first information. Depending on the context, the term "if" as used herein may be interpreted as "at the time of" or "when" or "in response to determining" or the like.

[0031] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with the relevant laws, regulations and standards of relevant countries and regions, and provide corresponding operation entrances for users to choose to authorize or refuse.

[0032] Operational Technology (OT) refers to technologies related to actual physical operations, primarily used to process and control field equipment, industrial production processes, and safety systems. OT primarily focuses on aspects of factory production lines, such as automated control, monitoring and sensing, real-time data acquisition and processing, and processes such as supervisory control and automation (SCADA), sensors and actuators, and industrial communication protocols. OT data typically includes operational data from industrial equipment. This data can be collected through automated sensors or industrial control systems. The collected data represents the status of the industrial equipment and is typically discrete and time-series data, such as current temperature, pressure, flow rate, speed, and other parameters.

[0033] Information Technology (IT) refers to technologies related to computer hardware, software, networking, and data management, primarily used to process and manage enterprise-level information and processes. IT primarily focuses on enterprise data processing, network communications, software development, and operations and maintenance, such as internal office automation systems, database management systems, and network equipment. IT data typically includes various management system data used by industrial enterprises during production and operations, typically structured and relational data, such as inventory data, batch prices for industrial equipment, employee salaries, and headcounts.

[0034] IT data can support and optimize OT technologies and services, such as leveraging computer networks and software systems to enable remote control and management of industrial equipment. Furthermore, OT's real-time data and production status can provide crucial information for IT business process decision-making and data analysis. Therefore, the integration of IT and OT data is a key trend in the current industrial sector. However, industrial enterprises often lack software R&D departments or capabilities, requiring some to rely on automation integrators for external procurement and delivery. Automation integrators provide industrial clients with application software, equipment, hardware, system integration, and other technical services, such as production line setup, control system commissioning, Supervisory Control and Data Acquisition (SCADA) data collection, and IT system deployment.

[0035] In related technologies, both automation integrators and industrial enterprises often use data applications to optimize the operating efficiency of production equipment, improve process flows, and manage energy consumption for industrial enterprises. These applications include Overall Equipment Effectiveness (OEE) tools, Statistical Process Control (SPC) tools, and energy systems. This helps industrial enterprises better optimize process flows and equipment operations, reducing costs and improving efficiency. However, in the process of developing and delivering these applications based on the specific circumstances of industrial enterprises, they face several major challenges, including heterogeneous data sources, loss of field semantics, and insufficient SQL capabilities. This makes it difficult to query the required data in the various databases of industrial enterprises, making it difficult to analyze and compare the data of industrial enterprises.

[0036] Specifically, the OT data of equipment operation and the IT data of business processes usually come from different data sources, are scattered in different departments and fields, and are in different databases, tables, and fields. In addition, different databases are usually heterogeneous, and there are large differences in data types, data structures, and data relationships. Some related technologies implement data fusion methods, including: synchronizing scattered data into one database through existing database synchronization technology, or fusing scattered data into a fusion engine through data warehouse technology (Extract Transform Load, ETL) tools, data middle platform and other technologies. However, if the databases are not homogenous or heterogeneous, it is difficult to fuse them. This is because when the data from different databases are fused through the fusion method in related technologies, the tables and fields of each database will lose their original semantic definitions, lose their original associations, lose their mapping relationships with the actual meanings of the industrial system, etc., and are completely separated from the semantic conventions of the original system, thereby affecting the next step of data analysis. Moreover, in the absence of professional database developers, automation integrators or industrial enterprises need to use complex SQL statements, such as subqueries, aggregations, and joins, to aggregate, integrate, purify, and process data. Therefore, it is still difficult to handle the massive amounts of complex data generated after the integration of multiple databases.

[0037] Currently, a number of products exist for data collection, data storage, or multi-mode database engines, each of which may have different issues. For example, the ROMAConnect platform can connect to IT system data but not OT data. Ignition, used to collect industrial equipment data, is adaptable to multiple PLC acquisition protocols and has the ability to collect and store OT data, but cannot connect to IT systems. The cloud-native multi-mode database Lindorm can store massive amounts of heterogeneous IT and OT data from Industrial IoT scenarios, but lacks the ability to collect IT or OT data. The Fusion Plant Industrial Internet Platform is a data middleware that supports IT / OT collection and integration, but users need to have strong IT data development capabilities to achieve data cleaning, integration, aggregation, and information mining at different levels of the system.

[0038] The data processing method provided by the embodiment of the present application can jointly query different databases, and uses explicit controls rather than characters such as database names and field names to indicate the data range that the user expects to query. Therefore, the user can obtain the desired fused data through the associated interactive operation of the two display controls. The query and fusion operation methods are more intuitive and simpler, lowering the technical threshold for querying data. In addition, in the prior art, if a user needs data from different databases, the user needs to be familiar with the field semantics and query operations in different databases, and view the data in different databases separately. However, the embodiment of the present application can fuse data from different databases, making it easier for users to view data from different databases at the same time, thereby making it easier for users to analyze and compare related data.

[0039] The following describes in detail the technical solution of this application and how it solves the aforementioned technical problems using specific embodiments. The several specific embodiments listed can be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments. The following describes the embodiments of this application in detail with reference to the accompanying drawings.

[0040] Figure 1 A flowchart of a data processing method provided in an embodiment of the present application is shown in FIG. Figure 1 As shown, the method specifically includes the following steps 101-103.

[0041] Step 101 : In response to a first user input, create a first display control for representing a first data range according to a first data range specified by the first user input.

[0042] Step 102 : In response to a second user input, create a second display control for representing a second data range according to a second data range specified by the second user input.

[0043] The first data range includes at least part of the data in the first database, and the second data range includes at least part of the data in the second database.

[0044] For any user input described in the embodiments of the present application, it may include user operations received based on the input device, and / or instructions converted based on user operations. The input device may include at least one of the following: a keyboard, a mouse, a touch screen, a camera, a touchpad, a stylus, a gyroscope, etc. Exemplarily, the user operation may be sliding, clicking, etc. on the surface of the touch screen or touchpad with a finger or a stylus, or the user performing an operation through gestures, body postures, etc. in front of the camera. In some embodiments, the user input is the user operation, while in other embodiments, after the input device receives the user operation, it may be converted by the input device, a device that executes the data processing method provided in the embodiments of the present application, etc., and the user operation is converted into an instruction that can be recognized by the device.

[0045] In some embodiments, any user input may be completed by one or more operations. During the operation, the user's operation may interact with the display screen, and the display screen may change based on the user's operation.

[0046] For example, the first user input may include the following process: the user clicks the icon used to represent the first database, and a tab page pops up on the interface, which includes multiple options corresponding to multiple fields in the first database. The user then clicks to select certain options, thereby specifying the data of the fields corresponding to the selected options in the first database and determining the first data range.

[0047] For another example, the user drags the icon used to represent the first database to the designated area, and a dialog box for the first database pops up, which includes a table selection box, a field selection box, and a primary key selection box. The table selection box displays a list of table names in the first database via a drop-down menu, and the field selection box displays a list of field names of the data table selected in the table selection box via a drop-down menu. The primary key selection box includes a list of primary keys of the selected data table and the field selected in the field selection box. The user's designated data range is determined by the user's single or multiple selections in the selection box. The above-mentioned name list can use the identifier in the original database or a custom name. The custom name is a redefined name for the corresponding object, which can be implemented by user editing or pre-configuration. After the user confirms the selection, a display control is generated to represent the specified data range.

[0048] For example, users can directly drag and drop specified tables, field names, etc. in the schema list based on the database model in the database. After dragging and dropping to the specified area, a display control representing the corresponding data range will be generated.

[0049] In step 101, the first user input can specify a first data range, and the user can specify the data range required by the user through some operations. For example, multiple database options can be provided in the form of a name list, icon, etc. The user selects the first database from the multiple databases and provides the names of the fields and even the primary keys of the first database. The user selects the specified fields and / or primary keys and specifies at least part of the data in the first database, thereby obtaining the data range of the first data range. It is understandable that at least part of the data also includes the case of the full amount of data. In some embodiments, the user can confirm the selection after specifying the first database, thereby confirming that the selected first data range is the first database.

[0050] It should be noted that specifying the first data range is different from synchronizing the first database. In some embodiments, after specifying the first data range, an SQL statement can be generated to query the specified data range in the first database. In these embodiments, for the database of the external data source, there is no need to synchronize the database, but the data required by the user in the external data source is obtained by real-time query. Compared with the technical solution in the related art that requires the database of the external data source to be stored locally and the external data source database to be synchronized (full or incremental synchronization) regularly, this embodiment does not require full storage of the external database, saving local storage resources, nor does it require regular synchronization with the external data source database, saving local computing resources and network bandwidth. In addition, in some embodiments, after obtaining the query results, the query results can be stored locally.

[0051] It is understood that in some embodiments, a step of querying a first database for data within a first data range may be included. This step may be triggered by a first user input or a third user input, and this is not limited in the embodiments of the present application. Similarly, in some embodiments, a step of querying a second database for data within a second data range may be included. This step may be triggered by a second user input or a third user input.

[0052] The first display control is used to map a first data range. The first display control is created in response to a first user input, and the first display control is used to represent the first data range. It should be noted that creating the first display control corresponding to the first data range does not necessarily require downloading the data within the first data range to the local computer. For example, if the first database is an external data source, after creating the first display control, a mapping table can be created between the first data range and the first display control, corresponding each table and field contained in the first data range to the table name and field name displayed in the first display control. Alternatively, an SQL statement can be created for querying and reading data within the first data range from the first database. In this case, there is no data within the first data range locally. In this example, after receiving a third user input, the data within the first data range is queried in response to the third user input. It is understood that the execution order of the query steps in the above example is an optional embodiment. In other embodiments, the step of querying the data within the first data range can be in response to the first user input to query and obtain the data within the first data range, or in response to other inputs that determine that the data within the first data range needs to be obtained from the first database, etc. This embodiment of the present application is not limited to this.

[0053] Optionally, the first display control may include at least one of the following types of display elements: text, graphics, icons, interactive elements, etc. The display content of the first display control may include at least one of the following: the name of the first database, the field name / primary key name of the first data range specified in the first database, etc. The first display control and the second display control may receive user operations, for example, they may move with the mouse when dragged, and they may modify the data range and / or field name when right-clicked.

[0054] It is understandable that step 102 is similar to step 101. Therefore, the description of the specific implementation of step 102 can refer to the description of step 101. It is understandable that the first user input described in step 101 and the second user input described in step 102 can include the same or different operation processes, and the first display control described in step 101 and the second display control described in step 102 can be the same or different styles and have the same or different operational functions.

[0055] Step 103 : In response to a third user input, display the fused data of the first data range and the second data range.

[0056] The third user input includes an associated interactive operation for associating the first display control with the second display control. Examples of associated interactive operations include: a user dragging the first display control into the display area of ​​the second display control; a user sequentially clicking the first display control and the second display control and pressing a preset shortcut key; a user clicking a connection point at the edge of the display area of ​​the first display control and dragging the control to a connection point at the edge of the display area of ​​the second display control. In some embodiments, in response to the third user input, a graphical representation of the associated interactive operation, such as a connecting line connecting the two display controls, may be displayed.

[0057] Fused data is generated by fusing data within a first data range with data within a second data range, and may include at least a portion of the data within the first data range and at least a portion of the data within the second data range. For example, referring to table join methods such as inner join, left join, and right join, the data within the first data range and the data within the second data range may be associated using the selected table join method to generate the fused data.

[0058] The fused data can be displayed as a table in a designated area. In some embodiments, the fused data can be displayed in a third display control, separate from the first and second display controls. Optionally, the third display control can be a table control. The fused data can be stored in the backend as a large, wide table and displayed in a data visualization chart on the frontend. For example, the fused data can be based on the primary key within the second data range, listing the data for all fields within the second data range that correspond to the primary key within the first data range.

[0059] In step 103, after receiving the third user input, in response to the third user input, a programming statement for fusing the data within the first data range and the data within the second data range, such as an SQL statement, etc., can be generated in the background. The generated programming statement can be applied by applying a preset template, and according to the first data range and the second data range specified by the user, fill in the content that needs to be filled in the programming statement template, such as the database name, database table name, database table field name, database login account and password used to connect to the external data source, etc. After the statement is generated, it is executed to generate the fused data. In some embodiments of the present application, the operation of the database can be implemented by the programming statement generated in the background to achieve the corresponding function, for example, it can include statements for executing the following steps: fusing the data within the first data range and the data within the second data range, querying the data within the first data range, querying the data within the second data range, logging into the database of the external data source, setting the table display format of the fused data, etc.

[0060] The data processing method provided in the embodiment of the present application determines the data range included in the first data range based on the data range specified by the first user input in the first database, creates a first display control for representing the first data range, determines the data range included in the second data range based on the data range specified by the second user input in the second database, and creates a second display control for representing the second data range. Then, the user can fuse the data of the first data range and the second data range by associating and interacting with the first display control and the second display control, obtain and display the fused data. This method of jointly querying different databases uses explicit controls rather than database names, field names, etc. to represent the data range that the user wants to query, so that the fused data that the user wants can be obtained by associating and interacting with the two display controls. The query and fusion operations are more intuitive and simpler, reducing the technical threshold for querying data. In addition, in the prior art, if a user needs data from different databases, the user needs to be familiar with the field semantics and query operations in the different databases and view the data in the different databases separately. However, the embodiment of the present application can fuse the data from different databases, making it convenient for the user to view the data from different databases at the same time, thereby making it more convenient for the user to analyze and compare related data.

[0061] In one example, before executing step 101, the mapping model of the first database can be displayed. Here, the mapping model of the first database is used to map the data structure of the first database. The mapping model of the first database is a data model pre-established based on the data structure of the first database, and the data model can represent the data structure of the first database. The data structure of the first database includes multiple data structure objects, such as databases, database tables, fields in database tables, primary keys in database tables, etc., and may also include associations between multiple data structure objects. Accordingly, the mapping model of the first database includes multiple mapping objects that are mapped one-to-one with multiple data structure objects, and may also include associations between multiple mapping objects, such as associations between database tables in the first database, etc. The above-mentioned mapping refers to each mapping object in the mapping model corresponding to each data structure object; further, the associations between each mapping object may correspond to the associations between each data structure object.

[0062] Each data structure object in the database has a corresponding identifier in the original database. Optionally, in the mapping model of the first database, the name of each mapping object and the identifier of each data structure object can be the same or different. That is, in some embodiments, the data structure objects in the original database can be given different names than in the original database, so that the attributes represented by the data can be more easily understood through semantics. Optionally, the name of each mapping object in the mapping model of the first database can be pre-established or user-modifiable. The user can customize the name of each mapping object in the mapping model to facilitate user understanding. Then, after displaying the mapping model of the first database, a first user input can be received to select a target mapping object from multiple mapping objects in the first database. The first data range is determined based on the target mapping object. It is understandable that the step of determining the first data range based on the target mapping object can be performed before, after, or during step 101. The embodiment of the present application does not specifically limit the execution order between background execution and front-end display, and different settings can be made according to the situation.

[0063] By displaying the mapping model of the database, the data structure of the database can be displayed, which makes it convenient for users to view the data structure of the database, helps users to quickly find the data structure objects they need in the data structure of the database, simplifies the difficulty of specifying the first data range, and does not require writing SQL statements. Moreover, even if the user does not know the data structure objects contained in the original database, the data structure of the original database can be clarified based on the displayed mapping model, which greatly facilitates the user's operation.

[0064] Furthermore, in some embodiments, step 101 may specifically include the following steps: in response to first user input, creating a first mapping dataset for mapping the first data range; then, adding a target mapping object to the first mapping dataset; and then creating a first display control associated with the first mapping dataset based on the first mapping dataset. In this embodiment, after the user selects the first data range, a dataset may be created in real time. In some implementations, the creation of the mapping dataset may be achieved by creating an externally linked table in real time in the background. The created dataset is used to map the first data range. For example, the dataset may include the mapping objects selected by the user in the mapping model, and the mapping objects correspond to data structure objects in the original database.

[0065] Optionally, when creating the first display control according to the created mapping data level, a display control style may be selected from a plurality of preset display control styles based on the selected data range, and corresponding content in the display control style may be changed according to the selected data range.

[0066] This embodiment creates a first mapping dataset to store the user's selected first data range, enabling the original data structure of the first data range to be preserved in a one-to-one mapping manner. Furthermore, the first display control is associated with the first mapping dataset in the backend. Users can interact with the first display control displayed on the frontend to synchronously perform corresponding operations on the first mapping dataset in the backend, such as adding, deleting, or modifying target mapping objects in the first mapping dataset. This collaboration between the frontend and backend enriches the user's operational options for specifying the first data range. In some embodiments, after creating the first mapping dataset, the first database can be queried for data within the first data range in response to a third user input. If data within the first data range is queried and downloaded from the first database in real time after the first mapping dataset is created, subsequent users who wish to modify the first data range before merging the data will need to re-query and download the updated data from the first database in real time, wasting system processing resources. Responses to third-user input avoid this situation, improving system processing efficiency.

[0067] In some embodiments, the first data range includes data of at least one field, and the second data range includes data of at least one field. The embodiment of the present application can also modify the field information of some fields in the table control used to display the fused data in response to a fourth user input. Among them, the table control of the fused data may include at least some fields of the first data range and some fields of the second data range. The above-mentioned field information includes at least one of the following: the name of the corresponding field, the type of the corresponding field, and the function of the corresponding field. Here, the function refers to performing an operation on the data of the corresponding field according to the selected function, that is, replacing the data in the corresponding field with the data obtained after performing the function operation.

[0068] In yet other embodiments, a target field may be added to the table control in response to a fifth user input. The target field is obtained by performing a function operation on a portion of fields in the first data range and / or a portion of fields in the second data range. That is, a target field may be added to the fused data. The target field is obtained by performing a function operation on multiple fields within the total data range of the first data range and the second data range.

[0069] It should be noted that the above-mentioned fourth user input and fifth user input can be executed before, after or during step 103, and the embodiment of the present application does not limit this. Among them, if the fourth user input is included in the execution of step 103, the third user input includes the fourth user input, and the fifth user input is the same, and no further details are given.

[0070] In some embodiments, before executing step 102 in response to the second user input and creating a second display control for representing the second data range according to the second data range specified by the second user input, the following steps may also be included: displaying a target database identifier set, the target database identifier set including identifiers of multiple databases, the multiple databases including the second database, and receiving a second user input for selecting the second database identifier from the multiple database identifiers. In this case, the full amount of data in the second database is the second data range specified by the user. In this way, the space for the user to specify the data range can be expanded without being restricted to selecting only part of the data in the first database. Optionally, a database table can also be specified by a database table identifier.

[0071] It should be noted that the first and second mentioned above are only used to distinguish two different objects and are not used to constitute a limitation on the specific implementation methods. The specific implementation methods corresponding to the first object and the second object respectively can be the same, different or interchangeable.

[0072] To prevent users from modifying the first and second data ranges, a third user input can be used to retrieve data within the first data range queried from the first database and retrieve data within the second data range queried from the second database. This avoids wasting storage and processing resources if the user abandons the fusion or requires modification after pre-acquiring the data within the first and second data ranges. After merging the data within the first and second data ranges, the fused data is obtained and displayed.

[0073] Optionally, when obtaining the data queried in the first database, the downloaded data can be obtained locally, or the first database can be queried in real time. In some embodiments, a local search can be conducted to determine whether there is data for each field in the first data range downloaded within the target time range. If all fields exist, no query is required. If some fields exist, the first database can be queried for the remaining fields that do not exist locally. Here, the target time range can be a recent period of time to prevent the locally stored data from being out of date due to updates to the first database.

[0074] It should be noted that the step of obtaining the data in the first data range queried from the first database is different from the step of requesting the first database to query the data in the first data range. Similarly, the step of obtaining the data in the second data range is the same. In some embodiments, before obtaining the data in the first data range queried from the first database, the first database may be requested to query the data in the first data range in response to a third user input. Before obtaining the data in the second data range queried from the second database, the second database may be requested to query the data in the second data range in response to a third user input. In this way, it is possible to avoid the waste of network resources, storage resources, and processing resources caused by the user giving up the fusion or needing to modify the data in the first data range and the second data range in advance.

[0075] In some embodiments, the fusion method of the fused data can be determined according to the associated interactive operation input by the third user, and then, based on the fusion method, the data in the first data range and the data in the second data range are fused to obtain the fused data. Exemplarily, the fused data can be to establish a connection between the data table corresponding to the first data range and the data table corresponding to the second data range through a table connection method, and the selection of the table connection method can be specified through an associated interactive operation. For example, by dragging the first display control to the second display control, it is indicated that the data table of the first data range and the data table of the second data range need to be connected. In this way, the user does not need to learn the programming statements for fusing the data, and can select the fusion method through visual interactive operations, thereby improving the convenience of user operation.

[0076] Furthermore, the direction of the table connection between the first and second data ranges can be determined based on the association direction indicated by the association interaction operation input by a third user. A table connection between the first and second data ranges can then be established based on the table connection direction to obtain fused data. For example, if a first display control is connected to a second display control, the second data range corresponding to the second display control will be the left table. This eliminates the need for users to learn programming statements for table connections and can instead select the table connection direction through visual interaction, improving user convenience.

[0077] Furthermore, in some embodiments, the specific implementation method for determining the fusion method can be determined based on the established graphic association relationship. Specifically, when determining the fusion method of the first data range and the second data range based on the associated interactive operation input by the third user, the graphic association relationship between the first display control and the second display control can be established and displayed based on the associated interactive operation input by the third user, and then the fusion method can be determined based on the graphic association relationship. Different graphic association relationships have corresponding fusion methods, and the corresponding relationships can be pre-configured by the system. In some embodiments, the user can also be provided with the function of modifying the specified operation for different fusion methods.

[0078] It should be noted that the fusion method can be determined by establishing a mapping table corresponding to the graphic association relationship in the background. The fusion method is determined based on the graphic association relationship mapping table established in the background. For example, the table can record the control labels of the two associated display controls. For the record of the association relationship between the two display controls, the graphic association relationship between the two display controls can be directly recorded, or the user operation method and operation direction can be recorded. Alternatively, in other embodiments, the background may not save the graphic association relationship mapping table. When determining the fusion method, the graphic association relationship displayed on the front end can be graphically detected. After determining the graphic association relationship between the two display controls based on the detection results, the corresponding fusion method is determined.

[0079] In some embodiments of the present application, the first database and the second database may be heterogeneous databases, that is, the first database and the second database may be databases with different data structures. In some embodiments, the first database and the second database may include non-relational databases and relational databases. Through the embodiments of the present application, the required data can be obtained from different databases for fusion, and the query and fusion of data in different databases can be realized. The first database and the second database may also be databases of different data sources. For example, they may include local or external data sources. In some embodiments, the local data source can be directly connected to the data acquisition system to directly synchronize the data updated in real time by the data acquisition system, and when obtaining the data from the local data source, it can be directly queried locally. As for the data from the external data source, the data within the corresponding data range can be downloaded after the data range is determined, without the need for a full download, which saves local storage space and retains the semantics and data structure in the original database. Without destroying the association and mapping relationships between the data structure objects in the original database, the data from the external data source can be queried and can be fused with the data from the local data source, thereby improving the flexibility of data query.

[0080] The following is an implementation method of the data processing method provided in the embodiment of the present application in an application scenario, specifically for integrating IT data and OT data of equipment in industrial enterprises. Figure 2 ~Attached Figure 7 The interface diagram of FIG. 1 is used to exemplarily illustrate the specific implementation of the above data processing method.

[0081] like Figure 2 As shown, under the "Asset Model" tab 201, the identifiers of different equipment asset models in the industrial enterprise are listed, including a third equipment name identifier 211. The user can quickly search by entering the desired equipment identifier in the search box 212. Here, the "asset model" can be a pre-established data model for each asset device. The data stored in different data sources / repositories for each asset device can be mapped to the same asset model identifier, and the data from different data sources / repositories can be displayed on different tabs corresponding to the identifier.

[0082] For example, when a user clicks on the identifier of any asset model, such as the third device name identifier 211, two tabs will pop up on the right: the "Information Attributes" tab 202 and the "Technical Attributes" tab 203. Here, the "Information Attributes" tab 202 is mapped to the IT data stored by the third device in an external data source, and the "Technical Attributes" tab 203 is mapped to the OT data stored locally by the third device. Here, the locally stored OT data may be collected by edge acquisition devices in various industrial workshops, and the OT data may be processed and stored by the edge data system. It can be understood that the data model in any of the above tabs can display the association relationship between the data structure objects in the corresponding database through options and sub-options, and each option and sub-option corresponds to the data structure object in the corresponding database.

[0083] For example, the user can select multiple fields by clicking the "Device Name" field option 221, the "Test Data" field option 222, and the "Dictionary" field option 223 in the "Information Properties" tab 202, and by holding the mouse and dragging, an interactive interface design in which icon copies of the selected fields are dragged into the target display area is displayed. When the user releases the mouse, a display control is created in the target display area to represent the data range specified by the user: the fields of the device name, test data, and dictionary in the external IT data source of the third device.

[0084] In the background, you can create a data table (mapped data set) that corresponds to the front-end display control. The background data table corresponds to the front-end display control. Figure 3 , including a schematic diagram of an example display control. Display control 301 includes the device model name 3011 and the field names selected by the user: "Device Name," "Test Data," and "Dictionary." In addition, the icon identifier (such as identifier 3012) and data type (such as Boolean, floating point, enumeration, time, integer, character) of each field can also be displayed.

[0085] In some embodiments, the fields selected by the user correspond to select statements in SQL statements. After the fields are filtered, a display control similar to a database table is created in the target display area, displaying the user-filtered fields. For data from external data sources such as IT data, a mapping data table corresponding to the user-specified data in the external data source can be created in real time. Figure 4 This is a flowchart for selecting specific attribute fields in technical attributes, such as Figure 4 As shown, after dragging the label of the technical attribute, the tab page of the technical attribute, that is, the selection window of the technical attribute, can be rendered. In the background, it is detected whether there is a data table (mapped data set). If the table exists, the table information is read, and the field selection window is rendered to select specific fields. If the table does not exist, the table is created and the field selection window is rendered to select specific fields. The selected fields are added to the created data table. In an example, a data table can be created and the table information can be read based on ClickHouse technology.

[0086] Display controls can have different interactive displays and different processing methods based on different operations of the user's mouse on the control. For example, display control 301 is displayed when the mouse is not within the display range of the display control; display control 302 is displayed when the mouse is hovering within the display range of the display control; display control 303 is displayed when the mouse clicks on the display control; display control 304 is displayed when the mouse selects the connection point 3041 of the edge, and the mark of the mouse position becomes a cross; the user clicks the connection point 3051 of display control 305 with the mouse, holds it down, and moves it to display control 306, and a connection line from connection point 3051 to the current mouse position is displayed; the user clicks the connection point 3071 of display control 307 with the mouse, holds it down, and drags it to the connection point 3081 of display control 308, then releases the mouse to establish the association relationship between display control 307 and display control 308.

[0087] An example diagram after establishing graphic association relationship is shown below: Figure 5 As shown. A connecting line is displayed between the two display controls. The connecting line corresponds to the background SQL statement, specifically the table connection (join & uinon) relationship in the SQL statement. The connecting line can also express more complex multi-level subqueries, left joins (left-join), right joins (right-join), etc. For example, Figure 5 The mark 501 on the middle connection line is used to indicate that the current connection is a left connection.

[0088] Optionally, after the mouse is moved to the connection point 3081 of the display control 308 and the mouse is released, a pop-up window may be displayed. Figure 6In the pop-up window shown, you can select specific information to establish a connection relationship, such as the association type, the association relationship between the fields of the two display controls, etc.

[0089] In some embodiments, a target field that does not exist in the original table can be added, and the target field can be obtained after processing and converting the original data. Figure 7 The following is a pop-up interface diagram for adding a calculated field. In addition to adding new calculated fields, you can also modify existing calculated fields. Editing a calculated field (including adding, modifying, and deleting) involves selecting operators, functions, and the fields to use. Operators include arithmetic operators, logical operators, and bitwise operators, while functions include aggregation functions, comparison functions, hash functions, and string functions.

[0090] In some embodiments, the types of fields existing in the original table can also be converted, corresponding to keywords such as SQL statement alias (as alias), modifying field names and field types, supporting function conversion, etc.

[0091] After the association relationship is established, the graphical association relationship can be converted into SQL statements that can be recognized by the system background through the built-in dynamic script language (DSL) parser for data association without the user's perception.

[0092] After data association, fused data is generated, producing a wide table where each row's primary key can be an ID and each column is a user-selected field. The resulting table can be displayed on the front end using a visual chart with a unique view ID. Alternatively, the table can be made available to third parties through an application programming interface (API).

[0093] This implementation method can perform data fusion based on the device, and can use the OT data of the device model as the entry point for fusion, and then avoid the loss of semantics in the original database caused by the use of ETL tools or database synchronization methods by real-time external linking of IT system data. OT devices can be pre-modeled, and through the device model, the real-time OT data of the device corresponding to the technical attributes can be used as the system's built-in data source. Automation integrators or industrial enterprises do not need to synchronize the OT database to the system through external links or database synchronization to obtain OT data for each time window. The data of the external IT system is embedded in the system in the form of an external data source, without the need for pre-processing by ETL tools or waiting for database synchronization tasks. Automation integrators or industrial enterprises can directly see all pre-defined internal tables on the data source dashboard. After dragging and dropping the external data source, an external link table will be created in real time, mapping it to the external data source one by one for subsequent association operations. In this way, through visual interactive operations such as dragging and dropping, corresponding SQL statements can be defined for a variety of interactive operations without the need to write complex SQL.

[0094] The present application also provides a data processing system. Figure 8 The data processing system shown includes: multiple databases 801 and a data processing device 802. The data processing device 802 is used to create a first display control for representing a first data range in response to a first user input and based on a first data range specified by the first user input; the first data range includes at least part of the data in the first database; in response to a second user input, create a second display control for representing a second data range in response to a second user input and based on a second data range specified by the second user input; the second data range includes at least part of the data in the second database; in response to a third user input, display fused data of the first data range and the second data range; the third user input includes associated interactive operations on the first display control and the second display control; the multiple databases include the first database and the second database.

[0095] Optionally, the multiple databases mentioned above may include internal data sources and / or external data sources.

[0096] In some embodiments, the multiple databases may include an industrial operational technology (OT) database and an industrial information technology (IT) database. Furthermore, the data processing system may include an operational technology (OT) data edge device. The operational technology data edge device is used to collect raw operational technology (OT) monitoring data from industrial equipment, convert the raw operational technology monitoring data according to a preset data model of the industrial operational technology database, and store it in the industrial operational technology database.

[0097] In a specific application scenario, IT data can include different tiered electricity price information tables from the Enterprise Resource Planning (ERP) system, and associate the different tiered electricity price information tables with the power consumption fields of the equipment in the OT data. The electricity bill and other information can be calculated by adding new calculation fields. This can facilitate automation integrators or industrial enterprises to use electricity bill information to plan equipment and personnel schedules, and can be combined with the SCADA system to control the start and stop time of industrial equipment, thereby helping industrial enterprises optimize the production schedules of equipment and workers and reduce overall power consumption expenses.

[0098] In this way, users such as automation integrators or industrial enterprises who have data fusion needs can, based on the data processing method provided in the embodiments of this application, use interactive operations such as dragging and dropping on the front-end interface without programming based on SQL / Python technology for traditional data analysis. They can fuse data in massive multi-source heterogeneous data, and bring together data distributed in various systems, databases, and tables in industrial enterprises to the same place without losing the field semantics, association relationships, mapping relationships, etc. in the original database. Users can combine IT data with the temporal relationship of OT data, and combine OT data with the rich dimensions of IT data, and perform fusion analysis on IT data and OT data, so that data can be analyzed in combination with different dimensions, thereby better achieving comprehensive predictions and decisions, which can help enterprises improve efficiency and reduce costs. Furthermore, in some optional implementations of the embodiments of this application, data association can also be performed to establish various data associations, thereby achieving data fusion analysis.

[0099] The OT data edge device is an edge-fusion data acquisition all-in-one machine. Based on industrial equipment modeling, it aggregates and calculates massive amounts of original equipment OT data and stores them in a data warehouse. Combined with the data processing equipment described in the embodiments of this application, data from external IT systems can be collected into the data processing system and associated with data with rich dimensions of industrial equipment. Compared with traditional SCADA data acquisition systems that can only transmit time series data of industrial equipment to the outside, the time series data transmitted by the data processing system provided by the embodiments of this application carries rich IT information. Data users can perform attribution analysis on abnormal fluctuations of equipment based on fused data. Compared with single trend prediction, the information of the IT system can be converted into fluctuation factors by adding new fields, etc., and fed back to equipment engineers for better equipment debugging and optimization.

[0100] In some embodiments, the data processing system provided by the embodiments of the present application provides an industrial data application platform. In the scenario of group management and control, the industrial data application platform connects to the edge fusion all-in-one machine, allowing group managers to link the OT operating status data of multiple workshops and production lines to the IT system for energy consumption management, process optimization, etc. For example, the OT data of workshops in different regions can be linked to the group's Energy Management System (EMS). From the perspective of energy consumption, the power consumption levels of different workshops in different time periods and regional differences can be seen. Through business intelligence (BI) analysis, better scheduling optimization can be carried out to reduce energy consumption costs for the enterprise.

[0101] Corresponding to the aforementioned embodiments of the data processing method, the present application also provides embodiments of a data processing device. Figure 9 FIG. 1 is a structural diagram of a data processing device according to an exemplary embodiment, wherein the device is used to execute the data processing method provided in any of the above embodiments, such as Figure 9 As shown, the data processing device includes:

[0102] A first execution module 901 is configured to, in response to a first user input, create a first display control for representing a first data range according to a first data range specified by the first user input; the first data range includes at least part of the data in the first database;

[0103] A second execution module 902 is configured to create, in response to a second user input, a second display control for representing a second data range according to a second data range specified by the second user input; the second data range includes at least part of the data in the second database;

[0104] The display module 903 is configured to display the fused data of the first data range and the second data range in response to a third user input; the third user input includes an associated interactive operation on the first display control and the second display control.

[0105] The data processing device provided in the embodiment of the present application determines the data range included in the first data range based on the data range specified by the first user input in the first database, creates a first display control for representing the first data range, determines the data range included in the second data range based on the data range specified by the second user input in the second database, and creates a second display control for representing the second data range. Then, the user can fuse the data of the first data range and the second data range by associating and interacting with the first display control and the second display control, obtain and display the fused data. This method of jointly querying different databases uses explicit controls rather than database names, field names, etc. to represent the data range that the user wants to query, so that the fused data desired by the user can be obtained by associating and interacting with the two display controls. The query and fusion operations are more intuitive and simpler, reducing the technical threshold for querying data. In addition, in the prior art, if a user needs data from different databases, the user needs to be familiar with the field semantics, query operations, etc. in different databases and view the data in different databases separately. However, the embodiment of the present application can fuse the data from different databases, making it convenient for the user to view the data from different databases at the same time, thereby making it more convenient for the user to analyze and compare related data.

[0106] The data processing device provided in the embodiment of the present application and the data processing method provided in the embodiment of the present application are based on the same inventive concept and have the same beneficial effects as the methods adopted, operated or implemented by them.

[0107] The implementation process of the functions and effects of each module in the above-mentioned device is specifically described in the implementation process of the corresponding steps in the above-mentioned method, and will not be repeated here.

[0108] For the device embodiments, since they basically correspond to the method embodiments, the relevant parts can be referred to the partial description of the method embodiments. The device embodiments described above are merely illustrative, wherein the modules described as separate components may or may not be physically separated, and the components illustrated as modules may or may not be physical modules, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the present application scheme. A person of ordinary skill in the art can understand and implement it without paying any creative work.

[0109] Some embodiments of the present application also provide an electronic device corresponding to the data processing method provided in the aforementioned embodiment to execute the aforementioned data processing method.

[0110] Figure 10This is a hardware structure diagram of an electronic device according to an exemplary embodiment. The electronic device includes a communication interface 601, a processor 602, a memory 603, and a bus 604. The communication interface 601, the processor 602, and the memory 603 communicate with each other via the bus 604. The processor 602 executes the data processing method described above by reading and executing machine-executable instructions corresponding to the control logic of the data processing method in the memory 603. The details of the method are described in the above embodiments and are not repeated here.

[0111] The memory 603 mentioned in the embodiments of the present application can be any electronic, magnetic, optical or other physical storage device, and can contain stored information, such as executable instructions, data, etc. Specifically, the memory 603 can be RAM (Random Access Memory), flash memory, a storage drive (such as a hard disk drive), any type of storage disk (such as an optical disk, DVD, etc.), or a similar storage medium, or a combination thereof. The communication connection between the system network element and at least one other network element is realized through at least one communication interface 601 (which can be wired or wireless), and the Internet, wide area network, local area network, metropolitan area network, etc. can be used.

[0112] The bus 604 may be an ISA bus, a PCI bus, or an EISA bus, etc. The bus may be divided into an address bus, a data bus, a control bus, etc. The memory 603 is used to store programs, and the processor 602 executes the programs after receiving an execution instruction.

[0113] The processor 602 may be an integrated circuit chip with signal processing capabilities. In the implementation process, each step of the above method can be completed by the integrated logic circuit of the hardware in the processor 602 or the instruction in the form of software. The above-mentioned processor 602 can be a general-purpose processor, including a network processor (NP), a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware controls, etc. The various methods, steps and logic block diagrams disclosed in the embodiments of the present application can be implemented or executed. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor, etc. The steps of the method disclosed in conjunction with the embodiments of the present application can be directly embodied as a hardware decoding processor for execution, or can be completed by a combination of hardware and software modules in the decoding processor.

[0114] The electronic device provided in the embodiment of the present application and the data processing method provided in the embodiment of the present application are based on the same inventive concept and have the same beneficial effects as the methods adopted, operated or implemented by them.

[0115] An embodiment of the present application also provides a computer-readable storage medium corresponding to the data processing method provided in the aforementioned embodiment, which stores a computer program (i.e., a program product). When the computer program is run by a processor, it will execute the data processing method provided in any of the aforementioned embodiments.

[0116] It should be noted that examples of the computer-readable storage medium may also include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other optical or magnetic storage media, which are not listed here one by one.

[0117] The computer-readable storage medium provided in the above-mentioned embodiments of the present application and the data processing method provided in the embodiments of the present application are based on the same inventive concept and have the same beneficial effects as the methods adopted, run or implemented by the application programs stored therein.

[0118] An embodiment of the present application further provides a computer program product corresponding to the data processing method provided in the aforementioned embodiment. The computer program product includes a computer program, which is executed by a processor to implement the data processing method provided in the aforementioned embodiment.

[0119] The computer program product provided by the above-mentioned embodiments of the present application and the data processing method provided by the embodiments of the present application are based on the same inventive concept and have the same beneficial effects as the methods adopted, run or implemented by the application programs stored therein.

[0120] Those skilled in the art will readily appreciate other embodiments of the present application after considering the specification and practicing the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the present application that follow the general principles of the present application and include common knowledge or customary techniques in the art not disclosed herein. The description and examples are to be considered merely as exemplary, and the true scope and spirit of the present application are indicated by the claims.

[0121] It should also be noted that the terms "comprises," "includes," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, commodity, or apparatus that includes a series of elements includes not only those elements but also other elements not explicitly listed, or includes elements inherent to such process, method, commodity, or apparatus. In the absence of further limitations, an element defined by the phrase "comprises a ..." does not exclude the presence of other identical elements in the process, method, commodity, or apparatus that includes the element.

[0122] The above description is only a preferred embodiment of the present application and is not intended to limit the present application. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present application shall be included in the scope of protection of the present application.

Claims

1. A data processing method, characterized in that: The method comprises: In response to a first user input, creating a first display control for representing a first data range according to a first data range specified by the first user input; the first data range includes at least part of the data in the first database; In response to a second user input, creating a second display control for representing a second data range according to a second data range specified by the second user input; the second data range includes at least part of the data in the second database; In response to a third user input, fused data of the first data range and the second data range is displayed; the third user input includes an associating interaction operation for associating the first display control and the second display control.

2. The method according to claim 1, characterized in that Before creating, in response to a first user input and according to a first data range specified by the first user input, a first display control for representing the first data range, the method further includes: Displaying a mapping model of the first database; the mapping model of the first database is used to map the data structure of the first database; the data structure of the first database includes a plurality of data structure objects; the mapping model of the first database includes a plurality of mapping objects that are mapped one-to-one with the plurality of data structure objects; A first user input is received to select a target mapping object from a plurality of mapping objects in the first database; the first data range is determined according to the target mapping object.

3. The method according to claim 2, characterized in that The step of creating, in response to a first user input and according to a first data range specified by the first user input, a first display control for representing the first data range includes: In response to the first user input, a first mapping data set is created, and the target mapping object is added to the first mapping data set; the first mapping data set is used to map the first data range; The first display control associated with the first mapping dataset is created according to the first mapping dataset.

4. The method according to claim 1, wherein The first data range includes data of at least one field; the second data range includes data of at least one field; The fused data is displayed in a table control; the method further comprises: In response to a fourth user input, modifying field information of some fields in the table control; the table control includes some fields of the first data range and some fields of the second data range; the field information includes at least one of the following: a name of the corresponding field, a type of the corresponding field, and a function of the corresponding field; and / or, In response to a fifth user input, a target field is added to the table control, where the target field is obtained by performing a function operation on a portion of the fields in the first data range and / or a portion of the fields in the second data range.

5. The method according to claim 1, wherein Before creating, in response to a second user input and according to a second data range specified by the second user input, a second display control for representing the second data range, the method further includes: Displaying a target database identification set; the target database identification set includes identifications of multiple databases, and the multiple databases include the second database; The second user input for selecting the second database identifier among the plurality of database identifiers is received.

6. The method according to any one of claims 1 to 5, characterized in that The displaying of the fused data of the first data range and the second data range includes: Obtaining data in a first data range found in the first database; Acquire data in a second data range found in the second database; fusing the data in the first data range and the data in the second data range to obtain the fused data; The fused data is displayed.

7. The method according to claim 6, characterized in that Before obtaining the data in the first data range queried from the first database, the method further includes: In response to the third user input, querying the first database for data in the first data range; Before acquiring the data in the second data range queried from the second database, the method further includes: In response to the third user input, a query is made to the second database for data in the second data range.

8. The method according to claim 6, characterized in that The fusing the data in the first data range and the data in the second data range to obtain the fused data includes: determining, according to the associated interactive operation input by the third user, a fusion method of the first data range and the second data range; Based on the fusion mode, the data in the first data range and the data in the second data range are fused to obtain the fused data.

9. The method according to claim 8, characterized in that The fusing the data in the first data range and the data in the second data range to obtain the fused data includes: determining a table connection direction between the first data range and the second data range according to an association direction indicated by the association interaction operation input by the third user; A table connection is established between the first data range and the second data range according to the table connection direction to obtain the fused data.

10. The method according to claim 8, characterized in that The determining, according to the associated interactive operation input by the third user, a fusion method of the first data range and the second data range includes: Establishing and displaying a graphic association relationship between the first display control and the second display control according to the association interaction operation input by the third user; The fusion mode is determined according to the graphic association relationship.

11. The method according to claim 1, wherein The first database and the second database are heterogeneous databases; and / or the first database and the second database are databases from different data sources.

12. A data processing system, characterized in that: The data processing system comprises: Multiple databases; A data processing device for creating, in response to a first user input, a first display control for representing a first data range specified by the first user input; the first data range includes at least part of the data in a first database; in response to a second user input, creating a second display control for representing a second data range specified by the second user input; the second data range includes at least part of the data in a second database; in response to a third user input, displaying fused data of the first data range and the second data range; the third user input includes an associative interaction operation for associating the first display control and the second display control; the multiple databases include the first database and the second database.

13. The data processing system according to claim 12, wherein: The plurality of databases include an industrial operation technology database and an industrial information technology database.

14. The data processing system according to claim 13, wherein: The data processing system further includes: The operation technology data edge device is used to collect original operation technology monitoring data of industrial equipment, convert the original operation technology monitoring data according to the preset data model of the industrial operation technology database, and store it in the industrial operation technology database.

15. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: The processor executes the program to implement the method according to any one of claims 1 to 11.

16. A computer-readable storage medium having a computer program stored thereon, characterized in that: The program is executed by a processor to implement the method according to any one of claims 1 to 11.

17. A computer program product comprising a computer program, characterized in that The computer program is executed by a processor to implement the method according to any one of claims 1 to 11.

Images