Test data management method and system based on database calling corresponding information

Abstract

The invention discloses a test data management method and system based on database calling corresponding information, and belongs to the technical field of test data processing. The method comprises the following steps of monitoring request test tasks of a specified database at a current time monitoring point, and performing classification management on the request test tasks; calculating a core degree index according to the core characteristic parameter of each test table so as to judge whether to enter a data processing module or not; if entering the data processing module, firstly performing priority evaluation based on the priority factor evaluation value of the test task, and performing classified management on the test table and the request test task according to the priority factor evaluation value and the core degree index; and if not, monitoring a database state index, and judging whether abnormal state early warning is needed or not. In the whole process, the health of the database and task priority management are ensured through real-time monitoring and analysis, and the database management efficiency is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of test data processing, and in particular to a test data management method and system based on database calls for corresponding information. Background Art

[0002] With the explosive growth of data volume in modern society, database technology has become the core support of various application systems due to its efficient data management, storage, query, and security mechanisms. The test data management method realizes the centralized storage, efficient retrieval, regular update, and strict verification of test data by utilizing database technology to ensure the accuracy, consistency, and effectiveness of test data.

[0003] Existing test data management methods mainly process concurrent requests in the order of a preset priority queue or submission time, and at the same time use exclusive locks to ensure that when one transaction performs a write operation on data, other transactions cannot read or write to the data.

[0004] For example, the test data management method, device, computer device, and storage medium disclosed in the patent application with the publication number: CN114185807A include: collecting the functional architecture of the target terminal, where the functional architecture consists of multiple functional units; configuring the verification rules for each functional unit based on the functional architecture and a preset rule database, where the rule database is used to store the verification rules corresponding to various functional units; extracting the test data of the target terminal and splitting the test data into multiple functional test data according to each functional unit; respectively performing data verification on the corresponding functional test data according to the verification rules of each functional unit; and when any functional test data fails to pass the verification, sending a verification error message to the target terminal.

[0005] For example, the test data management method and system for industrial production disclosed in the patent application with the publication number: CN118277449A include: S10: setting a test database for products and a backend program connecting to the test database in the server; the test database is used to obtain the test data uploaded by each detection terminal and store the obtained test data; the backend program is used to connect each query terminal; S20: the backend program obtains the query conditions input by the user from the query terminal; S30: the backend program retrieves the test data that meets the query conditions from the test database and performs statistical analysis on the retrieved test data, and sends the test data and the corresponding statistical analysis results to the query terminal for display. A test data management system for industrial production is also provided, which displays the test data and the corresponding statistical analysis results according to the query conditions when querying test data.

[0006] However, in the process of implementing the technical solution of the present invention in the embodiments of the present application, it is found that the above technologies have at least the following technical problems: In the prior art, when processing request test tasks according to the queuing order, since the queuing tasks cannot be dynamically adjusted according to requirements, some low-priority tasks unnecessarily block the execution of high-priority tasks, and the low-priority tasks slow down the overall processing speed, resulting in low database management efficiency. Summary of the Invention

[0007] The present invention provides a test data management method and system based on calling corresponding information from a database, which solves the problem in the prior art that when processing request test tasks according to the queuing order, since the queuing tasks cannot be dynamically adjusted according to requirements, some low-priority tasks unnecessarily block the execution of high-priority tasks, and the low-priority tasks slow down the overall processing speed, resulting in low database management efficiency. It realizes reducing the overall processing time of tasks, thereby improving the efficiency of database management.

[0008] The present invention provides a test data management method based on calling corresponding information from a database, including the following steps: obtaining in real time each request test task and each request test task type of a specified database at the current time monitoring point, classifying based on the test forms of each request test task at the current time monitoring point to obtain the request test tasks of each test form at the current time monitoring point; monitoring in real time the core characteristic parameters of each test form of the specified database to obtain the core degree index of each test form, and judging whether each test form enters the data processing stage according to the number of request test tasks of each test form and the core degree index of each test form at the current time monitoring point; the data processing stage specifically is, obtaining in real time the priority factor data and each request test task influence parameter of each request test task of each test form of the specified database to obtain the priority evaluation value of each request test task of each test form, and at the same time classifying and managing each test form and each request test task based on the core degree index of each test form and the priority evaluation value of each request test task of each test form; if it does not enter the data processing stage, then monitoring the database status data of the specified database at the current time monitoring point to obtain the database status index, and judging whether to give an early warning of an abnormal state based on the database status index at the current time monitoring point.

[0009] Further, the steps of determining whether each test form enters the data processing stage according to the requested test task quantity of each test form at the current time monitoring point and the core degree index of each test form include: matching the requested test task quantity threshold of each test form according to the core degree index of each test form; comparing the requested test task quantity of each test form at the current time monitoring point with the requested test task quantity threshold of each test form respectively. If the requested test task quantity of a certain test form is greater than or equal to the requested test task quantity threshold of this test form, then this test form is not allowed to enter the data processing stage. If the requested test task quantity of a certain test form is less than the requested test task quantity threshold of this test form, then this test form is allowed to enter the data processing stage.

[0010] Further, the steps of real-time monitoring the core characteristic parameters of each test form in the specified database to obtain the core degree index of each test form include: the core characteristic parameters include the number of associated forms, the number of nested associations, and the number of test data references; obtaining the critical number of associated forms, the critical number of nested associations, and the critical number of test data references from the data management database; performing ratio processing on the number of associated forms, the number of nested associations, and the number of test data references of each test form with the critical number of associated forms, the critical number of nested associations, and the critical number of test data references respectively, and further analyzing to obtain the core degree index of each test form; the core degree index represents the quantitative data of the influence degree of the number of associated forms, the number of nested associations, and the number of test data references on the core degree of the test form in the specified database.

[0011] Further, the steps of real-time obtaining the priority factor data of each requested test task and the influencing parameters of each requested test task of each test form in the specified database to obtain the priority evaluation value of each requested test task of each test form include: the priority factor data includes the number of test steps, the number of conditional branches, and the remaining time until the task deadline; the influencing parameters of the requested test task include the number of dependent forms and the number of dependent tasks; obtaining the critical number of test steps, the critical number of conditional branches, the critical remaining time until the task deadline, the critical number of dependent forms, and the critical number of dependent tasks from the data management database; comprehensively analyzing according to the number of test steps and the critical number of test steps, the number of conditional branches and the critical number of conditional branches, the remaining time until the task deadline and the critical remaining time until the task deadline, and the influencing parameters of the requested test task to obtain the priority evaluation value of each requested test task of each test form. The priority evaluation value represents the quantitative data of the influence degree of the number of test steps, the number of conditional branches, and the remaining time until the task deadline on the urgency of the requested test task.

[0012] Further, the steps of classifying and managing each test form and each requested test task based on the core degree index of each test form and the priority evaluation value of each requested test task for each test form include: classifying each test form according to the core degree index of each test form to obtain each important test form and each unimportant test form, and dividing each unimportant test form into a first unimportant test form and a second unimportant test form; sorting each requested test task for each test form from large to small according to the priority evaluation value of each requested test task for each test form to obtain the first sorting of the requested test tasks for each test form; processing the first sorting of the requested test tasks for each test form according to each requested test task type to obtain the second sorting of the requested test tasks for each test form; and managing each requested test task according to the second sorting of the requested test tasks for each test form.

[0013] Further, the steps of processing the first sorting of the requested test tasks for each test form according to each requested test task type to obtain the second sorting of the requested test tasks for each test form include: the requested test task type includes a viewing request task and a modification request task; obtaining the task time data of each viewing request task for each test form, where the task time data includes the task prediction time and the task waiting time; obtaining the critical task prediction time, the critical task waiting time, and the critical priority evaluation value from the data management database, and comprehensively analyzing the task time data of each viewing request task for each test form and the priority evaluation value of each viewing request task for each test form to obtain the priority degree evaluation value of each viewing request task for each test form, and the priority degree evaluation value represents the quantitative data of the influence degree of the task prediction time, the task waiting time, and the priority evaluation value on the execution order of the viewing request task; and processing the first sorting of the requested test tasks for each test form according to the priority degree evaluation value of each viewing request task for each test form to obtain the second sorting of the requested test tasks for each test form.

[0014] Further, the steps of processing the first sorting of the requested test tasks for each test form according to the priority degree evaluation value of each viewing request task for each test form to obtain the second sorting of the requested test tasks for each test form include: obtaining the priority degree evaluation threshold from the data management database; comparing the priority degree evaluation value of each viewing request task for each test form with the priority degree evaluation threshold, if the priority degree evaluation value of a certain viewing request task for a certain test form is greater than or equal to the priority degree evaluation threshold, then move the order of this viewing request task to the previous viewing request sorting, if the priority degree evaluation value of a certain viewing request task for a certain test form is less than the priority degree evaluation threshold, then no additional operation is performed; and marking the sorted requested test tasks for each test form after processing as the second sorting of the requested test tasks for each test form.

[0015] Further, the steps of managing each requested test task according to the second sorting of the requested test tasks in each test form include: managing each requested test task in each important test form according to the second sorting of the requested test tasks in each important test form, and evaluating and feeding back the status of each important test form after the management operation; managing each requested test task in each unimportant test form according to the second sorting of the requested test tasks in each unimportant test form and the database status index; the management operation includes backup, flow limiting, and queuing.

[0016] Further, the steps of monitoring the database status data of the specified database at the current time monitoring point to obtain the database status index and judging whether to issue an abnormal status warning based on the database status index at the current time monitoring point include: the database status data includes the task table ratio and the total processing time of the requested test tasks, and the task table ratio represents the ratio of the number of requested test tasks to the number of test forms; obtaining the critical task table ratio, the critical total processing time of the requested test tasks, and the database status index threshold from the data management database; comprehensively analyzing the ratio of the task table ratio to the critical task table ratio and the ratio of the total processing time of the requested test tasks to the average value of the critical total processing time of the requested test tasks to obtain the database status index, and the database status index represents the quantitative data of the influence degree of the task table ratio and the total processing time of the requested test tasks on the database status; comparing the database status index with the database status index threshold, if the database status index is greater than or equal to the database status index threshold, enter the data processing stage, if the database status index is less than the database status index threshold, issue an abnormal status warning.

[0017] The embodiment of the present application provides a test data management system based on calling corresponding information from a database, which includes a task classification module, a stage judgment module, a data processing module, a database monitoring module, and a data management database; wherein, the task classification module is used to obtain each requested test task and each requested test task type of a specified database at the current time monitoring point in real time, classify based on the test tables of each requested test task at the current time monitoring point, and obtain the requested test tasks of each test table at the current time monitoring point; the stage judgment module is used to monitor the core feature parameters of each test table of the specified database in real time to obtain the core degree index of each test table, and judge whether each test table enters the data processing stage according to the number of requested test tasks of each test table and the core degree index of each test table at the current time monitoring point; the data processing module is used to obtain the priority factor data and the influence parameters of each requested test task of each test table of the specified database in real time to obtain the priority evaluation value of each requested test task of each test table, and at the same time classify and manage each test table and each requested test task based on the core degree index of each test table and the priority evaluation value of each requested test task of each test table; the database monitoring module is used to monitor the database status data of the specified database at the current time monitoring point to obtain the database status index, and judge whether to give an early warning of an abnormal state based on the database status index at the current time monitoring point.

[0018] The embodiment of the present application provides a computer-readable storage medium for storing a program, which when executed by a processor implements a test data management method based on calling corresponding information from a database.

[0019] The embodiment of the present application provides an electronic device, including: a processor and a memory for storing executable instructions of the processor; when the processor is configured to execute the instructions, the electronic device implements a test data management method based on calling corresponding information from a database.

[0020] One or more technical solutions provided in the embodiment of the present application have at least the following technical effects or advantages: 1. By providing a test data management method and system based on calling corresponding information from a database, the present invention effectively classifies and manages the requested test tasks of each test table, thereby realizing the efficient scheduling of database test tasks, the optimal allocation of resources, and the guarantee of system stability, comprehensively improving the efficiency and security of database management.

[0021] 2. The present invention performs a secondary sorting on the requested test tasks of each test form, thereby managing different tasks more precisely, further achieving more efficient resource allocation under different task priorities, optimizing the task execution order, ensuring that critical tasks can be processed in a timely manner, avoiding resource waste of low-priority tasks, and improving the overall operation efficiency and response ability of the system.

[0022] 3. The present invention classifies and manages test forms and tasks based on the core degree index of each test form and the priority evaluation value of each requested test task, thereby being able to accurately identify and process critical tasks, preferentially allocate resources and processing capabilities, and further achieving more efficient data management and an optimized task execution process, improving the stability and response ability of the overall system. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 It is a flowchart of a test data management method for calling corresponding information based on a database provided by an embodiment of the present application; Figure 2 It is a change diagram of the core degree index of a test form based on the test data management method provided by an embodiment of the present application; Figure 3 It is a schematic structural diagram of a test data management system for calling corresponding information based on a database provided by an embodiment of the present application. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0024] Embodiments of the present application provide a test data management method and system for calling corresponding information based on a database, which solves the problem in the prior art that when processing request test tasks according to the queuing order, since the queuing tasks cannot be dynamically adjusted according to requirements, some low-priority tasks unnecessarily block the execution of high-priority tasks, and the low-priority tasks slow down the overall processing speed, resulting in low database management efficiency. By obtaining each request test task and each request test task type of a specified database at the current time monitoring point in real time, classifying based on the test tables of each request test task at the current time monitoring point, and obtaining the request test tasks of each test table at the current time monitoring point; monitoring the core characteristic parameters of each test table of the specified database in real time to obtain the core degree index of each test table, and judging whether each test table enters the data processing stage according to the request test task quantity of each test table and the core degree index of each test table at the current time monitoring point; the data processing stage specifically is to obtain the priority factor data and each request test task influence parameter of each request test task of each test table of the specified database in real time to obtain the priority evaluation value of each request test task of each test table, and at the same time, classify and manage each test table and each request test task based on the core degree index of each test table and the priority evaluation value of each request test task of each test table; if it does not enter the data processing stage, then monitor the database status data of the specified database at the current time monitoring point to obtain the database status index, and judge whether to give an early warning of an abnormal state based on the database status index at the current time monitoring point, reducing the overall processing time of the task, thereby improving the efficiency of database management.

[0025] The technical solution in the embodiments of the present application for solving the problem that when processing request test tasks according to the queuing order, since the queuing tasks cannot be dynamically adjusted according to requirements, some low-priority tasks unnecessarily block the execution of high-priority tasks, and the low-priority tasks slow down the overall processing speed, resulting in low database management efficiency, is generally as follows: By monitoring the request test tasks and task types of the specified database in real time, classifying the test tables based on the time monitoring point, obtaining the request task quantity of each test table, and then monitoring the core characteristic parameters of the test tables in real time, evaluating the core degree index of each table, and judging whether to enter the data processing stage. Among them, if it enters the data processing stage, obtain the priority factors and influence parameters of the tasks, calculate the priority evaluation value, and classify and manage the tasks based on the core degree index and priority; if it does not enter the processing stage, then monitor the specified database status index and judge whether an early warning of an abnormal state is required, achieving optimized management of tasks, intelligent decision support, and reasonable allocation of resources.

[0026] To better understand the above technical solution, the above technical solution will be described in detail below in conjunction with the accompanying drawings of the specification and specific embodiments.

[0027] As Figure 1 shown, it is a flowchart of a test data management method for calling corresponding information based on a database provided by an embodiment of the present application. The method includes the following steps: Real-time obtain each request test task and each request test task type of a specified database at the current time monitoring point, based on the test form of each request test task at the current time monitoring point, where the test form is used to organize and store structured data related to the test task, the test data is the actual data required for the execution of the test task, stored in the test form, the request test task is the execution unit of the test, and it depends on the test data stored in the test form to perform specific test operations. Classify each request test task that is consistent with the application test form into one category for classification, and obtain the request test tasks of each test form at the current time monitoring point; Real-time monitor the core feature parameters of each test form of the specified database to obtain the core degree index of each test form, and judge whether each test form enters the data processing stage according to the number of request test tasks of each test form and the core degree index of each test form at the current time monitoring point; If it enters the data processing stage, real-time obtain the priority factor data and each request test task impact parameter of each request test task of each test form of the specified database to obtain the priority evaluation value of each request test task of each test form, and at the same time classify and manage each test form and each request test task based on the core degree index of each test form and the priority evaluation value of each request test task of each test form; If it does not enter the data processing stage, monitor the database status data of the specified database at the current time monitoring point to obtain the database status index, and judge whether to issue an abnormal status warning based on the database status index at the current time monitoring point.

[0028] In this embodiment, classifying the test forms according to the request test tasks can accurately track the request test task situation of each test form at different time points, ensuring the accuracy and pertinence of data processing, because different test forms may carry different test requirements and importance; When judging whether each test form enters the data processing stage first, it ensures that key and urgent data can be processed in a timely manner; When entering the data processing stage, calculating the priority evaluation value of each request test task can classify and manage each test form and each request test task based on the priority of the task and the core degree of the test form, which helps to optimize the data processing process and ensure the most effective use of resources; If it does not enter the data processing stage, the system will continue to monitor the status of the specified database and trigger an alarm when necessary, enhancing the stability and reliability of the system, because timely abnormal status warnings can help administrators take measures quickly to prevent potential problems from expanding.

[0029] In addition, a specified database is used to store relevant data such as request test tasks and test forms, while a data management database is used to store relevant data of a test data management method for calling corresponding information based on the database, including: the number of critical associated forms, the number of critical nested associations, the number of times of critical test data references, the influence factor of the core degree index corresponding to the number of associated forms, and the priority evaluation threshold, etc. The data in the data management database can be directly queried through public databases such as CNKI and Wanfang Data, or data sharing agreements can be signed with other organizations or enterprises to open up some data resources to each other, so as to achieve the exchange and common utilization of data.

[0030] Further, the steps of determining whether each test form enters the data processing stage according to the request test task quantity of each test form at the current time monitoring point and the core degree index of each test form include: matching the request test task quantity threshold of each test form according to the core degree index of each test form; comparing the request test task quantity of each test form at the current time monitoring point with the request test task quantity threshold of each test form respectively. If the request test task quantity of a certain test form is greater than or equal to the request test task quantity threshold of this test form, then this test form is not allowed to enter the data processing stage. If the request test task quantity of a certain test form is less than the request test task quantity threshold of this test form, then this test form is allowed to enter the data processing stage.

[0031] In this embodiment, the request test task quantity threshold represents a critical value of the request test task quantity that this test form can bear. Obtain the request test task quantity threshold mapping set corresponding to each core degree index from the data management database, where this mapping set is obtained by corresponding each core degree index to each request test task quantity threshold one by one. When obtaining the request test task quantity threshold of each test form, input the core degree index of each test form into the mapping set to obtain the request test task quantity threshold of each test form corresponding to the core degree index of each test form. By comparing the request test task quantity of each test form at the current time monitoring point with the request test task quantity threshold of each test form respectively, it can ensure that core forms are processed preferentially, guarantee the quality of data processing, improve the overall utilization rate of database resources at the same time, and enhance system stability.

[0032] Further, the steps of real-time monitoring of the core characteristic parameters of each test table in the specified database to obtain the core degree index of each test table include: the core characteristic parameters include the number of associated tables, the number of nested associations, and the number of test data references; obtaining the critical number of associated tables, the critical number of nested associations, and the critical number of test data references from the data management database; performing ratio processing on the number of associated tables, the number of nested associations, and the number of test data references of each test table with the critical number of associated tables, the critical number of nested associations, and the critical number of test data references respectively, and further analyzing to obtain the core degree index of each test table. The core degree index represents the quantitative data of the influence degree of the number of associated tables, the number of nested associations, and the number of test data references on the core degree of the test table in the specified database.

[0033] In this embodiment, the number of associated tables refers to the number of other tables directly associated with a certain test table. The association relationship can be established through foreign keys, references, connections, etc., and can be directly obtained by querying the number of foreign key constraints, JOIN conditions, etc. between the tables in the database; the number of nested associations refers to the number of deeper-level associations in the tables associated with the target table, and can be obtained by recursively querying the multi-level associations in the database to obtain the hierarchical structure of the table nesting; the number of test data references refers to the total number of times all test data in a certain test table are referenced by other tables and tasks in the system, and can be directly obtained by analyzing SQL query logs, database dependencies, etc. Among them, the three are interrelated. For example, if a test table establishes foreign key associations or reference relationships with multiple tables, then its data may be used by more queries, operations, or tasks. Therefore, the more the number of associated tables, the higher the number of test data references; the more the number of nested associations, the more data and query times are often involved, resulting in an increase in the number of references. The core degree index obtained through comprehensive analysis can help identify the core test tables and data in the system. At the same time, by understanding the association and reference relationships of each table, the scheduling and resource allocation of tasks can be optimized to ensure that important tasks are processed first. Based on the core degree index, the priority of data processing can be adjusted to ensure that complex or highly dependent tasks are processed in a timely manner and avoid system bottlenecks.

[0034] Among them, the method for obtaining the core degree index of each test table is as follows: ; In the formula, represents the core degree index of the i-th test table, represents the core degree index influence factor corresponding to the number of associated tables, represents the core degree index influence factor corresponding to the number of nested associations, Indicates the impact factor of the core degree index corresponding to the number of references to test data Indicates the number of associated tables of the i-th test table Indicates the critical number of associated tables Indicates the nested association quantity of the i-th test table Indicates the critical nested association quantity Indicates the number of references to test data of the i-th test table Indicates the critical number of references to test data, where i is the number of each test table, i = 1, 2, 3,..., Z, Z is the total number of test tables, and the sinh function is the hyperbolic sine function, which is convenient for querying the relationship changes between the core feature parameters and the core degree index

[0035] 、 and Are respectively the impact factors of the core degree index corresponding to the number of associated tables, the number of nested associations, and the number of references to test data preset in the data management database. These impact factors are numerical indicators for measuring the influence of the above core feature parameters on the core degree index. Specifically, there is a mapping relationship table for each of the number of associated tables, the number of nested associations, and the number of references to test data. The table records each possible value of the core feature parameter and its corresponding impact factor of the core degree index. These mapping relationships can be one-to-one or many-to-one. For example, in practical applications, when it is necessary to evaluate the core degree index of a certain test table, the measured number of associated tables, the number of nested associations, and the number of references to test data can be respectively input into their corresponding mapping relationship tables, and the impact factors corresponding to these values can be quickly found. The value range of the impact factor is between 0 and 1

[0036] Set the impact factor of the core degree index corresponding to the number of associated tables to 0.3, the impact factor of the core degree index corresponding to the number of nested associations to 0.3, the impact factor of the core degree index corresponding to the number of references to test data to 0.4. Set the number of associated tables of the i-th test table to 5, the critical number of associated tables to 3, the nested association quantity of this test table to 3, the critical nested association quantity to 3, and the critical number of references to test data to 50. Calculate the core degree index of this test table when the number of references to test data in this test table is continuously increasing. As shown in Table 1, the data table of the core degree index of the test table based on the test data management method

[0037] Table 1 Data table of the core degree index of the test table based on the test data management method Number <![CDATA[RD 1i > <![CDATA[CL i <!-- 7 -->]]> 1 30 1.238 2 40 1.369 3 50 1.509 4 60 1.659 5 70 1.820 Such as Figure 2As shown in the figure, it is a chart showing the change of the core degree index of the test form provided by the embodiment of the present application based on the test data management method. As shown in Table 1 and Figure 2 It can be seen that when the influence factors of the core degree index corresponding to the number of associated forms, the influence factors of the core degree index corresponding to the number of nested associations, the influence factors of the core degree index corresponding to the number of test data references, the number of associated forms of the i-th test form, the critical number of associated forms, the number of nested associations of the test form, the critical number of nested associations, and the critical number of test data references remain unchanged, and the number of test data references of the test form is continuously increasing, the core degree index of the test form is also continuously increasing.

[0038] Further, the steps of obtaining the priority evaluation value of each request test task of each test form by obtaining the priority factor data and the influence parameters of each request test task of each test form in the specified database in real time include: the priority factor data includes the number of test steps, the number of conditional branches, and the remaining time until the task deadline; the influence parameters of the request test task include the number of dependent forms and the number of dependent tasks; obtaining the critical number of test steps, the critical number of conditional branches, the critical remaining time until the task deadline, the critical number of dependent forms, and the critical number of dependent tasks from the data management database; and comprehensively analyzing according to the number of test steps and the critical number of test steps, the number of conditional branches and the critical number of conditional branches, the remaining time until the task deadline and the critical remaining time until the task deadline, and the influence parameters of the request test task to obtain the priority evaluation value of each request test task of each test form. The priority evaluation value represents the quantitative data of the influence degree of the number of test steps, the number of conditional branches, and the remaining time until the task deadline on the urgency of the request test task.

[0039] In this embodiment, the number of test steps refers to the number of specific steps or operations included in a certain test task, which can be counted by analyzing the steps in the test case document, test plan, or automated test script; the number of conditional branches refers to the number of decision points in the test task, which can be directly obtained by analyzing the branch statements (such as if, else, switch, etc.) in the test code; the remaining time until the task deadline refers to the remaining time between the current time and the deadline of the test task, which can be obtained by querying the deadline in the task scheduling system, project management tool, or test management system and calculating the difference between the current time and the deadline. The three are interrelated. For example, a test task with a large number of test steps may have more conditional branches because more operation steps may lead to more decisions; if the number of test steps or conditional branches is large, it usually means that the task is complex and requires more time, but if the remaining time until the task deadline is short, it must be processed first, even if it is complex.

[0040] The impact parameters of the request test task are used to quantify the dependency impact of the request test task on the priority evaluation value of the request test task, and can dynamically adjust the priority evaluation value of the request test task. Among them, the number of dependent tables refers to the number of tables in the specified database that a certain test task needs to utilize, which can be obtained by analyzing the business logic of the test task or SQL queries; the number of dependent tasks refers to the number of other tasks that need to be completed before a certain test task is completed, which can be directly queried using the task management module built into the specified database. The two are interrelated. Generally speaking, a task that depends on more tables may also require more tasks to be completed, because complex data requirements may require more complex preconditions or dependent tasks. The impact parameters of the request test task obtained through comprehensive analysis can help evaluate the complexity of the task and the degree of dependence on the system, and further determine its priority. The priority evaluation value of each request test task for each test table obtained through comprehensive analysis of the priority factor data of each request test task for each test table and the impact parameters of each request test task can determine the priority of each test task, avoid low-priority tasks occupying too many resources, and ensure that critical tasks can be executed in a timely manner; at the same time, it provides a clear view of the dependencies between tasks, helps predict potential delay problems, and adjusts the plan in a timely manner.

[0041] Among them, the method for obtaining the priority evaluation value of each request test task for each test table is as follows: ; ; In the formula, represents the priority evaluation value of the kth request test task for the ith test table, represents the priority evaluation impact factor corresponding to the number of test steps, represents the priority evaluation impact factor corresponding to the number of conditional branches, represents the priority evaluation impact factor corresponding to the remaining time until the task deadline, represents the number of test steps of the kth request test task for the ith test table, represents the critical number of test steps, represents the number of conditional branches of the kth request test task for the ith test table, represents the critical number of conditional branches, represents the remaining time until the task deadline of the kth request test task for the ith test table, represents the critical remaining time until the task deadline, represents the impact parameter of the kth request test task for the ith test table, represents the impact parameter impact factor of the request test task corresponding to the number of dependent tables, Indicates the impact factor of the request test task impact parameter corresponding to the number of dependent tasks, Indicates the number of tables that the kth request test task of the i-th test table depends on. Indicates the number of critical dependency tables, Indicates the number of dependent tasks of the kth request test task in the i-th test table, represents the number of critical dependent tasks, e is a natural constant, k is the number of each request test task, k=1,2,3,...,K, K is the total number of request test tasks, and tanh function is a hyperbolic tangent function. The priority evaluation value of each request test task in each test table is normalized so that higher and lower evaluation values can be reasonably expressed within the range.

[0042] , and The priority assessment impact factors corresponding to the number of test steps, the number of conditional branches and the remaining time of the task deadline preset in the data management database are numerical indicators that measure the impact of the above-mentioned priority factor data on the priority assessment value. Specifically, there is a mapping relationship table for the number of test steps, the number of conditional branches and the remaining time of the task deadline respectively, and the table records each possible priority factor data value and its corresponding priority assessment impact factor. These mapping relationships can be one-to-one or many-to-one. For example, in actual applications, when it is necessary to evaluate the priority assessment value of a request test task in a certain test form, the measured number of test steps, the number of conditional branches and the remaining time of the task deadline can be respectively input into the corresponding mapping relationship table, and the priority assessment impact factors corresponding to these values can be quickly found, where the value range of the impact factor is between 0 and 1.

[0043] and The influencing factors of the request test task influencing parameters corresponding to the number of dependent tables and the number of dependent tasks preset in the data management database are numerical indicators that measure the influence of the above-mentioned request test task influencing parameters on the request test task influencing parameters. Specifically, there is a mapping relationship table for the number of dependent tables and the number of dependent tasks respectively, and the table records each possible number of dependent tables and number of dependent tasks and their corresponding request test task influencing parameter influencing factors. These mapping relationships can be one-to-one or many-to-one. For example, in actual applications, when it is necessary to evaluate the influencing parameters of a request test task of a certain test table, the measured number of dependent tables and number of dependent tasks can be input into their respective corresponding mapping relationship tables, and the request test task influencing parameter influencing factors corresponding to these values can be quickly found, where the value range of the influencing factor is between 0 and 1.

[0044] Further, the steps of classifying and managing each test form and each requested test task based on the core degree index of each test form and the priority evaluation value of each requested test task for each test form include: classifying each test form according to the core degree index of each test form, comparing the core degree index of each test form with the core degree index threshold obtained from the data management database. If the core degree index of a certain test form is greater than or equal to the core degree index threshold, then mark this test form as an important test form. If the core degree index of a certain test form is less than the core degree index threshold, then mark this test form as a non-important test form, and count to obtain each important test form and each non-important test form. Each non-important test form is divided into a first non-important test form and a second non-important test form; sort each requested test task in descending order according to the priority evaluation value of each requested test task for each test form to obtain the first sorting of the requested test tasks for each test form; process the first sorting of the requested test tasks for each test form according to each requested test task type to obtain the second sorting of the requested test tasks for each test form; manage each requested test task according to the second sorting of the requested test tasks for each test form.

[0045] In this embodiment, the first sorting of the requested test tasks is the initial sorting of all requested test tasks according to the priority. The second sorting of the requested test tasks is to modify the sorting of the view requested test tasks that can be executed in advance within the target time period and process them simultaneously in the sorting of the view requested test tasks being processed currently. By giving priority to important and urgent test tasks, time and resources can be utilized more effectively, and unnecessary delays and wastes can be reduced; allocating resources according to the core degree of the test form and the priority of the requested test task can ensure that key tasks receive sufficient attention and support; in addition, clear classification and management processes help project managers better track and control the test progress and adjust strategies in a timely manner to address potential risks and challenges.

[0046] Further, the step of processing the first sorting of the requested test tasks of each test form according to the types of the requested test tasks to obtain the second sorting of the requested test tasks of each test form includes: the types of the requested test tasks include viewing request tasks and modification request tasks; obtaining the task time data of each viewing request task of each test form, where the task time data includes task prediction time and task waiting time; obtaining the critical task prediction time, critical task waiting time, and critical priority evaluation value from the data management database, and comprehensively analyzing the task time data and the priority evaluation value of each viewing request task of each test form to obtain the priority evaluation value of each viewing request task of each test form, and the priority evaluation value represents the quantitative data of the influence degree of the task prediction time, task waiting time, and priority evaluation value on the execution order of the viewing request task; processing the first sorting of the requested test tasks of each test form according to the priority evaluation value of each viewing request task of each test form to obtain the second sorting of the requested test tasks of each test form.

[0047] In this embodiment, the task prediction time includes the predicted time of the viewing request task to be processed and the predicted time of the viewing request task to be processed. When the type of the requested test task ranked first is a viewing request task, secondary sorting processing is performed. At the same time, it is necessary to obtain the task length threshold from the data management database as the adjustable task range, and judge whether there are other viewing request tasks within the task length threshold range of the first requested test task. If so, merge the other viewing request tasks into the current viewing request task order. The task time data mainly reflects the time requirements and waiting time of each requested test task. Among them, the task prediction time is the estimated time required to complete the task, which can be calculated as the average value according to the execution time of the same type of historical tasks, and the task waiting time is the time that the task has waited for execution at the current time monitoring point, which can be directly queried from the database. By combining the task time data with the priority evaluation value, the system can better allocate resources and avoid resource conflicts between urgent tasks and complex tasks.

[0048] Among them, the method for obtaining the priority evaluation value of each viewing request task of each test form is as follows: ; ; In the formula, represents the priority evaluation value of the j-th viewing request test task of the i-th test form, represents the influence factor of the priority evaluation corresponding to the task prediction time, represents the influence factor of the priority evaluation corresponding to the task waiting time, represents the influence factor of the priority evaluation corresponding to the priority evaluation value, represents the task prediction time of the j-th viewing request test task in the i-th test form, represents the critical task prediction time, represents the task waiting time of the j-th viewing request test task in the i-th test form, represents the critical task waiting time, represents the priority evaluation value of the j-th viewing request test task in the i-th test form, represents the critical priority evaluation value, represents the task prediction time of the j-th upcoming viewing request task to be processed in the i-th test form, represents the task prediction time of the j-th viewing request task to be processed in the i-th test form, where j is the number of each viewing request task, j = 1, 2, 3,..., M, and M is the total number of viewing request tasks.

[0049] and and are respectively the influencing factors for evaluating the priority degree corresponding to the preset task prediction time, task waiting time, and priority evaluation value in the data management database. These influencing factors are numerical indicators for measuring the influence of the above parameters on the priority degree evaluation value. Specifically, there is a mapping relationship table for each of the task prediction time, task waiting time, and priority evaluation value. The table records each possible parameter value and its corresponding influencing factor for evaluating the priority degree. These mapping relationships can be one-to-one or many-to-one. For example, in practical applications, when it is necessary to evaluate the priority degree evaluation value of a certain request test task in a certain test form, the measured task prediction time, task waiting time, and priority evaluation value can be respectively input into their corresponding mapping relationship tables, and the influencing factors corresponding to these values can be quickly found. The value range of the influencing factor is between 0 and 1.

[0050] Further, the steps of processing the first sorting of the request test tasks of each test form according to the priority degree evaluation value of each viewing request task of each test form to obtain the second sorting of the request test tasks of each test form include: obtaining the priority degree evaluation threshold from the data management database; comparing the priority degree evaluation value of each viewing request task of each test form with the priority degree evaluation threshold. If the priority degree evaluation value of a certain viewing request task of a certain test form is greater than or equal to the priority degree evaluation threshold, then move the order of this viewing request task to the previous viewing request sorting. If the priority degree evaluation value of a certain viewing request task of a certain test form is less than the priority degree evaluation threshold, no additional operation is performed; mark the sorted request test tasks of each test form after processing as the second sorting of the request test tasks of each test form.

[0051] In this embodiment, the priority evaluation threshold is a preset value used to evaluate whether a viewing request test task has a higher priority. Since the task completion time of the viewing request test task is much lower than that of the modification request test task, prioritizing the viewing request test task helps to reasonably allocate time calculations, reduce the waiting time during resource contention, thereby reducing the overall processing time of the task, and thus improving the efficiency of database management.

[0052] Further, the steps of managing each request test task according to the second sorting of the request test tasks in each test form include: managing each request test task in each important test form according to the second sorting of the request test tasks in each important test form, and evaluating and feedbacking the status of each important test form after the management operation; managing each request test task in each non-important test form according to the second sorting of the request test tasks in each non-important test form and the database status indicators; the management operation includes backup, flow limiting, and queuing.

[0053] In this embodiment, when managing each request test task, multiple adjacent viewing request test tasks in the sorting can be processed together. Among them, for each important test form, high-frequency backup needs to be performed first (for example, backup once per minute), and then each request test task is processed according to the second sorting of the request test tasks in each important test form. The modification request test task is restricted to only one at the same time, and after the management operation, each test data content of each important test form is obtained for content comparison according to the sorting. If an abnormal test data content occurs, the test data is immediately replaced with the previous backup content, and an error reminder is given for the request test task that has been completed but has abnormal content according to the sorting; for the first non-important test form, differential backup can be used (only record the data that has changed since the last backup), and at the same time, the limit is relaxed to 20 modification requests per second; for the second non-important test form, a relatively simple backup method can be used (such as full backup once a week), and flow limiting is only performed when the database status indicator exceeds the database status indicator threshold, and no flow limiting is performed otherwise.

[0054] Further, the steps of monitoring the database status data of the specified database at the current time monitoring point to obtain database status metrics and determining whether to issue an abnormal status warning based on the database status metrics at the current time monitoring point include: the database status data includes the task table ratio and the total request test task processing time, and the task table ratio represents the ratio of the number of request test tasks to the number of test tables; obtaining the critical task table ratio, the critical total request test task processing time, and the database status metric threshold from the data management database; comprehensively analyzing the ratio of the task table ratio to the average of the critical task table ratio and the total request test task processing time to the critical total request test task processing time to obtain the database status metric, and the database status metric represents the quantitative data of the degree of influence of the task table ratio and the total request test task processing time on the database status; comparing the database status metric with the database status metric threshold, if the database status metric is greater than or equal to the database status metric threshold, enter the data processing stage, if the database status metric is less than the database status metric threshold, issue an abnormal status warning.

[0055] In this embodiment, the higher the task table ratio, the more tasks are processed on each table, which may lead to an increase in the load of the database, resulting in a lower database status metric; the total request test task processing time may indicate poor system performance, or a high load, and a lag in task processing time, resulting in a lower database status metric. The two are interrelated. When the task table ratio increases, more tasks may need to be processed on a single table, which may lead to an increase in the total request processing time. By analyzing the relationship between the task table ratio and the total request test task processing time, the performance of the database under different loads can be obtained.

[0056] Among them, the acquisition method of the database status metric is as follows: , In the formula, represents the database status metric, represents the database status metric influence factor corresponding to the task table ratio, represents the database status metric influence factor corresponding to the total request test task processing time, represents the task table ratio, represents the critical task table ratio, represents the total request test task processing time, represents the critical total request test task processing time.

[0057] and They are respectively the influence factors of the task table ratio preset in the data management database and the total time for processing the request test tasks corresponding to the database state indicators. These influence factors are numerical indicators for measuring the influence of the above database state data on the priority evaluation value. Specifically, there is a mapping relation table for each of the task table ratio and the total time for processing the request test tasks. The table records each possible database state data value and its corresponding database state indicator influence factor. These mapping relations can be one-to-one or many-to-one. For example, in practical applications, when it is necessary to evaluate the database state indicators, the measured task table ratio and the total time for processing the request test tasks can be respectively input into their corresponding mapping relation tables, and the database state indicator influence factors corresponding to these values can be quickly found. The value range of the influence factor is between 0 and 1.

[0058] As Figure 3 shown, it is a schematic structural diagram of the test data management system based on database call corresponding information provided by an embodiment of the present application. The test data management system based on database call corresponding information provided by an embodiment of the present application includes: a task classification module, a stage judgment module, a data processing module, a database monitoring module, and a data management database; among them, the task classification module is used to obtain each request test task and each request test task type of the specified database at the current time monitoring point in real time, and classify them based on the test forms of each request test task at the current time monitoring point to obtain the request test tasks of each test form at the current time monitoring point; the stage judgment module is used to monitor the core characteristic parameters of each test form of the specified database in real time to obtain the core degree indicators of each test form, and judge whether each test form enters the data processing stage according to the number of request test tasks of each test form and the core degree indicators of each test form at the current time monitoring point; the data processing module is used to obtain the priority factor data and each request test task influence parameter of each request test task of each test form of the specified database in real time to obtain the priority evaluation value of each request test task of each test form, and at the same time classify and manage each test form and each request test task based on the core degree indicators of each test form and the priority evaluation value of each request test task of each test form; the database monitoring module is used to monitor the database state data of the specified database at the current time monitoring point to obtain the database state indicators, and judge whether to give an abnormal state warning based on the database state indicators at the current time monitoring point.

[0059] In summary, in the embodiments of the present application, by obtaining in real time each request test task and each request test task type of a specified database at the current time monitoring point, classifying based on the test tables of each request test task at the current time monitoring point, the request test tasks of each test table at the current time monitoring point are obtained; the core characteristic parameters of each test table of the specified database are monitored in real time to obtain the core degree index of each test table, and it is judged whether each test table enters the data processing module according to the number of request test tasks of each test table and the core degree index of each test table at the current time monitoring point; if it enters the data processing module, the priority factor data and the request test task influence parameters of each request test task of each test table of the specified database are obtained in real time to obtain the priority evaluation value of each request test task of each test table, and at the same time, each test table and each request test task are classified and managed based on the core degree index of each test table and the priority evaluation value of each request test task of each test table; if it does not enter the data processing module, the database status data of the specified database at the current time monitoring point is monitored to obtain the database status index, and it is judged whether to give an abnormal status warning based on the database status index at the current time monitoring point, reducing the overall processing time of tasks, thereby improving the efficiency of database management.

[0060] Those skilled in the art should understand that the embodiments of the present invention can be provided as a method, a system, or a computer program product. Therefore, the present invention can take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, the present invention can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0061] The present invention is described with reference to the flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, and the combination of processes and / or blocks in the flowchart and / or block diagram, can be realized by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing devices to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing devices generate means for realizing the specified functions in Figure 1 one process or multiple processes and / or blocks Figure 1 one block or multiple blocks.

[0062] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to operate in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means that implement the function specified in the flowchart(s) Figure 1 of one or more flowcharts and / or block(s) Figure 1 of one or more blocks.

[0063] These computer program instructions can also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer-implemented process, whereby the instructions executed on the computer or other programmable apparatus provide steps for implementing the function specified in the flowchart(s) Figure 1 of one or more flowcharts and / or block(s) Figure 1 of one or more blocks.

[0064] Although the preferred embodiments of the present invention have been described, additional changes and modifications can be made by those skilled in the art once they learn of the basic inventive concept. Therefore, the appended claims are intended to be construed to include the preferred embodiments as well as all changes and modifications that fall within the scope of the present invention.

[0065] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalent technologies, the present invention is also intended to include these modifications and variations.

Claims

1. A test data management method for calling corresponding information based on a database, characterized in that, Including the following steps: Obtain each request test task and each request test task type of the specified database at the current time monitoring point in real time, classify based on the test tables of each request test task at the current time monitoring point, and obtain the request test tasks of each test table at the current time monitoring point; Monitor the core characteristic parameters of each test table in the specified database in real time to obtain the core degree index of each test table, and determine whether each test table enters the data processing stage according to the number of request test tasks of each test table and the core degree index at the current time monitoring point; The data processing stage specifically is to obtain the priority factor data and each request test task impact parameter of each request test task of each test table in the specified database in real time to obtain the priority evaluation value of each request test task of each test table, and at the same time classify and manage each test table and each request test task based on the core degree index of each test table and the priority evaluation value of each request test task of each test table; If it does not enter the data processing stage, then monitor the database status data of the specified database at the current time monitoring point to obtain the database status index, and determine whether to issue an abnormal status warning based on the database status index at the current time monitoring point.

2. The test data management method based on database call of corresponding information according to claim 1, wherein: The step of determining whether each test table enters the data processing stage according to the number of request test tasks of each test table and the core degree index at the current time monitoring point includes: Match the number of request test task thresholds of each test table according to the core degree index of each test table; Compare the number of request test tasks of each test table at the current time monitoring point with the number of request test task thresholds of each test table respectively. If the number of request test tasks of a certain test table is greater than or equal to the number of request test task threshold of this test table, then this test table is not allowed to enter the data processing stage. If the number of request test tasks of a certain test table is less than the number of request test task threshold of this test table, then this test table is allowed to enter the data processing stage.

3. The test data management method for calling corresponding information based on a database according to claim 1, characterized in that: The step of monitoring the core characteristic parameters of each test table in the specified database in real time to obtain the core degree index of each test table includes: The core characteristic parameters include the number of associated tables, the number of nested associations, and the number of test data references; Obtain the critical number of associated tables, the critical number of nested associations, and the critical number of test data references from the data management database; Perform ratio processing on the number of associated tables, the number of nested associations, and the number of test data references of each test table with the critical number of associated tables, the critical number of nested associations, and the critical number of test data references respectively, and further analyze to obtain the core degree index of each test table. The core degree index represents the quantitative data of the influence degree of the number of associated tables, the number of nested associations, and the number of test data references on the core degree of the test table in the specified database.

4. The test data management method based on database call of corresponding information according to claim 1, characterized in that: The step of obtaining the priority factor data and each request test task impact parameter of each request test task of each test table in the specified database in real time to obtain the priority evaluation value of each request test task of each test table includes: The priority factor data includes the number of test steps, the number of conditional branches, and the remaining time until the task deadline; The request test task impact parameters include the number of dependency tables and the number of dependent tasks; Obtain the critical number of test steps, the critical number of conditional branches, the critical remaining time until the task deadline, the critical number of dependency tables, and the critical number of dependent tasks from the data management database; Based on the number of test steps and the critical number of test steps, the number of conditional branches and the critical number of conditional branches, the remaining time until the task deadline and the critical remaining time until the task deadline, and the request test task impact parameters, comprehensively analyze to obtain the priority evaluation value of each request test task for each test form. The priority evaluation value represents the quantitative data of the combined impact of the number of test steps, the number of conditional branches, and the remaining time until the task deadline on the urgency of the request test task.

5. The test data management method based on calling corresponding information from a database according to claim 1, characterized in that: The steps of classifying and managing each test form and each request test task based on the core degree index of each test form and the priority evaluation value of each request test task for each test form include: Classify each test form according to the core degree index of each test form to obtain each important test form and each unimportant test form. Each unimportant test form is divided into a first unimportant test form and a second unimportant test form; Sort each request test task for each test form from largest to smallest according to the priority evaluation value of each request test task for each test form to obtain the first sorting of the request test tasks for each test form; Process the first sorting of the request test tasks for each test form according to the type of each request test task to obtain the second sorting of the request test tasks for each test form; Manage each request test task according to the second sorting of the request test tasks for each test form.

6. The test data management method for calling corresponding information based on a database according to claim 5, wherein: The steps of processing the first sorting of the request test tasks for each test form according to the type of each request test task to obtain the second sorting of the request test tasks for each test form include: The type of the request test task includes a view request task and a modification request task; Obtain the task time data of each view request task for each test form. The task time data includes the task prediction time and the task waiting time; Obtain the critical task prediction time, the critical task waiting time, and the critical priority evaluation value from the data management database. Based on the task time data of each view request task for each test form and the priority evaluation value of each view request task for each test form, comprehensively analyze to obtain the priority degree evaluation value of each view request task for each test form. The priority degree evaluation value represents the quantitative data of the combined impact of the task prediction time, the task waiting time, and the priority evaluation value on the execution order of the view request task; Process the first sorting of the request test tasks for each test form according to the priority degree evaluation value of each view request task for each test form to obtain the second sorting of the request test tasks for each test form.

7. The test data management method based on database call of corresponding information according to claim 6, characterized in that: The steps of processing the first sorting of the request test tasks for each test form according to the priority degree evaluation value of each view request task for each test form to obtain the second sorting of the request test tasks for each test form include: Obtain the priority degree evaluation threshold from the data management database; Compare the priority evaluation value of each viewing request task in each test form with the priority evaluation threshold. If the priority evaluation value of a viewing request task in a certain test form is greater than or equal to the priority evaluation threshold, move the order of this viewing request task to the previous viewing request sorting. If the priority evaluation value of a viewing request task in a certain test form is less than the priority evaluation threshold, no additional operation is performed; Mark the sorted request test tasks of each processed test form as the second sorting of the request test tasks of each test form.

8. The test data management method based on database call for corresponding information according to claim 5, wherein: The step of managing each request test task according to the second sorting of the request test tasks of each test form includes: Manage each request test task of each important test form according to the second sorting of the request test tasks of each important test form, and evaluate and feedback the status of each important test form after the management operation; Manage each request test task of each non-important test form according to the second sorting of the request test tasks of each non-important test form and the database status indicators; The management operation includes backup, flow limiting and queuing.

9. The test data management method based on database call for corresponding information according to claim 1, characterized in that: The step of monitoring the database status data of the specified database at the current time monitoring point to obtain the database status indicators and judging whether to issue an abnormal status warning based on the database status indicators at the current time monitoring point includes: The database status data includes the task table ratio and the total request test task processing time. The task table ratio represents the ratio of the number of request test tasks to the number of test forms; Obtain the critical task table ratio, the critical total request test task processing time and the database status indicator threshold from the data management database; Comprehensively analyze the ratio of the task table ratio to the critical task table ratio and the ratio of the total request test task processing time to the average value of the critical total request test task processing time to obtain the database status indicator. The database status indicator represents the quantitative data of the combined influence of the task table ratio and the total request test task processing time on the database status; Compare the database status indicator with the database status indicator threshold. If the database status indicator is greater than or equal to the database status indicator threshold, enter the data processing stage. If the database status indicator is less than the database status indicator threshold, issue an abnormal status warning.

10. A test data management system that calls corresponding information based on a database, applying the test data management method based on calling corresponding information based on a database as described in any one of claims 1-9, characterized in that: It includes a task classification module, a stage judgment module, a data processing module, a database monitoring module and a data management database; Among them, the task classification module is used to obtain each request test task and each request test task type of the specified database at the current time monitoring point in real time, and classify based on the test forms of each request test task at the current time monitoring point to obtain the request test tasks of each test form at the current time monitoring point; The stage judgment module is used to monitor the core characteristic parameters of each test form of the specified database in real time to obtain the core degree indicators of each test form, and judge whether each test form enters the data processing stage according to the number of request test tasks of each test form and the core degree indicators of each test form at the current time monitoring point; The data processing module is used to obtain in real time the priority factor data and the influencing parameters of each requested test task for each test table in the specified database to obtain the priority evaluation value of each requested test task for each test table, and at the same time classify and manage each test table and each requested test task based on the core degree index of each test table and the priority evaluation value of each requested test task for each test table; The database monitoring module is used to monitor the database status data of the specified database at the current time monitoring point to obtain the database status index, and judge whether to issue an abnormal status warning based on the database status index at the current time monitoring point.

Images