Report processing method, apparatus, device, medium, and product

Abstract

The application discloses a report processing method, device, equipment, medium and product, and applies to the technical field of data processing, wherein the method comprises the following steps: in response to a report display triggering operation, a first report is displayed, and the process of obtaining the first report comprises the following steps: a first pre-rendering page template of the first report is acquired, a first group of report data in a first storage space, and a second group of report data in a second storage space; the first storage space is a temporary cache space of a business report system, and the second storage space is a storage space of a database system corresponding to the business report system; the first pre-rendering page template, the first group of report data and the second group of report data are combined to obtain the first report. The technical scheme of the embodiment of the application solves the problem that the business form query response is slow, can quickly respond to the form display demand, and improves the security of the business form data.

Description

Technical Field

[0001] This invention relates to the field of computer technology, and in particular to a report processing method, apparatus, device, medium, and product. Background Technology

[0002] Reporting tools can be used for business data management and display during business development. In complex business scenarios, business reports typically involve large amounts of data and relatively complex calculations.

[0003] However, in the process of implementing the present invention, it was found that the prior art has at least the following technical problems: when dealing with large amounts of data and complex business, configurable dynamic business reports have slow data query response and may have potential security risks. Summary of the Invention

[0004] This invention provides a report processing method, apparatus, device, medium, and product that can quickly respond to form display needs and improve the security of business form data.

[0005] In a first aspect, embodiments of the present invention provide a report processing method, the method comprising: In response to a report display trigger operation, the first report is displayed. The first report is the business report associated with the report display trigger operation. The process of obtaining the first report includes: Obtain the first pre-rendered page template of the first report, the first set of report data in the first storage space, and the second set of report data in the second storage space; the first storage space is the temporary cache space of the business report system, and the second storage space is the storage space of the database system corresponding to the business report system; The first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report.

[0006] Secondly, embodiments of the present invention also provide a report processing apparatus, the apparatus comprising: The report visualization module is used to respond to the report display trigger operation and display the first report, which is the business report associated with the report display trigger operation; The report visualization module includes a report combination sub-module, which is used for specific purposes: Obtain the first pre-rendered page template of the first report, the first set of report data in the first storage space, and the second set of report data in the second storage space; the first storage space is the temporary cache space of the business report system, and the second storage space is the storage space of the database system corresponding to the business report system; The first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report.

[0007] Thirdly, embodiments of the present invention also provide an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the report processing method as described in any of the embodiments of the present invention.

[0008] Fourthly, embodiments of the present invention also provide a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the report processing method as described in any of the embodiments of the present invention.

[0009] Fifthly, embodiments of the present invention also provide a computer program product, including a computer program that, when executed by a processor, implements the report processing method as described in any of the embodiments of the present invention.

[0010] In this embodiment of the invention, a first report is displayed in response to a report display trigger operation. The first report is a business report associated with the report display trigger operation. The process of obtaining the first report includes: acquiring a first pre-rendered page template of the first report, a first set of report data in a first storage space, and a second set of report data in a second storage space; the first storage space is a temporary cache space for the business report system, and the second storage space is the storage space of the database system corresponding to the business report system; the first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report. The technical solution of this embodiment of the invention solves the problem of slow response to business form queries, enabling rapid response to form display needs and improving the security of business form data. Attached Figure Description

[0011] To more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings used in the embodiments will be briefly introduced below. It should be understood that the following drawings only show some embodiments of the present invention and should not be regarded as a limitation on the scope. For those skilled in the art, other related drawings can be obtained based on these drawings without creative effort.

[0012] Figure 1 A flowchart of a report processing method provided in an embodiment of the present invention; Figure 2 A flowchart illustrating yet another report processing method provided in this embodiment of the invention; Figure 3 A flowchart illustrating yet another report processing method provided in an embodiment of the present invention; Figure 4 A flowchart illustrating an application example of a report processing method provided in this embodiment of the invention; Figure 5This is a schematic diagram of a report data processing process provided in an embodiment of the present invention; Figure 6 This is a schematic diagram of the structure of a report processing device provided in an embodiment of the present invention; Figure 7 This is a schematic diagram of the structure of a computer device provided in an embodiment of the present invention. Detailed Implementation

[0013] The present invention will now be described in further detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and not intended to limit it. Furthermore, it should be noted that, for ease of description, the accompanying drawings show only the parts relevant to the present invention, and not all of the structures.

[0014] It should be noted that similar reference numerals and letters in the following figures indicate similar items; therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures. Furthermore, in the description of this invention, terms such as "first," "second," etc., are used only for distinguishing descriptions and should not be construed as indicating or implying relative importance. The acquisition, storage, use, and processing of data in the technical solutions of this application all comply with relevant laws and regulations.

[0015] It should be noted that in the embodiments of this application, certain software, components, models and other existing solutions in the industry may be mentioned. These should be regarded as exemplary and are only intended to illustrate the feasibility of implementing the technical solution of this application. However, it does not mean that the applicant has used or necessarily used the relevant content of the solution.

[0016] Figure 1 This is a flowchart illustrating a report processing method provided in an embodiment of the present invention. This embodiment is applicable to business report processing and display scenarios. The method can be executed by a report processing device, which can be implemented in software and / or hardware and integrated into a computer device.

[0017] like Figure 1 As shown, the report processing method includes the following steps: S110, In response to the report display trigger operation, display the first report.

[0018] Report display triggers can be actions performed by system users on the front-end interface of the business reporting system, where they execute report processing methods. For example, a user clicking a menu, button, or link on a report could be an action that requests to view a business report.

[0019] The first report is the business report associated with the triggered operation, which is the final data display result that the user expects to see, such as "Monthly Sales Performance Report" or "Inventory Warning List" and other business reports under different business scenarios.

[0020] In one optional implementation, after a user executes a report display trigger operation on the front-end interface of the business reporting system, the back-end of the business reporting system receives the report display trigger operation, thus confirming the user's report display request. Subsequently, the business reporting system can initiate a process of acquiring and combining report data and report page templates based on the report identifier carried in the request, and finally present the generated first report to the user in a visual form, quickly responding to the user's request.

[0021] The business reporting system can retrieve the first pre-rendered page template of the first report from the system's temporary cache space, simultaneously query and retrieve the first set of report data from the temporary cache space, and then query and retrieve the second set of report data from the database system's storage space. The system then combines these three parts to generate the complete first report and returns it to the business reporting front-end for display. This process balances the real-time nature of data retrieval with the performance advantages of caching by separating the data storage sources. The database system's storage space can be either the database's memory cache space or disk cache space, and the second set of report data can be a temporary data table in the memory cache space or disk cache space.

[0022] For example, the process of obtaining the first report can be referred to as follows: Figure 2 The process shown includes: S1101. Obtain the first pre-rendered page template of the first report, the first set of report data in the first storage space, and the second set of report data in the second storage space.

[0023] The first storage space serves as a temporary cache for the business reporting system, storing frequently accessed but infrequently updated data or static resources. Its fast access speed effectively improves system response efficiency. The second storage space is the storage space for the database system corresponding to the business reporting system. This database system storage space can be either memory cache or disk cache. Different data storage spaces correspond to different data read speeds. By caching different report data in different data storage spaces, tiered data storage is achieved.

[0024] Furthermore, the first pre-rendered page template in this step can refer to the page structure framework of the first report, which defines the static presentation elements such as the report's layout, style, and chart containers. This template can be pre-rendered and stored in a temporary cache before the user requests it.

[0025] The first set of report data refers to a portion of the report data stored in the first storage space. This typically consists of relatively static, infrequently changing, or quickly displayed basic data from the first report, such as user information, configuration options, or historical statistics. Alternatively, it can be business data specified based on the configuration.

[0026] The second set of report data can refer to another part of the report data stored in the second storage space. It usually includes core business data that has high real-time requirements and is dynamically changing, such as the latest transaction records and order status.

[0027] Before generating the first report, the business reporting system retrieves different types of data from different storage media in parallel or serially, according to the preset data source configuration for the first report. In one optional implementation, the business reporting system determines the data source of the report data based on the configuration information of the first report. The business reporting system can access the first storage space through a cache interface, locate and read the first pre-rendered page template corresponding to the first report, and simultaneously obtain the first set of report data. Then, the business reporting system accesses the second storage space through a database connection, executes predefined query statements, and obtains the second set of report data.

[0028] In another alternative implementation, the business reporting system may also employ a cache-first retrieval strategy. When retrieving all the components required for the first report, it first attempts to retrieve the first pre-rendered page template and the first set of report data associated with each template from the first pre-rendered page template in the first storage space. If the cache is not found, the business reporting system automatically downgrades, querying the corresponding first set of report data and second set of report data from the second storage space, and then backfilling the first set of report data into the first storage space for future use.

[0029] S1102. Combine the first pre-rendered page template, the first set of report data, and the second set of report data to obtain the first report.

[0030] Combining the first pre-rendered page template, the first set of report data, and the second set of report data refers to the process of integrating and rendering independent page templates and data according to preset rules, positions, and formats, so that the data and structure are merged into a complete and presentable report page.

[0031] After combining the first pre-rendered page template, the first set of report data, and the second set of report data, a complete final report file or page code containing data content is generated, which can be directly displayed in the user interface.

[0032] After obtaining all the components of the report, the business reporting system executes the combination logic to fill the first set of report data and the second set of report data into the specified positions of the first pre-rendered page template, generating the final report content. In one optional implementation, the business reporting system performs template and data combination on the front end, while the back end interface is only responsible for returning the code string of the first pre-rendered page template, the first set of report data, and the second set of report data (usually in structured data format). After receiving this data, the front end uses the template rendering capabilities of the front-end framework to dynamically bind the data to the template, completing the final combination and page rendering on the user's browser.

[0033] The technical solution of this invention displays a first report in response to a report display trigger operation. The first report is a business report associated with the report display trigger operation. The process of obtaining the first report includes: acquiring a first pre-rendered page template, a first set of report data in a first storage space, and a second set of report data in a second storage space. The first storage space is a temporary cache space for the business report system, and the second storage space is the storage space of the database system corresponding to the business report system. The first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report. This invention solves the problem of slow response times for business form queries. By utilizing a temporary cache space to carry the pre-rendered template and part of the report data, it significantly reduces the query pressure and resource consumption of the core database system, improving the report's response performance in high-concurrency scenarios. Furthermore, by introducing a layered storage and data combination mechanism, it effectively avoids security risks such as SQL injection caused by directly concatenating SQL (Structured Query Language) statements in database queries.

[0034] Figure 3 This is a flowchart illustrating a report processing method provided in an embodiment of the present invention. This embodiment is applicable to scenarios involving business report processing and display. The method can be executed by a report processing device, implemented in software and / or hardware, and integrated into a computer device.

[0035] like Figure 3 As shown, the report processing method includes the following steps: S210. In response to the startup of the business report system, obtain the first set of business reports.

[0036] The first business report set is a collection of pre-configured business reports in the business report system; this set contains all available report definition information in the system, such as report identifier, name, structure configuration, etc.

[0037] The startup of a business reporting system can refer to the initialization process of the reporting system service changing from a stopped state to a running state, such as when the application server starts, the service container is initialized, or the system starts running after its initial deployment.

[0038] When the business reporting system starts, it automatically triggers an initialization process, retrieving metadata information for all defined reports from the configuration storage to obtain the first set of business reports. The business reporting system then loads this set into memory for subsequent processing steps.

[0039] S220. For each business report in the first business report set, perform pre-rendering of the report page based on the report structure configuration information of each business report to obtain the pre-rendered page template corresponding to each business report.

[0040] Report structure configuration information refers to configuration data that describes the structure of each business report page, including the report layout style, chart type, data field binding rules, display component definition, etc.

[0041] The pre-rendered page template is a page framework that is pre-processed and generated based on the report structure configuration information and can be directly used for display. The template already contains static elements such as layout structure and component styles, but has not yet been populated with specific business data.

[0042] The business reporting system can iterate through the first set of business reports, read the structure configuration information of each report in the set, and perform rendering processing to generate a corresponding pre-rendered page template. For example, the business reporting system can process each report in the first set of business reports one by one. For each report, the system parses its report structure configuration information, calls the template engine to generate a complete page template based on the layout, components, and styles defined in the configuration, and stores the generated template with the report identifier as the pre-rendered page template corresponding to that report. Alternatively, the business reporting system can adopt a parallel processing approach, using multi-threaded or asynchronous tasks to process the pre-rendering of multiple business reports simultaneously. For reports in the first set of business reports, the business reporting system submits the pre-rendering task of each report to a thread pool for parallel execution to obtain the pre-rendered page template corresponding to each report in the first set of business reports.

[0043] S230: Load the first set of report data from the second storage space into the first storage space.

[0044] The first set of report data can refer to a pre-selected portion of report data that is suitable for placement in a temporary cache. This typically consists of data that is frequently accessed, has low real-time requirements, or does not change frequently, such as basic dictionary data, historical summary data, or common configuration data for reports.

[0045] The first storage space refers to the temporary cache space within the business reporting system, used to store frequently accessed data. Its fast access speed effectively improves system response efficiency. The second storage space can be the memory cache space and disk storage space of the database system corresponding to the business reporting system, used to store core business data. For example, the intermediate temporary table processed in the second set of report data can exist in the database system's memory cache space, while the corresponding temporary source data table can exist in the database system's disk storage space. After the business reporting system starts, it can filter and extract the first set of report data corresponding to each business report from the second storage space of the database system, and write it to the temporary cache space for quick access when displaying the reports later.

[0046] For example, the business reporting system can determine, based on predefined rules, which data belongs to the first group of report data for each business report in the first business report set. The business reporting system can establish a connection with the second storage space, execute query statements to retrieve this data, and then write the query results back to the first storage space through a caching interface, thus completing the data preloading.

[0047] It is understandable that S230 and S220 do not have a strict execution order and can be executed simultaneously.

[0048] S240. In response to the report display trigger operation, display the first report, which is the business report associated with the report display trigger operation.

[0049] The process of obtaining the first report may include acquiring a first pre-rendered page template for the first report, a first set of report data in a first storage space, and a second set of report data in a second storage space. Then, the first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report, which is then displayed.

[0050] For example, when a user executes a report display trigger operation on the front-end interface of the business reporting system, the back-end of the business reporting system receives the report display trigger operation, thus confirming the user's report display request. Subsequently, the business reporting system can initiate a process of acquiring and combining report data and report page templates based on the report identifier carried in the request, and finally present the generated first report to the user in a visual form, quickly responding to the user's request.

[0051] Furthermore, the first and second sets of report data can be the results of preprocessing by the database system based on the configuration results of the first business report. For example, the database system can run a scheduled data processing task to process the business data associated with the first report on day T at a certain time on day T+1, obtaining the first and second sets of report data. Of course, depending on the granularity or dimension of data segmentation during data processing, more than two sets of report data can be obtained.

[0052] In another scenario, the first and second sets of report data can be distinguished based on their data caching locations. The first set of report data can be pre-loaded into the business reporting system's cache space, while the second set is stored in the database system's cache space. The second set of report data can also be a collection of multiple temporary data tables.

[0053] In one optional implementation, the processing of the first set of report data and the second set of report data may include the following steps: The first step is to group the data items in the database system according to the business data attributes of the business data items in the first report, and obtain at least two data item grouping results.

[0054] The key feature is that the business data attributes include at least one of the following: data update frequency, the business scenario to which the data belongs, and the business data source. These attributes can be metadata describing the characteristics and properties of the business data items, used to guide the system in classifying, storing, and processing the data items. Data update frequency refers to the time interval characteristic of changes to business data items in the database, such as real-time updates, hourly updates, daily updates, or very infrequent updates. The business scenario to which the data belongs can refer to the specific business area or application scenario associated with the business data item, such as a sales scenario, inventory scenario, financial scenario, or human resources scenario, which can correspond to different modules in a comprehensive report. The business data source can refer to the source system or database of the business data item, such as an order database, customer relationship management system, enterprise resource planning system, or external interface data.

[0055] The reason for data grouping is that, in this embodiment, a hierarchical data grouping strategy is adopted in the business reporting system. For example, the business reporting system first divides data items into different source groups based on the attributes of the business data source, and then further subdivides each source group based on the data update frequency attribute. For groups with low update frequency, the system stores the processing results as the first group of report data in the cache; for groups with high update frequency, the processing results are used as the second group of report data, which is calculated and obtained in real time when the user requests it.

[0056] The second step involves processing the report data according to the pre-configured data item processing rules in the first report for each data item grouping result, resulting in the first group of report data and at least one second group of report data.

[0057] Among them, the data item processing rules can be pre-configured processing logic definitions for each data item group, including data aggregation methods, calculation formulas, filtering conditions, transformation rules, etc., which can be used to guide how to process the raw data into the final data form required for the report.

[0058] Report data processing refers to the process of performing calculations, transformations, and aggregations on raw business data according to data item processing rules, transforming the raw data into final data that meets the requirements for report display.

[0059] In one optional implementation, the method of processing report data according to the pre-configured data item processing rules in the first report can be to generate a data processing script based on the pre-configured data item processing rules using a preset workshop model; then, based on the data processing script, data processing is performed on the data corresponding to each data item in the grouping result of each data item.

[0060] The pre-built workshop model refers to a pre-constructed processing model used to transform data processing rules into executable scripts. This model encapsulates the core logic of script generation, similar to a production workshop, where the input is configurable rules and the output is an executable processing script. Data item processing rules refer to the pre-configured processing logic definitions for each data item group, including data aggregation methods, calculation formulas, filtering conditions, transformation rules, etc., used to guide how to process raw data into the final data form required for reports. The data processing script is a program code snippet automatically generated by the pre-built workshop model according to the data item processing rules, which can be executed by the system. This script contains specific instructions for performing calculations, transformations, aggregations, and other operations on the raw data. The database system can input the pre-configured data item processing rules corresponding to each data item group into the pre-built workshop model. The pre-built workshop model parses these rules, identifies the aggregation functions, filtering conditions, and calculation expressions, and automatically generates the corresponding data processing script based on the parsing results. The script can be presented in the form of a structured query language or a program script, such as a Shell script. The data processing scripts are used to process the data corresponding to each data item in the grouping results. This process involves executing the scripts for each grouping result, processing the raw data associated with the data items in the group, and generating processed report data.

[0061] The technical solution of this invention, in response to the startup of a business report system, obtains a first set of business reports; the first set of business reports is a set of pre-configured business reports in the business report system; for each business report in the first set of business reports, pre-rendering of the report page is performed based on the report structure configuration information of each business report to obtain a pre-rendered page template corresponding to each business report; a first set of report data is loaded from a second storage space to a first storage space; in response to a report display trigger operation, a first report is displayed, the first report being the business report associated with the report display trigger operation; wherein, the process of obtaining the first report includes obtaining a first pre-rendered page template of the first report, a first set of report data in the first storage space, and a second set of report data in the second storage space; the first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report. The technical solution of this invention solves the problem of slow response to business form queries by advancing the pre-rendering of the report page template and the pre-loading of some data to the system startup stage, thereby reducing the consumption of database and central processing unit resources when users request data. Meanwhile, since the report generation process no longer relies on the fields and condition parameters passed from the front end for dynamic structured query language concatenation, it fundamentally avoids security risks such as structured query language injection, reduces direct exposure to core metadata, and improves the security of business data.

[0062] In an application example of a report processing method, a detailed explanation is provided using the store decoration score diagnostic report in e-commerce as an example. The final display process of the total store decoration score and the scores of each module is as follows: Figure 4 .

[0063] according to Figure 4 The process shown allows users to select the store decoration score table in the business reporting system. By using the corresponding control, they can open the store decoration score query page and query the total decoration score and detailed scores for each module. The business reporting system then determines whether the data in the store decoration score table comes from the corresponding temporary table (corresponding to the second set of report data cached in the database system's cache space in the aforementioned embodiment). If so, the corresponding data source temporary table is determined. Based on the report processing method and data source in the aforementioned embodiment, the pre-rendered page template of the store decoration score table, the first set of report data already loaded in the business reporting system, and the temporary table data from the database system are combined to obtain the store decoration score table and its performance display.

[0064] Furthermore, regarding the pre-rendered page template corresponding to the store decoration score table, reports such as the store decoration score table typically consist of dynamic content (such as display fields and filter conditions) and a static framework (such as rendering templates and display areas). Before the store decoration score table is displayed, the static data of the report needs to be pre-rendered and cached. In this process, to improve loading efficiency, the report data can be divided into static and dynamic parts. For static data such as information involved in the store decoration score table, such as fixed content like the report rendering template and display area layout, pre-rendering is performed on the NODE server corresponding to the front end of the business reporting system to generate an HTML fragment with a complete DOM structure (i.e., the pre-rendered page template corresponding to the report), and then cached. When a user requests the store decoration score table, this static page framework can be returned first and foremost, thereby improving loading speed.

[0065] In the rendering process of the pre-rendered page template, since the report rendering template is fixed and can be identified by the primary key ID of the corresponding business report, the system retrieves the corresponding static data from the database based on the ID. Matching the static statements with the report rendering template displays the basic display style and fundamental data of the store decoration content report. The field information displayed in this report uses empty DOM nodes as placeholders. All configured reports are processed sequentially and rendered into a complete HTML webpage. The pre-rendered HTML file is then published to the local cache of the business reporting system. When a user requests the report page, the system directly reads and returns this static page from the local cache. Because dynamic generation and network transmission delays are skipped, the page loads extremely quickly. Users can immediately see the rendered static content, such as the complete report layout framework and display area, thus receiving immediate visual feedback and significantly improving the user experience.

[0066] The form data in the store decoration score table is processed in batches using a dynamic data workshop model. The rendering of the dynamic data can be done on the browser side. Once the report display is triggered, a data request can be initiated. The returned dynamic data in the store decoration score table can be divided into main table data and auxiliary table data according to the change frequency (i.e., corresponding to the first and second group of report data in the aforementioned embodiment).

[0067] The main table contains basic information that changes infrequently, such as the store name, store operation information, and store merchant information. The auxiliary table contains business information that changes frequently, such as store image and text component decoration, store coupon component decoration, and store search keyword configuration.

[0068] The two types of data are cleaned and batch-processed using a workshop model, respectively. The processing steps can be referenced. Figure 5The data processing steps are shown below. The auxiliary table data related to store decoration undergoes n processing steps to calculate scores. The main table data of basic store information undergoes m processing steps. During processing, intermediate results can be cached in a temporary table, ultimately forming the displayed data. By separating static and dynamic data and using step-by-step intermediate caching, unnecessary data duplication is reduced, overall SQL complexity is lowered, and data statistics and query efficiency is improved. The n and m processing steps correspond to the data item processing rules configured in the store decoration score table.

[0069] After the report page template is pre-rendered and the data is processed offline, layered data storage and loading can be used to execute temporary report storage, enabling rapid data interaction and responding to business report tactical trigger operations. While the page content is complete after both static and dynamic data in the report are rendered, interactive functions (such as date filtering, data sorting, and score summary calculation) are not yet available. To achieve rapid interaction, the business reporting system can utilize intermediate result data stored in a temporary table during the step-by-step processing. When a user queries a store's decoration score, a lightweight query can be initiated directly to the temporary table storing the overall statistical score results for store decoration, and the result will be returned quickly. The entire process does not require access to the underlying original business tables, thus achieving real-time and efficient page interaction while maintaining data consistency.

[0070] Figure 6 This is a schematic diagram of the structure of a report processing device provided in an embodiment of the present invention. This embodiment is applicable to scenarios involving the display of business reports. The device can be implemented by software and / or hardware and integrated into a computer device.

[0071] like Figure 6 As shown, the report processing device includes a report visualization module 310.

[0072] The report visualization module 310 is used to respond to the report display trigger operation and display the first report, which is the business report associated with the report display trigger operation. The report visualization module 310 includes a report combination submodule, which is used to: obtain the first pre-rendered page template of the first report, the first set of report data in the first storage space, and the second set of report data in the second storage space; the first storage space is the temporary cache space of the business report system, and the second storage space is the storage space of the database system corresponding to the business report system; and combine the first pre-rendered page template, the first set of report data, and the second set of report data to obtain the first report.

[0073] The technical solution of this invention displays a first report in response to a report display trigger operation. The first report is a business report associated with the report display trigger operation. The process of obtaining the first report includes: acquiring a first pre-rendered page template of the first report, a first set of report data in a first storage space, and a second set of report data in a second storage space; the first storage space is a temporary cache space for the business report system, and the second storage space is the storage space of the database system corresponding to the business report system; the first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report. This technical solution solves the problem of slow response to business form queries, enabling rapid response to form display needs and improving the security of business form data.

[0074] In one optional implementation, the report processing apparatus further includes a template page pre-rendering module, used for: Before receiving the report display trigger operation, in response to the startup of the business report system, the first business report set is obtained; the first business report set is a set of pre-configured business reports in the business report system. For each business report in the first business report set, the report page is pre-rendered based on the report structure configuration information of each business report to obtain the pre-rendered page template corresponding to each business report.

[0075] In one optional implementation, the report processing apparatus further includes a data loading module for: Load the first set of report data from the second storage space into the first storage space.

[0076] In one optional implementation, the processing of the first set of report data and the second set of report data includes: In the database system, data items are grouped according to the business data attributes of the business data items in the first report to obtain at least two data item grouping results; For each data item grouping result, the report data is processed according to the pre-configured data item processing rules in the first report to obtain the first group of report data and at least one second group of report data.

[0077] In one optional implementation, the report data is processed according to the pre-configured data item processing rules in the first report, including: Data processing scripts are generated based on pre-configured data item processing rules using a preset workshop model; Based on the data processing script, the data corresponding to each data item in the grouping results are processed separately.

[0078] In one alternative implementation, the business data attributes include at least one of the following: data update frequency, the business scenario to which the data belongs, and the business data source.

[0079] In one optional implementation, the first report is an evaluation table of the item collection display scheme in the e-commerce business system; the first set of report data in the first report includes at least one of the following: item collection name, item collection attribute information, and information of the object to which the item collection belongs; the second set of report data in the first report includes the configuration information of the graphic components in the item collection display, the item collection search term setting information, and the item acquisition cost setting information in the item collection.

[0080] The report processing device provided in the embodiments of the present invention can execute the report processing method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the method execution.

[0081] Figure 7 This is a schematic diagram of the structure of a computer device provided in an embodiment of the present invention. Figure 7 A block diagram of an exemplary computer device 12 suitable for implementing embodiments of the present invention is shown. Figure 7 The computer device 12 shown is merely an example and should not be construed as limiting the functionality or scope of the embodiments of the present invention. The computer device 12 can be any terminal device with computing capabilities, such as intelligent controllers and servers, mobile phones, and other terminal devices.

[0082] like Figure 7 As shown, the computer device 12 is represented in the form of a general-purpose computing device. The components of the computer device 12 may include, but are not limited to: one or more processors or processing units 16, system memory 28, and bus 18 connecting different system components (including system memory 28 and processing unit 16).

[0083] Bus 18 represents one or more of several bus architectures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of the various bus architectures. For example, these architectures include, but are not limited to, the Industry Standard Architecture (ISA) bus, the Micro Channel Architecture (MAC) bus, the Enhanced ISA bus, the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect (PCI) bus.

[0084] Computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by computer device 12, including volatile and non-volatile media, removable and non-removable media.

[0085] System memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. Computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, storage system 34 may be used to read and write non-removable, non-volatile magnetic media (…). Figure 7 Not shown; usually referred to as a "hard drive"). Although Figure 7 As not shown, disk drives for reading and writing to removable non-volatile disks (e.g., "floppy disks") and optical disc drives for reading and writing to removable non-volatile optical discs (e.g., CD-ROMs, DVD-ROMs, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 via one or more data media interfaces. System memory 28 may include at least one program product having a set (e.g., at least one) of program modules configured to perform the functions of the embodiments of the present invention.

[0086] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in system memory 28. Such program modules 42 include, but are not limited to, an operating system, one or more application programs, other program modules, and program data. Each or some combination of these examples may include an implementation of a network environment. Program modules 42 typically perform the functions and / or methods described in the embodiments of the present invention.

[0087] Computer device 12 can also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), and with one or more devices that enable a user to interact with the computer device 12, and / or with any device that enables the computer device 12 to communicate with one or more other computing devices (e.g., network card, modem, etc.). This communication can be performed via input / output (I / O) interface 22. Furthermore, computer device 12 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and / or public networks, such as the Internet) via network adapter 20. As shown, network adapter 20 communicates with other modules of computer device 12 via bus 18. It should be understood that, although... Figure 7 As not shown, it can be used in conjunction with computer device 12 with other hardware and / or software modules, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0088] Processing unit 16 executes various functional applications and data processing by running programs stored in system memory 28, such as implementing the report processing method provided in this embodiment, which includes: In response to a report display trigger operation, the first report is displayed. The first report is the business report associated with the report display trigger operation. The process of obtaining the first report includes: Obtain the first pre-rendered page template of the first report, the first set of report data in the first storage space, and the second set of report data in the second storage space; the first storage space is the temporary cache space of the business report system, and the second storage space is the storage space of the database system corresponding to the business report system; The first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report.

[0089] This embodiment provides a computer-readable storage medium storing a computer program thereon. When executed by a processor, the program implements the report processing method provided in any embodiment of the present invention, the method comprising: In response to a report display trigger operation, the first report is displayed. The first report is the business report associated with the report display trigger operation. The process of obtaining the first report includes: Obtain the first pre-rendered page template of the first report, the first set of report data in the first storage space, and the second set of report data in the second storage space; the first storage space is the temporary cache space of the business report system, and the second storage space is the storage space of the database system corresponding to the business report system; The first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report.

[0090] The computer storage medium of this invention can be any combination of one or more computer-readable media. A computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. A computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage media (a non-exhaustive list) include: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this document, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

[0091] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, capable of sending, propagating, or transmitting programs for use by or in connection with an instruction execution system, apparatus, or device.

[0092] Program code contained on a computer-readable medium may be transmitted using any suitable medium, including but not limited to: wireless, wire, optical fiber, RF, etc., or any suitable combination thereof.

[0093] Computer program code for performing the operations of this invention can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages ​​such as C or similar languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0094] Those skilled in the art will understand that the modules or steps of the present invention described above can be implemented using general-purpose computing devices. They can be centralized on a single computing device or distributed across a network of multiple computing devices. Optionally, they can be implemented using computer-executable program code, thereby allowing them to be stored in a storage device for execution by a computing device, or they can be fabricated as separate integrated circuit modules, or multiple modules or steps can be fabricated as a single integrated circuit module. Thus, the present invention is not limited to any particular combination of hardware and software.

[0095] This invention also provides a computer program product, including a computer program that, when executed by a processor, implements the report processing method provided in any embodiment of this application.

[0096] In implementing the computer program product, computer program code for performing the operations of this invention can be written in one or more programming languages ​​or a combination thereof. Programming languages ​​include object-oriented programming languages ​​such as Java, Smalltalk, and C++, as well as conventional procedural programming languages ​​such as C or similar languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0097] Note that the above description is merely a preferred embodiment of the present invention and the technical principles employed. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and various obvious changes, readjustments, and substitutions can be made without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in detail through the above embodiments, the present invention is not limited to the above embodiments, and may include many other equivalent embodiments without departing from the concept of the present invention, the scope of which is determined by the scope of the appended claims.

Claims

1. A report processing method, applied to a business report system, characterized in that, include: In response to a report display trigger operation, a first report is displayed, which is a business report associated with the report display trigger operation. The process of obtaining the first report includes: Obtain the first pre-rendered page template of the first report, the first set of report data in the first storage space, and the second set of report data in the second storage space; the first storage space is the temporary cache space of the business report system, and the second storage space is the storage space of the database system corresponding to the business report system; The first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report.

2. The method according to claim 1, characterized in that, Before obtaining the report display trigger operation, the method further includes: In response to the startup of the business reporting system, a first set of business reports is obtained; the first set of business reports is a set of pre-configured business reports in the business reporting system. For each business report in the first set of business reports, the report page is pre-rendered based on the report structure configuration information of each business report to obtain the pre-rendered page template corresponding to each business report.

3. The method according to claim 2, characterized in that, Also includes: Load the first set of report data from the second storage space into the first storage space.

4. The method according to claim 1, characterized in that, The processing procedures for the first set of report data and the second set of report data include: In the database system, data items are grouped according to the business data attributes of the business data items in the first report to obtain at least two data item grouping results; For each grouping result of the data item, the report data is processed according to the data item processing rules pre-configured in the first report to obtain the first group of report data and at least one copy of the second group of report data.

5. The method according to claim 4, characterized in that, The step of processing the report data according to the pre-configured data item processing rules in the first report includes: Based on the pre-configured data item processing rules, a data processing script is generated using a preset workshop model; Based on the data processing script, the data corresponding to each data item in the grouping result of each data item is processed.

6. The method according to claim 4, characterized in that, The business data attributes include at least one of the following: data update frequency, the business scenario to which the data belongs, and the business data source.

7. The method according to claim 1, characterized in that, The first report is an evaluation table of the item collection display scheme in the e-commerce business system; the first set of report data in the first report includes at least one of the following: item collection name, item collection attribute information, and item collection object information; the second set of report data in the first report includes the image and text component configuration information in the item collection display, the item collection search term setting information, and the item acquisition cost setting information in the item collection.

8. A report processing device, characterized in that, include: The report visualization module is used to display a first report in response to a report display trigger operation. The first report is a business report associated with the report display trigger operation. The report visualization module includes a report combination sub-module, which is used for specific purposes: Obtain the first pre-rendered page template of the first report, the first set of report data in the first storage space, and the second set of report data in the second storage space; the first storage space is the temporary cache space of the business report system, and the second storage space is the storage space of the database system corresponding to the business report system; The first pre-rendered page template, the first set of report data, and the second set of report data are combined to obtain the first report.

9. An electronic device, characterized in that, The electronic device includes: One or more processors; Storage device for storing one or more programs. When the one or more programs are executed by the one or more processors, the one or more processors implement the report processing method as described in any one of claims 1-7.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the program is executed by the processor, it implements the report processing method as described in any one of claims 1-7.

11. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by the processor, it implements the report processing method as described in any one of claims 1-7.

Images