Report statistical method and device, computer equipment and storage medium

Abstract

The invention relates to a report statistical method and device, computer equipment and a storage medium. The method comprises the following steps: acquiring report configuration information from a report statistics request sent by a receiving terminal; analyzing the report configuration information to obtain a report statistical rule of which each field comprises a statistical type of the field, a source data identifier and an analysis rule; if the statistical type is real-time statistics, acquiring data corresponding to the field from a source database according to the source data identifier through a preset real-time statistics application program, and performing real-time statistics on the data corresponding to the field based on an analysis rule to obtain a target statistical result of the field; if the statistical type is timed off-line statistics, acquiring data corresponding to the field from the source database at a preset time interval based on the source data identifier through a preset off-line statistics application program, and performing timed off-line statistics on the data corresponding to the field based on an analysis rule to obtain a target statistical result of the field; and generating a target report statistical result based on the target statistical result of each field. By adopting the method, the statistical efficiency of the report can be improved.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a report statistics method, apparatus, computer equipment and storage medium. Background Art

[0002] With the development of Internet technology, Internet data has also increased massively. However, in the statistical scenario of data reports, existing technologies cannot perform efficient statistics on data, resulting in low statistical efficiency of data reports. Summary of the invention

[0003] Based on this, it is necessary to provide a report statistics method, device, computer equipment and storage medium that can efficiently count report data in order to address the above technical problems, thereby improving the statistical efficiency of data reports.

[0004] In a first aspect, the present application provides a report statistics method. The method comprises:

[0005] Receiving a report statistics request sent by a terminal, and acquiring report configuration information corresponding to a target service identifier from the report statistics request, wherein the report configuration information includes configuration information corresponding to each field in a target report corresponding to the target service identifier;

[0006] Parsing the report configuration information to obtain report statistics rules corresponding to each field in the target report, wherein the report statistics rules include the statistics type, source data identifier and analysis rules corresponding to the field;

[0007] If the statistical type corresponding to the field is real-time statistics, the data corresponding to the field is obtained from the source database according to the source data identifier corresponding to the field through the preset real-time statistics application, and the data corresponding to the field is subjected to real-time statistics based on the analysis rules corresponding to the field to obtain the real-time statistical result corresponding to the field, and the real-time statistical result corresponding to the field is used as the target statistical result corresponding to the field;

[0008] If the statistical type corresponding to the field is scheduled offline statistics, the data corresponding to the field is obtained from the source database at a preset time interval based on the source data identifier corresponding to the field through a preset offline statistical application, and the data corresponding to the field is subjected to scheduled offline statistics based on the analysis rule corresponding to the field to obtain the offline statistical result corresponding to the field, and the offline statistical result corresponding to the field is used as the target statistical result corresponding to the field;

[0009] Based on the target statistical results corresponding to each field, a target report statistical result corresponding to the target report is generated.

[0010] In one embodiment, real-time statistics are performed on the data corresponding to the field based on the analysis rules corresponding to the field, and the real-time statistical results corresponding to the field are obtained, including:

[0011] The preset real-time statistical application program obtains the algorithm factor corresponding to the field based on the analysis rule corresponding to the field, performs real-time statistical analysis on the data corresponding to the field based on the algorithm factor corresponding to the field, and obtains the real-time statistical result corresponding to the field.

[0012] In one embodiment, based on the analysis rule corresponding to the field, the data corresponding to the field is periodically counted offline, and the offline statistical result corresponding to the field is obtained, including:

[0013] The preset offline statistical application obtains the algorithm factor corresponding to the field based on the analysis rule corresponding to the field, performs regular offline statistical analysis on the data corresponding to the field based on the algorithm factor corresponding to the field, and obtains the offline statistical result corresponding to the field.

[0014] In one embodiment, the statistical type corresponding to each field includes being determined according to the data update frequency corresponding to each field.

[0015] In one of the embodiments, after generating the target report statistical result corresponding to the target report based on the target statistical result corresponding to each field, the method further includes:

[0016] Sending the target report statistical results to the terminal;

[0017] The terminal is enabled to obtain the interface configuration information corresponding to the target service identifier, and display the target statistical result on the target interface based on the interface configuration information.

[0018] In one embodiment, the report configuration information includes real-time report configuration information and offline report configuration information; the method further includes:

[0019] Parsing the report configuration information to obtain real-time report statistics rules corresponding to the real-time report configuration information and offline report statistics rules corresponding to the offline report configuration information;

[0020] Based on the preset real-time statistics application and the real-time report statistics rules, real-time statistics are performed on the data corresponding to the target business identifier to generate a real-time statistics report corresponding to the target business identifier; based on the preset offline statistics application and the offline report statistics rules, regular offline statistics are performed on the data corresponding to the target business identifier to generate an offline statistics report corresponding to the target business identifier;

[0021] If the time point of the real-time statistics is the same as the time point of the scheduled offline statistics, the statistical results of the offline statistical report will be used as the statistical results of the target report corresponding to the target business identifier; if the time point of the real-time statistics is not the same as the time point of the scheduled offline statistics, the statistical results of the real-time statistical report will be used as the statistical results of the target report corresponding to the target business identifier.

[0022] In a second aspect, the present application also provides a report statistics device. The device comprises:

[0023] An acquisition module, used for receiving a report statistics request sent by a terminal, and acquiring report configuration information corresponding to a target service identifier from the report statistics request, wherein the report configuration information includes configuration information corresponding to each field in a target report corresponding to the target service identifier;

[0024] A parsing module, used to parse the report configuration information to obtain report statistics rules corresponding to each field in the target report, wherein the report statistics rules include the statistics type, source data identifier and analysis rules corresponding to the field;

[0025] A real-time statistics module is used for obtaining data corresponding to the field from a source database according to a source data identifier corresponding to the field through a preset real-time statistics application program if the statistics type corresponding to the field is real-time statistics, performing real-time statistics on the data corresponding to the field based on an analysis rule corresponding to the field, obtaining a real-time statistics result corresponding to the field, and using the real-time statistics result corresponding to the field as a target statistics result corresponding to the field;

[0026] An offline statistics module is used for, if the statistical type corresponding to a field is a scheduled offline statistics, obtaining the data corresponding to the field from the source database at a preset time interval based on the source data identifier corresponding to the field through a preset offline statistics application, performing scheduled offline statistics on the data corresponding to the field based on the analysis rule corresponding to the field, obtaining the offline statistical result corresponding to the field, and using the offline statistical result corresponding to the field as the target statistical result corresponding to the field;

[0027] The generating module is used to generate the target report statistical result corresponding to the target report based on the target statistical result corresponding to each field.

[0028] In one of the embodiments, the report statistics device also includes a display module, which is used to send the target report statistics results to the terminal; so that the terminal obtains the interface configuration information corresponding to the target business identifier, and displays the target statistics results on the target interface based on the interface configuration information.

[0029] A computer device comprises a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0030] Receiving a report statistics request sent by a terminal, and acquiring report configuration information corresponding to a target service identifier from the report statistics request, wherein the report configuration information includes configuration information corresponding to each field in a target report corresponding to the target service identifier;

[0031] Parsing the report configuration information to obtain report statistics rules corresponding to each field in the target report, wherein the report statistics rules include the statistics type, source data identifier and analysis rules corresponding to the field;

[0032] If the statistical type corresponding to the field is real-time statistics, the data corresponding to the field is obtained from the source database according to the source data identifier corresponding to the field through the preset real-time statistics application, and the data corresponding to the field is subjected to real-time statistics based on the analysis rules corresponding to the field to obtain the real-time statistical result corresponding to the field, and the real-time statistical result corresponding to the field is used as the target statistical result corresponding to the field;

[0033] If the statistical type corresponding to the field is scheduled offline statistics, the data corresponding to the field is obtained from the source database at a preset time interval based on the source data identifier corresponding to the field through a preset offline statistical application, and the data corresponding to the field is subjected to scheduled offline statistics based on the analysis rule corresponding to the field to obtain the offline statistical result corresponding to the field, and the offline statistical result corresponding to the field is used as the target statistical result corresponding to the field;

[0034] Based on the target statistical results corresponding to each field, a target report statistical result corresponding to the target report is generated.

[0035] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the following steps:

[0036] Receiving a report statistics request sent by a terminal, and acquiring report configuration information corresponding to a target service identifier from the report statistics request, wherein the report configuration information includes configuration information corresponding to each field in a target report corresponding to the target service identifier;

[0037] Parsing the report configuration information to obtain report statistics rules corresponding to each field in the target report, wherein the report statistics rules include the statistics type, source data identifier and analysis rules corresponding to the field;

[0038] If the statistical type corresponding to the field is real-time statistics, the data corresponding to the field is obtained from the source database according to the source data identifier corresponding to the field through the preset real-time statistics application, and the data corresponding to the field is subjected to real-time statistics based on the analysis rules corresponding to the field to obtain the real-time statistical result corresponding to the field, and the real-time statistical result corresponding to the field is used as the target statistical result corresponding to the field;

[0039] If the statistical type corresponding to the field is scheduled offline statistics, the data corresponding to the field is obtained from the source database at a preset time interval based on the source data identifier corresponding to the field through a preset offline statistical application, and the data corresponding to the field is subjected to scheduled offline statistics based on the analysis rule corresponding to the field to obtain the offline statistical result corresponding to the field, and the offline statistical result corresponding to the field is used as the target statistical result corresponding to the field;

[0040] Based on the target statistical results corresponding to each field, a target report statistical result corresponding to the target report is generated.

[0041] The above-mentioned report statistics method, device, computer equipment and storage medium obtain report configuration information corresponding to the target business identifier from the report statistics request by receiving the report statistics request sent by the terminal, and the report configuration information includes configuration information corresponding to each field in the target report corresponding to the target business identifier; the report configuration information is parsed to obtain report statistics rules corresponding to each field in the target report, and the report statistics rules include the statistical type, source data identifier and analysis rules corresponding to the field; if the statistical type corresponding to the field is real-time statistics, the data corresponding to the field is obtained from the source database according to the source data identifier corresponding to the field through a preset real-time statistics application, and the data corresponding to the field is subjected to real-time statistics based on the analysis rules corresponding to the field to obtain the real-time statistical results corresponding to the field, and the real-time statistical results corresponding to the field are used as The target statistical result corresponding to the field; if the statistical type corresponding to the field is scheduled offline statistics, the data corresponding to the field is obtained from the source database at a preset time interval based on the source data identifier corresponding to the field through the preset offline statistical application, and the data corresponding to the field is subjected to scheduled offline statistics based on the analysis rules corresponding to the field to obtain the offline statistical result corresponding to the field, and the offline statistical result corresponding to the field is used as the target statistical result corresponding to the field; based on the target statistical result corresponding to each field, the target report statistical result corresponding to the target report is generated, thereby realizing targeted statistical analysis of field-related data with different update frequencies, effectively reducing the number of data queries and the waste of unnecessary resources in the data processing process, and improving the data response speed, which is beneficial to improving the statistical efficiency and processing performance of report data. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] Figure 1 A diagram showing an application environment of a report statistics method in an embodiment;

[0043] Figure 2 A flowchart of a report statistics method in one embodiment;

[0044] Figure 3 A schematic diagram of a flow chart of report statistics in an embodiment;

[0045] Figure 4 A schematic diagram of a flow chart of report statistics in another embodiment;

[0046] Figure 5 A structural block diagram of a report statistics device in an embodiment;

[0047] Figure 6 is an internal structure diagram of a computer device in one embodiment;

[0048] Figure 7 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0049] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0050] The report statistics method provided in the embodiment of the present application can be applied to Figure 1In the application environment shown, the terminal 102 communicates with the server 104 through a network. The data storage system can store data that the server 104 needs to process. The data storage system can be integrated on the server 104, or placed on the cloud or other network servers. The server 104 is used to receive a report statistics request sent by a terminal, obtain report configuration information corresponding to the target business identifier from the report statistics request, the report configuration information includes configuration information corresponding to each field in the target report corresponding to the target business identifier; parse the report configuration information to obtain report statistics rules corresponding to each field in the target report, the report statistics rules include the statistical type, source data identifier and analysis rules corresponding to the field; if the statistical type corresponding to the field is real-time statistics, then the data corresponding to the field is obtained from the source database according to the source data identifier corresponding to the field through a preset real-time statistics application, and the data corresponding to the field is subjected to real-time statistics based on the analysis rules corresponding to the field to obtain the real-time statistical results corresponding to the field, and the real-time statistical results corresponding to the field are used as the target statistical results corresponding to the field; if the statistical type corresponding to the field is scheduled offline statistics, then the source data corresponding to the field is obtained from the source database at a preset time interval based on the source data identifier corresponding to the field through a preset offline statistics application, and the data corresponding to the field is subjected to scheduled offline statistics based on the analysis rules corresponding to the field to obtain the offline statistical results corresponding to the field, and the offline statistical results corresponding to the field are used as the target statistical results corresponding to the field; based on the target statistical results corresponding to each field, a target report statistical result corresponding to the target report is generated. The terminal 102 may be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, IoT devices, and portable wearable devices. The IoT devices may be smart speakers, smart TVs, smart air conditioners, smart car-mounted devices, etc. The portable wearable devices may be smart watches, smart bracelets, head-mounted devices, etc. The server 104 may be implemented as an independent server or a server cluster consisting of multiple servers.

[0051] In one embodiment, Figure 2 As shown, a report statistics method is provided, which is applied to Figure 1 The server in the example is used to illustrate the following steps:

[0052] Step S200, receiving a report statistics request sent by a terminal, and acquiring report configuration information corresponding to a target service identifier from the report statistics request, wherein the report configuration information includes configuration information corresponding to each field in a target report corresponding to the target service identifier.

[0053] Among them, the report statistics request refers to a request for statistics on report data related to the business. The target business identifier refers to the name of the business that needs to be reported and analyzed. The report configuration information refers to the configuration information related to the report data of the business corresponding to the target business identifier, which includes but is not limited to the configuration information for various statistical analyses of each field in the report and the configuration information of the business display interface corresponding to the target business identifier; it can be recorded in JAON format. The target report refers to the report of the business corresponding to the target business identifier.

[0054] Specifically, different types of data may exist in business reports corresponding to different businesses. You can enter relevant business information (such as field information in the report, statistical rules for each field, etc.) in the relevant interface at the terminal according to business needs, and then generate a corresponding report statistical request based on the input information. The server receives the report statistical request sent by the terminal, and obtains the report configuration information corresponding to the target business identifier corresponding to the current operation from the report statistical request, wherein the report configuration information includes the configuration information corresponding to each field in the report corresponding to the target business identifier. The acquisition of the report configuration information provides a data basis for the subsequent statistical analysis of the data in each field and the generation of report statistical results.

[0055] Step S202, parse the report configuration information to obtain report statistical rules corresponding to each field in the target report, the report statistical rules including the statistical type, source data identifier and analysis rules corresponding to the field.

[0056] Among them, report statistical rules refer to the rules for analyzing and counting the data of certain fields. For example, the statistical rule for field A is to read the data information corresponding to field A from table B in the source database, and accumulate and count the data information corresponding to field A. Statistical type refers to the way of counting data, which can be real-time statistics or scheduled offline statistics. Source data identifier refers to the identifier that can guide the search for data corresponding to the field; for example, the data of field C can be read from table B of database A, and the identifier of database A + the identifier of table B + the identifier of field C can be used as the source data identifier. Analysis rules refer to the rules for processing the data of a field; for example, the data of field A can be accumulated.

[0057] Specifically, the report configuration information is saved in json format, and in the configuration information corresponding to different fields, different identifiers correspond to different statistical functions. For example, the data information corresponding to the field fun may be the sum identifier or the max identifier, and the sum identifier corresponds to the sum() function, and the max identifier corresponds to the max() function. The report configuration information can be parsed to obtain the report statistical rules corresponding to each field in the target report. Each report statistical rule contains the statistical type, source data identifier and analysis rule corresponding to each field. The statistical type can determine whether the field is counted in real-time or timed offline. The source data identifier can determine the search path of the data corresponding to the field. The analysis rule can determine the statistical function of the field (that is, algorithm factors such as sum() and max()). Different fields correspond to different statistical rules, so as to achieve targeted statistics of each field.

[0058] Step S204, if the statistical type corresponding to the field is real-time statistics, the data corresponding to the field is obtained from the source database according to the source data identifier corresponding to the field through a preset real-time statistical application, and real-time statistics are performed on the data corresponding to the field based on the analysis rules corresponding to the field to obtain the real-time statistical results corresponding to the field, and the real-time statistical results corresponding to the field are used as the target statistical results corresponding to the field.

[0059] Among them, real-time statistics refers to real-time statistics of data. The preset real-time statistics application refers to an application used to count data updated in real time; it can be but not limited to Flink applications. The source database refers to a database used to store relevant data of various businesses; it can be a collection of multiple databases; the data in the source database is also stored and recorded in real time based on the real-time update of relevant data of various businesses. The real-time statistical result refers to the result obtained after the data is counted in a real-time statistical manner. The target statistical result refers to the statistical result of the data corresponding to the field.

[0060] Specifically, the data update frequency of some fields is relatively high. For data with high update frequency, real-time statistics can be used for statistics. When it is identified that the statistical type corresponding to the field is real-time statistics, the data corresponding to the field can be obtained from the source database in real time according to the source data identifier of the field through a preset real-time statistics application, and then the data is analyzed in real time according to the analysis rule of the field, so as to obtain the real-time statistical result corresponding to the field in real time, and the real-time statistical result is used as the target statistical result corresponding to the field. For example, the source data identifier of field A is field A in table C in database B, then the data of field A is obtained from table C of database B in the source database, and the analysis rule of field A is to obtain the maximum data in field A, that is, the analysis rule of field A is implemented by the max() function (or max() algorithm factor), and the maximum data in field A is the real-time statistical result of field A, and the real-time statistical result may change in real time with the real-time change of the data of field A in table C in data B of the source database.

[0061] Step S206, if the statistical type corresponding to the field is timed offline statistics, the data corresponding to the field is obtained from the source database at a preset time interval based on the source data identifier corresponding to the field through a preset offline statistical application, and the data corresponding to the field is subjected to timed offline statistics based on the analysis rules corresponding to the field to obtain the offline statistical results corresponding to the field, and the offline statistical results corresponding to the field are used as the target statistical results corresponding to the field.

[0062] Among them, scheduled offline statistics are used to perform statistics on data at a specified time, including statistics on data in an offline state. The preset offline statistics application refers to an application that performs scheduled offline statistics on data; it can be, but is not limited to, a Spark application. The preset time interval refers to the time interval corresponding to the time interval for performing scheduled statistics on field data. The scheduled offline statistics result refers to the result obtained after performing statistics on data in a scheduled offline statistics manner.

[0063] Specifically, for data in fields that are not updated frequently, a timed offline statistics method can be used to perform statistical analysis of the data, thereby reducing frequent queries and processing of data and improving the efficiency and performance of data statistics. For timed offline statistics of data, a preset offline statistics application can be used to obtain data corresponding to the field from the source database at preset time intervals based on the source data identifier corresponding to the field, and perform timed offline statistics on the data corresponding to the same field according to the analysis rules corresponding to the field, that is, statistical analysis is performed on the data corresponding to the field according to the analysis rules of the field at preset time intervals, and the calculated offline statistical results are used as the target statistical results between the current time point and the next scheduled time point.

[0064] Step S208: Generate target report statistical results corresponding to the target report based on the target statistical results corresponding to each field.

[0065] The target report statistical results refer to the report statistical results obtained after statistical analysis of each field in the target report.

[0066] Specifically, for fields that undergo real-time statistical analysis, the real-time statistical results of the fields are the target statistical results corresponding to the fields in real time. For fields that undergo timed offline statistical analysis, the offline statistical results at a certain time point are used as the target statistical results corresponding to the period from that time point to the next time point, thereby reducing the query and processing of data with infrequent update frequency, and recording the target statistical results corresponding to each field to the corresponding position in the target report, thereby obtaining the target report statistical results corresponding to the target report at each time point, and sending the target report statistical results to the terminal so that the terminal displays the target report statistical results according to the interface configuration information.

[0067] The above-mentioned report statistics method obtains report configuration information corresponding to the target business identifier from the report statistics request by receiving the report statistics request sent by the terminal, and the report configuration information includes configuration information corresponding to each field in the target report corresponding to the target business identifier; the report configuration information is parsed to obtain report statistics rules corresponding to each field in the target report, and the report statistics rules include the statistical type, source data identifier and analysis rules corresponding to the field; if the statistical type corresponding to the field is real-time statistics, the data corresponding to the field is obtained from the source database according to the source data identifier corresponding to the field through a preset real-time statistics application, and the data corresponding to the field is subjected to real-time statistics based on the analysis rules corresponding to the field to obtain the real-time statistical results corresponding to the field, and the real-time statistical results corresponding to the field are used as the target statistics corresponding to the field. Statistical results; if the statistical type corresponding to the field is scheduled offline statistics, the data corresponding to the field is obtained from the source database at a preset time interval based on the source data identifier corresponding to the field through a preset offline statistical application, and the data corresponding to the field is subjected to scheduled offline statistics based on the analysis rules corresponding to the field to obtain the offline statistical results corresponding to the field, and the offline statistical results corresponding to the field are used as the target statistical results corresponding to the field; based on the target statistical results corresponding to each field, the target report statistical results corresponding to the target report are generated, thereby realizing targeted statistical analysis of field-related data with different update frequencies, effectively reducing the number of data queries and the waste of unnecessary resources in the data processing process, and improving the data response speed, which is beneficial to improving the statistical efficiency and processing performance of report data.

[0068] In one embodiment, step S204 includes: obtaining the algorithm factor corresponding to the field based on the analysis rule corresponding to the field through a preset real-time statistical application, performing real-time statistical analysis on the data corresponding to the field based on the algorithm factor corresponding to the field, and obtaining the real-time statistical result corresponding to the field.

[0069] Among them, the algorithm factor refers to the function of calculating data, such as the sum() function for addition, the count() function for calculating the number, the max() function for taking the maximum value, etc.

[0070] Specifically, the preset real-time statistical application can perform efficient statistical analysis on data with a high update frequency. The analysis rules of each field contain algorithm factors for analyzing the data of each field. The algorithm factors in the analysis rules can be identified, and the data of each field can be automatically analyzed and counted based on the algorithm factors, so as to obtain real-time statistical results corresponding to each field with real-time statistics as the statistical type.

[0071] In the above embodiment, by presetting the real-time statistical application based on the analysis rules corresponding to the field, the algorithm factors corresponding to the field are obtained, and real-time statistical analysis is performed on the data corresponding to the field based on the algorithm factors corresponding to the field to obtain the real-time statistical results corresponding to the field, thereby realizing real-time statistics of the field. The selection of the preset real-time statistical application improves the efficiency of real-time analysis and statistics of data to a certain extent, and the data of the field of real-time statistics and the field of scheduled offline statistics are processed separately, thereby improving the efficiency and performance of data processing to a certain extent.

[0072] In one embodiment, step S206 includes: obtaining the algorithm factor corresponding to the field based on the analysis rule corresponding to the field through a preset offline statistical application, performing regular offline statistical analysis on the data corresponding to the field based on the algorithm factor corresponding to the field, and obtaining the offline statistical result corresponding to the field.

[0073] Specifically, the preset offline statistical application can perform efficient timed statistical analysis on data with low update frequency. After identifying that the statistical type of a field is timed offline statistics, the preset offline statistical application determines the algorithm factor corresponding to the field from the analysis rule of the field, and performs timed statistics on the data of the field according to the function of the algorithm factor to obtain real-time statistical results corresponding to each field whose statistical type is timed offline statistics.

[0074] In the above embodiment, an offline statistical application is preset based on the analysis rules corresponding to the field to obtain the algorithm factors corresponding to the field, and a timed offline statistical analysis is performed on the data corresponding to the field based on the algorithm factors corresponding to the field to obtain the offline statistical results corresponding to the field, thereby realizing the timed offline statistics of the field. The selection of the preset offline statistical application improves the efficiency of the timed offline analysis and statistics of the data to a certain extent, and the data of the field of timed offline statistics and the field of real-time statistics are processed separately, thereby improving the efficiency and performance of data processing to a certain extent.

[0075] In one embodiment, the statistical type corresponding to each field includes being determined according to the data update frequency corresponding to each field.

[0076] Specifically, different fields have different data update frequencies. If real-time statistical analysis is performed on fields with a low update frequency like fields with a high update frequency, the frequency of data queries will increase, thereby increasing the use of unnecessary resources during data query and processing, and further reducing the data response speed and data processing performance. Therefore, the statistical type corresponding to each field can be set according to the data update frequency of each field, and there is no restriction on the calculation of the data update frequency.

[0077] In one embodiment, after step S208, the method further includes:

[0078] Step S300, sending the statistical results of the target report to the terminal.

[0079] Step S302 is to enable the terminal to obtain interface configuration information corresponding to the target service identifier, and to display the target statistical result on the target interface based on the interface configuration information.

[0080] The interface configuration information refers to the configuration information for displaying data in the interface. The target interface refers to the interface for displaying the statistical analysis results of the report corresponding to the target business identifier.

[0081] Specifically, the target report statistics result of the target report corresponding to the target business identifier can be sent to the terminal in real time, so that the terminal displays the target report statistics result in real time in the corresponding target interface according to the interface configuration information corresponding to the target business identifier.

[0082] In the above embodiment, the target report statistical results are sent to the terminal so that the terminal obtains the interface configuration information corresponding to the target business identifier, and the target statistical results are displayed on the target interface based on the interface configuration information, thereby realizing automatic configuration and display of the report statistical result interface of different business types, thereby improving the interface display performance corresponding to each type of business.

[0083] In one embodiment, the report configuration information includes real-time report configuration information and offline report configuration information; the report statistics method further includes:

[0084] Step S400: parsing the report configuration information to obtain real-time report statistics rules corresponding to the real-time report configuration information and offline report statistics rules corresponding to the offline report configuration information.

[0085] Step S402, based on the preset real-time statistical application and real-time report statistical rules, real-time statistics are performed on the data corresponding to the target business identifier, and a real-time statistical report corresponding to the target business identifier is generated. Based on the preset offline statistical application and offline report statistical rules, periodic offline statistics are performed on the data corresponding to the target business identifier, and an offline statistical report corresponding to the target business identifier is generated.

[0086] Step S404, if the time point of real-time statistics is the same as the time point of scheduled offline statistics, the statistical results of the offline statistical report will be used as the statistical results of the target report corresponding to the target business identifier; if the time point of real-time statistics is different from the time point of scheduled offline statistics, the statistical results of the real-time statistical report will be used as the statistical results of the target report corresponding to the target business identifier.

[0087] Among them, real-time report configuration information refers to configuration information for real-time statistics of reports. Offline report configuration information refers to configuration information for scheduled offline statistics of reports. Real-time report statistical rules refer to statistical rules for real-time statistics of data corresponding to fields in the entire report. Real-time statistical reports refer to reports obtained by real-time statistics. Offline report statistical rules refer to statistical rules for scheduled offline statistics of data corresponding to fields in the entire report. Offline statistical reports refer to reports obtained by offline statistics.

[0088] Specifically, all fields in the reports corresponding to certain businesses may have a high update frequency. In order to avoid the situation where data is not synchronously statistically processed between the update of field data in the report and the real-time statistics of each field in the report, all fields in the entire report can be counted in real time, and the data of all updated records before the scheduled time point can be counted regularly, thereby avoiding the situation where data analysis and statistics may be missed in real-time statistics, which may affect the accuracy of statistical results. Therefore, during configuration, it is possible to configure the statistical type of real-time statistics of the target report and also configure the statistical type of timed offline statistics of the report, so that after parsing the report configuration information, the real-time report statistical rules corresponding to the real-time report configuration information and the offline report statistical rules corresponding to the offline report configuration information can be parsed, and respectively, through the preset real-time statistical application, the source data identifier and algorithm factor of each field in the target report corresponding to the target business identifier are determined according to the real-time report statistical rules, and the data corresponding to the field is obtained from the source database in real time according to the source data identifier of each field, and then the data of each field is subjected to real-time statistics according to the algorithm factor of each field, so as to obtain the real-time statistical report corresponding to the target business identifier; and through the preset offline statistical application, the source data identifier and algorithm factor corresponding to each field are determined from the offline report statistical rules, and the data corresponding to each field is obtained from the source database at a preset time interval according to the source data identifier corresponding to each field, and the data of each field is subjected to timed offline statistics according to the algorithm factor of each field, so as to obtain the offline statistical report corresponding to the target business identifier. Since the data omission rate of scheduled offline statistics is lower than that of real-time statistics, when the time point of real-time statistics and the time point of scheduled offline statistics are the same, E uses the statistical results of the offline statistical report as the target report statistical results corresponding to the target business identifier, and sends the target report statistical results to the terminal for display; if the time point of real-time statistics and the time point of scheduled offline statistics are not the same, the statistical results of the real-time statistical report are used as the target report statistical results corresponding to the current time of the target business identifier, and the target report statistical results are sent to the terminal for display, thereby ensuring the real-time nature of the report statistical results displayed by the terminal while also ensuring the accuracy of the displayed report statistical results to a certain extent.

[0089] In the above embodiment, real-time statistics and scheduled offline statistics are performed on the target report of the target business identifier respectively, and when the time point of the real-time statistics is the same as the time point of the scheduled offline statistics, the statistical results of the offline statistical report are used as the statistical results of the target report corresponding to the target business identifier; when the time point of the real-time statistics is different from the time point of the scheduled offline statistics, the statistical results of the real-time statistical report are used as the statistical results of the target report corresponding to the target business identifier, thereby realizing real-time statistics of report data while reducing the data omission rate to a certain extent, thereby ensuring the accuracy and timeliness of report data statistics to a certain extent.

[0090] In one embodiment, the description is made by taking the example of a user configuring report statistics in an interface and implementing real-time report statistics and scheduled offline statistics according to the user configuration information. Figure 3 As shown, the user can enter the configuration information of the target business corresponding to the target business identifier in the configuration interface of the terminal, and store the interface configuration information corresponding to the target business in the interface configuration library, and store the report configuration information corresponding to the target business identifier in the business statistics rule configuration library. In addition, in order to better manage the configuration information, the interface configuration information stored in the interface configuration library and the report configuration information in the business statistics rule configuration library are also stored in the memory database. When it is necessary to perform statistical analysis on the data of each field in the target report, the report configuration information of the target report can be obtained from the memory database, and the report configuration information can be parsed to obtain the report statistics rules corresponding to each field in the target report, wherein the report statistics rules include the statistical type, source data identifier and analysis rules corresponding to the field. When the statistical type of the field is real-time statistics, the preset real-time statistics application (i.e. Figure 3 The Flink real-time application in the report obtains the data corresponding to the field from the source database according to the source data identifier of the field, determines the algorithm factor corresponding to the field according to the analysis rule of the field, and then calculates the data corresponding to the field according to the algorithm factor corresponding to the field to obtain the real-time statistical result corresponding to the field, and stores the real-time statistical result of the field as the target statistical result of the field in the report statistical result library; in addition, if the statistical type of the field is scheduled offline statistics, the preset offline statistical application (i.e. Figure 3 The Spark application in the program obtains the data corresponding to the field in the source database according to the source data identifier of the field, determines the algorithm factor corresponding to the field according to the analysis rule corresponding to the field, calculates the data of the field based on the algorithm factor corresponding to the field, obtains the offline statistical result corresponding to the field, and uses the offline statistical result of the field as the target statistical result of the field and stores it in the report statistical result library. At the same time, the target report statistical result generated based on the target statistical result of each field is sent to the terminal, so that the terminal displays the target report statistical result on the interface related to the target business identifier through the interface configuration information.

[0091] Further, a more detailed process can be Figure 4As shown, users can create tasks to generate business reports in business-related interfaces, and configure the basic information, report information, report statistical rules, and interface configuration information of the business report. The basic information of the business report includes but is not limited to the business identifier, the statistical type of the report corresponding to the business, business-related descriptions, and other information. The report information includes but is not limited to the report identifier, report name, and other information. The report statistical rules include but are not limited to the statistical type of each field in the report, the source data identifier, the analysis rules, and other information. The interface configuration information includes the configuration information of the interface design and data display. All business-related information can be stored in the in-memory database. In addition, the report statistical rules can be parsed in real time by the parser to obtain the statistical type, source data identifier, and analysis rules corresponding to each field. For fields with real-time statistical types, the Flink real-time statistical application is started to count the data of the field, and the data of the field is obtained from the source database according to the source data identifier of the field. The algorithm factor of the field is determined based on the analysis rule of the field (specifically, as shown in Figure 4 The algorithm factor of the example is used to perform real-time statistics on the data of the field according to the algorithm factor of the field, and the real-time statistical results are stored in the report statistical result library and sent to the terminal for display. Similarly, for fields with a statistical type of scheduled offline statistics, the Spark scheduled offline statistics application is started, and the data of the field is obtained from the source database according to the source data identifier of the field through the Spark application, and the algorithm factor of the field is determined based on the analysis rule of the field (specifically, as shown in Figure 4 The algorithm factor of the example is used to perform offline statistics on the data of the field according to the algorithm factor of the field, and store the results of the offline statistics in the report statistical result library, and send them to the terminal for display. In this way, targeted statistical analysis of the data of fields with different update frequencies is achieved, which effectively reduces the number of data queries and the waste of unnecessary resources in the data processing process, improves the data response speed, and is conducive to improving the statistical efficiency and processing performance of report data.

[0092] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0093] Based on the same inventive concept, the embodiment of the present application also provides a report statistics device for implementing the report statistics method involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations in one or more report statistics device embodiments provided below can refer to the limitations on the report statistics method above, and will not be repeated here.

[0094] In one embodiment, Figure 5 As shown, a report statistics device is provided, including: an acquisition module 500, a parsing module 502, a real-time statistics module 504, an offline statistics module 506 and a generation module 508, wherein:

[0095] The acquisition module 500 is used to receive a report statistics request sent by a terminal, and obtain report configuration information corresponding to a target business identifier from the report statistics request, wherein the report configuration information includes configuration information corresponding to each field in a target report corresponding to the target business identifier.

[0096] The parsing module 502 is used to parse the report configuration information to obtain the report statistical rules corresponding to each field in the target report, and the report statistical rules include the statistical type, source data identifier and analysis rules corresponding to the field.

[0097] The real-time statistics module 504 is used to obtain the data corresponding to the field from the source database according to the source data identifier corresponding to the field through a preset real-time statistics application if the statistical type corresponding to the field is real-time statistics, and to perform real-time statistics on the data corresponding to the field based on the analysis rules corresponding to the field to obtain the real-time statistical results corresponding to the field, and use the real-time statistical results corresponding to the field as the target statistical results corresponding to the field.

[0098] The offline statistics module 506 is used to obtain the data corresponding to the field from the source database at a preset time interval based on the source data identifier corresponding to the field through a preset offline statistics application if the statistical type corresponding to the field is scheduled offline statistics, and to perform scheduled offline statistics on the data corresponding to the field based on the analysis rules corresponding to the field to obtain the offline statistical results corresponding to the field, and use the offline statistical results corresponding to the field as the target statistical results corresponding to the field.

[0099] The generating module 508 is used to generate the target report statistical result corresponding to the target report based on the target statistical result corresponding to each field.

[0100] In one embodiment, the real-time statistics module 504 is also used to obtain the algorithm factor corresponding to the field based on the analysis rule corresponding to the field through the preset real-time statistics application, perform real-time statistical analysis on the data corresponding to the field based on the algorithm factor corresponding to the field, and obtain the real-time statistical results corresponding to the field.

[0101] In one embodiment, the offline statistics module 506 is also used to obtain the algorithm factor corresponding to the field based on the analysis rule corresponding to the field through the preset offline statistics application, perform regular offline statistical analysis on the data corresponding to the field based on the algorithm factor corresponding to the field, and obtain the offline statistical result corresponding to the field.

[0102] In one embodiment, the parsing module 502 is further used to determine the statistical type corresponding to each field according to the data update frequency corresponding to each field.

[0103] In one embodiment, the report statistics device also includes a display module 510, which is used to send the target report statistics results to the terminal; so that the terminal obtains the interface configuration information corresponding to the target business identifier, and displays the target statistics results on the target interface based on the interface configuration information.

[0104] In one embodiment, the report statistics device also includes a collaborative statistics module 512, which is used for report configuration information including real-time report configuration information and offline report configuration information; parsing the report configuration information to obtain real-time report statistics rules corresponding to the real-time report configuration information and offline report statistics rules corresponding to the offline report configuration information; based on a preset real-time statistics application and the real-time report statistics rules, performing real-time statistics on the data corresponding to the target business identifier, generating a real-time statistics report corresponding to the target business identifier, and based on a preset offline statistics application and the offline report statistics rules, performing scheduled offline statistics on the data corresponding to the target business identifier, generating an offline statistics report corresponding to the target business identifier; if the time point of the real-time statistics is the same as the time point of the scheduled offline statistics, the statistical result of the offline statistical report is used as the target report statistical result corresponding to the target business identifier; if the time point of the real-time statistics is different from the time point of the scheduled offline statistics, the statistical result of the real-time statistical report is used as the target report statistical result corresponding to the target business identifier.

[0105] Each module in the above-mentioned report statistics device can be implemented in whole or in part by software, hardware or a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute the operations corresponding to each module above.

[0106] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 6 As shown. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. The processor, the memory and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data related to the execution process. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a report statistics method is implemented.

[0107] In one embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as follows: Figure 7 As shown. The computer device includes a processor, a memory, an input / output interface, a communication interface, a display unit and an input device. The processor, the memory and the input / output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The input / output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. When the computer program is executed by the processor, a report statistics method is realized. The display unit of the computer device is used to form a visually visible picture, which can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, trackball or touchpad set on the computer device shell, or an external keyboard, touchpad or mouse.

[0108] Those skilled in the art will understand that Figure 6 and Figure 7The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0109] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above method embodiments when executing the computer program.

[0110] In one embodiment, a computer-readable storage medium is provided, storing a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0111] In one embodiment, a computer program product or computer program is provided, the computer program product or computer program includes computer instructions, the computer instructions are stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, so that the computer device performs the steps in the above-mentioned method embodiments.

[0112] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards of relevant countries and regions.

[0113] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.

[0114] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0115] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A report statistics method, characterized in that: The method comprises: Receiving a report statistics request sent by a terminal, and acquiring report configuration information corresponding to a target service identifier from the report statistics request, wherein the report configuration information includes configuration information corresponding to each field in a target report corresponding to the target service identifier; Parsing the report configuration information to obtain report statistics rules corresponding to each field in the target report, wherein the report statistics rules include the statistics type, source data identifier and analysis rules corresponding to the field; If the statistical type corresponding to the field is real-time statistics, the data corresponding to the field is obtained from the source database according to the source data identifier corresponding to the field through the preset real-time statistics application, and the data corresponding to the field is subjected to real-time statistics based on the analysis rules corresponding to the field to obtain the real-time statistical result corresponding to the field, and the real-time statistical result corresponding to the field is used as the target statistical result corresponding to the field; If the statistical type corresponding to the field is scheduled offline statistics, the data corresponding to the field is obtained from the source database at a preset time interval based on the source data identifier corresponding to the field through a preset offline statistical application, and the data corresponding to the field is subjected to scheduled offline statistics based on the analysis rule corresponding to the field to obtain the offline statistical result corresponding to the field, and the offline statistical result corresponding to the field is used as the target statistical result corresponding to the field; Based on the target statistical results corresponding to each field, a target report statistical result corresponding to the target report is generated.

2. The method according to claim 1, characterized in that The real-time statistics of the data corresponding to the field are performed based on the analysis rules corresponding to the field, and the real-time statistics results corresponding to the field are obtained, including: The preset real-time statistical application program obtains the algorithm factor corresponding to the field based on the analysis rule corresponding to the field, performs real-time statistical analysis on the data corresponding to the field based on the algorithm factor corresponding to the field, and obtains the real-time statistical result corresponding to the field.

3. The method according to claim 1, characterized in that The performing of regular offline statistics on the data corresponding to the field based on the analysis rule corresponding to the field to obtain the offline statistical result corresponding to the field includes: The preset offline statistical application obtains the algorithm factor corresponding to the field based on the analysis rule corresponding to the field, performs regular offline statistical analysis on the data corresponding to the field based on the algorithm factor corresponding to the field, and obtains the offline statistical result corresponding to the field.

4. The method according to claim 1, characterized in that: The statistical type corresponding to each field includes being determined according to the data update frequency corresponding to each field.

5. The method according to claim 1, characterized in that After generating the target report statistical result corresponding to the target report based on the target statistical result corresponding to each field, the method further includes: Sending the target report statistical results to the terminal; The terminal is enabled to obtain the interface configuration information corresponding to the target service identifier, and display the target statistical result on the target interface based on the interface configuration information.

6. The method according to claim 1, characterized in that The report configuration information includes real-time report configuration information and offline report configuration information; the method further includes: Parsing the report configuration information to obtain real-time report statistics rules corresponding to the real-time report configuration information and offline report statistics rules corresponding to the offline report configuration information; Based on the preset real-time statistics application and the real-time report statistics rules, real-time statistics are performed on the data corresponding to the target business identifier to generate a real-time statistics report corresponding to the target business identifier; based on the preset offline statistics application and the offline report statistics rules, regular offline statistics are performed on the data corresponding to the target business identifier to generate an offline statistics report corresponding to the target business identifier; If the time point of the real-time statistics is the same as the time point of the scheduled offline statistics, the statistical results of the offline statistical report will be used as the statistical results of the target report corresponding to the target business identifier; if the time point of the real-time statistics is not the same as the time point of the scheduled offline statistics, the statistical results of the real-time statistical report will be used as the statistical results of the target report corresponding to the target business identifier.

7. A report statistics device, characterized in that: The device comprises: An acquisition module, used for receiving a report statistics request sent by a terminal, and acquiring report configuration information corresponding to a target service identifier from the report statistics request, wherein the report configuration information includes configuration information corresponding to each field in a target report corresponding to the target service identifier; A parsing module, used to parse the report configuration information to obtain report statistics rules corresponding to each field in the target report, wherein the report statistics rules include the statistics type, source data identifier and analysis rules corresponding to the field; A real-time statistics module is used for obtaining data corresponding to the field from a source database according to a source data identifier corresponding to the field through a preset real-time statistics application program if the statistics type corresponding to the field is real-time statistics, performing real-time statistics on the data corresponding to the field based on an analysis rule corresponding to the field, obtaining a real-time statistics result corresponding to the field, and using the real-time statistics result corresponding to the field as a target statistics result corresponding to the field; An offline statistics module is used for, if the statistical type corresponding to a field is a scheduled offline statistics, obtaining the data corresponding to the field from the source database at a preset time interval based on the source data identifier corresponding to the field through a preset offline statistics application, performing scheduled offline statistics on the data corresponding to the field based on the analysis rule corresponding to the field, obtaining the offline statistical result corresponding to the field, and using the offline statistical result corresponding to the field as the target statistical result corresponding to the field; The generating module is used to generate the target report statistical result corresponding to the target report based on the target statistical result corresponding to each field.

8. The device according to claim 7, characterized in that The report statistics device also includes a display module, which is used to send the target report statistics result to the terminal; so that the terminal obtains the interface configuration information corresponding to the target business identifier, and displays the target statistics result on the target interface based on the interface configuration information.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images