CN112700328B - Automatic index analysis method, device, equipment and storage medium - Google Patents
Automatic index analysis method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN112700328B CN112700328B CN202110032296.5A CN202110032296A CN112700328B CN 112700328 B CN112700328 B CN 112700328B CN 202110032296 A CN202110032296 A CN 202110032296A CN 112700328 B CN112700328 B CN 112700328B
- Authority
- CN
- China
- Prior art keywords
- index
- sub
- indexes
- formulas
- calculation formula
- 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
Links
- 238000004458 analytical method Methods 0.000 title claims abstract description 53
- 238000004364 calculation method Methods 0.000 claims abstract description 187
- 238000000034 method Methods 0.000 claims abstract description 28
- 238000004590 computer program Methods 0.000 claims description 10
- 238000013215 result calculation Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 6
- 238000012545 processing Methods 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 2
- 238000009960 carding Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Marketing (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an automatic index analysis method, device, equipment and storage medium, wherein the method comprises the following steps: receiving a form submitted by supervision, acquiring all indexes contained in the form as indexes to be calculated, and acquiring a calculation formula used for calculating each index to be calculated as an index calculation formula; determining the level of the sub-formulas contained in each index calculation formula, and sequentially calculating the sub-formulas contained in each index calculation formula according to the level from low to high to obtain the result of each sub-formula; the sub-formulas of the lowest level are formulas capable of being directly assigned, and the sub-formulas of any other level are formulas capable of calculating corresponding results based on the results of the sub-formulas of the lower level; based on the result of each sub-formula contained in each index calculation formula, calculating to obtain the final result of each index calculation formula, and returning the final result. Therefore, the time required by the value calculation of the index is greatly saved, and the timeliness of the operations such as the value calculation and the subsequent analysis of the index is effectively improved.
Description
Technical Field
The present invention relates to the field of data analysis technologies, and in particular, to an automatic index analysis method, apparatus, device, and storage medium.
Background
Financial institutions need to report a wide variety of forms to people banks and banking authorities, which are often composed of different kinds of indicators; in order to be able to perform a corresponding analysis based on these forms, it is generally necessary to first calculate the values of the various indicators contained in the forms; in the prior art, the calculation of the values of the various indexes in the form is usually realized by staff, so that a great deal of time is required to be consumed, and the timeliness is poor.
Disclosure of Invention
The invention aims to provide an automatic index analysis method, device, equipment and storage medium, which can greatly save the time required by the value calculation of indexes, and further effectively improve the timeliness of the operations such as the value calculation and the subsequent analysis of the indexes.
In order to achieve the above object, the present invention provides the following technical solutions:
an index automatic analysis method, comprising:
receiving a form submitted by supervision, acquiring all indexes contained in the form as indexes to be calculated, and acquiring a calculation formula used for calculating each index to be calculated as an index calculation formula;
determining the level of the sub-formulas contained in each index calculation formula, and sequentially calculating the sub-formulas contained in each index calculation formula according to the level from low to high to obtain the result of each sub-formula; the sub-formulas of the lowest level are formulas capable of being directly assigned, and the sub-formulas of any other level are formulas capable of calculating corresponding results based on results of the corresponding sub-formulas of the level lower than any level;
and calculating a final result of each index calculation formula based on the result of each sub-formula contained in each index calculation formula, and returning the final result.
Preferably, after all the indexes contained in the form are to-be-calculated indexes, the method further includes:
respectively comparing each index to be calculated with each basic index in a basic index library, and determining the index to be calculated which is the same as any basic index as an A-type index and the other indexes to be calculated except the A-type index as comprehensive indexes;
accordingly, determining the hierarchy of the sub-formulas contained in each index calculation formula includes:
and determining that all the sub-formulas contained in the class A index are the lowest levels, and determining that at least two different levels respectively correspond to the sub-formulas contained in the comprehensive class index.
Preferably, after determining that the other indexes to be calculated except the class a index are comprehensive class indexes, the method further includes:
determining that the comprehensive indexes containing preset characters in the used index calculation formula are B-class indexes, and the comprehensive indexes except the B-class indexes are C-class indexes;
and determining a conditional sub-formula which is contained in the class-C index and does not belong to any hierarchy, and summarizing partial data used for obtaining values assigned to the basic index to obtain a result of the conditional sub-formula, so as to obtain a final result of each index calculation formula based on the result of the conditional sub-formula.
Preferably, the calculation formula used for obtaining and calculating each index to be calculated is an index calculation formula, including:
and acquiring a calculation formula used for calculating each index to be calculated from a calculation formula currently input by a user or a stored calculation formula input by the user in advance as an index calculation formula.
Preferably, the sub-formula included in each index calculation formula is calculated sequentially in a hierarchy from low to high, including:
when a plurality of different sub-formulas belonging to the same hierarchy are calculated, a plurality of threads are utilized to calculate the plurality of different sub-formulas belonging to the same hierarchy in parallel.
Preferably, after calculating the final result of each index calculation formula, the method further includes:
storing each index to be calculated and the corresponding final result, and outputting the corresponding index to be calculated and the corresponding final result when receiving an external query instruction.
Preferably, returning the final result includes:
and displaying each index to be calculated and the corresponding final result in a form.
An index automatic analysis device, comprising:
an acquisition module for: receiving a form submitted by supervision, acquiring all indexes contained in the form as indexes to be calculated, and acquiring a calculation formula used for calculating each index to be calculated as an index calculation formula;
a first calculation module for: determining the level of the sub-formulas contained in each index calculation formula, and sequentially calculating the sub-formulas contained in each index calculation formula according to the level from low to high to obtain the result of each sub-formula; the sub-formulas of the lowest level are formulas capable of being directly assigned, and the sub-formulas of any other level are formulas capable of calculating corresponding results based on results of the corresponding sub-formulas of the level lower than any level;
a second calculation module for: and calculating a final result of each index calculation formula based on the result of each sub-formula contained in each index calculation formula, and returning the final result.
An index automatic analysis device, comprising:
a memory for storing a computer program;
an analyzer for implementing the steps of the method for automatic analysis of an indicator according to any one of the preceding claims when executing said computer program.
A computer readable storage medium having stored thereon a computer program which when executed by an analyzer performs the steps of the method for automatic analysis of an index as defined in any one of the preceding claims.
The invention provides an index automatic analysis method, device, equipment and storage medium, wherein the method comprises the following steps: receiving a form submitted by supervision, acquiring all indexes contained in the form as indexes to be calculated, and acquiring a calculation formula used for calculating each index to be calculated as an index calculation formula; determining the level of the sub-formulas contained in each index calculation formula, and sequentially calculating the sub-formulas contained in each index calculation formula according to the level from low to high to obtain the result of each sub-formula; the sub-formulas of the lowest level are formulas capable of being directly assigned, and the sub-formulas of any other level are formulas capable of calculating corresponding results based on results of the corresponding sub-formulas of the level lower than any level; and calculating a final result of each index calculation formula based on the result of each sub-formula contained in each index calculation formula, and returning the final result. After receiving the forms submitted by supervision, the method acquires all indexes contained in the forms and calculation formulas required by calculating the values of the indexes, and because the values of the sub formulas of a high level are required to be calculated based on the values of the sub formulas of a lower level, the method calculates corresponding sub formulas of each calculation formula from low to high according to the levels of the sub formulas contained in the calculation formulas, and finally substitutes the values of the sub formulas into the calculation formulas to obtain the values of the corresponding indexes and returns the values. Therefore, after the indexes and the corresponding calculation formulas in the form are obtained, the calculation of the values of the corresponding indexes can be automatically realized based on the calculation formulas, so that the time required by the calculation of the values of the indexes is greatly saved, and the timeliness of the operations such as the calculation of the values of the indexes, the subsequent analysis and the like is effectively improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only embodiments of the present invention, and that other drawings can be obtained according to the provided drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of an automatic index analysis method according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating an example of a calculation formula of a class B index in an automatic index analysis method according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating an example of the generation of a base index library during the calculation of the values of class B indices in an automatic index analysis method according to an embodiment of the present invention;
FIG. 4 is a first exemplary diagram of a calculation formula of a B-class index after corresponding replacement in an automatic index analysis method according to an embodiment of the present invention;
FIG. 5 is an exemplary diagram of storing the calculated values of the class B indicators in a base indicator library in an automatic indicator analysis method according to an embodiment of the present invention;
FIG. 6 is a second exemplary diagram of a calculation formula of a B-class index after corresponding replacement in an automatic index analysis method according to an embodiment of the present invention;
fig. 7 is a schematic structural diagram of an automatic index analysis device according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1, a flowchart of an automatic index analysis method according to an embodiment of the present invention may include:
s11: and receiving the form submitted by supervision, acquiring all indexes contained in the form as indexes to be calculated, and acquiring a calculation formula used for calculating each index to be calculated as an index calculation formula.
The execution subject of the automatic index analysis method provided by the embodiment of the invention can be a corresponding automatic index analysis device. It should be noted that, the present application may be applied to the financial industry, the corresponding form for supervising and reporting may be a form for reporting by a financial institution, and the index in the form may include the index of the financial industry, such as financing amount, net profit, etc.; of course, the method can also be applied to other fields according to actual needs, and the method is within the protection scope of the invention.
After receiving the form submitted by supervision, all indexes contained in the form can be obtained as indexes to be analyzed, and then calculation formulas corresponding to the indexes respectively are obtained as corresponding index calculation formulas; when analysis of any index is implemented, a calculation formula of the any index is needed to be used for corresponding calculation, so that a value of the any index (in the application, the value of the index or the formula is a corresponding result) is obtained, and the value is assigned to the any index for subsequent processing such as corresponding analysis based on the value of the any index.
S12: determining the level of the sub-formulas contained in each index calculation formula, and sequentially calculating the sub-formulas contained in each index calculation formula according to the level from low to high to obtain the result of each sub-formula; the sub-formula of the lowest level is a formula capable of being directly assigned, and the sub-formula of any other level is a formula capable of calculating a corresponding result based on a result of the corresponding sub-formula of a level lower than any level.
Any calculation formula contains at least one formula, which can be called a sub-formula, and when determining the sub-formula, the formula between any two adjacent operation symbols can be determined to be the corresponding sub-formula; the most basic sub-formula is a formula capable of being directly assigned, namely, the formula is the sub-formula of the lowest level, and the values of the sub-formulas of any level other than the lowest level are calculated by using the values of the sub-formulas lower than any level; in order to implement calculation of the corresponding value of each index, the embodiment of the present application may determine the level of the sub-formula included in each index calculation formula first, and because the value of the sub-formula of the higher level needs to be calculated based on the value of the sub-formula of the lower level, for any index calculation formula in each index calculation formula, calculate the sub-formula of the lowest level included in any index calculation formula first, calculate the sub-formula of the second lowest level included in any index calculation formula, …, until calculate the sub-formula of the highest level included in any index calculation formula, thereby calculate the value corresponding to each sub-formula included in any index calculation formula according to the order from low to high, and finally substitute the values of these sub-formulas into any index calculation formula, so as to calculate the value of any index calculation formula.
For example: the index calculation formula is c0001=a0001+a0009+b0001, wherein a0001 and a0009 are the sub-formulas of the lowest level capable of direct assignment, and b0001=a0001+a0009, that is, B0001 needs to be calculated by using a0001 and a0009, so that the level of B0001 is higher than a0001 and a0009; when the sub-formulas are calculated from low to high according to the hierarchy, direct assignment is respectively carried out on A0001 and A0009, so that A0001=34.56 and A0009=36.13 are obtained; then substituting the values of a0001 and a0009 into b0001=a0001+a0009, so as to obtain b0001= 70.69; finally, values of B0001, a0001 and a0009 are all substituted into c0001=a0001+a0009+b0001, resulting in c0001= 141.38.
S13: based on the result of each sub-formula contained in each index calculation formula, calculating to obtain the final result of each index calculation formula, and returning the final result.
After the value of each sub-formula contained in the index calculation formula is calculated, the value of each sub-formula can be substituted into the corresponding index calculation formula, and the value of the index calculation formula can be calculated and returned, so that the staff can conveniently realize corresponding analysis and other processing based on the returned value.
After receiving the forms submitted by supervision, the method acquires all indexes contained in the forms and calculation formulas required by calculating the values of the indexes, and because the values of the sub formulas of a high level are required to be calculated based on the values of the sub formulas of a lower level, the method calculates corresponding sub formulas of each calculation formula from low to high according to the levels of the sub formulas contained in the calculation formulas, and finally substitutes the values of the sub formulas into the calculation formulas to obtain the values of the corresponding indexes and returns the values. Therefore, after the indexes and the corresponding calculation formulas in the form are obtained, the calculation of the values of the corresponding indexes can be automatically realized based on the calculation formulas, so that the time required by the calculation of the values of the indexes is greatly saved, and the timeliness of the operations such as the calculation of the values of the indexes, the subsequent analysis and the like is effectively improved.
The method for automatically analyzing the index provided by the embodiment of the invention can further comprise the following steps after all indexes contained in the acquired form are indexes to be calculated:
respectively comparing each index to be calculated with each basic index in a basic index library, and determining the index to be calculated which is the same as any basic index as an A-type index and the other indexes to be calculated except the A-type index as comprehensive indexes;
accordingly, determining the hierarchy of the sub-formulas contained in each index calculation formula includes:
and determining that all the sub-formulas contained in the class A indexes are the lowest levels, and determining that the sub-formulas contained in the comprehensive class indexes at least correspond to two different levels respectively.
In order to facilitate the analysis of the indexes, the indexes contained in the form can be classified after being acquired; specifically, the indexes can be initially divided into two types, wherein the first type is the index which does not depend on other indexes and can obtain the value thereof only through business logic calculation, namely the index which can be directly assigned, and the second type is the index which needs to carry out addition, subtraction, multiplication and division four operations or other operations on the basis of other indexes to obtain the value thereof, namely the index which needs to calculate the sub-formulas of at least two different levels, and the second type is the comprehensive type index. Based on the above, not only can the sub-formulas contained in the class A index be determined to be the sub-formulas with the lowest hierarchy, but also the sub-formulas contained in the comprehensive class index can be determined to contain at least two sub-formulas with different hierarchies, so that subsequent calculation is realized according to the hierarchies.
The method for automatically analyzing the index provided by the embodiment of the invention can further comprise the following steps after determining that other indexes to be calculated except the class A index are comprehensive indexes:
determining the comprehensive class indexes including preset characters in the used index calculation formula as class B indexes, and the other comprehensive class indexes except the class B indexes as class C indexes;
and determining a conditional sub-formula which is contained in the class-C index and does not belong to any hierarchy, and summarizing partial data used for obtaining values assigned to the basic index to obtain a result of the conditional sub-formula, so that a final result of each index calculation formula is obtained based on the result calculation of the conditional sub-formula.
In order to further facilitate analysis of the index, the embodiment of the application may further divide the comprehensive index into a class B index and a class C index. Specifically, the comprehensive class indexes are indexes of sub-formulas containing at least two levels, but the class C indexes are more special sub-formulas relative to the class B indexes, namely conditional sub-formulas; when assigning a class A index, the value assigned to the class A index may be obtained by summarizing a plurality of data, and the conditional sub-formula is obtained by summarizing part of the data required by the value summarization of the class A index, for example, a certain class A index is the sum of all financing amounts, and the conditional sub-formula in a class C index is the sum of financing amounts greater than a certain amount; therefore, the method and the device can obtain the value of the conditional sub-formula contained in the class-C index, and then substitutes the value of the conditional sub-formula into the class-C index, so that the class-C index can calculate the value based on the value of each sub-formula and the value of the conditional sub-formula, and the index calculation automation is further improved.
It should be noted that, the values of the indexes may be obtained by performing four operations or other operations on basic data and other arbitrary indexes, and the corresponding calculation formulas may include basic data and other arbitrary indexes that need to participate in the calculation, and each index has a corresponding index code, that is, the index code can uniquely identify the corresponding index, and at this time, the corresponding index may be represented by the index code and added into the calculation formulas, so the calculation formulas of the indexes may be combined by numbers, operation symbols and index codes. When the classification of the class A index, the class B index and the class C index is realized, the values of the basic indexes can be automatically calculated in advance by utilizing the SQL script configured by the system, and the basic indexes and the values of the basic indexes are all put into a basic index library; matching each index code in the form from a corresponding index calculation formula by using a regular expression, putting the index code into the MAP, traversing the index in the MAP, checking whether the index code is in a basic index library (or directly checking whether each index in the form is stored in the basic index library), and if so, indicating that the index code is a class A index, otherwise, indicating that the index code is a comprehensive class index; judging whether the calculation formula of the comprehensive class indexes contains an SQLVAL character string (a preset character string and a character string representing a conditional sub-formula), if so, automatically classifying the comprehensive class indexes into C class indexes, and if the comprehensive class indexes are the C class indexes, automatically classifying the rest comprehensive class indexes into B class indexes, thereby automatically realizing the classification of the indexes contained in the form through the mode. And when the class A index in the form needs to be assigned, the corresponding value can be obtained from the basic index library and assigned.
The method for automatically analyzing the index provided by the embodiment of the invention, which is used for obtaining the calculation formula for calculating each index to be calculated as the index calculation formula, can comprise the following steps:
and acquiring a calculation formula used for calculating each index to be calculated from a calculation formula currently input by a user or a stored calculation formula input by the user in advance as an index calculation formula.
In a specific application scenario, the calculation formulas of the indexes may be non-fixed formulas, which may be formulas defined by the user, so that after the user defines the corresponding formulas, the automatic index analysis device may automatically calculate the index values according to the formulas. Specifically, the calculation formula used by the obtained index can be currently input by a user or can be input and stored in advance by the user, and the calculation formula is within the protection scope of the invention; therefore, a user can realize the configuration of the calculation formula at any time according to actual needs, and therefore, the user can configure the calculation formula of the index at will, and the index automatic analysis device can automatically realize the calculation of the index based on the calculation formula, so that the index analysis automation is greatly increased, and the maintenance cost is reduced. Specifically, a supervision report bazaar may be created in a data warehouse of the index automatic analysis device, service logic is combed in the bazaar, a calculation method of class a indexes is configured, if the class a index is a0001, and a corresponding calculation formula may be configured as a001=sqlval (SELECT BAL FROM ups. Index_ TABLE WHERE INDEX = 'a 0001'); a calculating method of the B class index is configured, if the B class index is B0001, the corresponding calculating formula can be B0001 = A0001+ A0009+999.99+ A0018 x 0.66; the calculation method for configuring the class C index, for example, the class C index is B0001, and the corresponding calculation formula may be c0001=a0001+a0009+sqlval (SELECT SUM (BAL) FROM ups.index_table WHERE a0001 IN ('3', '4', '5')) +b0002×66.66. If the class B index and the class C index have the same level dependency or more dimensions, the sub-formulas contained in the class B index and the class C index can be set as corresponding levels, for example, B0002=b0001+a0008, if the level of B0001 is ii, the level of B0002 can be iii, and the level of the sub-formula in the class C index can also be analogized backward according to the principle.
In addition, the highest level corresponding to the sub-formula contained in each index can be set as the level of the index; after the calculation methods of the indexes are configured, for each index, the corresponding sub-formula can be calculated according to the level from low to high of the sub-formula contained in the index calculation formula, and for all indexes, the corresponding index calculation formula can be calculated according to the level from low to high of the sub-formula, so that the values used in calculation are all calculated values.
When class A indexes are calculated, a function EXEC (SQL) of JAVA JDBC can be executed, and the executed result is assigned to the corresponding class A indexes, and the obtained result can be in the form of: a0001 =34.56.
When calculating the class B index, firstly replacing index codes contained in a calculation formula of the class B index with specific values respectively by using a REPLACE function, for example, replacing B0001 = a0001+ a0009+999.99+ a0018 x 0.66 to obtain B0001 = 34.56+223.35+999.99+36.24 x 0.66, and then directly obtaining the value of B0001 by using a JAVA calculation function, wherein B0001 = calculate (34.56 +223.35+999.99+36.24 x 0.66) = 854.1324). If the class B index contains multi-level dependence, namely contains sub formulas of different levels, the method is used for recursively calculating the final index value. Class B index multi-level dependency recursion example: the calculation formula of the class B index is shown in fig. 2, and may include: b0001 A0001+a0009+999.99+a0018×0.66, b0002=b0001×0.9, b0003=b0002+a0001; the calculation flow is as follows:
the first step: as shown in fig. 3, the values of a0001, a0009, and a0018 are automatically calculated by packaging sql of python, perl, etc. to generate a base index library, yielding a0001=1000, a0009=3000, a0018=9000.
And a second step of: the calculation formula in fig. 2 is replaced by the replace function sequentially with the values of the base indexes in the base index library, and the formula in fig. 2 is changed into the formula in fig. 4 after replacement.
And a third step of: judging whether the class B index contains a sub-formula with an unobtained value, if not, calculating an index value by using a calculation, and storing the calculated index value into a basic index library as shown in fig. 5; if a recursive second step is included, the recursive second step is followed by the recursive second step as shown in FIG. 6.
Fourth step: judging whether the class B index contains a sub-formula with an unobtained value, if so, continuing to recursively carry out the second step until all index values are calculated.
When the class C index is calculated, the class C index is different from the class B index in the processing of the sqlvalue function; specifically, when the sqlvalue is processed, data of values of the indexes meeting the conditional sub-formula need to be selected in a basic index library to be summarized, then the corresponding sqlvalue value is replaced, the replacement principle of other indexes is the same as that of the B-type indexes, and finally all values are recursively obtained. For example: the calculation formula of the class C index is c0001=a0001+a0009+sqlval (SELECT SUM (BAL) FROM ups.index_table WHERE a0001 IN ('3', '4', '5') +b0002×66.66
Firstly, putting the value of A0001 into MAP, screening the 3,4,5 values meeting the conditions to perform SUM operation, then performing corresponding replacement, replacing the rest indexes with a replacement function, and finally calculating the final value by using calculation.
The method for automatically analyzing the index provided by the embodiment of the invention sequentially calculates the sub-formulas contained in each index calculation formula according to the low-to-high hierarchy, and can comprise the following steps:
when a plurality of different sub-formulas belonging to the same hierarchy are calculated, a plurality of threads are utilized to calculate the plurality of different sub-formulas belonging to the same hierarchy in parallel.
It should be noted that, when calculating different sub-formulas belonging to the same hierarchy, in order to further improve the efficiency of calculating the index value, the embodiment of the present application may use multiple threads to calculate multiple sub-formulas currently calculated in a one-to-one correspondence manner, and of course, other settings may be performed according to actual needs, which are all within the protection scope of the present invention.
The method for automatically analyzing the index provided by the embodiment of the invention can further comprise the following steps after the final result of each index calculation formula is obtained by calculation:
storing each index to be calculated and the corresponding final result, and outputting the corresponding index to be calculated and the corresponding final result when receiving an external query instruction.
After the value of each index is obtained, each index and the corresponding value can be stored, and in order to ensure the reliability of the index, at least two indexes and the corresponding values can be stored respectively, so that data backup is realized; in addition, when any index value needs to be inquired by the outside, a corresponding inquiry command can be input to the index automatic analysis device, and after the index automatic analysis device acquires the inquiry command, the index and the value corresponding to the inquiry command are determined and output for external users to acquire.
In addition, returning the final result may include:
and displaying each index to be calculated and the corresponding final result in a form.
The indexes and the corresponding values are displayed in a form, wherein the form comprises a column of the indexes and a column of the indexes to be indexed, and the indexes and the values of the indexes are positioned in the same row, so that external users can intuitively and rapidly acquire the corresponding information through the form.
In a specific application scenario, the method for automatically analyzing the index provided by the embodiment of the invention can comprise the following steps:
1. the method comprises the steps of carding a system packet for supervision and reporting, obtaining a form contained in the system packet, and classifying indexes in the form to obtain corresponding A-type indexes, B-type indexes and C-type indexes;
2. and configuring a calculation formula of the class A index, the class B index and the class C index, and after the calculation formula is configured, carrying out corresponding calculation in sequence from low to high according to the hierarchy. When people banks and banking authorities add new forms, corresponding index values can be automatically calculated by configuring corresponding calculation formulas, so that the time and efficiency of reporting are greatly saved.
When people banks and banking authorities newly increase the sending indexes, the corresponding values can be calculated in batches only by configuring the calculation formulas of the indexes, so that the system development time is shortened, the system maintenance cost is reduced, and the budget of a company is saved. And the configuration mode adopts humanized four-rule operation, so that the use threshold of the system is reduced. In addition, the index calculation can be performed simultaneously, the index calculation is rapid, and the reporting period is short.
The embodiment of the invention also provides an automatic index analysis device, as shown in fig. 7, which may include:
an acquisition module 11 for: receiving a form submitted by supervision, acquiring all indexes contained in the form as indexes to be calculated, and acquiring a calculation formula used for calculating each index to be calculated as an index calculation formula;
a first calculation module 12 for: determining the level of the sub-formulas contained in each index calculation formula, and sequentially calculating the sub-formulas contained in each index calculation formula according to the level from low to high to obtain the result of each sub-formula; the sub-formulas of the lowest level are formulas capable of being directly assigned, and the sub-formulas of any other level are formulas capable of calculating corresponding results based on results of the corresponding sub-formulas of the level lower than any level;
a second calculation module 13 for: based on the result of each sub-formula contained in each index calculation formula, calculating to obtain the final result of each index calculation formula, and returning the final result.
The automatic index analysis device provided by the embodiment of the invention can further comprise:
a classification module for: after all indexes contained in the form are to-be-calculated indexes, respectively comparing each to-be-calculated index with each basic index in a basic index library, and determining that the to-be-calculated index identical to any basic index is a class A index and the other to-be-calculated indexes except the class A index are comprehensive class indexes;
accordingly, the first computing module may include:
a hierarchy determining unit configured to: and determining that all the sub-formulas contained in the class A indexes are the lowest levels, and determining that the sub-formulas contained in the comprehensive class indexes at least correspond to two different levels respectively.
The embodiment of the invention provides an automatic index analysis device, and a classification module is also used for:
after determining that the other indexes to be calculated except the class A indexes are comprehensive indexes, determining that the comprehensive indexes containing preset characters in the used index calculation formula are B indexes, and determining that the other comprehensive indexes except the class B indexes are C indexes;
the apparatus further comprises:
a third calculation module for: and determining a conditional sub-formula which is contained in the class-C index and does not belong to any hierarchy, and summarizing partial data used for obtaining values assigned to the basic index to obtain a result of the conditional sub-formula, so that a final result of each index calculation formula is obtained based on the result calculation of the conditional sub-formula.
The automatic index analysis device provided by the embodiment of the invention, the acquisition module may include:
an acquisition unit configured to: and acquiring a calculation formula used for calculating each index to be calculated from a calculation formula currently input by a user or a stored calculation formula input by the user in advance as an index calculation formula.
The first calculation module of the index automatic analysis device provided by the embodiment of the invention may include:
a parallel computing unit configured to: when a plurality of different sub-formulas belonging to the same hierarchy are calculated, a plurality of threads are utilized to calculate the plurality of different sub-formulas belonging to the same hierarchy in parallel.
The automatic index analysis device provided by the embodiment of the invention can further comprise:
a storage module for: after the final result of each index calculation formula is obtained through calculation, each index to be calculated and the corresponding final result are stored, and the corresponding index to be calculated and the corresponding final result are output when an external query instruction is received.
The second calculation module of the index automatic analysis device provided by the embodiment of the invention may include:
a display unit for: and displaying each index to be calculated and the corresponding final result in a form.
The embodiment of the invention also provides an index automatic analysis device, which can comprise:
a memory for storing a computer program;
an analyzer for implementing the steps of any one of the index automatic analysis methods described above when executing a computer program.
The embodiment of the invention also provides a computer readable storage medium, and a computer program is stored on the computer readable storage medium, and when the computer program is executed by an analyzer, the steps of the automatic index analysis method according to any one of the above steps are realized.
It should be noted that, for the description of the related parts in the automatic indicator analysis device, the device and the storage medium provided in the embodiments of the present invention, please refer to the detailed description of the corresponding parts in the automatic indicator analysis method provided in the embodiments of the present invention, which is not repeated here. In addition, the parts of the above technical solutions provided in the embodiments of the present invention, which are consistent with the implementation principles of the corresponding technical solutions in the prior art, are not described in detail, so that redundant descriptions are avoided.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (8)
1. An automatic index analysis method, comprising:
receiving a form submitted by supervision, acquiring all indexes contained in the form as indexes to be calculated, and acquiring a calculation formula used for calculating each index to be calculated as an index calculation formula;
determining the level of the sub-formulas contained in each index calculation formula, and sequentially calculating the sub-formulas contained in each index calculation formula according to the level from low to high to obtain the result of each sub-formula; the sub-formulas of the lowest level are formulas capable of being directly assigned, and the sub-formulas of any other level are formulas capable of calculating corresponding results based on results of the corresponding sub-formulas of the level lower than any level;
calculating a final result of each index calculation formula based on the result of each sub-formula contained in each index calculation formula, and returning the final result;
after all the indexes contained in the acquired form are indexes to be calculated, the method further comprises the steps of:
respectively comparing each index to be calculated with each basic index in a basic index library, and determining the index to be calculated which is the same as any basic index as an A-type index and the other indexes to be calculated except the A-type index as comprehensive indexes;
determining that the comprehensive indexes containing preset characters in the used index calculation formula are B-class indexes, and the comprehensive indexes except the B-class indexes are C-class indexes;
determining a conditional sub-formula which is contained in the class-C index and does not belong to any hierarchy, and summarizing partial data used for obtaining values assigned to the basic index to obtain a result of the conditional sub-formula, so as to calculate and obtain a final result of each index calculation formula based on the result of the conditional sub-formula;
and, the determining the hierarchy of the sub-formulas included in each index calculation formula includes:
and determining that all the sub-formulas contained in the class A index are the lowest levels, and determining that at least two different levels respectively correspond to the sub-formulas contained in the comprehensive class index.
2. The method according to claim 1, wherein the calculation formula used for obtaining and calculating each of the indices to be calculated is an index calculation formula, comprising:
and acquiring a calculation formula used for calculating each index to be calculated from a calculation formula currently input by a user or a stored calculation formula input by the user in advance as an index calculation formula.
3. The method according to claim 2, wherein sequentially calculating the sub-formulas included in each index calculation formula in a hierarchy from low to high includes:
when a plurality of different sub-formulas belonging to the same hierarchy are calculated, a plurality of threads are utilized to calculate the plurality of different sub-formulas belonging to the same hierarchy in parallel.
4. A method according to claim 3, further comprising, after calculating the final result of each of the index calculation formulas:
storing each index to be calculated and the corresponding final result, and outputting the corresponding index to be calculated and the corresponding final result when receiving an external query instruction.
5. The method of claim 4, wherein returning the final result comprises:
and displaying each index to be calculated and the corresponding final result in a form.
6. An automatic index analyzer, comprising:
an acquisition module for: receiving a form submitted by supervision, acquiring all indexes contained in the form as indexes to be calculated, and acquiring a calculation formula used for calculating each index to be calculated as an index calculation formula;
a first calculation module for: determining the level of the sub-formulas contained in each index calculation formula, and sequentially calculating the sub-formulas contained in each index calculation formula according to the level from low to high to obtain the result of each sub-formula; the sub-formulas of the lowest level are formulas capable of being directly assigned, and the sub-formulas of any other level are formulas capable of calculating corresponding results based on results of the corresponding sub-formulas of the level lower than any level;
a second calculation module for: calculating a final result of each index calculation formula based on the result of each sub-formula contained in each index calculation formula, and returning the final result;
a classification module for: after all indexes contained in the form are to-be-calculated indexes, respectively comparing each to-be-calculated index with each basic index in a basic index library, and determining that the to-be-calculated index identical to any basic index is a class A index and the other to-be-calculated indexes except the class A index are comprehensive class indexes;
the classification module is also used for: after determining that the other indexes to be calculated except the class A indexes are comprehensive indexes, determining that the comprehensive indexes containing preset characters in the used index calculation formula are B indexes, and determining that the other comprehensive indexes except the class B indexes are C indexes;
a third calculation module for: determining a conditional sub-formula which is contained in the class-C index and does not belong to any level, and summarizing partial data used for obtaining values assigned to the basic index to obtain a result of the conditional sub-formula, so that a final result of each index calculation formula is obtained based on the result calculation of the conditional sub-formula;
and, the first computing module specifically includes:
a hierarchy determining unit configured to: and determining that all the sub-formulas contained in the class A indexes are the lowest levels, and determining that the sub-formulas contained in the comprehensive class indexes at least correspond to two different levels respectively.
7. An index automatic analysis device, characterized by comprising:
a memory for storing a computer program;
an analyzer for implementing the steps of the automatic index analysis method according to any one of claims 1 to 5 when executing the computer program.
8. A computer-readable storage medium, characterized in that the computer-readable storage medium has stored thereon a computer program which, when executed by an analyzer, implements the steps of the automatic index analysis method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110032296.5A CN112700328B (en) | 2021-01-11 | 2021-01-11 | Automatic index analysis method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110032296.5A CN112700328B (en) | 2021-01-11 | 2021-01-11 | Automatic index analysis method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112700328A CN112700328A (en) | 2021-04-23 |
| CN112700328B true CN112700328B (en) | 2024-04-16 |
Family
ID=75513897
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110032296.5A Active CN112700328B (en) | 2021-01-11 | 2021-01-11 | Automatic index analysis method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112700328B (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104933299A (en) * | 2015-06-03 | 2015-09-23 | 浪潮软件集团有限公司 | Data processing method and device |
| CN106776822A (en) * | 2016-11-25 | 2017-05-31 | 远光软件股份有限公司 | Conglomerate's report data extracting method and system |
| CN106875110A (en) * | 2017-02-06 | 2017-06-20 | 泰康保险集团股份有限公司 | Operational indicator layered calculation method and device, distributed computing method and system |
| CN107808336A (en) * | 2017-11-02 | 2018-03-16 | 中国银行股份有限公司 | The computational methods and device of a kind of financial index |
| CN109359898A (en) * | 2018-12-10 | 2019-02-19 | 胜科金仕达数据系统(中国)有限公司 | A kind of index analysis method, product and its application |
| CN110069519A (en) * | 2018-08-23 | 2019-07-30 | 平安科技（深圳）有限公司 | Data information management method, apparatus, computer equipment and storage medium |
| CN110782354A (en) * | 2019-10-23 | 2020-02-11 | 中国工商银行股份有限公司 | Method and apparatus for disclosing fund investment |
| WO2020087830A1 (en) * | 2018-11-02 | 2020-05-07 | 深圳壹账通智能科技有限公司 | Data analysis method and apparatus, server, and storage medium |
| CN111553556A (en) * | 2020-03-27 | 2020-08-18 | 深圳壹账通智能科技有限公司 | Business data analysis method and device, computer equipment and storage medium |
| CN111784148A (en) * | 2020-06-28 | 2020-10-16 | 京东数字科技控股有限公司 | Data processing method and device, electronic equipment and storage medium |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080140473A1 (en) * | 2006-12-08 | 2008-06-12 | The Risk Management Association | System and method for determining composite indicators |
| WO2017159523A1 (en) * | 2016-03-15 | 2017-09-21 | 日本電気株式会社 | Inference system, inference method, and recording medium |
-
2021
- 2021-01-11 CN CN202110032296.5A patent/CN112700328B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104933299A (en) * | 2015-06-03 | 2015-09-23 | 浪潮软件集团有限公司 | Data processing method and device |
| CN106776822A (en) * | 2016-11-25 | 2017-05-31 | 远光软件股份有限公司 | Conglomerate's report data extracting method and system |
| CN106875110A (en) * | 2017-02-06 | 2017-06-20 | 泰康保险集团股份有限公司 | Operational indicator layered calculation method and device, distributed computing method and system |
| CN107808336A (en) * | 2017-11-02 | 2018-03-16 | 中国银行股份有限公司 | The computational methods and device of a kind of financial index |
| CN110069519A (en) * | 2018-08-23 | 2019-07-30 | 平安科技（深圳）有限公司 | Data information management method, apparatus, computer equipment and storage medium |
| WO2020087830A1 (en) * | 2018-11-02 | 2020-05-07 | 深圳壹账通智能科技有限公司 | Data analysis method and apparatus, server, and storage medium |
| CN109359898A (en) * | 2018-12-10 | 2019-02-19 | 胜科金仕达数据系统(中国)有限公司 | A kind of index analysis method, product and its application |
| CN110782354A (en) * | 2019-10-23 | 2020-02-11 | 中国工商银行股份有限公司 | Method and apparatus for disclosing fund investment |
| CN111553556A (en) * | 2020-03-27 | 2020-08-18 | 深圳壹账通智能科技有限公司 | Business data analysis method and device, computer equipment and storage medium |
| CN111784148A (en) * | 2020-06-28 | 2020-10-16 | 京东数字科技控股有限公司 | Data processing method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112700328A (en) | 2021-04-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110162516B (en) | Data management method and system based on mass data processing | |
| US20140115012A1 (en) | Data model optimization using multi-level entity dependencies | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| CN114461644A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN108090086A (en) | Paging query method and device | |
| CN110765750A (en) | Report data entry method and terminal equipment | |
| US8707262B2 (en) | Code scoring | |
| CN108897765A (en) | A kind of batch data introduction method and its system | |
| CN117371412B (en) | Form-based filling method, system, equipment and storage medium | |
| CN113886373A (en) | Data processing method and device and electronic equipment | |
| CN112700328B (en) | Automatic index analysis method, device, equipment and storage medium | |
| CN112508119A (en) | Feature mining combination method, device, equipment and computer readable storage medium | |
| CN111522819A (en) | Method and system for summarizing tree-structured data | |
| CN115563310A (en) | Method, device, equipment and medium for determining key service node | |
| CN115080607A (en) | Method, device, equipment and storage medium for optimizing structured query statement | |
| CN104636422A (en) | Method and system for mining of patterns in a data set | |
| CN110765100B (en) | Label generation method and device, computer readable storage medium and server | |
| CN114881521A (en) | Service evaluation method, device, electronic equipment and storage medium | |
| CN113344023A (en) | Code recommendation method, device and system | |
| US8359329B2 (en) | Method, computer apparatus and computer program for identifying unusual combinations of values in data | |
| CN107168942B (en) | Automatic report generation method and device | |
| CN114116729B (en) | Test data processing method and equipment | |
| CN110309211A (en) | A kind of method and relevant device positioning ETL Process Problems | |
| CN115826928B (en) | Program generating method, system, electronic device and computer readable storage medium | |
| CN111126015B (en) | Report form compiling method and equipment |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |