CN117291741A - Account data processing method, device, equipment, storage medium and program product - Google Patents

Abstract

The present application relates to database technology, and more particularly, to an accounting data processing method, apparatus, computer device, storage medium, and computer program product. The method comprises the following steps: receiving an accounting data record request, wherein the accounting data record request comprises a plurality of accounting details; starting a transaction corresponding to the accounting data record request based on a programming transaction mode, and setting the isolation level of the transaction as read submitted; reading an initial value and a first timestamp corresponding to the current accounting detail from an account remaining value table; processing the corresponding accounting details based on the initial value in the transaction to obtain an end-of-period value; and when the first timestamp is successfully matched with a corresponding second timestamp in the account residual numerical value table, updating an initial value in the account residual numerical value table based on the end-of-period value, and updating a timestamp corresponding to the initial value in the account residual numerical value table. By adopting the method, the program overhead can be reduced.

Description

Account data processing method, device, equipment, storage medium and program product

Technical Field

The present invention relates to the field of database technologies, and in particular, to an accounting data processing method, an accounting data processing device, a computer device, a storage medium, and a computer program product.

Background

Along with the development of financial business, the accuracy requirements of accounting subjects are higher and higher, the system ensures the consistency of accounts by adding pessimistic locks or optimistic locks, and the integrity of accounts is ensured by database transactions.

Pessimistic locks have exclusivity and exclusivity, taking an account A to an account B as an example, firstly selecting and updating the account A and the account B at the beginning of a flow, respectively locking two rows of data, and then reading a critical value of the grading to split accounts. If the locking fails, the data is modified, an exception needs to be waited or thrown, and the shared resource is only used for a single thread, so that the integrity of the data can be ensured. In order to ensure the correctness of the split subjects of the classified billing, the system generally uses a database lock function to realize that the rest accounts cannot operate on a certain account while performing the billing, for example select for update, and although the mechanism can ensure the sequence of data and the correctness of the accounts, a long waiting condition exists in a high concurrency condition, and even deadlock is caused.

Many systems consider using an optimistic lock mechanism in the event of low concurrency, which always assumes that certain lines of data are not being modified by other programs when they are being processed. When updating the data, it is determined whether the data has been modified during this period, and if the data is found to be modified, an error is polled or returned. The scheme can ensure the data integrity and improve the concurrency capability of the program to a certain extent. The optimistic lock is contrary to the pessimistic lock idea, the version number is added in the account table, the version number of the account data is firstly inquired, whether the version number is consistent with the version number obtained by the previous inquiry is checked during data updating, if so, the version number is added with 1 and the balance is updated, and if not, the error is directly reported or the inquiry is executed again to continuously try to update. This approach requires the addition of a version number to the database, which can introduce some overhead into the program.

Disclosure of Invention

In view of the foregoing, it is desirable to provide an accounting data processing method, apparatus, computer device, computer readable storage medium, and computer program product that can reduce program overhead.

In a first aspect, the present application provides an accounting data processing method, the method including:

Receiving an accounting data record request, wherein the accounting data record request comprises a plurality of accounting details;

starting a transaction corresponding to the accounting data record request based on a programming transaction mode, and setting the isolation level of the transaction as read submitted;

reading an initial value and a first timestamp corresponding to the current accounting detail from an account remaining value table;

processing the corresponding accounting details based on the initial value in the transaction to obtain an end-of-period value;

and when the first timestamp is successfully matched with a corresponding second timestamp in the account residual numerical value table, updating an initial value in the account residual numerical value table based on the end-of-period value, and updating a timestamp corresponding to the initial value in the account residual numerical value table.

In one embodiment, the processing, in the transaction, the corresponding accounting details based on the initial value to obtain an end-of-period value includes:

acquiring a unified ordering rule corresponding to each transaction;

based on the sorting rule, sorting the accounting details according to accounts corresponding to the accounting details;

and in the transaction, sequentially processing the ordered accounting details based on the initial value of the period to obtain a corresponding end value of the period.

In one embodiment, the method further comprises:

rollback the transaction based on a programmed transaction manner when the matching of the first timestamp and a corresponding second timestamp in the account remaining value table fails;

judging whether the retry number reaches a preset value;

and when the retry number does not reach a preset value, restarting a transaction corresponding to the accounting data record request based on a programmed transaction mode until the retry number reaches the preset value or the transaction is submitted successfully.

In one embodiment, the rollback of the transaction based on a programmed transaction manner when the matching of the first timestamp and the corresponding second timestamp in the account remaining value table fails includes:

acquiring an update influence value returned by a database corresponding to an account residual numerical value table, wherein the update influence value is used for identifying the updated data number of the account residual numerical value table;

and rolling back the transaction based on a programming transaction mode when the update impact value is not the target value.

In one embodiment, after the transaction corresponding to the accounting data record request is started based on the programming transaction mode, the method further includes:

Acquiring preset transaction timeout time;

and when the first timestamp is successfully matched with a corresponding second timestamp in the account remaining numerical value table, updating the initial period numerical value in the account remaining numerical value table based on the end-of-period numerical value, and further comprising:

determining whether corresponding data in the account remaining numerical table is being written or not based on the isolation level;

when corresponding data in the account residual value table is being written, acquiring current waiting time;

ending the transaction when the current waiting time exceeds the transaction timeout time;

and when the corresponding data in the account residual value table is not written, continuing to execute the step of updating the initial value in the account residual value table based on the end-of-period value when the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table.

In one embodiment, the method further comprises:

storing a plurality of accounting details in the accounting data record request into an accounting detail table;

acquiring a grading parameter value in a parameter table;

judging whether the corresponding accounting details need to be split or not based on the end-of-term value, the occurrence value and the grading parameter value;

When the accounting details need to be split, splitting the accounting details based on the end-of-term value and the occurrence value to obtain split accounting details;

and determining the transparent mark and the transparent type of the split account details and the non-split account details, and storing the split account details, the non-split account details, the corresponding transparent mark and the transparent type into a accounting list.

In one embodiment, the step parameter values in the acquisition parameter table include:

acquiring an account corresponding to the accounting details;

and acquiring a grading parameter value corresponding to the account from the parameter table.

In a second aspect, the present application further provides an accounting data processing device, the device comprising:

the receiving module is used for receiving an accounting data recording request, wherein the accounting data recording request comprises a plurality of accounting details;

the transaction opening module is used for opening a transaction corresponding to the accounting data record request based on a programming transaction mode and setting the isolation level of the transaction as read submitted;

the reading module is used for reading the initial value and the first timestamp corresponding to the current accounting detail from the account remaining value table;

The numerical processing module is used for processing the corresponding accounting details based on the initial value in the transaction to obtain an end-of-period value;

and the updating module is used for updating the initial value in the account residual value table based on the end value of the period when the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table, and updating the timestamp corresponding to the initial value in the account residual value table.

In a third aspect, the present application also provides a computer device comprising a memory storing a computer program and a processor implementing the steps of the method of any one of the embodiments described above when the computer program is executed by the processor.

In a fourth aspect, the present application also provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method of any of the embodiments described above.

In a fifth aspect, the present application also provides a computer program product comprising a computer program which, when executed by a processor, implements the steps of the method of any of the embodiments described above.

According to the accounting data processing method, the accounting data processing device, the computer equipment, the storage medium and the computer program product, after the accounting data recording request is received, the transaction corresponding to the accounting data recording request is started based on the programming transaction mode, so that the transaction operation can be managed more flexibly and accurately, and the minimum granularity can be applied to the code block level; in addition, the isolation level of the transaction is set to be that reading is submitted, and the initial value and the first timestamp corresponding to the accounting details are read from the account remaining value table at first, and when the transaction is submitted, the initial value in the account remaining value table is updated based on the final value of the period and the timestamp corresponding to the initial value in the account remaining value table is updated only after the first timestamp and the second timestamp corresponding to the account remaining value table are successfully matched, so that the version number is not increased as the optimistic lock is not needed, and the expenditure of resources is reduced.

Drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the related art, the drawings that are required to be used in the embodiments or the related technical descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and other drawings may be obtained according to the drawings without inventive effort for a person having ordinary skill in the art.

FIG. 1 is an application environment diagram of an accounting data processing method in one embodiment;

FIG. 2 is a flow chart of an accounting data processing method in one embodiment;

FIG. 3 is a flow diagram of step accounting in one embodiment;

FIG. 4 is a timing diagram of an accounting data processing method in another embodiment;

FIG. 5 is a block diagram of an accounting data processing device in one embodiment;

fig. 6 is an internal structural diagram of a computer device in one embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.

The accounting data processing method provided by the embodiment of the application can be applied to an application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network, the server 104 also communicates with the database 106. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104 or may be located on a cloud or other network server.

Wherein the server 104 may receive an accounting data record request sent by the terminal, where the accounting data record request includes a plurality of accounting details; starting a transaction corresponding to the accounting data record request based on a programming transaction mode, and setting the isolation level of the transaction as read submitted; reading an initial value corresponding to the current accounting details and a first timestamp from an account remaining value table stored in the database 106; processing corresponding accounting details based on the initial value in the transaction to obtain the final value; and when the first time stamp is successfully matched with the corresponding second time stamp in the account remaining value table, updating the initial period value in the account remaining value table based on the end-of-period value, and updating the time stamp corresponding to the initial period value in the account remaining value table.

According to the accounting data processing method, after the accounting data recording request is received, the transaction corresponding to the accounting data recording request is started based on the programming transaction mode, so that the transaction operation can be managed more flexibly and accurately, and the minimum granularity can be applied to the code block level; in addition, the isolation level of the transaction is set to be that reading is submitted, an initial value and a first timestamp corresponding to the current account details are read from an account remaining value table at first, and when the first timestamp and a second timestamp corresponding to the account remaining value table are successfully matched during the submitting, the initial value in the account remaining value table is updated based on the end value of the period, the timestamp corresponding to the initial value in the account remaining value table is updated, the version number is not increased as in the case of optimistic locks, and the expenditure of resources is reduced.

The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices, and portable wearable devices, where the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart vehicle devices, and the like. The portable wearable device may be a smart watch, smart bracelet, headset, or the like. The server 104 may be implemented as a stand-alone server or as a server cluster of multiple servers. Database 106 may be any type of database.

In an exemplary embodiment, as shown in fig. 2, there is provided an accounting data processing method, which is described as an example of application of the method to the server in fig. 1, including the following steps S202 to S210.

Wherein:

s202: an accounting data record request is received, the accounting data record request including a plurality of accounting details.

Wherein the accounting data record request is a request for storing accounting data generated by the transaction. Wherein the transaction may include multiple accounts, such that the accounting data record request includes multiple account details, one account for each account. For example, the accounting data record request may include four account details, (1) borrow A account 100 elements (2) borrow B account 100 elements (3) credit C account 150 elements (4) credit D account 20 elements, where borrow A account 100 elements account details correspond to account A, and other accounting details correspond to other accounts as well.

S204: and starting a transaction corresponding to the accounting data record request based on a programming transaction mode, and setting the isolation level of the transaction as the submitted reading.

The transaction management is realized by a coding mode based on a programming transaction mode, for example, the transaction management is realized by a spring coding mode, and the transaction management comprises the steps of opening, rollback, submitting and the like. The spring programming transaction mode grasps operations such as opening, submitting, rolling back and the like of the transaction in the hand of a developer, can more flexibly and accurately manage the transaction operation and can act on the level of the code block with minimum granularity. In addition, it should be noted that the transactions are concurrent and do not interfere with each other.

Transaction isolation level refers to how changes made to data by one operation are visible to other parallel operations in a transaction concurrency scenario, with varying degrees of visibility defining transaction isolation levels. The isolation level of a transaction includes read committed, read uncommitted, repeatable read, and serializable. In this embodiment, the isolation level of the transaction is that a read is submitted, and the manner in which the read is submitted refers to that in the execution process of one transaction, not only can the newly inserted data successfully submitted by other transactions be accessed, but also the successfully modified data can be accessed. Transactions that read data allow other transactions to continue to access the line of data, but uncommitted write transactions will prohibit other transactions from accessing the line. And it is assumed that a certain data is not modified by other programs when it is processed.

S206: and reading the initial value and the first timestamp corresponding to the current accounting details from the account remaining value table.

The account residual numerical value table stores accounts and account residual numerical values, wherein the accounts comprise account accounts, currencies, states and other information fields; the account remaining value table comprises fields such as account number, currency, account remaining value, current date primary value, timestamp and the like.

Wherein the prime account takes on a value prior to a certain financial transaction. The timestamp refers to the fact that an account residual value table is registered when the account residual value changes, the timestamp refers to the field in the account residual value table, and the timestamp field is synchronously updated to the latest time when the account residual value table is registered or updated. The first timestamp is the timestamp of last update of the accounting details, and each time the accounting details are updated, the timestamp is updated correspondingly.

When the server processes the account details, namely when the account data record request is processed in one transaction, each account detail is processed in series, account information corresponding to the first account detail is acquired first, and then an initial value and a first timestamp are read from an account residual data table based on the account information.

S208: and processing the corresponding accounting details based on the initial value in the transaction to obtain the final value.

Specifically, the end-of-term value refers to the value of the account after a certain accounting transaction occurs. And the server calculates to obtain an end-of-period value based on the initial-period value and the corresponding accounting details, for example, if the accounting details are 100 yuan by the A account, the calculation of the end-of-period value of the corresponding A account is the initial-period value-100 yuan.

S210: and when the first time stamp is successfully matched with the corresponding second time stamp in the account remaining value table, updating the initial period value in the account remaining value table based on the end-of-period value, and updating the time stamp corresponding to the initial period value in the account remaining value table.

After calculating the end-of-period value, the server submits the end-of-period value to the database in the transaction, and simultaneously submits the first timestamp in the process of submitting, so that the database obtains an account corresponding to the end-of-period value, reads the second timestamp of the end-of-period value of the account, compares the first timestamp with the second timestamp, and if the first timestamp is the same as the second timestamp, the initial value of the period is not modified, so that the initial value of the period is replaced by the end-of-period value, the update of the initial value of the period is realized, and after the update is completed, the current time is obtained, and the timestamp corresponding to the initial value of the period in the residual value table of the account is updated, so that the processing of other accounts on the data is facilitated.

Optionally, for the submission of the end-of-term value, in this embodiment, the end-of-term value is submitted once after the transaction is calculated, or the end-of-term values corresponding to all account details in the transaction are calculated, and then the transaction is submitted uniformly, which is not limited specifically herein.

According to the accounting data processing method, after the accounting data recording request is received, the transaction corresponding to the accounting data recording request is started based on the programming transaction mode, so that the transaction operation can be managed more flexibly and accurately, and the minimum granularity can be applied to the code block level; in addition, the isolation level of the transaction is set to be that reading is submitted, an initial value and a first timestamp corresponding to the current account details are read from an account remaining value table at first, and when the first timestamp and a second timestamp corresponding to the account remaining value table are successfully matched during the submitting, the initial value in the account remaining value table is updated based on the end value of the period, the timestamp corresponding to the initial value in the account remaining value table is updated, the version number is not increased as in the case of optimistic locks, and the expenditure of resources is reduced.

In one embodiment, processing corresponding accounting details based on the initial value in the transaction to obtain the end-of-period value includes: acquiring a unified ordering rule corresponding to each transaction; based on the ordering rule, ordering the account details according to the account corresponding to the account details; and in the transaction, sequentially processing the ordered accounting details based on the initial value of the period to obtain the corresponding end value of the period.

The ordering rule is unified for each transaction, and the rules for ordering the details of the accounts are the same in all the transactions, and may be preset, for example, ordering according to the names of the accounts, and in other embodiments, ordering according to other attributes of the accounts.

After the transaction is started, the accounting details in the transaction are ordered according to the ordering rule, and then the accounting details are sequentially processed in the transaction.

To facilitate understanding, for example, one transaction is a debit A account, a credit B account, and another transaction is a debit B account, a credit A account. If the transactions are not ordered, deadlock occurs when the transactions are processed simultaneously, namely, when the transaction A account corresponding to the first transaction is processed, the account A is locked, and meanwhile, as the transactions are concurrent, the transaction B account is processed by the second transaction, and the account B is locked, so that the two accounts are interlocked. For this purpose, the account details in the two transactions are ordered, for example, the first transaction is changed to a credit account B, and the second transaction is changed to a credit account B, so that according to the setting of the transactions, the second transaction waits for the first transaction to finish and then process, specifically, the first transaction is processed first, the first transaction locks the account a, at this time, the second transaction finds that the account a is locked, waits, and when the first transaction finishes processing the account a and releases, the second transaction processes the account a. And the first transaction continues to process the account B, after the second transaction finishes the account A, the second transaction continues to process the account B after the first transaction finishes the account B, and the interlocking condition can not occur.

In the above embodiment, each transaction has a unified ordering rule, so that before each transaction is processed, multiple accounting details are processed, so that the same account is processed in each transaction, and no interlocking condition is caused.

In one embodiment, the method further comprises: rollback transactions based on a programmed transaction mode when matching of the first timestamp and a corresponding second timestamp in the account remaining value table fails; judging whether the retry number reaches a preset value; and when the retry number does not reach the preset value, restarting the transaction corresponding to the accounting data record request based on the programming transaction mode until the retry number reaches the preset value or the transaction is submitted successfully.

And if the first timestamp is not equal to the second timestamp, indicating that the initial residual value in the account residual value table is changed, rolling back the transaction based on a programming transaction mode, judging whether the retry number corresponding to the transaction reaches a preset value, if the retry number does not reach the preset value, starting the transaction corresponding to the accounting data record request again based on the programming transaction mode, and if the retry number does not reach the preset value, feeding back the transaction failure information. The preset value may be set by the user, for example, 2 times, 3 times, etc., and is not particularly limited herein.

In the above embodiments, based on the programmed transaction mode rollback transaction, the transaction is re-submitted, the transaction operation can be managed more flexibly and accurately, and the minimum granularity can be applied to the code block level.

In one embodiment, rolling back the transaction based on the programmed transaction manner when the matching of the first timestamp and the corresponding second timestamp in the account remaining value table fails, comprises: acquiring an updated influence value returned by a database corresponding to the account residual numerical value table, wherein the updated influence value is used for identifying the updated data number of the account residual numerical value table; and rolling back the transaction based on the programming transaction mode when the update impact value is not the target value.

Specifically, the update impact value is used to identify the updated number of data in the account remaining value table, and generally, only one line of data in the account remaining value table is processed each time the account details are submitted, so that the update impact value is 1, and if the data in the account remaining value table is not processed, the update impact value is 0. Therefore, whether the update is successful can be judged based on the finer influence value, if the update influence value is not the target value, namely 1, the transaction commit failure is indicated, so that the transaction is rolled back based on the programming transaction mode, if the update influence value is 1, the success of the commit is indicated, and the next account detail can be continuously processed until the processing is completed.

In the above embodiment, whether to roll back the transaction is determined based on the update influence value returned by the database, so that the data overhead is small.

In one embodiment, after the transaction corresponding to the accounting data record request is started based on the programming transaction mode, the method further comprises: acquiring preset transaction timeout time; when the first timestamp is successfully matched with the corresponding second timestamp in the account remaining value table, before updating the initial period value in the account remaining value table based on the end-of-period value, the method further comprises the following steps: determining whether corresponding data in the account residual value table is being written or not based on the isolation level; when corresponding data in the account residual value table is being written, acquiring current waiting time; ending the transaction when the current waiting time exceeds the transaction timeout time; and when the corresponding data in the account residual value table is not being written, continuing to execute the step of updating the initial value in the account residual value table based on the end-of-period value when the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table.

The transaction timeout time is to avoid transaction processing failure, for example, one transaction is a borrowing A account, a lending B account, another transaction is a borrowing B account, the lending A account is changed into the borrowing A account and the lending A account is changed into the lending B account in the first transaction after sequencing, so that according to the setting of the transaction, the second transaction waits for the first transaction to finish the reprocessing, if the transaction B also needs to process the A account in the second transaction, the first transaction is required to finish processing, and if the transaction B is required to finish processing, the timeout time is set to the transaction B, so that the A account in the first transaction is processed in the transaction A, and if the timeout time is not up, the A account is processed in the second transaction in the transaction B, so as to finish the processing of the transaction.

In the above embodiment, the timeout is set, so long as the timeout is within, the transaction is not required to be re-processed, and the success rate is improved.

In one embodiment, the method further comprises: storing the multi-note account details in the account data record request into an account detail table; acquiring a grading parameter value in a parameter table; judging whether the corresponding accounting details need to be split or not based on the end-of-term value, the occurrence value and the grading parameter value; when the accounting details need to be split, splitting the accounting details based on the end-of-term value and the occurrence value to obtain split accounting details; and determining the transparent mark and the transparent type of the split account details and the non-split account details, and storing the split account details, the non-split account details, the corresponding transparent mark and the transparent type into the accounting list.

Specifically, the parameter table stores grading parameter values, the grading parameter values are used for grading a plurality of sheets, the grading accounting refers to accounting of different departments according to different grading parameter values, and if the rest of the account values are crossed after transaction, the account values need to be split into a plurality of accounts.

In one of the alternative embodiments, obtaining the values of the step parameters in the parameter table includes: acquiring an account corresponding to the accounting details; the value of the step parameter corresponding to the account is obtained from the parameter table. Thus, the grading critical value of each account can be stored in a parameter table, and is dynamically set, so that flexibility and expansibility are improved.

The normal principal means that when the account principal value is greater than or equal to zero, the account remaining value belongs to the type of the money which is the normal principal. Overdraft principal means that when the account principal value is smaller than zero, the account remaining value belongs to the money type which is overdraft principal. Overdraft mark means overdraft mark is overdraft when the remaining number of account is negative, and the rest is not overdraft.

Referring to fig. 3, fig. 3 is a flow chart of the step billing in one embodiment, in which the step parameter value is 0:

(1) If the end-of-term value > =0, a value < =0 occurs, the remaining value overdraft flag is no, and the accounting details table is directly added.

(2) If the end-of-period value > =0, a value >0 occurs. Judging whether the end-of-period value (initial period value) is smaller than 0, if the end-of-period value (initial period value) is smaller than 0, adding 1 money as the end-of-period value, and adding 1 money as the end-of-period value, wherein the remaining value overdraft mark is a NO record, and the remaining value overdraft mark is a yes record; if the end-of-period value (initial period value) > =0, the remaining value overdraft flag is no, and the accounting list is directly added.

(3) If the end-of-term value <0, the occurrence value > =0, the remaining value overdraft flag is yes, directly added to the accounting list.

(4) If the end of period value <0, a value <0 occurs. Judging whether the end-of-period value (initial period value) is greater than 0, if the end-of-period value (initial period value) is greater than 0, adding 1 record of which the sum is (-1) and the end-of-period value, and the remaining value overdraft mark is yes, and then adding 1 record of which the sum is the end-of-period value (initial period value) and the remaining value overdraft mark is no; if the end-of-period value (initial period value) <=0, the remaining value overdraft flag is yes, directly adding to the accounting list.

(5) And obtaining whether the money type is overdraft principal or normal principal according to the overdraft marks in the four steps, and finally obtaining a specific accounting detail list.

In the above embodiment, the accounting list and the accounting list are stored separately, so that the accounting list completely retains the request list initiated by the operator, and the accounting list is used for storing the split accounting list without interference.

For easy understanding, referring to fig. 4, fig. 4 is a timing chart of an account data processing method in an embodiment, in the embodiment, a server receives an account data recording request sent by a terminal, starts a transaction corresponding to the account data recording request based on a programmed transaction mode, sets an isolation level of the transaction as a read submitted, sorts a plurality of account details in the account data recording request according to account names, obtains a current account details based on the sorting, determines an account corresponding to the current account details, reads a corresponding initial value and a first timestamp from an account residual value table of a database based on the account, processes the account details based on the initial value to obtain an end value of the transaction, sends the end value of the transaction and the first timestamp to a database after the processing is completed, and the database matches the first timestamp with a second timestamp in the account residual value table, updates the initial value in the account residual value table based on the end value of the transaction if the matching is successful, and updates the initial value corresponding to the account residual value in the account residual value table based on the end value of the transaction, and feeds back an influence value to the server to update the server, and continues to determine that the transaction processing is completed until the next transaction is successful. The method comprises the steps of updating balance, then adding a query account remaining value table to obtain an end-of-period value, loading the end-of-period value into the account remaining value table, updating balance statement to add a return value, updating balance input time stamp, throwing out abnormality and rolling back data if the number of the update return influence lines is not 1 (the return result is false), checking the time stamp again after updating, judging whether the time stamp is consistent, and if abnormality is not consistently thrown and the data is rolled back or the data is rolled back to try updating operation again.

In the above embodiment, the accounting statement and the accounting statement are separated, and the accounting statement is used for completely displaying the information and the transaction state recorded by the operator, and the accounting statement displays the final accounting entry, so that the coupling degree is reduced, and the maintainability is improved. The operation of splitting accounts according to the grading critical value is handed to the system for processing, so that the efficiency can be improved, and the consistency and the integrity of the accounts can be ensured. The correctness of the stepped accounting accounts under the concurrent condition can be ensured by improving the traditional optimistic locking mechanism and combining Spring transactions. In addition, the realization of the grading accounting splits the contract into a plurality of accounting details according to the grading critical value through the system, and an operator is not required to inquire the account primary balance, the transaction amount, calculate the final balance and read the grading critical value before inputting the accounting to split the details. This not only improves the work efficiency but also ensures the accuracy of accounting in concurrent scenarios. The accounting list and the accounting list are separated, so that an operator can clearly find out the details of own transaction entry, and can know how to split the accounting of the system according to the accounting list. By improving the traditional optimistic lock mechanism, not only is the billing core provided with the optimistic lock function, but also the overhead that may be caused by the optimistic lock spin is reduced. The grading critical value can be configured in the parameter table, so that not only can the general grading parameters be configured, but also the grading critical value maintenance of each account can be expanded, and the flexibility and expansibility are increased.

It should be understood that, although the steps in the flowcharts related to the above embodiments are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.

Based on the same inventive concept, the embodiment of the application also provides an accounting data processing device for realizing the accounting data processing method. The implementation of the solution provided by the device is similar to the implementation described in the above method, so the specific limitation in the embodiments of one or more accounting data processing devices provided below may be referred to the limitation of the accounting data processing method hereinabove, and will not be repeated here.

In one exemplary embodiment, as shown in fig. 5, there is provided an accounting data processing device including: a receiving module 501, a transaction opening module 502, a reading module 503, a value processing module 504, and an updating module 505, wherein:

a receiving module 501, configured to receive an accounting data record request, where the accounting data record request includes a plurality of accounting details;

the transaction opening module 502 is configured to open a transaction corresponding to the accounting data record request based on a programmed transaction manner, and set an isolation level of the transaction as a read submitted;

a reading module 503, configured to read an initial value and a first timestamp corresponding to the current accounting detail from the account remaining value table;

a value processing module 504, configured to process, in the transaction, the corresponding accounting details based on the initial value of the period, to obtain an end-of-period value;

and the updating module 505 is configured to update the initial value of the period in the account remaining value table based on the end value of the period when the first timestamp and the corresponding second timestamp in the account remaining value table are successfully matched, and update the timestamp corresponding to the initial value of the period in the account remaining value table.

In one embodiment, the numerical processing module 504 is further configured to obtain a unified ordering rule corresponding to each transaction; based on the ordering rule, ordering the account details according to the account corresponding to the account details; and in the transaction, sequentially processing the ordered accounting details based on the initial value of the period to obtain the corresponding end value of the period.

In one embodiment, the apparatus further includes: the rollback module is used for rollback the transaction based on a programming transaction mode when the matching of the first timestamp and the corresponding second timestamp in the account residual numerical table fails; judging whether the retry number reaches a preset value; and when the retry number does not reach the preset value, restarting the transaction corresponding to the accounting data record request based on the programming transaction mode until the retry number reaches the preset value or the transaction is submitted successfully.

In one embodiment, the rollback module is further configured to obtain an update impact value returned from a database corresponding to the account remaining numerical value table, where the update impact value is used to identify a number of data pieces updated by the account remaining numerical value table; and rolling back the transaction based on the programming transaction mode when the update impact value is not the target value.

In one embodiment, the apparatus further includes a timeout setting module, configured to obtain a preset transaction timeout time; determining whether corresponding data in the account residual value table is being written or not based on the isolation level; when corresponding data in the account residual value table is being written, acquiring current waiting time; ending the transaction when the current waiting time exceeds the transaction timeout time; and when the corresponding data in the account residual value table is not being written, continuing to execute the step of updating the initial value in the account residual value table based on the end-of-period value when the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table.

In one embodiment, the apparatus further includes a step module for storing the multi-note details in the accounting data record request into an accounting details table; acquiring a grading parameter value in a parameter table; judging whether the corresponding accounting details need to be split or not based on the end-of-term value, the occurrence value and the grading parameter value; when the accounting details need to be split, splitting the accounting details based on the end-of-term value and the occurrence value to obtain split accounting details; and determining the transparent mark and the transparent type of the split account details and the non-split account details, and storing the split account details, the non-split account details, the corresponding transparent mark and the transparent type into the accounting list.

In one embodiment, the above-mentioned grading module is further configured to obtain an account corresponding to the accounting details; the value of the step parameter corresponding to the account is obtained from the parameter table.

The respective modules in the above-described accounting data processing device may be implemented in whole or in part by software, hardware, and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.

In one exemplary embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 6. The computer device includes a processor, a memory, an Input/Output interface (I/O) and a communication interface. 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. Wherein the processor of the computer device is configured 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, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is for storing a first timestamp. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for communicating with an external terminal through a network connection. The computer program, when executed by a processor, implements a method of processing accounting data.

It will be appreciated by those skilled in the art that the structure shown in fig. 6 is merely a block diagram of some of the structures associated with the present application and is not limiting of the computer device to which the present application may be applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.

In one exemplary embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of: receiving an accounting data record request, wherein the accounting data record request comprises a plurality of accounting details; starting a transaction corresponding to the accounting data record request based on a programming transaction mode, and setting the isolation level of the transaction as read submitted; reading an initial value corresponding to the current accounting detail from an account residual value table and a first timestamp; processing corresponding accounting details based on the initial value in the transaction to obtain the final value; and when the first time stamp is successfully matched with the corresponding second time stamp in the account remaining value table, updating the initial period value in the account remaining value table based on the end-of-period value, and updating the time stamp corresponding to the initial period value in the account remaining value table.

In one embodiment, the processing of the corresponding accounting details based on the initial value in the transaction implemented when the processor executes the computer program to obtain the final value includes: acquiring a unified ordering rule corresponding to each transaction; based on the ordering rule, ordering the account details according to the account corresponding to the account details; and in the transaction, sequentially processing the ordered accounting details based on the initial value of the period to obtain the corresponding end value of the period.

In one embodiment, the processor when executing the computer program further performs the steps of: rollback transactions based on a programmed transaction mode when matching of the first timestamp and a corresponding second timestamp in the account remaining value table fails; judging whether the retry number reaches a preset value; and when the retry number does not reach the preset value, restarting the transaction corresponding to the accounting data record request based on the programming transaction mode until the retry number reaches the preset value or the transaction is submitted successfully.

In one embodiment, a method for rollback transactions based on a programmed transaction mode when a first timestamp and a corresponding second timestamp in an account remaining value table fail to match, the method comprising: acquiring an updated influence value returned by a database corresponding to the account residual numerical value table, wherein the updated influence value is used for identifying the updated data number of the account residual numerical value table; and rolling back the transaction based on the programming transaction mode when the update impact value is not the target value.

In one embodiment, after the processor starts the transaction corresponding to the accounting data record request based on the programming transaction mode when executing the computer program, the method further includes: acquiring preset transaction timeout time; when the first timestamp and the corresponding second timestamp in the account remaining value table are successfully matched, the processor is implemented when executing the computer program, and before updating the initial period value in the account remaining value table based on the end-of-period value, the processor further comprises: determining whether corresponding data in the account residual value table is being written or not based on the isolation level; when corresponding data in the account residual value table is being written, acquiring current waiting time; ending the transaction when the current waiting time exceeds the transaction timeout time; and when the corresponding data in the account residual value table is not being written, continuing to execute the step of updating the initial value in the account residual value table based on the end-of-period value when the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table.

In one embodiment, the processor when executing the computer program further performs the steps of: storing the multi-note account details in the account data record request into an account detail table; acquiring a grading parameter value in a parameter table; judging whether the corresponding accounting details need to be split or not based on the end-of-term value, the occurrence value and the grading parameter value; when the accounting details need to be split, splitting the accounting details based on the end-of-term value and the occurrence value to obtain split accounting details; and determining the transparent mark and the transparent type of the split account details and the non-split account details, and storing the split account details, the non-split account details, the corresponding transparent mark and the transparent type into the accounting list.

In one embodiment, the values of the step parameters in the acquisition parameter table implemented when the processor executes the computer program include: acquiring an account corresponding to the accounting details; the value of the step parameter corresponding to the account is obtained from the parameter table.

In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of: receiving an accounting data record request, wherein the accounting data record request comprises a plurality of accounting details; starting a transaction corresponding to the accounting data record request based on a programming transaction mode, and setting the isolation level of the transaction as read submitted; reading an initial value corresponding to the current accounting detail from an account residual value table and a first timestamp; processing corresponding accounting details based on the initial value in the transaction to obtain the final value; and when the first time stamp is successfully matched with the corresponding second time stamp in the account remaining value table, updating the initial period value in the account remaining value table based on the end-of-period value, and updating the time stamp corresponding to the initial period value in the account remaining value table.

In one embodiment, a computer program, when executed by a processor, processes corresponding accounting details in a transaction based on an initial value to obtain an end-of-term value, comprising: acquiring a unified ordering rule corresponding to each transaction; based on the ordering rule, ordering the account details according to the account corresponding to the account details; and in the transaction, sequentially processing the ordered accounting details based on the initial value of the period to obtain the corresponding end value of the period.

In one embodiment, the computer program when executed by the processor further performs the steps of: rollback transactions based on a programmed transaction mode when matching of the first timestamp and a corresponding second timestamp in the account remaining value table fails; judging whether the retry number reaches a preset value; and when the retry number does not reach the preset value, restarting the transaction corresponding to the accounting data record request based on the programming transaction mode until the retry number reaches the preset value or the transaction is submitted successfully.

In one embodiment, a method for rollback transactions based on a programmatic transaction mode when a first timestamp and a corresponding second timestamp in an account remaining value table fail to match, implemented when a computer program is executed by a processor, comprises: acquiring an updated influence value returned by a database corresponding to the account residual numerical value table, wherein the updated influence value is used for identifying the updated data number of the account residual numerical value table; and rolling back the transaction based on the programming transaction mode when the update impact value is not the target value.

In one embodiment, after the computer program is executed by the processor to open the transaction corresponding to the accounting data record request based on the programming transaction mode, the method further includes: acquiring preset transaction timeout time; when the computer program is executed by the processor and the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table, before updating the initial period value in the account residual value table based on the final period value, the computer program further comprises: determining whether corresponding data in the account residual value table is being written or not based on the isolation level; when corresponding data in the account residual value table is being written, acquiring current waiting time; ending the transaction when the current waiting time exceeds the transaction timeout time; and when the corresponding data in the account residual value table is not being written, continuing to execute the step of updating the initial value in the account residual value table based on the end-of-period value when the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table.

In one embodiment, the computer program when executed by the processor further performs the steps of: storing the multi-note account details in the account data record request into an account detail table; acquiring a grading parameter value in a parameter table; judging whether the corresponding accounting details need to be split or not based on the end-of-term value, the occurrence value and the grading parameter value; when the accounting details need to be split, splitting the accounting details based on the end-of-term value and the occurrence value to obtain split accounting details; and determining the transparent mark and the transparent type of the split account details and the non-split account details, and storing the split account details, the non-split account details, the corresponding transparent mark and the transparent type into the accounting list.

In one embodiment, the values of the step parameters in the acquisition parameter table implemented when the computer program is executed by the processor comprise: acquiring an account corresponding to the accounting details; the value of the step parameter corresponding to the account is obtained from the parameter table.

In one embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, performs the steps of: receiving an accounting data record request, wherein the accounting data record request comprises a plurality of accounting details; starting a transaction corresponding to the accounting data record request based on a programming transaction mode, and setting the isolation level of the transaction as read submitted; reading an initial value corresponding to the current accounting detail from an account residual value table and a first timestamp; processing corresponding accounting details based on the initial value in the transaction to obtain the final value; and when the first time stamp is successfully matched with the corresponding second time stamp in the account remaining value table, updating the initial period value in the account remaining value table based on the end-of-period value, and updating the time stamp corresponding to the initial period value in the account remaining value table.

In one embodiment, a computer program, when executed by a processor, processes corresponding accounting details in a transaction based on an initial value to obtain an end-of-term value, comprising: acquiring a unified ordering rule corresponding to each transaction; based on the ordering rule, ordering the account details according to the account corresponding to the account details; and in the transaction, sequentially processing the ordered accounting details based on the initial value of the period to obtain the corresponding end value of the period.

In one embodiment, the computer program when executed by the processor further performs the steps of: rollback transactions based on a programmed transaction mode when matching of the first timestamp and a corresponding second timestamp in the account remaining value table fails; judging whether the retry number reaches a preset value; and when the retry number does not reach the preset value, restarting the transaction corresponding to the accounting data record request based on the programming transaction mode until the retry number reaches the preset value or the transaction is submitted successfully.

In one embodiment, a method for rollback transactions based on a programmatic transaction mode when a first timestamp and a corresponding second timestamp in an account remaining value table fail to match, implemented when a computer program is executed by a processor, comprises: acquiring an updated influence value returned by a database corresponding to the account residual numerical value table, wherein the updated influence value is used for identifying the updated data number of the account residual numerical value table; and rolling back the transaction based on the programming transaction mode when the update impact value is not the target value.

In one embodiment, after the computer program is executed by the processor to open the transaction corresponding to the accounting data record request based on the programming transaction mode, the method further includes: acquiring preset transaction timeout time; when the computer program is executed by the processor and the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table, before updating the initial period value in the account residual value table based on the final period value, the computer program further comprises: determining whether corresponding data in the account residual value table is being written or not based on the isolation level; when corresponding data in the account residual value table is being written, acquiring current waiting time; ending the transaction when the current waiting time exceeds the transaction timeout time; and when the corresponding data in the account residual value table is not being written, continuing to execute the step of updating the initial value in the account residual value table based on the end-of-period value when the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table.

In one embodiment, the computer program when executed by the processor further performs the steps of: storing the multi-note account details in the account data record request into an account detail table; acquiring a grading parameter value in a parameter table; judging whether the corresponding accounting details need to be split or not based on the end-of-term value, the occurrence value and the grading parameter value; when the accounting details need to be split, splitting the accounting details based on the end-of-term value and the occurrence value to obtain split accounting details; and determining the transparent mark and the transparent type of the split account details and the non-split account details, and storing the split account details, the non-split account details, the corresponding transparent mark and the transparent type into the accounting list.

In one embodiment, the values of the step parameters in the acquisition parameter table implemented when the computer program is executed by the processor comprise: acquiring an account corresponding to the accounting details; the value of the step parameter corresponding to the account is obtained from the parameter table.

It should be noted that, the user information (including, but not limited to, user equipment information, user personal information, etc.) and the data (including, but not limited to, data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use, and processing of the related data are required to meet the related regulations.

Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.

The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.

The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.

Claims (11)

1. A method of processing accounting data, the method comprising:

receiving an accounting data record request, wherein the accounting data record request comprises a plurality of accounting details;

starting a transaction corresponding to the accounting data record request based on a programming transaction mode, and setting the isolation level of the transaction as read submitted;

reading an initial value and a first timestamp corresponding to the current accounting detail from an account remaining value table;

Processing the corresponding accounting details based on the initial value in the transaction to obtain an end-of-period value;

and when the first timestamp is successfully matched with a corresponding second timestamp in the account residual numerical value table, updating an initial value in the account residual numerical value table based on the end-of-period value, and updating a timestamp corresponding to the initial value in the account residual numerical value table.

2. The method of claim 1, wherein processing the corresponding accounting details in the transaction based on the initial value results in an end-of-period value, comprising:

acquiring a unified ordering rule corresponding to each transaction;

based on the sorting rule, sorting the accounting details according to accounts corresponding to the accounting details;

and in the transaction, sequentially processing the ordered accounting details based on the initial value of the period to obtain a corresponding end value of the period.

3. The method according to claim 1, wherein the method further comprises:

rollback the transaction based on a programmed transaction manner when the matching of the first timestamp and a corresponding second timestamp in the account remaining value table fails;

Judging whether the retry number reaches a preset value;

and when the retry number does not reach a preset value, restarting a transaction corresponding to the accounting data record request based on a programmed transaction mode until the retry number reaches the preset value or the transaction is submitted successfully.

4. The method of claim 3, wherein the rollback the transaction based on a programmed transaction manner upon failure of a corresponding second timestamp in the first timestamp and the account remaining values table to match, comprises:

acquiring an update influence value returned by a database corresponding to an account residual numerical value table, wherein the update influence value is used for identifying the updated data number of the account residual numerical value table;

and rolling back the transaction based on a programming transaction mode when the update impact value is not the target value.

5. The method of any one of claims 1 to 4, further comprising, after the opening of the transaction corresponding to the accounting data record request based on the programmed transaction manner:

acquiring preset transaction timeout time;

and when the first timestamp is successfully matched with a corresponding second timestamp in the account remaining numerical value table, updating the initial period numerical value in the account remaining numerical value table based on the end-of-period numerical value, and further comprising:

Determining whether corresponding data in the account remaining numerical table is being written or not based on the isolation level;

when corresponding data in the account residual value table is being written, acquiring current waiting time;

ending the transaction when the current waiting time exceeds the transaction timeout time;

and when the corresponding data in the account residual value table is not written, continuing to execute the step of updating the initial value in the account residual value table based on the end-of-period value when the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table.

6. The method according to any one of claims 1 to 4, further comprising:

storing a plurality of accounting details in the accounting data record request into an accounting detail table;

acquiring a grading parameter value in a parameter table;

judging whether the corresponding accounting details need to be split or not based on the end-of-term value, the occurrence value and the grading parameter value;

when the accounting details need to be split, splitting the accounting details based on the end-of-term value and the occurrence value to obtain split accounting details;

And determining the transparent mark and the transparent type of the split account details and the non-split account details, and storing the split account details, the non-split account details, the corresponding transparent mark and the transparent type into a accounting list.

7. The method of claim 6, wherein the obtaining the values of the step parameters in the parameter table comprises:

acquiring an account corresponding to the accounting details;

and acquiring a grading parameter value corresponding to the account from the parameter table.

8. An accounting data processing device, said device comprising:

the receiving module is used for receiving an accounting data recording request, wherein the accounting data recording request comprises a plurality of accounting details;

the transaction opening module is used for opening a transaction corresponding to the accounting data record request based on a programming transaction mode and setting the isolation level of the transaction as read submitted;

the reading module is used for reading the initial value and the first timestamp corresponding to the current accounting detail from the account remaining value table;

the numerical processing module is used for processing the corresponding accounting details based on the initial value in the transaction to obtain an end-of-period value;

And the updating module is used for updating the initial value in the account residual value table based on the end value of the period when the first timestamp is successfully matched with the corresponding second timestamp in the account residual value table, and updating the timestamp corresponding to the initial value in the account residual value table.

9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.

10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.

11. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.