Customized future report generation method and system

By customizing future report generation methods and systems, using large language models and mapping databases to intelligently match and automated conversion, the problems of low efficiency and low accuracy of traditional report generation are solved, and flexible, personalized, accurate and efficient report generation is achieved. .

CN119046334AActive Publication Date: 2024-11-29河北网星软件有限公司
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411236213.4
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-09-04
Publication Date
2024-11-29
Estimated Expiration
2044-09-04

AI Technical Summary

Technical Problem

Traditional report generation methods are inefficient and low in accuracy, requiring a lot of trial and error and exploration, making it difficult to quickly respond to new report requirements, resulting in cumbersome and time-consuming data query and report generation process.

Method used

Provide a customized future report generation method and system, which determines target data query statements and report generation statements by responding to target information, directly extracts key data sets from the target data warehouse, automatically processes data, and generates target reports. The system includes a computing module, a data acquisition module and a report generation module, and uses a large language model and a mapping database to achieve intelligent matching and automated conversion.

Benefits of technology

It improves the flexibility and personalization of report generation, ensures data accuracy and timeliness, saves labor costs, significantly improves work efficiency, and provides a solid data foundation to support decision-making.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119046334A_ABST
    Figure CN119046334A_ABST
Patent Text Reader

Abstract

The invention provides a customized future report generation method and system, and belongs to the technical field of report generation, and the method comprises the steps: responding to received target information, and determining a data query statement and a report generation statement corresponding to the target information; the target information comprises generation demand information of the target report; determining a target data set from a target data warehouse according to the data query statement, wherein the target data set comprises data for generating a target report; and processing the target data set according to the report generation statement to obtain a target report. According to the customized future report generation method and system provided by the invention, the problem of low report generation efficiency can be solved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present disclosure belongs to the technical field of report generation, and more specifically, to a customized future report generation method and system. Background Art

[0002] Customized report generation refers to designing and creating reports with personalized layout, calculation logic, and visual presentation according to specific business needs and data analysis goals. This approach can help enterprises more effectively monitor business performance, identify trends and anomalies, and support decision making. In traditional methods, determining the data required to generate reports often requires a lot of trial and error and exploration, which may result in irrelevant data being queried or important data being omitted. In addition, the report generation process is cumbersome and time-consuming. When new report requirements are received, it often takes a long time to determine the required data query statements and report generation methods, resulting in low report generation efficiency and accuracy. Summary of the invention

[0003] The purpose of the present disclosure is to provide a customized future report generation method and system to solve the problem of low report generation efficiency.

[0004] A first aspect of an embodiment of the present disclosure provides a customized future report generation method, comprising: In response to receiving the target information, determining a target data query statement and a target report generation statement corresponding to the target information; the target information includes target report generation requirement information; Determine a target data set from a target data warehouse according to a target data query statement, where the target data set includes data for generating a target report; The target data set is processed according to the target report generation statement to obtain the target report.

[0005] A second aspect of the disclosed embodiment provides a customized future report generation system, including: A calculation module, configured to determine, in response to receiving target information, a target data query statement and a target report generation statement corresponding to the target information; the target information includes target report generation requirement information; A data acquisition module, used to determine a target data set from a target data warehouse according to a target data query statement, wherein the target data set includes data for generating a target report; The report generation module is used to process the target data set according to the target report generation statement to obtain the target report.

[0006] According to a third aspect of an embodiment of the present disclosure, an electronic device is provided, including a memory, a processor, and a computer program stored in the memory and running on the processor, wherein the processor implements the steps of the above-mentioned customized future report generation method when executing the computer program.

[0007] According to a fourth aspect of the embodiments of the present disclosure, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the above-mentioned customized future report generation method are implemented.

[0008] The beneficial effects of the customized future report generation method and system provided by the disclosed embodiment are: by intelligently responding to target information, accurately matching the data query and report generation requirements required by the user, the flexibility and personalization of report generation are improved. At the same time, the key data sets are directly extracted from the target data warehouse to ensure the accuracy and timeliness of the data, providing a solid data foundation for decision-making. In addition, the automatic processing of the target data set and the rapid generation of the target report not only save labor costs, but also significantly improve work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0010] Figure 1 A flowchart of a customized future report generation method provided by an embodiment of the present disclosure; Figure 2 A structural block diagram of a customized future report generation system provided in an embodiment of the present disclosure; Figure 3 A schematic block diagram of an electronic device provided by an embodiment of the present disclosure. DETAILED DESCRIPTION

[0011] In the following description, specific details such as specific system structures and technologies are provided for the purpose of illustration rather than limitation, so as to provide a thorough understanding of the embodiments of the present disclosure. However, it should be clear to those skilled in the art that the present disclosure may be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to avoid obstructing the description of the present disclosure with unnecessary details.

[0012] In order to make the purpose, technical solutions and advantages of the present disclosure more clear, specific embodiments will be described below in conjunction with the accompanying drawings.

[0013] Please refer to Figure 1 , Figure 1 This is a flow chart of a customized future report generation method provided by an embodiment of the present disclosure. The method may include S101 to S103.

[0014] S101: In response to receiving target information, determining a target data query statement and a target report generation statement corresponding to the target information. The target information includes target report generation requirement information.

[0015] In this embodiment, the target information refers to the key input content used to trigger the generation of customized future reports. The target report generation requirement information may include a detailed description of the report's subject, purpose, data range, data time span, specific indicators or parameter requirements, and audience groups.

[0016] For example, in a laboratory scenario, the target information may include: specific experimental project or research field requirements, such as reporting requirements for a new drug development experiment, involving data on drug concentration monitoring, experimental animal reactions, etc. Time range requirements, such as generating experimental data reports for the past week, month, or a specific time period. Data type requirements, specifying specific types of data, such as experimental temperature, pressure, chemical composition analysis results, etc. Report format requirements, which may include specific display requirements such as tables, bar charts, and line charts. User role-specific requirements, different laboratory personnel, such as researchers, managers, technicians, etc., have different reporting requirements.

[0017] For example, in a biological laboratory, the target information may be "generating a report on the temperature, humidity and cell growth rate data of the cell culture experiments in the past month, and displaying the cell growth rate in different time periods in a bar graph."

[0018] In this embodiment, the target data query statement is used to retrieve a specific query language expression of the required data from a specific data storage source (such as a database, data warehouse, etc.) according to the generation requirement information in the target information. In the generation of customized reports, a structured query language (SQL) statement can be used to implement it.

[0019] The target data query statement may include specifying the data source, filtering conditions, sorting methods, and associated queries, etc., to ensure that the data set that meets the report generation requirements is accurately obtained.

[0020] Among them, specifying the data source means clearly obtaining the data from which database, data table or data storage location. According to the time range, data type and other requirements in the target information, you can set the filtering conditions to obtain a specific subset of data. If you need to display the data in a specific order, you can include sorting instructions. Associative query means that if the data is scattered in multiple data tables, you can perform an associated query to obtain the complete data set.

[0021] For example, if the target information is: "Generate a temperature and pressure data report for a certain experimental project within a specific time period", the query statement for generating the target data is as follows: "SELECT temperature, pressure FROM lab_data WHERE experiment_project = 'Specific experiment project name' AND measurement_timeBETWEEN 'Start time' AND 'End time';” In this embodiment, the target report generation statement is an instruction set for generating a final report based on the retrieved data. The target report generation statement may include operations such as data processing, formatting, and chart generation.

[0022] For example, if the target information requires a bar chart to show the reagent usage under different experimental conditions, the target report generation statement may include the following steps: First, use a data query statement to obtain the reagent usage data. Then, use the report generation tool or the function in the programming language to process and group the data. Finally, call the chart drawing function to generate a bar chart and set the format of the chart title, axis labels, etc.

[0023] S102: Determine a target data set from a target data warehouse according to a target data query statement, where the target data set includes data for generating a target report.

[0024] In this embodiment, the target data set is a data set selected from the target data warehouse in order to generate a specific target report. The target data set contains all relevant data that meets the target report generation requirements and is the basis for building the target report.

[0025] Exemplarily, the target data set can be divided into a plurality of data type sets, such as a numerical data set, a text data set, and a date and time data set. Among them, the numerical data set can include specific numerical data such as temperature, pressure, concentration, etc. in the experiment, which can be used to generate statistical charts or perform data analysis. The text data set can include descriptive text, experimental conclusions, etc. in the experimental record, which can be used to generate text content in the report. The date and time data set can include the time information of the recorded experiment, which can be used to filter and analyze data according to the time dimension and generate time series reports.

[0026] In this embodiment, the target data query statement can be used as a filter to accurately filter out data that meets specific conditions from a huge target data warehouse. The target data query statement is executed to extract the target data set from the data warehouse. The target data set may include various data required to generate a target report, such as experimental parameters, result data, time information, etc. Finally, a target report is generated based on these data, and the data is intuitively displayed through different presentation methods (such as tables, charts, etc.) to meet the user's needs for specific information.

[0027] For example, in a biological laboratory, it is necessary to generate a report on a cell culture experiment within a specific time period. The target report requirement is to show the changes in the number of cell growth under different culture conditions. Construct a target data query statement, such as: "SELECT culture_condition, cell_count, observation_time FROM cell_culture_data WHERE observation_time BETWEEN 'start time' AND 'end time'". Execute the target data query statement to obtain the target data set from the data warehouse, including data such as culture conditions, cell number, and observation time. Finally, use the report generation tool to generate a data display table, and display the data in the form of a line graph in the report. The horizontal axis is the observation time, and the vertical axis is the cell number. Different lines represent different culture conditions, which intuitively reflects the growth changes of cells under different conditions. At the end of the report, data analysis results can also be generated.

[0028] S103: Process the target data set according to the target report generation statement to obtain the target report.

[0029] In this embodiment, this specific data set is processed according to the target report generation statement. The processing process may include operations such as data screening, sorting, aggregation, calculation, and selection of appropriate chart types, format settings, etc., to ultimately generate a target report that meets specific requirements.

[0030] For example, the specific content of the target report generation statement is determined, and appropriate data analysis tools and report generation tools are selected. For example, a programming language such as Python can be used in combination with a data analysis library (such as Pandas) to process data, and a report generation library (such as Matplotlib or Seaborn) can be used to visualize data.

[0031] Execute the target report generation statement to perform various operations on the target data set. For example, filter data according to specific conditions, calculate statistics such as average and sum, and group data for better presentation.

[0032] Select the appropriate chart type and format according to the report requirements, such as bar chart, line chart, table, etc., and set the format of title, axis label, color, etc.

[0033] It can be concluded from the above that this embodiment improves the flexibility and personalization of report generation by intelligently responding to target information and accurately matching the data query and report generation requirements required by users. At the same time, key data sets are directly extracted from the target data warehouse to ensure the accuracy and timeliness of the data, providing a solid data foundation for decision-making. In addition, the automatic processing of target data sets and the rapid generation of target reports not only save labor costs, but also significantly improve work efficiency.

[0034] Specifically, whether in laboratory scenarios or other fields, different users have specific requirements for the subject, purpose, data range, format, etc. of the report. This method can accurately respond to these needs and provide reports that meet the needs of people in different roles such as researchers, managers, technicians, etc., greatly improving the practicality and pertinence of the report.

[0035] Through the target data query statement, the required data can be quickly filtered out from the huge data warehouse, avoiding the processing of irrelevant data, saving time and computing resources. At the same time, operations such as clearly specifying the data source and setting the filtering conditions ensure the accuracy and completeness of the data.

[0036] The target report generation statement can perform various processing operations on the target data set, such as data screening, aggregation, calculation, etc., to make the data more valuable. And you can choose the appropriate chart type and format for visualization according to your needs, so that users can understand the data more intuitively. For example, in a biological laboratory, a line chart can be used to display the cell growth rate, which helps to quickly discover trends and patterns in the data.

[0037] Customized report generation provides users with accurate and timely information, reducing the time users spend on manually collating data and making reports, allowing them to focus more on core business and decision-making, and providing strong support for laboratory research and management.

[0038] In one embodiment of the present disclosure, determining a target data query statement and a target report generation statement corresponding to target information includes: The target information is input into a large language model to determine multiple data query features and multiple report generation features.

[0039] The plurality of data query features are matched with the first mapping database to determine a target data query statement.

[0040] The plurality of report generation features are matched with the second mapping database to determine a target report generation statement.

[0041] The first mapping database includes a plurality of standard data query features and data query statements corresponding to each standard data query feature, and the second mapping database includes a plurality of standard report generation features and report generation statements corresponding to each standard report generation feature.

[0042] In this embodiment, the standard data query features and the standard report generation features can be determined based on historical query and historical report generation information. After each report generation, the corresponding data query features, report generation features, and corresponding data query statements and report generation statements are stored. The stored data query features and report generation features are used as standard data query features and standard report generation features, respectively.

[0043] In this embodiment, the large language model is an artificial intelligence language processing model based on deep learning technology. The large language model can learn rich language knowledge and semantic representation by training on large-scale text data. It can understand the meaning of natural language input, including complex sentence structure, lexical ambiguity and contextual relationships.

[0044] Exemplarily, for laboratory report generation, texts in related fields such as scientific research literature, experimental reports, and technical manuals can be collected for training to obtain a large language model so that it can accurately extract features from the input target information. A first mapping database and a second mapping database are established respectively, and a plurality of standard data query features and their corresponding data query statements, as well as standard report generation features and their corresponding report generation statements are sorted out. The target information is input into the large language model to obtain a plurality of data query features and report generation features. Feature matching is performed in the mapping database to determine the target data query statement and the target report generation statement.

[0045] In this embodiment, the first mapping database may store a database of standard features related to data query and corresponding query statements. The purpose is to quickly determine the accurate data query statement based on the input specific data query feature. The second mapping database may store a database of standard report generation features and corresponding report generation statements, aiming to generate a report statement that meets the requirements based on the input report generation features.

[0046] Exemplarily, standard data query features are abstract descriptions of specific data query requirements, used to match data query statements. For example, specific experimental project features ("drug development experimental data query"), specific time range features ("past month data query"), specific data indicator features ("temperature data query"), etc. Standard report generation features are abstract descriptions of report generation requirements, used to determine report generation statements. For example, specific chart format features ("display as a bar chart"), specific data sorting features ("data report generation in ascending order of time"), specific data filtering features ("report generation that only displays successful experimental data"), etc.

[0047] For example, in a chemical laboratory, the target information is "generate a report on the usage of various reagents in a specific chemical experiment in the past month, and use a bar chart to show the usage differences of different reagents". The large language model extracts data query features such as "past month", "specific chemical experiment", "reagent usage", etc. from this target information, and report generation features such as "bar chart", "comparison of different reagents", etc. After matching with the first mapping database, the target data query statement is determined to filter out the data on reagent usage in the past month from the data table of a specific experiment. After matching with the second mapping database, the target report generation statement is determined to use a reporting tool to generate a bar chart to compare and display the usage of different reagents.

[0048] This embodiment realizes the automatic conversion from target information to data query statements and report generation statements by combining the large language model with the mapping database. This method not only improves the efficiency of data processing and report generation, but also ensures the accuracy and consistency of queries and reports. Through the in-depth understanding of natural language input by the large language model, it can capture complex data query and report generation requirements, and quickly match the corresponding query and report statements through the mapping database, thereby meeting the diverse data processing and report generation requirements.

[0049] In one embodiment of the present disclosure, matching multiple data query features with a first mapping database to determine a target data query statement includes: The similarity between the first data query feature and each standard data query feature in the first mapping database is calculated. The first data query feature is a feature among the multiple data query features.

[0050] The standard query statement corresponding to the second data query feature is adjusted to obtain a data query statement corresponding to the first data query feature. The second data query feature is a standard data query feature whose similarity to the first data query feature is greater than the first similarity.

[0051] The data query statements corresponding to the first data query features are integrated to obtain a target data query statement.

[0052] In this embodiment, similarity can be calculated based on semantic understanding and keyword matching. For example, the first data query feature and the standard data query feature can be converted into vector representations using methods such as word vector representation and cosine similarity calculation in natural language processing technology, and then the cosine similarity between them can be calculated.

[0053] In this embodiment, calculating the similarity between the first data query feature and each standard data query feature in the first mapping database includes: In response to the first data query feature belonging to a numerical attribute, a similarity between the first data query feature and a plurality of numerical standard data query features in the first mapping database is calculated based on a first formula.

[0054] The first formula is: umeric( , )=

[0055] in, umeric( , )express and The similarity of represents the xth first data query feature, represents the oth standard data query feature, represents the qth attribute value of the xth first data query feature, o represents the oth standard data query feature in the first mapping database, represents the qth attribute value of the oth standard data query feature, n represents the total number of attribute values ​​of the oth standard data query feature, Represents a fixed constant.

[0056] In response to the first data query feature belonging to a text attribute, similarity between the first data query feature and a plurality of text-type standard data query features in the first mapping database is calculated based on word vector similarity.

[0057] In this embodiment, the standard query statement corresponding to the second data query feature is adjusted, including: when the first data query feature is similar to the standard data query feature, the difference feature between the two is extracted, the adjustment content is determined based on the type of the difference feature, and the standard query statement is adjusted.

[0058] Exemplarily, if the difference feature is a different time range, that is, the type of the difference feature is a time range, then the time filter condition in the query statement can be adjusted. If the difference feature is a different data type, then the data field of the query can be adjusted, etc. For example, in a physical laboratory, the first data query feature can be combined into "query the operating data of a specific instrument under high temperature conditions in the past week", which is similar to a standard data query feature combination of "query the operating data of a specific instrument in the past month". The difference features extracted are time range and operating conditions. According to the difference features, the time range in the standard query statement is adjusted from "past month" to "past week", and the filter condition of high temperature conditions is added, so as to obtain a query statement that meets the requirements of the first data query feature.

[0059] For example, assume that the data in the physical laboratory is stored in a table named lab_data, which contains the fields instrument_id (instrument number), data_time (data time), temperature (temperature), and running_data (running data). The standard query statement corresponding to the standard data query feature is as follows: SELECT running_data FROM lab_data WHERE instrument_id = 'specific instrument number' AND data_time BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND NOW(); The query statement adjusted according to the difference characteristics is: SELECT running_data FROM lab_data WHERE instrument_id = 'specific instrument number' AND data_time BETWEEN DATE_SUB(NOW(), INTERVAL 1 WEEK) AND NOW() AND temperature>'high temperature threshold'; In this embodiment, the first similarity changes dynamically. Different similarity thresholds can be set based on experience to conduct experiments, and the accuracy and efficiency of the target data query statements generated under different thresholds can be compared. The optimal similarity threshold is selected as the initial similarity threshold based on the experimental results. On this basis, the similarity threshold is dynamically adjusted based on the initial similarity threshold and the data distribution change, data type change or data volume change in the data warehouse to obtain the first similarity.

[0060] For example, if the data distribution, data type or data volume in the data warehouse changes, it will affect the similarity judgment. For example, if more special cases or new data features appear in the new data, the first similarity can be reduced to adapt to such changes to ensure that a more suitable standard query statement can be found for adjustment. The data can be analyzed regularly to evaluate the impact of changes in data features on the first similarity judgment, and the first similarity can be adjusted accordingly.

[0061] This embodiment achieves automatic parsing and generation of complex data query requirements by matching data query features with a mapping database. This embodiment not only improves query efficiency, but also reduces the risk of human error. Through precise matching and semantic understanding, query statements that are closer to user needs can be generated, providing users with a more convenient and efficient data query experience. At the same time, the adjustment strategy based on the difference characteristics further ensures the accuracy and practicality of the query results, and adjusts some corresponding contents based on the existing data query statements, reducing the consumption of computing resources and time costs of regenerating data query statements.

[0062] This embodiment sets an initial threshold and dynamically adjusts the first similarity based on data changes, so as to flexibly respond to changes in the data warehouse and improve the accuracy and efficiency of data query.

[0063] In one embodiment of the present disclosure, matching multiple report generation features with a second mapping database to determine a target report generation statement includes: The similarity between the first report generation feature and each standard report generation feature in the second mapping database is calculated. The first report generation feature is a feature among the multiple report generation features.

[0064] The standard report generation statement corresponding to the second report generation feature is adjusted to obtain a report generation statement corresponding to the first report generation feature. The second report generation feature is a standard report generation feature whose similarity to the first report generation feature is greater than a second similarity.

[0065] The report generation statements corresponding to the first report generation features are integrated to obtain a target report generation statement.

[0066] In this embodiment, the similarity calculation may adopt various methods, such as based on keyword matching, semantic understanding, etc. For example, the first report generation feature and the standard report generation feature are converted into vector representations, and the cosine similarity between the vectors is calculated.

[0067] In this embodiment, calculating the similarity between the first report generation feature and each standard report generation feature in the second mapping database includes: The similarity between the first report generation feature and each standard report generation feature in the second mapping database is calculated based on the word vector similarity.

[0068] In this embodiment, the difference between the first report generation feature and the second report generation feature is analyzed, and the standard generation statement is modified according to the difference. For example, if the first report generation feature requires a specific chart color, and this setting is not included in the standard generation statement, the corresponding color setting code can be added.

[0069] In this embodiment, statement integration can combine the adjusted report generation statements together by string concatenation, code merging, etc., to ensure that the generated report can meet all report generation feature requirements.

[0070] For example, in a chemical laboratory, the goal is to generate a report for a specific experiment, in which one of the report generation features is "displaying the experimental result data in a red bar graph". First, calculate the similarity between this feature and the standard report generation feature in the second mapping database. Suppose a standard report generation feature "displaying data in a bar graph" is found with a high similarity (greater than the second similarity threshold). Adjust the standard generation statement corresponding to this standard report generation feature and add a red setting code. Perform similar processing on other report generation features, and finally integrate the adjusted report generation statements to generate the target report generation statement, thereby generating a red bar graph experimental result report that meets the requirements.

[0071] This embodiment automatically generates report generation statements that meet specific requirements by combining precise matching with flexible adjustment. By calculating similarity, the closest standard report generation statement can be accurately found to reduce duplication of work. At the same time, the statement is adjusted according to feature differences to ensure that the report meets all personalized requirements. This method improves the efficiency and quality of report generation and is particularly suitable for complex and changeable report requirement scenarios.

[0072] In one embodiment of the present disclosure, determining a target data set from a target data warehouse according to a target data query statement includes: The target data warehouse includes a first data warehouse and a second data warehouse, the first data warehouse includes a plurality of first data tables, and the second data warehouse includes a plurality of second data tables, and the priority of the plurality of first data tables is higher than the priority of the plurality of second data tables.

[0073] Determine the target data table based on the target data query statement.

[0074] In response to the target data table being the first data table, a target data set is determined from the first data warehouse according to the target data query statement.

[0075] In response to the target data table being the second data table, a target data set is determined from the second data warehouse according to the target data query statement.

[0076] In this embodiment, according to the access popularity of the target data query statement, it is allocated to different data warehouses for data extraction. The access popularity reflects the frequency and importance of the query. By reasonably allocating resources, the efficiency and accuracy of data extraction can be improved.

[0077] In this embodiment, the storage space and the number of stored data tables of the first data warehouse are both smaller than those of the second data warehouse, and the data update frequency and data query speed of the first data warehouse are both greater than those of the second data warehouse. The priority of a data table represents the importance of the data. The access popularity reflects the frequency and importance of the target data query statement being used.

[0078] In this embodiment, the target data query statement is analyzed to find out the data table information involved therein, so as to determine whether the target data table belongs to the first data warehouse or the second data warehouse. According to the ownership of the target data table, the target data query statement is used to extract data from the corresponding data warehouse, and the extracted data is integrated into the target data set.

[0079] For example, in an enterprise's data analysis system, the first data warehouse stores multiple first data tables of core business data, which have high requirements for real-time and accuracy and high priority. The second data warehouse stores multiple second data tables of some auxiliary data. When conducting important business decision analysis, the target data query statement involves the first data table, and the data is quickly extracted from the first data warehouse to ensure the timeliness and accuracy of the data. When conducting some general data analysis, the target data query statement involves the second data table, and the data is extracted from the second data warehouse to meet the analysis needs while allocating resources reasonably.

[0080] In this embodiment, the data in the target data warehouse may include manually imported data information, such as importing an Excel spreadsheet or Word document storing data information into the target data warehouse. The data in the target data warehouse may also include data information obtained from related devices, such as exporting data from a device interface, or obtaining data information through wireless communication.

[0081] According to the needs of laboratory report generation, you can design a suitable data table structure to store equipment data. For example, you can create a table containing fields such as equipment number, timestamp, data value, etc. Use a database connection library or tool to write the collected data to the target data warehouse. You can perform preliminary processing on the collected data, such as parsing the data format, converting the data type, removing noise, etc. Ensure that the collected data meets the storage requirements of the data warehouse. You can set up regular data cleanup strategies to delete expired or unnecessary data to keep the data warehouse running efficiently.

[0082] This embodiment effectively improves the efficiency and accuracy of data extraction by allocating target data query statements to different data warehouses for data extraction based on their access popularity. At the same time, by reasonably setting the priority and storage space of the data warehouse, the real-time and accuracy of the core business data are ensured, and resources are reasonably allocated. In addition, this embodiment also supports importing data from multiple data sources, and provides data preprocessing and regular cleanup strategies, further improving the practicality and efficiency of the data warehouse.

[0083] In an embodiment of the present disclosure, the customized future report generation method further includes: updating data in the first data warehouse based on the first frequency.

[0084] The second data warehouse is updated based on the second step frequency. The first step frequency is greater than the second step frequency.

[0085] In this embodiment, different data warehouses are updated with different step frequencies according to the importance and frequency of use of the data. The data in the first data warehouse is more important or more frequently used, so a higher first step frequency is used to update the data to ensure the timeliness and accuracy of the data. The data in the second data warehouse is relatively less important or less frequently used, so a lower second step frequency is used to update the data to balance the cost and benefit of data update.

[0086] Exemplarily, the first step frequency is greater than the second step frequency. For example, the first step frequency can be set to update once an hour, while the second step frequency can be set to update once a day. The data update operation may include determining the corresponding data source based on the data table in the corresponding data warehouse, and the data source may include multiple devices. When the data update time arrives, an access signal may be sent to the corresponding device. After the device verification is passed, the corresponding data may be transferred to the corresponding data warehouse for storage. During the data update process, if an error or abnormal situation occurs, the system will perform corresponding error handling and record log information for subsequent troubleshooting and repair.

[0087] For example, in a financial institution, the first data warehouse stores key data such as real-time transaction data and customer account information, which need to be updated in a timely manner to support real-time transaction monitoring and risk assessment. Therefore, the first frequency is adopted to update the data of the first data warehouse every hour. The second data warehouse stores historical transaction records, customer credit ratings and other data, which are updated relatively less frequently, and the second frequency can be adopted to update the data once a day.

[0088] This embodiment significantly improves data processing efficiency and report generation quality through differentiated update strategies. For high-frequency, important data, high-frequency updates are used to ensure real-time performance. For low-frequency, minor data, low-frequency updates are used to save costs. This strategy not only ensures the timeliness and accuracy of key data, but also optimizes resource allocation and achieves the best balance between cost and benefit.

[0089] In an embodiment of the present disclosure, the customized future report generation method further includes: calculating the access popularity of the plurality of first data tables and the plurality of second data tables based on the historical data query statement.

[0090] If the access heat of the data table is greater than or equal to the first heat, future update data of the corresponding data table is stored in the first data warehouse.

[0091] If the access heat is less than the first heat, the future update data of the corresponding data table is stored in the second data warehouse.

[0092] In this embodiment, all query statements in the past period of time are recorded, the collected historical data query statements are analyzed, and the total number of times each data table is queried, the query frequency, and the user role that issued the query request are counted to comprehensively calculate the access popularity of each data table.

[0093] = + +

[0094] Among them, H( ) represents the access popularity of the i-th data table, Indicates the i-th data table, and N indicates the query data table The total number of times, Indicates the total number of queries to the target data warehouse, M indicates The query frequency, represents the query frequency of the target data warehouse, Indicates the jth query data table User roles, Indicates user role The corresponding weight, , They represent different weight coefficients respectively.

[0095] For example, in a financial institution, there are multiple data tables for storing customer information, transaction records and other data. By analyzing historical data query statements, it is found that the access popularity of the customer basic information table and the recent transaction record table is higher, greater than the first popularity. Therefore, the future update data of these two data tables are stored in the first data warehouse for fast query and analysis. Some historical transaction summary tables have a lower access popularity, less than the first popularity, so their future update data are stored in the second data warehouse.

[0096] This embodiment achieves refined management and storage of data by distinguishing the access popularity of data tables. Based on the analysis of historical data query statements, the method stores data tables with high access popularity in a high-performance first data warehouse to ensure fast response and efficient query. At the same time, data tables with low access popularity are stored in the second data warehouse, which effectively utilizes storage resources and computing resources.

[0097] Corresponding to the customized future report generation method of the above embodiment, Figure 2 This is a structural block diagram of a customized future report generation system provided by an embodiment of the present disclosure. For ease of explanation, only the parts related to the embodiment of the present disclosure are shown. Figure 2 , the customized future report generation system 20 includes: The calculation module is used to determine the target data query statement and the target report generation statement corresponding to the target information in response to receiving the target information. The target information includes the generation requirement information of the target report.

[0098] The data acquisition module is used to determine the target data set from the target data warehouse according to the target data query statement. The target data set includes data for generating a target report.

[0099] The report generation module is used to process the target data set according to the target report generation statement to obtain the target report.

[0100] In one embodiment of the present disclosure, the computing module is specifically configured to input target information into a large language model and determine a plurality of data query features and a plurality of report generation features.

[0101] The plurality of data query features are matched with the first mapping database to determine a target data query statement.

[0102] The plurality of report generation features are matched with the second mapping database to determine a target report generation statement.

[0103] The first mapping database includes a plurality of standard data query features and data query statements corresponding to each standard data query feature, and the second mapping database includes a plurality of standard report generation features and report generation statements corresponding to each standard report generation feature.

[0104] In one embodiment of the present disclosure, the calculation module is further configured to calculate the similarity between the first data query feature and each standard data query feature in the first mapping database. The first data query feature is a feature among the multiple data query features.

[0105] The standard query statement corresponding to the second data query feature is adjusted to obtain a data query statement corresponding to the first data query feature. The second data query feature is a standard data query feature whose similarity to the first data query feature is greater than the first similarity.

[0106] The data query statements corresponding to the first data query features are integrated to obtain a target data query statement.

[0107] In an embodiment of the present disclosure, the calculation module is further configured to calculate the similarity between the first report generation feature and each standard report generation feature in the second mapping database. The first report generation feature is a feature among the multiple report generation features.

[0108] The standard report generation statement corresponding to the second report generation feature is adjusted to obtain a report generation statement corresponding to the first report generation feature. The second report generation feature is a standard report generation feature whose similarity to the first report generation feature is greater than a second similarity.

[0109] The report generation statements corresponding to the first report generation features are integrated to obtain a target report generation statement.

[0110] In one embodiment of the present disclosure, the data acquisition module is specifically used for the target data warehouse including a first data warehouse and a second data warehouse, the first data warehouse includes a plurality of first data tables, and the second data warehouse includes a plurality of second data tables. The priority of the plurality of first data tables is higher than the priority of the plurality of second data tables.

[0111] Determine the target data table based on the target data query statement.

[0112] In response to the target data table being the first data table, a target data set is determined from the first data warehouse according to the target data query statement.

[0113] In response to the target data table being the second data table, a target data set is determined from the second data warehouse according to the target data query statement.

[0114] In one embodiment of the present disclosure, the customized future report generation system 20 further includes: The data updating module is used to update the data in the first data warehouse based on the first step.

[0115] The second data warehouse is updated based on the second step frequency. The first step frequency is greater than the second step frequency.

[0116] In one embodiment of the present disclosure, the customized future report generation system 20 further includes: The data import module is used to calculate the access popularity of multiple first data tables and multiple second data tables based on historical data query statements.

[0117] If the access heat of the data table is greater than or equal to the first heat, future update data of the corresponding data table is stored in the first data warehouse.

[0118] If the access heat is less than the first heat, the future update data of the corresponding data table is stored in the second data warehouse.

[0119] See also Figure 3 , Figure 3 A schematic block diagram of an electronic device provided by an embodiment of the present disclosure. Figure 3 The electronic device 300 in the embodiment shown may include: one or more processors 301, one or more input devices 302, one or more output devices 303 and one or more memories 304. The processors 301, input devices 302, output devices 303 and memories 304 communicate with each other via a communication bus 305. The memory 304 is used to store computer programs, which include program instructions. The processor 301 is used to execute the program instructions stored in the memory 304. The processor 301 is configured to call the program instructions to execute the functions of the modules in the above-mentioned system embodiments, such as Figure 2 The functions of modules 21 to 23 are shown.

[0120] It should be understood that in the embodiment of the present disclosure, the processor 301 may be a central processing unit (CPU), and the processor may also be other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.

[0121] The input device 302 may include a touch panel, a fingerprint collection sensor (for collecting the user's fingerprint information and fingerprint direction information), a microphone, etc., and the output device 303 may include a display (LCD, etc.), a speaker, etc.

[0122] The memory 304 may include a read-only memory and a random access memory, and provide instructions and data to the processor 301. A portion of the memory 304 may also include a non-volatile random access memory. For example, the memory 304 may also store information about the device type.

[0123] In a specific implementation, the processor 301, input device 302, and output device 303 described in the embodiments of the present disclosure may execute the implementation methods described in the first and second embodiments of the customized future report generation method provided in the embodiments of the present disclosure, and may also execute the implementation methods of the electronic device 300 described in the embodiments of the present disclosure, which will not be repeated here.

[0124] In another embodiment of the present disclosure, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores a computer program, wherein the computer program includes program instructions, and when the program instructions are executed by the processor, all or part of the processes in the above-mentioned embodiment method are implemented, and the computer program can also be completed by instructing the relevant hardware through the computer program. The computer program can be stored in a computer-readable storage medium, and when the computer program is executed by the processor, the steps of each of the above-mentioned method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form, etc. The computer-readable medium can include: any entity or device capable of carrying computer program code, recording medium, U disk, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium, etc.

[0125] The computer-readable storage medium may be an internal storage unit of the electronic device of any of the aforementioned embodiments, such as a hard disk or memory of the electronic device. The computer-readable storage medium may also be an external storage device of the electronic device, such as a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (SecureDigital, SD) card, a flash card (Flash Card), etc. equipped on the electronic device. Furthermore, the computer-readable storage medium may also include both an internal storage unit of the electronic device and an external storage device. The computer-readable storage medium is used to store computer programs and other programs and data required by the electronic device. The computer-readable storage medium may also be used to temporarily store data that has been output or is to be output.

[0126] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this disclosure.

[0127] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the electronic devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0128] In the several embodiments provided in the present application, it should be understood that the disclosed electronic device and method can be implemented in other ways. For example, the system embodiments described above are only schematic. For example, the division of units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. In addition, the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces or units, or it can be an electrical, mechanical or other form of connection.

[0129] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the embodiments of the present disclosure.

[0130] In addition, each functional unit in each embodiment of the present disclosure may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0131] The above are only specific embodiments of the present disclosure, but the protection scope of the present disclosure is not limited thereto. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed in the present disclosure, and these modifications or replacements should be included in the protection scope of the present disclosure. Therefore, the protection scope of the present disclosure should be based on the protection scope of the claims.

Claims

1. A customized future report generation method, It is characterized in that include: In response to receiving the target information, determining a target data query statement and a target report generation statement corresponding to the target information; The target information includes target report generation requirement information; Determining a target data set from a target data warehouse according to the target data query statement, wherein the target data set includes data for generating a target report; The target data set is processed according to the target report generation statement to obtain a target report.

2. The customized future report generation method according to claim 1, It is characterized in that The step of determining a target data query statement and a target report generation statement corresponding to the target information includes: Inputting the target information into a large language model to determine a plurality of data query features and a plurality of report generation features; Matching the multiple data query features with the first mapping database to determine a target data query statement; Matching the multiple report generation features with a second mapping database to determine a target report generation statement; The first mapping database includes a plurality of standard data query features and data query statements corresponding to each standard data query feature, and the second mapping database includes a plurality of standard report generation features and report generation statements corresponding to each standard report generation feature.

3. The customized future report generation method according to claim 2, It is characterized in that The step of matching the plurality of data query features with the first mapping database to determine a target data query statement includes: Calculating the similarity between a first data query feature and each standard data query feature in the first mapping database; the first data query feature is a feature among the multiple data query features; The standard query statement corresponding to the second data query feature is adjusted to obtain a data query statement corresponding to the first data query feature; the second data query feature is a standard data query feature whose similarity to the first data query feature is greater than the first similarity; The data query statements corresponding to the first data query features are integrated to obtain the target data query statement.

4. The customized future report generation method according to claim 2, It is characterized in that The step of matching the plurality of report generation features with the second mapping database to determine a target report generation statement includes: Calculating the similarity between a first report generation feature and each standard report generation feature in the second mapping database; the first report generation feature is a feature among the multiple report generation features; The standard generation statement corresponding to the second report generation feature is adjusted to obtain a report generation statement corresponding to the first report generation feature; the second report generation feature is a standard report generation feature whose similarity to the first report generation feature is greater than a second similarity; The report generation statements corresponding to the first report generation features are integrated to obtain the target report generation statement.

5. The customized future report generation method according to claim 1, It is characterized in that Determining the target data set from the target data warehouse according to the target data query statement includes: The target data warehouse includes a first data warehouse and a second data warehouse, the first data warehouse includes a plurality of first data tables, and the second data warehouse includes a plurality of second data tables; the priority of the plurality of first data tables is higher than the priority of the plurality of second data tables; Determine a target data table based on the target data query statement; In response to the target data table being the first data table, determining a target data set from the first data warehouse according to the target data query statement; In response to the target data table being the second data table, a target data set is determined from the second data warehouse according to the target data query statement.

6. The customized future report generation method according to claim 5, It is characterized in that Also includes: Based on the first frequency, update the data in the first data warehouse; Updating data in the second data warehouse based on a second step frequency; The first step frequency is greater than the second step frequency.

7. The customized future report generation method according to claim 5, It is characterized in that Also includes: Calculating the access popularity of the plurality of first data tables and the plurality of second data tables based on the historical data query statement; If the access popularity of the data table is greater than or equal to the first popularity, storing future update data of the corresponding data table in the first data warehouse; If the access heat is less than the first heat, the future update data of the corresponding data table is stored in the second data warehouse.

8. A customized future report generation system, It is characterized in that include: A calculation module, configured to determine, in response to receiving the target information, a target data query statement and a target report generation statement corresponding to the target information; The target information includes target report generation requirement information; A data acquisition module, used to determine a target data set from a target data warehouse according to the target data query statement, wherein the target data set includes data for generating a target report; The report generation module is used to process the target data set according to the target report generation statement to obtain a target report.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and running on the processor, It is characterized in that When the processor executes the computer program, the steps of the method according to any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium storing a computer program. It is 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 7 are implemented.

Citation Information

Patent Citations

  • Report query method and device and storage medium

    CN109902100A

  • Database query based match engine

    US20180293319A1