CN113221522A

CN113221522A - Report generation method, device, system, electronic equipment and storage medium

Info

Publication number: CN113221522A
Application number: CN202110470039.XA
Authority: CN
Inventors: 吴晨
Original assignee: Beijing Dajia Internet Information Technology Co Ltd
Current assignee: Beijing Dajia Internet Information Technology Co Ltd
Priority date: 2021-04-28
Filing date: 2021-04-28
Publication date: 2021-08-06
Anticipated expiration: 2041-04-28
Also published as: CN113221522B

Abstract

The disclosure relates to a report generation method, a report generation device, a report generation system, electronic equipment and a storage medium, wherein the method comprises the following steps: responding to a generation request of a target report, and sending an associated data acquisition instruction carrying target identification information of the target report to a configuration server; the configuration server acquires target associated data corresponding to the target identification information based on preset mapping information, wherein the target associated data comprises a target data acquisition mode and target dynamic language data processing logic; receiving a target data acquisition mode and a target dynamic language data processing logic sent by a configuration server; acquiring target original report data corresponding to a target report based on a target data acquisition mode; and generating a target report according to the target dynamic language data processing logic and the target original report data. By using the technical scheme provided by the embodiment of the disclosure, the workload of service deployment and restart can be reduced, and the consumption of system resources in the target report generation process can be reduced.

Description

Report generation method, device, system, electronic equipment and storage medium

Technical Field

The present disclosure relates to the field of internet technologies, and in particular, to a method, an apparatus, a system, an electronic device, and a storage medium for generating a report.

Background

With the continuous expansion of enterprise business, when data generated by a plurality of businesses are faced, the report forms become a preferred mode of data statistics and data analysis.

In the related art, usually, a data format for generating a report is specified in a report generating service, and data acquisition and data processing logic are unified into data source acquisition, so long as data acquired from a data source conforms to a data structure of the report service, the report generating service can analyze the data and generate a corresponding report.

However, in the related art, data acquisition and data processing logic are unified into data source acquisition, which causes severe coupling of the data acquisition and data processing logic, and when the data format is adjusted, the logic needs to be modified at the data source acquisition place, so that the debugging and deployment work of the server is transferred to the data source acquisition, the workload of debugging and deployment of the server in the report generation process is large, and the consumption of the report generation process on system resources is increased.

Disclosure of Invention

The present disclosure provides a report generation method, apparatus, system, electronic device, and storage medium, to at least solve the problem in the related art that the workload of debugging and deploying a server is large in the report generation process, thereby increasing the consumption of system resources in the report generation process. The technical scheme of the disclosure is as follows:

according to a first aspect of the embodiments of the present disclosure, a report generation method is provided, including:

responding to a generation request of a target report, and sending an associated data acquisition instruction of the target report to a configuration server, wherein the associated data acquisition instruction carries target identification information of the target report; the configuration server acquires target associated data corresponding to the target identification information based on preset mapping information, the preset mapping information represents a mapping relation between the identification information and the associated data of the report, and the target associated data comprises a target data acquisition mode and target dynamic language data processing logic;

receiving the target data acquisition mode and the target dynamic language data processing logic sent by the configuration server;

acquiring target original report data corresponding to the target report based on the target data acquisition mode;

and generating the target report according to the target dynamic language data processing logic and the target original report data.

In an exemplary embodiment, if the target associated data further includes target table display attribute information, the generating the target report according to the target dynamic language data processing logic and the target raw report data includes:

calling a local dynamic language engine;

executing the operation corresponding to the target dynamic language data processing logic on the target original report data through the local dynamic language engine to obtain the target report data;

generating a target table according to the target table display attribute information;

and adding the target report data into the target table to obtain the target report.

In an exemplary embodiment, if the target data obtaining manner is generated by the configuration server based on a target data source and a target query statement, the obtaining target original report data corresponding to the target report based on the target data obtaining manner includes:

and acquiring the target original report data from the target data source based on the target query statement.

According to a second aspect of the embodiments of the present disclosure, there is provided a report generation method, including:

receiving a report server, responding to an associated data acquisition instruction of a target report sent by a generation request of the target report, wherein the associated data acquisition instruction carries target identification information of the target report;

acquiring target associated data corresponding to the target identification information based on preset mapping information, wherein the preset mapping information represents a mapping relation between the identification information of the report and the associated data, and the target associated data comprises a target data acquisition mode and target dynamic language data processing logic;

sending the target data acquisition mode and the target dynamic language data processing logic to the report server; the report server acquires target original report data corresponding to the target report based on the target data acquisition mode; and enabling the report server to generate the target report according to the target dynamic language data processing logic and the target original report data.

In an exemplary embodiment, the obtaining of the target associated data corresponding to the target identification information based on the preset mapping information includes:

acquiring the target data acquisition mode corresponding to the target identification information based on the first preset mapping information;

and acquiring the target dynamic language data processing logic corresponding to the target identification information based on the second preset mapping information.

In an exemplary embodiment, before the receiving report server responds to the associated data acquisition instruction of the target report sent by the generation request of the target report, the method further includes:

responding to a configuration instruction of a data source corresponding to at least one report, and generating the data source corresponding to the at least one report;

responding to a configuration instruction of the query statement corresponding to the at least one report, and generating the query statement corresponding to the at least one report;

generating a data acquisition mode corresponding to the at least one report based on the data source corresponding to the at least one report and the query statement;

responding to a configuration instruction for configuring the dynamic language data processing logic corresponding to the at least one report based on the dynamic language, and generating the dynamic language data processing logic corresponding to the at least one report;

and establishing the first preset mapping information between the identification information of the at least one report and the corresponding data acquisition mode, and establishing the second preset mapping information between the identification information of the at least one report and the corresponding dynamic language data processing logic.

In an exemplary embodiment, if the target data obtaining manner is generated based on a target data source and a target query statement, the obtaining the target data obtaining manner corresponding to the target identification information based on the first preset mapping information includes:

and acquiring the target data source and the target query statement corresponding to the target identification information based on the first preset mapping information.

In an exemplary embodiment, the target associated data further includes target table display attribute information, the preset mapping information further includes third preset mapping information, and the third preset mapping information represents a mapping relationship between the identification information of the report and the table display attribute information, before the receiving report server responds to an associated data obtaining instruction of the target report sent by a target report generation request, the method further includes:

responding to a configuration instruction of table display attribute information of at least one report, and generating table display attribute information corresponding to the at least one report;

establishing the third preset mapping information between the identification information of the at least one report and the corresponding table display attribute information;

correspondingly, the obtaining of the target associated data corresponding to the target identification information based on the preset mapping information includes:

acquiring the target table display attribute information corresponding to the target identification information based on the third preset mapping information;

accordingly, the method further comprises:

and sending the target table display attribute information to the report server.

In an exemplary embodiment, the method further comprises:

responding to an update instruction of the associated data, and generating updated associated data;

and updating the preset mapping information based on the updated associated data.

According to a third aspect of the embodiments of the present disclosure, there is provided a report generation system including: a report server and a configuration server;

the report server is used for responding to a generation request of a target report and sending an associated data acquisition instruction of the target report to a configuration server, wherein the associated data acquisition instruction carries target identification information of the target report; the configuration server is used for acquiring target data corresponding to the target report according to the target data acquisition mode returned by the configuration server; the target report is generated according to the target original report data and the target dynamic language data processing logic returned by the configuration server;

the configuration server is used for acquiring target associated data corresponding to the target identification information based on preset mapping information, the preset mapping information represents a mapping relation between the identification information of the report and the associated data, and the target associated data comprises a target data acquisition mode and target dynamic language data processing logic; and the report server is used for sending the target data acquisition mode and the target dynamic language data processing logic to the report server.

According to a fourth aspect of the embodiments of the present disclosure, there is provided a report generation apparatus, including:

the system comprises an associated data acquisition instruction sending module, a configuration server and a data processing module, wherein the associated data acquisition instruction sending module is configured to execute a generation request responding to a target report and send an associated data acquisition instruction of the target report to the configuration server, and the associated data acquisition instruction carries target identification information of the target report; the configuration server acquires target associated data corresponding to the target identification information based on preset mapping information, the preset mapping information represents a mapping relation between the identification information and the associated data of the report, and the target associated data comprises a target data acquisition mode and target dynamic language data processing logic;

the receiving module is configured to execute and receive the target data acquisition mode and the target dynamic language data processing logic sent by the configuration server;

the target original report data acquisition module is configured to execute the target original report data corresponding to the target report based on the target data acquisition mode;

and the target report generation module is configured to execute the target report generation according to the target dynamic language data processing logic and the target original report data.

In an exemplary embodiment, the target associated data further includes target table display attribute information, and the target report generation module includes:

a calling unit configured to perform calling a local dynamic language engine;

the execution unit is configured to execute the operation corresponding to the target dynamic language data processing logic on the target original report data through the local dynamic language engine to obtain the target report data;

a target table generating unit configured to perform generation of a target table according to the target table presentation attribute information;

and the adding unit is configured to add the target report data into the target table to obtain the target report.

In an exemplary embodiment, the target data obtaining manner is generated by the configuration server based on a target data source and a target query statement, and the target raw report data obtaining module is configured to perform obtaining the target raw report data from the target data source based on the target query statement.

According to a fifth aspect of the embodiments of the present disclosure, there is provided a report generation apparatus, including:

the report generation request comprises a correlation data acquisition instruction receiving module, a report generation request receiving module and a report generation request sending module, wherein the correlation data acquisition instruction receiving module is configured to execute a report receiving server and respond to a correlation data acquisition instruction of a target report, and the correlation data acquisition instruction carries target identification information of the target report;

the target associated data acquisition module is configured to execute target associated data corresponding to the target identification information based on preset mapping information, the preset mapping information represents a mapping relation between the identification information of the report and the associated data, and the target associated data comprises a target data acquisition mode and target dynamic language data processing logic;

the sending module is configured to send the target data acquisition mode and the target dynamic language data processing logic to the report server; the report server acquires target original report data corresponding to the target report based on the target data acquisition mode; and enabling the report server to generate the target report according to the target dynamic language data processing logic and the target original report data.

In an exemplary embodiment, the preset mapping information includes first preset mapping information and second preset mapping information, where the first preset mapping information represents a mapping relationship between identifier information of a report and a data obtaining manner, and the second preset mapping information represents a mapping relationship between identifier information of a report and dynamic language data processing logic, and then the target associated data obtaining module includes:

a target data acquisition mode acquisition unit configured to execute acquiring the target data acquisition mode corresponding to the target identification information based on the first preset mapping information;

and the target dynamic language data processing logic acquisition unit is configured to execute the target dynamic language data processing logic corresponding to the target identification information based on the second preset mapping information.

In an exemplary embodiment, the apparatus further comprises:

the data source generating module is configured to execute a configuration instruction of a data source corresponding to at least one report and generate the data source corresponding to the at least one report;

the query statement generation module is configured to execute a configuration instruction responding to the query statement corresponding to the at least one report, and generate the query statement corresponding to the at least one report;

the data acquisition mode generation module is configured to execute data source and query statement corresponding to the at least one report to generate a data acquisition mode corresponding to the at least one report;

the dynamic language data processing logic generation module is configured to execute a configuration instruction for configuring the dynamic language data processing logic corresponding to the at least one report based on a dynamic language, and generate the dynamic language data processing logic corresponding to the at least one report;

the establishing module is configured to execute establishing of the first preset mapping information between the identification information of the at least one report and the corresponding data acquisition mode, and establishing of the second preset mapping information between the identification information of the at least one report and the corresponding dynamic language data processing logic.

In an exemplary embodiment, the target data obtaining manner is generated based on a target data source and a target query statement, and the target data obtaining manner obtaining unit is configured to perform obtaining of the target data source and the target query statement corresponding to the target identification information based on the first preset mapping information.

In an exemplary embodiment, the target associated data further includes target table display attribute information, the preset mapping information further includes third preset mapping information, and the third preset mapping information represents a mapping relationship between the identifier information of the report and the table display attribute information, and then the apparatus further includes:

the table display attribute information generation module is configured to execute a configuration instruction responding to the table display attribute information of at least one report and generate the table display attribute information corresponding to the at least one report;

a third preset mapping information establishing module configured to execute establishing of the third preset mapping information between the identification information of the at least one report and the corresponding table display attribute information;

correspondingly, the target associated data obtaining module is configured to perform obtaining of the target table display attribute information corresponding to the target identification information based on the third preset mapping information;

correspondingly, the device further comprises:

and the target form display attribute information sending module is configured to execute sending of the target form display attribute information to the report server.

In an exemplary embodiment, the apparatus further comprises:

an update instruction response module configured to execute an update instruction in response to the associated data, and generate updated associated data;

an updating module configured to perform updating the preset mapping information based on the updated associated data.

According to a sixth aspect of embodiments of the present disclosure, there is provided an electronic apparatus including:

a processor;

a memory for storing the processor-executable instructions;

wherein the processor is configured to execute the instructions to implement the report generating method according to any of the above embodiments.

According to a seventh aspect of the embodiments of the present disclosure, there is provided a computer-readable storage medium, wherein when the instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device is caused to execute the report generation method according to any one of the above embodiments.

According to an eighth aspect of the embodiments of the present disclosure, there is provided a computer program product, including a computer program, which when executed by a processor implements the report generating method according to any of the above embodiments.

The technical scheme provided by the embodiment of the disclosure at least brings the following beneficial effects:

the method and the device can respond to a generation request of the target report, send the associated data acquisition instruction carrying the target identification information of the target report to the configuration server, and acquire the target associated data which corresponds to the target identification information and comprises a target data acquisition mode and target dynamic language data processing logic by the configuration server according to the preset mapping information. And then, acquiring target original report data corresponding to the target report according to the target data acquisition mode, and generating the target report according to the target dynamic language data processing logic and the target original report data. Because the corresponding target data acquisition mode and the target dynamic language data processing logic can be directly acquired through the configuration server based on the preset mapping information, and the target report is generated according to the target data acquisition mode and the target dynamic language data processing logic, the generation process of the target report is simple, the workload of service deployment and restart in the process is small, and the consumption of system resources in the generation process of the target report is reduced.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and, together with the description, serve to explain the principles of the disclosure and are not to be construed as limiting the disclosure.

FIG. 1 is a schematic diagram of an application environment of a report generation method according to an exemplary embodiment.

FIG. 2 is a flow diagram illustrating a report generation method in accordance with an exemplary embodiment.

FIG. 3 is a flow diagram illustrating another report generation method in accordance with an illustrative embodiment.

FIG. 4 is a flow diagram illustrating configuration association data according to an example embodiment.

FIG. 5 is a task configuration page diagram illustrating one manner of configuration data acquisition and dynamic language data processing logic, according to an example embodiment.

FIG. 6 is a diagram illustrating a common template configuration page for a configuration form showing attribute information according to an exemplary embodiment.

Fig. 7 is a diagram illustrating Markdown text corresponding to a target table in accordance with an exemplary embodiment.

FIG. 8 is a schematic diagram illustrating a goal table according to an exemplary embodiment.

FIG. 9 is a flowchart illustrating another report generation method in accordance with an illustrative embodiment.

FIG. 10 is a flow diagram illustrating another report generation method in accordance with an illustrative embodiment.

FIG. 11 is a block diagram illustrating a report generation apparatus according to an example embodiment.

FIG. 12 is a block diagram illustrating another report generation apparatus according to an example embodiment.

FIG. 13 is a block diagram illustrating an electronic device for report generation in accordance with an exemplary embodiment.

Detailed Description

In order to make the technical solutions of the present disclosure better understood by those of ordinary skill in the art, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below with reference to the accompanying drawings.

It should be noted that the terms "first," "second," and the like in the description and claims of the present disclosure and in the above-described drawings are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the disclosure described herein are capable of operation in sequences other than those illustrated or otherwise described herein. The implementations described in the exemplary embodiments below are not intended to represent all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present disclosure, as detailed in the appended claims.

Referring to fig. 1, fig. 1 is a schematic diagram illustrating an application environment of a report generation method according to an exemplary embodiment, and as shown in fig. 1, the application environment may include a client 01, a report server 02, a configuration server 03 and a data source 04.

The client 01 may be configured to send a configuration instruction (including a data acquisition mode configuration instruction, a dynamic language data processing logic configuration instruction, a form presentation attribute information configuration instruction, and the like) to the configuration server 03, so that the configuration server 03 generates associated data (including a data acquisition mode of a report, a dynamic language data processing logic, a form presentation attribute information, and the like) in response to the configuration instruction. Alternatively, client 01 includes, but is not limited to, a smart phone, desktop computer, tablet computer, laptop computer, smart speaker, digital assistant, and the like type of electronic device. The software running on the electronic device may be an application program, an applet, or the like. Optionally, the operating system running on the electronic device may include, but is not limited to, an android system, an IOS system, linux, windows, and the like. The client 01 may be directly or indirectly connected with the configuration server 03 through a wired or wireless communication manner, and the disclosure is not limited herein.

The report server 02 may be configured to send an associated data obtaining instruction carrying target identification information of the target report to the configuration server 03, obtain target original report data corresponding to the target report from the data source 04 according to a target data obtaining manner returned by the configuration server 03, and generate the target report according to the target original report data and the target dynamic language data processing logic returned by the configuration server 03.

The configuration server 03 may be configured to receive the associated data acquisition instruction sent by the report server 02, and acquire target associated data including a target data acquisition mode and a target dynamic language data processing logic based on preset mapping information.

Optionally, the report server 02, the configuration server 03, and the data source 04 may be independent physical servers, may also be a server cluster or a distributed system formed by a plurality of physical servers, and may also be cloud servers that provide basic cloud computing services such as cloud service, a cloud database, cloud computing, a cloud function, cloud storage, Network service, cloud communication, middleware service, domain name service, security service, Content Delivery Network (CDN), and a big data and artificial intelligence platform.

In addition, it should be noted that fig. 1 shows only one application environment of the report generation method provided by the present disclosure, and in practical applications, other application environments may also be included.

FIG. 2 is a flowchart illustrating a report generation method according to an exemplary embodiment, and as shown in FIG. 2, the method may be used in the system including the client, the report server, the configuration server and the data source in FIG. 1, and may include the following steps.

In step S11, the report server sends, in response to the request for generating the target report, an associated data obtaining instruction of the target report to the configuration server, where the associated data obtaining instruction carries the target identification information of the target report.

In the embodiment of the present disclosure, when a report needs to be generated, a generation request of a target report may be sent to a report server, where the generation request may carry target identification information of the target report.

Illustratively, a timing task may be set, and the generation request is automatically and periodically sent to the report server by the timing task. By sending the generation request at regular time through the timed task, the efficiency and the automation degree of the generation of the target report can be improved.

For example, the generation request is sent to the report server, and may also be sent by the client on demand and at a non-regular time, that is, when a user (e.g., a developer) corresponding to the client wants to generate a report, the generation request is sent to the report server. The client sends the generation request as required, so that the flexibility of generating the target report can be improved, and the consumption of system resources in the generation process of the target report is reduced.

Specifically, the target identification information represents an Identity identification number (ID) of the target report, and is used for uniquely identifying the target report.

In the embodiment of the present disclosure, after the report server receives the generation request sent by the timing task or the client, the report server may send an associated data acquisition instruction carrying the target identification information to the configuration server in response to the generation request.

Illustratively, the associated data acquisition instruction is used for acquiring associated data of the target report. The associated data characterizes data associated with generating the target report.

In step S13, the configuration server obtains target associated data corresponding to the target identification information based on preset mapping information, where the preset mapping information represents a mapping relationship between the identification information of the report and the associated data, and the target associated data includes a target data obtaining manner and a target dynamic language data processing logic.

In the embodiment of the disclosure, the configuration server is configured with the associated data and the preset mapping information between the identification information of the report and the associated data in advance.

Optionally, the association data may include: data acquisition mode, dynamic language data processing logic, table display attribute information, and the like. The data acquisition mode represents a mode of acquiring original report data from a corresponding data source through a corresponding query statement or link. The dynamic language data processing logic is compiled from a dynamic language, and represents the logic for processing the original report data to obtain the report data required by the generated report. The table display attribute information represents information required for displaying the table.

After receiving the associated data acquisition instruction, the configuration server may acquire target associated data corresponding to the target identification information according to the preset mapping information, where the target associated data may include a target data acquisition mode and a target dynamic language data processing logic. Specifically, the target data obtaining mode represents a mode of obtaining target original report data from a target data source through a target query statement or target connection, the target dynamic language data processing logic is compiled by a dynamic language, and the representation processes the target original data to obtain the logic of the target report data required by generating the target report.

In an alternative embodiment, FIG. 3 is a flow chart illustrating another report generation method according to an exemplary embodiment. As shown in fig. 3, the preset mapping information may include first preset mapping information and second preset mapping information, where the first preset mapping information represents a mapping relationship between the identifier of the report and the data obtaining manner, and the second preset mapping information represents a mapping relationship between the identifier of the report and the dynamic language data processing logic, and in step S13, the obtaining, by the configuration server, target associated data corresponding to the target identifier based on the preset mapping information may include:

in step S131, the configuration server obtains the target data obtaining manner corresponding to the target identification information based on the first preset mapping information.

In step S133, the configuration server obtains the target dynamic language data processing logic corresponding to the target identification information based on the second preset mapping information.

In the embodiment of the disclosure, the configuration server is configured with the associated data and the preset mapping information between the identification information of the report and the associated data in advance. When generating the report, the configuration server may directly obtain the corresponding target data obtaining mode and the target dynamic language data processing logic according to the first preset mapping information and the second preset mapping information configured in advance, respectively. The target data acquisition mode and the target dynamic language data processing logic are more convenient to acquire, so that the generation efficiency of the target report is improved. And because the configuration server is directly configured with the related data, the problems of resource waste, high cost and the like caused by the fact that the usage depends on external storage data are avoided, and therefore the cost of generating the report and the consumption of system resources in the report generating process are reduced.

In an alternative embodiment, FIG. 4 is a flow diagram illustrating configuration association data according to an example embodiment. As shown in fig. 4, before the report server responds to the generation request of the target report and sends the associated data obtaining instruction of the target report to the configuration server, the method may further include: in step S01, the data acquisition method and the dynamic language data processing logic of the report are configured in the configuration server. Illustratively, the data obtaining manner and the dynamic language data processing logic of the configuration report may include:

in step S011, the configuration server generates a data source corresponding to the at least one report in response to a configuration instruction of the data source corresponding to the at least one report.

In step S013, the configuration server generates a query statement corresponding to the at least one report in response to the configuration command of the query statement corresponding to the at least one report.

In step S015, the configuration server generates a data obtaining manner corresponding to the at least one report based on the data source and the query statement corresponding to the at least one report.

In step S017, the configuration server generates the dynamic language data processing logic corresponding to the at least one report in response to a configuration instruction for configuring the dynamic language data processing logic corresponding to the at least one report based on the dynamic language.

In step S019, the configuration server establishes the first preset mapping information between the identifier information of the at least one report and the corresponding data obtaining manner, and establishes the second preset mapping information between the identifier information of the at least one report and the corresponding dynamic language data processing logic.

In a specific embodiment, when the configuration server performs data acquisition mode and dynamic language data processing logic configuration, the business party may first provide a business report requirement, and send the business report requirement to the developer, the developer sends a report task configuration instruction to the report server, and the report server responds to the report task configuration instruction to generate a corresponding report configuration task. Then, the developer writes the dynamic language data processing logic based on the dynamic language (JavaScript), and obtains a data acquisition mode (generated by a data source and a query statement) from the data staff. In the above steps S011 to S015, a user (e.g., a developer) corresponding to the client may send a configuration instruction of the data source and a configuration instruction of the query statement corresponding to the at least one report to the configuration server, and the configuration server generates the data source and the query statement corresponding to the at least one report in response to the configuration instruction, and generates the data obtaining manner corresponding to the at least one report based on the data source and the query statement corresponding to the at least one report. In step S017, a user (e.g., a developer) corresponding to the client may also send a configuration instruction for configuring the dynamic language data processing logic corresponding to the at least one report to the configuration server, and the configuration server responds to the configuration instruction to generate the dynamic language data processing logic corresponding to the at least one report. In step S019, after the configuration is completed, the configuration server may establish the first preset mapping information and the second preset mapping information.

In a specific embodiment, the configuration server is configured with a data source and a query statement, and the data acquisition manner is generated based on the data source and the query statement. In step S131, the acquiring, by the configuration server, the target data corresponding to the target identification information based on the first preset mapping information may include:

and the configuration server acquires the target data source and the target query statement corresponding to the target identification information based on the first preset mapping information.

Specifically, the data source characterizes the source of the data that generated the report. The data sources for different services are different, and optionally, the data sources can be data warehouse tools (hives) or interfaces. That is, depending on the service, data may be acquired from hive or from the interface.

In particular, the query statement characterizes the statement that retrieves data from the data source. Alternatively, the Query statement may be a Structured Query Statement (SQL).

Specifically, the dynamic language data processing logic is written by a developer using a dynamic language.

In an alternative embodiment, FIG. 5 is a schematic diagram of a task configuration page illustrating a configuration data acquisition mode and dynamic language data processing logic, according to an example embodiment. As shown in fig. 5, in the task configuration page, not only the data source (e.g., hive), the query statement, and the dynamic language data processing logic may be configured, but also the task name may be configured, where the task name may be a name of a target report to be generated (e.g., a test data report, a statistical data report, and the like), so that each report is configured with a corresponding data acquisition mode and a corresponding dynamic language data processing logic.

In the embodiment of the disclosure, the data acquisition mode and the dynamic language data processing logic are configured in the configuration server, so that both the data acquisition mode and the dynamic language data processing logic can be configured, that is, only the configuration server needs to respond to the configuration instruction of a developer and pay attention to the simple configuration of the data acquisition mode and the dynamic language data processing logic of the data, thereby avoiding the problem of large workload caused by directly modifying the logic in a data source, greatly reducing the workload of the system in response to the development, debugging, deployment and other work of the developer, and further reducing the cost of generating the report and the consumption of the report generating process on system resources. In addition, because the dynamic language data processing logic is obtained through dynamic language configuration in the configuration server, the problem of dependence of various packages does not need to be considered in the transmission process of the dynamic language, the problem that the dynamic language data processing logic cannot be normally executed due to dependence on other packages can be effectively avoided, the execution precision of the subsequent dynamic language data processing logic is improved, and the generation precision of the target report is further improved.

In another optional embodiment, continuing as shown in fig. 4, the target associated data may further include target table display attribute information, the preset mapping information may further include third preset mapping information, and the third preset mapping information represents a mapping relationship between the identification information of the report and the table display attribute information, before the report server responds to a generation request of the target report and sends an associated data obtaining instruction of the target report to the configuration server, the method may further include: in step S02, the form presentation attribute information of the report form is configured in the configuration server. Illustratively, the table showing attribute information of the configuration report may include:

in step S021, the configuration server responds to the configuration instruction of the table display attribute information of the at least one report, and generates the table display attribute information corresponding to the at least one report.

In step S023, the configuration server establishes the third preset mapping information between the identifier information of the at least one report and the corresponding table display attribute information.

Illustratively, the table presentation attribute information characterizes information required to present the report. Optionally, the table showing attribute information may include, but is not limited to: title, header, etc.

In this disclosure, the target associated data may further include target table display attribute information, and the preset mapping information may further include identification information representing the report and third preset mapping information of the table display attribute information. Besides configuring the data acquisition mode and the dynamic language data processing logic in the configuration server, a developer can also configure form presentation attribute information required for presenting the form.

In an alternative embodiment, fig. 6 is a diagram illustrating a common template configuration page of a configuration form showing attribute information according to an exemplary embodiment. As shown in fig. 6, a title (for example, a template sharing rate ranking, etc.), a header (a template chinese name, an export rate, a sharing number, a sharing rate, etc.), a field list, and the like may be configured in the common template configuration page. Where the field list is a one-to-one correspondence of fields to task names and headers. In addition, task names (such as a test data report, a statistical data report, and the like) can be configured in the public configuration page, so that a mapping relationship between each report and table display attribute information is established.

As the table display attribute information may be configured in the configuration server, and a third mapping relationship between the table and the corresponding table display attribute information is established, as shown in fig. 3, in step S13, the configuration server obtains the target association data corresponding to the target identification information based on preset mapping information, and the method may further include:

in step S135, the configuration server obtains the target table display attribute information corresponding to the target identifier information based on the third preset mapping information.

Because report requirements of different services are different, in the embodiment of the disclosure, the table display attribute information (title, header, etc.) is configured in the configuration server, and different types of tables can be generated according to different services, so that the generated table can be displayed to the user more clearly and friendly in the following process, and the capability of the system for visually displaying information to the user is improved.

In step S15, the configuration server sends the target data acquisition method and the target dynamic language data processing logic to the report server.

In the embodiment of the present disclosure, after the configuration server obtains the target data obtaining manner and the target dynamic language data processing logic, the configuration server may send the target data obtaining manner and the target dynamic language data processing logic to the report server.

Since the target related data may further include the target table display attribute information, in an optional embodiment, as shown in fig. 3, the step S15 may further include:

and the configuration server sends the target form display attribute information to the report server.

In step S17, the report server obtains target original report data corresponding to the target report based on the target data obtaining manner.

In an optional embodiment, since the target data obtaining manner is generated by the target data source and the data query statement, in step S17, the obtaining, by the report server, target original report data corresponding to the target report based on the target data obtaining manner may include: and the report server acquires the target original report data from the target data source based on the target query statement. Continuing with fig. 3, it may specifically be: and the report server sends a data acquisition request to a target data source, wherein the data acquisition request carries the target query statement, the target data source queries according to the target query statement to obtain the target original report data, and sends the target original report data to the report server.

The method and the device have the advantages that the target original report data are obtained from the target data source, and the pre-configured target dynamic language data processing logic is obtained from the configuration server, so that the data source and the data processing logic can be decoupled, the defect that the debugging and deployment workload of the server is large due to the fact that the data obtaining and data processing logic is unified into the data source is avoided, and the cost for generating the report and the consumption of system resources in the report generating process are further reduced.

In step S19, the report server generates the target report according to the target dynamic language data processing logic and the target original report data.

In an alternative embodiment, continuing with fig. 3, in step S19, the generating, by the report server, the target report according to the target dynamic language data processing logic and the target raw report data may include:

in step S191, the report server calls a local dynamic language engine.

In step S193, the report server executes, through the local dynamic language engine, an operation corresponding to the target dynamic language data processing logic on the target original report data to obtain the target report data.

In step S195, the report server generates a target table according to the target table display attribute information.

In step S197, the report server adds the target report data to the target table to obtain the target report.

Illustratively, when embodiments of the present disclosure rely on a Java environment, the local dynamic language engine may be a jdk's own JavaScript engine. Wherein jdk refers to the development environment of Java language, and the jdk itself has a JavaScript engine built therein for executing JavaScript scripts (i.e. target dynamic language data processing logic).

For example, when the target table presentation attribute information includes a header and a title, in step S195, the generating, by the report server, the target table according to the target table presentation attribute information may include: and the report server generates a target table according to the table header and the title.

Fig. 7 is a diagram illustrating Markdown text corresponding to a target form, where Markdown is a lightweight markup language, according to an example embodiment. FIG. 8 is a schematic diagram illustrating a goal table according to an exemplary embodiment. FIG. 8 is a diagram illustrating the paste of FIG. 7 in a related parsing tool for parsing. Assuming that as shown in fig. 5 and fig. 6, the current task name is "test data report," which is titled "template sharing rate ranking," and the header includes "template chinese name," "export number," "sharing number," and "sharing rate," the target dynamic data language processing logic includes: 1. selecting a derivative number greater than 1000; 2. sort by number of shares/number of exports (export share rate); 3. the first 3 data are intercepted. In step S193, the report server processes the target original report data, screens out target original data with a export number greater than 1000 from the target original report data, sorts the screened target original data according to the sharing number/export number (export rate), and finally selects the data of the top 3 of the sorted target report data as the target report data. In step S195, a target table is generated based on the current task name (test data report), the title (template sharing rate ranking), and the header (template chinese name, export number, sharing rate). Finally, in step S197, the target report data of the top 3 of the sequence is added to the target table, so as to obtain the target table shown in fig. 8.

In the embodiment of the disclosure, the function of service deployment can be completed through the target dynamic language data processing logic (e.g., JavaScript script) and the local dynamic language engine (e.g., the JavaScript engine of the jdk itself), without depending on an external analysis tool, thereby greatly reducing the workload of system deployment and repeated service restart caused by the system responding to the development, debugging, deployment and other instructions of developers, and reducing the cost of target table generation and the consumption of system resources caused in the target table generation process.

In an alternative embodiment, continuing with fig. 4, the method may further include: in step S03, the configuration server updates the associated data. Illustratively, the updating the association data at the configuration server may include:

in step S031, the configuration server generates updated association data in response to the update instruction of the association data.

In step S033, the configuration server updates the preset mapping information based on the updated associated data.

In the embodiment of the present disclosure, since the associated data (including a data obtaining manner, a dynamic language data processing logic, table display attribute information, and the like) may be configured, when a task needs to be updated (for example, added, deleted, or modified), a user (for example, a developer) corresponding to the client sends a data update instruction to the configuration server, and the configuration server responds to the update instruction and executes corresponding update configuration. The change of the associated data is effective when the next task is executed, the work of service deployment and restarting is not required, the workload and the cost of generating the target report are reduced, and the consumption of the target report generating process to system resources is reduced.

In the following, a report server is taken as an execution subject to describe a report generation method of the present disclosure, and fig. 9 is a flowchart illustrating another report generation method according to an exemplary embodiment. As shown in fig. 9, may include:

in step S21, in response to a request for generating a target report, sending an associated data obtaining instruction of the target report to a configuration server, where the associated data obtaining instruction carries target identification information of the target report; and the configuration server acquires target associated data corresponding to the target identification information based on preset mapping information, the preset mapping information represents a mapping relation between the identification information of the report and the associated data, and the target associated data comprises a target data acquisition mode and target dynamic language data processing logic.

In step S23, the target data acquisition method and the target dynamic language data processing logic transmitted by the configuration server are received.

In step S25, target original report data corresponding to the target report is obtained based on the target data obtaining manner.

In step S27, the target report is generated according to the target dynamic language data processing logic and the target original report data.

In an exemplary embodiment, the generating the target report according to the target dynamic language data processing logic and the target raw report data further includes:

a local dynamic language engine is invoked.

And executing the operation corresponding to the target dynamic language data processing logic on the target original report data through the local dynamic language engine to obtain the target report data.

And generating a target table according to the target table display attribute information.

In an exemplary embodiment, the obtaining, by the configuration server, the target data obtaining manner based on a target data source and a target query statement, and then obtaining, based on the target data obtaining manner, target original report data corresponding to the target report may include:

A report generation method according to the present disclosure is described below with a configuration server as an execution subject, and fig. 10 is a flowchart illustrating another report generation method according to an exemplary embodiment. As shown in fig. 10, may include:

in step S31, the receiving report server responds to the associated data obtaining instruction of the target report sent by the target report generation request, where the associated data obtaining instruction carries the target identification information of the target report.

In step S33, based on preset mapping information, target associated data corresponding to the target identification information is obtained, where the preset mapping information represents a mapping relationship between the identification information of the report and the associated data, and the target associated data includes a target data obtaining manner and a target dynamic language data processing logic.

In step S35, sending the target data acquisition mode and the target dynamic language data processing logic to the report server; the report server acquires target original report data corresponding to the target report based on the target data acquisition mode; and enabling the report server to generate the target report according to the target dynamic language data processing logic and the target original report data.

In an exemplary embodiment, the obtaining of the target associated data corresponding to the target identification information based on the preset mapping information may include:

and acquiring the target data acquisition mode corresponding to the target identification information based on the first preset mapping information.

In an exemplary embodiment, before the receiving report server responds to the relevant data obtaining instruction of the target report sent by the generation request of the target report, the method may further include:

and responding to the configuration instruction of the data source corresponding to at least one report to generate the data source corresponding to the at least one report.

And responding to the configuration instruction of the query statement corresponding to the at least one report to generate the query statement corresponding to the at least one report.

And generating a data acquisition mode corresponding to the at least one report based on the data source and the query statement corresponding to the at least one report.

And responding to a configuration instruction for configuring the dynamic language data processing logic corresponding to the at least one report based on the dynamic language, and generating the dynamic language data processing logic corresponding to the at least one report.

In an exemplary embodiment, if the target data obtaining manner is generated based on a target data source and a target query statement, the obtaining the target data obtaining manner corresponding to the target identification information based on the first preset mapping information may include:

In an exemplary embodiment, the target associated data further includes target table display attribute information, the preset mapping information further includes third preset mapping information, and the third preset mapping information represents a mapping relationship between identification information of a report and the table display attribute information, and before the report receiving server responds to an associated data obtaining instruction of the target report sent by a target report generation request, the method may further include:

and responding to a configuration instruction of the table display attribute information of at least one report to generate the table display attribute information corresponding to the at least one report.

And establishing the third preset mapping information between the identification information of the at least one report and the corresponding table display attribute information.

Correspondingly, the obtaining of the target associated data corresponding to the target identification information based on the preset mapping information may include:

and acquiring the target table display attribute information corresponding to the target identification information based on the third preset mapping information.

Correspondingly, the method may further include:

In an exemplary embodiment, the method may further include:

and generating updated associated data in response to the update instruction of the associated data.

FIG. 11 is a block diagram illustrating a report generation apparatus according to an example embodiment. Referring to fig. 11, the apparatus may include an associated data acquisition instruction transmitting module 41, a receiving module 43, a target raw report data acquiring module 45, and a target report generating module 47.

The associated data obtaining instruction sending module 41 is configured to execute a generation request in response to a target report, and send an associated data obtaining instruction of the target report to a configuration server, where the associated data obtaining instruction carries target identification information of the target report; and the configuration server acquires target associated data corresponding to the target identification information based on preset mapping information, the preset mapping information represents a mapping relation between the identification information of the report and the associated data, and the target associated data comprises a target data acquisition mode and target dynamic language data processing logic.

The receiving module 43 is configured to execute the target data obtaining method and the target dynamic language data processing logic sent by the configuration server.

The target original report data obtaining module 45 is configured to execute obtaining of target original report data corresponding to the target report based on the target data obtaining manner.

The target report generation module 47 is configured to execute the target dynamic language data processing logic and the target original report data to generate the target report.

In an exemplary embodiment, the target associated data further includes target table display attribute information, and the target report generation module 47 may include:

a calling unit configured to perform calling the local dynamic language engine.

And the execution unit is configured to execute the operation corresponding to the target dynamic language data processing logic on the target original report data through the local dynamic language engine to obtain the target report data.

And the target table generating unit is configured to generate a target table according to the target table display attribute information.

In an exemplary embodiment, the target data obtaining manner is generated by the configuration server based on a target data source and a target query statement, and the target raw report data obtaining module 45 is configured to perform obtaining the target raw report data from the target data source based on the target query statement.

FIG. 12 is a block diagram illustrating another report generation apparatus according to an example embodiment. Referring to fig. 12, the apparatus may include an association data acquisition instruction receiving module 51, a target association data acquisition module 53, and a transmitting module 55.

The associated data obtaining instruction receiving module 51 is configured to execute a report receiving server, and respond to an associated data obtaining instruction of a target report sent by a target report generation request, where the associated data obtaining instruction carries target identification information of the target report.

The target associated data obtaining module 53 is configured to perform obtaining target associated data corresponding to the target identification information based on preset mapping information, where the preset mapping information represents a mapping relationship between the identification information of the report and the associated data, and the target associated data includes a target data obtaining manner and a target dynamic language data processing logic.

The sending module 55 is configured to execute sending the target data obtaining manner and the target dynamic language data processing logic to the report server; the report server acquires target original report data corresponding to the target report based on the target data acquisition mode; and enabling the report server to generate the target report according to the target dynamic language data processing logic and the target original report data.

In an exemplary embodiment, the preset mapping information includes a first preset mapping information and a second preset mapping information, where the first preset mapping information represents a mapping relationship between the identifier information of the report and the data obtaining manner, and the second preset mapping information represents a mapping relationship between the identifier information of the report and the dynamic language data processing logic, and then the target associated data obtaining module 53 may include:

and a target data acquisition mode acquisition unit configured to execute acquiring the target data acquisition mode corresponding to the target identification information based on the first preset mapping information.

And a target dynamic language data processing logic obtaining unit configured to execute the target dynamic language data processing logic corresponding to the target identification information based on the second preset mapping information.

In an exemplary embodiment, the apparatus may further include:

and the data source generating module is configured to execute a configuration instruction in response to the data source corresponding to the at least one report, and generate the data source corresponding to the at least one report.

And the query statement generation module is configured to execute a configuration instruction responding to the query statement corresponding to the at least one report, and generate the query statement corresponding to the at least one report.

And the data acquisition mode generation module is configured to execute a data source and a query statement corresponding to the at least one report to generate a data acquisition mode corresponding to the at least one report.

And the dynamic language data processing logic generation module is configured to execute a configuration instruction for configuring the dynamic language data processing logic corresponding to the at least one report based on the dynamic language, and generate the dynamic language data processing logic corresponding to the at least one report.

And the establishing module is configured to execute establishing the first preset mapping information between the identification information of the at least one report and the corresponding data acquisition mode, and establishing the second preset mapping information between the identification information of the at least one report and the corresponding dynamic language data processing logic.

In an exemplary embodiment, the target related data further includes target table display attribute information, the preset mapping information further includes third preset mapping information, and the third preset mapping information represents a mapping relationship between the identifier information of the report and the table display attribute information, and the apparatus may further include:

and the table display attribute information generation module is configured to execute a configuration instruction responding to the table display attribute information of at least one report and generate the table display attribute information corresponding to the at least one report.

A third preset mapping information establishing module configured to execute establishing of the third preset mapping information between the identification information of the at least one report and the corresponding table display attribute information.

Correspondingly, the target associated data obtaining module is configured to perform obtaining of the target table display attribute information corresponding to the target identification information based on the third preset mapping information.

Correspondingly, the above apparatus may further include:

In an exemplary embodiment, the apparatus may further include:

and the update instruction response module is configured to execute an update instruction responding to the associated data and generate updated associated data.

And the updating module is configured to update the preset mapping information based on the updated associated data.

In an exemplary embodiment, there is further provided a report generation system, including: report server and the above configuration server.

The report server may be configured to send, in response to a request for generating a target report, an associated data obtaining instruction of the target report to a configuration server, where the associated data obtaining instruction carries target identification information of the target report; the configuration server is used for acquiring target data corresponding to the target report according to the target data acquisition mode returned by the configuration server; and the system is used for generating the target report according to the target original report data and the target dynamic language data processing logic returned by the configuration server.

The configuration server may be configured to obtain target associated data corresponding to the target identification information based on preset mapping information, where the preset mapping information represents a mapping relationship between identification information of a report and associated data, and the target associated data includes a target data obtaining manner and a target dynamic language data processing logic; and the report server is used for sending the target data acquisition mode and the target dynamic language data processing logic to the report server.

With regard to the apparatus in the above-described embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.

In an exemplary embodiment, there is also provided an electronic device, comprising a processor; a memory for storing processor-executable instructions; wherein, the processor is configured to implement the steps of any report generation method in the above embodiments when executing the instructions stored in the memory.

The electronic device may be a terminal, a server, or a similar computing device, taking the electronic device as a server as an example, fig. 13 is a block diagram of an electronic device for report generation according to an exemplary embodiment, where the electronic device 60 may generate a relatively large difference due to different configurations or performances, and may include one or more Central Processing Units (CPUs) 61 (the CPU 61 may include but is not limited to a Processing device such as a microprocessor MCU or a programmable logic device FPGA, etc.), a memory 63 for storing data, and one or more storage media 62 (e.g., one or more mass storage devices) for storing an application program 623 or data 622. Memory 63 and storage medium 62 may be, among other things, transient or persistent storage. The program stored on the storage medium 62 may include one or more modules, each of which may include a sequence of instructions operating on the electronic device. Still further, the central processor 61 may be arranged to communicate with the storage medium 62, and execute a series of instruction operations in the storage medium 62 on the electronic device 60. The electronic device 60 may also include one or more power supplies 66, one or more wired or wireless network interfaces 65, one or more input-output interfaces 64, and/or one or more operating systems 621, such as Windows ServerTM, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM, and so forth.

The input/output interface 64 may be used to receive or transmit data via a network. Specific examples of the network described above may include a wireless network provided by a communication provider of the electronic device 60. In one example, the input/output Interface 64 includes a Network adapter (NIC) that can be connected to other Network devices through a base station to communicate with the internet. In an exemplary embodiment, the input/output interface 64 may be a Radio Frequency (RF) module, which is used for communicating with the internet in a wireless manner.

It will be understood by those skilled in the art that the structure shown in fig. 13 is only an illustration, and is not intended to limit the structure of the electronic device. For example, electronic device 60 may also include more or fewer components than shown in FIG. 13, or have a different configuration than shown in FIG. 13.

In an exemplary embodiment, there is also provided a computer-readable storage medium, wherein instructions of the computer-readable storage medium, when executed by a processor of an electronic device, enable the electronic device to perform the steps of any one of the report generation methods in the above embodiments.

In an exemplary embodiment, there is also provided a computer program product comprising a computer program which, when executed by a processor, implements the report generation method provided in any one of the above embodiments.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided by the present disclosure may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.

It will be understood that the present disclosure is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A report generation method is characterized by comprising the following steps:

2. The report generation method according to claim 1, wherein the target associated data further includes target table presentation attribute information, and the generating the target report according to the target dynamic language data processing logic and the target raw report data includes:

calling a local dynamic language engine;

3. A report generation method is characterized by comprising the following steps:

4. A report generation method according to claim 3, wherein the preset mapping information includes first preset mapping information and second preset mapping information, the first preset mapping information represents a mapping relationship between the identification information of the report and a data acquisition manner, and the second preset mapping information represents a mapping relationship between the identification information of the report and a dynamic language data processing logic, and then the acquiring of the target associated data corresponding to the target identification information based on the preset mapping information includes:

5. The report generation method according to claim 4, wherein before the receiving report server receives the associated data acquisition instruction of the target report sent in response to the generation request of the target report, the method further comprises:

6. A report generation method according to claim 3, wherein the target associated data further includes target table display attribute information, the preset mapping information further includes third preset mapping information, and the third preset mapping information represents a mapping relationship between the identification information of the report and the table display attribute information, and before the receiving report server receives the associated data acquisition instruction of the target report sent in response to the generation request of the target report, the method further includes:

accordingly, the method further comprises:

7. A report generation system, comprising: a report server and a configuration server;

8. A report generation apparatus, comprising:

9. An electronic device, comprising:

a processor;

a memory for storing the processor-executable instructions;

wherein the processor is configured to execute the instructions to implement the report generating method according to any of claims 1 to 6.

10. A computer-readable storage medium, wherein the instructions, when executed by a processor of an electronic device, cause the electronic device to perform the report generation method of any of claims 1-6.