Information report generation method and process engine, computer device and storage medium

Abstract

The application provides an information report generation method, which comprises: collecting a plurality of different user information and a plurality of product information bound with different interaction information in a plurality of different databases; obtaining product information corresponding to each user information according to the product identifier; querying the current user information in the user information; obtaining the current interaction information corresponding to the current user information; and generating a current data report based on the current interaction information. In addition, the application also provides a process engine and a computer device for realizing information report generation. By collecting user information and product information in a plurality of databases and completing information correspondence according to the identifier, querying target product information and obtaining corresponding interaction information, generating a data report according to the correspondence of the two, the report generation of user information and product information in a plurality of databases is realized, and the correspondence between business logic and product information is accurately reflected.

Description

Technical Field

[0001] This application relates to the field of report development technology, and in particular to an information report generation method, process engine, computer device and storage medium. Background Technology

[0002] In the data reporting process, reports play a crucial role in clarifying the data source, function, and impact; appropriate reports improve data readability. Currently, commonly used report development tools mainly fall into two categories: those that generate interfaces through drag-and-drop on the front end and then generate reports by binding data sources; and those that provide a Structured Query Language (SQL) editor, allowing users to edit SQL statements on the front end and generate data sources. Report management systems developed using big data platforms also utilize big data tools to aggregate data into the big data platform as the data source for report development.

[0003] The two methods described above have the following shortcomings: The first method can only generate simple reports and cannot process the data, especially when there is a need to aggregate and display reports from multiple systems and databases. The second method uses a big data platform. While establishing a complete big data tool platform is necessary for large systems, for small systems or internal departmental systems, building a big data platform is complex, not very practical, and prone to inaccurate data when displaying reports with business logic. Summary of the Invention

[0004] This application provides an information report generation method, process engine, computer equipment, and storage medium to generate reports of user information and product information from various databases.

[0005] In a first aspect, embodiments of this application provide an information report generation method, which includes: collecting multiple different user information and multiple product information bound to different interactive information from multiple different databases; obtaining product information corresponding to each user information according to the product identifier; querying the current user information in the user information; obtaining the current interactive information corresponding to the current user information; and generating a current data report based on the current interactive information.

[0006] Secondly, embodiments of this application provide a process engine for generating information reports. This process engine includes a data collection component, a first acquisition component, a query component, a second acquisition component, and a report generation component. The data collection component collects multiple different user information items and multiple product information items bound to different interaction information items. The first acquisition component obtains the product information corresponding to each user information item based on the product identifier. The query component retrieves the current user information from the user information. The second acquisition component obtains the current interaction information corresponding to the current user information. The report generation component generates a current data report based on the current interaction information.

[0007] Thirdly, embodiments of this application provide a computer device for generating information reports, characterized in that the computer device for generating information reports includes a memory and a processor. The memory is used to store computer programs; the processor is used to execute the computer programs to implement the above-described information report generation method.

[0008] Fourthly, embodiments of this application provide a computer-readable storage medium for storing a computer program, which is executed to implement the above-described information report generation method.

[0009] The aforementioned information report generation method, process engine, computer equipment, and storage medium collect user information and product information from multiple databases, complete information correspondence based on identifiers, query target product information and obtain corresponding interactive information, and generate data reports based on the correspondence between the two, thereby realizing the generation of reports on user information and product information from multiple databases, while accurately reflecting the correspondence between business logic and product information. Attached Figure Description

[0010] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on the structures shown in these drawings without creative effort.

[0011] Figure 1 A flowchart illustrating the information report generation method provided in this application embodiment.

[0012] Figure 2 The flowchart of step S102 provided in the embodiments of this application.

[0013] Figure 3 The flowchart of step S1022 provided in the embodiments of this application is as follows.

[0014] Figure 4 The flowchart of step S104 provided in the embodiments of this application is shown.

[0015] Figure 5 The flowchart of step S105 provided in the embodiments of this application is as follows.

[0016] Figure 6 This is a block diagram of the process engine structure for generating information reports, provided in an embodiment of this application.

[0017] Figure 7 A schematic diagram of the structure of a computer device for generating information reports, provided in an embodiment of this application.

[0018] The realization of the purpose, functional features and advantages of this application will be further explained in conjunction with the embodiments and with reference to the accompanying drawings. Detailed Implementation

[0019] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application. All other embodiments obtained by those skilled in the art based on the embodiments in this application without inventive effort are within the scope of protection of this application.

[0020] The terms “first,” “second,” “third,” “fourth,” etc. (if present) in the specification, claims, and accompanying drawings of this application are used to distinguish similar planned objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data are interchangeable where appropriate; in other words, the described embodiments are implemented according to a sequence other than that illustrated or described herein. Furthermore, the terms “comprising” and “having,” and any variations thereof, may also include other content; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0021] It should be noted that the use of terms such as "first" and "second" in this application is for descriptive purposes only and should not be construed as indicating or implying their relative importance or implicitly specifying the number of technical features indicated. Therefore, features defined with "first" and "second" may explicitly or implicitly include one or more of that feature. Furthermore, the technical solutions of the various embodiments can be combined with each other, but this must be based on the ability of those skilled in the art to implement them. If the combination of technical solutions is contradictory or impossible to implement, it should be considered that such a combination of technical solutions does not exist and is not within the scope of protection claimed in this application.

[0022] In the data reporting process, reports play a crucial role in clarifying the data source, function, and impact; appropriate reports improve data readability. This application provides an information report generation method. This method collects user information and product information from various databases, completes information mapping based on identifiers, queries target product information and obtains corresponding interaction information, and generates a data report based on the mapping relationship between the two, thereby achieving the effect of reflecting the mapping relationship between business logic and product information.

[0023] Please refer to Figure 1 This is a flowchart of the information report generation method provided in the embodiments of this application. The information report generation method includes steps S101-S105.

[0024] Step S101: Collect multiple different user information and multiple product information bound with different interactive information from multiple different databases.

[0025] In step S101, each product information item includes a first product identifier for identifying different products, and the user information corresponds to multiple different second product identifiers. Regarding identifier types, the relationship between the first and second product identifiers is that the second product identifier includes the first product identifier. In other words, the identifiers of the user information include the identifiers of all product information items.

[0026] In some feasible embodiments, the data acquisition process is executed by calling a workflow engine through scheduled tasks. The scheduled tasks are used to schedule any script, program, or document to run at a specified time. Specifically, an Application Programming Interface (API) is provided for the workflow invocation. When configuring the scheduled task, the workflow ID is configured. When the scheduled task is executed, the workflow is invoked using the workflow ID to complete data cleaning and aggregation.

[0027] After collecting the user and product information, the data in the information is configured or modified according to requirements. In this embodiment, multiple data sources are configured using MyBatis (an open-source project of Apache). MyBatis' dynamic loading mechanism for mapper files allows for online SQL writing with real-time effects. When using the database component, the data source, MyBatis, SQLId, and parameter information need to be configured to complete database read, insert, modify, and delete operations.

[0028] Step S102: Obtain the product information corresponding to each user information based on the product identifier.

[0029] In step S102, each user information has one and only one corresponding second product identifier.

[0030] Please refer to the following: Figure 2 This is a flowchart of sub-step S102 provided in the embodiments of this application. Obtaining the product information corresponding to each user information according to the product identifier includes steps S1021-S1023.

[0031] Step S1021: Obtain multiple second product identifiers corresponding to the user information.

[0032] Step S1022: Compare the first product identifier and the second product identifier contained in each product information in sequence to obtain the comparison results.

[0033] In step S1022, the comparison results include a first comparison result indicating that the comparisons are the same and a second comparison result indicating that the comparisons are different.

[0034] Please refer to the following: Figure 3 The flowchart for step S1022 provided in the embodiment of this application is as follows: The first product identifier and the second product identifier contained in each product information are compared sequentially to obtain the comparison result, including steps S10221-S10222.

[0035] Step S10221: When the comparison result is the first comparison result, the user information and product information being compared correspond.

[0036] In step S10221, the corresponding user information and product information can be one or more sets, which will not be elaborated here.

[0037] Step S10222: When the comparison result is the second comparison result, the second product identifier of the current user information and the first product identifier of the next product information are compared sequentially until the comparison result is the first comparison result.

[0038] In step S10222, when the comparison result is the second comparison result, the currently compared product identifier does not correspond. Since the second product identifier includes the first product identifier, the identifier of the current user information is compared with the identifier of the next product information one by one until the current user information corresponds to the current product information.

[0039] Step S1023: Based on the comparison results, obtain the product information corresponding to each user information.

[0040] In step S1023, the comparison result corresponds to the information of the first comparison result.

[0041] Step S103: Query the current user information in the user information.

[0042] After obtaining the corresponding product information from the user information, the user information for which data reports need to be generated is queried according to the requirements and used as the current user information.

[0043] Step S104: Obtain the current interaction information corresponding to the current user information.

[0044] Please refer to the following: Figure 4 This is a flowchart of sub-step S104 provided in the embodiments of this application. Obtaining the current interaction information corresponding to the current user information includes steps S1041-S1042.

[0045] Step S1041: Obtain several corresponding current product information based on the current user information.

[0046] Step S1042: Based on the aforementioned current product information, obtain the current interaction information corresponding to each current product information.

[0047] In step S1042, the current interaction information includes data of the current product information and process information in which the current product information participates.

[0048] After acquiring the current product information and current interaction information, a current data report is generated. This current data report reflects the correspondence between the data and process information in the current product information and current interaction information.

[0049] Step S105: Generate a current data report based on the current interaction information.

[0050] Please refer to the following: Figure 5 The flowchart for step S105 provided in this application embodiment is as follows. Generating the current data report based on the current interaction information includes steps S1051-S1052.

[0051] Step S1051: Obtain the current product information, the data and process information in the current interaction information, and the dependency relationship between the current product information and the data and process information in the current interaction information to obtain several dependency relationship groups. Each dependency relationship group includes a dependent item and a dependent item.

[0052] In step S1051, the dependency is the current product information in the dependency group, and the dependent is the data and process information in the current interaction information in the dependency group.

[0053] Step S1052: Place the dependent items in each group in one column of the current data report, and place the dependent items in each group in another column of the current data report to obtain the current data report.

[0054] Please refer to Figure 6 This is a structural block diagram of the process engine for generating information reports provided in this application embodiment. The process engine 100 for generating information reports includes a data collection component 11, a first acquisition component 21, a query component 31, a second acquisition component 41, and a report generation component 51.

[0055] The data collection component 11 is used to collect multiple different user information and multiple product information bound with different interactive information.

[0056] The first acquisition component 21 is used to acquire product information corresponding to each user information based on the product identifier.

[0057] The query component 31 is used to query the current user information in the user information.

[0058] The second acquisition component 41 is used to acquire the current interaction information corresponding to the current user information.

[0059] The report generation component 51 is used to generate a current data report based on the current interaction information.

[0060] Please refer to Figure 7 This is a schematic diagram of the structure of a computer device for generating information reports provided in an embodiment of this application. The computer device 101 for generating information reports includes a memory 901 and a processor 902. The processor 902 is used to execute computer program instructions in the memory 901 to implement the information report generation method.

[0061] The memory 901 includes at least one type of readable storage medium, including flash memory, hard disk, multimedia card, card-type memory (e.g., SD or DX memory), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the memory 901 can be an internal storage unit of a computer device, such as a hard disk. In other embodiments, the memory 901 can be an external storage device of a computer device, such as a plug-in hard disk, Smart Media Card (SMC), Secure Digital (SD) card, Flash Card, etc., configured in the computer device. Furthermore, the memory 901 can include both internal and external storage units of the computer device. The memory 901 can be used not only to store application software and various types of data installed on the computer device, such as code for information report generation methods, but also to temporarily store data that has been output or will be output.

[0062] In the above embodiments, by collecting user information and product information from multiple databases and completing the information correspondence according to the identifier, querying the target product information and obtaining the corresponding interaction information, and generating data reports based on the correspondence between the two, the system realizes the generation of reports on user information and product information from multiple databases, while accurately reflecting the correspondence between business logic and product information.

[0063] Obviously, those skilled in the art can make various modifications and variations to this application without departing from the spirit and scope of this application. Therefore, if such modifications and variations fall within the scope of the claims of this application and their equivalents, this application also intends to include such modifications and variations.

[0064] The above-listed embodiments are merely preferred embodiments of this application and should not be construed as limiting the scope of this application. Therefore, any equivalent variations made in accordance with the claims of this application shall still fall within the scope of this application.

Claims

1. A method for generating information reports, characterized in that, The information report generation method includes: Collect multiple different user information and multiple product information bound to different interactive information from multiple different databases; Based on the product identifier, obtain the product information corresponding to each user's information; The current user information is retrieved from the user information; Obtain the current interaction information corresponding to the current user information; Generate a current data report based on the current interaction information; The information report generation method further includes, whereby the current data report is used to reflect the correspondence between the data and process information in the current product information and the current interaction information; generating the current data report includes: The system obtains the data and process information in the current product information and the current interaction information, as well as the dependencies between the current product information and the data and process information in the current interaction information, to obtain several dependency relationship groups. Each dependency relationship group includes a dependent item and a dependent item. The dependent item is the current product information in the dependency relationship group, and the dependent item is the data and process information in the current interaction information in the dependency relationship group. The current data report is obtained by placing the dependent items in each group in one column of the current data report and placing the dependent items in each group in another column of the current data report.

2. The information report generation method as described in claim 1, characterized in that, Each product information contains a first product identifier for identifying different products, and the user information corresponds to multiple different second product identifiers.

3. The information report generation method as described in claim 2, characterized in that, Based on the product identifier, obtain the product information corresponding to each user's information, including: Obtain multiple second product identifiers corresponding to the user information; The comparison results are obtained by sequentially comparing the first product identifier and each second product identifier contained in each product information. Based on the comparison results, obtain the product information corresponding to each user's information.

4. The information report generation method as described in claim 3, characterized in that, The comparison results include a first comparison result indicating that the comparisons are the same and a second comparison result indicating that the comparisons are different; the comparison results are obtained by sequentially comparing the first product identifier and each second product identifier contained in each product information, including: When the comparison result is the first comparison result, the user information and product information being compared correspond to each other. When the comparison result is the second comparison result, the second product identifier of the current user information is compared with the first product identifier of the next product information in sequence until the comparison result is the first comparison result.

5. The information report generation method as described in claim 1, characterized in that, Obtaining the current interaction information corresponding to the current user information includes: Based on the current user information, obtain the corresponding current product information; Based on the aforementioned current product information, obtain the current interaction information corresponding to each current product information.

6. The information report generation method as described in claim 1, characterized in that, The current interaction information includes data about the current product information and process information in which the current product information participates.

7. A process engine for generating information reports, characterized in that, The process engine for generating information reports includes: The data collection component is used to collect multiple different user information and multiple product information bound with different interactive information; The first acquisition component is used to obtain the product information corresponding to each user's information based on the product identifier; A query component is used to retrieve the current user information from the user information; The second acquisition component is used to acquire the current interaction information corresponding to the current user information; A report generation component is used to generate a current data report based on the current interaction information; the current data report reflects the correspondence between the current product information and the data and process information in the current interaction information; generating the current data report includes: The system obtains the data and process information in the current product information and the current interaction information, as well as the dependencies between the current product information and the data and process information in the current interaction information, to obtain several dependency relationship groups. Each dependency relationship group includes a dependent item and a dependent item. The dependent item is the current product information in the dependency relationship group, and the dependent item is the data and process information in the current interaction information in the dependency relationship group. The current data report is obtained by placing the dependent items in each group in one column of the current data report and placing the dependent items in each group in another column of the current data report.

8. A computer device for generating information reports, characterized in that, The computer device used to generate information reports includes: Memory, used to store computer programs; and A processor for executing the computer program to implement the information report generation method as described in any one of claims 1-7.

9. A computer-readable storage medium, characterized in that, The storage medium is used to store a computer program, which is executed to implement the information report generation method as described in any one of claims 1-6.

Images