Structured report management method and device, equipment and storage medium

Abstract

The invention discloses a structured report management method and device, equipment and a storage medium. Comprising the steps of obtaining an original report file, and processing the original report file to generate structured data; establishing an index according to the structured data, and generating storage data according to the index and the structured data; and obtaining a user query request, determining target data from the storage data based on the query request, and generating a reconstruction report according to the target data. By obtaining the original report file and processing the original report file to generate the structured data, normalization and standardization of the report file are achieved, and the quality and availability of the data are improved. And the index is established according to the structured data, so that the data retrieval speed and efficiency are remarkably improved. In the face of a large amount of report data, accurate and valuable report information can be quickly provided for the user according to the query request of the user, so that the query time is saved, the user experience is enhanced, the efficiency and quality of report file management are improved, and the value and the utilization degree of the data are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of data storage, and in particular to a structured report management method, device, equipment and storage medium. Background Art

[0002] In today's data-driven society, enterprises and organizations generate a large amount of data during their operations. After processing and analysis, these data are presented in the form of reports, providing an important basis for decision-making. With the continuous growth of data volume and the increasing diversity of data types, traditional report storage methods have gradually exposed many problems.

[0003] In an unstructured storage environment, it is extremely difficult to find, retrieve and manage report files, which consumes a lot of time and manpower. At the same time, the report formats generated by different departments and systems vary, and there is a lack of unified standards and specifications, which leads to huge challenges in data integration and sharing, seriously affecting work efficiency and timeliness of decision-making. In addition, traditional storage methods also have hidden dangers in terms of data security and integrity, and are vulnerable to the threat of data loss, tampering and leakage. Summary of the invention

[0004] The present invention provides a structured report management method, device, equipment and storage medium, which can greatly improve data retrieval speed and reduce waiting time through structured processing and index optimization.

[0005] According to one aspect of the present invention, a structured report management method is provided, the method comprising:

[0006] Obtaining original report files, and processing the original report files to generate structured data;

[0007] Create an index based on structured data, and generate storage data based on the index and structured data;

[0008] Obtain user query requests, determine target data from stored data based on the query requests, and generate a reconstructed report based on the target data.

[0009] Optionally, the original report file is processed to generate structured data, including: identifying the file format and content structure of the original report file; extracting data from the original report file based on the file format and content structure to generate extracted data, wherein the extracted data includes cell data, format, style, and embedded charts; and structuring each extracted data to generate structured data.

[0010] Optionally, an index is established based on structured data, including: taking the structured data corresponding to the cell data as the first data, and taking the structured data corresponding to the format, style and embedded chart as the second data; determining the key fields in the first data, and establishing a first index for the key fields; and establishing a second index for the second data.

[0011] Optionally, generating storage data according to the index and the structured data includes: compressing the structured data to generate compressed data; and generating storage data according to the correspondence between the compressed data and the index.

[0012] Optionally, determining the target data from the stored data based on the query request includes: matching the index of the stored data through the query request to obtain the target index corresponding to the query request; and obtaining target compressed data corresponding to the target index from the stored data as the target data.

[0013] Optionally, generating a reconstructed report based on the target data includes: decompressing the target data to generate decompressed target data; determining target report elements corresponding to the decompressed target data, wherein the target report elements include target cell data, target format, target style, and target embedded charts; and generating a reconstructed report based on the target report elements using a reporting tool.

[0014] Optionally, the method also includes: regularly evaluating the stored data to determine evaluation results, wherein the evaluation results include query frequency and data update frequency; determining adjustment parameters based on the evaluation results, and adjusting the stored data based on the adjustment parameters, wherein the adjustment parameters include index structure parameters and data compression parameters.

[0015] According to another aspect of the present invention, there is provided a structured report management device, the device comprising:

[0016] A structured data generation module is used to obtain original report files and process the original report files to generate structured data;

[0017] A storage data generation module is used to create an index based on the structured data and generate storage data based on the index and the structured data;

[0018] The reconstruction report generation module is used to obtain a user query request, determine target data from the stored data based on the query request, and generate a reconstruction report based on the target data.

[0019] According to another aspect of the present invention, an electronic device is provided, the electronic device comprising:

[0020] at least one processor;

[0021] and a memory communicatively coupled to the at least one processor;

[0022] The memory stores a computer program that can be executed by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute a structured report management method described in any embodiment of the present invention.

[0023] According to another aspect of the present invention, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement a structured report management method according to any embodiment of the present invention when executed.

[0024] The technical solution of the embodiment of the present invention realizes the normalization and standardization of report files by acquiring the original report files and processing and generating structured data, thereby improving the quality and availability of data. By establishing indexes based on structured data, the speed and efficiency of data retrieval are significantly improved. By generating storage data based on indexes and structured data, the data storage method is optimized, the storage space occupied is reduced, and the storage security and stability of data are improved. When faced with a large amount of report data, accurate and valuable report information can be quickly provided to users based on user query requests, saving query time, enhancing user experience, and helping to improve the efficiency and quality of report file management and enhance the value and utilization of data.

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

[0026] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0027] Figure 1 is a flow chart of a structured report management method provided according to the first embodiment of the present invention;

[0028] Figure 2 is a flow chart of another structured report management method provided according to the second embodiment of the present invention;

[0029] Figure 3 This is a schematic diagram of the structure of a structured report management device provided according to Embodiment 3 of the present invention;

[0030] Figure 4The present invention is a schematic diagram of the structure of an electronic device for implementing a structured report management method according to an embodiment of the present invention. DETAILED DESCRIPTION

[0031] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0032] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention 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 the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0033] Embodiment 1

[0034] Figure 1 A flowchart of a structured report management method is provided for the first embodiment of the present invention. This embodiment is applicable to the situation where report files in various formats are stored and reconstructed. The method can be executed by a structured report management device. The structured report management device can be implemented in the form of hardware and / or software. The structured report management device can be configured in a computer controller.

[0035] like Figure 1 As shown, the method includes:

[0036] S110: Obtain an original report file, and process the original report file to generate structured data.

[0037] Among them, the original report file refers to the file generated by summarizing data in the form of tables, charts, graphs, etc. Structured data refers to data with a clear format and organization, usually in the form of tables and relational databases. The fields and types of the data are clearly defined, which is convenient for storage, management and analysis.

[0038] Specifically, the controller can obtain the original report file through the data source, such as a database, a file system, a network interface, etc. The original report file can be in the format of Excel, CSV, XML, etc. The processing process is to convert the unstructured or semi-structured data in the original file into structured data with a clear structure and format. The data processing process can include steps such as data cleaning, format conversion, field extraction and classification to ensure the accuracy and consistency of the data.

[0039] It should be noted that the process of processing the original report file to generate structured data follows the principles of data cleaning and conversion. The original data may have missing values, wrong values, duplicate records and other problems. Through data cleaning, such as deleting duplicate records, filling missing values, and correcting wrong values, the quality of the data can be improved. Conversion includes unifying data in different formats into a standard format, as well as classifying and encoding the data to make it have a clear structure, such as converting text descriptions into digital codes for subsequent processing and analysis.

[0040] Optionally, the original report file is processed to generate structured data, including: identifying the file format and content structure of the original report file; extracting data from the original report file based on the file format and content structure to generate extracted data, wherein the extracted data includes cell data, format, style, and embedded charts; and structuring each extracted data to generate structured data.

[0041] Specifically, the controller needs to identify the file format and content structure of the original report file. Different file formats have different storage methods and encoding rules. For Excel files, a specific binary format is used internally to store information such as data, format, and formulas; CSV is a plain text format separated by commas. The controller will then extract data from the original report file based on the identified file format and content structure. For the extraction of cell data, it is necessary to accurately read the data value according to the cell storage method defined by the file format. The extraction of the format requires obtaining information such as fonts, colors, and alignment. The extraction of styles includes aspects such as borders and backgrounds. The extraction of embedded charts requires understanding the type of chart (such as bar charts, line charts, etc.) and the data relationship it represents. The controller will structure the extracted data, such as converting it into JSON format data.

[0042] S120: Create an index according to the structured data, and generate storage data according to the index and the structured data.

[0043] An index is a database structure that is used to speed up the retrieval and access of data. An index is similar to the table of contents of a book. By creating an index for a specific field, you can quickly locate the relevant data records.

[0044] Optionally, an index is established based on structured data, including: taking the structured data corresponding to the cell data as the first data, and taking the structured data corresponding to the format, style and embedded chart as the second data; determining the key fields in the first data, and establishing a first index for the key fields; and establishing a second index for the second data.

[0045] Specifically, the controller defines the structured data corresponding to the cell data as the first data, which usually contains the core business information, such as transaction amount, customer name, product category, etc. The structured data corresponding to the format, style and embedded chart is regarded as the second data, which is about the presentation method of data and auxiliary display elements. Key fields refer to fields that are frequently used in query, filtering and association operations. For example, if you often need to find related transaction records according to customer number, you can use customer number as the key field. Indexing can sort and organize the values ​​of key fields by B+ tree or hash table, so that the data range containing specific key field values ​​can be quickly located when querying, greatly improving query efficiency. Although the second data is not the core business information, it may also need to be quickly retrieved and accessed in certain specific scenarios. For example, when you need to quickly find data with a specific format or style, establishing a corresponding index can avoid traversing the entire second data set. The way to establish the second index may vary according to the characteristics and usage requirements of the second data. For example, if the formats and styles of the second data are relatively few and fixed, a simple linear index can be used; if the types are large and complex, a more complex index structure may be needed to improve retrieval performance. By reasonably classifying structured data and establishing corresponding indexes for different types of data, the speed of data access and processing can be effectively improved to meet various complex business needs.

[0046] Optionally, generating storage data according to the index and the structured data includes: compressing the structured data to generate compressed data; and generating storage data according to the correspondence between the compressed data and the index.

[0047] Specifically, the controller compresses the structured data to generate compressed data. Data compression can use lossless compression algorithms, such as Huffman coding or LZ77 algorithm. Huffman coding assigns different lengths of codes to different characters according to the frequency of occurrence of characters in the data, thereby reducing the storage space of the data. The LZ77 algorithm achieves compression by finding repeated patterns in the data and using pointers to replace the repeated parts. The purpose of compressing structured data is to reduce the storage space occupied and improve the transmission efficiency of data on the storage medium. By removing redundant information in the data, such as repeated data values, continuous zero value areas, etc., the volume of the data can be significantly reduced.

[0048] Furthermore, the controller generates storage data based on the correspondence between the compressed data and the index. The correspondence is established so that the corresponding compressed data can be quickly located according to the index when querying. When generating the storage data, the index and compressed data are organized and stored according to a specific format and structure. For example, the index can be stored in an independent data structure, and the compressed data can be arranged in a certain order, and a clear association can be established between the two. When a query request is received, the system can quickly find the corresponding compressed data location through the index, and then decompress and return the data required by the user.

[0049] S130: Obtain a user query request, determine target data from stored data based on the query request, and generate a reconstruction report based on the target data.

[0050] Among them, user query request refers to the data acquisition demand proposed by the user, including clear conditions, keywords, range and other information, which is used to filter out the part required by the user from the stored data. Target data refers to the data set that meets specific conditions and requirements filtered out from the overall stored data according to the user's query request. Reconstructed report refers to the report regenerated based on the acquired target data to meet the user's viewing needs, and its format and content can be customized according to user needs.

[0051] Specifically, when receiving a user's query request, the controller will parse the query request. Based on the conditions and requirements proposed by the user, the target data is accurately determined from the previously generated stored data. The query process will make full use of the established indexes to quickly locate and filter out the data sets that meet the conditions.

[0052] Optionally, determining the target data from the stored data based on the query request includes: matching the index of the stored data through the query request to obtain the target index corresponding to the query request; and obtaining target compressed data corresponding to the target index from the stored data as the target data.

[0053] Specifically, when the target data is determined from the stored data based on the query request, the index of the stored data is first matched through the query request. The matching process is to compare and match the key information in the query request with the field value in the index. For example, if the query request is to find the transaction records of a specific customer, the index may contain fields such as the customer ID. The controller compares the customer ID in the query request with the customer ID field in the index one by one. After obtaining the target index corresponding to the query request, the target compressed data corresponding to the target index can be obtained from the stored data as the target data.

[0054] Optionally, the method also includes: regularly evaluating the stored data to determine evaluation results, wherein the evaluation results include query frequency and data update frequency; determining adjustment parameters based on the evaluation results, and adjusting the stored data based on the adjustment parameters, wherein the adjustment parameters include index structure parameters and data compression parameters.

[0055] Specifically, the evaluation principle of query frequency is based on monitoring and recording user query operations. Whenever a query request occurs, the controller will record relevant information, such as the time of the query, the query conditions, and the data range involved. Through statistics and analysis over a period of time, it is possible to determine how frequently different parts of the data are queried. For example, data in a certain time period or in a specific business area may be queried significantly more often than other parts. The evaluation of data update frequency is based on tracking data write and modification operations. Whenever new data is inserted, existing data is modified or deleted, the controller will also record relevant details, including the time of the update, the content of the updated data, and the data category to which it belongs. After a period of accumulation and analysis, it is possible to understand which parts of the data are updated more frequently and which are relatively stable.

[0056] It can be known that the adjustment of index structure parameters can better meet the query requirements. If the query frequency of certain data is very high, it may be necessary to optimize the index structure, such as increasing the number of index layers, adjusting the order of index fields, or creating composite indexes to improve the speed and efficiency of queries. If the data is updated frequently, it may be necessary to select a compression algorithm that is more suitable for frequent update operations, or adjust the compression level to balance the compression ratio and the performance overhead of update operations. If some parts of data are rarely queried but occupy a large amount of space, an algorithm with a higher compression ratio can be used to save storage space. By regularly evaluating the stored data and determining and applying appropriate adjustment parameters based on the evaluation results, the storage system can always maintain good performance and efficient resource utilization to better meet business needs and user query requirements.

[0057] Specific application scenario: Assume that the controller receives an Excel file containing monthly sales data for 2023. The file contains three worksheets, named "First Quarter", "Second Quarter", and "Third Quarter". Each worksheet contains the following columns: date (in the format of YYYY-MM-DD), product type, sales quantity, sales amount, and cell format (font, background color).

[0058] During the data preprocessing stage, the controller recognizes the Excel file, automatically parses the name of each worksheet, and reads the columns and related formats in each worksheet.

[0059] During the data parsing and structuring phase, the controller will traverse each record, extract data and format settings, and convert them into JSON format.

[0060] During the index building and data storage phase, a B+ tree index is created for the "Date" and "Product Type" fields, and indexes are created for the format and chart configuration. The LZ77 algorithm is used to compress the overall data, and the data is finally compressed to 200MB and stored in the database.

[0061] During the data retrieval and report reconstruction stage, users can request to view the sales report for the first quarter of 2023 through a web interface. The system uses the established index to quickly locate and retrieve the corresponding data and style information, and then uses reporting tools (such as Tableau) to rebuild the complete Excel report including data and style. In addition, the controller also supports joint retrieval, that is, joint query based on a large number of structured report data. The controller also supports the joint assembly of reports, that is, combining and reconstructing multiple parts based on a large number of structured report data. For example, the report displayed by the controller will contain the original data format and charts, such as the green background and Arial font of the cell, and may include a bar chart showing the total monthly sales.

[0062] During the optimization and maintenance phase, the controller can analyze the query logs and find that the data in the categories of "electronic products" and "furniture" are frequently accessed. Based on the access patterns of this data, the index is adjusted to optimize the retrieval speed of these two categories, and the compression parameters are adjusted to reduce the storage space of this part of the data.

[0063] The technical solution of the embodiment of the present invention realizes the normalization and standardization of report files by acquiring the original report files and processing and generating structured data, thereby improving the quality and availability of data. By establishing indexes based on structured data, the speed and efficiency of data retrieval are significantly improved. By generating storage data based on indexes and structured data, the data storage method is optimized, the storage space occupied is reduced, and the storage security and stability of data are improved. When faced with a large amount of report data, accurate and valuable report information can be quickly provided to users based on user query requests, saving query time, enhancing user experience, and helping to improve the efficiency and quality of report file management and enhance the value and utilization of data.

[0064] Embodiment 2

[0065] Figure 2This is a flow chart of a structured report management method provided in the second embodiment of the present invention. This embodiment adds a specific process of generating a reconstructed report based on target data on the basis of the above-mentioned first embodiment. The specific contents of steps S210-S220 are roughly the same as steps S110-S120 in the first embodiment, so they will not be described in detail in this embodiment. Figure 2 As shown, the method includes:

[0066] S210: Obtain an original report file, and process the original report file to generate structured data.

[0067] Optionally, the original report file is processed to generate structured data, including: identifying the file format and content structure of the original report file; extracting data from the original report file based on the file format and content structure to generate extracted data, wherein the extracted data includes cell data, format, style, and embedded charts; and structuring each extracted data to generate structured data.

[0068] S220: Create an index based on the structured data, and generate storage data based on the index and the structured data.

[0069] Optionally, an index is established based on structured data, including: taking the structured data corresponding to the cell data as the first data, and taking the structured data corresponding to the format, style and embedded chart as the second data; determining the key fields in the first data, and establishing a first index for the key fields; and establishing a second index for the second data.

[0070] Optionally, generating storage data according to the index and the structured data includes: compressing the structured data to generate compressed data; and generating storage data according to the correspondence between the compressed data and the index.

[0071] S230: Obtain a user query request, and determine target data from stored data based on the query request.

[0072] Optionally, determining the target data from the stored data based on the query request includes: matching the index of the stored data through the query request to obtain the target index corresponding to the query request; and obtaining target compressed data corresponding to the target index from the stored data as the target data.

[0073] S240: Decompress the target data to generate decompressed target data.

[0074] Specifically, in the process of generating a reconstruction report based on the target data, the target data is first decompressed to generate decompressed target data. The decompression process requires an inverse operation based on the data compression algorithm previously used. For example, if Huffman coding is used for compression, the coding will be converted back to the original data value according to the Huffman coding table during decompression. By executing the corresponding decompression algorithm, the compressed data is restored to its original and complete state for subsequent processing and analysis.

[0075] S250: Determine a target report element corresponding to the decompressed target data, wherein the target report element includes target cell data, target format, target style, and target embedded chart.

[0076] S260. Generate a reconstructed report according to the target report element by using a report tool.

[0077] Specifically, the controller also needs to determine the target report elements corresponding to the decompressed target data. The target report elements include target cell data, target format, target style, and target embedded chart. The reporting tool can combine and arrange the target report elements according to the predetermined template or layout rules. For example, according to the set row height, column width, and page layout, the target cell data is placed in the correct position, and the corresponding target format, target style, and target embedded chart are applied. In the process of generating reports, the output format of the report, such as PDF, Excel, etc., is also considered to meet different usage requirements. The entire generation process follows the modular and process design principles in software development to ensure the accuracy, aesthetics, and usability of the report.

[0078] Optionally, the method also includes: regularly evaluating the stored data to determine evaluation results, wherein the evaluation results include query frequency and data update frequency; determining adjustment parameters based on the evaluation results, and adjusting the stored data based on the adjustment parameters, wherein the adjustment parameters include index structure parameters and data compression parameters.

[0079] The technical solution of the embodiment of the present invention realizes the normalization and standardization of report files by acquiring the original report files and processing and generating structured data, thereby improving the quality and availability of data. By establishing indexes based on structured data, the speed and efficiency of data retrieval are significantly improved. By generating storage data based on indexes and structured data, the data storage method is optimized, the storage space occupied is reduced, and the storage security and stability of data are improved. When faced with a large amount of report data, accurate and valuable report information can be quickly provided to users based on user query requests, saving query time, enhancing user experience, and helping to improve the efficiency and quality of report file management and enhance the value and utilization of data.

[0080] Embodiment 3

[0081] Figure 3 This is a schematic diagram of a structured report management device provided by Embodiment 3 of the present invention. Figure 3 As shown, the device includes: a structured data generating module 310, which is used to obtain an original report file and process the original report file to generate structured data;

[0082] A storage data generation module 320, used to create an index based on the structured data, and generate storage data based on the index and the structured data;

[0083] The reconstruction report generation module 330 is used to obtain a user query request, determine target data from the stored data based on the query request, and generate a reconstruction report according to the target data.

[0084] Optionally, the structured data generation module 310 is specifically used to: identify the file format and content structure of the original report file; extract data from the original report file based on the file format and content structure to generate various extracted data, wherein the extracted data includes cell data, format, style and embedded charts; and perform structured processing on various extracted data to generate structured data.

[0085] Optionally, the storage data generation module 320 specifically includes: an index establishment unit, used to: use the structured data corresponding to the cell data as the first data, and use the structured data corresponding to the format, style and embedded chart as the second data; determine the key fields in the first data, and establish a first index for the key fields; establish a second index for the second data.

[0086] Optionally, the storage data generation module 320 specifically includes: a storage data generation unit, which is used to: compress the structured data to generate compressed data; and generate storage data according to the corresponding relationship between the compressed data and the index.

[0087] Optionally, the reconstruction report generation module 330 specifically includes: a target data query unit, which is used to: match the index of the stored data through the query request to obtain the target index corresponding to the query request; and obtain the target compressed data corresponding to the target index from the stored data as the target data.

[0088] Optionally, the reconstruction report generation module 330 specifically includes: a reconstruction report generation unit, which is used to: decompress the target data to generate decompressed target data; determine the target report elements corresponding to the decompressed target data, wherein the target report elements include target cell data, target format, target style and target embedded chart; and generate a reconstruction report according to the target report elements through a reporting tool.

[0089] Optionally, the device also includes: a storage data adjustment module, which is used to: regularly evaluate the stored data to determine evaluation results, wherein the evaluation results include query frequency and data update frequency; determine adjustment parameters based on the evaluation results, and adjust the stored data based on the adjustment parameters, wherein the adjustment parameters include index structure parameters and data compression parameters.

[0090] The technical solution of the embodiment of the present invention realizes the normalization and standardization of report files by acquiring the original report files and processing and generating structured data, thereby improving the quality and availability of data. By establishing indexes based on structured data, the speed and efficiency of data retrieval are significantly improved. By generating storage data based on indexes and structured data, the data storage method is optimized, the storage space occupied is reduced, and the storage security and stability of data are improved. When faced with a large amount of report data, accurate and valuable report information can be quickly provided to users based on user query requests, saving query time, enhancing user experience, and helping to improve the efficiency and quality of report file management and enhance the value and utilization of data.

[0091] A structured report management device provided in an embodiment of the present invention can execute a structured report management method provided in any embodiment of the present invention, and has functional modules and beneficial effects corresponding to the execution method.

[0092] Embodiment 4

[0093] Figure 4 A schematic diagram of the structure of an electronic device 10 that can be used to implement an embodiment of the present invention is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

[0094] like Figure 4As shown, the electronic device 10 includes at least one processor 11, and a memory connected to the at least one processor 11, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., wherein the memory stores a computer program that can be executed by at least one processor, and the processor 11 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 to the random access memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0095] A number of components in the electronic device 10 are connected to the I / O interface 15, including: an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, speakers, etc.; a storage unit 18, such as a disk, an optical disk, etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0096] The processor 11 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 11 executes the various methods and processes described above, such as a structured report management method.

[0097] In some embodiments, a structured report management method may be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as a storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the structured report management method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to execute a structured report management method in any other appropriate manner (e.g., by means of firmware).

[0098] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0099] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when the computer program is executed by the processor, the functions / operations specified in the flow chart and / or block diagram are implemented. The computer program may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0100] In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in combination with an instruction execution system, device or equipment. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0101] To provide interaction with a user, the systems and techniques described herein may be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0102] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0103] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services.

[0104] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the present invention can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document does not limit this.

[0105] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A structured report management method, characterized in that: include: Obtaining an original report file, and processing the original report file to generate structured data; Establishing an index according to the structured data, and generating storage data according to the index and the structured data; A user query request is obtained, target data is determined from the stored data based on the query request, and a reconstruction report is generated according to the target data.

2. The method according to claim 1, characterized in that The processing of the original report file to generate structured data includes: Identify the file format and content structure of the original report file; Extracting data from the original report file based on the file format and the content structure to generate extracted data, wherein the extracted data includes cell data, format, style, and embedded charts; Structuring is performed on each of the extracted data to generate structured data.

3. The method according to claim 2, characterized in that The step of establishing an index according to the structured data includes: Using the structured data corresponding to the cell data as first data, and using the structured data corresponding to the format, the style, and the embedded chart as second data; Determine a key field in the first data, and establish a first index for the key field; A second index is established for the second data.

4. The method according to claim 1, characterized in that: The generating storage data according to the index and the structured data includes: compressing the structured data to generate compressed data; The stored data is generated according to the corresponding relationship between the compressed data and the index.

5. The method according to claim 4, characterized in that The determining target data from the stored data based on the query request includes: Matching the index of the stored data through the query request to obtain a target index corresponding to the query request; The target compressed data corresponding to the target index is acquired from the stored data as the target data.

6. The method according to claim 5, characterized in that The generating a reconstruction report according to the target data includes: decompressing the target data to generate decompressed target data; Determine a target report element corresponding to the decompressed target data, wherein the target report element includes target cell data, target format, target style, and target embedded chart; The reconstructed report is generated according to the target report element by a report tool.

7. The method according to claim 1, characterized in that The method further comprises: Periodically evaluating the stored data to determine an evaluation result, wherein the evaluation result includes a query frequency and a data update frequency; An adjustment parameter is determined according to the evaluation result, and the stored data is adjusted according to the adjustment parameter, wherein the adjustment parameter includes an index structure parameter and a data compression parameter.

8. A structured report management device, characterized in that: include: A structured data generation module, used for acquiring an original report file, and processing the original report file to generate structured data; A storage data generation module, used to establish an index according to the structured data, and generate storage data according to the index and the structured data; The reconstruction report generation module is used to obtain a user query request, determine target data from the stored data based on the query request, and generate a reconstruction report according to the target data.

9. An electronic device, characterized in that: The electronic device comprises: at least one processor; and a memory communicatively coupled to the at least one processor; The memory stores a computer program that can be executed by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the method according to any one of claims 1 to 7.

10. A computer storage medium, characterized in that: The computer storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement the method according to any one of claims 1 to 7 when executed.

Images