Reporting exception handling method and device
Through the dependency tree relationship algorithm and verification formula table, the problem of commercial banks' untimely processing of abnormal indicator data reported by them was solved, the processing efficiency and accuracy were improved, and the regulatory authorities' needs for rapid correction were met.
Patent Information
- Application Number
- CN202210390055.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-04-14
- Publication Date
- 2025-09-09
- Estimated Expiration
- 2042-04-14
AI Technical Summary
In the existing technology, when commercial banks report financial statistical regulatory indicators, abnormal indicator data is not processed in a timely manner, resulting in low processing efficiency and insufficient accuracy.
Use dependency tree relationship algorithm and verification formula table to find the source indicators and related indicators in the indicator items to be modified, and correct the data according to the verification rules to improve processing efficiency and accuracy.
It has achieved timely adjustment of abnormal indicator data, improved the efficiency and accuracy of reporting abnormalities, and met the rapid correction requirements of regulatory agencies.
Smart Images

Figure CN115048366B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data processing technology, and in particular to a method and device for reporting exception processing. Background Art
[0002] With the growing development of internet finance, to strengthen the identification, assessment, and early warning of commercial bank risks and effectively prevent financial risks, commercial banks must, in accordance with the relevant regulations of higher-level regulatory agencies, regularly extract, process, and integrate data from basic business systems to form various financial statistical regulatory indicators. These indicators are then assembled into reports and submitted to higher-level regulatory agencies. If the reported indicator data does not meet the corresponding verification rules, the reporting institution will receive an abnormal reporting receipt and must correct the abnormal indicator data based on the receipt and resubmit it.
[0003] When business personnel need to manually correct a certain indicator data, due to the complex verification relationship between multiple indicators, it takes a lot of time to analyze the indicator content and quantity of the affected items. However, since the time window required by the regulatory agency to complete the reporting is relatively short, the results of manual analysis cannot guarantee 100% accuracy.
[0004] Therefore, there is an urgent need for a method that can quickly handle reporting exceptions. Summary of the Invention
[0005] In view of this, an embodiment of the present invention provides a method and apparatus for handling reporting anomalies, so as to achieve the purpose of timely adjusting abnormal indicator data, improving the processing efficiency of reporting anomalies, and improving reporting efficiency and reporting accuracy.
[0006] To achieve the above objectives, the embodiments of the present invention provide the following technical solutions:
[0007] A first aspect of an embodiment of the present invention discloses a method for handling reporting exceptions, the method comprising:
[0008] Receive abnormal reporting receipts from regulatory agencies;
[0009] Determine abnormal indicator data according to the abnormal reporting receipt, and modify any abnormal indicator data to obtain modified indicator data and indicator items to be modified, wherein the indicator items to be modified include multiple indicators to be modified;
[0010] Using a pre-established dependency tree relationship algorithm, searching for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and determining indicator data of all indicators associated with the indicator to be modified in the modified indicator data;
[0011] According to the verification rules between the indicators in the pre-established verification formula table, the indicator data of all indicators associated with the indicator to be modified are corrected.
[0012] Optionally, the using of a pre-established dependency tree relationship algorithm to search for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified includes:
[0013] Generate an indicator list corresponding to the indicator item to be modified based on a pre-established verification formula table;
[0014] generating a dependency graph based on the indicator list;
[0015] By using a pre-established dependency tree relationship algorithm, the source indicator in the indicator item to be modified and all other indicators that have a logical verification relationship with the indicator to be modified are searched in the dependency relationship graph.
[0016] Optionally, the step of correcting the indicator data of all indicators associated with the indicator to be modified according to the verification rules between indicators in the pre-established verification formula table includes:
[0017] Based on the dependency tree relationship algorithm, starting from the source indicator, the verification formulas corresponding to all other indicators that have a logical verification relationship with the indicator to be modified are determined in sequence;
[0018] For each indicator data associated with the indicator to be modified, the indicator data of all indicators associated with the indicator to be modified are corrected in turn according to the verification formulas corresponding to all other indicators that have a logical verification relationship with the indicator to be modified, until the indicator data of all indicators associated with the indicator to be modified are corrected.
[0019] Optionally, the process of pre-establishing the verification formula table includes:
[0020] Obtaining indicator data and determining each indicator in the indicator data;
[0021] Determining the indicators in the left and right terms of the verification formula and the operation symbols between the indicators based on the comparison type;
[0022] According to the operation symbol, determine the final value corresponding to each of the left and right terms;
[0023] According to the comparison type, establishing verification rules between the various indicators, and obtaining verification formulas corresponding to the various indicators;
[0024] Based on the verification formulas corresponding to the various indicators, a verification formula table is established.
[0025] Optionally, the process of pre-establishing a dependency tree relationship algorithm includes:
[0026] Obtaining indicator data, determining each indicator in the indicator data, and determining an indicator list corresponding to all the indicators;
[0027] List the dependency lists of all the indicators in the indicator list, and mark the RL relationship list and the RR relationship list in the dependency list;
[0028] Converting the dependency list in a first conversion manner to obtain a first display effect diagram, wherein the first display effect diagram includes a separator and each relationship pair in the dependency list;
[0029] Converting the indicator list in a second conversion mode to obtain a second display effect diagram, wherein the second display effect diagram includes the separator, the processed indicator, and the indicator to be processed, the processed indicator is marked as a first label, and the indicator to be processed is marked as a second label;
[0030] Based on the first display effect diagram and the second display effect diagram, starting from each indicator in the indicator list, delete the first indicator that appears in the RR relationship list from the indicators to be processed;
[0031] The second indicator that does not appear in the RR relationship list is set as the first label, and the relationship pairs about the first indicator that appear in the dependency list are deleted until the final dependency order of each of the indicators is obtained.
[0032] A second aspect of an embodiment of the present invention discloses a device for handling reporting exceptions, the device comprising:
[0033] A receiving module is used to receive the abnormality report receipt sent by the regulatory agency;
[0034] A first processing module is configured to determine abnormal indicator data according to the abnormal reporting receipt, and modify any abnormal indicator data to obtain modified indicator data and an indicator item to be modified, wherein the indicator item to be modified includes a plurality of indicators to be modified;
[0035] A second processing module is configured to use a pre-established dependency tree relationship algorithm to search for a source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and determine indicator data of all indicators associated with the indicator to be modified in the modified indicator data;
[0036] The correction module is used to correct the indicator data of all indicators associated with the indicator to be modified according to the verification rules between indicators in the pre-established verification formula table.
[0037] Optionally, the second processing module includes:
[0038] A first generating unit is configured to generate an indicator list corresponding to the indicator item to be modified based on a pre-established verification formula table;
[0039] A second generating unit, configured to generate a dependency graph based on the indicator list;
[0040] The search unit is used to use a pre-established dependency tree relationship algorithm to search the source indicator in the indicator item to be modified and all other indicators that have a logical verification relationship with the indicator to be modified in the dependency relationship graph.
[0041] Optionally, the correction module includes:
[0042] a determination unit configured to determine, based on the dependency tree relationship algorithm, starting from the source indicator, verification formulas corresponding to all remaining indicators that have a logical verification relationship with the indicator to be modified;
[0043] The correction unit is used to correct the indicator data of each indicator associated with the indicator to be modified in turn according to the verification formula corresponding to all other indicators that have a logical verification relationship with the indicator to be modified, until the indicator data of all indicators associated with the indicator to be modified are corrected.
[0044] Optionally, the system further includes: a first pre-establishment module, configured to pre-establish a verification formula table;
[0045] The first pre-built module includes:
[0046] an acquisition unit, configured to acquire indicator data and determine each indicator in the indicator data;
[0047] A first determining unit is configured to determine, based on a comparison type, the indicators in the left and right terms of the verification formula and the operation symbols between the indicators;
[0048] A second determining unit is used to determine the final values corresponding to the left and right terms according to the operation symbol;
[0049] an obtaining unit, configured to establish verification rules between the indicators according to the comparison type, and obtain verification formulas corresponding to the indicators;
[0050] An establishing unit is used to establish a verification formula table based on the verification formula corresponding to each of the indicators.
[0051] Optionally, the method further includes: a second pre-establishment module for pre-establishing a dependency tree relationship algorithm;
[0052] The second pre-built module includes:
[0053] a determination unit, configured to obtain indicator data, determine each indicator in the indicator data, and determine an indicator list corresponding to all the indicators;
[0054] a marking unit, configured to list dependency lists of all the indicators in the indicator list, and mark an RL relationship list and an RR relationship list in the dependency relationship list;
[0055] A first obtaining unit is configured to convert the dependency list in a first conversion manner to obtain a first display effect diagram, wherein the first display effect diagram includes a separator and each relationship pair in the dependency list;
[0056] a second obtaining unit, configured to convert the indicator list in a second conversion manner to obtain a second display effect diagram, wherein the second display effect diagram includes the separator, the processed indicator, and the indicator to be processed, the processed indicator is marked as a first label, and the indicator to be processed is marked as a second label;
[0057] a first processing unit configured to, based on the first display effect diagram and the second display effect diagram, sequentially delete, starting with each indicator in the indicator list, a first indicator that appears in the RR relationship list from the indicators to be processed;
[0058] The second processing unit is used to set the second indicator that does not appear in the RR relationship list as the first label, and delete the relationship pairs about the first indicator that appear in the dependency list until the final dependency order of each of the indicators is obtained.
[0059] Based on the above embodiment of the present invention, a method and device for handling abnormal reporting is provided, the method comprising: receiving an abnormal reporting receipt sent by a regulatory agency; determining abnormal indicator data according to the abnormal reporting receipt, and modifying any of the abnormal indicator data to obtain modified indicator data and an indicator item to be modified, wherein the indicator item to be modified includes multiple indicators to be modified; using a pre-established dependency tree relationship algorithm, searching for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and determining the indicator data of all indicators associated with the indicator to be modified in the modified indicator data; and correcting the indicator data of all indicators associated with the indicator to be modified according to the verification rules between indicators in the pre-established verification formula table. In this solution, after modifying any abnormal indicator data, using a dependency tree relationship algorithm, searching for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and correcting the indicator data of all indicators associated with the indicator to be modified according to the verification rules between indicators in the verification formula table, thereby timely adjusting the abnormal indicator data, improving the processing efficiency of reporting abnormalities, and improving reporting efficiency and reporting accuracy. BRIEF DESCRIPTION OF THE DRAWINGS
[0060] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are merely embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying any creative work.
[0061] Figure 1 A flowchart of a method for handling exception reporting provided by an embodiment of the present invention;
[0062] Figure 2 A block diagram of the principle of reporting exception processing provided by an embodiment of the present invention;
[0063] Figure 3 A schematic diagram of a process for searching for a source indicator in an indicator item to be modified and all indicators associated with the indicator to be modified provided by an embodiment of the present invention;
[0064] Figure 4 An example diagram of a dependency relationship provided by an embodiment of the present invention;
[0065] Figure 5 A schematic diagram of a process for correcting indicator data of all indicators associated with an indicator to be modified provided by an embodiment of the present invention;
[0066] Figure 6 A schematic diagram of a process for pre-establishing a verification formula table provided in an embodiment of the present invention;
[0067] Figure 7 An example diagram of a calibration formula provided by an embodiment of the present invention;
[0068] Figure 8 A schematic diagram of a flow chart of an algorithm for pre-establishing a dependency tree relationship provided by an embodiment of the present invention;
[0069] FIG9( a ) and FIG9 ( b ) are diagrams showing a display effect according to an embodiment of the present invention;
[0070] Figure 10 A calculation result diagram provided by an embodiment of the present invention;
[0071] Figure 11 A schematic diagram of the structure of a reporting exception handling device provided in an embodiment of the present invention. DETAILED DESCRIPTION
[0072] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.
[0073] In this application, the terms "comprises," "comprising," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, article, or apparatus that includes a list of elements includes not only those elements but also other elements not explicitly listed, or elements inherent to such process, method, article, or apparatus. In the absence of further limitations, an element defined by the phrase "comprising a ..." does not preclude the presence of additional identical elements in the process, method, article, or apparatus that includes the element.
[0074] The terms "first," "second," "third," "fourth," and so on (if any) in the specification and claims of this application and the accompanying drawings are used to distinguish similar objects and are not necessarily used to describe a particular order or sequence. It should be understood that the terms used in this manner are interchangeable where appropriate, so that the embodiments described herein can be implemented in an order other than that shown or described herein.
[0075] In order to facilitate understanding of the technical solution of the present invention, the technical terms appearing in the present invention are explained:
[0076] Regulatory reporting system: A bank management system developed to meet the internal and external regulatory data reporting needs of commercial banks. It usually includes a data processing system, a data reporting system, etc., and uses a unified data processing model and information presentation model to implement the various data reporting requirements put forward by regulatory agencies.
[0077] Indicators: These indicators have specific statistical calibers and measurement methods. They are quantitative expressions of activity characteristics and quantitative reflections of the risk status of commercial banks. They are important criteria for accurately identifying overall assessments and continuously supervising bank risks.
[0078] Submission Receipt: A fixed-format text sent by the regulatory authority to the commercial bank through a specific communication method after verifying the submitted data. The regulatory authority determines whether the submission is successful through the text information.
[0079] Verification rules: refers to the digital logical relationship between the reported indicators for mutual inspection and verification. For example, the indicator of the number of active bank cards is equal to the sum of the number of active debit cards, the number of active credit cards and the number of active combined credit and debit cards.
[0080] Dependency tree: A dependency tree is used to describe the dependencies between events in a system. Events in the system are abstracted into nodes in a tree, and the edges between nodes represent the dependencies between events. Typically, the connections in a dependency tree are logical dependencies.
[0081] As can be seen from the background technology, the existing reporting exception processing method cannot adjust the abnormal indicator data in a timely manner, and the processing efficiency of reporting exceptions is low.
[0082] Therefore, an embodiment of the present invention provides a method and device for handling reporting exceptions. In this solution, after modifying any abnormal indicator data, a dependency tree relationship algorithm is used to find the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and based on the verification rules between the indicators in the verification formula table, the indicator data of all indicators associated with the indicator to be modified are corrected, thereby timely adjusting the abnormal indicator data, improving the processing efficiency of reporting exceptions, and improving the reporting efficiency and reporting accuracy.
[0083] like Figure 1 FIG. 1 is a flow chart of a method for handling an exception report provided by an embodiment of the present invention, the method mainly comprising the following steps:
[0084] Step S101: Receive an exception reporting receipt sent by a regulatory agency.
[0085] In the specific implementation of step S101, the reporting agency assembles various financial statistical regulatory indicators into a message and submits it to the superior regulatory agency. If the reported indicator data does not meet the corresponding verification rules, the reporting agency will receive an abnormal reporting receipt sent by the regulatory agency, and must correct the abnormal indicator data based on the receipt issue and resubmit it.
[0086] Step S102: Determine abnormal indicator data according to the abnormality report receipt, and modify any abnormal indicator data to obtain modified indicator data and indicator items to be modified.
[0087] In step S102, the indicator item to be modified includes a plurality of indicators to be modified.
[0088] In the specific implementation process of step S102, after receiving the abnormal reporting receipt sent by the regulatory agency, the reporting agency determines the abnormal indicator data based on the abnormal reporting receipt. Since there may be multiple abnormal indicator data, any abnormal indicator data is modified to obtain the modified indicator data and the indicator item to be modified.
[0089] It should be noted that after any abnormal indicator data is modified, the reporting data correction area receives the modified indicator data and the indicator items to be modified, and performs subsequent related processing operations.
[0090] Step S103: using a pre-established dependency tree relationship algorithm, searching for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and determining indicator data of all indicators associated with the indicator to be modified in the modified indicator data.
[0091] In the embodiment of the present invention, the source indicator is the root node.
[0092] In the process of implementing step S103, a dependency tree relationship algorithm is established in advance. At this time, for the obtained modified indicator data and indicator items to be modified, that is, for the modified indicator data and indicator items to be modified in the data correction area, the dependency tree relationship algorithm is used to find the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and determine the indicator data of all indicators associated with the indicator to be modified in the modified indicator data.
[0093] In other words, a dependency tree relationship algorithm is pre-established, and the dependency tree relationship algorithm is used to trace the source indicators and related indicators in the indicator item to be modified, and determine the indicator data of the related indicators in the modified indicator data.
[0094] Step S104: Correct the indicator data of all indicators associated with the indicator to be modified according to the verification rules between indicators in the pre-established verification formula table.
[0095] It should be noted that the verification formula table is created based on the verification rules between indicators.
[0096] In the process of implementing step S104, a verification formula table is established in advance, the verification rules between the various indicators in the verification formula table are determined, and the indicator data of each indicator associated with the indicator to be modified are corrected in turn according to the verification rules between the indicators in the verification formula table, until the correction of the indicator data of each indicator associated with the indicator to be modified is completed.
[0097] It should be noted that after the correction of abnormal indicator data is completed, the abnormal data should be resubmitted.
[0098] like Figure 2 FIG. 1 is a block diagram showing a principle of reporting exception handling according to an embodiment of the present invention.
[0099] exist Figure 2 In the reporting process, when the reported indicator data does not meet the corresponding verification rules, that is, when the verification fails, the reporting agency will receive an abnormal reporting receipt from the regulatory agency. According to the abnormal reporting receipt, after modifying any abnormal indicator data, the reported data correction area receives the modified indicator data and the indicator items to be modified. The reported data correction area corrects the abnormal indicator data based on the pre-established verification formula table and resubmits the data after the correction is completed. The specific correction process is as follows:
[0100] A dependency tree relationship algorithm is established in advance, and the dependency tree relationship algorithm is used to trace the source indicators and related indicators in the indicator items to be modified, and determine the indicator data of the related indicators in the modified indicator data.
[0101] According to the verification rules between the indicators in the verification formula table, the indicator data of all indicators associated with the indicator to be modified are corrected.
[0102] A method for handling exception reporting provided by an embodiment of the present invention comprises the following steps: receiving an exception reporting receipt sent by a regulatory agency; determining the exception indicator data according to the exception reporting receipt, and modifying any exception indicator data to obtain the modified indicator data and the indicator item to be modified, wherein the indicator item to be modified includes multiple indicators to be modified; using a pre-established dependency tree relationship algorithm, searching for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and determining the indicator data of all indicators associated with the indicator to be modified in the modified indicator data; and correcting the indicator data of all indicators associated with the indicator to be modified according to the verification rules between indicators in the pre-established verification formula table. In this solution, after modifying any exception indicator data, using a dependency tree relationship algorithm, searching for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and correcting the indicator data of all indicators associated with the indicator to be modified according to the verification rules between indicators in the verification formula table, thereby timely adjusting the exception indicator data, improving the processing efficiency of reporting exceptions, and improving the reporting efficiency and reporting accuracy.
[0103] Based on the above-mentioned method for handling anomaly reporting provided by the embodiment of the present invention, step S103 is executed to use the pre-established dependency tree relationship algorithm to search for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, such as Figure 3 FIG. 1 is a flow chart of searching for a source indicator and all indicators associated with the indicator to be modified in an indicator item to be modified, provided by an embodiment of the present invention, and mainly includes the following steps:
[0104] Step S301: Based on a pre-established verification formula table, generate an indicator list corresponding to the indicator items to be modified.
[0105] In the specific implementation of step S301, a verification formula table is created in advance according to the verification rules between indicators, and based on the verification rules between indicators in the verification formula table, an indicator list corresponding to the indicator items to be modified is generated.
[0106] Step S302: Generate a dependency graph based on the indicator list.
[0107] In the specific implementation of step S302 , based on the generated indicator list corresponding to the indicator item to be modified, the indicator list is converted into a graphical representation to obtain a corresponding dependency graph.
[0108] Step S303: using a pre-established dependency tree relationship algorithm, searching the dependency relationship graph for the source indicator in the indicator item to be modified and all other indicators that have a logical verification relationship with the indicator to be modified.
[0109] In the process of implementing step S303, a dependency tree relationship algorithm is pre-established, and the dependency tree relationship algorithm is used to search the dependency relationship graph in step S302 for the source indicator in the indicator item to be modified and all other indicators that have a logical verification relationship with the indicator to be modified.
[0110] Take steps S301 to S303 as an example. Figure 4 As shown, it is an example diagram of dependency provided by an embodiment of the present invention.
[0111] exist Figure 4 In the example, the index items to be modified are A, B, C, D, E, F and G, and the verification formulas are A=C+D+G, B=C+G, D=E+B, F=E and G=F. Based on the pre-established verification formula table, the index list corresponding to the index items to be modified is T(A, B, C, D, E, F, G), and based on the index list T(A, B, C, D, E, F, G), a dependency graph is generated (such as Figure 4 shown).
[0112] Assuming that the source indicator in the indicator item to be modified is B, the source indicator B in the indicator item to be modified and all other indicators C and G that have a logical verification relationship with the indicator to be modified are found in the dependency graph.
[0113] A reporting exception processing method provided by an embodiment of the present invention generates a dependency graph and uses a dependency tree relationship algorithm to search the dependency graph for the source indicator in the indicator item to be modified and all other indicators that have a logical verification relationship with the indicator to be modified, thereby providing a prerequisite for subsequent timely adjustment of abnormal indicator data, thereby improving the processing efficiency of reporting exceptions and improving reporting efficiency and reporting accuracy.
[0114] Based on the above-mentioned method for handling abnormal reports provided by the embodiment of the present invention, step S104 is executed to correct the indicator data of all indicators associated with the indicator to be modified according to the verification rules between the indicators in the pre-established verification formula table, such as Figure 5 FIG. 1 is a flow chart of correcting the indicator data of all indicators associated with the indicator to be modified, provided by an embodiment of the present invention, and mainly includes the following steps:
[0115] Step S501: Based on the dependency tree relationship algorithm, starting from the source indicator, the verification formulas corresponding to all other indicators that have a logical verification relationship with the indicator to be modified are determined in sequence.
[0116] In the process of implementing step S501, after finding the source indicator in the indicator item to be modified and all other indicators that have a logical verification relationship with the indicator to be modified, based on the dependency tree relationship algorithm, starting from the found source indicator, the verification formulas corresponding to all other indicators that have a logical verification relationship with the indicator to be modified are determined in turn.
[0117] Step S502: For each indicator data associated with the indicator to be modified, the indicator data of all indicators associated with the indicator to be modified are corrected in turn according to the verification formulas corresponding to all other indicators that have a logical verification relationship with the indicator to be modified, until the indicator data of all indicators associated with the indicator to be modified are corrected.
[0118] In the process of specifically implementing step S502, for each indicator data, that is, for each indicator data associated with the indicator to be modified, the indicator data of all indicators associated with the indicator to be modified are corrected in turn according to the verification formula corresponding to all other indicators that have a logical verification relationship with the indicator to be modified, until the indicator data of all indicators associated with the indicator to be modified are corrected.
[0119] For example, A=B+C. Assuming B is the source indicator, the indicator data of B should be increased by 1 after verification, then its associated indicator A will be increased by 1 accordingly.
[0120] For example, Figure 4 As shown, assuming that the source indicator in the indicator item to be modified is D, the source indicator D in the indicator item to be modified is found in the dependency graph, and all other indicators that have a logical verification relationship with the indicator to be modified are E and B. Then, based on the dependency tree relationship algorithm, starting from the source indicator D, the verification formula corresponding to all other indicators that have a logical verification relationship with the indicator to be modified is determined in turn, which is D=E+B.
[0121] For each indicator data associated with the indicator to be modified, that is, the indicator data of indicator E and the indicator data of indicator B, according to the verification formula: D=E+B, the indicator data of all indicators associated with the indicator to be modified are corrected in turn, that is, the indicator data of indicator E and the indicator data of indicator B are corrected in turn.
[0122] A reporting exception processing method provided in an embodiment of the present invention starts from the source indicator and corrects the indicator data of all indicators associated with the indicator to be modified in sequence according to the verification formulas corresponding to all other indicators that have a logical verification relationship with the indicator to be modified, thereby timely adjusting the abnormal indicator data, improving the processing efficiency of reporting exceptions, and improving the reporting efficiency and reporting accuracy.
[0123] Based on the above-mentioned method for handling abnormal reports provided by the embodiment of the present invention, step S104 is executed to correct the indicator data of all indicators associated with the indicator to be modified according to the verification rules between the indicators in the pre-established verification formula table, such as Figure 6 FIG. 1 is a flow chart of pre-establishing a verification formula table according to an embodiment of the present invention, which mainly includes the following steps:
[0124] Step S601: Obtain indicator data and determine each indicator in the indicator data.
[0125] In the specific implementation of step S601, when establishing the verification formula table, indicator data support is required, and the indicator data needs to be obtained. After the required indicator data is obtained, each indicator in the obtained indicator data is determined.
[0126] Step S602: Based on the comparison type, determine the indicators in the left and right terms of the verification formula and the operation symbols between the indicators.
[0127] It should be noted that comparison types include but are not limited to <, <=, =, >= and >.
[0128] Operator symbols include, but are not limited to, +, -, *, / , and %.
[0129] In the process of implementing step S602, based on the comparison type, the indicators in the left and right terms of the verification formula and the operation symbols between each indicator are determined, that is, the left and right terms of the verification formula and the corresponding operation symbols of the left and right terms are matched according to the comparison type (<, <=, =, >=, >).
[0130] Step S603: Determine the final values corresponding to the left and right terms according to the operation symbols.
[0131] In the specific implementation of step S603 , for the left and right terms after the division, the final values corresponding to the left and right terms are determined according to the corresponding operation symbols in the left and right terms.
[0132] Step S604: According to the comparison type, establish verification rules between various indicators and obtain verification formulas corresponding to various indicators.
[0133] In the process of implementing step S604, after determining the final values corresponding to the left and right items, verification rules between the indicators are established according to the comparison type, and verification formulas corresponding to the indicators are obtained. It can be understood that the indicators are associated according to the comparison type, that is, the dependency between the reported data indicators is completed.
[0134] For example, Figure 7 As shown in FIG, an example diagram of a verification formula provided by an embodiment of the present invention.
[0135] exist Figure 7 In the figure, the indicators in the left and right terms of the verification formula, the operation symbols between the indicators, and the comparison type between the left and right terms of the verification formula are marked.
[0136] Step S605: Create a verification formula table based on the verification formulas corresponding to the various indicators.
[0137] A reporting exception processing method provided in an embodiment of the present invention establishes a verification formula table to provide conditions for subsequently correcting the indicator data of all indicators associated with the indicator to be modified based on the verification rules between the indicators in the verification formula table, thereby enabling timely adjustment of abnormal indicator data, improving the processing efficiency of reporting exceptions, and improving reporting efficiency and reporting accuracy.
[0138] Based on the above-mentioned method for handling anomaly reporting provided by the embodiment of the present invention, step S103 is executed to use the pre-established dependency tree relationship algorithm to search for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, such as Figure 8 FIG. 1 is a flow chart of an algorithm for pre-establishing a dependency tree relationship according to an embodiment of the present invention, which mainly includes the following steps:
[0139] Step S801: Acquire indicator data, determine each indicator in the indicator data, and determine an indicator list corresponding to all indicators.
[0140] In the embodiment of the present invention, the indicator list is referred to as T for short.
[0141] In the process of implementing step S801, when establishing the dependency tree relationship algorithm, the support of indicator data is needed, so the indicator data needs to be obtained. After obtaining the required indicator data, each indicator in the obtained indicator data is determined, and the indicator list corresponding to all indicators is determined. Based on the indicator list corresponding to all indicators, a dependency relationship graph is generated.
[0142] For example, Figure 4 The indicator list of the graph in is: T(A, B, C, D, E, F, G).
[0143] Step S802: List the dependency lists of all indicators in the indicator list, and mark the RL relationship list and the RR relationship list in the dependency relationship list.
[0144] In the embodiment of the present invention, the dependency list is referred to as R for short.
[0145] For example, Figure 4 The dependency list is: R(A->C, A->D, A->G, B->C, D->B, D->E, F->E, G->F, B->G).
[0146] Among them, Figure 4 In the dependency list R, the left and right sides of the arrow are marked as RL relationship list and RR relationship list respectively.
[0147] Step S803: convert the dependency list in a first conversion manner to obtain a first display effect diagram.
[0148] In step S803, the first display effect diagram includes a separator and each relationship pair in the dependency list.
[0149] Among them, the first display effect diagram is Figure 9(a), and the separation symbol is “|”.
[0150] In actual applications, the right side of the separator is where the individual relationship pairs in the dependency list are placed.
[0151] Step S804: convert the indicator list using a second conversion method to obtain a second display effect diagram.
[0152] In step S804, the second display effect diagram includes a separator, processed indicators, and indicators to be processed.
[0153] Processed indicators are marked with the first label, and indicators to be processed are marked with the second label.
[0154] Among them, the second display effect diagram is Figure 9(b), and the separation symbol is “|”.
[0155] In actual applications, the processed indicators are placed on the left side of the separator, and the indicators to be processed are placed on the right side of the separator. That is, the indicators on the left side of the separator "|" indicate that they have been processed, and the indicators on the right side are waiting to be processed.
[0156] Step S805: Based on the first display effect diagram and the second display effect diagram, starting from each indicator in the indicator list, the first indicator appearing in the RR relationship list is deleted from the indicators to be processed in turn.
[0157] It should be noted that starting from each indicator in the indicator list means that all indicators are waiting to be sorted, that is, starting from the separator symbol in the indicator list means that all indicators are waiting to be sorted.
[0158] Step S806: Set the second indicator that does not appear in the RR relationship list as the first label, and delete the relationship pair about the first indicator that appears in the dependency relationship list until the final dependency relationship order of each indicator is obtained.
[0159] In the process of specifically implementing step S805 and step S806, based on the first display effect diagram and the second display effect diagram, starting from the first indicator in the indicator list, the first indicator that appeared in the RR relationship list is deleted from the indicators to be processed, and the second indicator that did not appear in the RR relationship list is set as the first label, that is, the second indicator that did not appear in the RR relationship list is placed on the left side of the separator, and the relationship pair regarding the first indicator that appeared in the dependency list is deleted.
[0160] Next, starting from the second indicator in the indicator list, delete the first indicator that appears in the RR relationship list from the indicators to be processed, set the second indicator that does not appear in the RR relationship list as the first label, and delete the relationship pair about the first indicator that appears in the dependency list.
[0161] And so on, until the final dependency order of each indicator is obtained.
[0162] It can be understood that based on the first display effect diagram and the second display effect diagram, starting from the first indicator to the last indicator in the indicator list, the indicators that have appeared in the RR relationship list are crossed out in the list waiting to be sorted, and the uncrossed indicators are placed on the left side of the separator. Then, the relationship pairs of the indicators on the left side of the separator are crossed out from the dependency list at the same time until the final dependency order of each indicator is obtained.
[0163] Let's take an example to illustrate the above content. From the above content, we can see that Figure 4 The indicator list in is: T(A, B, C, D, E, F, G), and the dependency list is: R(A->C, A->D, A->G, B->C, D->B, D->E, F->E, G->F, B->G). Figure 4 In the dependency list R, the left and right sides of the arrow are marked as RL relationship list and RR relationship list respectively.
[0164] by Figure 4 The operation steps of the indicator relationship in are as follows:
[0165] Starting from each indicator in the indicator list, delete the first indicator that appears in the RR relationship list in the indicators to be processed one by one, set the second indicator that does not appear in the RR relationship list as the first label, and delete the relationship pair about the first indicator that appears in the dependency list. As shown in Figure 9, indicator A has been arranged.
[0166] Repeat the previous steps and get the following Figure 10 The final dependency order of the indicators is ADBCGFE.
[0167] It should be noted that there is not necessarily only one dependency, such as Figure 10 As shown in Figure 2, it can be seen from steps 4 and 5 that CG can be interchanged, so ADBGCFE is also the final dependency order of each indicator.
[0168] A reporting exception processing method provided in an embodiment of the present invention establishes a dependency tree relationship algorithm to provide conditions for subsequently using the dependency tree relationship algorithm to find the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, thereby enabling timely adjustment of abnormal indicator data, improving the processing efficiency of reporting exceptions, and improving reporting efficiency and reporting accuracy.
[0169] Corresponding to the method for handling exceptions as shown in the above embodiment of the present invention, the embodiment of the present invention also provides a device for handling exceptions, such as Figure 11 As shown, the reporting exception processing device includes: a receiving module 111, a first processing module 112, a second processing module 113 and a correction module 114.
[0170] The receiving module 111 is used to receive the abnormality report receipt sent by the regulatory agency.
[0171] The first processing module 112 is configured to determine abnormal indicator data according to the abnormality reporting receipt, and modify any abnormal indicator data to obtain modified indicator data and indicator items to be modified.
[0172] The indicator item to be modified includes multiple indicators to be modified.
[0173] The second processing module 113 is used to use a pre-established dependency tree relationship algorithm to search for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and determine the indicator data of all indicators associated with the indicator to be modified in the modified indicator data.
[0174] The correction module 114 is configured to correct the indicator data of all indicators associated with the indicator to be modified according to the verification rules between indicators in the pre-established verification formula table.
[0175] It should be noted that the specific principles and execution processes of each module in the reporting exception handling device disclosed in the above-mentioned embodiment of the present invention are the same as those of the reporting exception handling method implemented in the above-mentioned present invention. Please refer to the corresponding parts of the reporting exception handling method disclosed in the above-mentioned embodiment of the present invention, and no further details will be given here.
[0176] A reporting exception processing device provided by an embodiment of the present invention receives an exception reporting receipt sent by a regulatory agency; determines abnormal indicator data based on the abnormal reporting receipt, and modifies any abnormal indicator data to obtain modified indicator data and indicator items to be modified, wherein the indicator items to be modified include multiple indicators to be modified; uses a pre-established dependency tree relationship algorithm to find the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and determines the indicator data of all indicators associated with the indicator to be modified in the modified indicator data; and corrects the indicator data of all indicators associated with the indicator to be modified based on the verification rules between indicators in the pre-established verification formula table. In this solution, after modifying any abnormal indicator data, uses a dependency tree relationship algorithm to find the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and corrects the indicator data of all indicators associated with the indicator to be modified based on the verification rules between indicators in the verification formula table, thereby timely adjusting the abnormal indicator data, improving the processing efficiency of reporting abnormalities, and improving reporting efficiency and reporting accuracy.
[0177] Optional, based on the above Figure 11 The second processing module 113 shown includes:
[0178] The first generating unit is configured to generate an indicator list corresponding to the indicator item to be modified based on a pre-established verification formula table.
[0179] The second generating unit is used to generate a dependency graph based on the indicator list.
[0180] The search unit is used to use a pre-established dependency tree relationship algorithm to search the source indicator in the indicator item to be modified and all other indicators that have a logical verification relationship with the indicator to be modified in the dependency relationship graph.
[0181] A reporting exception processing device provided by an embodiment of the present invention generates a dependency graph and uses a dependency tree relationship algorithm to search for the source indicator in the indicator item to be modified and all other indicators that have a logical verification relationship with the indicator to be modified in the dependency graph, thereby providing a prerequisite for subsequent timely adjustment of abnormal indicator data, thereby improving the processing efficiency of reporting exceptions and improving reporting efficiency and reporting accuracy.
[0182] Optional, based on the above Figure 11 The correction module 114 shown includes:
[0183] The determination unit is used to determine, based on a dependency tree relationship algorithm, starting from the source indicator, the verification formulas corresponding to all other indicators that have a logical verification relationship with the indicator to be modified.
[0184] The correction unit is used to correct the indicator data of each indicator associated with the indicator to be modified in turn according to the verification formula corresponding to all other indicators that have a logical verification relationship with the indicator to be modified, until the indicator data of all indicators associated with the indicator to be modified are corrected.
[0185] A reporting exception processing device provided by an embodiment of the present invention starts from the source indicator and corrects the indicator data of all indicators associated with the indicator to be modified in sequence according to the verification formulas corresponding to all other indicators that have a logical verification relationship with the indicator to be modified, thereby timely adjusting the abnormal indicator data, improving the processing efficiency of reporting exceptions, and improving the reporting efficiency and reporting accuracy.
[0186] Based on the above Figure 11 The abnormality reporting processing device shown is combined with Figure 11 The reporting exception handling device further provides a first pre-establishment module for pre-establishing a verification formula table.
[0187] The first pre-built module includes:
[0188] The acquisition unit is used to acquire indicator data and determine each indicator in the indicator data.
[0189] The first determining unit is configured to determine, based on the comparison type, the indicators in the left and right terms of the verification formula and the operation symbols between the indicators.
[0190] The second determining unit is used to determine the final values corresponding to the left and right terms according to the operation symbol.
[0191] The obtaining unit is used to establish verification rules between various indicators according to the comparison type and obtain the verification formula corresponding to each indicator.
[0192] The establishment unit is used to establish a verification formula table based on the verification formula corresponding to each indicator.
[0193] A reporting exception processing device provided in an embodiment of the present invention establishes a verification formula table to provide conditions for subsequently correcting the indicator data of all indicators associated with the indicator to be modified based on the verification rules between the indicators in the verification formula table, thereby being able to timely adjust the abnormal indicator data, improve the processing efficiency of reporting exceptions, and improve the reporting efficiency and reporting accuracy.
[0194] Based on the above Figure 11 The abnormality reporting processing device shown is combined with Figure 11 The reporting exception handling device is further provided with a second pre-establishment module for pre-establishing a dependency tree relationship algorithm.
[0195] The second pre-built module includes:
[0196] The determination unit is used to obtain indicator data, determine each indicator in the indicator data, and determine an indicator list corresponding to all indicators.
[0197] The marking unit is used to list the dependency lists of all indicators in the indicator list, and mark the RL relationship list and the RR relationship list in the dependency list.
[0198] The first obtaining unit is used to convert the dependency list in a first conversion manner to obtain a first display effect diagram.
[0199] The first display effect diagram includes a separator symbol and each relationship pair in the dependency list.
[0200] The second obtaining unit is used to convert the indicator list in a second conversion manner to obtain a second display effect diagram.
[0201] Among them, the second display effect diagram includes a separator symbol, processed indicators and indicators to be processed, the processed indicators are marked as the first label, and the indicators to be processed are marked as the second label.
[0202] The first processing unit is used to delete the first indicator appearing in the RR relationship list from the indicators to be processed in sequence starting from each indicator in the indicator list based on the first display effect diagram and the second display effect diagram.
[0203] The second processing unit is used to set the second indicator that does not appear in the RR relationship list as the first label, and delete the relationship pair about the first indicator that appears in the dependency list until the final dependency order of each indicator is obtained.
[0204] A reporting exception processing device provided by an embodiment of the present invention establishes a dependency tree relationship algorithm to provide conditions for subsequently using the dependency tree relationship algorithm to find the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, thereby being able to timely adjust the abnormal indicator data, improve the processing efficiency of reporting exceptions, and improve the reporting efficiency and reporting accuracy.
[0205] Each embodiment in this specification is described in a progressive manner. The same or similar parts between the embodiments can be referred to each other. Each embodiment focuses on the differences from other embodiments. In particular, for system or system embodiments, since they are basically similar to method embodiments, the description is relatively simple. For relevant parts, refer to the partial description of the method embodiment. The system and system embodiments described above are merely schematic, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the solution of this embodiment. A person of ordinary skill in the art can understand and implement it without expending creative work.
[0206] Professionals may further appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the above description has generally described the components and steps of each example according to their functions. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professionals and technicians may use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of the present invention.
[0207] The above description of the disclosed embodiments is intended to enable one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be readily apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention is not limited to the embodiments shown herein but is intended to conform to the widest scope consistent with the principles and novel features disclosed herein.
Claims
1. A method for handling abnormal reporting, characterized in that: The method comprises: After assembling various financial statistical regulatory indicators into a message and submitting it to the regulatory agency, receive the abnormal reporting receipt sent by the regulatory agency; Determine abnormal indicator data according to the abnormal reporting receipt, and modify any of the abnormal indicator data to obtain modified indicator data and indicator items to be modified, and send the modified indicator data and indicator items to be modified to the data correction area, wherein the indicator items to be modified include multiple indicators to be modified; In the data correction area, using a pre-established dependency tree relationship algorithm, searching for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified, and determining indicator data of all indicators associated with the indicator to be modified in the modified indicator data; According to the verification rules between the indicators in the pre-established verification formula table, the indicator data of all indicators associated with the indicator to be modified are corrected.
2. The method according to claim 1, characterized in that The method of using a pre-established dependency tree relationship algorithm to search for the source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified includes: Generate an indicator list corresponding to the indicator item to be modified based on a pre-established verification formula table; generating a dependency graph based on the indicator list; By using a pre-established dependency tree relationship algorithm, the source indicator in the indicator item to be modified and all other indicators that have a logical verification relationship with the indicator to be modified are searched in the dependency relationship graph.
3. The method according to claim 1, characterized in that The step of correcting the indicator data of all indicators associated with the indicator to be modified according to the verification rules between the indicators in the pre-established verification formula table includes: Based on the dependency tree relationship algorithm, starting from the source indicator, the verification formulas corresponding to all other indicators that have a logical verification relationship with the indicator to be modified are determined in sequence; For each indicator data associated with the indicator to be modified, the indicator data of all indicators associated with the indicator to be modified are corrected in turn according to the verification formulas corresponding to all other indicators that have a logical verification relationship with the indicator to be modified, until the indicator data of all indicators associated with the indicator to be modified are corrected.
4. The method according to claim 1, wherein The process of pre-establishing the verification formula table includes: Obtaining indicator data and determining each indicator in the indicator data; Determining the indicators in the left and right terms of the verification formula and the operation symbols between the indicators based on the comparison type; According to the operation symbol, determine the final value corresponding to each of the left and right terms; According to the comparison type, establishing verification rules between the various indicators, and obtaining verification formulas corresponding to the various indicators; Based on the verification formulas corresponding to the various indicators, a verification formula table is established.
5. The method according to claim 1, wherein The process of pre-establishing the dependency tree relationship algorithm includes: Obtaining indicator data, determining each indicator in the indicator data, and determining an indicator list corresponding to all the indicators; List the dependency lists of all the indicators in the indicator list, and mark the RL relationship list and the RR relationship list in the dependency list; Converting the dependency list in a first conversion manner to obtain a first display effect diagram, wherein the first display effect diagram includes a separator and each relationship pair in the dependency list; Converting the indicator list in a second conversion mode to obtain a second display effect diagram, wherein the second display effect diagram includes the separator, the processed indicator, and the indicator to be processed, the processed indicator is marked as a first label, and the indicator to be processed is marked as a second label; Based on the first display effect diagram and the second display effect diagram, starting from each indicator in the indicator list, delete the first indicator that appears in the RR relationship list from the indicators to be processed; The second indicator that does not appear in the RR relationship list is set as the first label, and the relationship pairs about the first indicator that appear in the dependency list are deleted until the final dependency order of each of the indicators is obtained.
6. A reporting exception handling device, characterized in that: The device comprises: A receiving module is used to receive an exception reporting receipt sent by the regulatory authority after assembling various financial statistical regulatory indicators into a message and submitting it to the regulatory authority; a first processing module, configured to determine abnormal indicator data according to the abnormal reporting receipt, and modify any of the abnormal indicator data to obtain modified indicator data and indicator items to be modified, and send the modified indicator data and indicator items to be modified to a data correction area, wherein the indicator items to be modified include multiple indicators to be modified; a second processing module configured to search, within the data correction area, for a source indicator in the indicator item to be modified and all indicators associated with the indicator to be modified using a pre-established dependency tree relationship algorithm, and determine indicator data of all indicators associated with the indicator to be modified in the modified indicator data; The correction module is used to correct the indicator data of all indicators associated with the indicator to be modified according to the verification rules between indicators in the pre-established verification formula table.
7. The device according to claim 6, characterized in that The second processing module includes: A first generating unit is configured to generate an indicator list corresponding to the indicator item to be modified based on a pre-established verification formula table; A second generating unit, configured to generate a dependency graph based on the indicator list; The search unit is used to use a pre-established dependency tree relationship algorithm to search the source indicator in the indicator item to be modified and all other indicators that have a logical verification relationship with the indicator to be modified in the dependency relationship graph.
8. The device according to claim 6, characterized in that The correction module includes: a determination unit configured to determine, based on the dependency tree relationship algorithm, starting from the source indicator, verification formulas corresponding to all remaining indicators that have a logical verification relationship with the indicator to be modified; The correction unit is used to correct the indicator data of each indicator associated with the indicator to be modified in turn according to the verification formula corresponding to all other indicators that have a logical verification relationship with the indicator to be modified, until the indicator data of all indicators associated with the indicator to be modified are corrected.
9. The device according to claim 6, characterized in that Also includes: A first pre-establishment module is used to pre-establish a verification formula table; The first pre-built module includes: an acquisition unit, configured to acquire indicator data and determine each indicator in the indicator data; A first determining unit is configured to determine, based on a comparison type, the indicators in the left and right terms of the verification formula and the operation symbols between the indicators; A second determining unit is configured to determine the final values corresponding to the left and right terms according to the operation symbol; an obtaining unit, configured to establish verification rules between the indicators according to the comparison type, and obtain verification formulas corresponding to the indicators; An establishing unit is used to establish a verification formula table based on the verification formula corresponding to each of the indicators.
10. The device according to claim 6, characterized in that Also includes: A second pre-established module is used to pre-establish a dependency tree relationship algorithm; The second pre-built module includes: a determination unit, configured to obtain indicator data, determine each indicator in the indicator data, and determine an indicator list corresponding to all the indicators; a marking unit, configured to list dependency lists of all the indicators in the indicator list, and mark an RL relationship list and an RR relationship list in the dependency relationship list; A first obtaining unit is configured to convert the dependency list in a first conversion manner to obtain a first display effect diagram, wherein the first display effect diagram includes a separator and each relationship pair in the dependency list; a second obtaining unit, configured to convert the indicator list in a second conversion manner to obtain a second display effect diagram, wherein the second display effect diagram includes the separator, the processed indicator, and the indicator to be processed, the processed indicator is marked as a first label, and the indicator to be processed is marked as a second label; a first processing unit configured to, based on the first display effect diagram and the second display effect diagram, sequentially delete, starting with each indicator in the indicator list, a first indicator that appears in the RR relationship list from the indicators to be processed; The second processing unit is used to set the second indicator that does not appear in the RR relationship list as the first label, and delete the relationship pairs about the first indicator that appear in the dependency list until the final dependency order of each of the indicators is obtained.
Citation Information
Patent Citations
A data quality management method and system
CN109522318B