Data operation monitoring method, electronic equipment and medium

Abstract

The invention provides a data operation monitoring method, electronic equipment and a medium, and relates to the field of computer processing. And in combination with unique requirements of the target service system, completing selection of a corresponding target database instance and SQL query statement configuration of to-be-monitored data through a monitoring tool configuration page for the target service system, running the SQL query statement according to pre-associated database information of the target database instance, and outputting a running result. A user can know the operation condition of the to-be-monitored data in the target service system by checking the operation result, and accurate monitoring of the target service system is achieved.

Description

Technical Field

[0001] The present application relates to the field of computer processing, and in particular to a data operation monitoring method, electronic equipment, and medium. Background Art

[0002] As digital transformation continues to deepen, the stable operation of business systems plays a decisive role in the operations of enterprises and organizations. The operational status of business systems is highly dependent on effective data support. As the scale of enterprise business continues to expand, the amount of data is growing exponentially, and the operational processes of data collection, transmission, storage, and processing are becoming increasingly complex.

[0003] Data performance directly reflects the operational status of business systems. Any data transmission delay, loss, or error can impact the normal operation of business systems, potentially causing irreversible disruptions and significant losses to the business. For example, during e-commerce promotions, delayed order data transmission can lead to inventory management disruptions, impacting product sales. Inaccurate customer information can lead to customer service failures and a negative customer experience. Furthermore, data timeliness and accuracy are key factors in ensuring the efficient operation of business systems. In financial transaction systems, where real-time performance is crucial, delayed or inaccurate transaction data can result in significant financial losses.

[0004] However, current monitoring technologies primarily focus on database availability and performance, with a focus on common metrics such as database locks, wait events, and CPU usage. However, there are significant deficiencies in monitoring the operation of the data itself. Summary of the Invention

[0005] In view of this, the present application provides a data operation monitoring method, electronic device and medium to implement targeted and exclusive data operation monitoring for a specific business system.

[0006] In a first aspect, the present application provides a data operation monitoring method, comprising:

[0007] Outputting a monitoring tool configuration page for the target business system, the monitoring tool configuration page including a tool information editing area and a script configuration area, the tool information editing area including a database instance selection area;

[0008] When a trigger operation for the database instance selection area is detected, a database instance selection list is displayed; wherein the database selection list includes database instances pre-associated with the target business system;

[0009] Determine a target database instance from the database instance selection list and obtain pre-associated database information of the target database instance; the pre-associated database information includes one or more of the following information about the corresponding database: database IP address, instance information, port number, database type, and account information; the target database instance includes one or more;

[0010] Obtaining the SQL query statement for the data to be monitored entered in the script configuration area;

[0011] When a run trigger operation is detected, the SQL query statement is run according to the pre-associated database information, and the run result is output.

[0012] In one embodiment, after obtaining the SQL query statement for the data to be monitored input in the script configuration area, the method further includes:

[0013] When a parsing operation is detected, the query conditions and query fields are parsed from the SQL query statement and displayed.

[0014] In one embodiment, the method further comprises:

[0015] The SQL query statement is updated according to the adjustment operation on the query condition and / or the query field.

[0016] In one embodiment, the method further comprises:

[0017] Acquire the tool information entered in the tool information editing area;

[0018] A new data monitoring tool for the target business system is generated according to the tool information, the SQL query statement and the pre-associated database information.

[0019] In one embodiment, the method further comprises:

[0020] Output a monitoring system configuration page, the monitoring system configuration page including a basic information configuration area and a process configuration area; the basic information configuration area is used to obtain basic information of the monitoring process, the basic information including any one or more of the following: process name, process type, and execution mode;

[0021] Determine the system monitoring plan by selecting and arranging data query nodes and other nodes corresponding to the target data monitoring tool through the process configuration area; the other nodes include any one or more of the following: comparison nodes, selection nodes, merge nodes, parallel nodes, notification nodes and end nodes;

[0022] Run the system monitoring solution and display the execution result of each node in the system monitoring solution.

[0023] In one embodiment, selecting a data query node corresponding to a target data monitoring tool through the process configuration area includes:

[0024] Adding a data query node through the process configuration area;

[0025] A node information configuration area is displayed for the data query node; the node information configuration area includes a selection entry for a data monitoring tool;

[0026] The selection entry triggers the display of a monitoring tool selection page, wherein the monitoring tool selection page includes: identifiers of one or more data monitoring tools and the business systems to which they belong;

[0027] When a selection operation for a target data monitoring tool is detected, the data query node is bound to the target data monitoring tool.

[0028] In one embodiment, running the system monitoring solution includes:

[0029] Obtaining node configuration information of the other nodes;

[0030] Acquire monitoring configuration information of the target data monitoring tool; the monitoring configuration information includes the tool information, the SQL query statement and the pre-associated database information.

[0031] The system monitoring solution is run according to the node configuration information of the other nodes and the monitoring configuration information of the target data monitoring tool.

[0032] In one embodiment, before outputting the monitoring tool configuration page for the target business system, the method further includes:

[0033] Outputting a database maintenance page, the database maintenance page including a business system selection area, a database configuration area, and an account information configuration area; the business system selection area is used to select the target business system from multiple business systems;

[0034] The database configuration area is used to determine the data source information to be monitored under the target business system, and the data source information to be monitored includes one or more of the following information of the database to be monitored: database IP, instance information, port, database type, business type, instance type, database URL and database alias;

[0035] The account information configuration area is used to determine the account information for accessing the database to be monitored;

[0036] The target business system, the information of the data source to be monitored and the account information of the database to be monitored are associated and stored.

[0037] In a second aspect, the present application provides an electronic device, comprising:

[0038] at least one processor; and

[0039] At least one memory having instructions stored thereon, which, when executed individually or collectively by the at least one processor, cause the electronic device to execute the method according to the first aspect.

[0040] In a third aspect, the present application provides a computer storage medium having instructions stored thereon. When the instructions are executed individually or collectively by at least one processor of an electronic device, the electronic device executes the method described in the first aspect.

[0041] The data operation monitoring method provided in this application takes into account the unique needs of the target business system. Through the monitoring tool configuration page for the target business system, the corresponding target database instance is selected and SQL query statements for the data to be monitored are configured. The SQL query statements are then run based on the pre-associated database information of the target database instance, and the results are output. Users can view the results to understand the operational status of the monitored data in the target business system, achieving accurate monitoring of the target business system's operation. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] The accompanying drawings are included to provide a further understanding of the present application. They are incorporated into and constitute a part of this application. The accompanying drawings illustrate embodiments of the present application and, together with this specification, serve to explain the principles of the present application. In the accompanying drawings:

[0043] Figure 1 This is a flow chart of a data operation monitoring method provided in an embodiment of the present application;

[0044] Figure 2 This is a schematic diagram of a database maintenance page provided in an embodiment of the present application;

[0045] Figure 3 This is a schematic diagram of a data operation monitoring page provided in an embodiment of the present application;

[0046] Figure 4 This is a schematic diagram of a monitoring tool configuration page provided in an embodiment of the present application;

[0047] Figure 5 is a schematic diagram of another monitoring tool configuration page provided in an embodiment of the present application;

[0048] Figure 6 This is a flow chart of another data operation monitoring method provided in an embodiment of the present application;

[0049] Figure 7This is a schematic diagram of a monitoring system configuration page provided in an embodiment of the present application;

[0050] Figure 8 This is a schematic diagram of another monitoring system configuration page provided in an embodiment of the present application;

[0051] Figure 9 This is a schematic diagram of a monitoring tool selection page provided in an embodiment of the present application;

[0052] Figure 10 This is a schematic diagram of another monitoring system configuration page provided in an embodiment of the present application;

[0053] Figure 11 This is a schematic diagram of another monitoring system configuration page provided in an embodiment of the present application;

[0054] Figure 12 This is a schematic diagram of another monitoring system configuration page provided in an embodiment of the present application;

[0055] Figure 13 This is a schematic diagram of the execution results of a system monitoring solution provided in an embodiment of the present application;

[0056] Figure 14 This is a structural diagram of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0057] To more clearly illustrate the technical solutions of the embodiments of this application, the following is a brief introduction to the drawings required for describing the embodiments. Obviously, the drawings described below are merely examples or embodiments of this application. Those skilled in the art can apply this application to other similar scenarios based on these drawings without inventive effort. Unless otherwise apparent from the context or otherwise noted, the same reference numerals in the figures represent the same structure or operation.

[0058] As used herein, unless the context clearly indicates otherwise, the terms "a," "an," "an," and / or "the" are not intended to refer to the singular but may include the plural. Generally speaking, the terms "include" and "comprise" only indicate the inclusion of the steps and elements specifically identified, and these steps and elements do not constitute an exclusive list. A method or apparatus may also include other steps or elements.

[0059] At the same time, this application uses specific terms to describe the embodiments of this application. For example, "one embodiment," "an embodiment," and / or "some embodiments" refer to a certain feature, structure, or characteristic related to at least one embodiment of this application. Therefore, it should be emphasized and noted that "one embodiment," "an embodiment," or "an alternative embodiment" mentioned twice or multiple times in different locations in this specification does not necessarily refer to the same embodiment. In addition, certain features, structures, or characteristics in one or more embodiments of this application may be appropriately combined.

[0060] Unless otherwise specified, the relative arrangement of the parts and steps, numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present application. Meanwhile, it should be understood that, for ease of description, the sizes of the various parts shown in the accompanying drawings are not drawn according to actual proportional relationships. Technology, methods and equipment known to those of ordinary skill in the relevant art may not be discussed in detail, but in appropriate cases, the technology, methods and equipment should be considered as a part of the specification. In all examples shown and discussed here, any specific value should be interpreted as being merely exemplary, rather than as a limitation. Therefore, other examples of exemplary embodiments may have different values. It should be noted that similar numbers and letters represent similar items in the following drawings, and therefore, once an item is defined in an accompanying drawing, it does not need to be further discussed in subsequent drawings.

[0061] In addition, although the terms used in this application are selected from commonly known and commonly used terms, some of the terms mentioned in this specification may be selected by the applicant at his or her discretion, and their detailed meanings are explained in the relevant parts of the description herein. In addition, it is required that this application be understood not only by the actual terms used, but also by the meaning implied by each term.

[0062] Flowcharts are used in this application to illustrate the operations performed by devices or apparatuses according to embodiments of the present application. It should be understood that the preceding or following operations are not necessarily performed in exact order. Instead, the various steps may be processed in reverse order or simultaneously. Furthermore, other operations may be added to these processes, or one or more operations may be removed from these processes.

[0063] See also Figure 1 , this application proposes a data operation monitoring method, which is applied to a data monitoring management platform and includes the following steps:

[0064] S100: Outputting a monitoring tool configuration page for a target business system. The monitoring tool configuration page includes a tool information editing area and a script configuration area. The tool information editing area includes a database instance selection area.

[0065] S101: When a trigger operation for a database instance selection area is detected, a database instance selection list is displayed.

[0066] The database selection list includes one or more database instances that are pre-associated with the target business system.

[0067] S102: Determine a target database instance from the database instance selection list, and obtain pre-associated database information of the target database instance.

[0068] The target database instance may include one or more. The case where the target database instance includes multiple instances is mainly used in scenarios where multiple data sources in a distributed business system monitor similar indicators.

[0069] The pre-associated database information includes one or more of the following information about the corresponding database: database IP, instance information, port, database type, and account information.

[0070] In one embodiment, before executing step S100, the user can configure the data sources to be monitored for different business systems. Specifically, the user can configure the relevant information of the database to be monitored, including: database IP, instance information (such as instance name, instance type, etc.), port, database type, business type, database URL (Uniform Resource Locator), database alias, account information, and the business system to which the database belongs. After the configuration is completed, the business system and this configuration information can be associated and stored in a preset storage area to form a binding relationship. The preset storage area can be any area that can store data, such as local storage space, cloud storage space, or block node in the blockchain, and is not specifically limited to this.

[0071] The embodiments of this application support multiple database types, such as eight trusted databases including OCEANBASE-ORACLE, OCEANBASE-MYSQL, TDSQL-PG, TDSQL-MYSQL, DAMO, HOLOGRESS, ADB, and Gauss DB, as well as four mainstream databases including ORACLE, MYSQL, MONGDB, and PG.

[0072] The above-mentioned account information may include any one or more of the following: the account number, password, and password acquisition method for accessing the database to be monitored. When the password acquisition method is manual entry, the account information directly includes the account number and password for accessing the database to be monitored; when the password acquisition method is obtained from a third-party platform (the third-party platform is a platform that uniformly manages various account passwords), the account information includes the account number for accessing the database to be monitored, and the password acquisition method. When you need to access the database to be monitored later, you can directly obtain the latest variable password from the third-party platform in real time based on the account number to ensure that the account number is accurate each time a data query is initiated.

[0073] In an embodiment of the present application, the method for configuring the relevant information of the above-mentioned database to be monitored is that the user configures it locally and then imports the relevant information (such as the information shown in Table 1) into the data monitoring management platform, or the user completes the configuration through the visualization page provided by the data monitoring association platform.

[0074] Table 1

[0075]

[0076] The following describes how users complete configuration through the visualization page provided by the data monitoring association platform:

[0077] In one embodiment, before executing step S100, the following steps may be further executed:

[0078] Step 1: Output the database maintenance page, which includes the business system selection area, database configuration area, and account information configuration area.

[0079] The business system selection area is used to select a target business system from multiple business systems.

[0080] The database configuration area is used to determine the data source information to be monitored under the target business system. The data source information to be monitored includes one or more of the following information of the database to be monitored: database IP, instance information, port, database type, business type, instance type, database URL and database alias.

[0081] The above account information configuration area is used to determine the account information for accessing the database to be monitored.

[0082] Step 2: Associate and store the target business system, the data source information to be monitored, and the account information of the database to be monitored.

[0083] For example, the database maintenance page is as follows: Figure 2As shown, it includes a business system selection area 200, a database configuration area 201, and an account information configuration area 202. The user selects business system 1 as the target business system in the business system selection area 200, configures the data source information to be monitored for business system 1 in the database configuration area 201, and configures the account information of database life (i.e., the database to be monitored) in the account information configuration area 202. The user clicks Figure 2 Click the "Save" button to complete the configuration. The data monitoring management platform can associate the virtual IP address, instance name, port, instance role, database type, instance type, database alias, and account information corresponding to business system 1 and database life in the preset storage area, forming a binding relationship.

[0084] S103: Obtaining the SQL query statement of the data to be monitored input in the script configuration area.

[0085] In one embodiment, the above-mentioned data to be monitored are associated with the business characteristics of the target business system. According to the unique needs and characteristics of different business systems, SQL query statements can be configured for different data to be monitored. For example, for e-commerce business, its transaction data has the characteristics of high concurrency and strong timeliness. The prevention and control technology can focus on monitoring the data operation status of key links such as order creation and payment processing, grasp the business peaks and troughs in real time, and give early warning of possible system freezes or data backlogs, to ensure that the business system runs stably during traffic peaks such as big promotions. Then, if the target business system in step S100 is an e-commerce business system, the data to be monitored can be data related to order creation and payment processing. Accordingly, SQL query statements can be used to query order creation status, payment processing status, and so on.

[0086] For another example, for financial business, given its extremely high requirements for data accuracy and security, if the target business system in step S100 is a financial business system, the data to be monitored may be data related to account fund changes, transaction flows, etc. Accordingly, SQL query statements can be used to query account fund changes, transaction flows, etc., to ensure the accurate recording and timely transmission of each financial transaction data, and maintain the compliance and stability of financial business.

[0087] S104: When a run trigger operation is detected, the SQL query statement is run according to the pre-associated database information, and the run result is output.

[0088] See also Figure 3 and Figure 4 When users need to monitor certain data of a business system, they can trigger the data monitoring management platform to display Figure 3In the data operation monitoring page shown, the user selects business system 1 as the target business system to be monitored in area 300 based on his own needs. Figure 3 When the "Add" button is triggered, the monitoring tool configuration page for business system 1 is displayed (such as Figure 4 As shown in the figure, it includes a script configuration area 401 and a tool information editing area 402. The user enters the SQL query statement of the data to be monitored in the script configuration area 401, selects the target database instance in the database instance selection area 4020 in the tool information editing area 402, and enters the tool name, database type, timing expression, notification method and other tool information in the areas other than the database instance selection area 4020 in the tool information editing area 402. After the configuration is completed, if the data monitoring management platform detects the running trigger operation (such as the user clicks Figure 4 ), the pre-associated database information (database IP, instance information, port, database type and account information, etc.) of the target data instance is obtained from the above-mentioned preset storage area, and the SQL query statement in the script configuration area 401 is run according to the pre-associated database information, and the running result is output.

[0089] In one embodiment, the method proposed in the present application further includes: obtaining tool information input in the tool information editing area, and generating a new data monitoring tool for the target business system based on the tool information, SQL query statements and pre-associated database information.

[0090] For example, see Figure 4 , users pass Figure 4 After completing the configuration of the data monitoring tool "Individual Generation Team Cross-Duplicate Data Verification", the data monitoring management platform can obtain the tool information entered in the tool information editing area 402, and generate a new data monitoring tool for business system 1 based on the tool information, SQL query statement and pre-associated database information. The name of the new data monitoring tool is: Individual Generation Team Cross-Duplicate Data Verification, and the new data monitoring tool is added to the data monitoring tool library for subsequent direct call.

[0091] In one embodiment, during the execution of an SQL query statement, the SQL statement may be verified, including syntax verification and single query quantity verification. After the verification passes, the above-mentioned step of generating a new data monitoring tool for the target business system based on the tool information, the SQL query statement, and the pre-associated database information is executed.

[0092] Specifically, the SQL statement verification process includes: first, performing a syntax check on the SQL query statement. If there are any syntax errors, a syntax error prompt message is output; if there are no syntax errors, the SQL query statement can be checked for the number of single query results. If the number of single query results exceeds a threshold (for example, 200), the execution is stopped prematurely and a risk warning is output. After reviewing the risk warning, the user can reconfigure the SQL query statement and reassemble it into an SQL query statement with a number of query results less than or equal to the threshold.

[0093] In one embodiment, after obtaining the SQL query statement for the data to be monitored entered in the script configuration area, the following steps can also be performed: when a parsing operation is detected, the query conditions and query fields are parsed and displayed from the SQL query statement to facilitate users to quickly understand the specific information that needs to be monitored.

[0094] In one embodiment, after displaying the query conditions and query fields, the following steps may be performed: updating the SQL query statement according to adjustments to the query conditions and / or query fields. Adjustments include adding, deleting, and modifying query conditions and / or query fields, facilitating additional maintenance of query conditions and / or query fields by the user.

[0095] For example, see Figure 5 When the user enters an SQL query statement in the script configuration area of the monitoring tool configuration page and clicks the "Auto Parse" button, the data monitoring management platform will confirm that the parsing operation has been detected and will automatically parse the SQL query statement entered in the script configuration area, parse out the query conditions and return fields, and display them on the monitoring tool configuration page. The user can view the query conditions and return fields to quickly and intuitively verify the SQL query statement. If the verification is correct, click Figure 5 Click the "Save" button (i.e., run the trigger operation), the data monitoring and management platform can execute step S104 to run the SQL query statement and output the operation result. If the verification is incorrect, the user can manually adjust the query conditions / or query fields and enter the adjustment operation. The data monitoring and management platform will update the SQL query statement according to the adjustment operation. Figure 5 When you click the "Save" button (i.e., run the trigger operation), the data monitoring management platform runs the updated SQL query statement and outputs the running results.

[0096] In the embodiments of the present application, the target database instance can be selected and the SQL query statement for the data to be monitored can be configured through the monitoring tool configuration page for the target business system, taking into account the unique needs of the target business system. The SQL query statement is then run based on the pre-associated database information of the target database instance, and the execution results are output. The user can view the execution results to understand the operation status of the data to be monitored in the target business system, thereby achieving accurate monitoring of the operation of the target business system.

[0097] See also Figure 6 ,exist Figure 1 Based on the method shown, this application proposes another data operation monitoring method, which includes the following steps:

[0098] S100: Outputting a monitoring tool configuration page for a target business system. The monitoring tool configuration page includes a tool information editing area and a script configuration area. The tool information editing area includes a database instance selection area.

[0099] S101: When a trigger operation for a database instance selection area is detected, a database instance selection list is displayed.

[0100] S102: Determine a target database instance from the database instance selection list, and obtain pre-associated database information of the target database instance.

[0101] S103: Obtaining the SQL query statement of the data to be monitored input in the script configuration area.

[0102] S104: When a run trigger operation is detected, the SQL query statement is run according to the pre-associated database information, and the run result is output.

[0103] The specific implementation of steps S100 to S104 can be found in Figure 1 The detailed description of the embodiments is omitted here.

[0104] S105: Outputting a monitoring system configuration page, which includes a basic information configuration area and a process configuration area.

[0105] The basic information configuration area is used to obtain basic information of the monitoring process, which includes any one or more of the following: process name, process type and execution mode.

[0106] S106: Select and arrange data query nodes and other nodes corresponding to the target data monitoring tool in the process configuration area to determine the system monitoring plan. Other nodes include any one or more of the following: comparison nodes, selection nodes, merge nodes, parallel nodes, notification nodes, and end nodes; and the target data monitoring tool may include one or more data monitoring tools.

[0107] S107: Run the system monitoring solution and display the execution result of each node in the system monitoring solution.

[0108] In one embodiment, S107 may be implemented by obtaining node configuration information of other nodes and monitoring configuration information of the target data monitoring tool, and running the system monitoring solution according to the node configuration information of other nodes and monitoring configuration information of the target data monitoring tool.

[0109] The monitoring configuration information includes the target data monitoring tool's tool information, the SQL query statement, and pre-associated database information. The node configuration information includes any one or more of the following for other nodes: name, node type, parent node information, child node information, and node execution conditions. The node configuration information for notification nodes may also include the specific notification method, notification content, and notification recipients.

[0110] In one embodiment, the implementation method of selecting a data query node corresponding to a target data monitoring tool through a process configuration area includes:

[0111] Step 1: Add a data query node through the process configuration area and display the node information configuration area of the data query node. The node information configuration area includes the selection entrance of the data monitoring tool.

[0112] Step 2: Trigger the display of the monitoring tool selection page by selecting the entry (displaying the identifiers of one or more data monitoring tools and the business systems to which they belong). When a selection operation for the target data monitoring tool is detected, bind the data query node to the target data monitoring tool.

[0113] For example, assuming that the monitoring system configuration page is as follows Figure 7 As shown, it includes a basic information configuration area 700, a process configuration area 701, and a node information configuration area 702. The process configuration area 701 includes a node selection area 7010, which displays data query nodes, comparison nodes, merge nodes, parallel nodes, notification nodes, and end nodes for users to select. Users can select one or more nodes to add to the process configuration area 701 and arrange each node to determine the system monitoring plan.

[0114] The node information configuration area 702 is used to obtain node configuration information of each node, which includes, for example, name, node type, upper node information, lower node information, and node execution conditions. The node configuration information of the notification node may also include the specific notification method, notification content, notification recipient, etc.

[0115] Continue to see Figures 7 to 10When users want to monitor active investment research and operation and maintenance inspections, they can display the monitoring system configuration page through the data monitoring management platform. The monitoring system configuration page is as follows: Figure 7 As shown. The user enters the process name "Active Investment Research and Operation Inspection", process type "Data Query", and user group "Application Manager Group" in the basic information configuration area 700. Click the "Data Query" button in the node selection area 7010, and the data monitoring management platform will display a data query node in the process configuration area 701. After the user selects the data query node, the monitoring system configuration page will be as follows: Figure 8 The displayed content is as shown. Figure 8 When a trigger operation is detected for the "Tool" area (i.e. the selection entry of the data monitoring tool) in the node information configuration area, it is displayed Figure 9 The monitoring tool selection page shown in the figure shows the monitoring tools selected by Figure 1 The method shown is pre-configured as a data monitoring tool. The user selects the "Trading Day Query" tool of Business System 1 as the first target data monitoring tool based on their own needs. After the selection is completed, click the "OK" button. The data monitoring management platform binds the "Trading Day Query" tool to the previously added data query node and jumps to the display as shown below. Figure 10 The monitoring system configuration page is shown.

[0116] Continue to see Figures 11-13 , users can continue to add multiple selection nodes, active investment research and operation inspection nodes (data query nodes corresponding to the second target data monitoring tool), multiple notification nodes and end nodes, and arrange the processes for these selected nodes. Select any node and enter the node configuration information in the corresponding node information configuration area, for example Figure 11 For the selected node, you can configure node configuration information such as node name, type, subordinate nodes, and execution conditions, thereby completing the configuration of the "Active Investment Research and Operation and Maintenance Inspection" system monitoring solution.

[0117] Furthermore, the data monitoring management platform detects that the system monitoring solution configuration is complete (e.g., the user clicks Figure 12 When you click the "Save" button in the system monitoring program, the system monitoring program will be run and the execution results of each node in the system monitoring program will be displayed. Figure 13 As shown in the figure, the √ after the node indicates a successful operation, and the × after the node indicates a failed operation. Click each node to view the task log when the corresponding node is running, which helps users quickly locate the root cause of the operation failure.

[0118] In an embodiment of the present application, the pre-configured data monitoring tool can be jointly orchestrated in a diversified manner with one or more of the comparison nodes, selection nodes, merge nodes, parallel nodes, notification nodes and end nodes to meet more complex business monitoring needs.

[0119] Figure 14 This is a schematic diagram of the structure of an electronic device provided in an embodiment of the present application. The electronic device can operate Figure 1 and Figure 6 The data operation monitoring method or the data monitoring management platform, such as Figure 14 As shown, the electronic device includes one or more processors 1400 , one or more memories 1401 coupled to the processor 1400 , and one or more communication modules 1402 coupled to the processor 1400 .

[0120] The communication module 1402 is configured for bidirectional communication. The communication module 1402 has at least one antenna to facilitate communication. The communication interface may represent any interface necessary for communicating with other network elements.

[0121] Processor 1400 may be of any type suitable for the local technology network and may include, by way of non-limiting example, one or more of a general purpose computer, a special purpose computer, a microprocessor, a digital signal processor (DSP), and a processor based on a multi-core processor architecture. An electronic device may have multiple processors, such as application specific integrated circuit chips, which are driven in time to a clock that synchronizes the master processor.

[0122] Processor 1400 can be used to perform the following steps: output a monitoring tool configuration page for the target business system, the monitoring tool configuration page includes a tool information editing area and a script configuration area, the tool information editing area includes a database instance selection area; when a trigger operation for the database instance selection area is detected, a database instance selection list is displayed; wherein the database selection list includes database instances pre-associated with the target business system; determine the target database instance from the database instance selection list, and obtain the pre-associated database information of the target data instance; the pre-associated database information includes one or more of the following for the corresponding database: database IP, instance information, port, database type and account information; the target database instance includes one or more; obtain the SQL query statement for the data to be monitored entered in the script configuration area; when a run trigger operation is detected, run the SQL query statement according to the pre-associated database information, and output the run result.

[0123] In one embodiment, after obtaining the SQL query statement for the data to be monitored input in the script configuration area, the processor 1400 is further configured to parse and display query conditions and query fields from the SQL query statement when a parsing operation is detected.

[0124] In one embodiment, the processor 1400 is further configured to update the SQL query statement according to an adjustment operation on the query condition and / or the query field.

[0125] In one embodiment, the processor 1400 is further configured to obtain tool information input in the tool information editing area; and generate a new data monitoring tool for the target business system according to the tool information, the SQL query statement, and the pre-associated database information.

[0126] In one embodiment, the processor 1400 is further configured to:

[0127] Output a monitoring system configuration page, the monitoring system configuration page including a basic information configuration area and a process configuration area; the basic information configuration area is used to obtain basic information of the monitoring process, the basic information including any one or more of the following: process name, process type, and execution mode;

[0128] Determine the system monitoring plan by selecting and arranging data query nodes and other nodes corresponding to the target data monitoring tool through the process configuration area; the other nodes include any one or more of the following: comparison nodes, selection nodes, merge nodes, parallel nodes, notification nodes and end nodes;

[0129] Run the system monitoring solution and display the execution result of each node in the system monitoring solution.

[0130] In one embodiment, the processor 1400 is specifically configured to:

[0131] Adding a data query node through the process configuration area;

[0132] A node information configuration area is displayed for the data query node; the node information configuration area includes a selection entry for a data monitoring tool;

[0133] The selection entry triggers the display of a monitoring tool selection page, wherein the monitoring tool selection page includes: identifiers of one or more data monitoring tools and the business systems to which they belong;

[0134] When a selection operation for a target data monitoring tool is detected, the data query node is bound to the target data monitoring tool.

[0135] In one embodiment, the processor 1400 is specifically configured to:

[0136] Obtaining node configuration information of the other nodes;

[0137] Acquire monitoring configuration information of the target data monitoring tool; the monitoring configuration information includes the tool information, the SQL query statement and the pre-associated database information.

[0138] The system monitoring solution is run according to the node configuration information of the other nodes and the monitoring configuration information of the target data monitoring tool.

[0139] In one embodiment, the processor 1400 is further configured to:

[0140] Outputting a database maintenance page, the database maintenance page including a business system selection area, a database configuration area, and an account information configuration area; the business system selection area is used to select the target business system from multiple business systems;

[0141] The database configuration area is used to determine the data source information to be monitored under the target business system, and the data source information to be monitored includes one or more of the following information of the database to be monitored: database IP, instance information, port, database type, business type, instance type, database URL and database alias;

[0142] The account information configuration area is used to determine the account information for accessing the database to be monitored;

[0143] The target business system, the information of the data source to be monitored and the account information of the database to be monitored are associated and stored.

[0144] The memory 1401 may include one or more non-volatile memories and one or more volatile memories. Examples of non-volatile memories include, but are not limited to, read-only memory (ROM), electrically programmable read-only memory (EPROM), flash memory, hard disks, compact disks (CDs), digital video disks (DVDs), and other magnetic and / or optical memories. Examples of volatile memories include, but are not limited to, random access memory (RAM) and other volatile memories that do not persist during a power outage.

[0145] The computer program includes computer executable instructions executed by the associated processor 1400. The computer program may be stored in ROM. The processor 1400 may perform any appropriate actions and processes by loading the computer program into RAM.

[0146] The embodiments of the present application can be implemented by a computer program so that the electronic device can execute the reference Figure 1 or Figure 6 The embodiments of the present application may also be implemented by hardware or by a combination of software and hardware.

[0147] In some embodiments, the computer program may be tangibly contained in a computer-readable medium, which may be contained in an electronic device (e.g., memory 1401) or other storage device accessible to the electronic device. The electronic device may load the computer program from the computer-readable medium into RAM for execution. The computer-readable medium may include any type of tangible non-volatile memory, such as ROM, EPROM, flash memory, hard disk, CD, DVD, etc. The computer program is stored on the computer-readable medium.

[0148] In general, various embodiments of the present application may be implemented in hardware or dedicated circuits, software, logic, or any combination thereof. Certain aspects may be implemented in hardware, while other aspects may be implemented in firmware or software, which may be executed by a controller, microprocessor, or other electronic device. Although various aspects of the embodiments of the present application are shown and described as block diagrams, flow charts, or using some other graphical representations, it should be understood that, as non-limiting examples, the blocks, devices, management platforms, techniques, or methods described herein may be implemented in hardware, software, firmware, dedicated circuits or logic, general-purpose hardware or controllers or other electronic devices, or some combination thereof.

[0149] The present application also provides at least one computer program product tangibly stored on a non-transitory computer readable storage medium. The computer program product includes computer executable instructions, such as instructions included in program modules, which are executed in a device on a target real or virtual processor to perform the above-mentioned reference Figure 1 The method described. Generally, program modules include routines, programs, libraries, objects, classes, components, data structures, etc. that perform specific tasks or implement specific abstract data types. In various embodiments, the functionality of program modules can be combined or separated between program modules as needed. Machine-executable instructions for program modules can be executed on local or distributed devices. In distributed devices, program modules can be located in local and remote storage media.

[0150] The program code for executing the method of the present application can be written in any combination of one or more programming languages. These program codes can be provided to a processor or controller of a general-purpose computer, a special-purpose computer or other programmable data processing equipment so that when the program code is executed by the processor or controller, the function / operation specified in the flow chart and / or block diagram is realized. The program code can be executed fully on the machine as an independent software package, partially on the machine, partially on a remote machine, partially on a remote machine, or all on a remote machine or server.

[0151] In the context of this application, computer program codes or related data may be carried by any suitable carrier to enable a device, apparatus or processor to perform various processes and operations as described above. Examples of carriers include signals, computer-readable media, etc.

[0152] The computer-readable medium may be a computer-readable signal medium or a computer-readable storage medium. The computer-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor management platform, device, or apparatus, or any suitable combination of the foregoing. More specific examples of computer-readable storage media include an electrical connection having one or more wires, a portable computer floppy disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0153] In addition, although operations are described in a specific order, this should not be understood as requiring the specific order or sequence shown to perform these operations, or to perform all operations shown, to obtain the required result. In some cases, multi-tasking and parallel processing may be advantageous. Similarly, although several specific implementation details are included in the above discussion, these details should not be interpreted as limiting the scope of the application, but can be interpreted as a description of the specific features of a particular embodiment. Some features described in the context of a separate embodiment also can be combined in a single embodiment. On the contrary, the various features described in the context of a single embodiment also can be realized individually or in any suitable sub-combination in multiple embodiments.

[0154] Although the present application has been described in language specific to structural features and / or methodological acts, it should be understood that the present application defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims.

Claims

1. A data operation monitoring method, characterized in that: The method comprises: Outputting a monitoring tool configuration page for the target business system, the monitoring tool configuration page including a tool information editing area and a script configuration area, the tool information editing area including a database instance selection area; When a trigger operation for the database instance selection area is detected, a database instance selection list is displayed, wherein the database selection list includes database instances pre-associated with the target business system; Determine a target database instance from the database instance selection list, and obtain pre-associated database information of the target database instance, wherein the pre-associated database information includes one or more of the following information of the corresponding database: database IP, instance information, port, database type, and account information; Obtaining the SQL query statement for the data to be monitored entered in the script configuration area; When a run trigger operation is detected, the SQL query statement is run according to the pre-associated database information, and the run result is output.

2. The method according to claim 1, wherein After obtaining the SQL query statement of the data to be monitored input in the script configuration area, the method further includes: When a parsing operation is detected, the query conditions and query fields are parsed from the SQL query statement and displayed.

3. The method according to claim 2, wherein The method further comprises: The SQL query statement is updated according to the adjustment operation on the query condition and / or the query field.

4. The method according to any one of claims 1 to 3, wherein The method further comprises: Acquire the tool information entered in the tool information editing area; A new data monitoring tool for the target business system is generated according to the tool information, the SQL query statement and the pre-associated database information.

5. The method according to claim 4, wherein The method further comprises: Output a monitoring system configuration page, the monitoring system configuration page including a basic information configuration area and a process configuration area; the basic information configuration area is used to obtain basic information of the monitoring process, the basic information including any one or more of the following: process name, process type, and execution mode; Determine the system monitoring plan by selecting and arranging data query nodes and other nodes corresponding to the target data monitoring tool through the process configuration area; the other nodes include any one or more of the following: comparison nodes, selection nodes, merge nodes, parallel nodes, notification nodes and end nodes; Run the system monitoring solution and display the execution result of each node in the system monitoring solution.

6. The method according to claim 5, wherein The step of selecting a data query node corresponding to a target data monitoring tool through the process configuration area includes: Adding a data query node through the process configuration area; A node information configuration area is displayed for the data query node; the node information configuration area includes a selection entry for a data monitoring tool; The selection entry triggers the display of a monitoring tool selection page, wherein the monitoring tool selection page includes: identifiers of one or more data monitoring tools and the business systems to which they belong; When a selection operation for a target data monitoring tool is detected, the data query node is bound to the target data monitoring tool.

7. The method according to claim 5, wherein The running of the system monitoring solution includes: Obtaining node configuration information of the other nodes; Acquire monitoring configuration information of the target data monitoring tool; the monitoring configuration information includes the tool information, the SQL query statement and the pre-associated database information; The system monitoring solution is run according to the node configuration information of the other nodes and the monitoring configuration information of the target data monitoring tool.

8. The method according to claim 1, wherein Before outputting the monitoring tool configuration page for the target business system, the method further includes: Outputting a database maintenance page, the database maintenance page including a business system selection area, a database configuration area, and an account information configuration area; the business system selection area is used to select a target business system from multiple business systems; The database configuration area is used to determine the data source information to be monitored under the target business system, and the data source information to be monitored includes one or more of the following information of the database to be monitored: database IP, instance information, port, database type, business type, instance type, database URL and database alias; The account information configuration area is used to determine the account information for accessing the database to be monitored; The target business system, the information of the data source to be monitored and the account information of the database to be monitored are associated and stored.

9. An electronic device, characterized in that: include: at least one processor; as well as At least one memory having instructions stored thereon, wherein when the instructions are executed individually or collectively by the at least one processor, the electronic device executes the method according to any one of claims 1 to 8.

10. A computer storage medium, characterized in that The computer storage medium stores instructions, which, when executed individually or collectively by at least one processor of an electronic device, enable the electronic device to perform the method according to any one of claims 1 to 8.

Images