[go: up one dir, main page]

CN111177231B - Report generation method and report generation device - Google Patents

Report generation method and report generation device Download PDF

Info

Publication number
CN111177231B
CN111177231B CN201911326564.3A CN201911326564A CN111177231B CN 111177231 B CN111177231 B CN 111177231B CN 201911326564 A CN201911326564 A CN 201911326564A CN 111177231 B CN111177231 B CN 111177231B
Authority
CN
China
Prior art keywords
report
information
parameter
statement
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201911326564.3A
Other languages
Chinese (zh)
Other versions
CN111177231A (en
Inventor
林继承
林莉萍
石阳
马骏
霍延
周鸿�
曾添华
魏珊珊
陈映雪
王健勇
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Construction Bank Corp
Original Assignee
China Construction Bank Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Construction Bank Corp filed Critical China Construction Bank Corp
Priority to CN201911326564.3A priority Critical patent/CN111177231B/en
Publication of CN111177231A publication Critical patent/CN111177231A/en
Application granted granted Critical
Publication of CN111177231B publication Critical patent/CN111177231B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/248—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a report generation method and a report generation device, and relates to the technical field of computers. One embodiment of the method comprises the following steps: receiving a report generation request, and acquiring target identification information corresponding to a report to be generated according to the report generation request; acquiring target parameter information corresponding to a report to be generated according to target identification information based on a pre-configured configuration information table; and according to the target parameter information and the configuration information table, splicing to generate a target structured query statement, and executing the target structured query statement to generate a report to be generated. According to the embodiment, the method for flexibly configuring the visualization can be provided in the generation process of the report, and different report data can be automatically generated according to the configured business logic, so that the separation of the report development business logic and the display form is completed, the report generation efficiency is improved, the report generation time is shortened, the repeated development of similar functions is avoided, the universality of the report is realized, and the development cost is saved.

Description

Report generation method and report generation device
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a report generating method and a report generating device.
Background
The report forms are important components of the information management system, and especially for the overseas institutions of commercial banks, the report forms are required to be provided with internal reports for analysis, evaluation and prediction and administrative report forms meeting the requirements of the overseas and overseas administrative systems and regulations. Because of various reports, frequent changes and high timeliness, the reports need to be timely and accurately generated. In the development process of the data application system, a report engine is generated, which can define the format of a report and the algorithm of the report on the basis of original data, automatically execute calculation according to the defined algorithm, output the calculated result and display the content of the report according to the defined report format.
For the banking industry, there are multiple report rule engines available for use, including business and open source selection. However, most of the rules are engines for designing report presentation, and most of the required changes are changes of business logic processing, so that under the condition of the prior art, flexible configuration of a data calculation method cannot be realized, a large amount of repeated work can be caused, and the method has the disadvantages of poor expandability, poor maintainability and high development cost.
Disclosure of Invention
In view of the above, the embodiment of the invention provides a report generating method and a report generating device, which can provide a method for visual flexible configuration, automatically generate different report data according to configured business logic, improve report generating efficiency, shorten report generating time, avoid repeated development of similar functions, realize universality of the report, and save development cost.
In order to achieve the above object, according to a first aspect of an embodiment of the present invention, a report generating method is provided.
The report generation method of the embodiment of the invention comprises the following steps: receiving a report generation request, and acquiring target identification information corresponding to a report to be generated according to the report generation request; acquiring target parameter information corresponding to the report to be generated according to the target identification information based on a pre-configured configuration information table; and according to the target parameter information and the configuration information table, splicing to generate a target structured query statement, executing the target structured query statement, and generating the report to be generated.
Optionally, the obtaining, based on a pre-configured configuration information table, the target parameter information corresponding to the report to be generated according to the target identification information includes: reading a report parameter table in the configuration information table by using the target identification information to obtain target parameter information corresponding to the report to be generated; wherein the target parameter information includes: data type information and conditional filtering information.
Optionally, the generating, by splicing, the target structured query statement according to the target parameter information and the configuration information table includes: reading a data type/parameter comparison table in the configuration information table to obtain data type parameters according to the data type information, and then reading an engine output field configuration table in the configuration information table to generate a select statement; reading a data comparison table in the configuration information table according to the data type information, searching a target data table corresponding to the report to be generated, and generating a from statement; generating a sphere statement according to the data type information and the condition filtering information; reading the data type/parameter comparison table according to the data type information to obtain data type parameters and generating a group by statement; and performing splicing processing on the select statement, the from statement, the where statement and the group by statement to generate the target structured query statement.
Optionally, the generating a where statement according to the data type information and the condition filtering information includes: reading a data type/parameter comparison table in the configuration information table according to the data type information to obtain data type parameters and generating data attribute filtering conditions; reading a data type/pointer comparison table in the configuration information table according to the data type information and pointer condition information in the condition filtering information, and generating pointer filtering conditions; reading an engine global parameter table and an engine personality parameter table in the configuration information table according to the data type information and the time condition information in the condition filtering information, and generating a time filtering condition; and performing splicing processing on the data attribute filtering condition, the pointer filtering condition and the time filtering condition to generate the where statement.
Optionally, the executing the target structured query statement generates the report to be generated, including: executing the target structured query statement, generating report data, and generating the report to be generated according to the generated report data and an engine output table in the configuration information table.
Optionally, after executing the target structured query statement and generating the report to be generated, the method further includes: judging whether the report to be generated needs to be processed or not by using a report subparameter table in the configuration information table; if yes, updating the report to be generated by using the report subparameter table, and acquiring the updated report to be generated.
Optionally, before acquiring the target parameter information corresponding to the report to be generated according to the target identification information based on a pre-configured configuration information table, the method further includes: the configuration information table is preconfigured.
Optionally, the method further comprises: and changing the pre-configured configuration information table according to a configuration information table changing requirement, and executing the changed configuration information table according to the execution time corresponding to the changing requirement.
Optionally, the method further comprises: and initializing by using the engine global parameter table and the engine personality parameter table in the configuration information table.
In order to achieve the above object, according to a second aspect of the embodiments of the present invention, there is provided a report generating apparatus.
The report generating device of the embodiment of the invention comprises the following components: the receiving module is used for receiving a report generation request and acquiring target identification information corresponding to a report to be generated according to the report generation request; the acquisition module is used for acquiring the target parameter information corresponding to the report to be generated according to the target identification information based on a pre-configured configuration information table; and the generation module is used for splicing and generating a target structured query statement according to the target parameter information and the configuration information table, executing the target structured query statement and generating the report to be generated.
Optionally, the acquiring module is further configured to: reading a report parameter table in the configuration information table by using the target identification information to obtain target parameter information corresponding to the report to be generated; wherein the target parameter information includes: data type information and conditional filtering information.
Optionally, the generating module is further configured to: reading a data type/parameter comparison table in the configuration information table to obtain data type parameters according to the data type information, and then reading an engine output field configuration table in the configuration information table to generate a select statement; reading a data comparison table in the configuration information table according to the data type information, searching a target data table corresponding to the report to be generated, and generating a from statement; generating a sphere statement according to the data type information and the condition filtering information; reading the data type/parameter comparison table according to the data type information to obtain data type parameters and generating a group by statement; and performing splicing processing on the select statement, the from statement, the where statement and the group by statement to generate the target structured query statement.
Optionally, the generating module is further configured to: reading a data type/parameter comparison table in the configuration information table according to the data type information to obtain data type parameters and generating data attribute filtering conditions; reading a data type/pointer comparison table in the configuration information table according to the data type information and pointer condition information in the condition filtering information, and generating pointer filtering conditions; reading an engine global parameter table and an engine personality parameter table in the configuration information table according to the data type information and the time condition information in the condition filtering information, and generating a time filtering condition; and performing splicing processing on the data attribute filtering condition, the pointer filtering condition and the time filtering condition to generate the where statement.
Optionally, the generating module is further configured to: executing the target structured query statement, generating report data, and generating the report to be generated according to the generated report data and an engine output table in the configuration information table.
Optionally, the generating module is further configured to: judging whether the report to be generated needs to be processed or not by using a report subparameter table in the configuration information table; if yes, updating the report to be generated by using the report subparameter table, and acquiring the updated report to be generated.
Optionally, the apparatus further comprises: and the configuration module is used for pre-configuring the configuration information table.
Optionally, the configuration module is further configured to: and changing the pre-configured configuration information table according to a configuration information table changing requirement, and executing the changed configuration information table according to the execution time corresponding to the changing requirement.
Optionally, the apparatus further comprises: and the initialization module is used for carrying out initialization processing by utilizing the engine global parameter table and the engine personality parameter table in the configuration information table.
To achieve the above object, according to a third aspect of the embodiments of the present invention, there is provided an electronic apparatus.
An electronic device of an embodiment of the present invention includes: one or more processors; and the storage device is used for storing one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors are enabled to realize the report generation method of the embodiment of the invention.
To achieve the above object, according to a fourth aspect of the embodiments of the present invention, there is provided a computer-readable medium.
The computer readable medium of the embodiment of the invention stores a computer program, and the program is executed by a processor to realize the report generating method of the embodiment of the invention.
One embodiment of the above invention has the following advantages or benefits: after target identification information corresponding to the report to be generated is obtained according to the report generation request, the target parameter information corresponding to the report to be generated can be obtained by combining with a pre-configured configuration information table, then the corresponding information can be queried from the configuration information table, the target structural query statement is spliced and generated, and finally the target structural query statement is executed to generate the report to be generated, so that a method for flexibly configuring visualization can be provided in the generation process of the report, different report data can be automatically generated according to configured business logic, the separation of the business logic and the display form of the report is completed, the report generation efficiency is improved, the report generation time is shortened, the repeated development of similar functions is avoided, the universality of the report is realized, and the development cost is saved.
Further effects of the above-described non-conventional alternatives are described below in connection with the embodiments.
Drawings
The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:
FIG. 1 is a schematic diagram of the main flow of a report generating method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a configuration of a report parameter table according to an embodiment of the present invention;
FIG. 3 is a diagram of overall flow of report engine data according to an embodiment of the invention;
FIG. 4 is a schematic workflow diagram of a reporting engine according to an embodiment of the invention;
FIG. 5 is a schematic diagram of the main modules of a report generating apparatus according to an embodiment of the invention;
FIG. 6 is an exemplary system architecture diagram in which embodiments of the present invention may be applied;
fig. 7 is a schematic diagram of a computer system suitable for use in implementing an embodiment of the invention.
Detailed Description
Exemplary embodiments of the present invention will now be described with reference to the accompanying drawings, in which various details of the embodiments of the present invention are included to facilitate understanding, and are to be considered merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
The report forms belong to important components in the information management system, and particularly for the overseas institutions of commercial banks, the report forms are required to be provided with internal report forms for analysis, evaluation and prediction and supervision report forms meeting the requirements of overseas and overseas supervision systems and regulations. The financial institutions are required to be capable of timely and accurately generating the report forms in consideration of the fact that the report forms are various in variety, frequent in change and high in timeliness. In a traditional report system development mode, a developer directly writes codes according to actual service demands to realize analysis, processing and display functions of data, and the implementation mode causes a great deal of repeated work, for example, a data user needs to analyze the development trend of different product services from different perspectives, and similar functions need to be repeatedly developed, so that the report system has poor expandability, poor maintainability and high development cost.
Because complex business index rules are changed most often in the development process of the data application system, and the rules are required to conform to the change of the market, a report engine is generated, the report engine can define the format of a report and the algorithm of the report on the basis of original data, automatically execute calculation according to the defined algorithm, output the calculated result, and display the content of the report according to the defined report format. By utilizing a flexible report engine, business decisions can be well separated from an application program framework, then a predefined processing module and a defined grammar specification are used for receiving user input, then business rules of the user are analyzed, business data required by a report is generated, and the purpose of no strain in a certain sense is achieved.
Currently, there are a number of report rule engines available in the industry, including business and open source selection. However, most of these rules are engines for report display design, and flexible configuration of the data calculation method cannot be realized, and a large amount of repeated work still can be caused, so that the method has the defects of poor expandability, poor maintainability and high development cost. In order to solve the problems, the embodiment of the invention provides a report generation method, which can provide a method for visual flexible configuration in the generation process of a report, and automatically generate different report data according to configured business logic, thereby completing the separation of report development business logic and presentation forms and realizing a report engine capable of uniformly analyzing data, processing data and presenting information. Fig. 1 is a schematic diagram of a main flow of a report generating method according to an embodiment of the present invention. As shown in fig. 1, the main flow of the report generating method according to the embodiment of the present invention may include:
step S101, receiving a report generation request, and acquiring target identification information corresponding to a report to be generated according to the report generation request;
step S102, acquiring target parameter information corresponding to a report to be generated according to target identification information based on a pre-configured configuration information table;
And step S103, splicing and generating a target structured query statement according to the target parameter information and the configuration information table, and executing the target structured query statement to generate a report to be generated.
In the report generating method of the embodiment of the invention, firstly, a report generating request sent by a user or a staff is received, and target identification information corresponding to a report to be generated is obtained according to the received report generating request, wherein the target identification information can comprise: the organization identification information, the report identification information and the report data item identification information can be organization number information of a bank branch, the report identification information can be number information of a report, and the report data item identification information can be report data item number information. In the embodiment of the invention, after receiving the report generation request, the mechanism name, the report name and the data item can be extracted from the report generation request, so that the mechanism identification information corresponding to the mechanism name can be directly obtained, and the corresponding report identification information and report data item identification information can be obtained from the report master information table and the report item table of the configuration information table.
After the target identification information corresponding to the report to be generated is obtained in step S101, the obtained target identification information may be used to query the target parameter information corresponding to the report to be generated in combination with the pre-configured configuration information table. The configuration information table of the embodiment of the invention can be divided into a physical table part, a parameter comparison table part, a data comparison table part, a report information table part and an output information table part. Wherein the physical table portion may be used to store arithmetic logic; the parameter comparison table part can be used for defining available parameter codes and fields corresponding to different data types; the data comparison table part can be used for defining a data table corresponding to the data type; the report information table part is an important component part in the embodiment of the invention and can be used for storing the related information of the report; the output information table section may be used to store related information of the output data. Therefore, in the embodiment of the invention, after the target identification information is acquired, the target identification information can be utilized to query the target parameter information of the report to be generated in the pre-configured configuration information table.
After the target parameter information is queried by means of the configuration information table, the corresponding information can be acquired from the configuration information table by utilizing the target parameter information, the target structured query statement is spliced and generated, and then the generated target structured query statement is executed to obtain the report to be generated. It is contemplated that the structured query language (Structured Query Language, abbreviated as SQL language) is a database query and programming language for accessing data and querying, updating and managing relational database systems. The SQL language is a high-level non-procedural programming language, allows users to work on high-level data structures, does not require users to specify a storage method for data, and does not require users to know a specific data storage mode, so that different database systems with completely different underlying structures can use the same structured query language as an interface for data input and management. The SQL language statements can be nested, which gives him great flexibility and powerful functions. Therefore, in the embodiment of the invention, the target parameter information is utilized to acquire the corresponding information from the configuration information table, the target SQL statement is spliced and generated, and then the generated target SQL statement is executed to obtain the report to be generated.
According to the report generating method, after the target identification information corresponding to the report to be generated is obtained according to the report generating request, the target parameter information corresponding to the report to be generated can be obtained by combining with the pre-configured configuration information table, then the corresponding information can be queried from the configuration information table, the target structural query statement is spliced and generated, finally the target structural query statement is executed, the report to be generated is generated, a visual flexible configuration method can be provided in the generation process of the report, different report data can be automatically generated according to the configured business logic, and therefore separation of the business logic and the display form of the report is completed, the report generating efficiency is improved, the report generating time is shortened, repeated development of similar functions is avoided, the universality of the report is realized, and the development cost is saved.
It can be seen that the configuration information table is an important component in the embodiment of the present invention. Therefore, as a referenceable embodiment, before obtaining the target parameter information corresponding to the report to be generated according to the target identification information based on the pre-configured configuration information table, the report generation method may further include: the configuration information table is preconfigured. Table 1 is an information description of the configuration information table, and as can be seen from table 1, the configuration information table can be divided into a physical table section, a parameter comparison table section, a data comparison table section, a report information table section, and an output information table section. The physical table part may include an engine global parameter table, an engine personality parameter table and a product characteristic table, wherein the engine global parameter table is equivalent to default parameter configuration information of a general template, for example, a bank branch may modify operation logic of an engine according to the engine global parameter table, and the engine personality parameter table may configure special personality information for each report. The parameter lookup table portion may include a product/parameter lookup table, a product/pointer lookup table, and a customer/parameter lookup table. It should be noted that, in the embodiment of the present invention, the product/parameter comparison table and the client/parameter comparison table form a data type/parameter comparison table, when the data type is judged to be a product, the data type is searched in the product/parameter comparison table, and when the data type is judged to be a user, the data type is searched in the user/parameter comparison table. In addition, for the banking industry, the product/pointer comparison table herein may be a product/amount pointer comparison table, and for different industries, the corresponding pointer comparison table is different and needs to be set according to practical situations. The data lookup table portion may include a product/data table lookup table and a customer/data table lookup table. The report information table part may include a report master information table, a report item table, a report parameter table, and a report sub-parameter table. The output information table section may include an engine output table and an engine output field configuration table. In table 1, a detailed description of each table is also specifically described.
Table 1 is an information description of the configuration information table
In addition, in the embodiment of the invention, besides the configuration information table can be preconfigured, the configuration information table can be changed according to the service development requirement. Therefore, as still another embodiment of the present invention, the report generating method may further include: and changing the pre-configured configuration information table according to the configuration information table changing requirement, and executing the changed configuration information table according to the execution time corresponding to the changing requirement. The method is specifically realized in that after receiving the changing requirement of a configuration information table of a user or a worker, the configuration information table can be newly added or modified, the immediate effect or the delay processing can be selected according to the execution time corresponding to the changing requirement, if the real-time effect is selected, the generated report is the latest result obtained according to the latest configuration information table, so that the worker can change the configuration information table according to the specific requirement, and the configuration information table can be timely changed according to the characteristics of frequent report indexes and report change of internal control management and external supervision, thereby meeting the timeliness requirement of the report.
In the embodiment of the invention, corresponding information is acquired from the configuration information table according to the target parameter information, and then SQL sentences are generated, so that the acquisition of the target parameter information is another important part in the report generation method. Therefore, as still another embodiment, the obtaining, based on the pre-configured configuration information table, the target parameter information corresponding to the report to be generated according to the target identification information may include: and reading a report parameter table in the configuration information table by utilizing the target identification information, and acquiring target parameter information corresponding to the report to be generated. Wherein the target parameter information includes: data type information and conditional filtering information. The data type information may include product type information and client type information, so that a data type corresponding to a report to be generated may be determined according to the data type information in the target parameter information. The condition filtering information may be used to filter specific condition information of the data to be filtered.
The report parameter table is used as an important component of the configuration information table, and specific target parameter information can be obtained from the report parameter table after the target identification information is utilized. Table 2 is a composition information description of the report parameter table. In table 2, the report parameter table is composed of report items, parameter sets, parameter set main lines, parameter set branch lines, product modules, product sub-module sets, filtering parameters, filtering conditions, filtering condition sets, pointer conditions, pointer condition sets and default conditions, and specific composition descriptions are described in detail in table 2. It should be noted that, table 2 is a report parameter table created relative to the banking industry, so the pointer condition may be an amount pointer condition, and correspondingly, the pointer condition group is an amount pointer condition group, and for other industries, the pointer condition and the pointer condition group may be set differently according to actual situations. In addition, for the banking industry, under the condition that the data type is the product type, the report types are various and complex, so that the constituent elements of the report parameter table in the table 2 comprise the product module, the product sub-module and the product sub-module group, and the client module, the client sub-module and the client sub-module group are omitted, so that the constituent information of the report parameter table can be set according to the actual requirement, and the invention is not limited to the above.
Table 2 is a description of the composition information of the report parameter table
As shown in table 2, a plurality of parameter sets may be set for one report item. The basic elements of the parameter set are a parameter set main line, a product module, a product sub-module, a pointer condition and a default condition, and after the five elements are satisfied, an output result can be obtained. Fig. 2 is a schematic diagram of a configuration of a report parameter table according to an embodiment of the present invention, and it can be seen that filtering conditions in the report parameter table may be default. It is noted that a parameter set may correspond to a parameter set main line, a product module, and a default condition, but a plurality of product sub-modules, a plurality of parameter set branch lines, a plurality of filter conditions, and a plurality of pointer conditions may be set. That is, all product modules and product sub-modules can only be defined on the parameter set main leg, while pointer conditions (sets) and default conditions must be defined on the records of the product modules.
Generally, a parameter set generates a SQL statement, but through the above interrelationships, a parameter set may cause the splitting of the SQL statement due to multiple product sub-modules or multiple pointer conditions. For example, a parameter set comprises two product sub-modules, and two SQL sentences are split during processing; if the two pointer conditions are included, the other two SQL sentences are further split, and the total is four SQL sentences.
In the embodiment of the invention, the generated SQL statement can be composed of a select statement, a from statement, a where statement and a group by statement. As a further reference embodiment of the present invention, the generating the target structured query statement by stitching according to the target parameter information and the configuration information table may include: reading a data type/parameter comparison table in a configuration information table to obtain data type parameters according to the data type information, and then reading an engine output field configuration table in the configuration information table to generate a select statement; according to the data type information, reading a data comparison table in the configuration information table, searching a target data table corresponding to the report to be generated, and generating a from statement; generating a where statement according to the data type information and the condition filtering information; reading a data type/parameter comparison table according to the data type information to obtain data type parameters and generating a group by statement; and performing splicing processing on the select statement, the from statement, the where statement and the group by statement to generate a target structured query statement.
The select statement is used to select data and the result is stored in a result table. In the embodiment of the invention, a product/parameter comparison table in a configuration information table can be read to obtain a specific product type parameter according to data type information, such as product type information, then a specific field corresponding to the product type in a field configuration table is output by a reading engine to generate a select statement, or alternatively, for client type information, a client/parameter comparison table in the configuration information table is read to obtain a specific client type parameter, and then a specific field corresponding to the client type in a field configuration table is output by the reading engine to generate the select statement. In the embodiment of the invention, about 60 fields can be extracted by default, the remaining about 130 fields are custom fields, and the statistical sign field judges whether the fields need to be displayed or summarized according to the configuration information in the engine output field configuration table. It should be noted that, for the banking industry, the field corresponding to the current_id is processed by the value of the multiplexer, and the result is obtained by multiplying the sum by the multiplexer.
In the embodiment of the invention, 4 types of field types of the output field of the engine output table can be defined, namely characters, numerical values, ratios and dates, 20 types of characters can be set, and the other types of the characters are 10, and the total number of the field types is 50. Also, the definition may be divided into four layers: the method comprises a line layer, a report layer, a product module layer and a product sub-module layer, wherein each layer can have 50 independent custom fields, and the configuration method and the meaning of four layers are described in the table 3_report layer.
Table 3 is a report hierarchy description
If a report is configured with more than one level, the level closest to the current parameter set is automatically adopted when the report is fetched. For example, a report is configured with a layer 3 (the product module is an LOAN), and when the LOAN is encountered in the process of allocating the engine, a custom field with the layer 3 is adopted; encountering other product modules (e.g., DEPO), the custom field of level 1 is employed. The available parameter codes of all the product sub-modules are different, and if the parameter codes which cannot be resolved are encountered, NULL values can be automatically given without errors.
The from statement is a data source, and according to the data type information, the corresponding data table name is found out through the product/data table comparison table or the client/data table comparison table in the configuration information table. For example, the product class information uses inner join, and the product class additional information table and the customer-related table use left outer join.
The where statement indicates the condition under which the data is selected. In the embodiment of the invention, generating the where statement according to the data type information and the condition filtering information may include: reading a data type/parameter comparison table in the configuration information table according to the data type information to obtain data type parameters and generating data attribute filtering conditions; reading a data type/pointer comparison table in a configuration information table according to the data type information and pointer condition information in the condition filtering information, and generating pointer filtering conditions; reading an engine global parameter table and an engine personality parameter table in a configuration information table according to the data type information and the time condition information in the condition filtering information, and generating a time filtering condition; and performing splicing processing on the data attribute filtering condition, the pointer filtering condition and the time filtering condition to generate a where statement. The filter condition is spelled using multiple fields "param_type+param_id+text1+text2+time_band_ind+inc_exc" in the report parameter table. The method is concretely realized as follows: (1) Finding out the actual field name by using the param_type+param_id from the product/parameter comparison table and the client/parameter comparison table; (2) Judging whether the date type parameter is the date type parameter or not by using the time_band_ind, if the date type parameter is the date type parameter, spelling characters =, < >, > =, < > = betwen according to the time_band_ind, and if the date type parameter is not the date type parameter, spelling characters = and < >; (3) Then add the value of txet1, e.g., txet2 has a value, representing the range fetch, add the value of the and field and text 2. Normally, the and operator is used between filter conditions. If a paramid appears plural times in a parameter set and inc_exc is "include" then the or operator is used. Different branches (defined in sub_line) can be arranged in the same parameter set, an or operator can be used between the branches, brackets can be added at proper positions to ensure the accuracy of the or operator, and the branches can be set according to actual conditions.
The filtering of the around_id pointer is also performed in this section. Assuming that the pointer is an amount pointer in the banking industry, finding out the actual amount field name according to the product/amount pointer comparison table, and judging whether the value is greater than or less than < > according to the method. For common filtering conditions, the spelling of the default conditions is performed for part of the fields: the day of origin/creation, expiration date, contract/account status, amount. The fields and values actually used may be configured from the product/parameter table, and the default conditions above may be via the arom_ind switch. It is assumed that different default conditions are attached to a specific amount pointer, for example, if USP is used for non-interest principal, the engine automatically adds a filter condition of "interest day > accounting day", and it is noted that such default conditions cannot be turned on.
The group by statement is used to group the result set according to one or more columns. In the embodiment of the invention, the data type/parameter comparison table can be read to obtain the data type parameters according to the data type information, so that the set grouping mode can be obtained, and further the group by statement can be generated. After generating the select statement, the from statement, the where statement, and the group by statement, a concatenation process may be performed to generate the target SQL statement.
The configuration information table in the embodiment of the present invention further includes an engine output table, so as another referenceable embodiment, executing the target structured query statement, and generating the report to be generated may include: executing the target structured query statement, generating report data, and generating a report to be generated according to the generated report data and an engine output table in the configuration information table.
In the embodiment of the invention, after executing the target structured query statement and generating the report to be generated, the method further comprises the following steps: judging whether the report to be generated needs to be processed or not by using a report subparameter table in the configuration information table; if yes, updating the report to be generated by using the report subparameter table, and acquiring the updated report to be generated. In the embodiment of the invention, the report subparameter table can be used for judging whether special treatment is required to be carried out on the report to be generated, and if so, the report to be generated is updated by the report subparameter table, so that the updated report to be generated is obtained. The method is concretely realized as follows: and spelling an update statement through the report sub-parameter table, and processing data in the engine output table, wherein the statement can be a sphere statement, a set statement and an update statement.
According to field_id+text1+text2+time_band_ind spelling the sphere statement, directly spelling field_id, judging whether the field_id is a date parameter or not by using the time_band_ind, if the field_id is the date parameter, spelling characters =, < >, > =, < =, and betwen according to the time_band_ind, if the field_id is not the date parameter, spelling the characters =, then adding a value of text1, if text2 is a value, adding an and field and a value of text 2. For the set statement, the prt_item is spelled first, then the=character is spelled, and then the value of the sub_prt_item is spelled, so that the purpose of replacing the prt_item is achieved. For update statements, the default engine output table ord_eng_out may be used.
According to the report generation technical scheme provided by the embodiment of the invention, after the target identification information corresponding to the report to be generated is acquired according to the report generation request, the target parameter information corresponding to the report to be generated can be acquired by combining with the pre-configured configuration information table, then the corresponding information can be queried from the configuration information table, the target structured query statement is spliced and generated, and finally the target structured query statement is executed to generate the report to be generated.
The report generation method of the embodiment of the invention is realized as a report engine. The report engine can automatically generate statistical data required by the report according to the generation request corresponding to the report to be generated, and can select immediate effect or delay processing according to actual requirements after a user newly adds or modifies the configuration information table, if the real-time triggering is selected, the user can quickly see the latest result, and fig. 3 is a whole flow diagram of report engine data according to the embodiment of the invention. As shown in fig. 3, the implementation method mainly comprises the following steps: firstly, a technician configures information such as a product/data table comparison table, a client/data table comparison table and the like in advance, and after basic information is maintained, a business worker needs to configure information such as a report main information table, a report project table, a report parameter table, a report sub-parameter table and the like in advance (the specific table is shown in the information description of the configuration information table in Table 1). Wherein, the information of the product/data table comparison table, the client/data table comparison table and the like is generated according to the original data in the source system. Information tables configured by technicians and business personnel are stored in an engine configuration executor, and after the configuration information tables are configured, implementation operation or deferred operation can be selected. The engine execution can read corresponding information from the configuration information table according to the received report generation request to splice the information into SQL sentences, then the automatic generation data is executed, the generated data can be stored in a database, and then the engine output table is read to generate the report to be generated.
The report engine originates from the principles of popular workflow engines, definitions of report formats, various algorithms of report content. The rule analysis function is a core part of the report engine, generates a finally executed code by analyzing the input parameters and rule information of the related configuration table, and completes development of report data, the specific workflow is shown in fig. 4, and fig. 4 is a schematic workflow diagram of the report engine according to the embodiment of the invention. The analysis program mainly comprises five parts: initializing, generating a select statement, generating a from statement, generating a where statement, generating a group by statement, and generating a query branch according to the requirement of configuration information in the process of analysis.
The initialization of the report engine can be set by using the global parameter table of the engine, and if the personalized parameter table of the engine is provided with personalized settings, the report engine can be preferentially used. The system parameters, such as the home code and the country code, are initialized, so that the overall operation efficiency is improved. In addition, the data i cleaning work is also performed in the initialization phase. The method is characterized in that for the same report, only one section of data is reserved in the engine output table, and the last operation result is cleaned when the engine output table is operated each time, so that the consistency of the data is maintained.
The data extraction is the core part in the whole report engine, and according to the report parameter table, the dynamic SQL statement can be spelled by using the unit of the mechanism number, the report item and the serial number, and the running result is stored in the engine output table. Spelling work is divided into three parts: where statement spelling, from statement spelling, select statement spelling, and group up statement spelling. Wherein specific sql statements have been described in detail above and are not further described here.
After the engine output table is obtained, an update statement is spelled out through the report subparameter table, and processing is realized on the data in the engine output table. Spelling work is divided into three parts: the word spelling, set word spelling, and update word spelling, wherein the specific spelling process is also described in detail above and is not further elaborated herein.
The report engine for realizing the report generating method of the embodiment of the invention can combine the pre-configured configuration information table to acquire the target parameter information corresponding to the report to be generated after acquiring the target identification information corresponding to the report to be generated according to the report generating request, then can inquire the corresponding information from the configuration information table, splice and generate the target structured inquiry statement, finally execute the target structured inquiry statement to generate the report to be generated, thereby providing a visual flexible configuration method in the generating process of the report, automatically generating different report data according to the configured business logic, completing the separation of the business logic and the display form of the report, improving the report generating efficiency, shortening the report generating time, avoiding the repeated development of similar functions, realizing the universality of the report and saving the development cost.
Fig. 5 is a schematic diagram of main modules of a report generating apparatus according to an embodiment of the present invention. As shown in fig. 5, the report generating apparatus 500 according to the embodiment of the present invention may include: a receiving module 501, an acquiring module 502 and a generating module 503.
The receiving module 501 may be configured to receive a report generation request, and obtain target identification information corresponding to a report to be generated according to the report generation request; the obtaining module 502 may be configured to obtain, based on a pre-configured configuration information table, target parameter information corresponding to a report to be generated according to target identification information; the generating module 503 may be configured to splice and generate a target structured query statement according to the target parameter information and the configuration information table, and execute the target structured query statement to generate a report to be generated.
In the embodiment of the present invention, the obtaining module 502 may further be configured to: reading a report parameter table in the configuration information table by utilizing the target identification information to obtain target parameter information corresponding to a report to be generated; wherein the target parameter information includes: data type information and conditional filtering information.
In the embodiment of the present invention, the generating module 503 may further be configured to: reading a data type/parameter comparison table in a configuration information table to obtain data type parameters according to the data type information, and then reading an engine output field configuration table in the configuration information table to generate a select statement; according to the data type information, reading a data comparison table in the configuration information table, searching a target data table corresponding to the report to be generated, and generating a from statement; generating a where statement according to the data type information and the condition filtering information; reading a data type/parameter comparison table according to the data type information to obtain data type parameters and generating a group b7 statement; and performing splicing processing on the select statement, the from statement, the where statement and the group b7 statement to generate a target structured query statement.
In the embodiment of the present invention, the generating module 503 may further be configured to: reading a data type/parameter comparison table in the configuration information table according to the data type information to obtain data type parameters and generating data attribute filtering conditions; reading a data type/pointer comparison table in a configuration information table according to the data type information and pointer condition information in the condition filtering information, and generating pointer filtering conditions; reading an engine global parameter table and an engine personality parameter table in a configuration information table according to the data type information and the time condition information in the condition filtering information, and generating a time filtering condition; and performing splicing processing on the data attribute filtering condition, the pointer filtering condition and the time filtering condition to generate a where statement.
In the embodiment of the present invention, the generating module 503 may further be configured to: executing the target structured query statement, generating report data, and generating a report to be generated according to the generated report data and an engine output table in the configuration information table.
In the embodiment of the present invention, the generating module 503 may further be configured to: judging whether the report to be generated needs to be processed or not by using a report subparameter table in the configuration information table; if yes, updating the report to be generated by using the report subparameter table, and acquiring the updated report to be generated.
In the embodiment of the present invention, the report generating device may further include: a configuration module (not shown). The configuration module may be used to pre-configure the configuration information table.
In the embodiment of the invention, the configuration module can be further used for: and changing the pre-configured configuration information table according to the configuration information table changing requirement, and executing the changed configuration information table according to the execution time corresponding to the changing requirement.
In the embodiment of the present invention, the report generating device may further include: an initialization module (not shown in the figure). The initialization module can be used for performing initialization processing by utilizing an engine global parameter table and an engine personality parameter table in the configuration information table.
As can be seen from the above description, the report generating device according to the embodiment of the present invention can acquire the target identification information corresponding to the report to be generated according to the report generating request, and then can acquire the target parameter information corresponding to the report to be generated in combination with the pre-configured configuration information table, and then can query the corresponding information from the configuration information table, splice and generate the target structured query statement, and finally execute the target structured query statement to generate the report to be generated, thereby providing a method for flexible visualization configuration in the report generation process, automatically generating different report data according to the configured business logic, thereby completing the separation of the business logic and the display form of the report development, improving the report generating efficiency, shortening the report generating time, avoiding the repeated development of similar functions, realizing the versatility of the report, and saving the development cost.
Fig. 6 illustrates an exemplary system architecture 600 in which a report generating method or report generating apparatus of an embodiment of the present invention may be applied.
As shown in fig. 6, the system architecture 600 may include terminal devices 601, 602, 603, a network 604, and a server 605. The network 604 is used as a medium to provide communication links between the terminal devices 601, 602, 603 and the server 605. The network 604 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.
A user may interact with the server 605 via the network 604 using the terminal devices 601, 602, 603 to receive or send messages, etc. Various communication client applications such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only) may be installed on the terminal devices 601, 602, 603.
The terminal devices 601, 602, 603 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.
The server 605 may be a server providing various services, such as a background management server (by way of example only) providing support for shopping-type websites browsed by users using terminal devices 601, 602, 603. The background management server may analyze and process the received data such as the product information query request, and feedback the processing result (e.g., the target push information, the product information—only an example) to the terminal device.
Note that, the report generating method provided by the embodiment of the present invention is generally executed by the server 605, and accordingly, the report generating device is generally disposed in the server 605.
It should be understood that the number of terminal devices, networks and servers in fig. 6 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Referring now to FIG. 7, there is illustrated a schematic diagram of a computer system 700 suitable for use in implementing an embodiment of the present invention. The terminal device shown in fig. 7 is only an example, and should not impose any limitation on the functions and the scope of use of the embodiment of the present invention.
As shown in fig. 7, the computer system 700 includes a Central Processing Unit (CPU) 701, which can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 702 or a program loaded from a storage section 708 into a Random Access Memory (RAM) 703. In the RAM 703, various programs and data required for the operation of the system 700 are also stored. The CPU 701, ROM 702, and RAM 703 are connected to each other through a bus 704. An input/output (I/O) interface 705 is also connected to bus 704.
The following components are connected to the I/O interface 705: an input section 706 including a keyboard, a mouse, and the like; an output portion 707 including a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, a speaker, and the like; a storage section 708 including a hard disk or the like; and a communication section 709 including a network interface card such as a LAN card, a modem, or the like. The communication section 709 performs communication processing via a network such as the internet. The drive 710 is also connected to the I/O interface 705 as needed. A removable medium 711 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 710 as necessary, so that a computer program read therefrom is mounted into the storage section 708 as necessary.
In particular, according to embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network via the communication portion 709, and/or installed from the removable medium 711. The above-described functions defined in the system of the present invention are performed when the computer program is executed by a Central Processing Unit (CPU) 701.
The computer readable medium shown in the present invention may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules involved in the embodiments of the present invention may be implemented in software or in hardware. The described modules may also be provided in a processor, for example, as: a processor includes a receiving module, an obtaining module, and a generating module. The names of the modules do not form a limitation on the module itself in a certain case, for example, the receiving module may also be described as a "receiving report generation request", and acquiring target identification information corresponding to a report to be generated according to the report generation request ".
As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be present alone without being fitted into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to include: receiving a report generation request, and acquiring target identification information corresponding to a report to be generated according to the report generation request; acquiring target parameter information corresponding to a report to be generated according to target identification information based on a pre-configured configuration information table; and according to the target parameter information and the configuration information table, splicing to generate a target structured query statement, and executing the target structured query statement to generate a report to be generated.
According to the technical scheme of the embodiment of the invention, after the target identification information corresponding to the report to be generated is acquired according to the report generation request, the target parameter information corresponding to the report to be generated can be acquired by combining with the pre-configured configuration information table, then the corresponding information can be queried from the configuration information table, the target structured query statement is spliced and generated, finally the target structured query statement is executed, the report to be generated is generated, a method for flexibly configuring visualization can be provided in the generation process of the report, different report data can be automatically generated according to the configured business logic, thereby completing the separation of the business logic and the display form of the report development, improving the report generation efficiency, shortening the report generation time, avoiding the repeated development of similar functions, realizing the universality of the report and saving the development cost.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives can occur depending upon design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.

Claims (11)

1. A report generation method, comprising:
receiving a report generation request, and acquiring target identification information corresponding to a report to be generated according to the report generation request;
acquiring target parameter information corresponding to the report to be generated according to the target identification information based on a pre-configured configuration information table; the configuration information table is divided into a physical table, a parameter comparison table, a data comparison table, a report information table and an output information table, wherein the physical table is used for storing operation logic, the parameter comparison table is used for defining available parameter codes and fields corresponding to different data types, the data comparison table is used for defining the data types and the data tables corresponding to the data types, the report information table is used for storing the related information of a report, and the output information table is used for storing the related information of output data; the target parameter information comprises data type information, wherein the data type information comprises product type information and client type information;
According to the target parameter information and the configuration information table, splicing to generate a target structured query statement, executing the target structured query statement, and generating the report to be generated; one report item corresponds to one or more parameter groups, and when the parameter groups have a plurality of product sub-modules or a plurality of pointer conditions, the structural query statement is split;
judging whether the report to be generated needs to be processed or not by using a report subparameter table in the configuration information table; if yes, updating the report to be generated by using the report subparameter table, and acquiring the updated report to be generated; the method comprises the steps of spelling an update statement through a report subparameter table, wherein the spelling work is divided into three parts: a where statement spelling, a set statement spelling, and an update statement spelling.
2. The method according to claim 1, wherein the obtaining, based on the pre-configured configuration information table and according to the target identification information, the target parameter information corresponding to the report to be generated includes:
reading a report parameter table in the configuration information table by using the target identification information to obtain target parameter information corresponding to the report to be generated; wherein the target parameter information further comprises condition filtering information.
3. The method according to claim 2, wherein the concatenating the target parameter information and the configuration information table to generate a target structured query term includes:
reading a data type/parameter comparison table in the configuration information table to obtain data type parameters according to the data type information, and then reading an engine output field configuration table in the configuration information table to generate a select statement;
reading a data comparison table in the configuration information table according to the data type information, searching a target data table corresponding to the report to be generated, and generating a from statement;
generating a sphere statement according to the data type information and the condition filtering information;
reading the data type/parameter comparison table according to the data type information to obtain data type parameters and generating a group by statement;
and performing splicing processing on the select statement, the from statement, the where statement and the group by statement to generate the target structured query statement.
4. The method of claim 3, wherein generating a where statement based on the data type information and the conditional filter information comprises:
Reading a data type/parameter comparison table in the configuration information table according to the data type information to obtain data type parameters and generating data attribute filtering conditions;
reading a data type/pointer comparison table in the configuration information table according to the data type information and pointer condition information in the condition filtering information, and generating pointer filtering conditions;
reading an engine global parameter table and an engine personality parameter table in the configuration information table according to the data type information and the time condition information in the condition filtering information, and generating a time filtering condition;
and performing splicing processing on the data attribute filtering condition, the pointer filtering condition and the time filtering condition to generate the where statement.
5. The method of claim 1, wherein the executing the target structured query statement to generate the report to be generated comprises:
executing the target structured query statement, generating report data, and generating the report to be generated according to the generated report data and an engine output table in the configuration information table.
6. The method according to claim 1, wherein before acquiring the target parameter information corresponding to the report to be generated according to the target identification information based on a pre-configured configuration information table, the method further comprises: the configuration information table is preconfigured.
7. The method of claim 6, wherein the method further comprises:
and changing the pre-configured configuration information table according to a configuration information table changing requirement, and executing the changed configuration information table according to the execution time corresponding to the changing requirement.
8. The method according to claim 1, wherein the method further comprises:
and initializing by using the engine global parameter table and the engine personality parameter table in the configuration information table.
9. A report generating apparatus, comprising:
the receiving module is used for receiving a report generation request and acquiring target identification information corresponding to a report to be generated according to the report generation request;
the acquisition module is used for acquiring the target parameter information corresponding to the report to be generated according to the target identification information based on a pre-configured configuration information table; the configuration information table is divided into a physical table, a parameter comparison table, a data comparison table, a report information table and an output information table, wherein the physical table is used for storing operation logic, the parameter comparison table is used for defining available parameter codes and fields corresponding to different data types, the data comparison table is used for defining the data types and the data tables corresponding to the data types, the report information table is used for storing the related information of a report, and the output information table is used for storing the related information of output data; the target parameter information comprises data type information, wherein the data type information comprises product type information and client type information;
The generation module is used for splicing and generating a target structured query statement according to the target parameter information and the configuration information table, executing the target structured query statement and generating the report to be generated; one report item corresponds to one or more parameter groups, and when the parameter groups have a plurality of product sub-modules or a plurality of pointer conditions, the structural query statement is split;
judging whether the report to be generated needs to be processed or not by using a report subparameter table in the configuration information table; if yes, updating the report to be generated by using the report subparameter table, and acquiring the updated report to be generated; the method comprises the steps of spelling an update statement through a report subparameter table, wherein the spelling work is divided into three parts: a where statement spelling, a set statement spelling, and an update statement spelling.
10. An electronic device, comprising:
one or more processors;
storage means for storing one or more programs,
when executed by the one or more processors, causes the one or more processors to implement the method of any of claims 1-8.
11. A computer readable medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the method according to any of claims 1-8.
CN201911326564.3A 2019-12-20 2019-12-20 Report generation method and report generation device Active CN111177231B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911326564.3A CN111177231B (en) 2019-12-20 2019-12-20 Report generation method and report generation device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911326564.3A CN111177231B (en) 2019-12-20 2019-12-20 Report generation method and report generation device

Publications (2)

Publication Number Publication Date
CN111177231A CN111177231A (en) 2020-05-19
CN111177231B true CN111177231B (en) 2023-09-22

Family

ID=70655582

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911326564.3A Active CN111177231B (en) 2019-12-20 2019-12-20 Report generation method and report generation device

Country Status (1)

Country Link
CN (1) CN111177231B (en)

Families Citing this family (27)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111897806A (en) * 2020-06-28 2020-11-06 苏宁金融科技(南京)有限公司 Big data offline data quality inspection method and device
CN111897856A (en) * 2020-07-31 2020-11-06 平安普惠企业管理有限公司 Supervision message generation method, device, electronic device and readable storage medium
CN111897831A (en) * 2020-07-31 2020-11-06 平安普惠企业管理有限公司 Method, device, electronic device and storage medium for generating service message
CN111913993B (en) * 2020-08-12 2024-02-23 望海康信(北京)科技股份公司 Table data generation method, apparatus, electronic device and computer readable storage medium
CN111988401A (en) * 2020-08-20 2020-11-24 支付宝(杭州)信息技术有限公司 Data uploading method and device
CN112036143B (en) * 2020-09-02 2023-09-22 中国银行股份有限公司 Method and system for generating sustainable custom report responding to report demand
CN112199930B (en) * 2020-10-29 2024-06-28 上海蚂蚁创将信息技术有限公司 Method and system for automatically generating report according to report configuration
CN112487282A (en) * 2020-11-04 2021-03-12 山东中创软件商用中间件股份有限公司 Business processing condition monitoring method and device, electronic equipment and storage medium
CN112364025B (en) * 2020-11-30 2023-09-22 中国银行股份有限公司 Data processing method and device, electronic equipment and computer readable storage medium
CN112580319A (en) * 2020-12-14 2021-03-30 京东数字科技控股股份有限公司 Data processing method, device, equipment and computer readable storage medium
CN112632006A (en) * 2020-12-18 2021-04-09 平安普惠企业管理有限公司 Electronic report file export method, device, equipment and storage medium
CN112559646A (en) * 2020-12-25 2021-03-26 中国建设银行股份有限公司 Report downloading method and device
CN112883082B (en) * 2021-02-24 2023-04-14 浪潮通用软件有限公司 Method, device and equipment for realizing query of dynamic column
CN113051881A (en) * 2021-04-02 2021-06-29 北京神州数字科技有限公司 Report display method based on parameter configuration
CN113221522B (en) * 2021-04-28 2024-01-09 北京达佳互联信息技术有限公司 Report generation method, device, system, electronic equipment and storage medium
CN113535804B (en) * 2021-06-16 2025-04-01 支付宝(杭州)信息技术有限公司 Business data processing method, device, equipment and system
CN113342821B (en) * 2021-06-29 2023-04-07 深圳前海微众银行股份有限公司 Report configuration method, device, equipment and computer storage medium
CN113591448B (en) * 2021-08-03 2024-06-18 京东科技控股股份有限公司 Report generation method, device and storage medium
CN113642301A (en) * 2021-08-09 2021-11-12 京东科技控股股份有限公司 Report generation method, device and system
CN114218254B (en) * 2021-12-17 2025-09-02 中国建设银行股份有限公司 Report generation method, device, equipment and storage medium
CN114416674A (en) * 2022-01-21 2022-04-29 中国银行股份有限公司 Report generation method and device
CN115017190A (en) * 2022-04-22 2022-09-06 中银金融科技有限公司 Method and device for providing sequence number based on trigger and dynamic SQL
CN114968455B (en) * 2022-04-29 2024-02-27 北京百度网讯科技有限公司 Report generation method and device of application interface and electronic equipment
CN114943212B (en) * 2022-06-17 2024-11-12 中国银行股份有限公司 A parameter report generation method and related equipment
CN115374761A (en) * 2022-07-15 2022-11-22 中银金融科技有限公司 Report generation method, report generation device, electronic equipment and storage medium
CN115331669A (en) * 2022-08-01 2022-11-11 中国工商银行股份有限公司 Information generation method, apparatus, device, medium
KR102653516B1 (en) * 2022-12-15 2024-04-02 쿠팡 주식회사 Method and appartus for providing data

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105843784A (en) * 2016-03-18 2016-08-10 中国银行股份有限公司 Statement generation method and device
CN105843945A (en) * 2016-04-08 2016-08-10 联动优势科技有限公司 Report generation method and system
CN108984506A (en) * 2018-08-01 2018-12-11 北京中电普华信息技术有限公司 A kind of generation method and device of configurable intelligent report forms
CN109471890A (en) * 2018-10-16 2019-03-15 深圳壹账通智能科技有限公司 Generation method, terminal device and the medium of report file
CN109582937A (en) * 2017-09-28 2019-04-05 北京国双科技有限公司 Report form generation method, device, storage medium and processor
CN109857756A (en) * 2019-01-14 2019-06-07 中国联合网络通信集团有限公司 Generation method, device, equipment and the readable storage medium storing program for executing of Database Report

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105843784A (en) * 2016-03-18 2016-08-10 中国银行股份有限公司 Statement generation method and device
CN105843945A (en) * 2016-04-08 2016-08-10 联动优势科技有限公司 Report generation method and system
CN109582937A (en) * 2017-09-28 2019-04-05 北京国双科技有限公司 Report form generation method, device, storage medium and processor
CN108984506A (en) * 2018-08-01 2018-12-11 北京中电普华信息技术有限公司 A kind of generation method and device of configurable intelligent report forms
CN109471890A (en) * 2018-10-16 2019-03-15 深圳壹账通智能科技有限公司 Generation method, terminal device and the medium of report file
CN109857756A (en) * 2019-01-14 2019-06-07 中国联合网络通信集团有限公司 Generation method, device, equipment and the readable storage medium storing program for executing of Database Report

Also Published As

Publication number Publication date
CN111177231A (en) 2020-05-19

Similar Documents

Publication Publication Date Title
CN111177231B (en) Report generation method and report generation device
CN108027833B (en) Method for creating structured data language query
US10331692B2 (en) Transforming and loading data from a source data system to a target data system
AU2010337218B2 (en) Specifying user interface elements
CN111061733B (en) Data processing method, device, electronic equipment and computer readable storage medium
US8630969B2 (en) Systems and methods for implementing business rules designed with cloud computing
CN112905178A (en) Method, device, equipment and medium for generating business function page
US12197477B2 (en) System and method for translating a software query in an automated integration process into natural language
US10838964B2 (en) Supporting a join operation against multiple NoSQL databases
EP3455713A1 (en) Data flow design with static and dynamic elements
CN113760240B (en) Method and device for generating data model
CN112947919B (en) Method and device for building business model and processing business request
CN116594683A (en) Code annotation information generation method, device, equipment and storage medium
CN111125064A (en) Method and device for generating database mode definition statement
CN117454278A (en) Method and system for realizing digital rule engine of standard enterprise
CN114217842A (en) A general visual resource directory configuration method and system
US9741065B2 (en) Automated guidance for selecting components of an it solution
CN114282129A (en) Information system page generation method, system, electronic equipment and storage medium
CN113760969A (en) Data query method and device based on elastic search
US12117999B2 (en) Masking shard operations in distributed database systems
CN115422202A (en) Service model generation method, service data query method, device and equipment
CN113312053B (en) A method and device for data processing
US9489436B2 (en) Gateway enablement of analytic database services
CN117194463A (en) Method and device for inquiring report data
US20140012632A1 (en) Extension of business scenarios

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
TA01 Transfer of patent application right
TA01 Transfer of patent application right

Effective date of registration: 20220927

Address after: 25 Financial Street, Xicheng District, Beijing 100033

Applicant after: CHINA CONSTRUCTION BANK Corp.

Address before: 25 Financial Street, Xicheng District, Beijing 100033

Applicant before: CHINA CONSTRUCTION BANK Corp.

Applicant before: Jianxin Financial Science and Technology Co.,Ltd.

GR01 Patent grant
GR01 Patent grant