Business data report updating method and device, equipment and storage medium

By performing template configuration rendering, snapshot playback and index update on business data sources, and generating target snapshots, the problem of low efficiency in business data report updates in the existing technology is solved, and more efficient data updates are achieved.

CN119088807AInactive Publication Date: 2024-12-06HANGZHOU NEWGRAND TECHNOLOGY CO LTD
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
CN202411579082.X
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-11-07
Publication Date
2024-12-06
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

The update efficiency of existing business data reports is inefficient, especially when the data volume is large, data needs to be manually filled, resulting in long processing time and low efficiency.

Method used

By rendering the business data source based on template configuration information, a primary report snapshot is generated, and the target index is determined through snapshot playback and index update, and the target snapshot is finally rendered to generate the final business data report.

Benefits of technology

It improves the efficiency of updating business data reports, simplifies the user's manual adjustment process, reduces processing time, and improves the speed of data updates.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119088807A_ABST
    Figure CN119088807A_ABST
Patent Text Reader

Abstract

The invention relates to the technical field of data, in particular to a business data report updating method, device and equipment and a storage medium, and the method comprises the following steps: rendering a business data source based on template configuration information to obtain a primary report, and obtaining a first report snapshot based on the primary report and the template configuration information; performing snapshot playback on the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and processing the primary report to obtain a second report snapshot; determining a target index based on the cell modification snapshot, the row and column change snapshot and the second report snapshot, and updating the second report snapshot based on the target index to obtain a target snapshot; and rendering the target snapshot to obtain a business data report. The updating efficiency of the business data report is improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of data technology, and in particular to a method, device, equipment and storage medium for updating a business data report. Background Art

[0002] In order to intuitively display the business data in the business data source, the business data needs to be displayed in the form of a table, that is, the business data is rendered as a business data report; however, after the business data report is generated, the user still needs to manually make certain adjustments to the business data report, which will cause some business data automatically calculated by the business data source during the rendering of the business data report to change, so the business data report needs to be updated.

[0003] Currently, one way to update a business data report is to render the business data into the business data report by automatic filling. For business data that needs to be manually filled in the business data report, the staff manually fills the business data into the business data report according to the business data source.

[0004] However, if the amount of business data that needs to be manually filled in the business data report is too large, the staff will need to spend a long time processing, resulting in low updating efficiency of the business data report. Summary of the invention

[0005] In order to improve the updating efficiency of business data reports, the present application provides a business data report updating method, device, equipment and storage medium.

[0006] In a first aspect, the present application provides a method for updating a business data report, comprising:

[0007] Rendering the business data source based on the template configuration information to obtain a primary report, and obtaining a first report snapshot based on the primary report and the template configuration information;

[0008] Performing snapshot playback on the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and processing the primary report to obtain a second report snapshot;

[0009] Determine a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot, and update the second report snapshot based on the target index to obtain a target snapshot;

[0010] The target snapshot is rendered to obtain a business data report.

[0011] In a second aspect, the present application provides a business data report updating device, comprising:

[0012] A report processing module, configured to render the business data source based on the template configuration information to obtain a primary report, and to obtain a first report snapshot based on the primary report and the template configuration information;

[0013] A snapshot playback module, used for performing snapshot playback on the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and processing the primary report to obtain a second report snapshot;

[0014] An index updating module, configured to determine a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot, and to update the second report snapshot based on the target index to obtain a target snapshot;

[0015] The data rendering module is used to render the target snapshot to obtain a business data report.

[0016] In a third aspect, the present application provides a computer device, the computer device comprising a memory and a processor, the memory storing a computer program, and the processor implementing the steps in the above method when executing the computer program.

[0017] In a fourth aspect, the present application provides a computer-readable storage medium having a computer program stored thereon, which implements the steps in the above method when executed by a processor.

[0018] In a fifth aspect, the present application further provides a computer program product, wherein the computer program product comprises a computer program, and when the computer program is executed by a processor, the steps in any of the above method embodiments are implemented.

[0019] The above-mentioned business data report updating method, device, equipment and storage medium obtain a primary report by rendering the business data source based on the template configuration information, obtain a first report snapshot based on the primary report and the template configuration information; perform snapshot playback on the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and process the primary report to obtain a second report snapshot; determine the target index based on the cell modification snapshot, the row and column change snapshot and the second report snapshot, and update the second report snapshot based on the target index to obtain a target snapshot; render the target snapshot to obtain a business data report. Through the above implementation, after the user manually adjusts the business data report during its generation, the user's adjustment content can be determined to obtain a target snapshot, and the business data report can be updated through the target snapshot, which facilitates improving the updating efficiency of the business data report.

[0020] It should be understood that the content described in this section is not intended to identify the key or important features of the embodiments of the present application, nor is it intended to limit the scope of the present application. Other features of the present application will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments are briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present invention and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without creative work.

[0022] Figure 1 A flow chart of a method for updating a business data report provided in an embodiment of the present application;

[0023] Figure 2 A schematic diagram of the structure of a business data report updating device provided in an embodiment of the present application;

[0024] Figure 3 A schematic diagram of the structure of a computer device provided in an embodiment of the present application;

[0025] Figure 4 This is a diagram of the internal structure of a computer-readable storage medium provided in an embodiment of the present application. DETAILED DESCRIPTION

[0026] In order to make the purpose, technical solution and advantages of the present disclosure more clear, the present disclosure 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 disclosure and are not used to limit the present disclosure.

[0027] It should be noted that the terms "first", "second", etc. in the specification and claims of this article and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of this article described here can be implemented in an order other than those illustrated or described here. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, device, product or equipment that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or equipment.

[0028] In this article, the term "and / or" is only a description of the association relationship between related objects, indicating that there can be three relationships. For example, A and / or B can mean: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " in this article generally indicates that the related objects before and after are in an "or" relationship.

[0029] Embodiment 1

[0030] Figure 1 A flow chart of a method for updating a business data report provided in Example 1 of the present application, refer to Figure 1 The method may be performed by a device for performing the method, and the device may be implemented by software and / or hardware. The method includes:

[0031] S110: Render the business data source based on the template configuration information to obtain a primary report, and obtain a first report snapshot based on the primary report and the template configuration information.

[0032] Among them, the template configuration information includes cell configuration information corresponding to each cell on the report template. The report template is an empty report without data written in the business data source. The cell configuration information includes at least cell functions and cell metadata. The cell function is used to render the corresponding data in the business data source to the cell corresponding to the cell function in the report template. In this embodiment, the business data source is specifically a financial data source. In other embodiments, it can also be a school business data source, which is not specifically limited. The data in the business data source can be rendered into the report template through the template configuration information to obtain a primary report, wherein rendering is to write the data in the business data source into the cell corresponding to the report template through the cell function. The primary report is the report obtained after the report template is rendered. After the rendering is completed, each cell in the primary report has corresponding cell data and cell metadata. The first report snapshot is the cell data and cell metadata corresponding to each cell in the primary report at the current moment.

[0033] Specifically, the corresponding business data in the business data source is rendered to the corresponding cells in the report template through the cell function in the template configuration data, thereby obtaining a primary report; the business data written in each cell in the primary report is also the cell data, and the template configuration information includes the cell metadata corresponding to each cell, and the cell data and cell metadata corresponding to each cell at the current moment are obtained, thereby obtaining the first report snapshot.

[0034] S120: Play back the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and process the primary report to obtain a second report snapshot.

[0035] Among them, after the primary report is generated, the user may continue to operate the primary report, including cell modification and / or report row and column addition and deletion; snapshot playback is to replay the user's operation on the primary report and synchronously change the first report snapshot; the cell modification snapshot is the cell data and cell metadata related to the cell modification in the first report snapshot after the change, and the row and column change snapshot is the cell data and cell metadata related to the report row and column addition and deletion in the first report snapshot after the change. By clearing the primary report and then re-rendering the business data in the business data source into the report template through the template configuration data, a new primary report can be obtained. The second report snapshot is the data snapshot corresponding to the new primary report.

[0036] Specifically, in the process of snapshot playback of the first report snapshot, if it is determined that there are cells related to cell modification in the first report snapshot, the cell data and cell metadata corresponding to the cell are further determined to obtain a cell modification snapshot; if it is determined that there are cells related to addition and deletion of report rows and columns in the first report snapshot, the cell data and cell metadata corresponding to the cell are further determined to obtain a row and column change snapshot; then, the primary report is cleared, and the business data in the business data source is re-rendered into the report template through the template configuration data to obtain a new primary report, and the data snapshot corresponding to the new primary report is obtained to obtain a second report snapshot.

[0037] S130: Determine a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot, and update the second report snapshot based on the target index to obtain a target snapshot.

[0038] Among them, based on the cell modification snapshot, the row and column change snapshot and the second report snapshot, the index of the cell in the primary report where the cell modification and / or the report row and column addition and deletion occurs can be determined, that is, the target index; through the target index, the cell in the primary report where the cell modification and / or the report row and column addition and deletion occurs can be updated to the second report snapshot, and the target snapshot is the data snapshot obtained after the second report snapshot is updated.

[0039] Specifically, based on the cell modification snapshot, the row and column change snapshot and the second report snapshot, it can be determined that cell modifications and / or report row and column additions and deletions occurred in the primary report, and the cell index is obtained to obtain the target index; the cell corresponding to the target index in the primary report is updated to the second report snapshot to obtain the target snapshot.

[0040] S140: Render the target snapshot to obtain a business data report.

[0041] Rendering the target snapshot means writing the data of each cell in the target snapshot into the report template, and the business data report means the report obtained after the report template completes writing the cell data.

[0042] Specifically, the target snapshot is rendered into a report template to obtain a business data report.

[0043] It should be noted that this embodiment obtains a primary report by rendering the business data source based on the template configuration information, obtains a first report snapshot based on the primary report and the template configuration information; performs snapshot playback on the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, processes the primary report to obtain a second report snapshot; determines a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot, updates the second report snapshot based on the target index to obtain a target snapshot; and renders the target snapshot to obtain a business data report. Through the above implementation, after the user manually adjusts the business data report during its generation, the user's adjustment content can be determined to obtain a target snapshot, and the business data report can be updated through the target snapshot, which facilitates improving the updating efficiency of the business data report.

[0044] Embodiment 2

[0045] A business data report updating method provided in the second embodiment of the present application optimizes the "snapshot playback of the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot" in the first embodiment; it should be noted that for the parts not described in detail in this embodiment, reference can be made to the descriptions of other embodiments, and the method includes:

[0046] S210: Render the business data source based on the template configuration information to obtain a primary report, and obtain a first report snapshot based on the primary report and the template configuration information.

[0047] S221. Obtain a target operation log of the user on the primary report.

[0048] Among them, the user can operate the primary report as needed, wherein the operations include cell modification and / or addition and deletion of report rows and columns; in order to facilitate recording of user operations, a log container is preset, and a working buffer is provided in the log container. The working buffer is used to temporarily store logs related to the operation, and the logs related to the operation are recorded as target operation logs, thereby facilitating the prevention of a large number of target operation logs from accumulating in the memory of the browser used to generate business data reports, which helps prevent the browser from getting stuck; a waiting buffer is also provided in the log container. In response to the working buffer being full of target operation logs, the waiting buffer is set as a new working buffer, thereby continuing to store the target operation logs.

[0049] Specifically, in response to the target operation log in the working buffer being full, the target operation log in the working buffer is obtained.

[0050] S222: Play back the first report snapshot based on the target operation log, determine cells that have changed during the snapshot playback, and obtain changed cells.

[0051] Among them, the target operation log is used to record the user's operations on the primary report; during the snapshot playback process, the cells with changes in the primary report can be determined, and the changes are cell modifications and / or additions and deletions of report rows and columns. The cells with changes are the cells corresponding to the target operation log, and the changed cells are the cells with changes.

[0052] Specifically, the first report snapshot is played back based on the target operation log obtained from the work buffer, and during the snapshot playback, changed cells are determined to obtain changed cells.

[0053] S223. Obtain a cell modification snapshot and a row and column change snapshot based on the changed cell.

[0054] Among them, the cell modification snapshot can be created based on the changed cell where the cell modification occurs, and the row and column change snapshot can be created based on the changed cell where the report row and column are added or deleted.

[0055] Specifically, a cell modification snapshot is created based on the cell modification changes, and a row and column change snapshot is created based on the report row and column addition and deletion changes.

[0056] S224: Process the primary report to obtain a second report snapshot.

[0057] S230: Determine a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot, and update the second report snapshot based on the target index to obtain a target snapshot.

[0058] S240: Render the target snapshot to obtain a business data report.

[0059] Embodiment 3

[0060] A business data report updating method provided in Embodiment 3 of the present application optimizes the "obtaining a cell modification snapshot and a row and column change snapshot based on the changed cell" in Embodiment 2; it should be noted that for the parts not described in detail in this embodiment, reference may be made to the descriptions of other embodiments, and the method includes:

[0061] S310: Render the business data source based on the template configuration information to obtain a primary report, and obtain a first report snapshot based on the primary report and the template configuration information.

[0062] S321. Obtain a target operation log of the user on the primary report.

[0063] S322: Play back the first report snapshot based on the target operation log, determine cells that have changed during the snapshot playback, and obtain changed cells.

[0064] S323A: In response to a cell modification of the changed cell during the snapshot playback, a cell modification snapshot is obtained based on the index, version number, and value of the changed cell.

[0065] Among them, cell modification means that the value of the cell data corresponding to the cell changes, the index is the position of the changed cell in the primary table, the version number is used to represent the number of times the changed cell changes, and the value is the value of the cell data corresponding to the cell; the cell modification snapshot is a data snapshot of the index, version number and value of the changed cell that has undergone cell modification during the playback of the first report snapshot.

[0066] Specifically, determine whether there is any transformed cell that has undergone cell modification during the snapshot playback of the first report snapshot. If so, obtain the index, version number and value of the changed cell; obtain the index, version number and value of all transformed cells that have undergone cell modification in the above manner to obtain a cell modification snapshot.

[0067] S323B: in response to the report row and column addition and deletion occurring in the changed cell during the snapshot playback, a row and column change snapshot is obtained based on the row and column index and value corresponding to the changed cell.

[0068] Among them, the addition and deletion of report rows and columns means that the table rows and / or table columns where the changed cells in the initial report are located are added and / or deleted; the row and column indexes are the row indexes of the table rows and / or column indexes of the table columns where the changed cells are located; the row and column change snapshot is a data snapshot of the row and column indices and values ​​corresponding to the changed cells where the report rows and columns are added or deleted during the playback of the first report snapshot.

[0069] Specifically, it is determined whether there are any cells with changed report rows and columns added or deleted during the snapshot playback of the first report snapshot. If so, the row and column index and value of the changed cell are obtained to obtain a row and column change snapshot.

[0070] S324: Process the primary report to obtain a second report snapshot.

[0071] S330: Determine a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot, and update the second report snapshot based on the target index to obtain a target snapshot.

[0072] S340: Render the target snapshot to obtain a business data report.

[0073] Embodiment 4

[0074] A business data report updating method provided in a fourth embodiment of the present application optimizes the "determining a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot" in the first embodiment; it should be noted that for the parts not described in detail in this embodiment, reference may be made to the descriptions of other embodiments, and the method includes:

[0075] S410: Render the business data source based on the template configuration information to obtain a primary report, and obtain a first report snapshot based on the primary report and the template configuration information.

[0076] S420: Play back the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and process the primary report to obtain a second report snapshot.

[0077] S431. In response to the different snapshot sizes of the row and column change snapshot and the second report snapshot, obtain a record index set based on a preset record container recording the index of cells in the row and column change snapshot that are different from the cell vector of the second report snapshot.

[0078] Among them, the snapshot size includes the number of table rows and columns; the row and column change snapshot and the second report snapshot have their corresponding snapshot sizes. If the snapshot sizes of the row and column change snapshot and the second report snapshot are different, it means that the user has modified the initial report. The record container is used to record cell indexes. Each cell can calculate the corresponding vector based on its cell data, that is, the cell vector; the record index set is a collection of indexes of cells in the row and column change snapshot recorded in the record container that are different from the second report snapshot cell vectors.

[0079] Specifically, determine whether the snapshot sizes of the row and column change snapshot and the second report snapshot are the same. If not, calculate the cell vectors corresponding to each cell in the row and column change snapshot and the second report snapshot, and then determine the cells whose cell vectors are different from those of the cell positions corresponding to the row and column change snapshot and the second report snapshot, and record the index of the cell in the row and column change snapshot in a preset record container, thereby obtaining a record index set.

[0080] S432: Determine a target index based on the record index set, the row and column change snapshot, and the second report snapshot.

[0081] The target index can be determined according to the record index set, the row and column change snapshot and the second report snapshot.

[0082] S433: Update the second report snapshot based on the target index to obtain a target snapshot.

[0083] S440: Render the target snapshot to obtain a business data report.

[0084] Embodiment 5

[0085] A business data report updating method provided in Embodiment 5 of the present application optimizes the "determining a target index based on the record index set, the row and column change snapshot, and the second report snapshot" in Embodiment 1; it should be noted that for the parts not described in detail in this embodiment, reference may be made to the descriptions of other embodiments, and the method includes:

[0086] S510: Render the business data source based on the template configuration information to obtain a primary report, and obtain a first report snapshot based on the primary report and the template configuration information.

[0087] S520: Play back the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and process the primary report to obtain a second report snapshot.

[0088] S531 . In response to the different snapshot sizes of the row and column change snapshot and the second report snapshot, obtain a record index set based on a preset record container recording indices of cells in the row and column change snapshot that are different from the cell vectors of the second report snapshot.

[0089] S532A: Determine the difference in the number of cells between the row and column change snapshot and the second report snapshot.

[0090] The cell quantity difference is the difference between the cell quantity of the row and column change snapshot and the cell quantity of the second report snapshot.

[0091] Specifically, the difference between the number of cells in the row and column change snapshot and the number of cells in the second report snapshot is calculated to obtain the cell number difference.

[0092] S532B: In response to the inconsistency between the number of indexes corresponding to the record index set and the difference in the number of cells, determine a target cell group corresponding to the cells corresponding to the indexes in the record index set in the row and column change snapshot and the second report snapshot.

[0093] Among them, in this embodiment, the target cell group is the upper cell and the lower cell of the cell corresponding to the position of the cell corresponding to the index in the record index set in the row and column change snapshot, and the upper cell and the lower cell of the cell corresponding to the position of the cell corresponding to the index in the record index set in the second report snapshot; and the upper cell and the lower cell in the row and column change snapshot are respectively recorded as the first upper cell and the first lower cell, and the upper cell and the lower cell in the second report snapshot are respectively recorded as the second upper cell and the second lower cell; in other embodiments, the target cell group is the left cell and the right cell of the cell corresponding to the position of the cell corresponding to the index in the record index set in the row and column change snapshot, and the left cell and the right cell of the cell corresponding to the position of the cell corresponding to the index in the record index set in the second report snapshot, without specific limitation.

[0094] Specifically, determine whether the number of indexes corresponding to the record index set is consistent with the difference in the number of cells. If not, determine the cells above and below the cells corresponding to the positions of the cells corresponding to the indexes in the record index set in the row and column change snapshot to obtain the first upper cell and the first lower cell. Also determine the cells above and below the cells corresponding to the positions of the cells corresponding to the indexes in the record index set in the second report snapshot to obtain the second upper cell and the second lower cell. The target cell group includes the first upper cell, the first lower cell, the second upper cell and the second lower cell.

[0095] S532C. Determine a target index based on the target cell group.

[0096] Among them, if the cell data of the first upper cell and the second upper cell in the target cell group are consistent, and the cell data of the first lower cell and the second lower cell in the target cell group are consistent, it means that the corresponding index in the record index set is the index required for subsequent updating of the second report snapshot, that is, the target index; otherwise, it means that the corresponding index in the record index set is not the index required for subsequent updating of the second report snapshot.

[0097] Specifically, determine whether the cell data of the first upper cell and the second upper cell in the target cell group are consistent, and the cell data of the first lower cell and the second lower cell are consistent; if not, determine the corresponding index in the record index set as the target index, otherwise, remove the corresponding index in the record index set from the record container.

[0098] S533: Update the second report snapshot based on the target index to obtain a target snapshot.

[0099] S540: Render the target snapshot to obtain a business data report.

[0100] Embodiment 6

[0101] A business data report updating method provided in Embodiment 6 of the present application optimizes the "updating the second report snapshot based on the target index to obtain a target snapshot" in Embodiment 1; it should be noted that for the parts not described in detail in this embodiment, reference may be made to the descriptions of other embodiments, and the method includes:

[0102] S110: Render the business data source based on the template configuration information to obtain a primary report, and obtain a first report snapshot based on the primary report and the template configuration information.

[0103] S120: Play back the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and process the primary report to obtain a second report snapshot.

[0104] S631. Determine a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot.

[0105] S632: Modify the cell modification snapshot based on the target index to obtain a target modification snapshot.

[0106] Among them, the first target cell of the target index in the cell modification snapshot can be determined by the target index, and it can be further determined whether there is a newly added table row or table column before the table row or table column where the first target cell is located. If so, the index of each cell in the newly added table row or table column in the initial report is determined, and the cell data corresponding to the index in the initial report is filled into the cells in the newly added table row or table column. The target modification snapshot is now a data snapshot obtained after the corresponding cell data is filled in the newly added table row or table column; if not, the target cell group corresponding to the target index in the row and column change snapshot and the second report snapshot is determined, and then it is further determined whether the cell data of the first upper cell and the second upper cell in the cell group are consistent, and the cell data of the first lower cell and the second lower cell are consistent. If not, the change law of the cell data corresponding to the target index in the cell modification snapshot can be determined by a preset review algorithm, and the cell prediction data corresponding to the target index is determined according to the change law, and the cell prediction data is filled into the cell corresponding to the target index in the cell modification snapshot, thereby obtaining the target modification snapshot.

[0107] Specifically, determine the first target cell of the target index in the cell modification snapshot, and determine whether there is a newly added table row or table column before the table row or table column where the first target cell is located. If so, determine the index of each cell in the newly added table row or table column in the initial report, and fill the cell data corresponding to the index in the initial report into the cells in the newly added table row or table column, thereby obtaining the target modification snapshot; if there is no newly added table row or table column before the table row or table column where the first target cell is located, determine the change pattern of the cell data corresponding to the target index in the cell modification snapshot through a preset review algorithm, determine the cell prediction data corresponding to the target index according to the change pattern, and fill the cell prediction data into the cell corresponding to the target index in the cell modification snapshot, thereby obtaining the target modification snapshot.

[0108] S633: Modify the row and column change snapshot based on the target index to obtain a target change snapshot.

[0109] Among them, the record container may have a target index. In this step, the target index is specifically a row and column index. If it is determined that the record container has a row and column index, the cells corresponding to the row and column index in the initial report are inserted into the row and column change snapshot; further, taking one of the inserted cells as an example, the target cell group corresponding to the cell in the row and column change snapshot and the second report snapshot can be determined, and it can be determined whether the cell data of the first upper cell and the second upper cell in the cell group are consistent, and the cell data of the first lower cell and the second lower cell are consistent. If not, the change law of the cell data of the cell can be determined according to a preset review algorithm, and the cell prediction data corresponding to the target index can be determined according to the change law, and then the cell prediction data is filled in the cell corresponding to the target index in the cell modification snapshot, thereby obtaining the target change snapshot.

[0110] Specifically, determine whether there is a row and column index in the record container. If so, insert each cell corresponding to the row and column index in the initial report into the row and column change snapshot; then determine the target cell group corresponding to the cell in the row and column change snapshot and the second report snapshot, and determine whether the cell data of the first upper cell and the second upper cell in the cell group are consistent, and the cell data of the first lower cell and the second lower cell are consistent. If not, determine the change rule of the cell data of the cell according to a preset review algorithm, and determine the cell prediction data corresponding to the target index according to the change rule, and then fill the cell prediction data into the cell corresponding to the target index in the cell modification snapshot, thereby obtaining the target change snapshot.

[0111] S634: Obtain a target snapshot based on the target modification snapshot and the target change snapshot.

[0112] The target snapshot can be obtained by merging the target modification snapshot and the target change snapshot.

[0113] Specifically, the target modification snapshot and the target change snapshot are merged to obtain the target snapshot.

[0114] S640: Render the target snapshot to obtain a business data report.

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

[0116] Embodiment 7

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

[0118] In this embodiment, Figure 2 As shown, a business data report updating device is provided, comprising:

[0119] A report processing module, configured to render the business data source based on the template configuration information to obtain a primary report, and to obtain a first report snapshot based on the primary report and the template configuration information;

[0120] A snapshot playback module, used for performing snapshot playback on the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and processing the primary report to obtain a second report snapshot;

[0121] An index updating module, configured to determine a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot, and to update the second report snapshot based on the target index to obtain a target snapshot;

[0122] The data rendering module is used to render the target snapshot to obtain a business data report.

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

[0124] It should be noted that this embodiment obtains a primary report by rendering the business data source based on the template configuration information, obtains a first report snapshot based on the primary report and the template configuration information; performs snapshot playback on the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, processes the primary report to obtain a second report snapshot; determines a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot, updates the second report snapshot based on the target index to obtain a target snapshot; and renders the target snapshot to obtain a business data report. Through the above implementation, after the user manually adjusts the business data report during its generation, the user's adjustment content can be determined to obtain a target snapshot, and the business data report can be updated through the target snapshot, which facilitates improving the updating efficiency of the business data report.

[0125] Embodiment 8

[0126] In this embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Figure 3 As shown. 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 database of the computer device is used to store data. 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 business data report updating method is implemented.

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

[0128] Embodiment 9

[0129] In this embodiment, a computer readable storage medium is provided. Figure 4 As shown, a computer program is stored thereon, and when the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0130] Embodiment 10

[0131] In this embodiment, a computer program product is provided, including a computer program. When the computer program is executed by a processor, the steps in the above method embodiments are implemented.

[0132] 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 disclosure are all information and data authorized by the user or fully authorized by all parties.

[0133] A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment method 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 by the present disclosure 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 by the present disclosure 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 by the present disclosure may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic unit, a data processing logic unit based on quantum computing, etc., but are not limited to this.

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

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

Claims

1. A method for updating a business data report, characterized in that: include: Rendering the business data source based on the template configuration information to obtain a primary report, and obtaining a first report snapshot based on the primary report and the template configuration information; Performing snapshot playback on the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and processing the primary report to obtain a second report snapshot; Determine a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot, and update the second report snapshot based on the target index to obtain a target snapshot; The target snapshot is rendered to obtain a business data report.

2. The method according to claim 1, characterized in that The step of replaying the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot includes: Obtaining a target operation log of the user on the primary report; Performing snapshot playback on the first report snapshot based on the target operation log, determining cells that have changed during the snapshot playback to obtain changed cells; A cell modification snapshot and a row and column change snapshot are obtained based on the changed cell.

3. The method according to claim 2, characterized in that The obtaining of a cell modification snapshot and a row and column change snapshot based on the changed cell includes: In response to a cell modification of the changed cell during the snapshot playback, obtaining a cell modification snapshot based on the index, version number and value of the changed cell; In response to the report row and column addition and deletion occurring in the changed cell during the snapshot playback, a row and column change snapshot is obtained based on the row and column index and value corresponding to the changed cell.

4. The method according to claim 1, characterized in that: The determining the target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot includes: In response to the row and column change snapshot and the second report snapshot having different snapshot sizes, recording the index of cells in the row and column change snapshot that are different from the cell vector of the second report snapshot based on a preset record container to obtain a record index set; A target index is determined based on the record index set, the row and column change snapshot, and the second report snapshot.

5. The method according to claim 4, characterized in that The determining the target index based on the record index set, the row and column change snapshot, and the second report snapshot includes: Determine the difference in the number of cells between the row and column change snapshot and the second report snapshot; In response to the inconsistency between the number of indexes corresponding to the record index set and the difference in the number of cells, determining a target cell group corresponding to the cells corresponding to the indexes in the record index set in the row and column change snapshot and the second report snapshot; A target index is determined based on the target cell group.

6. The method according to claim 1, characterized in that The updating the second report snapshot based on the target index to obtain a target snapshot includes: Modify the cell modification snapshot based on the target index to obtain a target modification snapshot; Modify the row and column change snapshot based on the target index to obtain a target change snapshot; A target snapshot is obtained based on the target modification snapshot and the target change snapshot.

7. A business data report updating device, characterized in that: The device comprises: A report processing module, configured to render the business data source based on the template configuration information to obtain a primary report, and to obtain a first report snapshot based on the primary report and the template configuration information; A snapshot playback module, used for performing snapshot playback on the first report snapshot to obtain a cell modification snapshot and a row and column change snapshot, and processing the primary report to obtain a second report snapshot; An index updating module, configured to determine a target index based on the cell modification snapshot, the row and column change snapshot, and the second report snapshot, and to update the second report snapshot based on the target index to obtain a target snapshot; The data rendering module is used to render the target snapshot to obtain a business data report.

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

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

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

Citation Information

Patent Citations

  • Methods and devices of realizing data updating and data snapshot at OLAP (Online Analytical Processing) database

    CN108073595A

  • Solid state disk data table management method and device, storage medium and electronic equipment

    CN110688070A

  • Table data synchronization method and device, computer equipment and storage medium

    CN114201462A

  • Service data processing method and related equipment

    CN117149702A

  • Database replication method and system

    US20070255763A1