Financial account data query method, device and equipment based on distributed storage system, storage medium and program product
By using the financial account identification index table to query the target storage unit in the distributed storage system of financial institutions, the problem of low efficiency in financial account data query is solved, and efficient data query and resource utilization are achieved.
Patent Information
- Application Number
- CN202411031858.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-30
- Publication Date
- 2024-12-06
AI Technical Summary
Financial institutions are less efficient in querying financial account data in massive data and require a large amount of computing resources.
Using a distributed storage system-based method, the user identification is queried through the pre-acquisitioned financial account identification index table, the target storage unit is determined and the account data is obtained, the query scope is narrowed, and the query efficiency is improved.
It effectively improves the efficiency of financial account data query, reduces the consumption of computing resources, and supports online services and data query for massive users.
Smart Images

Figure CN119088799A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of big data technology, and in particular to a financial account data query method, apparatus, computer equipment, storage medium and computer program product based on a distributed storage system. Background Art
[0002] With the development of computer technology, the account data stored by financial institutions has shown explosive growth.
[0003] In the related art, the account data of multiple accounts are centrally stored in the core system of the financial institution. When the account data related to the target account needs to be queried, it can be queried in the core system according to the account ID of the target account. However, this method has low data query efficiency and often requires more computing resources to query the account data of the target account in the massive data. Summary of the invention
[0004] Based on this, it is necessary to provide a financial account data query method, device, computer equipment, computer-readable storage medium and computer program product based on a distributed storage system that can improve the efficiency of account data query of financial accounts in response to the above technical problems.
[0005] In a first aspect, the present application provides a financial account data query method based on a distributed storage system, wherein the distributed storage system includes a plurality of storage units for storing account data of different financial accounts; the method includes:
[0006] In response to an account data query request for a financial account, obtaining a user identifier carried in the data query request;
[0007] Querying a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier;
[0008] A target storage unit corresponding to the financial account identifier is determined among the multiple storage units, and account data corresponding to the financial account is obtained based on the account data stored in the target storage unit.
[0009] In one embodiment, searching a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier includes:
[0010] In the case where the user identifier includes a user name, obtaining a name index table; the name index table records the user names of multiple users and the financial account identifiers assigned by the financial institution when opening corresponding financial accounts for each of the users;
[0011] The financial account identifier corresponding to the user is queried according to the name index table and the user name.
[0012] In one embodiment, querying the financial account identifier corresponding to the user according to the name index table and the user name includes:
[0013] When multiple candidate financial account identifiers matching the user name are found according to the name index table, obtaining a certificate index table and a user certificate identifier of the user; the certificate index table records the user certificate identifiers of multiple users and the financial account identifiers allocated by the financial institution when opening a corresponding financial account for each of the users;
[0014] According to the certificate index table and the user certificate identifier, a financial account identifier corresponding to the user is determined from the multiple candidate financial account identifiers.
[0015] In one embodiment, searching a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier includes:
[0016] In the case where the user identification includes a user certificate identification, obtaining a certificate index table; the certificate index table records the user certificate identifications of multiple users and the financial account identifications allocated by the financial institution when opening a corresponding financial account for each of the users;
[0017] The financial account identifier corresponding to the user is queried according to the certificate index table and the user certificate identifier.
[0018] In one embodiment, the method further comprises:
[0019] Obtaining financial account identifiers and account data corresponding to each of the plurality of financial accounts;
[0020] According to the pre-acquired financial account grouping rule, the financial account identifiers corresponding to the multiple financial accounts are grouped to obtain multiple identifier sets; each identifier set includes at least one financial account identifier;
[0021] For each identification set, each financial account identification and corresponding account data in the identification set are associated and stored in the same storage unit.
[0022] In a second aspect, the present application further provides a financial account data query device based on a distributed storage system, wherein the distributed storage system includes a plurality of storage units for storing account data of different financial accounts; the device includes:
[0023] A user identification acquisition module, configured to respond to an account data query request for a financial account and acquire a user identification carried in the data query request;
[0024] A financial account identifier query module, used to query a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier;
[0025] The account data extraction module is used to determine a target storage unit corresponding to the financial account identifier among the multiple storage units, and obtain account data corresponding to the financial account based on the account data stored in the target storage unit.
[0026] In one embodiment, the financial account identification query module is used to:
[0027] In the case where the user identifier includes a user name, obtaining a name index table; the name index table records the user names of multiple users and the financial account identifiers assigned by the financial institution when opening corresponding financial accounts for each of the users;
[0028] The financial account identifier corresponding to the user is queried according to the name index table and the user name.
[0029] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:
[0030] In response to an account data query request for a financial account, obtaining a user identifier carried in the data query request;
[0031] Querying a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier;
[0032] A target storage unit corresponding to the financial account identifier is determined among the multiple storage units, and account data corresponding to the financial account is obtained based on the account data stored in the target storage unit.
[0033] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the following steps are implemented:
[0034] In response to an account data query request for a financial account, obtaining a user identifier carried in the data query request;
[0035] Querying a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier;
[0036] A target storage unit corresponding to the financial account identifier is determined among the multiple storage units, and account data corresponding to the financial account is obtained based on the account data stored in the target storage unit.
[0037] In a fifth aspect, the present application further provides a computer program product, including a computer program, which implements the following steps when executed by a processor:
[0038] In response to an account data query request for a financial account, obtaining a user identifier carried in the data query request;
[0039] Querying a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier;
[0040] A target storage unit corresponding to the financial account identifier is determined among the multiple storage units, and account data corresponding to the financial account is obtained based on the account data stored in the target storage unit.
[0041] The above-mentioned financial account data query method, device, computer equipment, storage medium and computer program product based on the distributed storage system, in response to an account data query request for a financial account, obtains the user identifier carried in the data query request, and then queries the financial account identifier corresponding to the user identifier in the pre-acquired financial account identifier index table, and then can determine the target storage unit corresponding to the financial account identifier in multiple storage units, and obtain the account data corresponding to the financial account based on the account data stored in the target storage unit. In this application, on the one hand, a large amount of account data can be stored in different storage units respectively, which can effectively narrow the query scope of each data query. On the other hand, by providing the user identifier, the financial institution can determine the corresponding financial account identifier through the financial account identifier index table and quickly locate the correct target storage unit, thereby improving the efficiency of determining the data query scope, thereby improving the efficiency of account data query of the financial account. BRIEF DESCRIPTION OF THE DRAWINGS
[0042] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the related technologies, the drawings required for use in the embodiments or the related technical descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0043] Figure 1 A schematic diagram of a flow chart of a financial account data query method based on a distributed storage system in one embodiment;
[0044] Figure 2A flowchart of a step of determining a financial account identifier in one embodiment;
[0045] Figure 3 A flowchart of another step of determining a financial account identifier in one embodiment;
[0046] Figure 4 It is a structural block diagram of a financial account data query device based on a distributed storage system in one embodiment;
[0047] Figure 5 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION
[0048] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.
[0049] In one embodiment, Figure 1 As shown, a method for querying financial account data of a distributed storage system is provided, wherein the distributed storage system includes multiple storage units for storing account data of different financial accounts. This embodiment is illustrated by applying the method to a server, such as a server of the distributed storage system. It is understandable that the method can also be applied to a system including a terminal and a server, and is implemented through the interaction between the terminal and the server. In this embodiment, the method includes the following steps:
[0050] S101, in response to an account data query request for a financial account, obtaining a user identifier carried in the data query request;
[0051] The user identifier may be an identifier corresponding to a user holding a financial account.
[0052] In some optional embodiments, the account data query request can be used to request to obtain the account data corresponding to the financial account to be queried. Exemplarily, the account data can be determined based on the business content of the user's financial business, such as the information submitted or filled in by the user when handling financial business (such as name, age, gender, etc.), the user's transaction habits, etc. It should be emphasized that the account data in this application is obtained with the user's authorization.
[0053] In some optional embodiments, the account data query request may come from a terminal, such as a financial service application deployed on the terminal, or may also come from other trusted servers of the financial institution.
[0054] In actual applications, users can request to query the account data of financial accounts through their terminals or at business outlets of financial institutions. When making inquiries, users can provide a user ID. By way of example, the user ID can be an ID used by the user in daily life to distinguish himself from others, such as the user's ID or user name. When sending an account data query request, the user ID can be added to the account data query request.
[0055] S102: Searching a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier.
[0056] Among them, the financial account identifier index table can record the correspondence between the user identifier and the financial account identifier; the financial account identifier is information used within the financial institution to distinguish different users, and the financial account identifier can uniquely correspond to the user.
[0057] Specifically, in this step, the financial account identification index table may be accessed. In some optional embodiments, the financial account identification index table may include multiple different types of index tables, that is, in multiple financial account identification index tables, different user identifications may be used as index information to query financial account identifications. In some embodiments, multiple financial account identification index tables may be stored in the same storage unit in a distributed storage system, which is called an aggregate index library or an aggregate unit.
[0058] After accessing the financial account identifier index table, a query may be performed in the index table according to the user identifier to find the financial account identifier corresponding to the user identifier as a query result.
[0059] S103, determining a target storage unit corresponding to the financial account identifier among multiple storage units, and obtaining account data corresponding to the financial account based on the account data stored in the target storage unit.
[0060] In a specific implementation, the account data of multiple financial accounts can be pre-stored in multiple storage units of a distributed storage system. In some optional embodiments, the storage unit can also be a business unit. Under the unitized architecture, each storage unit includes all services, and each storage unit only needs to process the account data of a preset number of financial accounts under the storage unit. By dividing the account data into units, online services for a large number of users of financial institutions can be supported, and it is easier to expand.
[0061] Among them, the account data of each financial account can be associated with the financial account identifier corresponding to the financial account. Furthermore, after determining the financial account identifier corresponding to the user, the target storage unit corresponding to the financial account identifier can be determined in multiple storage units of the distributed storage system, and the account data stored in the target storage unit can be queried to obtain the account data corresponding to the financial account. For example, the sub-library and sub-table storing the corresponding financial account data can be determined according to the financial account identifier, and then the account data corresponding to the financial account can be read from the corresponding sub-library and sub-table.
[0062] In this embodiment, in response to an account data query request for a financial account, the user identifier carried in the data query request is obtained, and then the financial account identifier corresponding to the user identifier is queried in the pre-acquired financial account identifier index table, and then the target storage unit corresponding to the financial account identifier can be determined in multiple storage units, and the account data corresponding to the financial account can be obtained based on the account data stored in the target storage unit. In this application, on the one hand, a large amount of account data can be stored in different storage units respectively, which can effectively narrow the query scope of each data query. On the other hand, by providing the user identifier, the financial institution can determine the corresponding financial account identifier through the financial account identifier index table and quickly locate the correct target storage unit, thereby improving the efficiency of determining the data query scope, thereby improving the efficiency of account data query of the financial account.
[0063] In one embodiment, Figure 2 As shown, searching the pre-acquired financial account identifier index table for the financial account identifier corresponding to the user identifier may include the following steps:
[0064] S201, when the user identification includes the user name, obtain a name index table; the name index table records the user names of multiple users and the financial account identification assigned by the financial institution when opening the corresponding financial account for each user.
[0065] In a specific implementation, the financial account identification index table may include a name index table. When a user provides his or her user name as a user identification to query account data, the name index table may be obtained.
[0066] S202, querying the financial account identifier corresponding to the user according to the name index table and the user name.
[0067] In this step, the name index table can be accessed, and the name index table contains the correspondence between the user name and the financial account identifier. Exemplarily, it can be implemented using a database, a memory cache, or other suitable storage methods. In the process of accessing the name index table, the user name provided by the user can be used as a query condition to find the corresponding financial account identifier in the name index table. If a matching result is found, the corresponding financial account identifier is returned as the query result. If no matching result is found in the name index table, how to deal with it is determined according to specific business needs, and an empty result can be returned or other logical operations can be performed.
[0068] In this embodiment, the financial account identifier corresponding to the user can be quickly queried based on the name index table and the user name, effectively improving the efficiency of locating the correct target storage unit.
[0069] In one embodiment, in step S202, querying the financial account identifier corresponding to the user according to the name index table and the user name may include the following steps:
[0070] When multiple candidate financial account identifiers matching the user's name are found according to the name index table, the certificate index table and the user's certificate identifier are obtained; and the financial account identifier corresponding to the user is determined from the multiple candidate financial account identifiers according to the certificate index table and the user's certificate identifier.
[0071] The certificate index table records the user certificate identifiers of multiple users and the financial account identifiers allocated by the financial institution when opening corresponding financial accounts for each user.
[0072] In actual applications, there may be multiple identical names in the name index table, and multiple candidate financial account identifiers with the same name but different specific identifiers can be matched based on the user name provided by the user. In this case, the certificate index table and the user's user certificate identifier can be obtained, and then a cross-comparison is performed based on the certificate index table and the user's certificate identifier to determine the user's corresponding financial account identifier from multiple candidate financial account identifiers. For example, the candidate financial account identifier corresponding to the user's certificate identifier is determined in the certificate index table, and then the candidate financial account identifier currently screened is compared with the candidate financial account identifier screened based on the name index table, and the same candidate financial account identifier is used as the user's corresponding financial account identifier. In this way, the correct financial account identifier can be accurately located when there are multiple possible candidate financial account identifiers.
[0073] In one embodiment, Figure 3 As shown, searching the pre-acquired financial account identifier index table for the financial account identifier corresponding to the user identifier may include the following steps:
[0074] S301, when the user identification includes a user certificate identification, obtain a certificate index table.
[0075] The certificate index table records the user certificate identifiers of multiple users and the financial account identifiers allocated by the financial institution when opening corresponding financial accounts for each user.
[0076] In this step, when the user identification includes a user certificate identification, a certificate index table may be obtained, and a financial account identification query may be performed first through the certificate index table.
[0077] S302, query the financial account identifier corresponding to the user according to the certificate index table and the user certificate identifier.
[0078] In this step, the certificate index table may be accessed, which contains the correspondence between the user certificate identifier and the financial account identifier. Exemplarily, this may be implemented using a database, a memory cache, or other suitable storage methods.
[0079] When accessing the document index table, you can use the user document ID provided by the user as the query condition to find the corresponding financial account ID in the document index table. If a match is found, the corresponding financial account ID is returned as the query result. If no match is found in the name index table, decide how to handle it based on specific business needs, and you can return an empty result or perform other logical operations.
[0080] In this embodiment, the financial account identifier corresponding to the user can be quickly queried based on the certificate index table and the user certificate identifier, effectively improving the efficiency of locating the correct target storage unit.
[0081] In one embodiment, the method may further include the following steps:
[0082] Obtain financial account identifiers and account data corresponding to each of the multiple financial accounts; group the financial account identifiers corresponding to each of the multiple financial accounts according to a pre-acquired financial account grouping rule to obtain multiple identifier sets; for each identifier set, associate each financial account identifier and the corresponding account data in the identifier set and store them in the same storage unit.
[0083] Each identification set includes at least one financial account identification.
[0084] In this embodiment, multiple financial accounts in the stock data can be processed, including obtaining financial account identifiers and account data corresponding to each of the multiple financial accounts, and then obtaining financial account grouping rules, such as business scenarios, number of customers, etc., and grouping the financial account identifiers corresponding to each of the multiple financial accounts to obtain multiple identifier sets.
[0085] Afterwards, for each identification set, each financial account identification and the corresponding account data in the identification set can be associated and stored in the same storage unit. For example, the account data of the financial accounts corresponding to different identification sets can be stored in different storage units, so that different storage units can be queried based on the financial account identification later, avoiding queries in the same database containing massive data.
[0086] In addition, user names and user IDs can be extracted from multiple financial accounts to construct a name index table and an ID index table to provide a basis for subsequent queries.
[0087] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.
[0088] Based on the same inventive concept, the embodiment of the present application also provides a financial account data query device based on a distributed storage system for implementing the above-mentioned financial account data query method based on a distributed storage system. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above-mentioned method, so the specific limitations in the embodiments of one or more financial account data query devices based on a distributed storage system provided below can refer to the limitations of the financial account data query method based on a distributed storage system above, and will not be repeated here.
[0089] In an exemplary embodiment, Figure 4 As shown, a financial account data query device based on a distributed storage system is provided, wherein the distributed storage system includes a plurality of storage units for storing account data of different financial accounts; the device includes:
[0090] A user identification acquisition module 401, configured to respond to an account data query request for a financial account and acquire a user identification carried in the data query request;
[0091] A financial account identifier query module 402, configured to query a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier;
[0092] The account data extraction module 403 is used to determine a target storage unit corresponding to the financial account identifier from among the multiple storage units, and obtain account data corresponding to the financial account based on the account data stored in the target storage unit.
[0093] In one embodiment, the financial account identification query module is used to:
[0094] In the case where the user identifier includes a user name, obtaining a name index table; the name index table records the user names of multiple users and the financial account identifiers assigned by the financial institution when opening corresponding financial accounts for each of the users;
[0095] The financial account identifier corresponding to the user is queried according to the name index table and the user name.
[0096] In one embodiment, the financial account identification query module 402 is used to:
[0097] When multiple candidate financial account identifiers matching the user name are found according to the name index table, obtaining a certificate index table and a user certificate identifier of the user; the certificate index table records the user certificate identifiers of multiple users and the financial account identifiers allocated by the financial institution when opening a corresponding financial account for each of the users;
[0098] According to the certificate index table and the user certificate identifier, a financial account identifier corresponding to the user is determined from the multiple candidate financial account identifiers.
[0099] In one embodiment, the financial account identification query module 402 is used to:
[0100] In the case where the user identification includes a user certificate identification, obtaining a certificate index table; the certificate index table records the user certificate identifications of multiple users and the financial account identifications allocated by the financial institution when opening a corresponding financial account for each of the users;
[0101] The financial account identifier corresponding to the user is queried according to the certificate index table and the user certificate identifier.
[0102] In one embodiment, the apparatus further comprises:
[0103] The stock data acquisition module is used to obtain the financial account identifiers and account data corresponding to each of the multiple financial accounts;
[0104] a grouping module, configured to group the financial account identifiers corresponding to the plurality of financial accounts according to a pre-acquired financial account grouping rule, to obtain a plurality of identifier sets; each identifier set includes at least one financial account identifier;
[0105] The distributed storage module is used to associate and store each financial account identifier and corresponding account data in the identifier set in the same storage unit for each identifier set.
[0106] Each module in the above-mentioned financial account data query device based on the distributed storage system can be implemented in whole or in part by software, hardware, or a combination thereof. Each of the above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to each of the above modules.
[0107] In an exemplary embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as shown in FIG. Figure 5 As shown. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. Among them, the processor, the memory and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store account data of financial accounts. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a financial account data query method based on a distributed storage system is implemented.
[0108] Those skilled in the art will understand that Figure 5 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0109] In one embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above-mentioned method embodiments when executing the computer program.
[0110] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.
[0111] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above method embodiments when executed by a processor.
[0112] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.
[0113] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.
[0114] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0115] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations 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 shall be subject to the attached claims.
Claims
1. A financial account data query method based on a distributed storage system, characterized in that: The distributed storage system includes a plurality of storage units for storing account data of different financial accounts; the method includes: In response to an account data query request for a financial account, obtaining a user identifier carried in the data query request; Querying a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier; A target storage unit corresponding to the financial account identifier is determined among the multiple storage units, and account data corresponding to the financial account is obtained based on the account data stored in the target storage unit.
2. The method according to claim 1, characterized in that The step of searching the pre-acquired financial account identifier index table for the financial account identifier corresponding to the user identifier includes: In the case where the user identifier includes a user name, obtaining a name index table; the name index table records the user names of multiple users and the financial account identifiers assigned by the financial institution when opening corresponding financial accounts for each of the users; The financial account identifier corresponding to the user is queried according to the name index table and the user name.
3. The method according to claim 2, characterized in that The querying the financial account identifier corresponding to the user according to the name index table and the user name includes: When multiple candidate financial account identifiers matching the user name are found according to the name index table, obtaining a certificate index table and a user certificate identifier of the user; the certificate index table records the user certificate identifiers of multiple users and the financial account identifiers allocated by the financial institution when opening a corresponding financial account for each of the users; According to the certificate index table and the user certificate identifier, a financial account identifier corresponding to the user is determined from the multiple candidate financial account identifiers.
4. The method according to claim 1, characterized in that: The step of searching the pre-acquired financial account identifier index table for the financial account identifier corresponding to the user identifier includes: In the case where the user identification includes a user certificate identification, obtaining a certificate index table; the certificate index table records the user certificate identifications of multiple users and the financial account identifications allocated by the financial institution when opening a corresponding financial account for each of the users; The financial account identifier corresponding to the user is queried according to the certificate index table and the user certificate identifier.
5. The method according to any one of claims 1 to 4, characterized in that The method further comprises: Obtaining financial account identifiers and account data corresponding to each of the plurality of financial accounts; According to the pre-acquired financial account grouping rule, the financial account identifiers corresponding to the multiple financial accounts are grouped to obtain multiple identifier sets; each identifier set includes at least one financial account identifier; For each identification set, each financial account identification and corresponding account data in the identification set are associated and stored in the same storage unit.
6. A financial account data query device based on a distributed storage system, characterized in that: The distributed storage system includes a plurality of storage units for storing account data of different financial accounts; the device includes: A user identification acquisition module, configured to respond to an account data query request for a financial account and acquire a user identification carried in the data query request; A financial account identifier query module, used to query a pre-acquired financial account identifier index table for a financial account identifier corresponding to the user identifier; The account data extraction module is used to determine a target storage unit corresponding to the financial account identifier among the multiple storage units, and obtain account data corresponding to the financial account based on the account data stored in the target storage unit.
7. The device according to claim 6, characterized in that The financial account identification query module is used to: In the case where the user identifier includes a user name, obtaining a name index table; the name index table records the user names of multiple users and the financial account identifiers assigned by the financial institution when opening corresponding financial accounts for each of the users; The financial account identifier corresponding to the user is queried according to the name index table and the user name.
8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 5 are implemented.
9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 5 are implemented.
10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 5 are implemented.
Citation Information
Patent Citations
Account information query method and device based on database table
CN111459976A
Virtual resource transaction processing method based on block chain and related equipment
CN115409624A
Information query method, system and device, computer equipment and storage medium
CN116049504A
Data query method and device, data storage method and device and computer equipment
CN116414838A
Public accumulation fund bill generation method and device, equipment, storage medium and program product
CN117235149A
