Report generation method and system

By extracting the parameters of report generation requests, orchestrating task dependencies and generating multi-fork trees, the problem of inefficiency in generating multiple reports in the existing technology is solved, and efficient multi-report generation and resource conservation are achieved.

CN119248856BActive Publication Date: 2025-03-11HUNDSUN TECH
View PDF 3 Cites 0 Cited by

Patent Information

Application Number
CN202411705026.6
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-11-26
Publication Date
2025-03-11
Estimated Expiration
2044-11-26

AI Technical Summary

Technical Problem

The prior art is inefficient when generating multiple reports and consumes a lot of computing resources, which cannot effectively solve the user's need to generate multiple reports.

Method used

By responding to report generation requests, report generation parameters are determined, and multiple report tasks are extracted from the task database of the target business. Orchestrate tasks according to the preset task dependency graph, obtain target multi-fork trees, and generate multiple target reports by traversing multi-fork trees.

Benefits of technology

It improves the efficiency of multi-report generation, avoids the computing resources consumed by repeated tasks, and improves the user's report usage experience.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119248856B_ABST
    Figure CN119248856B_ABST
Patent Text Reader

Abstract

The embodiments of the present specification provide a report generation method and system, wherein the report generation method comprises: determining report generation parameters in response to a report generation request submitted for a target business; when the report generation request is a multi-report generation request, extracting multiple report tasks from a task database of the target business according to the report generation parameters; determining task dependencies corresponding to the multiple report tasks according to a preset task dependency graph, and arranging the multiple report tasks according to the task dependency to obtain a target multi-branch tree; traversing the target multi-branch tree, and generating at least two target reports corresponding to the report generation request according to the traversal result.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The embodiments of the present specification relate to the field of data processing technology, and in particular to a report generation method and system. Background Art

[0002] With the development of computer and Internet technology, report generation technology has been applied in more and more scenarios, and report generation has become more convenient and rapid. Users only need to perform simple operations to generate target reports that meet the needs of users. In the prior art, most systems will set up the orchestration logic for report tasks in advance to ensure that each report has its unique task architecture, that is, a task tree composed of multiple independent and orderly tasks. These task trees serve as blueprints for report generation, define various processing steps, and enable the generation process of each report to run as an autonomous execution link. Although the above scheme can support users to customize any type of report, when users have the need to generate multiple reports, they can only do so by generating reports one by one, which makes the report generation efficiency extremely low, and the computing resources occupied by generating reports one by one are also relatively large. Therefore, an effective solution is urgently needed to solve the above problems. Summary of the invention

[0003] In view of this, an embodiment of this specification provides a report generation method. One or more embodiments of this specification also relate to a report generation system, a report generation device, a computing device, a computer-readable storage medium and a computer program product to solve the technical defects existing in the prior art.

[0004] According to a first aspect of an embodiment of this specification, a report generation method is provided, including:

[0005] determining report generation parameters in response to a report generation request submitted for a target business;

[0006] In the case where the report generation request is a multi-report generation request, extracting multiple report tasks from the task database of the target business according to the report generation parameters;

[0007] Determine the task dependencies corresponding to the multiple report tasks according to a preset task dependency graph, and arrange the multiple report tasks according to the task dependency to obtain a target multi-branch tree;

[0008] The target multi-branch tree is traversed, and at least two target reports corresponding to the report generation request are generated according to the traversal result.

[0009] According to a second aspect of an embodiment of this specification, a report generation system is provided, including a server and a client, including:

[0010] The client is used to receive a selection instruction submitted by a user for a target business, construct a report generation request according to the selection instruction, and send the report generation request to the server;

[0011] The server is used to determine report generation parameters according to the report generation request; if the report generation request is a multi-report generation request, extract multiple report tasks from the task database of the target business according to the report generation parameters; determine the task dependency relationships corresponding to the multiple report tasks according to a preset task dependency graph, and arrange the multiple report tasks according to the task dependency relationships to obtain a target multi-branch tree; traverse the target multi-branch tree, generate at least two target reports corresponding to the report generation request according to the traversal results, and send them to the client;

[0012] The client is used to display the at least two target reports to the user.

[0013] According to a third aspect of the embodiments of this specification, there is provided a report generating device, including:

[0014] a determination module configured to determine report generation parameters in response to a report generation request submitted for a target business;

[0015] An extraction module is configured to extract multiple report tasks from a task database of the target business according to the report generation parameters when the report generation request is a multiple report generation request;

[0016] An orchestration module is configured to determine the task dependencies corresponding to the multiple report tasks according to a preset task dependency graph, and to orchestrate the multiple report tasks according to the task dependency to obtain a target multi-branch tree;

[0017] The generating module is configured to traverse the target multi-branch tree and generate at least two target reports corresponding to the report generation request according to the traversal result.

[0018] According to a fourth aspect of an embodiment of this specification, a computing device is provided, including:

[0019] Memory and processor;

[0020] The memory is used to store computer executable instructions, and the processor is used to execute the computer executable instructions. When the computer executable instructions are executed by the processor, the steps of the above-mentioned report generation method are implemented.

[0021] According to a fifth aspect of the embodiments of this specification, a computer-readable storage medium is provided, which stores computer-executable instructions, and when the instructions are executed by a processor, the steps of the above-mentioned report generation method are implemented.

[0022] According to a sixth aspect of the embodiments of this specification, a computer program product is provided, including a computer program or instructions, which implement the steps of the above-mentioned report generation method when executed by a processor.

[0023] The report generation method provided in this embodiment can respond to the request to generate multiple reports quickly and efficiently, and reduce the consumption of computing resources. The report generation method can first determine the report generation parameters in response to the report generation request submitted for the target business; when the report generation request is a multiple report generation request, all report tasks associated with at least two reports to be generated can be directly extracted from the task database of the target business according to the report generation parameters; and then before the report generation, the report tasks can be divided without dividing them, but the task dependencies corresponding to the multiple report tasks can be directly determined according to the preset task dependency graph, and the multiple report tasks can be arranged according to the task dependency to obtain a target multi-branch tree; the hierarchical relationship and dependency relationship of all report tasks associated with at least two reports can be reflected through the target multi-branch tree, thereby avoiding the repeated execution of the same report task in each report generation stage, and realizing that only one of the same report tasks involved in at least two reports is retained in the multi-branch tree, and the target multi-branch tree can be traversed, and at least two target reports corresponding to the report generation request can be generated according to the traversal results. Thereby, the efficiency of multi-report generation can be effectively improved, and the computing resources consumed by repeated execution of tasks can be avoided, and the user report usage experience can be improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1 is a schematic diagram of a report generation method provided by an embodiment of this specification;

[0025] Figure 2 is a flow chart of a report generation method provided by an embodiment of this specification;

[0026] Figure 3 It is a schematic diagram of a multi-branch tree structure in a report generation method provided in one embodiment of this specification;

[0027] Figure 4 is a process flow chart of a report generation method provided by an embodiment of this specification;

[0028] Figure 5 It is a structural diagram of a report generation system provided by an embodiment of this specification;

[0029] Figure 6 It is a structural schematic diagram of a report generation device provided by an embodiment of this specification;

[0030] Figure 7It is a structural block diagram of a computing device provided by an embodiment of this specification. DETAILED DESCRIPTION

[0031] Many specific details are described in the following description to facilitate a full understanding of this specification. However, this specification can be implemented in many other ways than those described herein, and those skilled in the art can make similar generalizations without violating the connotation of this specification, so this specification is not limited to the specific implementation disclosed below.

[0032] The terms used in one or more embodiments of this specification are only for the purpose of describing specific embodiments, and are not intended to limit one or more embodiments of this specification. The singular forms of "a", "said" and "the" used in one or more embodiments of this specification and the appended claims are also intended to include plural forms, unless the context clearly indicates other meanings. It should also be understood that the term "and / or" used in one or more embodiments of this specification refers to and includes any or all possible combinations of one or more associated listed items.

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

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

[0035] In this specification, a report generation method is provided. This specification also relates to a report generation system, a report generation apparatus, a computing device, a computer-readable storage medium and a computer program product, which are described in detail one by one in the following embodiments.

[0036] See also Figure 1As shown in the schematic diagram, the report generation method provided by this embodiment can first determine the report generation parameters in response to the report generation request submitted for the target business in order to quickly and efficiently respond to the request to generate multiple reports and reduce the consumption of computing resources; when the report generation request is a multiple report generation request, all report tasks associated with at least two reports to be generated can be directly extracted from the task database of the target business according to the report generation parameters; and then before the report generation, the report tasks can be divided without dividing them, but the task dependencies corresponding to the multiple report tasks can be directly determined according to the preset task dependency graph, and the multiple report tasks can be arranged according to the task dependency to obtain a target multi-branch tree; the hierarchical relationship and dependency relationship of all report tasks associated with at least two reports can be reflected through the target multi-branch tree, thereby avoiding the repeated execution of the same report task in each report generation stage, and realizing that only one of the same report tasks involved in at least two reports is retained in the multi-branch tree, and the target multi-branch tree can be traversed, and at least two target reports corresponding to the report generation request can be generated according to the traversal results. Thereby, the efficiency of multi-report generation can be effectively improved, and the computing resources consumed by repeated execution of tasks can be avoided, and the user report usage experience can be improved.

[0037] See also Figure 2 , Figure 2 A flow chart of a report generation method provided according to an embodiment of the present specification is shown, which specifically includes the following steps.

[0038] Step S202: determining report generation parameters in response to a report generation request submitted for a target business.

[0039] The report generation method provided in this embodiment can be applied to the business system corresponding to any target business, so as to realize the rapid generation of reports related to the target business according to the report generation request submitted by the user. The target business can be a transaction information management business, a user information management business, a financial information management business, a medical diagnosis information management business, etc. And different target businesses support users to generate different types of reports on demand. This embodiment takes the report generation method in the transaction information management business as an example to illustrate it. The description of other scenarios can refer to the same or corresponding description in this embodiment, and this embodiment will not be repeated in detail here.

[0040] Specifically, the target business refers to the business in which the user participates, such as transaction information management business, user information management business, financial information management business, medical diagnosis information management business, etc. The user can extract data from the target business as needed to build reports, such as statistics of transaction information from January to December for annual summary, etc. Correspondingly, the report generation request refers to the request submitted by the user, which is used to determine the structure and data volume of the report to be generated. It can be understood that the report generation request is a request triggered by the user in the report generation interface by checking the controls provided by the system, so that the target report required by the user can be generated according to the request. Correspondingly, the report generation parameters refer to the relevant parameters required in the report generation stage, including but not limited to report number information, date information, product information, issuing agency code information, product type information, etc., which are used to more accurately determine the report task, thereby improving the accuracy of the generated report.

[0041] Based on this, in order to be able to quickly and efficiently respond to requests to generate multiple reports and reduce the consumption of computing resources, the report generation parameters can be determined in response to the report generation request submitted for the target business; when the report generation request is a multi-report generation request, all report tasks associated with at least two reports to be generated can be directly extracted from the task database of the target business according to the report generation parameters; then, before the report is generated, the report tasks do not need to be divided, but the task dependencies corresponding to the multiple report tasks can be directly determined according to the preset task dependency graph, and the multiple report tasks can be arranged according to the task dependency to obtain a target multi-branch tree; the hierarchical relationship and dependency relationship of all report tasks associated with at least two reports can be reflected through the target multi-branch tree, and finally the target multi-branch tree can be traversed to generate at least two target reports corresponding to the report generation request according to the traversal results.

[0042] Furthermore, in order to avoid repeated execution of report tasks when multiple report generation requests are triggered, a task dependency graph can be pre-built to reflect the dependency relationships between all report tasks through the task dependency graph, which is convenient for use in the application stage. In this embodiment, the specific implementation method is as follows:

[0043] Acquire multiple business reports associated with the target business; use the lineage analysis component to parse the multiple business reports to obtain data lineage relationships corresponding to the report data; construct initial report tasks corresponding to the multiple business reports, and construct a task dependency graph for the initial report tasks based on the data lineage relationships; wherein the task dependency graph records the task dependency relationships and task hierarchy information corresponding to the initial report tasks.

[0044] Specifically, multiple business reports specifically refer to all types of reports that can be generated by the target business. Correspondingly, the lineage analysis component specifically refers to a component used to track the data flow process and relationship, which can record the source, transmission path and purpose of the data, thereby helping enterprises manage and protect their data assets. It can be implemented using tools such as Apache Atlas, Datahub or Gudu SQLFlow, and this embodiment does not make any restrictions here. Correspondingly, the data lineage relationship specifically refers to the relationship that reflects the flow process between data, which is used to characterize the direct and indirect relationships and no relationship of data. Correspondingly, the initial report task specifically refers to the task that needs to be performed when multiple business reports are generated. Correspondingly, the task dependency graph specifically refers to a structural diagram that records the dependency relationship between all initial report tasks, and also records the task hierarchy information corresponding to each report task. The task hierarchy information is used to reflect the hierarchical position to which the report task belongs when it is applied.

[0045] Based on this, in order to be able to quickly generate the reports required by users in response to user requests during the application phase, all business reports associated with the target business can be obtained in advance; and then considering that the data required to be recorded in the user's report generation request may change in real time, it is impossible to pre-build the report for the user to use, so a task dependency graph can be pre-built to reflect the dependency of the report tasks involved in each report, so that task reuse can be achieved to generate reports. Therefore, the lineage analysis component can be used to parse multiple business reports to obtain the data lineage corresponding to the report data based on the parsing results; thereafter, the initial report tasks corresponding to multiple business reports can be constructed, so that the task dependency graph can be constructed for the initial report task based on the data lineage; the task dependency graph can be used to record the task dependency and task hierarchy information corresponding to the initial report task.

[0046] In actual applications, the types of reports that can be generated by the target business are usually fixed. Therefore, when building a task dependency graph, the report number corresponding to each report task can be recorded in the graph to facilitate use in the application stage. In other words, each report that can be generated by the target business is assigned a report number to support users to trigger the report generation logic by submitting the report number when they need to generate a report.

[0047] In summary, by pre-building a task dependency graph to record the task dependencies and task hierarchy information corresponding to the report tasks, the graph can be reused in the report generation stage, and the dependencies of multiple report tasks can be quickly determined to build a multi-branch tree to improve the report generation efficiency.

[0048] Furthermore, in order to accurately extract the report tasks involved in the report generation request in the subsequent step, the request can be parsed to obtain the report number information and report type information, so as to extract the report tasks. In this embodiment, the specific implementation method is as follows:

[0049] A report generation request submitted for a target business is received, and the report generation request is parsed; report number information and report type information are determined according to the parsing result, and the report number information and the report type information are used as report generation parameters; wherein, after the step of determining the report generation parameters in response to the report generation request submitted for the target business is executed, the step further includes: when it is determined according to the report number information that the report generation request is associated with at least two reports, determining that the report generation request is a multi-report generation request, and executing the step of extracting multiple report tasks from the task database of the target business according to the report generation parameters.

[0050] Specifically, the report number information specifically refers to the report number corresponding to the report that the user needs to generate. Correspondingly, the report type information specifically refers to the information that records the product information, product type, date, release structure code, etc. corresponding to the report that the user needs to generate.

[0051] Based on this, when a user has a report generation requirement, he can first receive a report generation request submitted for the target business, and then parse the report generation request; determine the report number information and report type information based on the parsing result, and then use the report number information and report type information as report generation parameters; so that multiple report tasks can be extracted based on the report generation parameters in the future.

[0052] Prior to this, it is necessary to detect the number of reports involved in the user's current report generation request. If it is determined based on the report number information that the report generation request is associated with one report, the report task can be directly extracted from the library according to the report number to generate the target report. If it is determined based on the report number information that the report generation request is associated with at least two reports, it means that the user needs to generate two or more reports at this time. Therefore, it can be determined that the report generation request is a multi-report generation request, and the step of extracting multiple report tasks from the task database of the target business according to the report generation parameters can be performed, so that a multi-branch tree can be constructed for the request to quickly generate the target report.

[0053] In actual applications, users can determine the required report type by selecting a specific report number, business date, product number, issuing agency code and product type on the report generation page, and then the backend can obtain the above information by parsing the request, and use it to determine the number of reports the user needs to generate, and thus choose a reasonable way to generate the report.

[0054] For example, the transaction information management business can use the lineage analysis component to parse the n reports involved in the business in advance, determine m report tasks based on the analysis results, and build a task dependency graph that records the dependencies of the m report tasks and the hierarchical positions in the execution sequence based on the data lineage relationship for use in the application stage.

[0055] Furthermore, when the user needs to generate a profit report from January to December and a transaction volume report from January to December, the user can select report number 1 corresponding to the profit report and report number 2 corresponding to the transaction volume report in the report generation page, and at the same time determine information such as the business date, product number, issuing agency code and product type, so as to subsequently combine the above information to complete the construction of the profit report from January to December and the transaction volume report from January to December for user use.

[0056] In summary, by recording the report number information and report type information in the report generation parameters, the system can quickly determine the number of reports to be generated and related information content, thereby improving the efficiency and accuracy of report generation.

[0057] Step S204: when the report generation request is a multi-report generation request, extract multiple report tasks from the task database of the target business according to the report generation parameters.

[0058] Specifically, after receiving a report generation request and determining report generation parameters, if the report generation request is a multi-report generation request, it means that the user currently needs to generate two or more reports. If a single build is performed for each report, it will not only take more time, but also cause the problem of repeated execution of report tasks (when there are overlapping parts between two reports, the report task is executed repeatedly). In order to save time and avoid repeated execution of tasks, all report tasks associated with the reports involved in the multi-report generation request can be directly extracted from the task database of the target business according to the report generation parameters, so that each report task is unique. Subsequently, report generation is performed on this basis to avoid repeated execution of report tasks.

[0059] The task database specifically refers to a database used by the target business to record all report-related report tasks. Correspondingly, the multiple report tasks specifically refer to a collection of report-related report tasks required to generate multiple report generation requests.

[0060] Furthermore, when extracting multiple report tasks, considering that the report generation request is a multi-report generation request, in order to improve the report generation efficiency, the report tasks can be extracted uniformly and task duplication can be avoided, thereby saving computing resources consumed by subsequent report generation. In this embodiment, the specific implementation method is as follows:

[0061] The report number information is extracted from the report generation parameters, and at least two report numbers are determined according to the report number information; the business report task corresponding to each report number is extracted from the task database of the target business; and a plurality of report tasks are composed based on the business report tasks corresponding to each report number.

[0062] Specifically, the report number refers to the unique number corresponding to each report, and different report numbers correspond to different types of reports. Correspondingly, the business report task refers to the report task that needs to be executed for each report corresponding to the report number. It should be noted that the report tasks stored in the task database carry the report number to ensure that when the task is read, it can be read uniformly according to the report number. In addition, each report task can be associated with one or more report numbers.

[0063] Based on this, in order to ensure that the report task covers the current multi-report generation request, the report number information can be extracted from the report generation parameters, and at least two report numbers can be determined based on the report number information; then the business report task corresponding to each report number can be extracted from the task database of the target business; thereby, multiple report tasks can be composed based on the business report task corresponding to each report number for subsequent use.

[0064] Using the above example, if it is determined that the user needs to generate a profit report from January to December and a transaction volume report from January to December, the report tasks associated with the profit report can be extracted from the task database according to the report number 1 corresponding to the profit report, which are report task 0, report task 1, report task 2, report task 3, report task 4, report task 5, and report task 6. At the same time, the report tasks associated with the transaction volume report can be extracted from the task database according to the report number 2 corresponding to the transaction volume report, which are report task 0, report task 7, report task 8, report task 9, report task 10, and report task 4. By integrating the above report tasks, it is determined that the generation of the two reports requires report tasks 0 to 10, a total of 11 report tasks.

[0065] In summary, by extracting all report tasks as a whole for subsequent report construction, it is possible to avoid the execution of repeated tasks, thereby saving computing resources and improving report generation efficiency.

[0066] Step S206 , determining the task dependencies corresponding to the multiple report tasks according to a preset task dependency graph, and arranging the multiple report tasks according to the task dependency to obtain a target multi-branch tree.

[0067] Specifically, after determining all the report tasks associated with the reports required to generate the multiple report generation requests as mentioned above, considering that multiple report tasks involve multiple reports, in order to avoid the decrease in report generation accuracy due to the complexity of task dependencies, the task dependencies corresponding to the multiple report tasks can be determined according to the preset task dependency graph, and the multiple report tasks can be arranged according to the task dependencies to obtain the target multi-branch tree, so as to represent the hierarchical information and dependencies of each report task through the multi-branch tree, thereby ensuring that multiple target reports can be obtained after traversing the multi-branch tree.

[0068] Among them, task dependency specifically refers to the task relationship between the execution of each report task in multiple report tasks. Correspondingly, the target multi-branch tree specifically refers to a multi-branch tree constructed by taking the report task as a tree node and determining the edges between the tree nodes according to the task dependency relationship. By sharing nodes in the multi-branch tree, the generation logic of multiple reports is fully realized, and then after the multi-branch tree is traversed, multiple reports can be quickly generated, and the report tasks can be avoided from being repeatedly executed, thereby improving the efficiency of report generation.

[0069] Furthermore, when arranging multiple report tasks, considering that multiple report tasks are associated with multiple report generation requirements, in order to avoid repeated execution of tasks, the tasks can be initialized to a multi-branch tree, so as to reflect multiple report generation logics by a multi-branch tree sharing tree node corresponding to the report task. In this embodiment, the specific implementation method is as follows:

[0070] Determine an initial multi-branch tree preset for the target business; based on the multi-branch tree structure of the initial multi-branch tree and the task dependencies, arrange the multiple report tasks to obtain task distribution information corresponding to each report task; add the multiple report tasks to the initial multi-branch tree according to the task distribution information corresponding to each report task, and obtain a target multi-branch tree corresponding to the report generation request.

[0071] Specifically, the initial multitree refers to a multitree without adding report tasks. Correspondingly, the task distribution information refers to the relationship between the position and level of each report task in the multitree. By adding report tasks to the multitree according to the relationship, a target multitree matching multiple report generation requests can be obtained, so that the target multitree reflects the task execution logic of multiple report generation.

[0072] Based on this, in order to avoid repeated execution of tasks, all report tasks can be initialized to a multi-branch tree to reflect the execution relationship between each task, and then the report tasks can be executed according to the structure of the multi-branch tree to obtain the target report. Therefore, it is necessary to accurately initialize the report task to the multi-branch tree. At this time, the initial multi-branch tree preset by the target business can be determined; then, based on the multi-branch tree structure and task dependency of the initial multi-branch tree, multiple report tasks can be arranged to obtain the task distribution information corresponding to each report task; on this basis, multiple report tasks can be added to the initial multi-branch tree according to the task distribution information corresponding to each report task, so that the target multi-branch tree corresponding to the report generation request can be obtained for subsequent report generation.

[0073] In actual applications, when users have the need to generate multiple reports, they can extract report tasks from the database by identifying the report number, and then analyze the dependencies of the report tasks, and rearrange the report tasks according to the preset multi-tree structure, so as to obtain the distribution information corresponding to each report task, and finally initialize the report tasks to the multi-tree to obtain a multi-tree that reflects the execution logic of the report tasks corresponding to each report, so that reports can be generated and used later. In addition, considering that there may be multiple report tasks that are referenced multiple times, in order to avoid the repeated execution of such tasks and consume more computing resources, such report tasks can be set as a separate layer of tree nodes, thereby ensuring that the tasks can be repeatedly used after being executed only once, so as to save more computing resources.

[0074] Continuing with the above example, in the case where the profit report from January to December and the transaction volume report from January to December involve report tasks 0 to 10, the task dependency relationship between report tasks 0 to 10 can be determined according to the task dependency graph pre-constructed by the transaction information pipeline business. At the same time, the multi-branch tree structure can be loaded, and report tasks 0 to 10 can be arranged according to the multi-branch tree structure and task dependencies. According to the arrangement results, it is determined that report task 0 belongs to the 5th layer of the multi-branch tree. Report task 1, report task 2, report task 3, report task 4, report task 7, report task 8 belong to the 4th layer of the multi-branch tree. Report task 5 and report task 9 belong to the 3rd layer of the multi-branch tree. Report task 6 and report task 10 belong to the 2nd layer of the multi-branch tree. The profit report and transaction volume report belong to the 1st layer of the multi-branch tree. Therefore, the above relationship can be used to construct the following Figure 3 The target multi-branch tree is shown, so that the profit report from January to December and the transaction volume report from January to December can be constructed based on the multi-branch tree.

[0075] In summary, by arranging report tasks according to a multi-branch tree structure, multiple report tasks can reflect task dependencies and execution relationships through a multi-branch tree, thereby ensuring that the final generated report is more accurate and saves more computing resources.

[0076] In addition, in addition to the above multi-branch tree construction method, the target multi-branch tree can also be formed by separately constructing subtrees and merging them to save computing resources. In this embodiment, the specific implementation method is as follows:

[0077] The multiple report tasks are grouped according to the report generation request to obtain at least two report task groups; the at least two report task groups are arranged based on the task dependency to obtain a subtask tree corresponding to each report task group; the subtask trees corresponding to each report task group are merged to obtain a target multi-branch tree corresponding to the report generation request.

[0078] Specifically, the report task group specifically refers to a collection of report tasks corresponding to a report number. Correspondingly, the subtask tree specifically refers to a sub-tree composed of report tasks corresponding to each report number.

[0079] Based on this, taking into account the need for multiple report tasks to be associated with multiple report generation, in order to ensure the accuracy of building a multi-branch tree, multiple report tasks can also be grouped according to the report generation request to obtain at least two report task groups; on this basis, at least two report task groups can be arranged based on task dependencies to obtain the subtask tree corresponding to each report task group; then the subtask trees corresponding to each report task group can be fused to obtain the target multi-branch tree corresponding to the report generation request based on the fusion results for subsequent use.

[0080] During specific implementation, the target multi-branch tree construction method can be selected according to actual needs, and this embodiment does not impose any limitation on this.

[0081] In summary, by constructing the target multi-branch tree by separately constructing subtask trees, the logical confusion problem existing in direct construction can be avoided, thereby improving the construction efficiency of the target multi-branch tree.

[0082] Step S208: traverse the target multi-branch tree, and generate at least two target reports corresponding to the report generation request according to the traversal result.

[0083] Specifically, after obtaining the target multi-branch tree as described above, the target multi-branch tree can be traversed to determine the report task corresponding to each tree node, and the report tasks can be executed in this order to generate at least two target reports corresponding to the report generation request for user use.

[0084] Furthermore, when traversing the target multi-branch tree, in order to avoid repeated execution of report tasks and to ensure the accuracy of report generation, it can be implemented by executing from the bottom up. In this embodiment, the specific implementation method is as follows:

[0085] Traverse the target multi-branch tree to obtain the i-th layer of tree nodes in the target multi-branch tree, and execute the report tasks corresponding to the i-th layer of tree nodes; when it is determined according to the task execution results that the report tasks corresponding to the i-th layer of tree nodes are all completed, i is automatically incremented in sequence, and the target multi-branch tree is traversed to obtain the i-th layer of tree nodes in the target multi-branch tree; until the i-th layer of tree nodes is the root node of the target multi-branch tree, based on the task execution results of the report tasks corresponding to the tree nodes of each layer of the target multi-branch tree, generate at least two target reports corresponding to the report generation request.

[0086] Specifically, the i-th layer node specifically refers to the tree node corresponding to any multi-tree level determined in the traversal stage in the target multi-tree. Among them, i is a positive integer, and i starts from 1. The level corresponding to each value starts from the child node of the target multi-tree until it reaches the root node to complete the construction of the target report.

[0087] Based on this, when constructing a target report, the report task can be executed from the bottom layer of the target multi-branch tree by traversing the target multi-branch tree, so the i-th layer tree node in the target multi-branch tree can be obtained, and then the report task corresponding to the i-th layer tree node can be executed; when it is determined according to the task execution result that the report tasks corresponding to the i-th layer tree nodes are all completed, it means that the report tasks corresponding to the current level are all completed, so i can be controlled to increase in sequence, and the target multi-branch tree is traversed to obtain the i-th layer tree node in the target multi-branch tree; until the i-th layer tree node is the root node of the target multi-branch tree, it can be determined that all report tasks contained in the target multi-branch tree are completed, so based on the task execution results of the report tasks corresponding to each layer tree node of the target multi-branch tree, at least two target reports corresponding to the report generation request can be generated.

[0088] In practical applications, the report tasks contained in the target multi-branch tree can be executed in a bottom-up traversal manner, that is, the bottom-level report tasks are executed first, and after the execution is completed, the report tasks of each layer are executed upward layer by layer until the top-level report tasks are completed. This can avoid duplication of report task execution and ensure that tasks are carried out in order according to the logical dependency order.

[0089] In the specific implementation, in order to improve the efficiency of report generation, the report tasks corresponding to each layer of tree nodes can also be set to be executed concurrently, thereby making full use of multi-core CPU resources, significantly shortening the overall processing time, and improving the system response speed.

[0090] Using the above example, after determining the levels corresponding to report tasks 0 to 10, each report task can be executed starting from the 5th level of the multitree. That is, the first execution cycle executes report task 0 contained in the 5th level of the multitree; the second execution cycle executes report task 1, report task 2, report task 3, report task 4, report task 7, and report task 8 contained in the 4th level of the multitree. The third execution cycle executes report task 5 and report task 9 contained in the 3rd level of the multitree. The fourth execution cycle executes report task 6 and report task 10 contained in the 2nd level of the multitree. According to the execution results of each task, the profit report from January to December and the transaction volume report from January to December can be obtained and fed back to the user.

[0091] In summary, by executing report tasks from the bottom up, the efficiency of task execution can be effectively improved, and repeated task execution can be avoided to save computing resources.

[0092] In addition, in order to optimize the target business in real time, a relationship between the execution link identifier and the request execution information can also be established to be traced back and used in the optimization stage. In this embodiment, the specific implementation method is as follows:

[0093] Determine the execution link identifier corresponding to the report generation request according to the report generation parameters, and obtain the request execution information corresponding to the report generation request; establish a mapping relationship between the execution link identifier and the request execution information, and store the execution link identifier and the request execution information in the business database of the target business according to the mapping relationship.

[0094] Specifically, the execution link identifier refers to the execution link ID, and correspondingly, the request execution information refers to the relevant information of the associated report generation request, including but not limited to the input parameters, output parameters, execution logic, etc. involved in the report generation process. It can also record parameter configuration, source code snippets, execution time, and other information.

[0095] Based on this, in order to facilitate the audit, tracing and optimization of the target business, the execution link identifier corresponding to the report generation request can be determined according to the report generation parameters, and the request execution information corresponding to the report generation request can be obtained; then a mapping relationship between the execution link identifier and the request execution information is established, and the execution link identifier and the request execution information are stored in the business database of the target business according to the mapping relationship, which can facilitate subsequent business auditing or business optimization.

[0096] In actual applications, data isolation can be achieved by executing link identification, ensuring that each task runs in its independent data environment. Even if the logic is the same, different parameters or task output data under the link can be strictly separated. This can ensure that in the subsequent business execution process, the input parameters, output parameters and execution logic of each task are recorded by relying on this representation, providing rich data for auditing, tracing and system performance, and enhancing compliance and transparency.

[0097] The report generation method provided in this embodiment can respond to the request to generate multiple reports quickly and efficiently, and reduce the consumption of computing resources. The report generation method can first determine the report generation parameters in response to the report generation request submitted for the target business; when the report generation request is a multiple report generation request, all report tasks associated with at least two reports to be generated can be directly extracted from the task database of the target business according to the report generation parameters; and then before the report generation, the report tasks can be divided without dividing them, but the task dependencies corresponding to the multiple report tasks can be directly determined according to the preset task dependency graph, and the multiple report tasks can be arranged according to the task dependency to obtain a target multi-branch tree; the hierarchical relationship and dependency relationship of all report tasks associated with at least two reports can be reflected through the target multi-branch tree, thereby avoiding the repeated execution of the same report task in each report generation stage, and realizing that only one of the same report tasks involved in at least two reports is retained in the multi-branch tree, and the target multi-branch tree can be traversed, and at least two target reports corresponding to the report generation request can be generated according to the traversal results. Thereby, the efficiency of multi-report generation can be effectively improved, and the computing resources consumed by repeated execution of tasks can be avoided, and the user report usage experience can be improved.

[0098] The following combination Figure 4 , taking the application of the report generation method provided in this specification in a data statistics scenario as an example, the report generation method is further described. Figure 4 A flowchart of a report generation method provided in an embodiment of the present specification is shown, which specifically includes the following steps.

[0099] Step S402: Acquire multiple business reports associated with the target business.

[0100] Step S404, using the lineage analysis component to parse multiple business reports to obtain data lineage relationships corresponding to the report data.

[0101] Step S406, constructing initial report tasks corresponding to a plurality of business reports, and constructing a task dependency graph for the initial report tasks based on data lineage relationships.

[0102] Step S408: receiving a report generation request submitted for the target business, and parsing the report generation request.

[0103] Step S410: determine report number information and report type information according to the analysis result, and use the report number information and report type information as report generation parameters.

[0104] Step S412: When it is determined according to the report number information that the report generation request is associated with at least two reports, the report generation request is determined to be a multi-report generation request.

[0105] Step S414: extract report number information from the report generation parameters, and determine at least two report numbers according to the report number information.

[0106] Step S416: extracting the business report task corresponding to each report number from the task database of the target business, and composing a plurality of report tasks based on the business report tasks corresponding to each report number.

[0107] Step S418, determining the task dependency relationships corresponding to the multiple report tasks according to the preset task dependency graph, and determining the initial multi-branch tree preset for the target business.

[0108] Step S420 , based on the multi-tree structure of the initial multi-tree and the task dependency relationship, multiple report tasks are arranged to obtain task distribution information corresponding to each report task.

[0109] Step S422: Add multiple report tasks to the initial multi-branch tree according to the task distribution information corresponding to each report task, and obtain a target multi-branch tree corresponding to the report generation request.

[0110] Step S424, traverse the target multi-branch tree, and generate at least two target reports corresponding to the report generation request according to the traversal result.

[0111] In summary, in order to generate multiple reports in response to a request quickly and efficiently and reduce the consumption of computing resources, the report generation parameters can be determined in response to the report generation request submitted for the target business; when the report generation request is a multiple report generation request, all report tasks associated with at least two reports to be generated can be directly extracted from the task database of the target business according to the report generation parameters; and then before the report generation, the report tasks can be divided without dividing them, but the task dependencies corresponding to the multiple report tasks can be directly determined according to the preset task dependency graph, and the multiple report tasks can be arranged according to the task dependency to obtain a target multi-branch tree; the hierarchical relationship and dependency relationship of all report tasks associated with at least two reports can be reflected through the target multi-branch tree, thereby avoiding the repeated execution of the same report task in each report generation stage, and realizing that only one of the same report tasks involved in at least two reports is retained in the multi-branch tree, and the target multi-branch tree can be traversed, and at least two target reports corresponding to the report generation request can be generated according to the traversal results. Thereby, the efficiency of multi-report generation can be effectively improved, and the computing resources consumed by repeated execution of tasks can be avoided, and the user report usage experience can be improved.

[0112] Corresponding to the above method embodiment, this specification also provides a report generation system embodiment. Figure 5 FIG. 1 shows a structural diagram of a report generation system provided by an embodiment of the present specification. Figure 5 As shown, the report generation system 500 includes a server 520 and a client 510, including:

[0113] The client 510 is used to receive a selection instruction submitted by a user for a target business, construct a report generation request according to the selection instruction, and send the report generation request to the server;

[0114] The server 520 is used to determine report generation parameters according to the report generation request; if the report generation request is a multi-report generation request, extract multiple report tasks from the task database of the target business according to the report generation parameters; determine the task dependency relationships corresponding to the multiple report tasks according to a preset task dependency graph, and arrange the multiple report tasks according to the task dependency relationships to obtain a target multi-branch tree; traverse the target multi-branch tree, generate at least two target reports corresponding to the report generation request according to the traversal results, and send them to the client;

[0115] The client 510 is used to display the at least two target reports to the user.

[0116] In an optional embodiment, before the step of determining report generation parameters in response to a report generation request submitted for a target business is performed, the method further includes:

[0117] Acquire multiple business reports associated with the target business; use the lineage analysis component to parse the multiple business reports to obtain data lineage relationships corresponding to the report data; construct initial report tasks corresponding to the multiple business reports, and construct a task dependency graph for the initial report tasks based on the data lineage relationships; wherein the task dependency graph records the task dependency relationships and task hierarchy information corresponding to the initial report tasks.

[0118] In an optional embodiment, determining the report generation parameters in response to the report generation request submitted for the target business includes:

[0119] A report generation request submitted for a target business is received, and the report generation request is parsed; report number information and report type information are determined according to the parsing result, and the report number information and the report type information are used as report generation parameters; wherein, after the step of determining the report generation parameters in response to the report generation request submitted for the target business is executed, the step further includes: when it is determined according to the report number information that the report generation request is associated with at least two reports, determining that the report generation request is a multi-report generation request, and executing the step of extracting multiple report tasks from the task database of the target business according to the report generation parameters.

[0120] In an optional embodiment, extracting a plurality of report tasks from a task database of the target business according to the report generation parameters includes:

[0121] The report number information is extracted from the report generation parameters, and at least two report numbers are determined according to the report number information; the business report task corresponding to each report number is extracted from the task database of the target business; and a plurality of report tasks are composed based on the business report tasks corresponding to each report number.

[0122] In an optional embodiment, the step of arranging the multiple report tasks according to the task dependency to obtain a target multi-branch tree includes:

[0123] Determine an initial multi-branch tree preset for the target business; based on the multi-branch tree structure of the initial multi-branch tree and the task dependencies, arrange the multiple report tasks to obtain task distribution information corresponding to each report task; add the multiple report tasks to the initial multi-branch tree according to the task distribution information corresponding to each report task, and obtain a target multi-branch tree corresponding to the report generation request.

[0124] In an optional embodiment, the step of arranging the multiple report tasks according to the task dependency to obtain a target multi-branch tree includes:

[0125] The multiple report tasks are grouped according to the report generation request to obtain at least two report task groups; the at least two report task groups are arranged based on the task dependency to obtain a subtask tree corresponding to each report task group; the subtask trees corresponding to each report task group are merged to obtain a target multi-branch tree corresponding to the report generation request.

[0126] In an optional embodiment, traversing the target multi-branch tree and generating at least two target reports corresponding to the report generation request according to the traversal result includes:

[0127] Traverse the target multi-branch tree to obtain the i-th layer of tree nodes in the target multi-branch tree, and execute the report tasks corresponding to the i-th layer of tree nodes; when it is determined according to the task execution results that the report tasks corresponding to the i-th layer of tree nodes are all completed, i is automatically incremented in sequence, and the target multi-branch tree is traversed to obtain the i-th layer of tree nodes in the target multi-branch tree; until the i-th layer of tree nodes is the root node of the target multi-branch tree, based on the task execution results of the report tasks corresponding to the tree nodes of each layer of the target multi-branch tree, generate at least two target reports corresponding to the report generation request.

[0128] In an optional embodiment, after the step of traversing the target multi-branch tree and generating at least two target reports corresponding to the report generation request according to the traversal result is executed, the method further includes:

[0129] Determine the execution link identifier corresponding to the report generation request according to the report generation parameters, and obtain the request execution information corresponding to the report generation request; establish a mapping relationship between the execution link identifier and the request execution information, and store the execution link identifier and the request execution information in the business database of the target business according to the mapping relationship.

[0130] The report generation system provided in this embodiment can respond to the report generation request submitted for the target business to generate multiple reports quickly and efficiently, and reduce the consumption of computing resources. The report generation system can first determine the report generation parameters in response to the report generation request submitted for the target business; when the report generation request is a multiple report generation request, all report tasks associated with at least two reports to be generated can be directly extracted from the task database of the target business according to the report generation parameters; and then before the report generation, the report tasks can be divided without dividing them, but the task dependencies corresponding to the multiple report tasks can be directly determined according to the preset task dependency graph, and the multiple report tasks can be arranged according to the task dependency to obtain a target multi-branch tree; the hierarchical relationship and dependency relationship of all report tasks associated with at least two reports can be reflected through the target multi-branch tree, thereby avoiding the repeated execution of the same report task in each report generation stage, and realizing that only one of the same report tasks involved in at least two reports is retained in the multi-branch tree, and the target multi-branch tree can be traversed, and at least two target reports corresponding to the report generation request can be generated according to the traversal results. Thereby, the efficiency of multi-report generation can be effectively improved, and the computing resources consumed by repeated execution of tasks can be avoided, and the user report usage experience can be improved.

[0131] The above is a schematic scheme of a report generation system of this embodiment. It should be noted that the technical scheme of the report generation system and the technical scheme of the report generation method described above are of the same concept, and the details not described in detail in the technical scheme of the report generation system can be referred to the description of the technical scheme of the report generation method described above.

[0132] Corresponding to the above method embodiment, this specification also provides a report generation device embodiment, Figure 6 FIG. 1 is a schematic diagram showing the structure of a report generation device provided by an embodiment of the present specification. Figure 6 As shown, the device comprises:

[0133] A determination module 602 is configured to determine report generation parameters in response to a report generation request submitted for a target business;

[0134] An extraction module 604 is configured to extract multiple report tasks from a task database of the target business according to the report generation parameters when the report generation request is a multiple report generation request;

[0135] The arrangement module 606 is configured to determine the task dependencies corresponding to the multiple report tasks according to a preset task dependency graph, and arrange the multiple report tasks according to the task dependency to obtain a target multi-branch tree;

[0136] The generating module 608 is configured to traverse the target multi-branch tree and generate at least two target reports corresponding to the report generation request according to the traversal result.

[0137] In an optional embodiment, the device further comprises:

[0138] An acquisition module is configured to acquire multiple business reports associated with the target business; parse the multiple business reports using a lineage analysis component to obtain data lineage relationships corresponding to the report data; construct initial report tasks corresponding to the multiple business reports, and construct a task dependency graph for the initial report task based on the data lineage relationships; wherein the task dependency graph records the task dependency relationships and task hierarchy information corresponding to the initial report task.

[0139] In an optional embodiment, the determining module 602 is further configured to:

[0140] A report generation request submitted for a target business is received, and the report generation request is parsed; report number information and report type information are determined according to the parsing result, and the report number information and the report type information are used as report generation parameters; wherein, after the step of determining the report generation parameters in response to the report generation request submitted for the target business is executed, the step further includes: when it is determined according to the report number information that the report generation request is associated with at least two reports, determining that the report generation request is a multi-report generation request, and executing the step of extracting multiple report tasks from the task database of the target business according to the report generation parameters.

[0141] In an optional embodiment, the extraction module 604 is further configured to:

[0142] The report number information is extracted from the report generation parameters, and at least two report numbers are determined according to the report number information; the business report task corresponding to each report number is extracted from the task database of the target business; and a plurality of report tasks are composed based on the business report tasks corresponding to each report number.

[0143] In an optional embodiment, the arrangement module 606 is further configured to:

[0144] Determine an initial multi-branch tree preset for the target business; based on the multi-branch tree structure of the initial multi-branch tree and the task dependencies, arrange the multiple report tasks to obtain task distribution information corresponding to each report task; add the multiple report tasks to the initial multi-branch tree according to the task distribution information corresponding to each report task, and obtain a target multi-branch tree corresponding to the report generation request.

[0145] In an optional embodiment, the arrangement module 606 is further configured to:

[0146] The multiple report tasks are grouped according to the report generation request to obtain at least two report task groups; the at least two report task groups are arranged based on the task dependency to obtain a subtask tree corresponding to each report task group; the subtask trees corresponding to each report task group are merged to obtain a target multi-branch tree corresponding to the report generation request.

[0147] In an optional embodiment, the generating module 608 is further configured to:

[0148] Traverse the target multi-branch tree to obtain the i-th layer of tree nodes in the target multi-branch tree, and execute the report tasks corresponding to the i-th layer of tree nodes; when it is determined according to the task execution results that the report tasks corresponding to the i-th layer of tree nodes are all completed, i is automatically incremented in sequence, and the target multi-branch tree is traversed to obtain the i-th layer of tree nodes in the target multi-branch tree; until the i-th layer of tree nodes is the root node of the target multi-branch tree, based on the task execution results of the report tasks corresponding to the tree nodes of each layer of the target multi-branch tree, generate at least two target reports corresponding to the report generation request.

[0149] In an optional embodiment, the device further comprises:

[0150] A storage module is configured to determine an execution link identifier corresponding to the report generation request according to the report generation parameters, and obtain request execution information corresponding to the report generation request; establish a mapping relationship between the execution link identifier and the request execution information, and store the execution link identifier and the request execution information in a business database of the target business according to the mapping relationship.

[0151] In order to quickly and efficiently respond to requests to generate multiple reports and reduce the consumption of computing resources, the report generation device provided in this embodiment can first determine the report generation parameters in response to the report generation request submitted for the target business; when the report generation request is a multiple report generation request, all report tasks associated with at least two reports to be generated can be directly extracted from the task database of the target business according to the report generation parameters; and then before the report generation, the report tasks can be divided without performing report task division, but the task dependencies corresponding to the multiple report tasks can be directly determined according to the preset task dependency graph, and the multiple report tasks can be arranged according to the task dependency to obtain a target multi-branch tree; the hierarchical relationship and dependency relationship of all report tasks associated with at least two reports can be reflected through the target multi-branch tree, thereby avoiding the repeated execution of the same report task in each report generation stage, and realizing that only one of the same report tasks involved in at least two reports is retained in the multi-branch tree, and the target multi-branch tree can be traversed, and at least two target reports corresponding to the report generation request can be generated according to the traversal results. Thereby, the efficiency of multi-report generation can be effectively improved, and the computing resources consumed by repeated task execution can be avoided, and the user report usage experience can be improved.

[0152] The above is a schematic scheme of a report generation device of this embodiment. It should be noted that the technical scheme of the report generation device and the technical scheme of the above report generation method belong to the same concept, and the details not described in detail in the technical scheme of the report generation device can be referred to the description of the technical scheme of the above report generation method.

[0153] Figure 7 The block diagram of a computing device 700 according to an embodiment of the present specification is shown. The components of the computing device 700 include but are not limited to a memory 710 and a processor 720. The processor 720 is connected to the memory 710 via a bus 730, and the database 750 is used to store data.

[0154] The computing device 700 also includes an access device 740 that enables the computing device 700 to communicate via one or more networks 760. Examples of these networks include a public switched telephone network (PSTN), a local area network (LAN), a wide area network (WAN), a personal area network (PAN), or a combination of communication networks such as the Internet. The access device 740 may include one or more of any type of network interface (e.g., a network interface card (NIC)) of wired or wireless, such as an IEEE 802.11 wireless local area network (WLAN) wireless interface, a world-wide interoperability for microwave access (Wi-MAX) interface, an Ethernet interface, a universal serial bus (USB) interface, a cellular network interface, a Bluetooth interface, and a near field communication (NFC).

[0155] In one embodiment of the present specification, the above components of the computing device 700 and Figure 7 Other components not shown in the figure may also be connected to each other, for example, via a bus. It should be understood that Figure 7 The computing device structure block diagram shown is only for the purpose of illustration, and is not intended to limit the scope of this specification. Those skilled in the art can add or replace other components as needed.

[0156] The computing device 700 may be any type of stationary or mobile computing device, including a mobile computer or mobile computing device (e.g., a tablet computer, a personal digital assistant, a laptop computer, a notebook computer, a netbook, etc.), a mobile phone (e.g., a smart phone), a wearable computing device (e.g., a smart watch, smart glasses, etc.), or other types of mobile devices, or a stationary computing device such as a desktop computer or a personal computer (PC). The computing device 700 may also be a mobile or stationary server.

[0157] The processor 720 is used to execute the following computer executable instructions, which, when executed by the processor, implement the steps of the above-mentioned report generation method.

[0158] The above is a schematic scheme of a computing device of this embodiment. It should be noted that the technical scheme of the computing device and the technical scheme of the report generation method described above are of the same concept, and the details not described in detail in the technical scheme of the computing device can be found in the description of the technical scheme of the report generation method described above.

[0159] An embodiment of the present specification further provides a computer-readable storage medium storing computer-executable instructions, which, when executed by a processor, implement the steps of the above-mentioned report generation method.

[0160] The above is a schematic scheme of a computer-readable storage medium of this embodiment. It should be noted that the technical scheme of the storage medium and the technical scheme of the report generation method described above are of the same concept, and the details not described in detail in the technical scheme of the storage medium can be found in the description of the technical scheme of the report generation method described above.

[0161] An embodiment of the present specification also provides a computer program product, including a computer program or instructions, which implement the steps of the above report generation method when executed by a processor.

[0162] The above is a schematic solution of a computer program product of this embodiment. It should be noted that the technical solution of the computer program product and the technical solution of the above report generation method belong to the same concept, and the details not described in detail in the technical solution of the computer program product can be referred to the description of the technical solution of the above report generation method.

[0163] The above is a description of a specific embodiment of the specification. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recorded in the claims can be performed in an order different from that in the embodiments and still achieve the desired results. In addition, the processes depicted in the drawings do not necessarily require the specific order or continuous order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0164] The computer instructions include computer program codes, which may be in source code form, object code form, executable files or some intermediate forms, etc. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electric carrier signal, telecommunication signal and software distribution medium, etc. It should be noted that the content contained in the computer-readable medium may be appropriately increased or decreased according to the requirements of patent practice. For example, in some regions, according to patent practice, computer-readable media do not include electric carrier signals and telecommunication signals.

[0165] It should be noted that, for the above-mentioned method embodiments, for the sake of simplicity of description, they are all expressed as a series of action combinations, but those skilled in the art should be aware that the embodiments of this specification are not limited by the order of the actions described, because according to the embodiments of this specification, some steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are all preferred embodiments, and the actions and modules involved are not necessarily required by the embodiments of this specification.

[0166] In the above embodiments, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0167] The preferred embodiments of this specification disclosed above are only used to help explain this specification. The optional embodiments do not describe all the details in detail, nor do they limit the invention to the specific implementation methods described. Obviously, many modifications and changes can be made according to the content of the embodiments of this specification. This specification selects and specifically describes these embodiments in order to better explain the principles and practical applications of the embodiments of this specification, so that technicians in the relevant technical field can understand and use this specification well.

Claims

1. A report generation method, characterized in that: include: determining report generation parameters in response to a report generation request submitted for a target business; In the case where the report generation request is a multi-report generation request, extracting multiple report tasks from the task database of the target business according to the report generation parameters; Determine the task dependencies corresponding to the multiple report tasks according to a preset task dependency graph, and arrange the multiple report tasks according to the task dependencies to obtain a target multi-branch tree, wherein the target multi-branch tree is constructed by using the multiple report tasks as tree nodes and the task dependencies as edges; The target multi-branch tree is traversed, and at least two target reports corresponding to the report generation request are generated according to the traversal result.

2. The report generation method according to claim 1, characterized in that: Before the step of determining report generation parameters in response to the report generation request submitted for the target business is performed, the method further includes: Acquire multiple business reports associated with the target business; Analyze the multiple business reports using a lineage analysis component to obtain data lineage relationships corresponding to the report data; Constructing initial report tasks corresponding to the plurality of business reports, and constructing a task dependency graph for the initial report tasks based on the data lineage relationship; The task dependency graph records the task dependency and task hierarchy information corresponding to the initial report task.

3. The report generation method according to claim 1, characterized in that: The step of determining report generation parameters in response to a report generation request submitted for a target business includes: Receiving a report generation request submitted for a target business, and parsing the report generation request; Determine report number information and report type information according to the analysis result, and use the report number information and the report type information as report generation parameters; After the step of determining report generation parameters in response to the report generation request submitted for the target business is executed, the method further includes: When it is determined according to the report number information that the report generation request is associated with at least two reports, the report generation request is determined to be a multi-report generation request, and a step of extracting multiple report tasks from a task database of the target business according to the report generation parameters is performed.

4. The report generation method according to claim 3, characterized in that: The extracting a plurality of report tasks from the task database of the target business according to the report generation parameters comprises: Extracting the report number information from the report generation parameters, and determining at least two report numbers according to the report number information; Extracting the business report task corresponding to each report number from the task database of the target business; Multiple report tasks are composed based on the business report tasks corresponding to each report number.

5. The report generation method according to claim 1, characterized in that: Arranging the multiple report tasks according to the task dependency to obtain a target multi-branch tree includes: Determine an initial multi-branch tree preset for the target service; Based on the multi-tree structure of the initial multi-tree and the task dependency relationship, the multiple report tasks are arranged to obtain task distribution information corresponding to each report task; The multiple report tasks are added to the initial multi-branch tree according to the task distribution information corresponding to each report task, and a target multi-branch tree corresponding to the report generation request is obtained.

6. The report generation method according to claim 1, characterized in that: Arranging the multiple report tasks according to the task dependency to obtain a target multi-branch tree includes: Grouping the multiple report tasks according to the report generation request to obtain at least two report task groups; Arrange the at least two report task groups based on the task dependency relationship to obtain a subtask tree corresponding to each report task group; The subtask trees corresponding to each report task group are merged to obtain a target multi-branch tree corresponding to the report generation request.

7. The report generation method according to claim 1, characterized in that: The traversing the target multi-branch tree and generating at least two target reports corresponding to the report generation request according to the traversal result includes: Traversing the target multi-branch tree, obtaining the i-th layer tree node in the target multi-branch tree, and executing the report task corresponding to the i-th layer tree node; When it is determined according to the task execution result that the report tasks corresponding to the i-th layer tree nodes are all completed, i is incremented in sequence, and the target multi-branch tree is traversed to obtain the i-th layer tree nodes in the target multi-branch tree; When the i-th tree node is the root node of the target multi-branch tree, at least two target reports corresponding to the report generation request are generated based on the task execution results of the report tasks corresponding to the tree nodes of each layer of the target multi-branch tree.

8. The report generation method according to any one of claims 1 to 7, characterized in that: After the step of traversing the target multi-branch tree and generating at least two target reports corresponding to the report generation request according to the traversal result is executed, the method further includes: Determining an execution link identifier corresponding to the report generation request according to the report generation parameter, and acquiring request execution information corresponding to the report generation request; A mapping relationship between the execution link identifier and the request execution information is established, and the execution link identifier and the request execution information are stored in a service database of the target service according to the mapping relationship.

9. A report generation system, characterized in that: Including server and client, including: The client is used to receive a selection instruction submitted by a user for a target business, construct a report generation request according to the selection instruction, and send the report generation request to the server; The server is used to determine report generation parameters according to the report generation request; when the report generation request is a multi-report generation request, extract multiple report tasks from the task database of the target business according to the report generation parameters; determine the task dependencies corresponding to the multiple report tasks according to a preset task dependency graph, and arrange the multiple report tasks according to the task dependency to obtain a target multi-branch tree, wherein the target multi-branch tree is constructed by taking the multiple report tasks as tree nodes and the task dependency as edges; traverse the target multi-branch tree, generate at least two target reports corresponding to the report generation request according to the traversal result, and send them to the client; The client is used to display the at least two target reports to the user.

10. A computing device, characterized in that include: Memory and processor; The memory is used to store computer-executable instructions, and the processor is used to execute the computer-executable instructions. When the computer-executable instructions are executed by the processor, the steps of the method described in any one of claims 1 to 8 are implemented.

11. A computer-readable storage medium, characterized in that: It stores computer executable instructions, which, when executed by a processor, implement the steps of the method described in any one of claims 1 to 8.

12. A computer program product, characterized in that The method comprises a computer program or an instruction, which, when executed by a processor, implements the steps of the method according to any one of claims 1 to 8.

Citation Information

Patent Citations

  • Method and device for querying report data

    CN117194463A

  • Data model drilling method and system, terminal and medium

    CN118503239A

  • Scheduling method, system, server and computer readable storage medium

    WO2022253165A1