A method, system and apparatus for obtaining a balance in real time at high transaction volumes

Abstract

The present application belongs to the technical field of bank data processing, and discloses a method, system and device for real-time acquisition of total account balance under large transaction volume. The method for real-time acquisition of total account balance under large transaction volume comprises the following steps: synchronously setting a plurality of total account occurrence amounts when opening a total account; asynchronously accumulating the total account occurrence amount according to a single accounting entry; using a load balancing strategy to select one occurrence account from the plurality of total account occurrence accounts for accumulation; and using a database manipulation statement to reset the occurrence amount of the total account occurrence account to zero at the end of each day. The present application replaces the "query-based accounting entry summary occurrence amount" with "real-time accumulation of total account occurrence amount", changes the summary occurrence amount to a query total account occurrence amount, avoids large data volume summary calculation, and greatly reduces the time consumption of real-time balance query. Since the large data volume summary calculation is avoided, a large amount of system resources is saved, and multiple concurrent real-time total account balance queries can be supported.

Description

Technical Field

[0001] This invention belongs to the field of banking data processing technology, and in particular relates to a method, system and device for obtaining the general ledger balance in real time under large transaction volume. Background Technology

[0002] Currently: The bank's general ledger system receives transaction logs from the core and online lending systems in real time during the day. Upon receiving the transaction logs, it performs real-time accounting and generates journal entries. At the end of the day, it summarizes and posts the journal entries, updating the general ledger account balances. During the day, it is necessary to check the general ledger balance after each transaction occurs. The existing practice is as follows:

[0003] (1) Temporarily summarize all accounting entries generated on the same day and calculate the total amount of general ledger entries.

[0004] (2) Find the previous day's general ledger balance.

[0005] (3) Calculate and return the real-time general ledger balance according to the formula: Real-time general ledger balance = Previous day's general ledger balance + General ledger transaction amount.

[0006] Based on the above analysis, the problems and shortcomings of the existing technology are as follows:

[0007] (1) Existing methods are inefficient when transaction volume is high: When the daily transaction volume is high, accounting entries are generated. Each query of the real-time general ledger balance takes a long time to summarize the amount of a large number of accounting entries. As the daily transaction volume of core and online lending transaction systems increases, the number of accounting entries generated increases, the time taken to summarize the amount of transactions increases, and the speed of returning query results becomes slower.

[0008] (2) Existing methods cannot support multiple people querying the balance in real time. Since the accounting entries need to be summarized each time the real-time general ledger balance is queried, it will occupy a large amount of memory, database and other system resources for a long time, causing system resource shortage and making it impossible to support multiple people querying the real-time general ledger balance at the same time (concurrently). Summary of the Invention

[0009] To address the problems existing in the prior art, this invention provides a method, system, and device for obtaining the general ledger balance in real time under large transaction volumes.

[0010] This invention is implemented as follows: a method for obtaining the total ledger balance in real time under high transaction volume, the method comprising the following steps:

[0011] Step 1: First, open a general ledger account in the local database system, set the integrity of the attributes in the general ledger account and enter the information. Use the database service to obtain the general ledger transaction amount parameter in binary code form through FTP port 20. Use SQL statements to extract the same general ledger account data in the general ledger account and the general ledger transaction amount account. Set up multiple independent general ledger transaction amount accounts using the general ledger account + serial number method.

[0012] Step 2: Generate accounting entries through accounting. Based on the accounting entries, use structured query statements to obtain general ledger account numbers from general ledger accounts. Based on the general ledger account numbers, obtain the transaction amount accounts from the general ledger transaction amount accounts in the form of records. Accumulate the general ledger transaction amount synchronously or asynchronously in near real-time for each accounting entry. Use the get severe method to obtain the load balancing strategy set for the transaction amount accounts. Based on the obtained load balancing strategy, use a random algorithm to select one transaction amount account from multiple general ledger transaction amount accounts for accumulation in the accounting entry.

[0013] Step 3: The database system uses SQL query language to query the general ledger account to obtain the previous day's general ledger balance. Based on the general ledger transaction accounts, it uses the group by statement to summarize multiple transaction accounts and obtain the transaction amount for the current day. It then uses a custom structured language to embed the formula "General Ledger Real-time Balance = Previous Day's Balance + Current Day's Transaction Amount" to obtain the general ledger real-time balance.

[0014] Step 4: At the end of each day, use database manipulation statements to reset the transaction amount of the general ledger transaction account to zero.

[0015] Furthermore, the method for opening general ledger transaction accounts is as follows:

[0016] While automatically or manually opening general ledger accounts, transaction amount accounts are also automatically opened. The rule for transaction amount accounts is "general ledger account + serial number". Multiple transaction amount accounts are opened for concurrent accumulation of transaction amounts, avoiding hotspots and supporting high-concurrency real-time accumulation of general ledger transaction amounts.

[0017] Furthermore, the default number of general ledger transaction accounts is 10, and the number of transaction accounts can be controlled by parameters; the general ledger transaction accounts are used to accumulate the transaction amount for the day.

[0018] Furthermore, step one is used to address hotspot issues when accumulating general ledger transactions, thereby improving update speed and ensuring near real-time timeliness.

[0019] Furthermore, in step two, the general ledger transaction amount is the general ledger account plus the serial number.

[0020] Furthermore, the formula for calculating the real-time general ledger balance is as follows:

[0021] Real-time general ledger balance = Previous day's general ledger balance + (General ledger transaction amount 1 + ... + General ledger transaction amount n);

[0022] Where 1≤n≤m (m is usually less than or equal to 10), n is the total ledger amount, and m is the number of accounts in the total ledger.

[0023] Furthermore, the specific method for the aforementioned accounting entries is as follows:

[0024] S21, Configure accounting entry information, and determine whether accounting subject information exists in the configured accounting entry information;

[0025] S22, if the accounting subject information does not exist, then configure the accounting subject information and store the configured accounting entry information and the accounting subject information;

[0026] S23, upon receiving the business, the system retrieves the corresponding accounting subject information and accounting entry information from the stored accounting entry information and accounting subject information, and processes the accounting entries for the business based on the retrieved accounting subject information and accounting entry information.

[0027] Another object of the present invention is to provide a system for obtaining the general ledger balance in real time under large transaction volume, implementing the method described above. The system for obtaining the general ledger balance in real time under large transaction volume includes:

[0028] The General Ledger Transaction Account Setup Module is used to set up multiple independent General Ledger Transaction Accounts using the General Ledger Account + Sequence Number method when opening a General Ledger Account through the SQL Service Database.

[0029] The General Ledger Transaction Accumulation Module is used to asynchronously and near real-time accumulate the General Ledger Transaction Amount based on a single accounting entry. It employs a load balancing strategy to select one transaction account from multiple General Ledger Transaction Amount Accounts for transaction accumulation.

[0030] The Real-Time General Ledger Balance module is used to query the previous day's general ledger balance and general ledger transaction amount when querying the general ledger balance during the day, and to calculate the real-time general ledger balance.

[0031] The zeroing module is used to reset the daily transaction amount of the general ledger account to zero at the end of each day.

[0032] Another object of the present invention is to provide a computer device including a memory and a processor, the memory storing a computer program, which, when executed by the processor, causes the processor to perform the steps of the method for obtaining the general ledger balance in real time under large transaction volume.

[0033] Another object of the present invention is to provide a computer-readable storage medium storing a computer program, which, when executed by a processor, causes the processor to perform the steps of the method for obtaining the general ledger balance in real time under large transaction volumes.

[0034] Combining all the above technical solutions, the advantages and positive effects of this invention are as follows: This invention replaces "querying based on accounting entry summary amount" with "real-time cumulative general ledger amount," transforming the summary amount into the query general ledger amount, avoiding the summary calculation of large amounts of data, and significantly reducing the time consumption for querying real-time balance. Because it avoids the summary calculation of large amounts of data, it saves a significant amount of system resources and can support multiple concurrent queries of the real-time general ledger balance; simultaneously, this invention sets up multiple general ledger amount accounts for one general ledger account. When accumulating based on accounting entries, it "randomly (or using other load balancing strategies)" selects one general ledger amount account from multiple general ledger amount accounts for accumulation, distributing a large number of concurrent accumulations, solving the hotspot problem during general ledger amount accumulation, improving the accumulation speed of general ledger amounts, and ensuring the timeliness of real-time balance; furthermore, this invention provides a method for viewing the real-time general ledger balance under large transaction volumes, improving the calculation and viewing speed of the real-time general ledger balance under large transaction volumes, shortening query time, reducing the occupation of system resources such as memory and database, and supporting concurrent queries by multiple users. Attached Figure Description

[0035] Figure 1 This is a schematic diagram of the method for obtaining the general ledger balance in real time under large transaction volume provided by an embodiment of the present invention;

[0036] Figure 2 This is a schematic diagram of the specific method flow for accounting entries provided in the embodiments of the present invention;

[0037] Figure 3 This is a schematic diagram of the system structure for obtaining the general ledger balance in real time under large transaction volumes, provided by an embodiment of the present invention.

[0038] In the diagram: 1. General Ledger Transaction Account Settings Module; 2. General Ledger Transaction Accumulation Module; 3. Real-time General Ledger Balance Module; 4. Zeroing Module. Detailed Implementation

[0039] To make the objectives, technical solutions, and advantages of this invention clearer, the invention will be further described in detail below with reference to embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the invention.

[0040] To address the problems existing in the prior art, the present invention provides a method, system, and device for obtaining the general ledger balance in real time under large transaction volumes. The present invention will be described in detail below with reference to the accompanying drawings.

[0041] Main plan and effect description section:

[0042] like Figure 1 As shown, the method for obtaining the general ledger balance in real time under large transaction volumes provided by this embodiment of the invention includes the following steps:

[0043] The method for obtaining the general ledger balance in real time under high transaction volume includes:

[0044] S1. First, open a general ledger account in the local database system, set the integrity of the attributes in the general ledger account and enter the information. Use the database service to obtain the general ledger transaction amount parameter in binary code form through FTP port 20. Use SQL statements to extract the same general ledger account data in the general ledger account and the general ledger transaction amount account. Set up multiple independent general ledger transaction amount accounts using the general ledger account + serial number method.

[0045] The method for opening a general ledger entry account:

[0046] While automatically or manually creating general ledger accounts, transaction amount accounts are also automatically created. The rule for transaction amount accounts is "general ledger account + serial number". Multiple transaction amount accounts are created for concurrent accumulation of transaction amounts, avoiding hotspots and supporting high-concurrency real-time accumulation of general ledger transaction amounts.

[0047] Obtain the merchant's basic information; based on the merchant's basic information, determine whether the merchant has a basic account; if so, request the basic account information corresponding to the merchant's basic information from the bank where the basic account is located; and use the basic account information to open a general ledger account for the merchant.

[0048] After opening a general ledger account for a merchant, the method further includes: setting the corresponding usage scenarios and usage amounts for the opened general ledger account;

[0049] The basic account information contains the merchant's identity authentication information. The step of using the basic account information to open a general ledger account for the merchant specifically includes: comparing the identity information with the merchant's identity authentication information; if the comparison is successful, then using the basic account information to open a general ledger account for the merchant.

[0050] After obtaining the merchant's basic information and determining whether the merchant has a basic account based on the merchant's basic information, the method further includes: if it exists, obtaining all basic accounts corresponding to the merchant's basic information; presenting all basic accounts so that the merchant can determine whether to input identity information based on all basic accounts;

[0051] The basic information of the merchant includes: the merchant's ID card number and mobile phone number; the identity information of the merchant includes: one or more of the following: the merchant's facial image, the merchant's fingerprint, the merchant's iris scan, and the merchant's electronic signature.

[0052] S2 generates accounting entries through accounting. Based on the accounting entries, it uses structured query statements to obtain general ledger account numbers from general ledger accounts, and then obtains transaction amount accounts from general ledger transaction amount accounts in the form of records based on the general ledger account numbers. It accumulates general ledger transaction amounts synchronously or asynchronously in near real-time for each accounting entry, and uses the get severe method to obtain the load balancing strategy set for the transaction amount accounts. Based on the obtained load balancing strategy, it uses a random algorithm to select one transaction amount account from multiple general ledger transaction amount accounts for accumulation in the accounting entries.

[0053] S3, the database system uses SQL query language to query the general ledger account to obtain the previous day's general ledger balance. Based on the general ledger transaction accounts, it uses the group by statement to summarize multiple transaction accounts and obtain the transaction amount for the current day. It uses a custom structured language to embed the formula "general ledger real-time balance = previous day's balance + current day's transaction amount" to obtain the general ledger real-time balance.

[0054] S4 uses database manipulation statements to reset the transaction amount of the general ledger transaction account to zero at the end of each day.

[0055] The default number of general ledger account entries is 10.

[0056] The general ledger entry account is used to accumulate the daily entries.

[0057] S1 is used to address hotspot updates when accumulating general ledger transactions, improving update speed and ensuring near real-time timeliness.

[0058] In S2, the general ledger entry account is the general ledger account plus the serial number.

[0059] The formula for calculating the real-time general ledger balance is as follows:

[0060] Real-time general ledger balance = Previous day's general ledger balance + (General ledger transaction amount 1 + ... + General ledger transaction amount n);

[0061] Where 1≤n≤m (m is usually less than or equal to 10), n is the total ledger amount, and m is the number of accounts in the total ledger.

[0062] like Figure 2 As shown, the specific method for the accounting entries is as follows:

[0063] S21, Configure accounting entry information, and determine whether accounting subject information exists in the configured accounting entry information;

[0064] S22, if the accounting subject information does not exist, then configure the accounting subject information and store the configured accounting entry information and the accounting subject information;

[0065] S23, after receiving the business, search for the accounting subject information and accounting entry information corresponding to the business from the stored accounting entry information and accounting subject information, and perform accounting processing on the business based on the found accounting subject information and accounting entry information.

[0066] To demonstrate the inventiveness and technical value of the technical solution of this invention, this section provides specific product or related technology application examples of the technical solution claimed.

[0067] like Figure 3 As shown, this invention implements the method for obtaining the total ledger balance in real time under high transaction volume using a system for obtaining the total ledger balance in real time under high transaction volume. The system for obtaining the total ledger balance in real time under high transaction volume includes:

[0068] General Ledger Transaction Account Setting Module 1 is used to set up multiple independent general ledger transaction accounts using the general ledger account + serial number method when opening a general ledger account through the SQL service database.

[0069] General ledger entry accumulation module 2 is used to asynchronously and near real-time accumulate general ledger entries based on individual accounting entries. It adopts a load balancing strategy to select one general ledger entry from multiple general ledger accounts for accumulation.

[0070] The Real-time General Ledger Balance Module 3 is used to query the previous day's general ledger balance and general ledger transaction amount when querying the general ledger balance during the day, and to calculate the real-time general ledger balance;

[0071] Zeroing module 4 is used to reset the daily transaction amount of the general ledger transaction amount account to zero at the end of each day.

[0072] Working principle: When this invention is working, it first uses the general ledger transaction amount account setting module 1 to open a general ledger account in the local database system, sets the integrity of the attributes in the general ledger account and enters the information, uses the database service to obtain the general ledger transaction amount parameters in binary code form through FTP port 20, uses SQL statements to extract the same general ledger account data in the general ledger account and general ledger transaction amount account, and sets up multiple independent general ledger transaction amount accounts using the general ledger account + serial number method. The general ledger transaction amount accumulation module 2 uses the obtained load balancing strategy to select one transaction amount account from the multiple general ledger account transaction amount accounts using a random algorithm to accumulate it in the accounting entry. Next, the real-time general ledger balance module 3 uses the previous day's general ledger balance and general ledger transaction amount to query and calculate the real-time general ledger balance. Finally, the zeroing module 4 uses the daily zeroing module to zero the transaction amount of the general ledger transaction amount account at the end of each day.

[0073] To make the technical means, creative features, objectives, and effects of this invention easier to understand, the invention is further described below with reference to embodiments:

[0074] Example: The method for obtaining the total ledger balance in real time under large transaction volume provided in this embodiment of the invention is applied to a computer device. The computer device includes a memory and a processor. The memory stores a computer program. When the computer program is executed by the processor, the processor performs the steps of the method for obtaining the total ledger balance in real time under large transaction volume.

[0075] The method for obtaining the total ledger balance in real time under large transaction volume provided in the embodiments of the present invention is applied to a computer-readable storage medium storing a computer program. When the computer program is executed by a processor, the processor performs the steps of the method for obtaining the total ledger balance in real time under large transaction volume.

[0076] Methods for obtaining the general ledger balance in real time under high transaction volume include:

[0077] When opening a general ledger account, multiple independent general ledger transaction accounts are set up using the general ledger account + serial number method;

[0078] The accounting entries are generated and the general ledger entries are accumulated asynchronously and in near real-time based on each individual accounting entry. Random or other load balancing strategies are used to select one of the multiple general ledger entries for accumulation.

[0079] When querying the general ledger balance during the day, the previous day's general ledger balance and general ledger transaction amount can be retrieved separately, and the real-time general ledger balance can be calculated.

[0080] At the end of each day, the transaction amount in the general ledger account should be zeroed out.

[0081] The default number of general ledger transaction accounts is 10, but the number of transaction accounts can be controlled by parameters.

[0082] The general ledger entry account is used to concurrently accumulate the total general ledger entries for the day.

[0083] Step one is used to address hotspot updates when accumulating general ledger transactions, thereby improving update speed and ensuring near real-time timeliness.

[0084] In step two, the general ledger entry amount is the general ledger account plus the serial number.

[0085] The formula for calculating the real-time general ledger balance is as follows:

[0086] Real-time general ledger balance = Previous day's general ledger balance + (General ledger transaction amount 1 + ... + General ledger transaction amount n);

[0087] Where 1≤n≤m (m is usually less than or equal to 10), n is the total ledger amount, and m is the number of accounts in the total ledger.

[0088] The specific method for making the accounting entries is as follows:

[0089] Configure accounting entry information and determine whether accounting subject information exists in the configured accounting entry information;

[0090] If the accounting subject information does not exist, then the accounting subject information is configured, and the configured accounting entry information and the accounting subject information are stored.

[0091] Upon receiving a business transaction, the system retrieves the corresponding accounting subject information and accounting entry information from the stored accounting entry information and accounting subject information, and processes the accounting entries for the business transaction based on the retrieved accounting subject information and accounting entry information.

[0092] In the description of this invention, unless otherwise stated, "a plurality of" means two or more; the terms "upper," "lower," "left," "right," "inner," "outer," "front end," "rear end," "head," "tail," etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings, and are only for the convenience of describing the invention and simplifying the description, and do not indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation, and therefore should not be construed as a limitation of the invention. Furthermore, the terms "first," "second," "third," etc., are used for descriptive purposes only and should not be construed as indicating or implying relative importance.

[0093] It should be noted that embodiments of the present invention can be implemented in hardware, software, or a combination of both. The hardware portion can be implemented using dedicated logic; the software portion can be stored in memory and executed by a suitable instruction execution system, such as a microprocessor or dedicated-design hardware. Those skilled in the art will understand that the above-described devices and methods can be implemented using computer-executable instructions and / or included in processor control code, for example, such code provided on a carrier medium such as a disk, CD, or DVD-ROM, a programmable memory such as read-only memory (firmware), or a data carrier such as an optical or electronic signal carrier. The devices and modules of the present invention can be implemented using hardware circuitry such as very large-scale integrated circuits or gate arrays, semiconductors such as logic chips, transistors, etc., or programmable hardware devices such as field-programmable gate arrays, programmable logic devices, etc., or using software executed by various types of processors, or using a combination of the above-described hardware circuitry and software, such as firmware.

[0094] The above description is merely a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any modifications, equivalent substitutions, and improvements made by those skilled in the art within the scope of the technology disclosed in the present invention, and within the spirit and principles of the present invention, should be covered within the scope of protection of the present invention.

Claims

1. A method for obtaining the general ledger balance in real time under high transaction volume, characterized in that, The method for obtaining the general ledger balance in real time under high transaction volume includes the following steps: Step 1: First, open a general ledger account in the local database system, set the integrity of the attributes in the general ledger account and enter the information. Use the database service to obtain the general ledger transaction amount parameter in binary code form through FTP port 20. Use SQL statements to extract the same general ledger account data in the general ledger account and the general ledger transaction amount account. Set up multiple independent general ledger transaction amount accounts using the general ledger account number + serial number method. Step 2: Generate accounting entries through accounting. Based on the accounting entries, use structured query statements to obtain general ledger account numbers from general ledger accounts. Then, based on the general ledger account numbers, obtain the general ledger transaction amounts from the general ledger transaction amount accounts in the form of records. Accumulate the general ledger transaction amounts synchronously or asynchronously in near real-time for each accounting entry. Use the getServer method to obtain the load balancing strategy set for the general ledger transaction amount accounts. Based on the obtained load balancing strategy, use a random algorithm to select one general ledger transaction amount account from multiple general ledger transaction amount accounts for accumulation in the accounting entries. Step 3: The database system uses SQL query language to query the general ledger accounts to obtain the previous day's general ledger balance. Based on the general ledger transaction accounts, it uses the group by statement to summarize multiple general ledger transaction accounts and obtain the transaction amount for the current day. It also uses a custom structured language to embed the formula "General Ledger Real-time Balance = Previous Day's General Ledger Balance + Current Day's Transaction Amount" to obtain the general ledger real-time balance. Step 4: At the end of each day, use database manipulation statements to reset the transaction amount of the general ledger transaction account to zero.

2. The method for obtaining the general ledger balance in real time under large transaction volume as described in claim 1, characterized in that, Methods for opening general ledger accounts: While automatically or manually opening general ledger accounts, general ledger transaction amount accounts are also automatically opened. The rule for general ledger transaction amount accounts is "general ledger account number + serial number". Multiple general ledger transaction amount accounts are opened for concurrent accumulation of transaction amounts, avoiding hotspots and supporting high-concurrency real-time accumulation of general ledger transaction amounts.

3. The method for obtaining the general ledger balance in real time under large transaction volume as described in claim 1, characterized in that, The default number of general ledger transaction accounts is 10, and the number of general ledger transaction accounts can be controlled by parameters; the general ledger transaction accounts are used to accumulate the transaction amount for the day.

4. The method for obtaining the general ledger balance in real time under large transaction volume as described in claim 1, characterized in that, The formula for calculating the real-time general ledger balance is as follows: Real-time general ledger balance = Previous day's general ledger balance + (General ledger transaction amount 1 + ... + General ledger transaction amount n); Where 1≤n≤m, m is the number of general ledger entries, and m is less than or equal to 10.

5. The method for obtaining the general ledger balance in real time under large transaction volume as described in claim 1, characterized in that, The specific method for making the accounting entries is as follows: S21, Configure accounting entry information, and determine whether accounting subject information exists in the configured accounting entry information; S22, if the accounting subject information does not exist, then configure the accounting subject information and store the configured accounting entry information and the accounting subject information; S23, after receiving the business, search for the accounting subject information and accounting entry information corresponding to the business from the stored accounting entry information and accounting subject information, and perform accounting processing on the business based on the found accounting subject information and accounting entry information.

6. A system for obtaining the general ledger balance in real time under high transaction volume, implementing the method for obtaining the general ledger balance in real time under high transaction volume as described in any one of claims 1-5, characterized in that, The system for obtaining the general ledger balance in real time under high transaction volume includes: The General Ledger Transaction Account Setup Module is used to set up multiple independent General Ledger Transaction Accounts using the General Ledger Account Number + Serial Number method when opening a General Ledger Account through the SQL Service Database. The general ledger entry accumulation module is used to asynchronously and near real-time accumulate general ledger entries based on individual accounting entries. It employs a load balancing strategy to select one general ledger entry account from multiple general ledger entry accounts for entry accumulation. The General Ledger Real-Time Balance module is used to query the previous day's general ledger balance and general ledger transaction amount when querying the general ledger balance during the day, and to calculate the real-time general ledger balance. The zeroing module is used to reset the daily transaction amount of the general ledger account to zero at the end of each day.

7. A computer device, characterized in that, The computer device includes a memory and a processor. The memory stores a computer program that, when executed by the processor, causes the processor to perform the steps of the method for obtaining the general ledger balance in real time under large transaction volumes as described in any one of claims 1-5.

8. A computer-readable storage medium storing a computer program, which, when executed by a processor, causes the processor to perform the steps of the method for obtaining the general ledger balance in real time under a large transaction volume as described in any one of claims 1-5.

Images