Report generation method and device, electronic equipment and storage medium

By obtaining the target configuration information of the report generation method, deciding whether to use the big data platform to process the report result data, solving the problem of low intelligence in the existing technology and improving the performance of the business system.

CN119026583APending Publication Date: 2024-11-26CHINA CONSTRUCTION BANK +1
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411168157.5
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-23
Publication Date
2024-11-26

AI Technical Summary

Technical Problem

In the prior art, the computing power of the database itself leads to a low degree of intelligence in the generation of report result data, affecting the overall performance of the business system.

Method used

By obtaining the target configuration information of the report generation method, we decide whether to use the big data platform. If used, the big data platform will process the original information table to generate report result data; if not used, it will be processed by the application database, and the result data will be stored in the report result data. Information table.

Benefits of technology

It improves the intelligence of report result data generation, reduces query time, and improves the overall performance of the business system.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119026583A_ABST
    Figure CN119026583A_ABST
Patent Text Reader

Abstract

The invention provides a report generation method and device, electronic equipment and a storage medium, and relates to the technical field of artificial intelligence. The method comprises the steps of obtaining target configuration information of a report generation mode, wherein the target configuration information at least comprises first information; if the first information indicates that the big data platform is used in the process of generating the report result data, determining a report generation mode by referring to the target configuration information through the big data platform, and processing the original information table by using the report generation mode through the big data platform to obtain the report result data; and if the first information indicates that the big data platform is not used in the process of generating the report result data, determining a report generation mode through reference target configuration information of an application database to which the original information table belongs, and processing the original information table through the application database by using the report generation mode to obtain the report result data. The technical problems that in the prior art, the intelligence degree of report result data generation is low, and the overall performance of a service system is affected are solved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present disclosure relates to the field of artificial intelligence technology, and in particular to a report generation method, device, electronic device and storage medium. Background Art

[0002] Normally, the computing power of the database itself is used to generate report result data based on fixed report configurations. In this way, the intelligent level of report result data generation is low, which affects the overall performance of the business system. Summary of the invention

[0003] The present disclosure aims to solve one of the technical problems in the related art at least to some extent.

[0004] To this end, the first purpose of the present disclosure is to propose a report generation method to improve the intelligence level of report result data generation, effectively reduce the time consumption of report result data query, and improve the overall performance of the business system.

[0005] The second objective of the present disclosure is to provide a report generating device.

[0006] A third objective of the present disclosure is to provide an electronic device.

[0007] A fourth objective of the present disclosure is to provide a computer-readable storage medium.

[0008] A fifth object of the present disclosure is to provide a computer program product.

[0009] To achieve the above-mentioned purpose, the first aspect of the present disclosure proposes a report generation method, including: obtaining target configuration information of a report generation method, wherein the target configuration information includes at least first information, and the first information is used to determine whether a big data platform is used in the process of generating report result data; when the first information indicates that the big data platform is used in the process of generating report result data, the report generation method is determined by referring to the target configuration information through the big data platform, and the original information table is processed by the big data platform using the report generation method to obtain the report result data; when the first information indicates that the big data platform is not used in the process of generating report result data, the report generation method is determined by referring to the target configuration information through the application database to which the original information table belongs, and the original information table is processed by the application database using the report generation method to obtain the report result data; and the report result data is stored in the report result data information table.

[0010] To achieve the above-mentioned purpose, the second aspect embodiment of the present disclosure proposes a report generation device, including: an acquisition module, used to acquire target configuration information of a report generation method, wherein the target configuration information includes at least first information, and the first information is used to determine whether a big data platform is used in the process of generating report result data; a first determination module, used to determine the report generation method by referring to the target configuration information through the big data platform when the first information indicates that the big data platform is used in the process of generating report result data, and use the report generation method to process the original information table through the big data platform to obtain report result data; a second determination module, used to determine the report generation method by referring to the target configuration information through the application database to which the original information table belongs when the first information indicates that the big data platform is not used in the process of generating report result data, and use the report generation method to process the original information table through the application database to obtain report result data; and a storage module, used to store the report result data in the report result data information table.

[0011] To achieve the above-mentioned purpose, the third aspect embodiment of the present disclosure proposes an electronic device, comprising: a processor, and a memory communicatively connected to the processor; the memory stores computer-executable instructions; the processor executes the computer-executable instructions stored in the memory to implement a report generation method proposed in the first aspect embodiment of the present disclosure.

[0012] To achieve the above-mentioned purpose, the fourth aspect embodiment of the present disclosure proposes a computer-readable storage medium, in which computer execution instructions are stored. When the computer execution instructions are executed by a processor, they are used to implement a report generation method proposed in the first aspect embodiment of the present disclosure.

[0013] To achieve the above-mentioned purpose, the fifth embodiment of the present disclosure proposes a computer program product, including a computer program, which, when executed by a processor, implements the report generation method proposed in the first embodiment of the present disclosure.

[0014] The report generation method, device, electronic device, non-transient computer-readable storage medium storing computer instructions, and computer program product provided by the present disclosure obtain target configuration information of the report generation method, wherein the target configuration information includes at least first information, and the first information is used to determine whether to use the big data platform in the process of generating report result data; when the first information indicates that the big data platform is used in the process of generating report result data, the report generation method is determined by referring to the target configuration information through the big data platform, and the original information table is processed by the big data platform using the report generation method to obtain the report result data; and when the first information indicates that the big data platform is not used in the process of generating report result data, the report generation method is determined by referring to the target configuration information through the application database to which the original information table belongs, and the original information table is processed by the application database using the report generation method to obtain the report result data; and the report result data is stored in the report result data information table. The intelligent degree of report result data generation is improved, and the overall performance of the business system is improved.

[0015] Additional aspects and advantages of the present disclosure will be given in part in the following description and in part will be obvious from the following description or learned through practice of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] The above and / or additional aspects and advantages of the present disclosure will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:

[0017] Figure 1 A flowchart of a report generation method provided by an embodiment of the present disclosure;

[0018] Figure 2 A flowchart of another report generation method provided by an embodiment of the present disclosure;

[0019] Figure 3 A flowchart of another report generation method provided by an embodiment of the present disclosure;

[0020] Figure 4 is a diagram of the overall architecture of the system in the embodiment of the present disclosure;

[0021] Figure 5 is a flow chart of report generation in an embodiment of the present disclosure;

[0022] Figure 6 is a schematic diagram of a human-computer interaction interface of an intelligent question-answering system in an embodiment of the present disclosure;

[0023] Figure 7 A structural diagram of a report generation device provided by an embodiment of the present disclosure;

[0024] Figure 8 It is a schematic structural diagram of an electronic device shown in an exemplary embodiment of the present disclosure. DETAILED DESCRIPTION

[0025] Embodiments of the present disclosure are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present disclosure, and should not be construed as limiting the present disclosure.

[0026] It should be noted that the information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, stored data, displayed data, etc.) and signals involved in this disclosure are all authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with the relevant laws, regulations and standards of relevant countries and regions. The acquisition, transmission, storage, use and processing of data in the technical solution of this disclosure are in compliance with the relevant provisions of national laws and regulations.

[0027] It should be noted that in the embodiments of the present disclosure, certain software, components, models and other existing solutions in the industry may be mentioned, which should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present disclosure, but it does not mean that the applicant has or will necessarily use the solution.

[0028] Figure 1 A flowchart of a report generation method provided by an embodiment of the present disclosure is provided.

[0029] This embodiment takes the report generation method configured as a report generation device as an example. In this embodiment, the report generation method can be configured in a report generation device, and the report generation device can be set in a server or in an electronic device, without limitation.

[0030] This embodiment takes the report generation method configured in an electronic device as an example, wherein the electronic device is a hardware device such as a smart phone, a tablet computer, a personal digital assistant, an e-book, etc. having various operating systems.

[0031] It should be noted that the execution subject of the embodiment of the present disclosure may be, for example, a central processing unit (CPU) in a server or electronic device in terms of hardware, or may be, for example, a related background service in a server or electronic device in terms of software, without limitation.

[0032] like Figure 1 As shown, the report generation method includes:

[0033] S101: Acquire target configuration information of a report generation method, wherein the target configuration information includes at least first information, and the first information is used to determine whether to use a big data platform in the process of generating report result data.

[0034] The report result data is used to integrate the report result data, and the report result data can support the final rendering and display of the report.

[0035] The report generation method refers to the method used to generate the report result data. The target configuration information is used to configure the report generation method. The report generation methods obtained by configuring different target configuration information are the same or different. For example, if the target configuration information includes a first generation cycle, the report result data can be generated based on the first generation cycle, and the method of generating the report result data based on the first generation cycle can be an optional example of the report generation method.

[0036] In some embodiments, the target configuration information may be pre-configured, for example, it may be configured by a user based on personalized usage requirements, or it may be configured based on the application of the generated report result data, and there is no limitation on this.

[0037] The target configuration information may include first information, which may be a field that may be configured with different values, one value for configuring the use of a big data platform in the process of generating report result data, and another value for configuring the use of a big data platform in the process of generating report result data. For example, whether to use a big data platform to generate report result data may be personalized based on the access volume of a business system, or personalized based on the data processing pressure of a business system, and there is no restriction on this.

[0038] Of course, the target configuration information may also include any other possible information for configuring the report generation method, and there is no limitation to this.

[0039] The big data platform in the disclosed embodiment can support a variety of report generation methods. At the same time, it can reduce the data processing pressure of the business system. The big data platform has massive data processing capabilities, real-time computing capabilities, and parallel computing capabilities, and can effectively support the generation of report result data.

[0040] Optionally, in some embodiments, the target configuration information further includes at least one of the following: report number, report name, report type, report period, second information, wherein the second information is used to indicate whether the large model is enabled, report storage address, report generation interface address, and third information, wherein the third information is used to indicate whether the target configuration information is effective, the creation time of the target configuration information, and the update time of the target configuration information. Thus, it supports the generation of report result data based on configuration, and improves the flexibility and generation effect of report result data generation.

[0041] The above-mentioned various possible target configuration information is configurable. Configurability means that the administrator can complete the configuration or viewing of the report control information through operations such as adding, modifying, deleting, and querying on the configuration interface. On this configuration interface, the administrator can configure the main control information of the report: report unique number (automatically generated by the system), report name (need to be verified for duplicate), report type (real-time, periodic), report period (day, week, month, year, etc.), whether a big data platform is required, whether to enable the big model, report storage address, report generation interface address, etc.

[0042] S102: When the first information indicates that a big data platform is used in the process of generating report result data, the report generation method is determined by referring to the target configuration information through the big data platform, and the original information table is processed by the big data platform using the report generation method to obtain the report result data.

[0043] The original information table refers to a data table containing original data. The original information table may be stored in an application database. The big data platform may obtain the original information table from the application database. Alternatively, the report processing backend server may also synchronize the original information table in the application database to the big data platform based on the data synchronization service, and there is no restriction on this.

[0044] In the above case where the first information indicates that a big data platform is used in the process of generating report result data, the target configuration information can be provided to the big data platform, and the big data platform configures the report generation method based on the target configuration information. Then, the original information table is processed by the big data platform using the report generation method to obtain the report result data.

[0045] For example, the big data platform can parse various information fields in the target configuration information, and determine the report generation method based on the specific values ​​of the information fields. Then, based on the report generation method, the various original data in the original information table are integrated, counted, analyzed, aggregated, etc. to obtain report result data.

[0046] S103: When the first information indicates that the big data platform is not used in the process of generating report result data, the report generation method is determined by referring to the target configuration information of the application database to which the original information table belongs, and the original information table is processed by the application database using the report generation method to obtain the report result data.

[0047] In the case where the first information indicates that the big data platform is not used in the process of generating the report result data, the application database to which the original information table belongs can directly configure the report generation method based on the target configuration information, and then, the original information table is processed by the application database using the report generation method to obtain the report result data. For example, the application database can parse various information fields in the target configuration information, and determine the report generation method based on the specific values ​​of the information fields, and then, based on the report generation method, various original data in the original information table are integrated, counted, analyzed, aggregated, etc. to obtain the report result data.

[0048] That is to say, if it is determined based on the configuration information that the big data platform is not used in the process of generating report result data, the report generation method can be configured locally in the application database based on the target configuration information, and the original information table can be processed locally in the application database based on the report generation method to obtain the report result data.

[0049] S104: Storing the report result data in the report result data information table.

[0050] After obtaining the report result data, the report result data can be stored in the report result data information table. The stored report result data information table can support online query by management personnel.

[0051] The structure of the report result data information table in the disclosed embodiment may include: a report unique number, report result data, and the last updated time. Among them, the report unique number is the unique identifier of the report result data information table, the primary key. A primary key index can be created, through which the report result data in the corresponding report result data information table can be directly obtained. The report result data is a large string field, and the report result data can be stored in the form of a json string. After the report result data is returned, the front end (such as a client that queries the report result data) can parse the field. After obtaining the report result data, the final rendering and display of the report can be completed. The last updated time is used to identify the last updated time of the report result data. Through the "last updated time" field, it can also be determined whether the corresponding report result data is the latest report result data.

[0052] In some embodiments, when the manager is performing an online report query, he can query the report result data based on the index. For example, when the manager is viewing the report, the report query service will be triggered. When requesting the service, the front end (e.g., the client that queries the report result data) will send the report unique number that has been assigned in the report control configuration information table. The back end (e.g., the server that queries the report result data) interface can use the report unique number as the index to query the report result data in the report result data information table, and then perform data analysis and rendering on the queried report result data to complete the rendering and display of the front end report.

[0053] In this embodiment, by obtaining the target configuration information of the report generation method, wherein the target configuration information includes at least the first information, the first information is used to determine whether to use the big data platform in the process of generating the report result data; when the first information indicates that the big data platform is used in the process of generating the report result data, the report generation method is determined by referring to the target configuration information through the big data platform, and the original information table is processed by the big data platform using the report generation method to obtain the report result data; and when the first information indicates that the big data platform is not used in the process of generating the report result data, the report generation method is determined by referring to the target configuration information through the application database to which the original information table belongs, and the original information table is processed by the application database using the report generation method to obtain the report result data; and the report result data is stored in the report result data information table. The intelligent degree of report result data generation is improved, and the overall performance of the business system is improved.

[0054] Figure 2 A flowchart of another report generation method provided by an embodiment of the present disclosure.

[0055] like Figure 2 As shown, the report generation method includes:

[0056] S201: Acquire report requirement information, and determine target report information in the report requirement information.

[0057] The report requirement information is used to describe the requirement for generating report result data. The target report information is used to describe the report to be generated. The determined target report information can be used to retrieve the target configuration information of the corresponding report generation method.

[0058] In the disclosed embodiment, the report requirement information can be obtained based on the intelligent question-answering method, and the target report information in the report requirement information can be determined. For example, a generative large-model intelligent question-answering system can be introduced, and the report requirement information entered by the management personnel can be collected based on the generative large-model intelligent question-answering system. For example, the management personnel can enter a voice request content, and the report requirement information can be obtained based on the analysis of the voice request content. Then, the generative large-model intelligent question-answering system can identify the target report information from the report requirement information based on semantic recognition, and there is no restriction on this.

[0059] Optionally, in the process of determining the target report information in the report requirement information, the semantic content of the report requirement information may be determined, and the sub-semantic content corresponding to each report field may be identified from the semantic content, a query statement may be generated based on the multiple sub-semantic contents and the query description information, and in response to receiving the target instruction information, the multiple sub-semantic contents may be used as the target report information, wherein the target instruction information is used to confirm the correctness of the query statement. The target report information contained in the report requirement information can be accurately captured, and the accuracy of the report result data generation can be improved.

[0060] In some embodiments, semantic recognition can be performed on the report requirement information to identify the semantic content contained in the report requirement information. The report field can be a pre-configured standard field used to match the sub-semantic content related to the report from the semantic content. Report fields are, for example, department name, report time, report type, etc. The inquiry description information is, for example, "Please confirm whether my understanding is correct, your requirement is". Then, the sub-semantic content that matches the department name, report time, report type, etc. can be identified from the semantic content, and then based on each sub-semantic content and the inquiry description information, the inquiry statement is spliced. In addition, the inquiry semantics can also be provided to the management personnel, and the target instruction information can be the instruction information input by the management personnel to confirm the correctness of the inquiry statement. After the generative large model intelligent question and answer system confirms the inquiry statement based on the target instruction information, each of the above sub-semantic contents is used as the target report information.

[0061] S202: Based on the target report information, target configuration information of the report generation method is obtained, wherein the target configuration information includes at least first information, and the first information is used to determine whether to use a big data platform in the process of generating report result data.

[0062] After obtaining the target report information, the target configuration information of the report generation method can be retrieved based on the target report information.

[0063] Optionally, in some embodiments, in the process of obtaining the target configuration information of the report generation method based on the target report information, a report control configuration information table may be obtained, wherein the report control configuration information table includes: multiple candidate report information and candidate configuration information corresponding to each candidate report information, and the candidate report information matching the target report information is determined from the multiple candidate report information, and the candidate configuration information corresponding to the matching candidate report information is used as the target configuration information of the report generation method. Thus, the efficiency and accuracy of obtaining the target configuration information are improved.

[0064] That is to say, in order to realize the configurability of the report generation method in the embodiment of the present disclosure, a management interface can be provided, and the management interface supports business personnel to perform personalized configuration of the configuration information of the report generation method. The configuration information obtained by the configuration can be called candidate configuration information, and a candidate report information can be set for each candidate configuration information. Then, the configured various possible candidate configuration information and the corresponding candidate report information can be stored in the report control configuration information table. This supports the retrieval of the target configuration information of the report generation method based on the target report information.

[0065] S203: When the first information indicates that the big data platform is used in the process of generating report result data, the report generation method is determined by referring to the target configuration information through the big data platform, and the original information table is processed by the big data platform using the report generation method to obtain the report result data.

[0066] S204: When the first information indicates that the big data platform is not used in the process of generating report result data, the report generation method is determined by referring to the target configuration information of the application database to which the original information table belongs, and the original information table is processed by the application database using the report generation method to obtain the report result data.

[0067] S205: Storing the report result data in the report result data information table.

[0068] For the description of S203 - S205 , please refer to the above embodiment for details, which will not be repeated here.

[0069] In this embodiment, by obtaining the target configuration information of the report generation method, wherein the target configuration information includes at least the first information, the first information is used to determine whether the big data platform is used in the process of generating the report result data; when the first information indicates that the big data platform is used in the process of generating the report result data, the report generation method is determined by referring to the target configuration information through the big data platform, and the original information table is processed by the big data platform using the report generation method to obtain the report result data; and when the first information indicates that the big data platform is not used in the process of generating the report result data, the report generation method is determined by referring to the target configuration information through the application database to which the original information table belongs, and the original information table is processed by the application database using the report generation method to obtain the report result data; and the report result data is stored in the report result data information table. The intelligent degree of report result data generation is improved, and the overall performance of the business system is improved. By obtaining the report requirement information, determining the target report information in the report requirement information, and obtaining the target configuration information of the report generation method based on the target report information, the flexibility of obtaining the target configuration information can be effectively improved, and it can be effectively applied to personalized report generation scenarios.

[0070] Figure 3 A flowchart of another report generation method provided by an embodiment of the present disclosure.

[0071] like Figure 3 As shown, the report generation method includes:

[0072] S301: Determine to start a general scheduled report task, wherein the general scheduled report task is used to scan and obtain target configuration information of a report generation method, and the general scheduled report task has a corresponding scheduled time range, and the scheduled time range includes a first moment.

[0073] The scheduled time range may be a time range when the data processing pressure of the business system is relatively small, such as from 0:00 to 2:00 in the morning, and there is no restriction on this.

[0074] In this embodiment, it is possible to support automatic generation of report result data based on the triggering of a general report timing task. In other words, a general report timing task can be started, and the general report timing task can trigger scanning to obtain target configuration information of the report generation method within a set timing time range. For example, the target configuration information is obtained by scanning from the report control configuration information table within the timing time range based on the general report timing task, and there is no limitation on this.

[0075] S302: In response to the current time reaching a first moment, target configuration information of a report generation method is scanned within a scheduled time range, wherein the target configuration information includes at least first information, and the first information is used to determine whether a big data platform is used in the process of generating report result data.

[0076] The above-mentioned timing time range has a corresponding timing time range, and the moment closest to the specific current moment in the timing time range can be called the first moment. When it is detected that the current time reaches the first moment, the scanning of the target configuration information can be triggered. Specifically, when the current time reaches the first moment, the scanning within the timing time range can be triggered to obtain the target configuration information of the report generation method.

[0077] S303: When the first information indicates that the big data platform is used in the process of generating report result data, the report generation method is determined by referring to the target configuration information through the big data platform, and the original information table is processed by the big data platform using the report generation method to obtain the report result data.

[0078] S304: When the first information indicates that the big data platform is not used in the process of generating report result data, the report generation method is determined by referring to the target configuration information of the application database to which the original information table belongs, and the original information table is processed by the application database using the report generation method to obtain the report result data.

[0079] S305: Storing the report result data in the report result data information table.

[0080] For the description of S303 - S305 , please refer to the above embodiment for details, which will not be repeated here.

[0081] In this embodiment, by obtaining the target configuration information of the report generation method, wherein the target configuration information includes at least the first information, and the first information is used to determine whether the big data platform is used in the process of generating the report result data; when the first information indicates that the big data platform is used in the process of generating the report result data, the report generation method is determined by referring to the target configuration information through the big data platform, and the original information table is processed by the big data platform using the report generation method to obtain the report result data; and when the first information indicates that the big data platform is not used in the process of generating the report result data, the report generation method is determined by referring to the target configuration information through the application database to which the original information table belongs, and the original information table is processed by the application database using the report generation method to obtain the report result data; and the report result data is stored in the report result data information table. The intelligent degree of report result data generation is improved, and the overall performance of the business system is improved. By determining to start a general timing task for a report, wherein the general timing task for a report is used to scan and obtain the target configuration information of the report generation method, the general timing task for a report has a corresponding timing time range, the timing time range includes a first moment, and in response to the current time reaching the first moment, the target configuration information of the report generation method is scanned within the timing time range. It can effectively improve the intelligent degree of obtaining the target configuration information, and support improving the intelligent degree of overall report generation.

[0082] In some embodiments of the present disclosure, when the first information indicates that a big data platform is used in the process of generating report result data, a data push service interface is called to process the original information table into a target data file, and the target data file is pushed to the big data platform, and the target data file is processed by the big data platform using a report generation method to obtain the report result data. This enables the big data platform to obtain the target data file in a timely manner, thereby improving the timeliness of generating report result data.

[0083] In some embodiments of the present disclosure, in the process of processing the target data file using the report generation method through the big data platform to obtain the report result data, the target data file may be parsed to obtain the processing index data and the original report data, and the data computing capability of the big data platform may be called to process the original report data using the report generation method and the processing index data to obtain the report result data. This improves the accuracy of the report result data generation.

[0084] In some embodiments of the present disclosure, when the report result data is stored in the report result data information table, a query request may also be received, wherein the query request includes: query data fields, and according to the query data fields, querying and obtaining the report result data from the report result data information table, and generating and providing a target report according to the report result data information table. This can greatly improve the response efficiency of the report query and effectively shorten the time consumption of the report query.

[0085] The examples for the above embodiment are as follows:

[0086] The disclosed embodiment introduces a generative large-model intelligent question-answering system, big data technology, control configurability, and a cache mechanism combined with a newly added intermediate result table (an optional example of a report result data information table). It can not only realize intelligent human-computer interaction and flexible configurability, but also decouple the dependency between the business system and the report generation program, greatly reducing the pressure on the business system and database, while improving the online transaction response rate and concurrency of the business system and the efficiency of report query.

[0087] like Figure 4 and Figure 5 As shown, Figure 4 is a diagram of the overall system architecture in the embodiment of the present disclosure, Figure 5 This is a flow chart of report generation in the embodiment of the present disclosure. The report generation method in the embodiment of the present disclosure is more intelligent, flexible, elastic, and scalable, and can better meet the needs of subsequent business development. An example is as follows:

[0088] The report control configuration information table structure is as follows:

[0089] Report unique number: unique identifier of report control configuration information (an optional example of candidate configuration information), primary key. Automatically generated by the system according to certain rules. After adding configuration information successfully, the front end will cache the configuration information of the corresponding report so that the report unique number can be sent as a parameter when querying the report result data later, so as to realize fast index query according to the report unique number. Report name: the name of the report control configuration information, which cannot be repeated. Therefore, when adding, you can configure a duplicate verification mechanism to ensure that the name is unique to avoid ambiguity. Report type: the type of report generated, which is divided into real-time and periodic. Here is a linkage control. If the report is a real-time type, it is not necessary to set the report cycle, and this type of report can only be completed by borrowing the real-time computing power of big data technology, and cannot directly access the business database, which can effectively avoid database pressure overload. Report cycle: the periodic frequency of generating reports, which can be daily, weekly, monthly, annual, etc. Whether to require a big data platform: This configuration item specifies whether to generate reports with the help of the capabilities of the big data platform. For example, for a data table with a small amount of data, or a small amount of access and a data volume that does not exceed a certain amount (an optional example of an original information table), the report result data can be directly calculated by the database, and the calculation results can be stored in the report result data information table. If you need to use the big data platform, you can follow the rules of the big data platform to complete the upload of report processing indicators and data synchronization. Whether to enable the big model: If this configuration is configured to be enabled, a button icon will be provided to prompt the intelligent question and answer system. Clicking this icon can enable the generative big model intelligent question and answer system; otherwise, the icon will not be displayed. Report storage address: This configuration can support setting the address where the report is stored after downloading in advance. Report generation interface address: The actual interface address for generating report result data. Through this configuration item, the report general scheduled task can know which interface to call to generate report result data. The interface address can be provided by the business system or the big data platform. Whether effective: Identifies whether the configuration information of the report control is effective. If it is not effective, the report general scheduled task will be skipped directly; if it is effective, the report general scheduled task will perform related business logic processing. Creation time: The creation time of the report control configuration information. Last updated: The last updated time of the report control configuration information. Remarks: Additional supplementary information of the report control configuration information.

[0090] The report general scheduled task in the embodiment of the present disclosure will start scanning the information in the report control configuration information table one by one at 0:00 am, and determine whether to perform subsequent processing based on whether the configuration information is effective. For the report control configuration information to be processed, the report general scheduled task will evoke an asynchronous task to call the report generation interface, and use some configuration items (such as the report unique number, report cycle, etc.) as the input parameters of the interface to complete the calculation and storage of the report result data.

[0091] The generative large model intelligent question-answering system is introduced in the disclosed embodiment: the generative large model can be based on deep learning and natural language processing technology, and can be repeatedly trained and generated by inputting a large corpus in an end-to-end manner. The disclosed embodiment can introduce an intelligent question-answering system, which can help managers quickly complete report generation. Managers can click the intelligent question-answering system button icon on the homepage of the report generation interface to activate the question-answering system and realize human-computer interaction. The target report can be generated without going through the menu layers. Figure 6 As shown, Figure 6 It is a schematic diagram of the human-computer interaction interface of the intelligent question-and-answer system in the embodiment of the present disclosure. The manager can tell the intelligent question-and-answer system the target report information to be generated. After receiving the voice information, the intelligent question-and-answer system will perform voice recognition operations and display the recognized information on the screen to the manager, who will confirm whether the recognized information is correct. If correct, the intelligent question-and-answer system will trigger the report timing task of the big data platform and generate the target report; if incorrect, it will ask the manager whether to end the task or re-enter, and the subsequent operations will be decided by the manager.

[0092] In the disclosed embodiment, an intermediate result table (an optional example of a report result data information table) is introduced, which can store the report data calculation results (an optional example of report result data) generated by the asynchronous task triggered by the report general scheduled task based on the caching strategy. When the report result data is subsequently obtained, the index query can be directly used, which is efficient and does not affect the operation of the business system. It is a decoupling between system modules.

[0093] In the disclosed embodiment, in the scenario where the big data platform is required to obtain report result data, the business system can provide a data push service interface to convert the original data (an optional example of the original information table) into a data file specified by the big data platform (an optional example of the target data file), and push the target data file to the big data platform according to certain rules, so that the big data platform processes the original data and stores it in the data storage unit allocated by the big data platform to the business system, providing data support for the subsequent generation of report result data.

[0094] In the disclosed embodiment, on the business system side, for reports that do not require the big data platform capabilities (determined by the value of the field "whether the big data platform is required" in the report control configuration information table), the business system provides a corresponding interface for generating report result data. On the big data platform side: For reports that require the big data platform capabilities (determined by the value of the field "whether the big data platform is required" in the report control configuration information table), the big data platform provides a corresponding interface for generating report result data.

[0095] Figure 7A structural schematic diagram of a report generating device provided by an embodiment of the present disclosure.

[0096] like Figure 7 As shown, the report generating device 70 includes:

[0097] The acquisition module 701 is used to acquire target configuration information of the report generation method, wherein the target configuration information includes at least first information, and the first information is used to determine whether to use a big data platform in the process of generating report result data.

[0098] The first determination module 702 is used to determine the report generation method by referring to the target configuration information through the big data platform when the first information indicates that the big data platform is used in the process of generating report result data, and process the original information table using the report generation method through the big data platform to obtain the report result data.

[0099] The second determination module 703 is used to determine the report generation method through the application database reference target configuration information to which the original information table belongs, when the first information indicates that the big data platform is not used in the process of generating report result data, and process the original information table through the application database using the report generation method to obtain the report result data.

[0100] The storage module 704 is used to store the report result data into the report result data information table.

[0101] It should be noted that the above explanation of the report generating method is also applicable to the report generating device of this embodiment, and will not be repeated here.

[0102] In this embodiment, by obtaining the target configuration information of the report generation method, wherein the target configuration information includes at least the first information, the first information is used to determine whether to use the big data platform in the process of generating the report result data; when the first information indicates that the big data platform is used in the process of generating the report result data, the report generation method is determined by referring to the target configuration information through the big data platform, and the original information table is processed by the big data platform using the report generation method to obtain the report result data; and when the first information indicates that the big data platform is not used in the process of generating the report result data, the report generation method is determined by referring to the target configuration information through the application database to which the original information table belongs, and the original information table is processed by the application database using the report generation method to obtain the report result data; and the report result data is stored in the report result data information table. The intelligent degree of report result data generation is improved, and the overall performance of the business system is improved.

[0103] As an example, Figure 8 is a schematic diagram of the structure of an electronic device shown in an exemplary embodiment of the present disclosure, such as Figure 8 As shown, the electronic device 700 may further include:

[0104] The memory 710 and the processor 720 , and the bus 730 connecting different components (including the memory 710 and the processor 720 ), the memory 710 stores a computer program, and when the processor 720 executes the program, the report generation method of the embodiment of the present disclosure is implemented.

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

[0106] The electronic device 700 typically includes a variety of electronic device readable media. These media can be any available media that can be accessed by the electronic device 700, including volatile and non-volatile media, removable and non-removable media.

[0107] The memory 710 may also include computer system readable media in the form of volatile memory, such as random access memory (RAM) 740 and / or cache memory 750. The electronic device 700 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 760 may be used to read and write non-removable, non-volatile magnetic media ( Figure 8 not shown, usually called a "hard drive"). Although Figure 8 Not shown, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 730 via one or more data medium interfaces. The memory 710 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present disclosure.

[0108] A program / utility 780 having a set (at least one) of program modules 770 may be stored, for example, in the memory 710, such program modules 770 including but not limited to an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules 770 generally perform the functions and / or methods of the embodiments described in the present disclosure.

[0109] The electronic device 700 may also communicate with one or more external devices 790 (e.g., keyboard, pointing device, display 791, etc.), may also communicate with one or more devices that enable a user to interact with the electronic device 700, and / or communicate with any device that enables the electronic device 700 to communicate with one or more other computing devices (e.g., network card, modem, etc.). Such communication may be performed through an input / output (I / O) interface 792. Furthermore, the electronic device 700 may also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN) and / or public network, such as the Internet) through a network adapter 793. As shown, the network adapter 793 communicates with other modules of the electronic device 700 through a bus 730. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the electronic device 700, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0110] The processor 720 executes various functional applications and data processing by running the programs stored in the memory 710 .

[0111] It should be noted that the implementation process and technical principles of the electronic device of this embodiment refer to the aforementioned explanation of the report generation method of the embodiment of the present disclosure, which will not be repeated here.

[0112] In order to implement the above embodiments, the present disclosure also proposes an electronic device, including: a processor, and a memory communicatively connected to the processor; the memory stores computer-executable instructions; the processor executes the computer-executable instructions stored in the memory to implement the method provided by the above embodiments.

[0113] In order to implement the above embodiments, the present disclosure further proposes a computer-readable storage medium, in which computer-executable instructions are stored. When the computer-executable instructions are executed by a processor, they are used to implement the methods provided by the above embodiments.

[0114] In order to implement the above embodiments, the present disclosure also proposes a computer program product, including a computer program, which implements the methods provided by the above embodiments when executed by a processor.

[0115] The collection, storage, use, processing, transmission, provision and disclosure of user personal information involved in this disclosure shall comply with the relevant laws and regulations and shall not violate public order and good morals.

[0116] It should be noted that personal information from users should be collected for legitimate and reasonable purposes and should not be shared or sold outside of these legitimate uses. In addition, such collection / sharing should be carried out after receiving the user's informed consent, including but not limited to notifying the user to read the user agreement / user notice and sign the agreement / authorization including authorization of relevant user information before the user uses the function. In addition, any necessary steps should be taken to protect and safeguard access to such personal information data and ensure that others who have access to personal information data comply with its privacy policy and procedures.

[0117] The present disclosure anticipates providing implementation schemes for users to selectively block the use or access of personal information data. That is, the present disclosure anticipates providing hardware and / or software to prevent or block access to such personal information data. Once the personal information data is no longer needed, risks can be minimized by limiting data collection and deleting the data. In addition, when applicable, such personal information is de-identified to protect the privacy of the user.

[0118] In the description of the aforementioned embodiments, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present disclosure. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, unless they are contradictory.

[0119] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one of the features. In the description of the present disclosure, "plurality" means at least two, such as two, three, etc., unless otherwise clearly and specifically defined.

[0120] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, segment or portion of code that includes one or more executable instructions for implementing the steps of a custom logical function or process, and the scope of the preferred embodiments of the present disclosure includes additional implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present disclosure belong.

[0121] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as an ordered list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute the instructions), or in combination with these instruction execution systems, devices or apparatuses. For the purpose of this specification, "computer-readable medium" can be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in combination with these instruction execution systems, devices or apparatuses. More specific examples of computer-readable media (a non-exhaustive list) include the following: an electrical connection with one or more wires (electronic device), a portable computer disk box (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), a fiber optic device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium and then editing, interpreting or processing in other suitable ways if necessary, and then stored in a computer memory.

[0122] It should be understood that the various parts of the present disclosure can be implemented in hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, multiple steps or methods can be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one of the following technologies known in the art or a combination thereof can be used to implement: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0123] A person skilled in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.

[0124] In addition, each functional unit in each embodiment of the present disclosure may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it may also be stored in a computer-readable storage medium.

[0125] The storage medium mentioned above may be a read-only memory, a disk or an optical disk, etc. Although the embodiments of the present disclosure have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limitations of the present disclosure. A person of ordinary skill in the art may change, modify, replace and modify the above embodiments within the scope of the present disclosure.

Claims

1. A report generation method, characterized in that: The method comprises the following steps: Acquire target configuration information of a report generation method, wherein the target configuration information includes at least first information, and the first information is used to determine whether to use a big data platform in the process of generating report result data; In the case where the first information indicates that a big data platform is used in the process of generating report result data, the report generation method is determined by the big data platform with reference to the target configuration information, and the original information table is processed by the big data platform using the report generation method to obtain the report result data; In a case where the first information indicates that the big data platform is not used in the process of generating the report result data, determining the report generation method by referring to the target configuration information through the application database to which the original information table belongs, and processing the original information table by the application database using the report generation method to obtain the report result data; and The report result data is stored in the report result data information table.

2. The method according to claim 1, characterized in that The target configuration information of the report generation method is obtained, including: Acquire report requirement information, and determine target report information in the report requirement information; Based on the target report information, target configuration information of the report generation method is acquired.

3. The method according to claim 2, characterized in that The determining of the target report information in the report requirement information includes: Determining the semantic content of the report requirement information; From the semantic content, identifying sub-semantic content corresponding to each report field; generating a query statement based on the plurality of sub-semantic contents and the query description information; In response to receiving the target instruction information, the plurality of sub-semantic contents are used as the target report information, wherein the target instruction information is used to confirm the correctness of the query statement.

4. The method according to claim 2, characterized in that: The step of acquiring target configuration information of a report generation method based on the target report information includes: Acquire a report control configuration information table, wherein the report control configuration information table includes: a plurality of candidate report information and candidate configuration information corresponding to each candidate report information; Determine candidate report information matching the target report information from the plurality of candidate report information; The candidate configuration information corresponding to the matching candidate report information is used as the target configuration information of the report generation method.

5. The method according to claim 1, characterized in that The target configuration information of the report generation method is obtained, including: Determine to start a general report timing task, wherein the general report timing task is used to scan and obtain target configuration information of a report generation method, and the general report timing task has a corresponding timing time range, and the timing time range includes a first moment; In response to the current time reaching the first moment, target configuration information of the report generation method is obtained by scanning within the timing time range.

6. The method according to claim 1, characterized in that The target configuration information also includes at least one of the following: report number, report name, report type, report period, second information, wherein the second information is used to indicate whether the large model is enabled, report storage address, report generation interface address, and third information, wherein the third information is used to indicate whether the target configuration information is effective, the creation time of the target configuration information, and the update time of the target configuration information.

7. The method according to claim 1, characterized in that The method further comprises: In the case where the first information indicates that a big data platform is used in the process of generating report result data, calling a data push service interface to process the original information table into a target data file, and pushing the target data file to the big data platform; The step of processing the original information table by using the report generation method through the big data platform to obtain the report result data includes: The target data file is processed by the big data platform using the report generation method to obtain the report result data.

8. The method according to claim 7, characterized in that The process of processing the target data file by the big data platform using the report generation method to obtain the report result data includes: Parse and obtain processing index data and report original data from the target data file; The data computing capability of the big data platform is called upon to process the original report data using the report generation method and the processing index data to obtain the report result data.

9. The method according to any one of claims 1 to 8, characterized in that: The method further comprises: Receiving a query request, wherein the query request includes: a query data field; According to the query data field, query and obtain the report result data from the report result data information table; Generate and provide a target report based on the report result data information table.

10. A report generation device, characterized in that: The device comprises: An acquisition module, used for acquiring target configuration information of a report generation method, wherein the target configuration information includes at least first information, and the first information is used to determine whether to use a big data platform in the process of generating report result data; A first determination module is used to determine the report generation method by referring to the target configuration information through the big data platform when the first information indicates that a big data platform is used in the process of generating the report result data, and to process the original information table by using the report generation method through the big data platform to obtain the report result data; A second determination module is used to determine the report generation method by referring to the target configuration information through the application database to which the original information table belongs, and process the original information table by using the report generation method through the application database to obtain the report result data when the first information indicates that the big data platform is not used in the process of generating the report result data; and The storage module is used to store the report result data in the report result data information table.

11. An electronic device, characterized in that: include: A processor, and a memory communicatively connected to the processor; The memory stores computer-executable instructions; The processor executes the computer-executable instructions stored in the memory to implement the method according to any one of claims 1 to 9.

12. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, which are used to implement the method according to any one of claims 1 to 9 when executed by a processor.

13. A computer program product, characterized in that The invention comprises a computer program, which implements the method according to any one of claims 1 to 9 when being executed by a processor.