CN-121979883-A - Data report generation device, storage medium and electronic device

CN121979883ACN 121979883 ACN121979883 ACN 121979883ACN-121979883-A

Abstract

The application discloses a generation device, a storage medium and an electronic device of a data report, and relates to the technical field of data processing, wherein the generation of the data report comprises the steps of generating an index library according to a plurality of index calculation rules and data of different data sources; generating a first index set according to an index subscription request of the target object, wherein the index subscription request comprises at least one index subscribed by the target object from the index library, the first index set comprises all indexes subscribed by the target object, responding to an index issuing instruction of the target object, acquiring first index data corresponding to the first index set from the index library, and generating a first data report according to the first index data. By adopting the technical scheme, the problem of how to improve the generation efficiency of the data report is solved.

Inventors

CHENG BO
YIN DESHUAI
ZHANG YUNHAO
HU BAICHUN

Assignees

青岛海尔科技有限公司
海尔优家智能科技（北京）有限公司
青岛海尔智能家电科技有限公司

Dates

Publication Date: 20260505
Application Date: 20251229

Claims (10)

1. The method for generating the data report is characterized by comprising the following steps: generating an index library according to a plurality of index calculation rules and data of different data sources; generating a first index set according to an index subscription request of the target object, wherein the index subscription request comprises at least one index subscribed by the target object from the index library, and the first index set comprises all indexes subscribed by the target object; and responding to an index issuing instruction of the target object, acquiring first index data corresponding to the first index set from the index library, and generating a first data report according to the first index data.
2. The method of generating a data report according to claim 1, wherein generating an index library from a plurality of index calculation rules and data of different data sources comprises: determining an index calculation rule of any index aiming at any index in the index library, and determining an index monitoring parameter required by the index calculation rule when calculating index data of any index; Determining different data sources associated with the index monitoring parameters, and acquiring parameter values of the index monitoring parameters from the different data sources; Calculating the parameter value of the index monitoring parameter according to the index calculation rule to obtain index data of any index; and generating a group of data corresponding to any one index according to the index calculation rule by using the different data sources and the index data, and determining the index library based on a plurality of groups of data corresponding to a plurality of indexes.
3. The method of claim 2, wherein obtaining parameter values of the index monitoring parameters from the different data sources comprises: acquiring original data from each data source for the different data sources; carrying out data analysis on the original data according to a data analysis rule preset for each data source to obtain analysis data; and carrying out unified formatting treatment on the analysis data to obtain the parameter value of the index monitoring parameter.
4. The method of generating a data report according to claim 1, wherein after generating a first data report from the first index data, the method further comprises: displaying index data in the first data report form on a visual interface; under the condition that index data in the index library is updated, determining a first updated index from the index library, wherein the first updated index represents the updated index in the index library; determining a target index set comprising any index in the first updated index from all index sets; under the condition that the target index set comprises the first index set, updating first index data in the first data report to obtain an updated first data report; And displaying the first index data in the updated first data report on the visual interface.
5. The method for generating a data report according to claim 4, wherein updating the first index data in the first data report to obtain an updated first data report if it is determined that the target index set includes the first index set, comprises: Determining a second update index from the first update indexes, wherein the second update index represents indexes belonging to the first index set in the first update indexes; acquiring second index data of the second updated index from the index library; And updating the first index data in the first data report according to the second index data to obtain the updated first data report.
6. The method of generating a data report according to claim 1, wherein after generating a first data report from the first index data, the method further comprises: displaying index data in the first data report form on a visual interface; Editing the indexes in the first index set according to the index editing request of the target object to obtain a second index set; Acquiring second index data corresponding to the second index set from the index library, generating a second data report table according to the second index data, and modifying the table structure of the first data report table according to the table structure corresponding to the second index set to obtain a second data report table; And displaying the index data in the second data report form on the visual interface.
7. The method for generating a data report according to claim 6, wherein displaying the index data in the first data report on a visual interface comprises: Under the condition that the visual interface is determined to be a display interface of a report tool, acquiring a query statement written in the report tool by the target object, wherein the report tool is connected to a database storing the first data report through a database connection protocol; Executing the query statement in the database to obtain index data in the first data report; And displaying the index data in the first data report on a display interface of the report tool.
8. A data report generating apparatus, comprising: the first generation module is used for generating an index library according to a plurality of index calculation rules and data of different data sources; The second generation module is used for generating a first index set according to an index subscription request of the target object, wherein the index subscription request comprises at least one index subscribed by the target object from the index library, and the first index set comprises all indexes subscribed by the target object; And the third generation module is used for responding to the index issuing instruction of the target object, acquiring first index data corresponding to the first index set from the index library, and generating a first data report according to the first index data.
9. A computer readable storage medium, characterized in that the computer readable storage medium comprises a stored program, wherein the program when run performs the method of any of the preceding claims 1 to 7.
10. An electronic device comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to execute the method according to any of the claims 1 to 7 by means of the computer program.

Description

Data report generation device, storage medium and electronic device Technical Field The present application relates to the field of data processing technologies, and in particular, to a data report generation device, a data report storage medium, and an electronic device. Background In the current enterprise data application, the generation efficiency of the data report is a key bottleneck for restricting the timeliness of business insight. The core of the prior art path, whether through interface call or direct database query, depends on the direct development and operation of the underlying data table. When report developers directly inquire a large database table serving as a public data source, unnormalized or high-concurrency inquiry is extremely easy to cause problems of steep increase of database performance load, slow response and the like, and performance tuning and isolation measures are carried out for guaranteeing system stability, so that report development complexity and time cost are further increased. Meanwhile, due to the lack of unified index definition and management, the situation that the indexes with the same name are possibly generated in different reports and the calculation logic is inconsistent with the numerical result is caused, and the phenomenon can lead to decision confusion and extra caliber checking work, so that the efficiency is seriously affected. Therefore, there is a problem in the related art how to improve the generation efficiency of the data report. Aiming at the problem of how to improve the generation efficiency of the data report in the related art, no effective solution has been proposed yet. Disclosure of Invention The embodiment of the application provides a generation device, a storage medium and an electronic device of a data report, which are used for at least solving the problem of how to improve the generation efficiency of the data report in the related technology. According to one embodiment of the application, the generation of the data report comprises the steps of generating an index library according to a plurality of index calculation rules and data of different data sources, generating a first index set according to an index subscription request of a target object, wherein the index subscription request comprises at least one index subscribed by the target object from the index library, the first index set comprises all indexes subscribed by the target object, responding to an index publishing instruction of the target object, acquiring first index data corresponding to the first index set from the index library, and generating the first data report according to the first index data. In one exemplary embodiment, an index library is generated according to a plurality of index calculation rules and data of different data sources, and the index library comprises the steps of determining an index calculation rule of any index for any index in the index library, determining index monitoring parameters required by the index calculation rule when calculating index data of any index, determining different data sources associated with the index monitoring parameters, acquiring parameter values of the index monitoring parameters from the different data sources, calculating the parameter values of the index monitoring parameters according to the index calculation rule to obtain the index data of any index, generating a group of data corresponding to the any index according to the index calculation rule by the different data sources and the index data, and determining the index library based on a plurality of groups of data corresponding to the indexes. In an exemplary embodiment, obtaining parameter values of the index monitoring parameters from different data sources includes obtaining original data from each data source for the different data sources, performing data analysis on the original data according to a data analysis rule preset for each data source to obtain analysis data, and performing unified formatting processing on the analysis data to obtain parameter values of the index monitoring parameters. In an exemplary embodiment, after the first data report is generated according to the first index data, the method further comprises the steps of displaying the index data in the first data report on a visual interface, determining a first updated index from the index library when the index data in the index library is updated, wherein the first updated index represents the updated index in the index library, determining a target index set comprising any index in the first updated index from all index sets, updating the first index data in the first data report to obtain an updated first data report when the target index set comprises the first index set, and displaying the first index data in the updated first data report on the visual interface. In an exemplary embodiment, under the condition that the target index set includes the first index set, up