Report generation method and device, computer equipment, storage medium and program product

Abstract

The invention relates to the technical field of data processing, and particularly discloses a report generation method and device, computer equipment, a storage medium and a program product. The method comprises the following steps: acquiring a data file in a preset time period from a data warehouse, loading target data required for generating a target type report from the data file, acquiring a preset script program corresponding to the target type report, and generating the target type report according to the target data and the preset script program. And generating the target type report corresponding to the preset time period, so that data can be periodically and automatically acquired from the data warehouse, the target type report is generated according to the acquired data through the preset script program, repeated development of the script program is reduced, custom development of a business report is met through configuration development of the database, and user experience is improved. The report generation operation is simplified, and the report research and development agility and timeliness are improved.

Description

Technical Field

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

[0002] With the rapid development of the financial industry and information technology, the ability to collect, process and analyze bank data such as customer information, transaction records and management data has become one of the important criteria for measuring bank competitiveness. Processing and generating reports based on these data not only reflects the bank's operating conditions, but also contains rich information on market trends and customer behavior.

[0003] Currently, the processing of bank data to generate reports usually involves obtaining data source tables through data warehouses, and then writing independent applications and scripts based on business needs and data source tables to generate reports.

[0004] However, the traditional method requires writing independent applications and scripts each time a report is generated. Therefore, for the same type of reports that need to be generated regularly based on data over a period of time, it is still necessary to repeatedly write applications and scripts, which makes the operation of generating reports complicated. Summary of the invention

[0005] Based on this, it is necessary to provide a report generation method, apparatus, computer equipment, storage medium and program product that can simplify the report generation operation in order to solve the above technical problems.

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

[0007] Obtain data files within a preset time period from the data warehouse;

[0008] Load the target data required for generating the target class report from the data file;

[0009] Get the preset script program corresponding to the target report;

[0010] According to the target data and the preset script program, a target type report corresponding to the preset time period is generated.

[0011] In one embodiment, the target type report corresponding to the preset time period is generated according to the target data and the preset script program, including:

[0012] At a first preset time, determining whether the target data meets the report generation requirement, the first preset time being a preset timing time for generating the target type report;

[0013] If the target data meets the report generation requirements, the preset script program is used to generate the target type report according to the target data;

[0014] If the target data does not meet the report generation requirement, the generation of the target report is suspended and a first prompt message is generated; the first prompt message is used to indicate that an abnormality occurs in the target data.

[0015] In one embodiment, the report generation requirement includes at least one of the following:

[0016] The target data has been loaded;

[0017] The format of the target data meets the requirements of the preset script program;

[0018] The generation time of the content in the target data meets the preset time requirement.

[0019] In one embodiment, the method further comprises:

[0020] At a second preset time, determining the generation status of the target report, the second preset time being a preset target timing time for generating the target report;

[0021] If the generation status of the target report is in the process of being generated, the generation of the target report is suspended, and a second prompt message is generated; the second prompt message is used to indicate that an abnormality occurs in the generation of the target report.

[0022] In one embodiment, obtaining data files within a preset time period from a data warehouse includes:

[0023] Updating the data in the data file within the preset time period into at least one zipper table in the local database;

[0024] The target data required to generate the target report is loaded from the data file, including:

[0025] Determine at least one target zipper table required for generating a target class report from the at least one zipper table;

[0026] Load the target data in the target zipper table.

[0027] In one embodiment, updating the data in the data file within the preset time period to at least one zipper table in the local database includes:

[0028] Add the data in the data file within the preset time period to the incremental table of the local database;

[0029] Update the data in the incremental table to at least one zipper table in the local database.

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

[0031] A first acquisition module is used to acquire data files within a preset time period from a data warehouse;

[0032] A loading module is used to load target data required for generating a target class report from the data file;

[0033] The second acquisition module is used to acquire the preset script program corresponding to the target report;

[0034] A generation module is used to generate the target type report corresponding to the preset time period according to the target data and the preset script program.

[0035] In one embodiment, the generating module includes:

[0036] A judgment unit, used to judge whether the target data meets the report generation requirement at a first preset time, where the first preset time is a preset timing time for generating the target type report;

[0037] A generating unit, configured to generate a target type report according to the target data by using the preset script program if the target data meets the report generation requirement;

[0038] The prompt unit is used to suspend the generation of the target report and generate a first prompt message if the target data does not meet the report generation requirements; the first prompt message is used to indicate that the target data is abnormal.

[0039] In one embodiment, the report generation requirement includes at least one of the following:

[0040] The target data has been loaded;

[0041] The format of the target data meets the requirements of the preset script program;

[0042] The generation time of the content in the target data meets the preset time requirement.

[0043] In one embodiment, the device further comprises:

[0044] A determination module, used to determine the generation status of the target report at a second preset time, where the second preset time is a preset target timing time for generating the target report;

[0045] The prompt module is used to suspend the generation of the target report if the generation status of the target report is in the generating state, and generate a second prompt message; the second prompt message is used to indicate that the generation of the target report is abnormal.

[0046] In one embodiment, the first acquisition module includes:

[0047] An updating unit, used for updating the data in the data file within the preset time period into at least one zipper table of the local database;

[0048] The load module includes:

[0049] A determination unit, configured to determine at least one target zipper table required for generating a target class report from the at least one zipper table;

[0050] A loading unit is used to load the target data in the target zipper table.

[0051] In one embodiment, the determining unit includes:

[0052] An adding subunit is used to add the data in the data file within the preset time period to the incremental table of the local database;

[0053] The updating subunit is used to update the data in the incremental table into at least one zipper table in the local database.

[0054] In a third aspect, the present application further provides a computer device, comprising a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of any of the above methods when executing the computer program.

[0055] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, which implements the steps of any of the above methods when executed by a processor.

[0056] In a fifth aspect, the present application also provides a computer program product, including a computer program, which implements the steps of any of the above methods when executed by a processor.

[0057] The above-mentioned report generation method, device, computer equipment, storage medium and program product obtain data files within a preset time period from a data warehouse, load target data required for generating target type reports from the data files, obtain a preset script program corresponding to the target type report, and generate the target type report corresponding to the preset time period based on the target data and the preset script program, thereby being able to periodically and automatically obtain data from the data warehouse and generate target type reports based on the obtained data through the preset script program, thereby reducing repeated development of script programs, meeting the customized development of business reports through the configurable development of databases, simplifying the report generation operation, and improving the agility and timeliness of report development. BRIEF DESCRIPTION OF THE DRAWINGS

[0058] FIG1 is an internal structure diagram of a computer device provided in an embodiment of the present application;

[0059] FIG2 is a flow chart of a report generation method provided in an embodiment of the present application;

[0060] FIG3 is a flow chart of a method for generating a target report according to an embodiment of the present application;

[0061] FIG4 is a schematic diagram of a flow chart of a method for determining a generation state provided in an embodiment of the present application;

[0062] FIG5 is a schematic diagram of a flow chart of a target data loading method provided in an embodiment of the present application;

[0063] FIG6 is a flow chart of a data updating method provided in an embodiment of the present application;

[0064] 7 is a flow chart of an automated report generation method based on database configuration provided in an embodiment of the present application;

[0065] FIG8 is a flow chart of an automated report generation method provided in an embodiment of the present application;

[0066] FIG. 9 is a structural block diagram of a report generating device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0067] 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.

[0068] With the rapid development of the financial industry and information technology, the ability to collect, process and analyze bank data such as customer information, transaction records and management data has become one of the important criteria for measuring bank competitiveness. Processing and generating reports based on these data not only reflects the bank's operating conditions, but also contains rich information on market trends and customer behavior.

[0069] Currently, the processing of bank data to generate reports usually involves obtaining data source tables through data warehouses, and then writing independent applications and scripts based on business needs and data source tables to generate reports.

[0070] However, the traditional method requires writing independent applications and scripts each time a report is generated. Therefore, for the same type of reports that need to be generated regularly based on data over a period of time, it is still necessary to repeatedly write applications and scripts, which makes the operation of generating reports complicated.

[0071] The report generation method provided in the embodiment of the present application can be applied in the application environment as shown in Figure 1. Figure 1 is an internal structure diagram of a computer device provided in the embodiment of the present application. The computer device can be a server, and its internal structure diagram can be as shown in Figure 1. The computer device includes a processor, a memory and a network interface connected through a system bus. Among them, 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 network 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 generation method is implemented.

[0072] Those skilled in the art will understand that the structure shown in FIG. 1 is merely a block diagram of a partial 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 shown in the figure, or combine certain components, or have a different arrangement of components.

[0073] In one embodiment, as shown in FIG. 2 , FIG. 2 is a flow chart of a report generation method provided in an embodiment of the present application, which can be applied to the computer device in FIG. 1 , and the method includes the following steps:

[0074] S201, obtaining data files within a preset time period from a data warehouse.

[0075] For example, the preset time period can be set according to actual needs. For example, if a report of daily business data is to be generated, the preset time period can be set to the previous 24 hours, or from 5 am of the previous day to 5 am of today, etc., to obtain daily business data.

[0076] In one embodiment, each system of the bank transmits data generated within a preset time period to the data warehouse, which can classify, filter, convert the format of the data transmitted by each system, and then temporarily store the data in the data warehouse.

[0077] At the start time of the preset time period, the required data can be subscribed to the data warehouse, which records the required data from various systems of the bank and transmits the loaded data in the form of files in a specific format to the computer device that implements the above report generation method.

[0078] In a possible implementation, after obtaining data files within a preset time period in the data warehouse, the data in the data files may be temporarily stored in an incremental table of a local database, and then the data in the incremental table may be updated to the zipper table according to preset configuration rules.

[0079] The incremental table is only used to store short-term data, such as 24-hour data, while the zipper table is used to store stock data. Temporarily storing the data in the data file in the incremental table can relieve the storage pressure of the zipper table, speed up the data storage rate, and reduce the probability of errors in data storage.

[0080] S202, loading target data required for generating a target class report from a data file.

[0081] In one embodiment, a cyclic timed startup task can be set, that is, based on the historical loading time of the target data required for the target type report and the target loading completion time, a preset loading start time (such as 5 a.m. every day) is set, and then the target data required for generating the target type report is loaded at the preset loading start time.

[0082] Optionally, at least one target zipper table that the target class report depends on may be determined, that is, at least one target zipper table required for generating the target class report may be determined, and then target data required for generating the target class report may be loaded from the target zipper table.

[0083] S203, obtaining a preset script program corresponding to the target report.

[0084] Optionally, the preset script program may be, for example, a preset view SQL statement for generating a target report. It should be noted that the preset script program may also be other scripting languages ​​for generating a target report, which is not specifically limited here.

[0085] In one embodiment, a preset script program can be written based on the target report and the data required to generate the target report.

[0086] S204: Generate a target report corresponding to a preset time period according to the target data and a preset script program.

[0087] In one embodiment, the target data may be initially processed by a preset script program to obtain an intermediate report, and then a target type report may be obtained from the intermediate report according to preset rules.

[0088] Among them, the intermediate report can be, for example, a report with a larger scope. In other words, the data dimension in the intermediate report is larger, contains more information, and is provided to developers or technicians. The target report can be a report used for display or provided to business personnel, so the data dimension is smaller.

[0089] In an embodiment of the present application, by obtaining a data file within a preset time period from a data warehouse, loading the target data required for generating a target type report from the data file, obtaining a preset script program corresponding to the target type report, and generating the target type report corresponding to the preset time period based on the target data and the preset script program, it is possible to periodically and automatically obtain data from the data warehouse, and generate a target type report based on the obtained data through the preset script program, thereby reducing repeated development of script programs, meeting the custom development of business reports through the configurable development of the database, simplifying the report generation operation, and improving the agility and timeliness of report development.

[0090] Referring to FIG. 3 , FIG. 3 is a flow chart of a method for generating a target report provided by an embodiment of the present application. This embodiment relates to a possible implementation method of how to generate a target report corresponding to a preset time period based on target data and a preset script program. Based on the above embodiment, the above S204 includes the following steps:

[0091] S301, at a first preset time, determining whether target data meets report generation requirements.

[0092] The first preset time is a preset timing for generating a target report.

[0093] Optionally, the report generation requirement may be, for example, at least one of the following: target data is loaded completely, the format of the target data complies with the requirement of a preset script program, and the generation time of the content in the target data complies with a preset time requirement.

[0094] For example, if the report generation requirement is that the target data has been loaded, it can be determined at the first preset time whether the target data has been loaded. If the report generation requirement is that the format of the target data meets the requirements of the preset script program, it can be determined at the first preset time whether the target data meets the requirements of the preset script program. If the report generation requirement is that the generation time of the content in the target data meets the preset time requirement, it can be determined at the first preset time whether the generation time of each data in the target data is within the preset time period.

[0095] In one embodiment, a timed loop task may be set to determine whether the target data meets the report generation requirements at preset time intervals. If the target data meets the report generation requirements and the first preset time has not arrived, the target data may be temporarily stored, and then data for generating other types of reports may continue to be loaded.

[0096] The preset time interval may be, for example, one minute.

[0097] S302: If the target data meets the report generation requirements, a target report is generated according to the target data using a preset script program.

[0098] Exemplarily, assuming that the report generation requirement is that the target data is loaded, the target data is loaded at the first preset time, indicating that the target data meets the report generation requirement, and then a preset script program is used to generate a target type report based on the target data.

[0099] In one embodiment, the target data may be initially processed by a preset script program to obtain an intermediate report, and then a target type report may be obtained from the intermediate report according to preset rules.

[0100] S303: If the target data does not meet the report generation requirement, suspending the generation of the target report and generating a first prompt message.

[0101] The first prompt information is used to indicate that an abnormality occurs in the target data.

[0102] Exemplarily, assuming that the report generation requirement is that the target data is loaded, if the target data is not loaded at the first preset time, it means that the target data does not meet the report generation requirements. Then the generation of the target type report is suspended, and the generation of the target type report is skipped, and a report with other data that has been loaded is generated first.

[0103] In addition, when the generation of the target report is suspended, a first prompt message indicating that the target data is abnormal is also generated, and the first prompt message is displayed, or the first prompt message is sent to the target terminal to prompt relevant personnel that the target data is abnormal through the first prompt message.

[0104] In the embodiment of the present application, at the first preset moment, it is determined whether the target data meets the report generation requirements. The first preset moment is a preset timing moment for generating a target class report. If the target data meets the report generation requirements, a preset script program is used to generate a target class report according to the target data. If the target data does not meet the report generation requirements, the generation of the target class report is suspended and a first prompt message is generated, so that other reports can be processed first when the target data is not loaded, thereby improving the flexibility and timeliness of report generation and avoiding inaccurate target class reports generated due to incomplete target data loading. In addition, the user can be prompted by the first prompt message to remind relevant personnel to handle the abnormalities in the target data loading in a timely manner, further improving the reliability of report generation.

[0105] Referring to Figure 4, Figure 4 is a flow chart of a method for determining a generation state provided in an embodiment of the present application. Based on the above embodiment, the method further includes the following steps:

[0106] S401, at a second preset time, determining a generation status of a target report.

[0107] The second preset time is a preset target timing for generating a target type report.

[0108] In one embodiment, when the target data meets the report generation requirements, a target report corresponding to a preset time period can be generated according to the target data and a preset script program, and after the target report is generated, the generation status of the target report is set to completed.

[0109] Optionally, if the target class report has not been generated, or the target class report has not been completely generated, the generation status of the target class report is set to generating.

[0110] In a possible implementation, the report can be reprocessed by modifying the generation status of the report. For example, the status of the completed first report can be modified to be generated again, and the first report can be added to the report generation queue again to generate the report again based on the data and the preset script program.

[0111] S402: If the generation status of the target report is in the process of being generated, suspending the generation of the target report and generating a second prompt message.

[0112] The second prompt information is used to indicate that an abnormality occurs in the generation of the target report.

[0113] In one embodiment, if the generation status of the target class report is "generating" at the target timing for generating the target class report, the generation of the target class report is paused, a second prompt message is generated to indicate that an abnormality has occurred in the generation of the target class report, and the second prompt message is displayed, or the second prompt message is sent to the target terminal to prompt relevant personnel through the second prompt message that an abnormality has occurred in the generation of the target class report.

[0114] Optionally, after receiving the second prompt information, the relevant personnel can check the target report generation log, etc., and promptly troubleshoot problems that occur when the target report is generated. In addition, the relevant personnel can also rewrite the generation script program, and generate the report manually based on the target data and the rewritten script program.

[0115] In an embodiment of the present application, at a second preset moment, the generation status of the target class report is determined, and the second preset moment is a preset target timing moment for generating the target class report. If the generation status of the target class report is generating, the generation of the target class report is suspended, and a second prompt message is generated to indicate that an abnormality has occurred in the generation of the target class report, thereby improving the flexibility and timeliness of report generation. In addition, the second prompt message can be used to remind the user that relevant personnel can be promptly processed when an abnormality has occurred in the generation of the target class report, thereby further improving the reliability of report generation.

[0116] Referring to Figure 5, Figure 5 is a flow chart of a target data loading method provided in an embodiment of the present application. Based on the above embodiment, the above S201 includes the following steps:

[0117] S501, updating data in a data file within a preset time period into at least one zipper table of a local database.

[0118] Optionally, the data in the data file within a preset time period may be directly updated in at least one zipper table of the local database.

[0119] Alternatively, the data in the data file may be temporarily stored in an incremental table of a local database, and then the data in the incremental table may be updated to the zipper table according to a preset configuration rule.

[0120] The incremental table is only used to store short-term data, such as 24-hour data, while the zipper table is used to store stock data. Temporarily storing the data in the data file in the incremental table can relieve the storage pressure of the zipper table, speed up the data storage rate, and reduce the probability of errors in data storage.

[0121] Based on the above embodiment, the above S202 includes the following steps:

[0122] S502: Determine at least one target zipper table required for generating a target class report from at least one zipper table.

[0123] S503, loading target data in the target zipper table.

[0124] In one embodiment, at least one target zipper table that the target class report depends on may be determined, that is, at least one target zipper table required for generating the target class report may be determined, and then target data required for generating the target class report may be loaded from the target zipper table.

[0125] In an embodiment of the present application, data in a data file within a preset time period is updated to at least one zipper table in a local database, at least one target zipper table required for generating a target class report is determined from the at least one zipper table, and the target data in the target zipper table is loaded, so that a target class report can be generated based on the data in at least one target zipper table on which the target class report depends, thereby reducing the interference of irrelevant data on report generation, thereby improving the efficiency and accuracy of report generation.

[0126] Referring to FIG. 6 , FIG. 6 is a flow chart of a data updating method provided by an embodiment of the present application. This embodiment relates to a possible implementation method of how to update data in a data file within a preset time period to at least one zipper table in a local database. Based on the above embodiment, the above S501 includes the following steps:

[0127] S601, adding data in a data file within a preset time period to an incremental table of a local database.

[0128] In a possible implementation, after obtaining data files within a preset time period in the data warehouse, the data in the data files may be temporarily stored in an incremental table of a local database.

[0129] The incremental table is only used to store short-term data, such as 24-hour data.

[0130] S602: Update the data in the incremental table to at least one zipper table in the local database.

[0131] In a possible implementation, the data in the incremental table may be updated to the zipper table according to a preset configuration rule.

[0132] Among them, the zipper table is used to store stock data.

[0133] In an embodiment of the present application, data in a data file within a preset time period is added to an incremental table of a local database, and the data in the incremental table is updated to at least one zipper table in the local database. The incremental table can alleviate the storage pressure of the zipper table, speed up the data storage rate, and reduce the probability of errors during data storage.

[0134] Referring to FIG. 7 , FIG. 7 is a flow chart of an automatic report generation method based on database configuration provided in an embodiment of the present application. The method comprises the following steps:

[0135] S701, adding data in a data file within a preset time period to an incremental table of a local database.

[0136] S702, update the data in the incremental table to at least one zipper table in the local database.

[0137] S703: Determine at least one target zipper table required for generating a target class report from at least one zipper table.

[0138] S704, loading target data in the target zipper table.

[0139] S705: At a first preset time, determine whether the target data meets the report generation requirements.

[0140] S706: If the target data meets the report generation requirements, a target report is generated according to the target data using a preset script program.

[0141] S707: If the target data does not meet the report generation requirement, suspending the generation of the target report and generating a first prompt message.

[0142] S708: At a second preset time, determining a generation status of a target report.

[0143] S709: If the generation status of the target report is in the process of being generated, suspending the generation of the target report and generating a second prompt message.

[0144] In order to introduce the embodiment of the present application more clearly, an exemplary description is given here in conjunction with Figure 8. Figure 8 is a flow chart of an automated report generation method provided by the embodiment of the present application. As shown in Figure 8, each system of the bank transmits the data generated within a day, that is, the end-of-day supply data, to the data warehouse, and the data warehouse can classify, filter, and convert the format of the data transmitted by each system. Then the data is transmitted to the report processing system in the form of a file in a specific format for report generation, and then the generated target report is displayed. Among them, the report processing system is deployed on the computer device that implements the above-mentioned report generation method.

[0145] 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.

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

[0147] In one embodiment, as shown in FIG. 9 , FIG. 9 is a structural block diagram of a report generation device provided in an embodiment of the present application, and the device 900 includes:

[0148] The first acquisition module 901 is used to acquire data files within a preset time period from a data warehouse.

[0149] The loading module 902 is used to load target data required for generating a target type report from a data file.

[0150] The second acquisition module 903 is used to acquire a preset script program corresponding to a target type report.

[0151] The generating module 904 is used to generate a target type report corresponding to a preset time period according to the target data and a preset script program.

[0152] In one embodiment, the generating module 904 includes:

[0153] The judgment unit is used to judge whether the target data meets the report generation requirement at a first preset time, and the first preset time is a preset timing time for generating the target type report.

[0154] The generating unit is used to generate a target type report according to the target data by using a preset script program if the target data meets the report generation requirements.

[0155] The prompt unit is used to suspend the generation of the target report and generate a first prompt message if the target data does not meet the report generation requirements; the first prompt message is used to indicate that the target data is abnormal.

[0156] In one embodiment, the report generation requirement includes at least one of the following:

[0157] The target data has been loaded.

[0158] The format of the target data meets the requirements of the preset script program.

[0159] The generation time of the content in the target data meets the preset time requirement.

[0160] In one embodiment, the apparatus 900 further includes:

[0161] The determination module is used to determine the generation status of the target type report at a second preset time, and the second preset time is a preset target timing time for generating the target type report.

[0162] The prompt module is used to suspend the generation of the target report if the generation status of the target report is in the generating state, and generate a second prompt message; the second prompt message is used to indicate that the generation of the target report is abnormal.

[0163] In one embodiment, the first acquisition module 901 includes:

[0164] The updating unit is used to update the data in the data file within a preset time period into at least one zipper table of the local database.

[0165] The loading module 902 includes:

[0166] A determination unit is used to determine at least one target zipper table required to generate a target class report from at least one zipper table.

[0167] A loading unit is used to load target data in a target zipper table.

[0168] In one embodiment, the determining unit includes:

[0169] An adding subunit is used to add data in a data file within a preset time period to an incremental table of a local database;

[0170] The updating subunit is used to update the data in the incremental table to at least one zipper table in the local database.

[0171] Each module in the above-mentioned report generation 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.

[0172] In one embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and when the processor executes the computer program, the following steps are implemented:

[0173] Obtain data files within a preset time period from the data warehouse;

[0174] Load the target data required to generate the target class report from the data file;

[0175] Get the preset script program corresponding to the target report;

[0176] Generate target reports corresponding to the preset time period based on target data and preset script programs.

[0177] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0178] At a first preset time, determining whether the target data meets the report generation requirement, the first preset time being a preset timing time for generating a target type report;

[0179] If the target data meets the report generation requirements, a preset script program is used to generate a target report based on the target data;

[0180] If the target data does not meet the report generation requirements, the generation of the target report is suspended and a first prompt message is generated; the first prompt message is used to indicate that an abnormality occurs in the target data.

[0181] In one embodiment, the report generation requirement includes at least one of the following:

[0182] The target data has been loaded;

[0183] The format of the target data meets the requirements of the preset script program;

[0184] The generation time of the content in the target data meets the preset time requirement.

[0185] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0186] At a second preset time, determining a generation state of a target report, the second preset time being a preset target timing time for generating the target report;

[0187] If the generation status of the target report is in the process of being generated, the generation of the target report is suspended and a second prompt message is generated; the second prompt message is used to indicate that an abnormality occurs in the generation of the target report.

[0188] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0189] Updating the data in the data file within a preset time period into at least one zipper table in the local database;

[0190] Determine at least one target zipper table required for generating a target class report from at least one zipper table;

[0191] Load the target data in the target zipper table.

[0192] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0193] Add the data in the data file within the preset time period to the incremental table of the local database;

[0194] Update the data in the incremental table to at least one zipper table in the local database.

[0195] In one embodiment, a computer readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:

[0196] Obtain data files within a preset time period from the data warehouse;

[0197] Load the target data required to generate the target class report from the data file;

[0198] Get the preset script program corresponding to the target report;

[0199] Generate target reports corresponding to the preset time period based on target data and preset script programs.

[0200] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0201] At a first preset time, determining whether the target data meets the report generation requirement, the first preset time being a preset timing time for generating a target type report;

[0202] If the target data meets the report generation requirements, a preset script program is used to generate a target report based on the target data;

[0203] If the target data does not meet the report generation requirements, the generation of the target report is suspended and a first prompt message is generated; the first prompt message is used to indicate that an abnormality occurs in the target data.

[0204] In one embodiment, the report generation requirement includes at least one of the following:

[0205] The target data has been loaded;

[0206] The format of the target data meets the requirements of the preset script program;

[0207] The generation time of the content in the target data meets the preset time requirement.

[0208] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0209] At a second preset time, determining a generation state of a target report, the second preset time being a preset target timing time for generating the target report;

[0210] If the generation status of the target report is in the process of being generated, the generation of the target report is suspended and a second prompt message is generated; the second prompt message is used to indicate that an abnormality occurs in the generation of the target report.

[0211] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0212] Updating the data in the data file within a preset time period into at least one zipper table in the local database;

[0213] Determine at least one target zipper table required for generating a target class report from at least one zipper table;

[0214] Load the target data in the target zipper table.

[0215] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0216] Add the data in the data file within the preset time period to the incremental table of the local database;

[0217] Update the data in the incremental table to at least one zipper table in the local database.

[0218] In one embodiment, a computer program product is provided, comprising a computer program, which, when executed by a processor, implements the following steps:

[0219] Obtain data files within a preset time period from the data warehouse;

[0220] Load the target data required to generate the target class report from the data file;

[0221] Get the preset script program corresponding to the target report;

[0222] Generate target reports corresponding to the preset time period based on target data and preset script programs.

[0223] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0224] At a first preset time, determining whether the target data meets the report generation requirement, the first preset time being a preset timing time for generating a target type report;

[0225] If the target data meets the report generation requirements, a preset script program is used to generate a target report based on the target data;

[0226] If the target data does not meet the report generation requirements, the generation of the target report is suspended and a first prompt message is generated; the first prompt message is used to indicate that an abnormality occurs in the target data.

[0227] In one embodiment, the report generation requirement includes at least one of the following:

[0228] The target data has been loaded;

[0229] The format of the target data meets the requirements of the preset script program;

[0230] The generation time of the content in the target data meets the preset time requirement.

[0231] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0232] At a second preset time, determining a generation state of a target report, the second preset time being a preset target timing time for generating the target report;

[0233] If the generation status of the target report is in the process of being generated, the generation of the target report is suspended and a second prompt message is generated; the second prompt message is used to indicate that an abnormality occurs in the generation of the target report.

[0234] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0235] Updating the data in the data file within a preset time period into at least one zipper table in the local database;

[0236] Determine at least one target zipper table required for generating a target class report from at least one zipper table;

[0237] Load the target data in the target zipper table.

[0238] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0239] Add the data in the data file within the preset time period to the incremental table of the local database;

[0240] Update the data in the incremental table to at least one zipper table in the local database.

[0241] 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.

[0242] 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.

[0243] 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.

[0244] 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 generation method, characterized in that: The method comprises: Obtain data files within a preset time period from the data warehouse; Loading target data required for generating a target class report from the data file; Get the preset script program corresponding to the target report; The target type report corresponding to the preset time period is generated according to the target data and the preset script program.

2. The method according to claim 1, characterized in that The step of generating the target report corresponding to the preset time period according to the target data and the preset script program includes: At a first preset time, determining whether the target data meets the report generation requirement, the first preset time being a preset timing time for generating the target type report; If the target data meets the report generation requirements, the target report is generated according to the target data using the preset script program; If the target data does not meet the report generation requirements, the generation of the target report is suspended and a first prompt message is generated; the first prompt message is used to indicate that an abnormality occurs in the target data.

3. The method according to claim 2, characterized in that The report generation requirements include at least one of the following: The target data has completed loading; The format of the target data meets the requirements of the preset script program; The generation time of the content in the target data meets the preset time requirement.

4. The method according to claim 1, characterized in that: The method further comprises: At a second preset time, determining a generation status of the target report, wherein the second preset time is a preset target timing time for generating the target report; If the generation status of the target report is in the process of being generated, the generation of the target report is suspended, and a second prompt message is generated; the second prompt message is used to indicate that an abnormality occurs in the generation of the target report.

5. The method according to claim 1, characterized in that The step of acquiring data files within a preset time period from the data warehouse includes: Updating the data in the data file within the preset time period into at least one zipper table in the local database; The step of loading target data required for generating a target report from the data file includes: Determine at least one target zipper table required for generating a target class report from the at least one zipper table; The target data in the target zipper table is loaded.

6. The method according to claim 5, characterized in that The updating of the data in the data file within the preset time period into at least one zipper table in the local database includes: Adding the data in the data file within the preset time period to the incremental table of the local database; The data in the incremental table is updated to at least one zipper table in the local database.

7. A report generation device, characterized in that: The device comprises: A first acquisition module is used to acquire data files within a preset time period from a data warehouse; A loading module, used for loading target data required for generating a target class report from the data file; The second acquisition module is used to acquire the preset script program corresponding to the target report; A generation module is used to generate the target type report corresponding to the preset time period according to the target data and the preset script program.

8. The device according to claim 7, characterized in that The generation module comprises: A judgment unit, used to judge whether the target data meets the report generation requirement at a first preset time, where the first preset time is a preset timing time for generating the target type report; A generating unit, configured to generate the target type report according to the target data by using the preset script program if the target data meets the report generation requirement; The prompt unit is used to suspend the generation of the target report and generate a first prompt message if the target data does not meet the report generation requirements; the first prompt message is used to indicate that the target data is abnormal.

9. The device according to claim 8, characterized in that The report generation requirements include at least one of the following: The target data has completed loading; The format of the target data meets the requirements of the preset script program; The generation time of the content in the target data meets the preset time requirement.

10. The device according to claim 7, characterized in that The device also includes: A determination module, used to determine the generation status of the target report at a second preset time, where the second preset time is a preset target timing time for generating the target report; The prompt module is used to suspend the generation of the target report if the generation status of the target report is in the generating state, and generate a second prompt message; the second prompt message is used to indicate that the generation of the target report is abnormal.

11. The device according to claim 7, characterized in that The first acquisition module includes: An updating unit, configured to update the data in the data file within the preset time period into at least one zipper table in the local database; The loading module includes: A determination unit, configured to determine at least one target zipper table required for generating a target class report from the at least one zipper table; A loading unit is used to load the target data in the target zipper table.

12. The device according to claim 11, characterized in that The determining unit comprises: An adding subunit, used to add the data in the data file within the preset time period to the incremental table of the local database; An updating subunit is used to update the data in the incremental table to at least one zipper table in the local database.

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

14. 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.

15. A computer program product comprising a computer program, 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