Method, device and medium for financial data aggregation based on an organization tree

Abstract

The application relates to a financial data aggregation processing method and device based on an institution tree, computer equipment, a storage medium and a computer program product, and relates to the fields of financial technology and big data technology. The application can improve the execution efficiency of financial institution tree type data aggregation. The method comprises the following steps: acquiring a financial institution tree to be processed; performing vertical completion, horizontal flattening and vertical drilling processing on the financial institution tree type data in the financial institution tree to obtain financial institution tree type auxiliary data; the financial institution tree type auxiliary data comprises multiple components; the number of the components corresponds to the number of layers of the financial institution tree; acquiring each item of financial detailed data; associating each item of the financial detailed data to the financial institution tree type auxiliary data according to the corresponding financial institution of each item of the financial detailed data, to form financial detailed aggregation data; and providing corresponding financial detailed aggregation data to a query user from the financial detailed aggregation data according to the information about the institution and the authority of the query user.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of financial technology and big data, and in particular to a financial data aggregation processing method and device based on an organization tree, a computer device, a storage medium and a computer program product. BACKGROUND

[0002] With the development of big data technology, a set with hierarchical relationship composed of one or more limited nodes appears, which is called tree data. The tree structure in the tree data represents the hierarchical relationship of the data, and the hierarchical aggregation and analysis of the data are generally implemented using a recursive algorithm.

[0003] In the prior art, when implementing tree data aggregation, the big data Hive generally uses a recursive algorithm to recursively aggregate one layer at a time according to the hierarchy. However, for a large number of hierarchies, the recursive aggregation process is relatively cumbersome, and the resources required by the recursive algorithm are greatly increased, resulting in the problems of complex implementation and slow execution efficiency in the current technology for tree data aggregation. SUMMARY

[0004] Therefore, it is necessary to provide a financial data aggregation processing method and device based on an organization tree, a computer device, a computer readable storage medium and a computer program product to solve the above technical problems.

[0005] In a first aspect, the present application provides a financial data aggregation processing method based on an organization tree. The method comprises:

[0006] obtaining a financial organization tree to be processed;

[0007] performing vertical completion, horizontal flattening and vertical drilling processing on the financial organization tree data in the financial organization tree to obtain financial organization tree auxiliary data; the financial organization tree auxiliary data comprises a plurality of components; the number of components corresponds to the number of layers of the financial organization tree; the components include one or more financial institution information items, each financial institution information item includes information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the scope of the superior institution is determined by the hierarchy of the financial organization tree corresponding to the component;

[0008] obtaining each item of financial detail data;

[0009] associating each item of financial detail data to the financial organization tree auxiliary data according to the corresponding financial institution of each item of financial detail data to form financial detail aggregation data;

[0010] providing financial detail aggregation data of a corresponding institution to the query user from the financial detail aggregation data according to the institution and permission information of the query user.

[0011] In one of the embodiments, the vertical complement, horizontal flattening and vertical drilling of the financial institution tree data in the financial institution tree are performed to obtain financial institution tree auxiliary data, including:

[0012] According to each level of the financial institution tree, the records of all levels in the financial institution tree data are complemented upwards to obtain upward complement auxiliary data; according to each level of the financial institution tree, the records of all levels in the upward complement auxiliary data are horizontally flattened to obtain horizontally flattened auxiliary data; based on the horizontally flattened auxiliary data, a drilling level is added and the records of the drilling level are complemented to obtain vertical drilling auxiliary data as the financial institution tree auxiliary data.

[0013] In one of the embodiments, after obtaining the financial detail data, it further includes:

[0014] According to each financial institution code in the financial institution tree, the respective corresponding financial institution code of the financial detail data is determined; the resource type conversion processing is performed on the resource value corresponding to each financial institution code to obtain the amount of detail data containing resource values represented in the same resource type.

[0015] In one of the embodiments, before associating the financial detail data to the financial institution tree auxiliary data according to the respective corresponding financial institution of the financial detail data, it further includes:

[0016] The corresponding financial institution code in the financial detail data is identified and obtained; according to the financial institution code, the respective corresponding financial institution of the financial detail data in the financial institution tree auxiliary data is determined; the associating the financial detail data to the financial institution tree auxiliary data according to the respective corresponding financial institution of the financial detail data includes: extracting the to-be-associated data in the financial detail data; according to the preset association condition, the to-be-associated data is added to the financial institution tree auxiliary data.

[0017] In one of the embodiments, the providing of the financial detail summary data of the corresponding institution to the query user from the financial detail summary data according to the institution and permission information of the query user includes:

[0018] obtaining target data information to be queried, an organization to which the query user belongs, and permission information of the query user; determining whether the target data information is included in the permission information; in a case where the target data information is included in the permission information, identifying, according to the organization to which the query user belongs, financial summary data of a corresponding organization from the financial summary data as target data obtained by the query; and sending the target data obtained by the query to the query user.

[0019] In one of the embodiments, the identifying, according to the organization to which the query user belongs, of the financial summary data of the corresponding organization from the financial summary data includes:

[0020] matching a first-level organization according to the organization to which the query user belongs; determining a second-level organization according to the organization to which the query user belongs and the matched first-level organization; identifying, from the financial summary data, to-be-summarized data respectively associated with the first-level organization and the second-level organization, and summarizing the to-be-summarized data to obtain the financial summary data.

[0021] In a second aspect, the application further provides a financial data summarization processing device based on an organization tree. The device includes:

[0022] a first obtaining module configured to obtain a financial organization tree to be processed;

[0023] a data supplementing module configured to perform vertical completion, horizontal flattening, and vertical drilling processing on financial organization tree data in the financial organization tree to obtain financial organization tree auxiliary data; the financial organization tree auxiliary data includes a plurality of components; a number of the components corresponds to a number of layers of the financial organization tree; the components include one or more financial institution information items, each of which includes information of a corresponding financial institution and information of each superior organization of the corresponding financial institution; a range of the superior organization is determined by a level of the financial organization tree corresponding to the component;

[0024] a second obtaining module configured to obtain each item of financial detail data;

[0025] a data correlating module configured to correlate, according to each corresponding financial institution of the each item of financial detail data, the each item of financial detail data to the financial organization tree auxiliary data to form financial summary data;

[0026] a query providing module configured to provide, according to an organization to which a query user belongs and permission information of the query user, financial summary data of a corresponding organization from the financial summary data to the query user.

[0027] In a third aspect, the present application provides a computer device. The computer device comprises a memory and a processor. The memory stores a computer program. The processor implements the following steps when executing the computer program:

[0028] obtaining a financial institution tree to be processed; performing vertical completion, horizontal flattening and vertical drilling on financial institution tree data in the financial institution tree to obtain financial institution tree auxiliary data; the financial institution tree auxiliary data comprises a plurality of components; the number of components corresponds to the number of layers of the financial institution tree; the components comprise one or more financial institution information items, each financial institution information item comprising information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the range of the superior institutions is determined by the level of the financial institution tree corresponding to the components; obtaining each item of financial detail data; associating each item of financial detail data to the financial institution tree auxiliary data according to the corresponding financial institution of each item of financial detail data to form financial detail summary data; and providing financial detail summary data of a corresponding institution to a query user from the financial detail summary data according to the institution and permission information of the query user.

[0029] In a fourth aspect, the present application provides a computer readable storage medium. The computer readable storage medium stores a computer program. The computer program is executed by a processor to implement the following steps:

[0030] obtaining a financial institution tree to be processed; performing vertical completion, horizontal flattening and vertical drilling on financial institution tree data in the financial institution tree to obtain financial institution tree auxiliary data; the financial institution tree auxiliary data comprises a plurality of components; the number of components corresponds to the number of layers of the financial institution tree; the components comprise one or more financial institution information items, each financial institution information item comprising information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the range of the superior institutions is determined by the level of the financial institution tree corresponding to the components; obtaining each item of financial detail data; associating each item of financial detail data to the financial institution tree auxiliary data according to the corresponding financial institution of each item of financial detail data to form financial detail summary data; and providing financial detail summary data of a corresponding institution to a query user from the financial detail summary data according to the institution and permission information of the query user.

[0031] In a fifth aspect, the present application provides a computer program product. The computer program product comprises a computer program. The computer program is executed by a processor to implement the following steps:

[0032] obtaining a financial institution tree to be processed; performing vertical completion, horizontal flattening and vertical drilling on financial institution tree data in the financial institution tree to obtain financial institution tree auxiliary data; the financial institution tree auxiliary data comprises a plurality of components; the number of components corresponds to the number of layers of the financial institution tree; the components include one or more financial institution information items, each financial institution information item including information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the range of the superior institutions is determined by the level of the financial institution tree corresponding to the components; obtaining each item of financial detail data; associating each item of financial detail data to the financial institution tree auxiliary data according to the financial institution corresponding to each item of financial detail data, to form financial detail summary data; and providing financial detail summary data of a corresponding institution to a query user from the financial detail summary data according to the institution and permission information of the query user.

[0033] The financial data summary processing method, device, computer device, storage medium and computer program product based on the institution tree, by obtaining a financial institution tree to be processed; performing vertical completion, horizontal flattening and vertical drilling on financial institution tree data in the financial institution tree to obtain financial institution tree auxiliary data; the financial institution tree auxiliary data comprises a plurality of components; the number of components corresponds to the number of layers of the financial institution tree; the components include one or more financial institution information items, each financial institution information item including information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the range of the superior institutions is determined by the level of the financial institution tree corresponding to the components; obtaining each item of financial detail data; associating each item of financial detail data to the financial institution tree auxiliary data according to the financial institution corresponding to each item of financial detail data, to form financial detail summary data; and providing financial detail summary data of a corresponding institution to a query user from the financial detail summary data according to the institution and permission information of the query user. In this way, by performing vertical completion, horizontal flattening and vertical drilling on the financial institution tree data, various financial institution tree auxiliary data is generated in advance; each item of financial detail data is associated to the financial institution tree auxiliary data to form financial detail summary data; thereby, when performing financial data summary, efficient data summary analysis is realized based on big data Hive through a unified and simple table association method, avoiding complex processes such as recursive summary of tree data with many levels, and reducing resources occupied when performing financial data summary, thereby effectively improving the execution efficiency of financial institution tree data summary. BRIEF DESCRIPTION OF DRAWINGS

[0034] Figure 1 An application environment diagram of the financial data summary processing method based on the institution tree in one embodiment;

[0035] Figure 2 A flowchart of a financial data aggregation processing method based on an organization tree in an embodiment;

[0036] Figure 3 A schematic diagram of a three-layer financial organization tree in an embodiment;

[0037] Figure 4 A flowchart of a financial data aggregation processing method based on an organization tree in an embodiment;

[0038] Figure 5 A structural block diagram of a financial data aggregation processing device based on an organization tree in an embodiment;

[0039] Figure 6 An internal structure diagram of a computer device in an embodiment. DETAILED DESCRIPTION

[0040] In order to make the purposes, technical solutions and advantages of the present application clearer, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and do not limit the present application.

[0041] It should be noted that the customer information (including but not limited to customer device information, customer personal information, etc.) and data (including but not limited to data for analysis, stored data, displayed data, etc.) involved in the present application are all information and data authorized by the customer or fully authorized by all parties, and the collection, use and processing of related data need to comply with relevant laws, regulations and standards of relevant countries and regions.

[0042] The financial data aggregation processing method based on an organization tree provided by the embodiments of the present application can be applied in an application environment as shown in the figure. Figure 1 The client 101 communicates with the server 102 through the network. The data storage system can store the data required to be processed by the server 102. The data storage system can be integrated on the server 102, or placed on the cloud or other network servers.

[0043] Specifically, the financial data aggregation processing method based on an organization tree provided by the embodiments of the present application can be executed by the server 102.

[0044] Exemplarily, the server 102 acquires a financial institution tree to be processed; performs vertical completion, horizontal flattening and vertical drilling on the financial institution tree-shaped data in the financial institution tree to obtain financial institution tree-shaped auxiliary data; the financial institution tree-shaped auxiliary data comprises a plurality of components; the number of the components corresponds to the number of layers of the financial institution tree; each component comprises one or more financial institution information items, and each financial institution information item comprises information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the range of the superior institutions is determined by the level of the financial institution tree corresponding to the component; the server 102 acquires each item of financial detail data; associates each item of the financial detail data to the financial institution tree-shaped auxiliary data according to the corresponding financial institution of each item of the financial detail data, to form financial detail summary data; and provides the financial detail summary data of the corresponding institution to the query user from the financial detail summary data according to the institution and permission information of the query user.

[0045] In the application environment as shown in Figure 1 , the client 101 can be, but is not limited to, various personal computers, notebook computers, smart phones and tablet computers. The server 102 can be implemented by an independent server or a server cluster composed of multiple servers.

[0046] In one embodiment, as shown in Figure 2 , a financial data summary processing method based on an institution tree is provided. Taking the server 102 in Figure 1 as an example, the method comprises the following steps:

[0047] Step S201: acquiring a financial institution tree to be processed.

[0048] The institution tree is a form of tree-shaped data, and the tree-shaped data is a set with hierarchical relationship composed of n (n>=1) limited nodes. As shown in Figure 3 , it is a schematic diagram of a three-layer financial institution tree.

[0049] Specifically, the server 102 acquires a financial institution tree to be processed in response to a financial data summary processing request based on an institution tree.

[0050] Step S202: performing vertical completion, horizontal flattening and vertical drilling on the financial institution tree-shaped data in the financial institution tree to obtain financial institution tree-shaped auxiliary data; the financial institution tree-shaped auxiliary data comprises a plurality of components; the number of the components corresponds to the number of layers of the financial institution tree; each component comprises one or more financial institution information items, and each financial institution information item comprises information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the range of the superior institutions is determined by the level of the financial institution tree corresponding to the component.

[0051] The vertical completion refers to vertically completing records of all levels according to the hierarchical structured data of the agency tree. There are two ways, one is upward completion, and the other is downward completion. The application mainly acts on the summary, so upward completion is selected.

[0052] The horizontal flattening refers to horizontally flattening records of all levels according to the hierarchical structured data of the agency tree.

[0053] The vertical drilling refers to drilling down to the horizontal flattened auxiliary data of the agency tree, to achieve vertical completion of the data.

[0054] Specifically, the server 102 sequentially performs vertical completion, horizontal flattening and vertical drilling on the financial agency tree data in the financial agency tree, to obtain financial agency tree auxiliary data. The financial agency tree auxiliary data includes multiple components. The number of components corresponds to the number of layers of the financial agency tree. The components include one or more financial agency information items. Each financial agency information item includes information of a corresponding financial agency and information of each superior agency of the corresponding financial agency. The range of the superior agency is determined by the level of the financial agency tree corresponding to the component.

[0055] In step S203, each item of financial detail data is obtained.

[0056] The financial detail data includes but is not limited to agency code, customer type, specific amount and other information.

[0057] Specifically, the server 102 obtains each item of financial detail data.

[0058] In step S204, according to the respective corresponding financial agencies of each item of financial detail data, each item of financial detail data is associated to the financial agency tree auxiliary data, to form financial detail summary data.

[0059] The financial detail summary data is an ordered data set that combines each item of financial detail data and the financial agency tree auxiliary data.

[0060] Specifically, the server 102 identifies the respective corresponding financial agencies of each item of financial detail data, and then according to the respective corresponding financial agencies of each item of financial detail data, associates each item of financial detail data to the financial agency tree auxiliary data, to form the financial detail summary data.

[0061] In step S205, according to the agency and permission information of the query user, the financial detail summary data of the corresponding agency is provided to the query user from the financial detail summary data.

[0062] The permission information is used to indicate whether the query user has access to the corresponding resource.

[0063] Specifically, the server 102 queries and obtains the affiliated institution and permission information of the query user, and provides the financial summary data of the corresponding institution to the query user from the financial summary data according to the affiliated institution and permission information of the query user.

[0064] For example, the affiliated institution of the query user A is Guangdong Province, and the permission information is the financial summary data of the affiliated institution and the financial summary data of each subordinate institution. Then, the server 102 provides the financial summary data of Guangdong Province and each subordinate city to the query user A according to the affiliated institution and permission information of the query user A.

[0065] In the above financial data summary processing method based on the institution tree, the financial institution tree to be processed is obtained; the financial institution tree data in the financial institution tree is processed by vertical completion, horizontal flattening and vertical drilling to obtain financial institution tree auxiliary data; the financial institution tree auxiliary data includes multiple components; the number of components corresponds to the number of layers of the financial institution tree; the components include one or more financial institution information items, and each financial institution information item includes information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the range of the superior institution is determined by the level of the financial institution tree corresponding to the component; each item of financial detail data is obtained; each item of financial detail data is associated to the financial institution tree auxiliary data according to the corresponding financial institution of each item of financial detail data to form financial summary data; and the financial summary data of the corresponding institution is provided to the query user from the financial summary data according to the affiliated institution and permission information of the query user. In this way, by performing preprocessing operations such as vertical completion, horizontal flattening and vertical drilling on the financial institution tree data, various financial institution tree auxiliary data is generated in advance; each item of financial detail data is associated to the financial institution tree auxiliary data to form the financial summary data; and when performing financial data summary, efficient data summary analysis is realized based on big data Hive through a unified and simple table association method, the tedious and complex process of recursive summary on the tree data with many levels is avoided, the resources occupied when performing financial data summary are reduced, and the execution efficiency of the financial institution tree data summary is effectively improved.

[0066] In one embodiment, the step S202 of performing vertical completion, horizontal flattening and vertical drilling on the financial institution tree data in the financial institution tree to obtain the financial institution tree auxiliary data includes the following steps:

[0067] According to each level of the financial institution tree, records of all levels in the financial institution tree data are complemented upwards to obtain upward complement auxiliary data; according to each level of the financial institution tree, records of all levels in the upward complement auxiliary data are horizontally flattened to obtain horizontally flattened auxiliary data; based on the horizontally flattened auxiliary data, a down-drilling level is added, and records of the down-drilling level are complemented to obtain vertical down-drilling auxiliary data as the financial institution tree auxiliary data.

[0068] Specifically, the server 102, according to each level of the financial institution tree, complements records of all levels in the financial institution tree data upwards to obtain upward complement auxiliary data; according to each level of the financial institution tree, records of all levels in the upward complement auxiliary data are horizontally flattened to obtain horizontally flattened auxiliary data; based on the horizontally flattened auxiliary data, a down-drilling level is added, and records of the down-drilling level are complemented to obtain vertical down-drilling auxiliary data as the financial institution tree auxiliary data.

[0069] For example, the specific steps of upward complement are as follows:

[0070] A. Create an institution tree vertical upward complement auxiliary data (table name is set as branch_supcompl_info) structure, and the fields include institution code (stru_id), institution name (stru_name), superior institution code (sup_stru_id), superior institution name (sup_stru_name), and upward level (sup_level).

[0071] B. Generate data with upward level 0, which is data with the superior institution being itself.

[0072] C. Generate data with upward level 1, which is data insertion with the superior institution being the superior of itself.

[0073] D. Generate data with upward level 2, which is based on the data with upward level 1 in C, and uses the superior institution code to associate the branch_info table to obtain the data of the superior of the superior institution as the data with upward level 2 for insertion.

[0074] E. Recursively according to the logic of D until there is no more superior data.

[0075] Table 1: Institution tree structured data

[0076]

[0077] The institution tree vertical upward complement auxiliary data finally generated based on the institution tree structured data in Table 1 is shown in Table 2.

[0078] Table 2: Institution tree vertical upward complement auxiliary data

[0079]

[0080]

[0081] The specific steps of horizontal flattening are as follows:

[0082] A. Create a horizontal flattening auxiliary data structure of the branch tree (table name is set as branch_hori_info), and the fields include branch code (stru_id), branch name (stru_name), first-level branch code (stru_id_lv1), first-level branch name (stru_name_lv1), second-level branch code (stru_id_lv2), second-level branch name (stru_name_lv2), third-level branch code (stru_id_lv3), third-level branch name (stru_name_lv3), and the specific number of levels is defined according to the actual tree structure.

[0083] B. According to the vertical upward completion auxiliary data of the branch tree, group according to the branch code, and obtain the maximum upward level of each branch code.

[0084] C. According to the vertical upward completion auxiliary data of the branch tree, associate the maximum upward level data of each branch code in B, and then group according to the branch code, use the maximum upward level of the branch minus the upward level of the current record, if equal to 0, it is a first-level branch code, if it is 1, it is a second-level branch code, and so on.

[0085] The final horizontal flattening auxiliary data of the branch tree based on the vertical upward completion auxiliary data of the branch tree in Table 2 is shown in Table 3.

[0086] Table 3 Horizontal flattening auxiliary data of the branch tree

[0087]

[0088] The specific steps of vertical drilling are as follows:

[0089] A. Create a vertical drilling auxiliary data structure of the branch tree (table name is set as branch_drill_info), which is based on the horizontal flattening auxiliary data of the branch tree, and adds a drilling level (drill_level).

[0090] B. Generate data with drilling level 0, which is the insertion of the horizontal flattening auxiliary data of the branch tree.

[0091] C. Generate data with drilling level 1, which is based on the data with drilling level 0, and only obtain the data of the second-level branch that is not empty, and then treat the second-level branch as a first-level branch and the third-level branch as a second-level branch, and so on.

[0092] D. Generate the data of the down-drilling level 2, which is based on the data of the down-drilling level 1, only get the data of the two-level organization which is not empty, and then take the two-level organization as a one-level organization, the three-level organization as a two-level organization, and so on.

[0093] E. Recursively according to the logic of D until there is no data.

[0094] The final generation of the organization tree vertical down-drilling auxiliary data based on the horizontal flattening auxiliary data of the organization tree of Table 3 is shown in Table 4.

[0095] Table 4 Organization tree vertical down-drilling auxiliary data

[0096]

[0097]

[0098] In this embodiment, the upward completion auxiliary data, the horizontal flattening auxiliary data and the vertical down-drilling auxiliary data are obtained in turn by the tree data processing method of vertical completion, horizontal flattening and vertical down-drilling, and finally the financial organization tree auxiliary data is accurately obtained.

[0099] In one of the embodiments, according to each level of the financial organization tree, the records of all levels in the upward completion auxiliary data are horizontally flattened, which specifically includes the following steps:

[0100] According to the upward completion auxiliary data and each financial organization, the maximum upward level data of each financial organization code is associated; according to the financial organization code, a plurality of financial organization code groups are obtained by grouping; and according to the maximum upward level data of the financial organization code, the data content corresponding to each financial organization code group is determined.

[0101] Specifically, the server 102 associates the maximum upward level data of each financial organization code according to the upward completion auxiliary data and each financial organization, groups the financial organization codes to obtain a plurality of financial organization code groups, and determines the data content corresponding to each financial organization code group according to the maximum upward level data of the financial organization code, thereby obtaining the horizontal flattening auxiliary data.

[0102] In this embodiment, the data content corresponding to each financial organization code group is determined according to the maximum upward level data of the financial organization code, so that the horizontal flattening auxiliary data is quickly and accurately obtained.

[0103] In one of the embodiments, after obtaining the financial detail data, the following steps are further included:

[0104] According to the financial institution code of each financial institution in the financial institution tree, the corresponding financial institution code of each item of financial detail data is determined; and the resource type conversion processing is performed on the resource value corresponding to each financial institution code to obtain the amount detail data containing the resource values expressed in the same resource type.

[0105] The resource value can represent the amount value of the amount held by the corresponding financial institution, and the resource type can be the amount currency corresponding to the amount held by the financial institution.

[0106] Specifically, the server 102 identifies and determines the corresponding financial institution code of each item of financial detail data according to the financial institution code of each financial institution in the financial institution tree; determines the target resource type, and performs resource type conversion processing on the resource value corresponding to each financial institution code to obtain the amount detail data containing the resource values expressed in the same resource type.

[0107] In this embodiment, by determining the corresponding financial institution code of each item of financial detail data according to the financial institution code of each financial institution in the financial institution tree, and performing resource type conversion processing on the resource value corresponding to each financial institution code, the amount detail data containing the resource values expressed in the same resource type is accurately obtained, and the reference value of the amount detail data is improved.

[0108] In one of the embodiments, before associating each item of financial detail data to the financial institution tree auxiliary data according to the corresponding financial institution of each item of financial detail data, the following steps are further included:

[0109] Identify and obtain the corresponding financial institution code in each item of financial detail data; and determine the corresponding financial institution of each item of financial detail data in the financial institution tree auxiliary data according to the financial institution code.

[0110] According to the corresponding financial institution of each item of financial detail data, the following steps are further included:

[0111] Extract the to-be-associated data in each item of financial detail data; and add the to-be-associated data to the financial institution tree auxiliary data according to the preset association condition.

[0112] As shown in Table 5, the to-be-associated data refers to the key part information in the financial detail data, such as the customer type, the amount, and the partition identifier.

[0113] Table 5 Financial Detail Data

[0114]

[0115] In the embodiment, the to-be-associated data in each item of financial detail data is extracted, and the to-be-associated data is added to the financial institution tree auxiliary data according to a preset association condition, so that efficient summarization between the financial detail data and the financial institution tree auxiliary data is realized, and the financial detail summary data is accurately and clearly obtained.

[0116] In one of the embodiments, in the step S205, the financial detail summary data of the corresponding institution is provided to the query user from the financial detail summary data according to the institution and permission information of the query user, and the step specifically includes the following steps.

[0117] The target data information to be queried, the institution and permission information of the query user are obtained, it is judged whether the target data information is contained in the permission information, in the case that the target data information is contained in the permission information, the financial detail summary data of the corresponding institution is identified from the financial detail summary data according to the institution of the query user, as the target data obtained by querying, and the target data obtained by querying is sent to the query user.

[0118] The permission information is used to judge whether the visitor has the access right to the target data information, and the target data information can be the summary data of the institution of the user and / or the summary data of each institution under jurisdiction.

[0119] Specifically, the server 102 obtains the target data information to be queried, the institution and permission information of the query user, judges whether the target data information is contained in the permission information, obtains a judgment result, in the case that the judgment result is that the target data information is contained in the permission information, the financial detail summary data of the corresponding institution is identified and obtained from the financial detail summary data according to the institution of the query user, as the target data obtained by querying, and the target data obtained by querying is sent to the query user.

[0120] In the embodiment, in the case that the target data information is contained in the permission information, the financial detail summary data of the corresponding institution is identified from the financial detail summary data according to the institution of the query user, as the target data obtained by querying, so that the related data information is effectively controlled by setting the query condition, the confidentiality of the summary data is improved, and the SQL (Structured Query Language) level permission control is realized.

[0121] In one of the embodiments, the financial detail summary data of the corresponding institution is identified from the financial detail summary data according to the institution of the query user, and the step specifically includes the following steps.

[0122] Based on the institution to which the querying user belongs, match the corresponding first-tier institution; based on the institution to which the querying user belongs and the matched first-tier institution, determine the corresponding second-tier institution; identify the data to be summarized that is associated with the first-tier and second-tier institutions from the financial detail summary data, and summarize the data to be summarized to obtain the financial detail summary data of the corresponding institution.

[0123] In the case where the first-layer mechanism is GDS or GXS, the corresponding second-layer mechanisms are GZs, ZHs or GLs, NNs, respectively.

[0124] Specifically, server 102 identifies and matches the corresponding first-tier institution based on the institution to which the querying user belongs; determines the corresponding second-tier institution based on the institution to which the querying user belongs and the matched first-tier institution; identifies the data to be summarized associated with the first-tier and second-tier institutions from the financial detail summary data, and merges the multiple data to be summarized to obtain the financial detail summary data of the corresponding institution.

[0125] In this embodiment, by identifying the data to be summarized associated with each of the first-tier and second-tier institutions from the financial detail summary data, and summarizing the data to be summarized, the financial detail summary data of the corresponding institutions is obtained; thereby enabling users to selectively view the institutions they have permission to access and obtain the summary data of the authorized institutions, further improving the confidentiality of the summary data.

[0126] In one embodiment, such as Figure 4 As shown, applied to server 102, a specific embodiment of a financial data aggregation and processing method based on an institutional tree is provided, which includes the following steps:

[0127] Step S401: Obtain the financial institution tree to be processed.

[0128] Step S402: Based on the various levels of the financial institution tree, complete the records of all levels in the financial institution tree data upwards to obtain upward completion auxiliary data.

[0129] Step S403: Based on the upward completion auxiliary data and each financial institution, associate the maximum upward level data of each financial institution code; group according to the financial institution code to obtain multiple financial institution code groups; determine the data content corresponding to each financial institution code group based on the maximum upward level data of the financial institution code to obtain horizontal leveling auxiliary data.

[0130] Step S404: Based on the horizontal leveling auxiliary data, add drilling levels and complete the records of drilling levels to obtain vertical drilling auxiliary data, which serves as tree-structured auxiliary data for financial institutions.

[0131] Step S405, obtaining each item of financial detail data; determining the respective financial institution code corresponding to each item of financial detail data according to the respective financial institution code in the financial institution tree; performing resource type conversion processing on the resource value corresponding to each financial institution code to obtain the amount of detail data containing resource values expressed in the same resource type.

[0132] Step S406, identifying and obtaining the corresponding financial institution code in each item of financial detail data; determining the respective financial institution corresponding to each item of financial detail data in the financial institution tree auxiliary data according to the financial institution code.

[0133] Step S407, extracting the to-be-associated data in each item of financial detail data; adding the to-be-associated data to the financial institution tree auxiliary data according to the preset association condition to form the financial detail summary data.

[0134] Step S408, obtaining the target data information to be queried, the institution to which the query user belongs, and the permission information; determining whether the target data information is included in the permission information.

[0135] Step S409, matching a corresponding one-level institution according to the institution to which the query user belongs; determining a corresponding two-level institution according to the institution to which the query user belongs and the matched one-level institution; identifying the to-be-summarized data associated with the one-level institution and the two-level institution from the financial detail summary data, and summarizing the to-be-summarized data to obtain the financial detail summary data as the target data obtained by querying.

[0136] Step S410, sending the target data obtained by querying to the query user.

[0137] In the above financial data summary processing method based on the institution tree, various financial institution tree auxiliary data is generated in advance by performing preprocessing operations such as vertical completion, horizontal flattening, and vertical drilling on the financial institution tree data; each item of financial detail data is associated with the financial institution tree auxiliary data to form the financial detail summary data; thereby, when performing financial data summary, efficient data summary analysis is realized based on big data Hive through a unified and simple table association method, avoiding the tedious and complex process of recursive summary of tree data with many levels, and reducing the resources occupied when performing financial data summary, thereby effectively improving the execution efficiency of the financial institution tree data summary.

[0138] It should be understood that although the steps in the flowcharts involved in the embodiments described above are shown in sequence according to the arrows, the steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified herein, the execution of the steps is not strictly limited in sequence, and the steps can be executed in other orders. Moreover, at least some of the steps in the flowcharts involved in the embodiments described above can include multiple steps or multiple stages, which are not necessarily executed at the same time, but can be executed at different times, and the execution order of the steps or stages is not necessarily sequential, but can be executed alternately or alternately with at least part of other steps or steps or stages in other steps.

[0139] Based on the same inventive concept, the embodiments of the present application also provide an institution tree-based financial data aggregation processing device for implementing the institution tree-based financial data aggregation processing method described above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme described in the above method, so the specific limitations in one or more institution tree-based financial data aggregation processing device embodiments provided below can refer to the limitations of the institution tree-based financial data aggregation processing method described above, which will not be repeated here.

[0140] In one embodiment, as shown in Figure 5 An institution tree-based financial data aggregation processing device is provided, comprising:

[0141] A first acquisition module 501 is configured to acquire a financial institution tree to be processed;

[0142] A data supplement module 502 is configured to perform vertical completion, horizontal flattening, and vertical drilling processing on the financial institution tree data in the financial institution tree, to obtain financial institution tree type auxiliary data; the financial institution tree type auxiliary data includes a plurality of component parts; the number of component parts corresponds to the number of layers of the financial institution tree; each component part includes one or more financial institution information items, and each financial institution information item includes information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the range of the superior institution is determined by the level of the financial institution tree corresponding to the component part;

[0143] A second acquisition module 503 is configured to acquire each item of financial detail data;

[0144] A data association module 504 is configured to associate each item of financial detail data to the financial institution tree type auxiliary data according to the corresponding financial institution of each item of financial detail data, to form financial detail aggregation data;

[0145] The query providing module 505 is configured to provide the financial summary data of the corresponding institution to the query user according to the institution to which the query user belongs and the permission information of the query user.

[0146] In one embodiment, the data supplementing module 502 is further configured to, according to each level of the financial institution tree, complete the records of all levels in the financial institution tree data upward to obtain upward completion auxiliary data; according to each level of the financial institution tree, horizontally flatten the records of all levels in the upward completion auxiliary data to obtain horizontally flattened auxiliary data; based on the horizontally flattened auxiliary data, increase the drilling level and complete the records of the drilling level to obtain vertical drilling auxiliary data as the financial institution tree auxiliary data.

[0147] In one embodiment, the data supplementing module 502 is further configured to, according to the upward completion auxiliary data and each financial institution, associate the maximum upward level data of each financial institution code; group the financial institution codes according to the financial institution codes to obtain a plurality of financial institution code groups; and determine the data content corresponding to each financial institution code group according to the maximum upward level data of the financial institution codes.

[0148] In one embodiment, the financial data summary processing device based on the institution tree further comprises a resource conversion module configured to determine the respective financial institution codes corresponding to each item of financial detail data according to each financial institution code in the financial institution tree; and perform resource type conversion processing on the resource values corresponding to each financial institution code to obtain the amount detail data containing resource values represented in the same resource type.

[0149] In one embodiment, the financial data summary processing device based on the institution tree further comprises an information determining module configured to identify and obtain the corresponding financial institution codes in each item of financial detail data; and determine the respective financial institutions corresponding to each item of financial detail data in the financial institution tree auxiliary data according to the financial institution codes. The data association module 504 is further configured to extract the to-be-associated data in each item of financial detail data; and add the to-be-associated data to the financial institution tree auxiliary data according to the preset association condition.

[0150] In one embodiment, the query providing module 505 is further configured to obtain target data information to be queried, the institution to which the query user belongs and the permission information of the query user; determine whether the target data information is included in the permission information; in the case where the target data information is included in the permission information, identify the financial summary data of the corresponding institution from the financial summary data according to the institution to which the query user belongs, as the target data obtained by the query; and send the target data obtained by the query to the query user.

[0151] In one embodiment, the query providing module 505 is further configured to match the corresponding first-tier institution based on the institution to which the query user belongs; determine the corresponding second-tier institution based on the institution to which the query user belongs and the matched first-tier institution; identify the data to be summarized associated with the first-tier institution and the second-tier institution respectively from the financial detail summary data, and summarize the data to be summarized to obtain the financial detail summary data of the corresponding institution.

[0152] Each module in the aforementioned financial data aggregation and processing device based on the organizational tree can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in or independent of the processor in a computer device, or stored in the memory of a computer device as software, so that the processor can call and execute the operations corresponding to each module.

[0153] In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as follows: Figure 6 As shown, this computer device includes a processor, memory, input / output interfaces (I / O), and a communication interface. The processor, memory, and I / O interfaces are connected via a system bus, and the communication interface is also connected to the system bus via the I / O interfaces. The processor provides computational and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and a database. The internal memory provides the environment for the operating system and computer programs in the non-volatile storage media to run. The database stores data such as the user's affiliated organization and permission information. The I / O interfaces are used for exchanging information between the processor and external devices. The communication interface is used for communicating with external terminals via a network connection. When executed by the processor, the computer program implements a financial data aggregation and processing method based on an organizational tree.

[0154] Those skilled in the art will understand that Figure 6 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0155] In one embodiment, a computer device is provided, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the computer program to implement the steps in the above-described method embodiments.

[0156] In an embodiment, a computer readable storage medium is provided, having stored thereon a computer program which, when executed by a processor, implements the steps of any of the above method embodiments.

[0157] In an embodiment, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the steps of any of the above method embodiments.

[0158] A person of ordinary skill in the art can understand that all or part of the processes in the above method embodiments can be completed by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer readable storage medium and can include the processes of the above method embodiments when executed. Any reference to a memory, database or other medium in the embodiments provided in the present application can include at least one of a non-volatile and volatile memory. The non-volatile memory can include a read-only memory (ROM), a magnetic tape, a floppy disk, a flash memory, an optical storage, a high-density embedded non-volatile memory, a resistive memory (ReRAM), a magnetoresistive memory (MRAM), a ferroelectric memory (FRAM), a phase change memory (PCM), a graphene memory, etc. The volatile memory can include a random access memory (RAM) or an external cache memory, etc. As an illustration but not limitation, the RAM can be in various forms such as a static random access memory (SRAM) or a dynamic random access memory (DRAM), etc. The database involved in the embodiments provided in the present application can include at least one of a relational database and a non-relational database. The non-relational database can include a distributed database based on a blockchain, etc., without being limited thereto. The processor involved in the embodiments provided in the present application can be a general processor, a central processing unit, a graphics processing unit, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., without being limited thereto.

[0159] Any combination of the technical features of the above embodiments can be made, and to make the description concise, all possible combinations of the technical features in the above embodiments are not described, however, as long as the combination of the technical features does not exist, it should be considered as the scope of the present application.

[0160] The above-described embodiments are merely illustrative of several embodiments of the present application, which are described in more detail and in a specific manner, but should not be construed as limiting the scope of the patent of the present application. It should be noted that, for those of ordinary skill in the art, several modifications and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the appended claims.

Claims

1. A method for aggregating financial data based on an institutional tree, characterized by, The method comprises: obtaining a financial institution tree to be processed, wherein the institution tree is a form of tree data, and the tree data is a set with hierarchical relationships composed of multiple finite nodes; performing vertical completion, horizontal flattening and vertical drilling processing on the financial institution tree data in the financial institution tree to obtain financial institution tree auxiliary data; the financial institution tree auxiliary data comprises multiple components; the number of components corresponds to the number of layers of the financial institution tree; the components comprise one or more financial institution information items, each financial institution information item comprises information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the range of the superior institutions is determined by the level of the financial institution tree corresponding to the components; obtaining each item of financial detail data; associating each item of financial detail data to the financial institution tree auxiliary data according to the corresponding financial institution of each item of financial detail data to form financial detail summary data; providing financial detail summary data of a corresponding institution to a query user from the financial detail summary data according to the institution and permission information of the query user; the vertical completion, horizontal flattening and vertical drilling processing on the financial institution tree data in the financial institution tree to obtain the financial institution tree auxiliary data comprises: completing records of all levels in the financial institution tree data upwards according to each level of the financial institution tree to obtain upwards completion auxiliary data; flattening records of all levels in the upwards completion auxiliary data horizontally according to each level of the financial institution tree to obtain horizontal flattening auxiliary data; based on the horizontal flattening auxiliary data, increasing a drilling level and completing records of the drilling level to obtain vertical drilling auxiliary data as the financial institution tree auxiliary data.

2. The method of claim 1, wherein, the horizontal flattening of the records of all levels in the upwards completion auxiliary data according to each level of the financial institution tree comprises: associating maximum upwards level data of each financial institution code according to the upwards completion auxiliary data and each financial institution; grouping the financial institution codes according to the maximum upwards level data of the financial institution codes to obtain multiple financial institution code groups; determining data contents corresponding to each financial institution code group according to the maximum upwards level data of the financial institution codes.

3. The method of claim 1, wherein, after obtaining each item of financial detail data, the method further comprises: determining financial institution codes corresponding to each item of financial detail data according to each financial institution code in the financial institution tree; performing resource type conversion processing on a resource value corresponding to each financial institution code to obtain amount detail data comprising resource values represented in the same resource type.

4. The method of claim 3, wherein, before associating each item of financial detail data to the financial institution tree auxiliary data according to the corresponding financial institution of each item of financial detail data, the method further comprises: identifying and obtaining corresponding financial institution codes in the items of financial detail data; determining the corresponding financial institution of each item of financial detail data in the financial institution tree auxiliary data according to the financial institution codes. The associating the financial detail data to the financial institution tree auxiliary data according to the respective financial institutions corresponding to the financial detail data comprises: extracting to-be-associated data in the financial detail data; adding the to-be-associated data to the financial institution tree auxiliary data according to a preset association condition.

5. The method according to any one of claims 1 to 4, characterized in that, The providing the financial detail summary data of the corresponding institution to the query user from the financial detail summary data according to the institution and permission information of the query user comprises: obtaining target data information to be queried, and the institution and permission information of the query user; determining whether the target data information is included in the permission information; in a case where the target data information is included in the permission information, identifying the financial detail summary data of the corresponding institution from the financial detail summary data according to the institution of the query user, as target data obtained by querying; sending the target data obtained by querying to the query user.

6. The method of claim 5, wherein, The identifying the financial detail summary data of the corresponding institution from the financial detail summary data according to the institution of the query user comprises: matching a first-level institution corresponding to the institution of the query user; determining a second-level institution corresponding to the institution of the query user and the matched first-level institution; identifying to-be-summarized data respectively associated with the first-level institution and the second-level institution from the financial detail summary data, and summarizing the to-be-summarized data to obtain the financial detail summary data of the corresponding institution.

7. An apparatus for processing financial data aggregation based on an organization tree, characterized by comprising: The apparatus comprises: a first obtaining module configured to obtain a financial institution tree to be processed, wherein the institution tree is a form of tree data, and the tree data is a set having a hierarchical relationship composed of a plurality of limited nodes; a data supplementing module configured to perform vertical completion, horizontal flattening and vertical drilling processing on financial institution tree data in the financial institution tree, to obtain financial institution tree auxiliary data; the financial institution tree auxiliary data comprises a plurality of components; the number of the components corresponds to the number of layers of the financial institution tree; the components comprise one or more financial institution information items; each financial institution information item comprises information of a corresponding financial institution and information of each superior institution of the corresponding financial institution; the range of the superior institutions is determined by the level of the financial institution tree corresponding to the components; a second obtaining module configured to obtain each item of financial detail data; a data associating module configured to associate each item of the financial detail data to the financial institution tree auxiliary data according to the respective financial institutions corresponding to the financial detail data, to form financial detail summary data; a query providing module configured to provide the financial detail summary data of the corresponding institution to the query user from the financial detail summary data according to the institution and permission information of the query user. The data supplementing module is further configured to: according to each level of the financial institution tree, complement records of all levels in the financial institution tree data upward to obtain upward complement auxiliary data; according to each level of the financial institution tree, horizontally flatten the records of all levels in the upward complement auxiliary data to obtain horizontally flattened auxiliary data; based on the horizontally flattened auxiliary data, increase a drilling level, and complement records of the drilling level to obtain vertical drilling auxiliary data as the financial institution tree auxiliary data.

8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that, The computer program, when executed by the processor, implements the steps of the method of any one of claims 1 to 6.

9. A computer readable storage medium having stored thereon a computer program, characterized in that, The computer program, when executed by the processor, implements the steps of the method of any one of claims 1 to 6.

10. A computer program product comprising a computer program, characterized in that, The computer program, when executed by the processor, implements the steps of the method of any one of claims 1 to 6. The computer program, when executed by the processor, implements the steps of the method of any one of claims 1 to 6.

Images