Report generation method and apparatus

Abstract

The present disclosure provides a report generation method, applied to the field of artificial intelligence technology, and the method comprises the following steps: receiving a report construction request, wherein the report construction request indicates index configuration information associated with at least one business index; obtaining initial index data in the form of a structured query language (SQL) from a business system database for constructing a report; performing parsing processing on the initial index data in the form of SQL according to the index configuration information to obtain standard index data associated with each business index; performing aggregation operation on the standard index data associated with each business index to obtain an aggregation operation result; and constructing a statistical report based on the aggregation operation result and outputting the statistical report. The present disclosure also provides a report generation device, an electronic device and a computer storage medium.

Description

TECHNICAL FIELD

[0001] The present disclosure relates to the field of artificial intelligence, and in particular, to a report generation method and device. BACKGROUND

[0002] Statistical reports play an important role in bank regulatory reporting, data analysis, internal statistics and other work, and can provide important reference for bank business analysis and risk asset management. The generation efficiency and configuration flexibility of statistical reports affect their application in bank daily accounting business.

[0003] In the process of implementing the technical solutions of the present disclosure, the inventors found that as the update speed of bank business improves, the work of generating statistical reports needs to adapt to more frequent changes in demand and more urgent demand updates, which puts higher requirements on the report generation efficiency and report configuration flexibility. SUMMARY

[0004] One aspect of the present disclosure provides a report generation method, comprising: receiving a report construction request, the report construction request indicating index configuration information associated with at least one business index; obtaining initial index data in the form of SQL (Structured Query Language) from a business system database for constructing a report; performing parsing processing on the initial index data in the form of SQL according to the index configuration information to obtain standard index data associated with each of the business indexes; performing aggregation operation on the standard index data associated with each of the business indexes to obtain an aggregation operation result; and constructing a statistical report based on the aggregation operation result and outputting the statistical report.

[0005] Optionally, the index configuration information includes index field identifiers and / or index field meanings associated with each of the business indexes; and the parsing processing on the initial index data in the form of SQL according to the index configuration information to obtain the standard index data associated with each of the business indexes comprises: performing discrete processing on the initial index data in the form of SQL to obtain intermediate index data based on index field discretization; and performing aggregation processing on the intermediate index data based on index field discretization according to the index field identifiers and / or index field meanings associated with each of the business indexes to obtain the standard index data associated with each of the business indexes.

[0006] Optionally, the index configuration information includes aggregation operation types associated with each of the business indexes; and the aggregation operation on the standard index data associated with each of the business indexes to obtain the aggregation operation result comprises: performing aggregation operation on the standard index data associated with each of the business indexes according to the aggregation operation types indicated by the index configuration information to obtain the aggregation operation result.

[0007] Optionally, the index configuration information further comprises index parameter threshold values associated with the business indexes; and the aggregating the standard index data associated with the business indexes to obtain the aggregation operation result comprises: aggregating the standard index data associated with the business indexes according to the aggregation operation type and the index parameter threshold values indicated by the index configuration information to obtain the aggregation operation result.

[0008] Optionally, the index configuration information further comprises operation logic for combining different business indexes into a composite business index; and the aggregating the standard index data associated with the business indexes to obtain the aggregation operation result comprises: aggregating the standard index data associated with at least two business indexes to be combined according to the operation logic and the at least two business indexes to be combined associated with the operation logic to obtain the aggregation operation result associated with the composite business index.

[0009] Optionally, in a case where a certain business index is a summary index obtained by summarizing at least two same-type sub-indexes, the aggregating the standard index data associated with the business indexes to obtain the aggregation operation result comprises: aggregating the standard index data associated with the sub-indexes to obtain the aggregation operation result associated with the sub-indexes; and summarizing the aggregation operation results associated with the sub-indexes to obtain the aggregation operation result associated with the business index.

[0010] Optionally, the aggregation operation comprises at least one of counting operation, summation operation, mean value operation, and extreme value operation.

[0011] Another aspect of the present disclosure provides a report generation apparatus, comprising: a receiving module configured to receive a report construction request, the report construction request indicating index configuration information associated with at least one business index; a first processing module configured to obtain initial index data in the form of structured query language (SQL) from a database of a business system for constructing a report; a second processing module configured to perform parsing processing on the initial index data in the form of SQL according to the index configuration information to obtain standard index data associated with the business indexes; a third processing module configured to aggregate the standard index data associated with the business indexes to obtain an aggregation operation result; and a fourth processing module configured to construct a statistical report based on the aggregation operation result and output the statistical report.

[0012] Optionally, the index configuration information comprises an index field identifier and / or an index field interpretation associated with each of the service indexes; the second processing module comprises: a first processing submodule, configured to perform discrete processing on the initial index data in the SQL form to obtain intermediate index data based on index field discretization; and a second processing submodule, configured to perform aggregation processing on the intermediate index data based on index field discretization according to the index field identifier and / or the index field interpretation associated with each of the service indexes to obtain standard index data associated with each of the service indexes.

[0013] Optionally, the index configuration information comprises an aggregation operation type associated with each of the service indexes; and the third processing module comprises: a third processing submodule, configured to perform aggregation operation on the standard index data associated with each of the service indexes according to the aggregation operation type indicated by the index configuration information to obtain the aggregation operation result.

[0014] Optionally, the index configuration information further comprises an index parameter threshold associated with each of the service indexes; and the third processing module comprises: a fourth processing submodule, configured to perform aggregation operation on the standard index data associated with each of the service indexes according to the aggregation operation type and the index parameter threshold indicated by the index configuration information to obtain the aggregation operation result.

[0015] Optionally, the index configuration information further comprises operation logic for combining different service indexes into a composite service index; and the third processing module comprises: a fifth processing submodule, configured to perform aggregation operation on the standard index data associated with each of at least two service indexes to be combined according to the operation logic and the at least two service indexes associated with the operation logic to obtain an aggregation operation result associated with the composite service index.

[0016] Optionally, in a case where a certain service index is a summary index obtained by summarizing at least two same-type sub-indexes, the third processing module comprises: a sixth processing submodule, configured to perform aggregation operation on the standard index data associated with each of the sub-indexes to obtain an aggregation operation result associated with each of the sub-indexes; and a seventh processing submodule, configured to perform summarization on the aggregation operation results associated with each of the sub-indexes to obtain an aggregation operation result associated with the service index.

[0017] Optionally, the aggregation operation comprises at least one of counting operation, summation operation, mean value operation and extreme value operation.

[0018] Another aspect of the present disclosure provides an electronic device, comprising one or more processors; a memory storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of the embodiments of the present disclosure.

[0019] Another aspect of the present disclosure provides a computer-readable storage medium storing computer-executable instructions that, when executed, implement the method of the embodiments of the present disclosure.

[0020] Another aspect of the present disclosure provides a computer program product comprising a computer program that, when executed by a processor, implements the method of the embodiments of the present disclosure. BRIEF DESCRIPTION OF DRAWINGS

[0021] For a more complete understanding of the present disclosure and its advantages, reference is now made to the following description taken in conjunction with the accompanying drawings in which,

[0022] Figure 1 The system architecture of the report generation method and device according to the embodiments of the present disclosure is schematically shown;

[0023] Figure 2 The flowchart of a report generation method according to the embodiments of the present disclosure is schematically shown;

[0024] Figure 3 The flowchart of another report generation method according to the embodiments of the present disclosure is schematically shown;

[0025] Figure 4 The flowchart of yet another report generation method according to the embodiments of the present disclosure is schematically shown;

[0026] Figure 5 The block diagram of a report generation device according to the embodiments of the present disclosure is schematically shown;

[0027] Figure 6 The block diagram of an electronic device according to the embodiments of the present disclosure is schematically shown. DETAILED DESCRIPTION

[0028] Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. However, it should be understood that the description is merely exemplary, and is not intended to limit the scope of the present disclosure. In the following detailed description, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present disclosure. However, it will be apparent to one skilled in the art that one or more embodiments can be practiced without these specific details. In addition, in the following description, descriptions of well-known structures and techniques have been omitted to avoid unnecessarily obscuring the concept of the present disclosure.

[0029] The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. As used herein, the terms "comprises", "comprising", "includes", "including" and the like are specifically intended to be open-ended and to mean that other features, operations, operations, or components can be added or otherwise included.

[0030] All terms used herein (including technical and scientific terms) have the meanings commonly understood by one of ordinary skill in the art, unless otherwise defined. It should be noted that the terms used herein should be interpreted as having meanings that are consistent with the context of the specification, and should not be interpreted in an idealized or overly formal manner.

[0031] In the case of using expressions similar to "at least one of A, B, and C, etc.", it should generally be interpreted to include any of them alone, any combination of two or more of them, and the like.

[0032] Some block diagrams and / or flowcharts are shown in the accompanying drawings. It should be understood that some blocks in the block diagrams and / or flowcharts, or combinations thereof, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing apparatus, so that these instructions, when executed by the processor, can construct a device for implementing the functions / operations described in the block diagrams and / or flowcharts. The technology of the disclosure can be implemented in the form of hardware and / or software (including firmware, microcode, etc.). In addition, the technology of the disclosure can take the form of a computer program product in the form of a computer readable storage medium storing instructions, which can be used by or in conjunction with an instruction execution system.

[0033] Embodiments of the disclosure provide a method and a generating device capable of applying the method. In the method, first, a report building request is received, the report building request indicating index configuration information associated with at least one business index, then, initial index data in the form of a structured query language (SQL) for building a report is obtained from a business system database, next, according to the index configuration information, a parsing process is performed on the initial index data in the form of SQL to obtain standard index data associated with each business index, and an aggregation operation is performed on the standard index data associated with each business index to obtain an aggregation operation result, and finally, based on the aggregation operation result, a statistical report is built and output.

[0034] Figure 1 The system architecture of the report generating method and device according to the embodiments of the disclosure is schematically shown. It should be noted that, Figure 1The shown is only an example of a system architecture to which the embodiments of the present disclosure can be applied, to help those skilled in the art understand the technical content of the present disclosure, but does not mean that the embodiments of the present disclosure cannot be used in other devices, systems, environments or scenarios.

[0035] As shown in Figure 1 The system architecture 100 can include business ends (a plurality of which are shown, such as business ends 101, 102, 103), a network 104, and a report generation system 105, the network 104 being a medium for providing a communication link between the business ends 101, 102, 103 and the report generation system 105. The network 104 can include various connection types, such as wired, wireless communication links, or optical fiber cables, etc. The report generation system 105, as the main body of the present scheme, can be a standalone physical server, or a server cluster or distributed system composed of multiple physical servers, or a cloud server providing cloud services, cloud computing, network services, middleware services, and other basic cloud computing services.

[0036] The report generation system 105 receives a report construction request from a business end (such as the business end 101, 102, 103), the report construction request indicating index configuration information associated with at least one business index. Next, the report generation system 105 obtains initial index data in the form of SQL from a business system database for constructing a report, and performs parsing processing on the initial index data in the form of SQL according to the index configuration information, to obtain standard index data associated with each business index. Then, the report generation system 105 performs aggregation operation on the standard index data associated with each business index, to obtain an aggregation operation result. Finally, based on the aggregation operation result, a statistical report is constructed and output to the business end (such as the business end 101, 102, 103).

[0037] It should be noted that the report generation method and device of the embodiments of the present disclosure can be used in the financial field, and can also be used in any field other than the financial field. The present disclosure will be described in detail below in conjunction with the drawings and specific embodiments.

[0038] Figure 2 The flowchart of a report generation method according to an embodiment of the present disclosure is schematically shown as Figure 2 The method 200 can include operations S210-S250.

[0039] In operation S210, a report construction request is received, the report construction request indicating index configuration information associated with at least one business index.

[0040] Next, in operation S220, initial index data in the form of SQL structured query language is obtained from a business system database for constructing a report.

[0041] Next, in operation S230, according to the index configuration information, a parsing process is performed on the initial index data in SQL form to obtain standard index data associated with each business index.

[0042] Next, in operation S240, an aggregation operation is performed on the standard index data associated with each business index to obtain an aggregation operation result.

[0043] Next, in operation S250, based on the aggregation operation result, a statistical report is constructed and output.

[0044] The specific flow of each step of the report generation method of the present embodiment will be described in detail below.

[0045] In operation S210, a report construction request is received, the report construction request indicating index configuration information associated with at least one business index.

[0046] In the present embodiment, specifically, a report construction request from a business end is received, the report construction request indicating index configuration information associated with at least one business index. Depending on the type and application purpose of the statistical report to be generated, the business index details used to generate the statistical report can be different. For example, when generating a statistical report on enterprise loan business, the business index used to generate the statistical report can include, for example, net assets to year-end loan balance ratio, asset-liability ratio, fund flow ratio, guarantee ratio, cash ratio, labor cash payment rate, main business collection rate, inventory turnover speed, operating profit rate, interest coverage ratio, and the like.

[0047] The index configuration information can be designed by business personnel according to actual business needs, which supports flexible modification and individual customization. The index configuration information indicates the business index configuration for generating the statistical report, and the index configuration information can include, for example, index field identification, index field meaning, aggregation operation type, index parameter threshold, index combination operation logic, and the like associated with each business index. In addition, the index configuration information can also indicate index data source, index data timeliness, index data capacity, report generation time, and the like associated with generating the statistical report. The index data source includes, for example, business system name, database type, database name, IP domain name, connection port, data synchronization frequency, and the like.

[0048] Next, in operation S220, initial index data in SQL structured query language form for constructing the report is obtained from the business system database.

[0049] In the embodiment, specifically, initial index data in the form of SQL (Structured Query Language) used for constructing the statistical report is acquired, SQL is a database query and programming language, and the initial index data can be log data generated by the statistical object in the running process, and specifically can be SQL string data containing business information. The acquired SQL string data contains multiple index fields, and contains operators and parameter values associated with each index field. Among them, the operators can include arithmetic operators (such as +, -, x, ÷), comparison operators (such as =, ≠, >, ≥, <, ≤, LIKE, IN, NOTIN, BETWEEN...AND, etc.), logical operators (such as AND, OR, NOT), set operators (such as FROM, WHERE, etc.), and connection operators (used to combine multiple strings or data values into a string).

[0050] Next, in operation S230, according to the index configuration information, a parsing process is performed on the initial index data in the form of SQL to obtain standard index data associated with each business index.

[0051] In the embodiment, specifically, the acquired initial index data can be SQL string data, which contains multiple index fields, and contains operators and parameter values associated with each index field. According to the index field identifier, index field interpretation, index field code, index classification identifier, index unit and other information indicated by the index configuration information, at least one business index used for generating the statistical report is determined based on each index field and the operators associated with each index field. Then, the parameter values associated with each business index are aggregated to obtain standard index data for each business index.

[0052] Next, in operation S240, the standard index data associated with each business index is aggregated to obtain an aggregation result.

[0053] In the embodiment, specifically, the index configuration information indicates the aggregation operation type, index parameter threshold, operation logic for combining different business indexes into a composite business index, and other information associated with each business index, wherein the operation logic between business indexes can include types such as "AND", "OR", "NOT", etc. According to the aggregation operation requirements for each business index indicated by the index configuration information, the standard index data associated with each business index is aggregated to obtain an aggregation result corresponding to each business index.

[0054] Next, in operation S250, based on the aggregation result, a statistical report is constructed and output.

[0055] In the embodiment, specifically, according to the aggregation operation result associated with each business index, a statistical report is constructed and output. When the statistical report type or report application requirement changes, or the business structure of the business to be analyzed is updated, a business personnel can adjust the analysis process for the initial index data and the aggregation operation process for the standard index data associated with each business index by changing the report configuration information, so as to dynamically update the generated statistical report.

[0056] According to the embodiment of the present disclosure, a report construction request is received, the report construction request indicating index configuration information associated with at least one business index; initial index data in the form of a structured query language (SQL) for constructing a report is obtained from a database of a business system; according to the index configuration information, analysis processing is performed on the initial index data in the form of SQL, to obtain standard index data associated with each business index; aggregation operation is performed on the standard index data associated with each business index, to obtain an aggregation operation result; and a statistical report is constructed and output based on the aggregation operation result. According to the obtained index configuration information, analysis processing is performed on the initial index data in the form of SQL, aggregation operation is performed on the standard index data associated with each business index, the aggregation operation result is obtained, and a statistical report is constructed. The report configuration method of this design is flexible, a business personnel can flexibly configure a filtering condition to obtain required statistical information, through automatic analysis and batch calculation, the report construction efficiency and performance can be effectively improved, and the frequent and urgent business iteration requirement can be quickly responded; the index operation amount in the report construction process is small, which is beneficial to effectively save the labor cost of report construction.

[0057] Figure 3 A flowchart of another report generation method according to an embodiment of the present disclosure is schematically shown in FIG. 3. Figure 3 As shown in FIG. 3, operation S230 can include operations S310-S320

[0058] In operation S310, discrete processing is performed on the initial index data in the form of SQL, to obtain intermediate index data based on index field discretization.

[0059] Next, in operation S320, according to the index field identifier and / or index field interpretation associated with each business index, aggregation processing is performed on the intermediate index data based on index field discretization, to obtain standard index data associated with each business index.

[0060] In the embodiment, specifically, a specified field or a specified operator is taken as a separator, to perform discrete processing on the initial index data in the form of SQL, to obtain intermediate index data based on index field discretization. For example, a logical operator AND is taken as a separator, to perform discrete processing on the initial index data.

[0061] Exemplarily, the SQL string constituting the initial indicator data includes: field A='a' AND field B LIKE 'b%' AND field C>'c' AND field D IN('a', 'b', 'c', 'd'), based on the logical operator AND, the SQL string is parsed into the intermediate indicator data based on the indicator field discretization: field A='a', field B LIKE 'b%', field C>'c' AND, field D IN('a', 'b', 'c', 'd').

[0062] Optionally, the SQL string data containing the logical operator OR, NOT is rejected, and the SQL string data is not taken as the batch parsing object. In addition, before parsing the SQL string data, the SQL string data is preprocessed, and the preprocessing manner includes, for example, screening out the left bracket or the right bracket appearing in the string data.

[0063] After obtaining the intermediate indicator data based on the indicator field discretization, according to the indicator field identification and / or the indicator field interpretation indicated by the indicator configuration information, the target indicator field meeting the requirement of the indicator configuration information is screened out from the multiple indicator fields contained in the intermediate indicator data as the business indicator field used for constructing the statistical report. The intermediate indicator data associated with the same business indicator field is aggregated, that is, the intermediate indicator data containing the same data attribute is aggregated, to obtain the standard indicator data associated with each business indicator.

[0064] For example, according to the requirement of the indicator configuration information, it is determined that a certain indicator field combined with a specific operator can be used as the business indicator field used for constructing the statistical report, and the parameter value associated with the indicator field combined with the specific operator is aggregated to obtain the standard indicator data associated with the corresponding business indicator. Exemplarily, according to the requirement of the indicator configuration information, it is determined that the indicator field A combined with the specific operator '=' is the business indicator field used for constructing the statistical report, and all parameter values corresponding to 'field A=' are aggregated to obtain the standard indicator data associated with 'field A='. Specifically, for example, the field A represents the credit limit, and all parameter values corresponding to 'credit limit=' are aggregated to obtain the standard indicator data associated with the business indicator 'credit limit'.

[0065] Figure 4 Exemplarily, a flowchart of another report generation method according to an embodiment of the present disclosure is shown in FIG. 4. Figure 4 As shown in FIG. 4, operation S240 can include any at least one of operations S410-S440.

[0066] In this embodiment, specifically, the index configuration information can include an aggregation operation type associated with each business index, and the operation S240 can include an operation S410 of performing an aggregation operation on the standard index data associated with each business index according to the aggregation operation type indicated by the index configuration information to obtain an aggregation operation result.

[0067] The aggregation operation type can include, for example, a counting operation, a summation operation, a mean value operation, a maximum value operation, a sorting operation, and the like, and the aggregation operation type indicates an operation manner of performing an aggregation operation on the standard index data associated with any business index to obtain statistical information, and specifically indicates an operation manner of performing an aggregation analysis on a large number of parameter values associated with any business index to obtain an aggregation operation result.

[0068] For example, the index field A combined with a specific operator “=” is a business index field used for constructing a statistical report, the field A represents a credit limit, and the index configuration information indicates that the aggregation operation type associated with the “credit limit” is a mean value operation, and a mean value operation is performed on the parameter values associated with the “credit limit” to obtain a credit limit average value used for constructing a statistical report.

[0069] The index configuration information can also include an index parameter threshold associated with each business index, and the operation S240 can include an operation S420 of performing an aggregation operation on the standard index data associated with each business index according to the aggregation operation type and the index parameter threshold indicated by the index configuration information.

[0070] The index parameter threshold, as an additional condition of the aggregation operation, can be used to further limit the value range of the index parameter values in the standard index data to which the aggregation operation is performed, or to limit the value range of the index parameter values in the aggregation operation result. For example, the index field A combined with a specific operator “=” is a business index field used for constructing a statistical report, the field A represents a credit limit, the index configuration information indicates that the aggregation operation type associated with the “credit limit” is a counting operation, and the index parameter threshold is M, and a counting operation is performed on the parameter values associated with the “credit limit” and greater than M to obtain a number of credit limit values greater than M used for constructing a statistical report.

[0071] The index configuration information can also include operation logic for combining different business indexes into a composite business index, and at this time, the operation S240 can include an operation S430 of performing an aggregation operation on the standard index data associated with each to-be-combined business index according to the operation logic indicated by the index configuration information and used for combining different business indexes into a composite business index, and obtaining an aggregation operation result associated with the composite business index.

[0072] The operation logic between the business indicators can include, for example, AND, OR, NOT, and the like, and the operation logic indicates a combination manner of combining different business indicators into a composite business indicator. The composite business indicator combined by different business indicators based on the operation logic can include, for example, "field A>" OR "field B<", "field C>" AND "field D>", "field A>" NOT "field C>", and the like. According to the operation logic indicated by the indicator configuration information, and according to at least two business indicators to be combined (field A>, field B<, field C>, field D>) associated with the operation logic, the parameter values associated with each business indicator to be combined are aggregated to obtain an aggregated operation result associated with the composite business indicator. Exemplarily, "debt paying ability" belongs to a composite business indicator, which is composed of multiple business indicators such as "cash ratio", "cash flow ratio", and "guarantee ratio" based on a preset operation logic.

[0073] Optionally, in a case where a certain business indicator is a summary indicator obtained by summarizing at least two same type sub-indicators, the operation S240 can include an operation S440: performing an aggregated operation on the standard indicator data associated with each sub-indicator to obtain an aggregated operation result associated with each sub-indicator; and summarizing the aggregated operation results associated with each sub-indicator to obtain an aggregated operation result associated with the business indicator. The summarizing manner can include direct summation or de-duplication summation.

[0074] Figure 5 A block diagram of a report generation apparatus according to an embodiment of the present disclosure is schematically shown.

[0075] As shown in Figure 5 , the apparatus 500 includes a receiving module 501, a first processing module 502, a second processing module 503, a third processing module 504, and a fourth processing module 505.

[0076] Specifically, the receiving module 501 is configured to receive a report construction request, the report construction request indicating indicator configuration information associated with at least one business indicator; the first processing module 502 is configured to obtain initial indicator data in the form of a structured query language (SQL) from a business system database for constructing a report; the second processing module 503 is configured to perform parsing processing on the initial indicator data in the form of SQL according to the indicator configuration information to obtain standard indicator data associated with each business indicator; the third processing module 504 is configured to perform an aggregated operation on the standard indicator data associated with each business indicator to obtain an aggregated operation result; and the fourth processing module 505 is configured to construct a statistical report based on the aggregated operation result and output the statistical report.

[0077] According to the embodiment of the present disclosure, a report building request is received, the report building request indicating index configuration information associated with at least one business index; initial index data in the form of a structured query language (SQL) used for building a report is obtained from a database of a business system; according to the index configuration information, a parsing process is performed on the initial index data in the form of SQL to obtain standard index data associated with each business index; an aggregation operation is performed on the standard index data associated with each business index to obtain an aggregation operation result; and a statistical report is built and output based on the aggregation operation result. According to the obtained index configuration information, the parsing process is performed on the initial index data in the form of SQL, the aggregation operation is performed on the standard index data associated with each business index, the aggregation operation result is obtained, and the statistical report is built. The report configuration method of this design is flexible, and a business personnel can flexibly configure a filtering condition to obtain required statistical information. Through automatic parsing and batch calculation, the report building efficiency and performance can be effectively improved, and the frequent and urgent business iteration requirements can be quickly responded. The index operation amount in the report building process is small, which is beneficial to effectively save the labor cost of report building.

[0078] As a feasible manner, the index configuration information includes index field identifiers and / or index field meanings associated with each business index; and the second processing module includes: a first processing submodule configured to perform discrete processing on the initial index data in the form of SQL to obtain intermediate index data based on index field discretization; and a second processing submodule configured to perform aggregation processing on the intermediate index data based on index field discretization according to the index field identifiers and / or the index field meanings associated with each business index to obtain the standard index data associated with each business index.

[0079] As a feasible manner, the index configuration information includes aggregation operation types associated with each business index; and the third processing module includes: a third processing submodule configured to perform aggregation operation on the standard index data associated with each business index according to the aggregation operation types indicated by the index configuration information to obtain the aggregation operation result.

[0080] As a feasible manner, the index configuration information further includes index parameter thresholds associated with each business index; and the third processing module includes: a fourth processing submodule configured to perform aggregation operation on the standard index data associated with each business index according to the aggregation operation types and the index parameter thresholds indicated by the index configuration information to obtain the aggregation operation result.

[0081] As a feasible manner, the index configuration information further comprises operation logic for combining different service indexes into a composite service index; and the third processing module comprises: a fifth processing submodule, configured to perform an aggregation operation on the standard index data associated with each to-be-combined service index according to the operation logic and at least two to-be-combined service indexes associated with the operation logic, to obtain an aggregation operation result associated with the composite service index.

[0082] As a feasible manner, in a case where a certain service index is a summary index obtained by summarizing at least two same-type sub-indexes, the third processing module comprises: a sixth processing submodule, configured to perform an aggregation operation on the standard index data associated with each sub-index, to obtain an aggregation operation result associated with each sub-index; and a seventh processing submodule, configured to perform a summary operation on the aggregation operation results associated with each sub-index, to obtain an aggregation operation result associated with the service index.

[0083] As a feasible manner, the aggregation operation comprises at least one of a counting operation, a summation operation, a mean value operation, and a maximum / minimum value operation.

[0084] It should be noted that, in the embodiments of the present disclosure, the implementation manners of the device part are the same as or similar to the implementation manners of the method part, and thus will not be described herein.

[0085] Any one or at least part of functions of the modules according to the embodiments of the present disclosure can be implemented in one module. Any one or more of the modules according to the embodiments of the present disclosure can be split into multiple modules for implementation. Any one or more of the modules according to the embodiments of the present disclosure can be implemented at least in part as a hardware circuit, such as a field programmable gate array (FPGA), a programmable logic array (PLA), a system on chip, a system on board, a system in package, an application specific integrated circuit (ASIC), or any other reasonable manner of hardware or firmware through integration or packaging of circuits, or in any one of software, hardware and firmware or in a proper combination of any one or more of them. Alternatively, one or more of the modules according to the embodiments of the present disclosure can be implemented at least in part as computer program modules, which can perform corresponding functions when the computer program modules are run.

[0086] For example, any plurality of the receiving module 501, the first processing module 502, the second processing module 503, the third processing module 504, and the fourth processing module 505 can be combined into one module, or any one of these modules can be split into multiple modules. Alternatively, at least part of the functionality of one or more of these modules can be combined with at least part of the functionality of other modules and implemented in one module. According to embodiments of the present disclosure, at least one of the receiving module 501, the first processing module 502, the second processing module 503, the third processing module 504, and the fourth processing module 505 can be at least partially implemented as hardware circuitry, such as a field-programmable gate array (FPGA), a programmable logic array (PLA), a system-on-a-chip, a system-on-a-substrate, a system-on-package, an application-specific integrated circuit (ASIC), or any other reasonable means of integrating or packaging the circuitry, or implemented in software, hardware, or firmware, or in any suitable combination of any of these three implementation methods. At least one of the receiving module 501, the first processing module 502, the second processing module 503, the third processing module 504, and the fourth processing module 505 can be at least partially implemented as a computer program module, which can perform corresponding functions when the computer program module is run.

[0087] Figure 6 A block diagram schematically illustrates an electronic device 600 suitable for implementing the processing method and processing apparatus according to embodiments of the present disclosure. Figure 6 The electronic device 600 shown is merely an example and should not be construed as limiting the functionality and scope of use of the embodiments disclosed herein.

[0088] like Figure 6 As shown, an electronic device 600 according to an embodiment of the present disclosure includes a processor 601, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 602 or a program loaded from a storage portion 608 into a random access memory (RAM) 603. The processor 601 may include, for example, a general-purpose microprocessor (e.g., a CPU), an instruction set processor and / or an associated chipset and / or a special-purpose microprocessor (e.g., an application-specific integrated circuit (ASIC)), etc. The processor 601 may also include onboard memory for caching purposes. The processor 601 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present disclosure.

[0089] In the RAM 603, various programs and data required for the operation of the electronic device 600 are stored. The processor 601, the ROM 602, and the RAM 603 are connected to each other via the bus 604. The processor 601 performs various operations of the method flow according to the embodiments of the present disclosure by executing the programs in the ROM 602 and / or the RAM 603. It should be noted that the programs can also be stored in one or more memories other than the ROM 602 and the RAM 603. The processor 601 can also perform various operations of the method flow according to the embodiments of the present disclosure by executing the programs stored in the one or more memories.

[0090] According to an embodiment of the present disclosure, the electronic device 600 can further include an input / output (I / O) interface 605, which is also connected to the bus 604. The electronic device 600 can further include one or more of the following components connected to the I / O interface 605: an input part 606 including a keyboard, a mouse, etc.; an output part 607 including a display such as a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage part 608 including a hard disk, etc.; and a communication part 609 including a network interface card such as a LAN card, a modem, etc. The communication part 609 performs communication processing via a network such as the Internet. A drive 610 is also connected to the I / O interface 605 as necessary. A removable medium 611 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc. is attached to the drive 610 as necessary, so that a computer program read out therefrom is installed in the storage part 608 as necessary.

[0091] According to an embodiment of the present disclosure, the method flow according to the embodiments of the present disclosure can be implemented as a computer software program. For example, the embodiments of the present disclosure include a computer program product including a computer program carried on a computer-readable storage medium, the computer program containing program codes for executing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network by the communication part 609, and / or installed from the removable medium 611. When the computer program is executed by the processor 601, the above-described functions defined in the system according to the embodiments of the present disclosure are performed. According to an embodiment of the present disclosure, the system, device, apparatus, module, unit, etc. described above can be implemented by computer program modules.

[0092] The present disclosure also provides a computer-readable storage medium, which can be included in the device / apparatus / system described in the above embodiments; or can exist separately without being assembled into the device / apparatus / system. The above computer-readable storage medium carries one or more programs, which when executed, implement the methods according to the embodiments of the present disclosure.

[0093] According to an embodiment of the present disclosure, the computer readable storage medium can be a nonvolatile computer readable storage medium, for example, can include but is not limited to: 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), a portable compact disc read only memory (CD-ROM), an optical storage device, a magnetic storage device, or any appropriate combination thereof. In the present disclosure, the computer readable storage medium can be any tangible medium that contains or stores a program that can be used by or in connection with an instruction execution system, apparatus, or device. For example, according to an embodiment of the present disclosure, the computer readable storage medium can include one or more memories such as the ROM 602 and / or the RAM 603 described above and / or one or more memory other than the ROM 602 and the RAM 603.

[0094] Embodiments of the present disclosure also include a computer program product, which includes a computer program containing program codes for executing the method provided by the embodiments of the present disclosure, and when the computer program product is run on an electronic device, the program codes are used to make the electronic device implement the method for detecting file upload vulnerabilities provided by the embodiments of the present disclosure.

[0095] When the computer program is executed by the processor 601, the above-mentioned functions defined in the system / apparatus of the embodiments of the present disclosure are executed. According to an embodiment of the present disclosure, the above-mentioned system, apparatus, module, unit, etc. can be implemented by computer program modules.

[0096] In one embodiment, the computer program can rely on tangible storage media such as optical storage media, magnetic storage media, etc. In another embodiment, the computer program can also be transmitted, distributed, downloaded and installed in the form of signals on a network medium, and be downloaded and installed through the communication part 609, and / or be installed from the detachable medium 611. The program codes contained in the computer program can be transmitted by any appropriate network medium, including but not limited to wireless, wired, etc., or any appropriate combination thereof.

[0097] According to an embodiment of the present disclosure, program code for execution of the computer programs provided by the embodiments of the present disclosure can be written in any combination of one or more programming languages, and specifically, these computer programs can be implemented using a high-level procedural and / or object-oriented programming language, and / or an assembly / machine language. The programming languages include, but are not limited to, such as Java, C++, python, "C" language, or similar programming languages. The program code can be executed entirely on a user computing device, partially on a user device, partially on a remote computing device, or entirely on a remote computing device or server. In the case involving a remote computing device, the remote computing device can be connected to the user computing device through any kind of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computing device (for example, connected through the Internet by using an Internet service provider).

[0098] The flow diagrams and the block diagrams in the drawings are illustrations of possible architectures, functions, and operations for systems, methods, and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flow diagrams or block diagrams can represent a module, a segment, or a 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 blocks can 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 be executed in the reverse order, depending on the functionality involved. It will also be noted that each block of the block diagrams and / or flow diagrams, and combinations thereof, can be implemented by special purpose hardware-based systems that perform the specified functions or operations, or combinations of special purpose hardware and computer instructions.

[0099] The embodiments of the present disclosure are described above. However, these embodiments are merely for illustrative purposes, and are not intended to limit the scope of the present disclosure. Those skilled in the art can make various substitutions and modifications without departing from the scope of the present disclosure, and these substitutions and modifications should fall within the scope of the present disclosure.

Claims

1. A report generation method, comprising: receiving a report building request, the report building request indicating metric configuration information associated with at least one business metric; obtaining initial metric data in a form of SQL (Structured Query Language) for building a report from a database of a business system; performing a parsing process on the initial metric data in the form of SQL according to the metric configuration information to obtain standard metric data associated with each of the business metrics; performing an aggregation operation on the standard metric data associated with each of the business metrics to obtain an aggregation operation result; building a statistical report based on the aggregation operation result and outputting the statistical report; wherein the metric configuration information comprises at least one of a metric field identifier, a metric field interpretation, an aggregation operation type, a metric parameter threshold value, and an operation logic associated with each of the business metrics; the performing of the parsing process on the initial metric data in the form of SQL according to the metric configuration information to obtain the standard metric data associated with each of the business metrics comprises: performing a discretization process on the initial metric data in the form of SQL to obtain intermediate metric data based on discretization of metric fields; filtering the intermediate metric data based on the discretization of metric fields to obtain target metric data according to the metric field identifier and / or the metric field interpretation associated with each of the business metrics, and performing an aggregation operation on the target metric data to obtain the standard metric data associated with each of the business metrics; wherein the method further comprises: dynamically configuring the metric configuration information based on a report type and / or a business requirement. 2.The method of claim 1, wherein the performing of the aggregation operation on the standard metric data associated with each of the business metrics to obtain the aggregation operation result comprises: performing the aggregation operation on the standard metric data associated with each of the business metrics according to the aggregation operation type indicated by the metric configuration information to obtain the aggregation operation result. 3.The method of claim 2, wherein the performing of the aggregation operation on the standard metric data associated with each of the business metrics to obtain the aggregation operation result comprises: performing the aggregation operation on the standard metric data associated with each of the business metrics according to the aggregation operation type and the metric parameter threshold value indicated by the metric configuration information to obtain the aggregation operation result. 4.The method of claim 1, wherein the performing of the aggregation operation on the standard metric data associated with each of the business metrics to obtain the aggregation operation result comprises: performing the aggregation operation on the standard metric data associated with each of the business metrics according to the operation logic and at least two business metrics to be combined associated with the operation logic to obtain an aggregation operation result associated with a composite business metric. 5.The method of claim 1, wherein in a case where a certain business metric is a summary metric obtained by summarizing at least two same-type sub-metrics, the performing of the aggregation operation on the standard metric data associated with each of the business metrics to obtain the aggregation operation result comprises: The standard index data associated with each of the sub-indices is aggregated to obtain an aggregation operation result associated with each of the sub-indices; The aggregation operation results associated with each of the sub-indices are summarized to obtain an aggregation operation result associated with the business index.

6. The method of any one of claims 1 to 5, wherein, The aggregation operation includes at least one of counting operation, summation operation, mean value operation, and extreme value operation.

7. A report generation apparatus, comprising: a receiving module configured to receive a report construction request, the report construction request indicating index configuration information associated with at least one business index, wherein the index configuration information includes at least one of index field identifier, index field interpretation, aggregation operation type, index parameter threshold, and operation logic associated with each of the business indices; a first processing module configured to obtain initial index data in the form of structured query language (SQL) from a business system database for constructing a report; a second processing module configured to perform parsing processing on the initial index data in the form of SQL according to the index configuration information to obtain standard index data associated with each of the business indices; a third processing module configured to perform aggregation operation on the standard index data associated with each of the business indices to obtain an aggregation operation result; a fourth processing module configured to construct a statistical report based on the aggregation operation result and output the statistical report; wherein the second processing module includes: a first processing submodule configured to perform discrete processing on the initial index data in the form of SQL to obtain intermediate index data based on index field discretization; a second processing submodule configured to filter the intermediate index data based on index field discretization according to the index field identifier and / or index field interpretation associated with each of the business indices to obtain target index data, and perform aggregation processing on the target index data to obtain the standard index data associated with each of the business indices; wherein the report generation apparatus is further configured to dynamically configure the index configuration information based on report type and / or business requirement.

8. An electronic device, comprising: one or more processors; and a memory configured to store one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-6.

9. A computer-readable storage medium having stored thereon executable instructions that, when executed by a processor, cause the processor to implement the method of any one of claims 1-6.

10. A computer program product, comprising a computer program that, when executed by a processor, implements the method of any one of claims 1-6.

Images