WO2022134363A1

WO2022134363A1 - Service report integration method and apparatus, device, and storage medium

Info

Publication number: WO2022134363A1
Application number: PCT/CN2021/084534
Authority: WO
Inventors: 王雍富; 贺春艳; 孙燕; 梁丽娜
Original assignee: 平安科技（深圳）有限公司
Priority date: 2020-12-24
Filing date: 2021-03-31
Publication date: 2022-06-30
Also published as: CN112667630B; CN112667630A

Abstract

A service report integration method and apparatus, a device, and a storage medium, which relate to the field of artificial intelligence. The method comprises: searching source databases that store service reports (S1); reading database table information in each source database, and generating a data dictionary according to each piece of the database table information (S2); according to the data dictionary, generating an acquisition script respectively corresponding to each service report, and according to each acquisition script, acquiring a task script for operating each service report (S3); recursively parsing the task scripts so as to acquire coupling relationships between the service reports (S4); and acquiring the service reports in each source database, and storing the service reports and the coupling relationships between the service reports to obtain a target database (S5). The beneficial effect is that the target database not only has all of the service reports in each source database, but also retains the coupling relationships between the service reports in the source databases.

Description

Method, device, device and storage medium for integrating business reports

This application claims the priority of the Chinese patent application with the application number 2020115494160 and the invention titled "Method, Apparatus, Equipment and Storage Medium for Integrating Business Reports" filed with the China Patent Office on December 24, 2020, the entire contents of which are by reference Incorporated in this application.

technical field

The present application relates to the field of data processing, and in particular, to a method, apparatus, device and storage medium for integrating business reports.

Background technique

A database, also known as a data management system, is a collection of data in which the processed data is stored together in a certain way, allowing multiple users to share and reducing redundancy as much as possible. The inventor realized that when saving business data, due to the limitations of the database or when developers develop different functions, the same type of business data may be stored in multiple databases respectively, and each database needs to be traversed during retrieval. This makes the retrieval process very cumbersome. Even some business data will be saved repeatedly, wasting storage space, so a method of integrating business reports is urgently needed.

technical problem

The main purpose of the present application is to provide a method, device, device and storage medium for integrating business reports, which aims to solve the problem that each database needs to be traversed during retrieval, which makes the retrieval process very cumbersome.

technical solutions

This application provides a method for integrating business reports, including:

Search the source database where business reports are stored;

Reading the library table information in each of the source databases, and generating a data dictionary according to each of the library table information, wherein the data dictionary records the location information of each of the business reports;

Generate respective acquisition scripts corresponding to each business report according to the data dictionary, and acquire a task script for operating each of the business reports according to each of the acquisition scripts;

Recursively analyze each of the task scripts to obtain the coupling relationship between each of the business reports;

Acquire the business reports in each source database, and store the business reports and the coupling relationship between the business reports in the target database.

The application also provides a device for integrating business reports, including:

The search module is used to search the source database that saves the business report;

a reading module, configured to read the library table information in each of the source databases, and generate a data dictionary according to each of the library table information, wherein the data dictionary records the location information of each of the business reports;

a generating module, configured to generate respective acquisition scripts corresponding to each business report according to the data dictionary, and obtain a task script for operating each of the business reports according to each of the acquisition scripts;

an acquisition module, used to recursively parse each of the task scripts to acquire the coupling relationship between each of the business reports;

The storage module is used for acquiring the business reports in each source database, and storing the business reports and the coupling relationship between the business reports to obtain the target database.

The present application also provides a computer device, including a memory and a processor, wherein the memory stores computer-readable instructions, and when the computer-readable instructions are executed by the processor, the processor executes the integrated business report The steps of the method:

Search the source database where business reports are stored;

The present application also provides a storage medium storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors perform the steps of the computer device:

Search the source database where business reports are stored;

beneficial effect

The corresponding task script is obtained by setting the obtaining script, and the coupling relationship between the business reports is parsed, and the business reports in each source database and the coupling relationship between the business reports are obtained and saved. The target database contains all the business reports in each source database, and also retains the coupling relationship between each business report in the source database, so that when relevant personnel search in the target database, they do not need to traverse multiple source databases, and can get with traversing multiple source databases for retrieval results.

Description of drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the application and together with the description serve to explain the principles of the application.

FIG. 1 is a schematic flowchart of a method for integrating business reports according to an embodiment of the present application;

2 is a schematic structural block diagram of an apparatus for integrating business reports according to an embodiment of the present application;

FIG. 3 is a schematic structural block diagram of a computer device according to an embodiment of the present application.

Best Mode for Carrying Out the Application

1, the present application proposes a method for integrating business reports, including:

S1: Search the source database where business reports are stored;

S2: Read the library table information in each of the source databases, and generate a data dictionary according to each of the library table information; wherein the data dictionary records the location information of each of the business reports;

S3: Generate respective acquisition scripts corresponding to each business report according to the data dictionary, and obtain a task script for operating each of the business reports according to each of the acquisition scripts;

S4: recursively parse each of the task scripts to obtain the coupling relationship between each of the business reports;

S5: Acquire the business reports in each source database, and store the business reports and the coupling relationship between the business reports in the target database.

As described in the above step S1, the source database storing the business report is searched. The way to obtain it is to first obtain the header information of the required business report, and then set the corresponding automated script according to the header information to read the library table information in each initial database. It should be understood that the header information generally refers to the business report. For the header of the report, the set automation script can be only the header information, or can include the synonymous information of the header information, so that the obtained business data report is more comprehensive. The settings of the automation script can be set by themselves according to the header information, or can be set by the developer.

As described in the above step S2, the library table information in each of the source databases is read, and a data dictionary is generated according to each of the library table information. The reading method may be to read the library table information in the initial database according to the automated script, filter out the source database with business reports, and obtain the library table information in the source database, where the library table information is the directory of different data tables. The database generally establishes the database table information to facilitate the query of the corresponding data. If there is no database table information, the database table information can be obtained by traversing, and then the corresponding data dictionary is generated according to the database table information. The location of the database where each business report is stored, and the location information in the database. In some embodiments, a certain business form may exist in two source databases at the same time. Therefore, before establishing a data dictionary according to the inventory information of each source database, a duplicate check can be performed, that is, it can be detected whether there is a business report with the same title. If so, you can obtain only one of the business reports to avoid the problem of data duplication.

As described in the above step S3, an acquisition script corresponding to each business report is generated according to the data dictionary, and a task script for operating each of the business reports is acquired according to each of the acquisition scripts. The task script can exist in the source database or in a third-party channel such as a third client, and can be obtained by obtaining the script at the set location. A plurality of corresponding acquisition scripts are set according to the data dictionary, wherein, in addition to acquiring the corresponding business report, the acquisition script should also acquire a task script related to the business report. Among them, each task script is a task script for operating the business report, that is, by obtaining the business report for operating the business report, the use of the business report can be known, and the situation of each business report being called in the source database can be known, that is, the same as that of the source database. Coupling relationship of other business reports.

As described in the above step S4, each of the task scripts is recursively parsed to obtain the coupling relationship between each of the business reports. Since the execution process of the task script may be very complicated, it may be difficult to obtain the final result by direct analysis. Therefore, the execution steps of each task script can be obtained, and the final result can be obtained by reverse recursion, that is, the recursion of each task script. Parse.

As described in step S5 above, the business reports in each source database are acquired, and the business reports and the coupling relationship between the business reports are stored to obtain the target database. The business reports obtained from each source database and the coupling relationship between the parsed business reports are stored. Therefore, the obtained target database not only contains all the business reports in each source database, but also retains the coupling relationship between each business report in the source database, so that the relevant personnel do not need to traverse multiple source databases when searching in the target database. It is also possible to obtain and traverse the retrieval results in multiple source databases.

In one embodiment, the step S4 of recursively analyzing each of the task scripts to obtain the coupling relationship between each of the business reports includes:

S401: Obtain one or more SQL statements involved in the task script;

S402: Detect the business report executed in each of the SQL statements, and whether the SQL statement is executable;

S403: Perform executable processing on the non-executable SQL statement to obtain an executable target task script;

S404: Parse the target task script, and build a work stack based on the parsed content; wherein, the work stack includes each step executed by the target task script;

S405: Recursively analyze the calculation functions in each step of the work stack to obtain the coupling relationship between the business reports.

As described in the above steps S401-S405, recursive parsing of the task script is implemented. The task script includes at least one SQL (Structured Query Language, Structured Query Language) statement, and the corresponding task in the task script has been completed. In this application, the coupling relationship between various business reports is mainly obtained, that is, in this task script The number of times the business report is called, as well as the order in which it is called, the degree of relevance, etc. Specifically, the business report executed in the SQL statement is first detected (it should be noted that SQL does not contain business reports, but only includes processing, calling and other execution commands for each business report). Since the obtained SQL statement It often contains instructions, special functions, custom functions, dynamic parameter transfer, etc. to make SQL statements unexecutable. Therefore, it is necessary to change the unexecutable statement into an executable statement by replacing the function or parameter constancy. The above operations can be set by setting the corresponding The program is automatically completed, but if you encounter an unexecutable statement that cannot be processed automatically, you can extract the unexecutable statement separately, and the corresponding technician will perform the executable processing on the unexecutable statement (usually also through replacement). functions, or operations such as parameter constancy for processing). Therefore, all the SQL statements in the task script can be executed to obtain the target task script. Parse the target task script and establish a work stack, wherein the way of establishing the work stack can be by establishing an abstract syntax tree, combining the conditional judgment in the target task script to set the nodes of the abstract syntax tree, and then according to the execution steps of the target task script, The result of the reverse derivation of the abstract syntax tree, that is, the order in which each business report is called, in which, through the above recursive calculation method, a large and complex problem can be transformed into a smaller problem similar to the original problem. Solve, simplify the operation difficulty.

In one embodiment, the step S404 of parsing the target task script and establishing a work stack includes:

S4041: Convert the target task script into an ASTNode abstract syntax tree;

S4042: Traverse the depth of the ASTNode abstract syntax tree, and parse out the output input table and the condition judgment statement of the ASTNode abstract syntax tree;

S4043: Set the execution plan of the ASTNode abstract syntax tree according to the output and input table and the conditional judgment statement, so as to obtain the work stack.

As described in the above steps S4041-S4043, the resume of the work stack is realized. The target task script is first converted into the ASTNode abstract syntax tree. The ASTNode abstract syntax tree does not depend on the specific grammar and does not depend on the details of the language, which can solve the redundant components brought by the grammar analysis. The redundant components may be It will adversely affect the subsequent stages. The target task script is a step that is judged by conditions and executed in sequence. If the equivalent exchange of grammars is performed before, it may affect the subsequent steps. Therefore, using the ASTNode abstract syntax tree can solve the technical problems brought by the grammar. Specifically, the target task script is first converted into an ASTNode abstract syntax tree. The conversion method can be to set the nodes of the tree according to the conditional judgment in the target task script, and set the branches of the tree according to the relationship between the various steps, thereby Get the corresponding ASTNode abstract syntax tree. Traverse the depth of the ASTNode abstract syntax tree, and parse out the output and input table and conditional judgment statement of the ASTNode abstract syntax tree, where the depth refers to the complexity of the branches, that is, the number of steps to be performed, and then parse out which The output input table and conditional judgment statement. Then set the corresponding execution plan, that is, first calculate the result that can be calculated, and then return the calculated result to the previous node to continue the calculation, and use the above calculation method to obtain the corresponding execution plan, so as to obtain the work. stack.

In one embodiment, the step S5 of storing the business reports and the coupling relationship between the business reports in the target database includes:

S501: Obtain table information of each of the business reports;

S502: Sort out hierarchical rules according to the table information;

S503: Divide each of the business reports into different levels according to the level rule;

S504: Perform cluster analysis on the business reports of the same level, and give the same labels to the business reports of the same class according to the analysis results;

S505: Classify and store each of the business reports in the target database according to the labels of each of the business reports, and store the coupling relationship between the business reports.

As described in the above steps S501-S505, the classified storage of the business report is realized. That is, first obtain the table information of the business report (generally only the header), and after obtaining the table information of each business report, you can sort out the corresponding hierarchical rules. The way of sorting is to set the correspondence between the table information and the level in advance. relationship, and then obtain the hierarchical rules that adapt to all business tables according to the table information, that is, some business reports may be derived from the content of other business reports, but this is generally recorded in the header, so according to the header You can divide the levels of each business report, divide each business report into different levels, and then perform cluster analysis. The clustering method can be text clustering algorithm (clustering algorithm based on division, clustering algorithm, density-based clustering algorithm, grid-based clustering algorithm, model-based clustering algorithm, and fuzzy-based clustering algorithm), and then assign the same label to the business report of the same type. Subsequently, each business report and the coupling relationship between the business reports are saved in the target database according to the corresponding tags.

S511: Obtain script information of the task script; wherein, the script information at least includes a script path, an operation type, and an associated business report involved;

S512: Analyze the script information to obtain the occurrence times and vertex information of each of the associated business reports;

S513: Set a corresponding weight for each of the associated business reports according to the number of occurrences of each of the associated business reports;

S514: Set the vertex information as the primary key of the associated service report, set the weight as the vertex attribute of the associated service report to save, and save the coupling relationship between each of the service reports.

As described in the above steps, the saving of each associated business report is realized. That is, in the target database, each business report is a vertex, and the data content it contains is vertex attribute. The relationship between vertices and vertices is the coupling relationship between business reports, and the vertex attribute is the basis for the importance of the business report, that is, in the later retrieval process, if the vertex attribute is good, you can first The vertex is traversed. Specifically, the script information of the task script is obtained, wherein the script information includes the corresponding script path, the operation type, the related business report involved, and even the data source in the script data. According to the script information, the corresponding association can be obtained. The number of occurrences of business reports and related business reports, and the vertex information (that is, the information of the business report, including the content in the business report and the coupling relationship with other business reports, etc.), set the weight for the related business report according to the number of occurrences of the related business report , so as to facilitate subsequent retrieval, it should be understood that the more times the associated business report appears, the greater its weight, the less the number of times the associated business report appears, the smaller its weight, and then set the primary key for the associated business report, where the primary key For the representation of the associated business report, it can be data encrypted with script information, or directly use the script information as the primary key, and then set the weight as the vertex attribute to save, thus realizing the preservation of each business report.

In one embodiment, after the step S5 of acquiring the business reports in each source database and storing the business reports and the coupling relationship between the business reports in the target database, the method further includes:

S601: Detect intermediate temporary tables in each of the business reports according to a set detection rule;

S602: Obtain a first report that has a blood relationship with the intermediate temporary table, and a second report that has an associated relationship with the intermediate temporary table; the first report and the second report are both the business report;

S603: According to the coupling relationship between the intermediate temporary table and the second report, directly establish a coupling relationship between the first report and the second report;

S604: Delete the intermediate temporary table to establish a knowledge graph of the target database.

As described in the above steps S601-S604, the optimization of the target database is realized. That is, the intermediate temporary tables in each of the business reports are detected according to the set detection rules. Generally speaking, when each business report is generated, the generated time will be used as the header, so the set detection rule can be set as the detection header, that is, according to the information in the header, you can know whether the business report is The intermediate temporary table, and then obtain the first report that has a blood relationship with the intermediate temporary table and the second report that has an associated relationship. The relationship of the table to other business reports. According to the coupling relationship between the intermediate temporary table and the second report, the coupling relationship between the first report and the second report is directly established. Specifically, the label of the intermediate temporary table can be marked as False, and If other business reports are recorded as True, the graph relationships in the target database include four types of False-True, False-False, True-False, and True-True. The coupling relationship between True-True does not need to be processed. False-True, False-False, True-False, perform Pregel graph iterative calculation, every time True-n Talse-tures are encountered, the head-to-tail relationship is stored in the vertex attribute set. Delete the False vertices, and directly establish the relationship between True and True according to the attribute set. This simplifies the knowledge graph of the target database, enables users to extract valuable data more clearly and intuitively, and facilitates the maintenance of the target database.

2, the present application also provides a device for integrating business reports, including:

The search module 10 is used to search the source database that saves the business report;

The reading module 20 is used to read the library table information in each of the source databases, and generate a data dictionary according to each of the library table information, wherein the data dictionary records the location information of each of the business reports;

The generating module 30 is configured to generate respectively corresponding acquisition scripts of each business report according to the data dictionary, and acquire a task script for operating each of the business reports according to each of the acquisition scripts;

an acquisition module 40, used for recursively analyzing each of the task scripts to acquire the coupling relationship between each of the business reports;

The storage module 50 is configured to acquire the business reports in each source database, and store the business reports and the coupling relationship between the business reports in the target database.

In one embodiment, the obtaining module 40 includes:

Get the submodule, which is used to get one or more SQL statements involved in the task script;

A detection submodule for detecting the business report executed in each of the SQL statements, and whether the SQL statements are executable;

A processing submodule, for performing executable processing on the unexecutable SQL statement to obtain an executable processing target task script;

establishing a submodule for parsing the target task script, and establishing a work stack based on the parsed content; wherein the work stack includes each step executed by the target task script;

The parsing submodule is used for recursively parsing the calculation functions in each step of the work stack to obtain the coupling relationship between the business reports.

In one embodiment, a sub-module is established, including:

A conversion unit for converting the target task script into an ASTNode abstract syntax tree;

A traversing unit, used to traverse the depth of the ASTNode abstract syntax tree, and parse out the output input table and the condition judgment statement of the ASTNode abstract syntax tree;

A setting unit, configured to set the execution plan of the ASTNode abstract syntax tree according to the output and input table and the conditional judgment statement, so as to obtain the work stack.

In one embodiment, the storage module 50 includes:

a form information acquisition sub-module, used to acquire the form information of each of the business reports;

a sorting sub-module for sorting out hierarchical rules according to the table information;

dividing sub-modules for dividing each of the business reports into different levels according to the level rules;

A clustering submodule for performing cluster analysis on the business reports of the same level, and assigning the same labels to the business reports of the same class according to the analysis results;

The storage sub-module is configured to classify and store each of the business reports in the target database according to the labels of each of the business reports, and store the coupling relationship between the business reports.

In one embodiment, the storage module 50 further includes:

a script information acquisition sub-module, used for acquiring script information of the task script; wherein the script information at least includes a script path, an operation type and a related business report;

a script information analysis sub-module for analyzing the script information to obtain the occurrence times and vertex information of each of the associated business reports;

A weight setting submodule, configured to set a corresponding weight for each of the associated business reports according to the number of occurrences of each of the associated business reports;

The primary key setting submodule is used to set the vertex information as the primary key of the associated business report, and to set the weight as the vertex attribute of the associated business report to save, and to save the relationship between each of the business reports. coupling relationship.

In one embodiment, the device for integrating business reports further includes:

an intermediate temporary table detection module, used for detecting the intermediate temporary table in each of the business reports according to the set detection rules;

The first report obtaining module is used to obtain a first report that has a blood relationship with the intermediate temporary table, and a second report that has an associated relationship with the intermediate temporary table; the first report and the second report are for said business statement;

a coupling relationship establishing module, configured to directly establish a coupling relationship between the first statement and the second statement according to the coupling relationship between the intermediate temporary table and the second statement;

A deletion module is used to delete the intermediate temporary table to establish a knowledge graph of the target database.

The beneficial effects of the present application are as follows: the corresponding task script is acquired by setting the acquisition script, and the coupling relationship between the business reports is parsed, and the business reports in each source database and the coupling relationship between the business reports are acquired, saved and stored. The target database contains all the business reports in each source database, and also retains the coupling relationship between each business report in the source database, so that when the relevant personnel search in the target database, they do not need to traverse multiple source databases, and can get with traversing multiple source databases for retrieval results.

Referring to FIG. 3 , an embodiment of the present application further provides a computer device. The computer device may be a server, and its internal structure may be as shown in FIG. 3 . The computer device includes a processor, memory, a network interface and a database connected by a system bus. Among them, the processor of the computer design is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium, an internal memory. The nonvolatile storage medium stores an operating system, a computer program, and a database. The memory provides an environment for the execution of the operating system and computer programs in the non-volatile storage medium. The database of the computer equipment is used to store various business reports and the like. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, the method for integrating business reports described in any of the foregoing embodiments can be implemented.

Claims

A method of consolidating business reporting, which includes:

Search the source database where business reports are stored;

Reading the library table information in each of the source databases, and generating a data dictionary according to each of the library table information, wherein the data dictionary records the location information of each of the business reports;

Generate respective acquisition scripts corresponding to each business report according to the data dictionary, and acquire a task script for operating each of the business reports according to each of the acquisition scripts;

Recursively analyze each of the task scripts to obtain the coupling relationship between each of the business reports;

Acquire the business reports in each source database, and store the business reports and the coupling relationship between the business reports in the target database.
The method for integrating business reports according to claim 1, wherein the step of recursively analyzing each of the task scripts to obtain the coupling relationship between the business reports comprises:

Get one or more SQL statements involved in the task script;

Detecting the business report executed in each of the SQL statements, and whether the SQL statements are executable;

Performing executable processing on the non-executable SQL statement to obtain an executable processing target task script;

Parse the target task script, and build a work stack based on the parsed content; wherein, the work stack includes each step executed by the target task script;

The calculation functions in each step of the work stack are recursively analyzed to obtain the coupling relationship between the business reports.
The method for integrating business reports according to claim 1, wherein the step of storing each of the business reports and the coupling relationship between the business reports in a target database comprises:

Obtain the form information of each of the described business reports;

Sort out hierarchical rules according to the table information;

Divide each of the business reports into different levels according to the level rules;

Perform cluster analysis on the business reports of the same level, and assign the same labels to the business reports of the same type according to the analysis results;

According to the labels of the business reports, the business reports are classified and stored in the target database, and the coupling relationship between the business reports is stored.
The method for integrating business reports according to claim 1, wherein the step of storing each of the business reports and the coupling relationship between the business reports in a target database further comprises:

Acquiring script information of the task script; wherein the script information at least includes a script path, an operation type, and an associated business report involved;

Analyze the script information to obtain the occurrence times and vertex information of each of the associated business reports;

Setting a corresponding weight for each of the associated business reports according to the number of occurrences of each of the associated business reports;

The vertex information is set as the primary key of the associated business report, and the weight is set as the vertex attribute of the associated business report for saving, and the coupling relationship between the business reports is saved.
The method for integrating business reports according to claim 1, wherein the obtaining the business reports in each source database, and storing the business reports and the coupling relationship between the business reports in the target database After the steps, also include:

Detect intermediate temporary tables in each of the business reports according to the set detection rules;

Obtain a first report that has a blood relationship with the intermediate temporary table, and a second report that has an associated relationship with the intermediate temporary table; the first report and the second report are both the business report;

According to the coupling relationship between the intermediate temporary table and the second report, the coupling relationship between the first report and the second report is directly established;

The intermediate temporary table is deleted to establish a knowledge graph of the target database.
The method for integrating business reports according to claim 2, wherein the step of parsing the target task script and establishing a work stack comprises:

The target task script is converted into an ASTNode abstract syntax tree;

Traverse the depth of the ASTNode abstract syntax tree, and parse out the output input table and the conditional judgment statement of the ASTNode abstract syntax tree;

The execution plan of the ASTNode abstract syntax tree is set according to the input and output table and the conditional judgment statement, so as to obtain the work stack.
A device for integrating business reports, comprising:

The search module is used to search the source database that saves the business report;

a reading module, configured to read the library table information in each of the source databases, and generate a data dictionary according to each of the library table information, wherein the data dictionary records the location information of each of the business reports;

A generating module, configured to generate respective acquisition scripts corresponding to each business report according to the data dictionary, and obtain a task script for operating each of the business reports according to each of the acquisition scripts

an acquisition module, used to recursively parse each of the task scripts to acquire the coupling relationship between each of the business reports;

The storage module is used for acquiring the business reports in each source database, and storing the business reports and the coupling relationship between the business reports in the target database.
A computer device includes a memory and a processor, the memory stores computer-readable instructions, and when the computer-readable instructions are executed by the processor, the processor is made to perform the steps of the method for integrating business reports:

Search the source database where business reports are stored;

Reading the library table information in each of the source databases, and generating a data dictionary according to each of the library table information, wherein the data dictionary records the location information of each of the business reports;

Generate respective acquisition scripts corresponding to each business report according to the data dictionary, and acquire a task script for operating each of the business reports according to each of the acquisition scripts;

Recursively analyze each of the task scripts to obtain the coupling relationship between each of the business reports;

Acquire the business reports in each source database, and store the business reports and the coupling relationship between the business reports in the target database.
The computer device according to claim 8, wherein the step of recursively parsing each of the task scripts to obtain a coupling relationship between each of the business reports comprises:

Get one or more SQL statements involved in the task script;

Detecting the business report executed in each of the SQL statements, and whether the SQL statements are executable;

Performing executable processing on the non-executable SQL statement to obtain an executable processing target task script;

Parse the target task script, and build a work stack based on the parsed content; wherein, the work stack includes each step executed by the target task script;

The calculation functions in each step of the work stack are recursively analyzed to obtain the coupling relationship between the business reports.
The computer device according to claim 8, wherein the step of storing each of the business reports and the coupling relationship between the business reports in the target database comprises:

Obtain the form information of each of the described business reports;

Sort out hierarchical rules according to the table information;

Divide each of the business reports into different levels according to the level rules;

Perform cluster analysis on the business reports of the same level, and assign the same labels to the business reports of the same type according to the analysis results;

According to the labels of the business reports, the business reports are classified and stored in the target database, and the coupling relationship between the business reports is stored.
The computer device according to claim 8, wherein the step of storing each of the business reports and the coupling relationship between each of the business reports in the target database further comprises:

Acquire script information of the task script; wherein, the script information at least includes a script path, an operation type, and an associated business report involved;

Analyze the script information to obtain the occurrence times and vertex information of each of the associated business reports;

Setting a corresponding weight for each of the associated business reports according to the number of occurrences of each of the associated business reports;

The vertex information is set as the primary key of the associated business report, and the weight is set as the vertex attribute of the associated business report for saving, and the coupling relationship between the business reports is saved.
The computer device according to claim 8, wherein after the step of acquiring the business reports in each source database and storing the business reports and the coupling relationship between the business reports in the target database ,Also includes:

Detect intermediate temporary tables in each of the business reports according to the set detection rules;

Obtain a first report that has a blood relationship with the intermediate temporary table, and a second report that has an associated relationship with the intermediate temporary table; the first report and the second report are both the business report;

According to the coupling relationship between the intermediate temporary table and the second report, the coupling relationship between the first report and the second report is directly established;

The intermediate temporary table is deleted to establish a knowledge graph of the target database.
The computer device of claim 9, wherein the step of parsing the target task script and establishing a work stack comprises:

The target task script is converted into an ASTNode abstract syntax tree;

Traverse the depth of the ASTNode abstract syntax tree, and parse out the output input table and the conditional judgment statement of the ASTNode abstract syntax tree;

The execution plan of the ASTNode abstract syntax tree is set according to the input and output table and the conditional judgment statement, so as to obtain the work stack.
A storage medium storing computer-readable instructions that, when executed by one or more processors, cause the one or more processors to perform the steps of the computer device:

Search the source database where business reports are stored;

Reading the library table information in each of the source databases, and generating a data dictionary according to each of the library table information, wherein the data dictionary records the location information of each of the business reports;

Generate respective acquisition scripts corresponding to each business report according to the data dictionary, and acquire a task script for operating each of the business reports according to each of the acquisition scripts;

Recursively analyze each of the task scripts to obtain the coupling relationship between each of the business reports;

Acquire the business reports in each source database, and store the business reports and the coupling relationship between the business reports in the target database.
The storage medium according to claim 14, wherein the step of recursively parsing each of the task scripts to obtain a coupling relationship between each of the business reports comprises:

Get one or more SQL statements involved in the task script;

Detecting the business report executed in each of the SQL statements, and whether the SQL statements are executable;

Performing executable processing on the non-executable SQL statement to obtain an executable processing target task script;

Parse the target task script, and build a work stack based on the parsed content; wherein, the work stack includes each step executed by the target task script;

The calculation functions in each step of the work stack are recursively analyzed to obtain the coupling relationship between the business reports.
The storage medium according to claim 14, wherein the step of storing the business reports and the coupling relationship between the business reports in the target database comprises:

Obtain the form information of each of the described business reports;

Sort out hierarchical rules according to the table information;

Divide each of the business reports into different levels according to the level rules;

Perform cluster analysis on the business reports of the same level, and assign the same labels to the business reports of the same type according to the analysis results;

According to the labels of the business reports, the business reports are classified and stored in the target database, and the coupling relationship between the business reports is stored.
The storage medium according to claim 14, wherein the step of storing the business reports and the coupling relationship between the business reports in the target database further comprises:

Acquire script information of the task script; wherein, the script information at least includes a script path, an operation type, and an associated business report involved;

Analyze the script information to obtain the occurrence times and vertex information of each of the associated business reports;

Setting a corresponding weight for each of the associated business reports according to the number of occurrences of each of the associated business reports;

The vertex information is set as the primary key of the associated business report, and the weight is set as the vertex attribute of the associated business report for saving, and the coupling relationship between the business reports is saved.
The storage medium according to claim 14, wherein after the step of acquiring the business reports in each source database, and storing the business reports and the coupling relationship between the business reports in the target database ,Also includes:

Detect intermediate temporary tables in each of the business reports according to the set detection rules;

Obtain a first report that has a blood relationship with the intermediate temporary table, and a second report that has an associated relationship with the intermediate temporary table; the first report and the second report are both the business report;

According to the coupling relationship between the intermediate temporary table and the second report, the coupling relationship between the first report and the second report is directly established;

The intermediate temporary table is deleted to establish a knowledge graph of the target database.
The storage medium of claim 15, wherein the step of parsing the target task script and establishing a work stack comprises:

The target task script is converted into an ASTNode abstract syntax tree;

Traverse the depth of the ASTNode abstract syntax tree, and parse out the output input table and the conditional judgment statement of the ASTNode abstract syntax tree;

The execution plan of the ASTNode abstract syntax tree is set according to the input and output table and the conditional judgment statement, so as to obtain the work stack.