A report generation method and device
Patent Information
- Application Number
- CN202110635150.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-06-08
- Publication Date
- 2026-10-20
- Estimated Expiration
- 2041-06-08
AI Technical Summary
[0004]本发明提供一种报表生成方法及装置,用于解决现有技术中报表生成效率较低的问题
Smart Images

Figure CN113326683B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of financial technology (Fintech), and more particularly to a method and apparatus for generating reports. Background Technology
[0002] With the development of computer technology, more and more technologies are being applied in the financial field. The traditional financial industry is gradually transforming into financial technology. However, due to the security and real-time requirements of the financial industry, higher demands are being placed on technology.
[0003] Currently, in the financial industry, report generation typically involves querying an existing report database and generating the report based on the retrieved configuration information. However, when the report configuration information cannot be found in the database, secondary development is required to reconfigure the report template. Before testing and deployment, reports cannot be generated automatically and quickly, resulting in low report generation efficiency. Summary of the Invention
[0004] This invention provides a report generation method and apparatus to solve the problem of low report generation efficiency in the prior art.
[0005] In a first aspect, the present invention provides a report generation method, comprising: receiving report template request information for a target business; the report template request information including at least a report number; determining whether a report template corresponding to the target business exists based on the report number; if no report template corresponding to the target business exists, searching for data of the corresponding field in a preset database based on the field corresponding to the target business, and dynamically configuring a new report template based on the data of the corresponding field; determining whether a report generated based on the new report template meets preset conditions; wherein, the preset conditions are conditions for determining whether the report meets real-time feedback conditions; when it is determined that the report does not meet the preset conditions, asynchronously feeding back the report.
[0006] In the above method, when no report template corresponding to the target business exists (i.e., no corresponding report template is found based on the report number), the corresponding fields can be retrieved from a preset database based on the fields corresponding to the target business. A new report template can then be dynamically configured based on this data, thus achieving dynamic configuration of the report template. Furthermore, after determining the new report template, it can be determined whether the report generated based on it meets preset conditions. If the report does not meet the preset conditions, the report can be asynchronously reported, thus not impacting program performance. This approach reduces the impact on program performance while still enabling rapid report generation.
[0007] Optionally, the step of searching for data of the corresponding field in a preset database based on the field corresponding to the target business, and dynamically configuring a new report template based on the data of the corresponding field, includes: searching for data of the field corresponding to the target business in a report database; wherein the report database includes data corresponding to all fields included in the templates corresponding to each business; when it is determined that there is no data of the field corresponding to the target business in the report database, then querying for data of the field corresponding to the target business in a source database; wherein the source database is the database corresponding to the source of all fields included in the templates corresponding to each business; when it is determined that there is first data of the field corresponding to the target business in the source database, then determining a schema from the report database, and dynamically configuring a new report template based on the first data of the field corresponding to the target business and the schema.
[0008] The above method provides a solution for dynamically configuring new report templates. Based on the first data of the field corresponding to the target business found in the source database and the schema found in the report database, the new report template can be determined. This allows for the simple and quick generation of new report templates without multiple complex steps, thereby improving the efficiency of report generation.
[0009] Optionally, the method further includes: saving the association attribute relationship between the field corresponding to the target business in the source database and the field updated based on the first data in the report database to the report database; and saving the correspondence relationship between the field updated based on the first data and the new report template in the report database to the report database.
[0010] The above method provides a solution for saving the association attribute relationship between the fields corresponding to the target business in the source database and the fields updated based on the first data in the report database, as well as the correspondence relationship between the fields updated based on the first data and the new report template in the report database. This provides a good implementation foundation for subsequent field-based data lookup in the source database and the new report template.
[0011] Optionally, after retrieving data for the corresponding field from a preset database based on the field corresponding to the target business, and dynamically configuring a new report template based on the data for the corresponding field, the method further includes: determining a first confidentiality level in the report template request information; when it is determined that the first confidentiality level is less than the confidentiality level of the field corresponding to the target business, querying the basic unit configuration corresponding to the corresponding field, and performing de-identification processing on the first data based on the basic unit configuration; and determining the report generated based on the new report template based on the de-identified data.
[0012] The above method provides a specific scheme for generating reports based on a new report template. This involves comparing the first confidentiality level in the report template request information with the confidentiality level of the field corresponding to the target business. When it is determined that the first confidentiality level in the report template request information is less than the confidentiality level of the field corresponding to the target business, the first data is desensitized based on the basic unit configuration. As a result, the report generated based on the new report template can be a report with partially encrypted data, thus ensuring the security of the data in the report.
[0013] Optionally, the basic unit is configured to be pre-stored in the report database, or determined by differentiating the data in the new report template based on preset differentiation conditions; wherein, the preset differentiation conditions are used to associate and divide the data based on the data source range and / or data source attributes.
[0014] The above method provides a way to determine the basic unit configuration, that is, the configuration obtained after the data association and division can provide the basic encrypted fields for the first data to be de-identified, thus providing a good implementation basis for the generation of reports.
[0015] Optionally, determining whether the report generated based on the new report template meets the preset conditions includes: determining the percentage of memory occupied by the report generated by the new report template, the total time for querying the report, the amount of data corresponding to the report, and the number of reports corresponding to the target business; when it is determined that any one of the parameters of the percentage of memory occupied by the report, the total time, the amount of data, and the number of reports is not less than the corresponding threshold, it is determined that the preset conditions are not met.
[0016] The above method provides specific ways to handle reports generated based on new report templates that do not meet preset conditions. For example, based on the comparison result that the percentage of memory occupied by the report is greater than its corresponding threshold, it can be determined that the generated report is too large and cannot be fed back in real time, so it can be determined that the preset conditions are not met and the report is fed back asynchronously. As another example, based on the comparison result that the total query time of the report is greater than its corresponding preset threshold, i.e., the preset time, it can be determined that the query time is too long, i.e. the report cannot be fed back in real time, so it can be determined that the preset conditions are not met.
[0017] Secondly, the present invention provides a report generation apparatus, comprising: a receiving unit, configured to receive report template request information for a target business; the report template request information includes at least a report number; a configuration unit, configured to determine whether a report template corresponding to the target business exists based on the report number, and if no report template corresponding to the target business exists, to search for data of the corresponding field in a preset database based on the field corresponding to the target business, and to dynamically configure a new report template based on the data of the corresponding field; a determining unit, configured to determine whether a report generated based on the new report template meets preset conditions; wherein the preset conditions are conditions for determining whether the report meets the conditions for real-time feedback; and a feedback unit, configured to asynchronously feed back the report when it is determined that the report does not meet the preset conditions.
[0018] Optionally, the configuration unit is specifically used for: retrieving data for fields corresponding to the target business from the report database; wherein the report database includes data corresponding to all fields included in the templates corresponding to each business; when it is determined that there is no data for fields corresponding to the target business in the report database, then querying data for fields corresponding to the target business from the source database; wherein the source database is the database corresponding to the source of all fields included in the templates corresponding to each business; when it is determined that there is first data for fields corresponding to the target business in the source database, then determining a schema from the report database, and dynamically configuring based on the first data for fields corresponding to the target business and the schema to determine a new report template.
[0019] Optionally, the device further includes a caching unit, configured to: save the association attribute relationship between the field corresponding to the target business in the source database and the field updated based on the first data in the report database to the report database; and save the correspondence relationship between the field updated based on the first data and the new report template in the report database to the report database.
[0020] Optionally, the device further includes a processing unit, configured to: determine a first confidentiality level in the report template request information; when the first confidentiality level is determined to be less than the confidentiality level of the field corresponding to the target business, query the basic unit configuration corresponding to the corresponding field, and perform de-identification processing on the first data based on the basic unit configuration; and determine the report generated based on the new report template based on the de-identified data.
[0021] Optionally, the basic unit is configured to be pre-stored in the report database, or determined by differentiating the data in the new report template based on preset differentiation conditions; wherein, the preset differentiation conditions are used to associate and divide the data based on the data source range and / or data source attributes.
[0022] Optionally, the determining unit is specifically used to: determine the percentage of memory occupied by the report generated by the new report template, the total time for querying the report, the amount of data corresponding to the report, and the number of reports corresponding to the target business; when it is determined that any one of the parameters of the percentage of memory occupied by the report, the total time, the amount of data, and the number of reports is not less than the corresponding threshold, it is determined that the preset condition is not met.
[0023] The beneficial effects of the second aspect and the various optional devices described above can be referred to the beneficial effects of the first aspect and the various optional methods described above, and will not be repeated here.
[0024] Thirdly, the present invention provides a computer device including a program or instructions, which, when executed, are used to perform the first aspect and the various optional methods of the first aspect.
[0025] Fourthly, the present invention provides a storage medium including a program or instructions, which, when executed, perform the first aspect and the various optional methods of the first aspect. Attached Figure Description
[0026] To more clearly illustrate the technical solutions in the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below.
[0027] Figure 1 A schematic diagram illustrating the report generation method provided in an embodiment of the present invention;
[0028] Figure 2 This is a flowchart illustrating the steps of a report generation method provided in an embodiment of the present invention;
[0029] Figure 3 This is a schematic diagram of a report generation device provided in an embodiment of the present invention. Detailed Implementation
[0030] To better understand the above technical solutions, the following will describe the above technical solutions in detail with reference to the accompanying drawings and specific embodiments. It should be understood that the embodiments of the present invention and the specific features in the embodiments are detailed descriptions of the technical solutions of the present invention, rather than limitations on the technical solutions of the present invention. In the absence of conflict, the embodiments of the present invention and the technical features in the embodiments can be combined with each other.
[0031] It should be noted that the terms "first," "second," etc., used in the specification and claims of this invention are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such use of images can be interchanged where appropriate so that the embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this invention. Rather, they are merely examples of apparatuses and methods consistent with some aspects of the invention as detailed in the appended claims.
[0032] To facilitate understanding of the technical solutions provided in the embodiments of the present invention, some key terms used in the embodiments of the present invention will be explained here first:
[0033] 1. Desensitization: This refers to transforming certain sensitive information through desensitization rules to achieve reliable protection of sensitive privacy data.
[0034] 2. Schema: In a database, it represents a collection of database objects, including various objects such as tables, views, stored procedures, and indexes.
[0035] The design concept of the embodiments of the present invention is briefly introduced below:
[0036] Currently, when the data rules of a report are adjusted but no matching report template is found, secondary development is required, and the report must be tested before going live. This makes the entire process of generating a report template complex and cumbersome, resulting in low report generation efficiency and high costs.
[0037] In view of this, the present invention provides a report generation method, which can quickly obtain a new template corresponding to the report and obtain the corresponding report based on the new template, that is, it can quickly generate reports and improve the efficiency of report generation.
[0038] After introducing the design concept of the embodiments of the present invention, the following is a brief introduction to the application scenarios applicable to the report generation technology solutions in the embodiments of the present invention. It should be noted that the application scenarios described in the embodiments of the present invention are for the purpose of more clearly illustrating the technical solutions of the embodiments of the present invention, and do not constitute a limitation on the technical solutions provided by the embodiments of the present invention. As those skilled in the art will know, with the emergence of new application scenarios, the technical solutions provided by the embodiments of the present invention are also applicable to similar technical problems.
[0039] In the embodiments of the present invention, please refer to Figure 1The illustrated application scenario includes an electronic device 101, a processing server 102, a server 103 corresponding to the source database, and a server 104 corresponding to the report database. The electronic device 101 can communicate with the processing server 102, and the processing server 102, server 103, and server 104 can also communicate with each other. For example, they can be directly or indirectly connected via wired or wireless communication methods; this invention is not limited to these methods.
[0040] In this scenario, a user can trigger a request to obtain a report template for a target business based on electronic device 101. Processing server 102 can obtain the report number based on the request. Further, processing server 102 will send a query request to server 103 based on the report number. When server 103 reports that no report template corresponding to the target business is found, processing server 102 can search for the corresponding field data from server 103 and / or server 104 based on the field corresponding to the target business, and dynamically configure a new report template based on the corresponding field data. Then, it determines whether the report generated based on the new report template meets the preset conditions. When it is determined that the report does not meet the preset conditions, the report is asynchronously fed back.
[0041] Among them, processing servers 102, 103, and 104 can be independent physical servers, server clusters or distributed systems composed of multiple physical servers, or cloud servers providing basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDN (Content Delivery Network), and big data and artificial intelligence platforms. Electronic device 101 can be a smartphone, tablet, laptop, desktop computer, smart TV, smart wearable device, or a server, but is not limited to these.
[0042] To further illustrate the report generation method provided in the embodiments of the present invention, a detailed description is provided below in conjunction with the accompanying drawings and specific implementation methods. Although the embodiments of the present invention provide method operation steps as shown in the following embodiments or drawings, more or fewer operation steps may be included in the method based on conventional or non-inventive methods. In steps where there is no logically necessary causal relationship, the execution order of these steps is not limited to the execution order provided in the embodiments of the present invention. In actual processing or when the device executes the method, it may be executed in the order shown in the embodiments or drawings, or in parallel (e.g., in an application environment with parallel processors or multi-threaded processing).
[0043] The following combination Figure 2The flowchart shown illustrates the report generation method in this embodiment of the invention. The method flow of this embodiment of the invention is described below.
[0044] Step 201: Receive report template request information for the target business; the report template request information shall include at least the report number.
[0045] Step 202: Determine whether a report template corresponding to the target business exists based on the report number. If no report template corresponding to the target business exists, search for the data of the corresponding field in the preset database based on the field corresponding to the target business, and dynamically configure a new report template based on the data of the corresponding field.
[0046] In this embodiment of the invention, a user can determine the report to be generated based on actual processing needs and trigger a report template request for the target business through an electronic device. For example, if a user determines that a report needs to be generated for business A, they can trigger a report template request for business A through an electronic device.
[0047] In this embodiment of the invention, the processing server can determine whether a report template corresponding to the target business exists based on the report number. Specifically, the processing server can send the report number to the server corresponding to the report database, so that the server corresponding to the report database can search for the report template corresponding to the target business in the report database based on the report number. When the server corresponding to the report database does not find a report template corresponding to the target business, that is, the report database does not store a report template corresponding to the target business, it reports back to the processing server that no report template corresponding to the report number, i.e., the target business, has been found. Thus, the processing server can determine the field corresponding to the target business, search for the data of the corresponding field in the preset database, and dynamically configure a new report template based on the data of the corresponding field.
[0048] In this embodiment of the invention, new report templates can be dynamically configured using, but not limited to, the following steps:
[0049] Step 1: Locate the data for the fields corresponding to the target business from the report database; the report database includes the data for all fields included in the templates for each business.
[0050] Step 2: When it is determined that the data for the field corresponding to the target business does not exist in the report database, the data for the field corresponding to the target business is queried from the source database; where the source database is the database from which the data for all fields included in the template corresponding to each business originates.
[0051] Step 3: Once it is determined that the source database contains the first data of the field corresponding to the target business, the schema is determined from the report database. Based on the first data of the field corresponding to the target business and the schema, a new report template is dynamically configured.
[0052] After Step 3, the association relationships between the fields corresponding to the target business in the source database and the fields updated based on the first data in the report database can be saved to the report database; and the correspondence between the fields updated based on the first data in the report database and the new report template can also be saved to the report database. Furthermore, the meanings of the fields updated based on the first data in the report database can be displayed on the front-end page, allowing users to perform subsequent selection, deletion, and other processing on the data in the report.
[0053] For example, the file corresponding to the rendering effect of the new report template can be determined and saved to the report database so that it can be quickly rendered when generating reports based on the new report template. In addition, the corresponding rendering effect can be presented to the user on an electronic device for the user to preview or select from the database of rendering effects, and the file corresponding to the determined target rendering effect can be bound to the new report template and saved to the report database.
[0054] Step 203: Determine whether the report generated based on the new report template meets the preset conditions; wherein, the preset conditions are the conditions for judging whether the report meets the real-time feedback conditions.
[0055] Before step 203, the first confidentiality level in the report template request information can also be determined, that is, the confidentiality level of the target business corresponding to the report template request is determined. When it is determined that the first confidentiality level is less than the confidentiality level of the field corresponding to the target business, the basic unit configuration corresponding to the corresponding field is queried, and the first data is de-identified based on the basic unit configuration. Based on the de-identified data, the report generated based on the new report template is determined.
[0056] For example, the confidentiality level of a field can be divided into five levels: Public, Internal, Secret, Confidential, and Top Secret, with the confidentiality levels increasing sequentially. The confidentiality level of the target business corresponding to the report mode request is the same as that of the field. When the first confidentiality level in the report mode request information is lower than the confidentiality level of the field corresponding to the target business, it can be determined that the first data, i.e., the data of the field corresponding to the target business, will undergo anonymization processing.
[0057] For example, before anonymizing the first data, the basic unit configuration corresponding to the corresponding field can be queried. This basic unit configuration is either pre-stored in the report database or determined by differentiating data in a new report template based on preset differentiation conditions. These preset differentiation conditions are used to associate and divide data based on data source range and / or data source attributes. Therefore, the basic unit configuration can be updated based on updates to the data in the report database; that is, the basic unit configuration is updatable. Once the basic unit configuration corresponding to the corresponding field is determined, the first data can be anonymized based on this configuration.
[0058] For example, before de-identifying the first data based on the basic unit configuration, de-identification rules can be queried. For example, de-identification rules may include, but are not limited to, the following:
[0059] (1) Encrypt the entire field data, for example, return all fixed data as "******".
[0060] (2) Encrypt the entire field data, for example, return the same number of * based on the actual length of the original data.
[0061] (3) Display a certain number of digits of data and encrypt the rest of the data. For example, return the first 4 digits of the ID number + ***** + the last 4 digits.
[0062] (4) Encrypt data of a certain number of digits. For example, encrypt only the middle 4 digits of a mobile phone number as *.
[0063] After determining the de-identification rules, the de-identification rules to be adopted can be determined based on the confidentiality level of the fields corresponding to the target business. For example, if the confidentiality level of the fields corresponding to the target business is confidential, the de-identification rule to be adopted can be determined to encrypt a certain number of bits of data. In this case, a certain number of bits of data in the first data, excluding the basic unit configuration, can be encrypted to obtain the de-identified data.
[0064] In this embodiment of the invention, after obtaining the de-identified data, the report generated based on the new report template can be determined based on the de-identified data, combined with the new report template and the corresponding rendering effect file.
[0065] In this embodiment of the invention, after determining the report generated based on the new report template, in step 203, the percentage of memory occupied by the report generated by the new report template, the total time for querying the report, the amount of data corresponding to the report, and the number of reports corresponding to the target business can be determined. If any one of the parameters—the percentage of memory occupied by the report, the total time, the amount of data, and the number of reports—is not less than the corresponding threshold, then it is determined that the preset condition is not met. It should be noted that in actual implementation, the percentage of memory occupied by the report, the total time, the amount of data, and the number of reports queried simultaneously being not less than the corresponding threshold can be determined based on the actual implementation situation, and this embodiment of the invention does not impose any limitations.
[0066] For example, if it is determined that the report generated by the new report template occupies 60% of the memory and the threshold corresponding to the percentage of memory occupied by the report is 50%, then it can be determined that the preset conditions are not met.
[0067] For example, if the total duration of the query report is determined to be 2 minutes, and the total duration corresponding to the total duration of the query report is 1 minute, then it can be determined that the preset conditions are not met.
[0068] For example, if the number of reports corresponding to the target business is greater than or equal to the preset number, such as the preset number of 2 and the number of reports corresponding to the target business is 3, and there are duplicate basic configuration units among them, then it can be determined that the preset conditions are not met.
[0069] For example, if the data volume corresponding to the report is greater than the preset data volume, such as 100M, while the data volume corresponding to the report is 200M, then it can be determined that the preset condition is not met.
[0070] Step 204: When it is determined that the report does not meet the preset conditions, the report will be fed back asynchronously.
[0071] In step 204, when it is determined that the preset conditions are not met, a waiting message can be returned to the electronic device, and the report can be asynchronously pushed to the business system deployed on the electronic device after the report is generated. Specifically, the waiting information can be a text prompt indicating how many minutes to wait, or a dual prompt method of text prompt plus voice prompt; no limitation is made in this embodiment of the invention.
[0072] like Figure 3As shown, the present invention provides a report generation device, comprising: a receiving unit 301, configured to receive report template request information for a target business; the report template request information includes at least a report number; a configuration unit 302, configured to determine whether a report template corresponding to the target business exists based on the report number, and if no report template corresponding to the target business exists, to search for data of the corresponding field in a preset database based on the field corresponding to the target business, and to dynamically configure a new report template based on the data of the corresponding field; a determining unit 303, configured to determine whether a report generated based on the new report template meets preset conditions; wherein the preset conditions are conditions for determining whether the report meets the conditions for real-time feedback; and a feedback unit 304, configured to asynchronously feed back the report when it is determined that the report does not meet the preset conditions.
[0073] Optionally, the configuration unit 302 is specifically configured to: search for data corresponding to the field of the target business from the report database; wherein the report database includes data corresponding to all fields included in the templates corresponding to each business; when it is determined that there is no data corresponding to the field of the target business in the report database, then query the data corresponding to the field of the target business from the source database; wherein the source database is the database corresponding to the source of all fields included in the templates corresponding to each business; when it is determined that there is first data corresponding to the field of the target business in the source database, then determine the schema from the report database, and dynamically configure and determine a new report template based on the first data corresponding to the field of the target business and the schema.
[0074] Optionally, the device further includes a caching unit, configured to: save the association attribute relationship between the field corresponding to the target business in the source database and the field updated based on the first data in the report database to the report database; and save the correspondence relationship between the field updated based on the first data and the new report template in the report database to the report database.
[0075] Optionally, the device further includes a processing unit, configured to: determine a first confidentiality level in the report template request information; when the first confidentiality level is determined to be less than the confidentiality level of the field corresponding to the target business, query the basic unit configuration corresponding to the corresponding field, and perform de-identification processing on the first data based on the basic unit configuration; and determine the report generated based on the new report template based on the de-identified data.
[0076] Optionally, the basic unit is configured to be pre-stored in the report database, or determined by differentiating the data in the new report template based on preset differentiation conditions; wherein, the preset differentiation conditions are used to associate and divide the data based on the data source range and / or data source attributes.
[0077] Optionally, the determining unit 303 is specifically used to: determine the percentage of memory occupied by the report generated by the new report template, the total time for querying the report, the amount of data corresponding to the report, and the number of reports corresponding to the target business; when it is determined that any one of the parameters of the percentage of memory occupied by the report, the total time, the amount of data, and the number of reports is not less than the corresponding threshold, it is determined that the preset condition is not met.
[0078] This invention provides a computer device, including a program or instructions, which, when executed, are used to perform a report generation method and any optional method provided in this invention.
[0079] This invention provides a storage medium including a program or instructions, which, when executed, are used to perform a report generation method and any optional method provided in this invention.
[0080] Finally, it should be noted that those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, optical storage, etc.) containing computer-usable program code.
[0081] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing device to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing device, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.
[0082] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.
[0083] Obviously, those skilled in the art can make various modifications and variations to this invention without departing from its scope. Therefore, if these modifications and variations fall within the scope of the claims of this invention and their equivalents, this invention also intends to include these modifications and variations.
Claims
1. A report generation method, characterized in that, include: Receive report template request information for the target business; The report template request information shall include at least the report number; Based on the report number, determine whether a report template corresponding to the target business exists. If no report template corresponding to the target business exists, search for the data of the corresponding field in the preset database based on the field corresponding to the target business, and dynamically configure a new report template based on the data of the corresponding field. Determine whether the report generated based on the new report template meets preset conditions; wherein, the preset conditions are the conditions for determining whether the report meets the requirements for real-time feedback; When it is determined that the report does not meet the preset conditions, the report will be fed back asynchronously; The step of retrieving data for the corresponding field from a preset database based on the field corresponding to the target business, and dynamically configuring a new report template based on the data for the corresponding field, includes: From the report database, retrieve the data for the field corresponding to the target business; wherein, the report database includes the data for all fields included in the templates corresponding to each business. When it is determined that there is no data in the report database corresponding to the field of the target business, the data corresponding to the field of the target business is queried from the source database; wherein, the source database is the database corresponding to the source of all the data of the fields included in the template of each business; When it is determined that the source database contains first data for a field corresponding to the target business, the schema is determined from the report database, and the new report template is determined by dynamic configuration based on the first data for the field corresponding to the target business and the schema. After retrieving data for the corresponding field from a preset database based on the field corresponding to the target business, and dynamically configuring a new report template based on the data for the corresponding field, the method further includes: Determine the first confidentiality level in the report template request information; When it is determined that the first confidentiality level is lower than the confidentiality level of the field corresponding to the target business, the basic unit configuration corresponding to the corresponding field is queried, and the first data is de-identified based on the basic unit configuration; Based on the anonymized data, determine the report generated based on the new report template; The basic unit is configured to be pre-stored in the report database, or determined by differentiating the data in the new report template based on preset differentiation conditions; wherein, the preset differentiation conditions are used to associate and divide the data based on the data source range and / or data source attributes.
2. The method as described in claim 1, characterized in that, The method further includes: The association attribute relationship between the fields corresponding to the target business in the source database and the fields updated based on the first data in the report database is saved to the report database; and, The correspondence between the fields updated based on the first data and the new report template in the report database is saved to the report database.
3. The method as described in claim 1, characterized in that, Determining whether the report generated based on the new report template meets preset conditions includes: Determine the percentage of memory occupied by the reports generated by the new report template, the total time for querying the reports, the amount of data corresponding to the reports, and the number of reports corresponding to the target business. If any one of the following parameters—the percentage of memory occupied by the report, the total duration, the amount of data, and the number of reports—is not less than the corresponding threshold, then the preset condition is determined not to be met.
4. A report generation device, characterized in that, include: The receiving unit is used to receive report template request information for the target business. The report template request information shall include at least the report number; The configuration unit is used to determine whether a report template corresponding to the target business exists based on the report number. If no report template corresponding to the target business exists, the unit searches for the data of the corresponding field in the preset database based on the field corresponding to the target business, and dynamically configures a new report template based on the data of the corresponding field. A determining unit is used to determine whether the report generated based on the new report template meets preset conditions; wherein, the preset conditions are conditions for determining whether the report meets the requirements for real-time feedback; A feedback unit is used to asynchronously feed back the report when it is determined that the report does not meet the preset conditions; The configuration unit is specifically used for: retrieving data from the report database corresponding to the field of the target business; wherein the report database includes data corresponding to all fields included in the templates corresponding to each business; when it is determined that there is no data corresponding to the field of the target business in the report database, then querying data corresponding to the field of the target business from the source database; wherein the source database is the database corresponding to the source of all fields included in the templates corresponding to each business; when it is determined that there is first data corresponding to the field of the target business in the source database, then determining the schema from the report database, and dynamically configuring based on the first data corresponding to the field of the target business and the schema to determine the new report template; The processing unit is configured to determine a first confidentiality level in the report template request information; when it is determined that the first confidentiality level is less than the confidentiality level of the field corresponding to the target business, it queries the basic unit configuration corresponding to the corresponding field and performs de-identification processing on the first data based on the basic unit configuration; and based on the de-identified data, it determines the report generated based on the new report template. The basic unit is configured to be pre-stored in the report database, or determined by differentiating the data in the new report template based on preset differentiation conditions; wherein, the preset differentiation conditions are used to associate and divide the data based on the data source range and / or data source attributes.
5. A computer device, characterized in that, Includes a program or instruction, which, when executed, performs the method as described in any one of claims 1 to 3.
6. A storage medium, characterized in that, Includes a program or instruction, which, when executed, performs the method as described in any one of claims 1 to 3.
Citation Information
Patent Citations
Dynamic allocation report data processing method based on two-dimension relationship
CN104657384A
Report generation method and device, computer device, and storage medium
CN109271411A
Report generation method and device, computer device and computer readable storage medium
CN110222321A