CN114648402A - Method and device for processing account limit data and electronic equipment - Google Patents
Method and device for processing account limit data and electronic equipment Download PDFInfo
- Publication number
- CN114648402A CN114648402A CN202011494088.9A CN202011494088A CN114648402A CN 114648402 A CN114648402 A CN 114648402A CN 202011494088 A CN202011494088 A CN 202011494088A CN 114648402 A CN114648402 A CN 114648402A
- Authority
- CN
- China
- Prior art keywords
- batch
- account
- quota
- credit
- transaction
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a processing method, a device and electronic equipment of account quota data, which are executed by a transaction server, wherein account quota data corresponding to a plurality of quota batches are stored in a database server associated with the transaction server, and the method comprises the following steps: determining a credit lot associated with a transaction lot of the account transaction request; generating an account limit data operation request for corresponding account limit data according to the determined limit batch; and sending the account quota data operation request to a database server so that the database server modifies the corresponding account quota data. The method and the device can process the high-concurrency uninterrupted transaction request without suspending the service transaction, thereby ensuring the continuous transaction; in addition, by isolating the transaction and the credit from the batch dimension, accurate account credit data of each batch can be obtained, the requirement on data reliability of the financial industry is met, and an accurate data basis is provided for subsequent generation amount check and external bill provision.
Description
Technical Field
The present application relates to the technical field of financial services, and in particular, to a method and an apparatus for processing account amount data, and an electronic device.
Background
In the financial business scene, the deduction of the account amount is a core function point for real-time deduction transaction. Traditional banks or other financial institutions generally adopt a centralized database, update account dates and acquire account limits in a pessimistic lock mode, and in order to solve the problem of hot accounts under high concurrent transaction requests, a distributed account system is also adopted in the prior art to process real-time deduction transactions.
However, the distributed account system can solve the problem of hot accounts under highly concurrent transaction requests, but also brings new problems, and the account transaction needs to consider how to finish and account, the existing day-to-day and day-to-day end limit calculation scheme can only be applied to a centralized database and cannot be applied to the distributed account system, and some banks or financial institutions do not accept transactions or have overtime and refusal of transactions due to overlarge data volume.
Disclosure of Invention
The embodiment of the application provides a method and a device for processing account limit data and electronic equipment, so as to accurately calculate data such as a daily terminal limit of a distributed account system.
The embodiment of the application adopts the following technical scheme:
in a first aspect, an embodiment of the present application provides a method for processing account credit data, where the method is executed by a transaction server, and a database server associated with the transaction server stores account credit data corresponding to a plurality of credit batches, where the method includes:
determining a credit lot associated with a transaction lot of the account transaction request;
generating an account limit data operation request for corresponding account limit data according to the determined limit batch;
and sending the account quota data operation request to the database server so that the database server modifies the corresponding account quota data.
Optionally, each transaction batch and the quota batch respectively correspond to a predetermined time interval.
Optionally, the account credit data corresponding to each credit batch includes account batch credit and credit batch number, and is stored in the credit account summary table of the database server, and the determining the credit batch associated with the transaction batch of the account transaction request includes:
determining a quota batch number that is not less than the transaction batch number of the account transaction request;
the content of the account quota data operation request comprises the following contents: and according to the transaction content contained in the account transaction request, modifying the account batch credit corresponding to the credit batch number determined in the credit account summary table.
Optionally, if the credit batch numbers stored in the credit account summary table are all smaller than the transaction batch number, the content of the account credit data operation request includes:
and generating account credit data corresponding to a new credit batch in the credit account summary, wherein the transaction batch number is used as the credit batch number of the new credit batch, and the account batch credit of the new credit batch is determined by the account batch credit of the last credit batch in the credit account summary and the transaction content contained in the account transaction request.
Optionally, an account amount table and a batch ending amount table of the account are set in the database server,
the line account table stores the dynamic data of the current line batch and the dynamic data of the previous line batch, and the batch end-rate table records the static data of historical line batches;
and when the dynamic data of the previous quota batch meets a preset time condition, the dynamic data can be used as a group of static data of historical quota batches to be stored in the batch final quota table.
Optionally, the method further comprises:
if the account transaction request is not received within a certain preset time interval, generating an account amount data operation request at least comprising the following contents and sending the account amount data operation request to the database server:
replacing the quota batch number and the account batch quota in the dynamic data of the previous quota batch in the quota account table with the quota batch number and the account batch quota in the dynamic data of the current quota batch;
and replacing the quota batch number in the dynamic data of the current quota batch with a quota batch number corresponding to the current time.
Optionally, the determining a credit lot associated with the transaction lot of the account transaction request comprises:
comparing the transaction batch number of the account transaction request with the quota batch number in the dynamic data of the current quota batch;
if the transaction batch number is consistent with the quota batch number, taking the current quota batch as a related quota batch;
the content of the account quota data operation request at least comprises the following contents: and modifying the account batch credit in the dynamic data of the current credit batch according to the transaction content contained in the account transaction request.
Optionally, the determining a credit lot associated with the transaction lot of the account transaction request further comprises:
if the transaction batch number is smaller than the quota batch number, both the current quota batch and the previous quota batch are taken as the associated quota batch;
the content of the account quota data operation request at least comprises the following contents: and modifying the account batch credit in the dynamic data of the current credit batch and the account batch credit in the dynamic data of the previous credit batch according to the transaction content contained in the account transaction request.
Optionally, the determining a credit lot associated with the transaction lot of the account transaction request further comprises:
if the transaction batch number is larger than the quota batch number, both the current quota batch and the previous quota batch are used as the related quota batch;
the content of the account quota data operation request at least comprises the following contents:
replacing the quota batch number and the account batch quota in the dynamic data of the previous quota batch with the quota batch number and the account batch quota in the dynamic data of the current quota batch;
according to the transaction content contained in the account transaction request, modifying the account batch credit in the dynamic data of the current credit batch;
and replacing the quota batch number in the dynamic data of the current quota batch with the transaction batch number.
Optionally, a transaction flow meter is arranged in the database server and used for storing the content of the account amount data operation request;
the content of the account quota data operation request comprises the following contents: account number, transaction serial number, amount batch number, account batch amount adjustment number and account batch amount adjustment form.
Optionally, the account credit data stored in the database server may be used to check the amount of the occurrence and/or provide an external bill.
In a second aspect, an embodiment of the present application further provides a device for processing account credit data, which is applied to a transaction server, wherein the device is configured to implement any one of the foregoing methods.
In a third aspect, an embodiment of the present application further provides an electronic device, including:
a processor; and
a memory arranged to store computer executable instructions that, when executed, cause the processor to perform any of the methods described above.
In a fourth aspect, embodiments of the present application further provide a computer-readable storage medium storing one or more programs, which when executed by an electronic device including a plurality of application programs, cause the electronic device to perform any of the methods described above.
The embodiment of the application adopts at least one technical scheme which can achieve the following beneficial effects: the method for processing account credit data according to the embodiment of the application can be executed by a transaction server deployed independently, and a database server corresponding to the transaction server is also provided, wherein account credit data corresponding to a plurality of credit batches are stored as a basis for processing the account credit data. Before processing account quota data, the transaction server receives an account transaction request, and then can determine a quota batch related to the account transaction request in the database server according to a transaction batch of the account transaction request; then generating an account quota data operation request for corresponding account quota data according to the determined quota batch; and finally, sending the account limit data operation request to a database server so that the database server can adjust the corresponding account limit data according to the account limit data operation request. The method for processing the account credit data can process highly-concurrent uninterrupted transaction requests without suspending business transactions, and ensures continuous transactions; in addition, accurate quota data of each batch can be obtained by isolating the transaction and the quota from the batch dimension, the requirement on data reliability of the financial industry is met, and an accurate data basis is provided for subsequent functions of quota generation check, bill supply to the outside and the like.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:
fig. 1 is a schematic structural diagram of a distributed account system according to an embodiment of the present application;
FIG. 2 is a flowchart of a method for processing account quota data according to an embodiment of the present application;
FIG. 3 is a diagram illustrating an example of a numerical axis for adjusting account batch quota;
FIG. 4 is a schematic structural diagram of a device for processing account credit data according to an embodiment of the present disclosure;
fig. 5 is a schematic structural diagram of an electronic device in an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be described in detail and completely with reference to the following specific embodiments of the present application and the accompanying drawings. It should be apparent that the described embodiments are only some of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The technical solutions provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.
As shown in fig. 1, a schematic structural diagram of a distributed account system is provided, where the distributed account system includes a plurality of Data centers (Internet Data centers, abbreviated as IDCs) distributed in different areas, each Data Center has a unified Data access module and an account quota management module, and each account quota management module can manage one or more account quota databases. The distributed account system distributes the credit to a large number of account numbers which are scattered in different account credit databases, so that the transaction processing program can uniformly disperse the transaction on different account numbers, further adjust the account credit of the corresponding account number, and greatly improve the processing efficiency of transaction requests.
However, since the account credit data changes in real time and there is a time difference between different servers, in order to obtain accurate credit data in each service date or each time batch, it is necessary to dynamically adjust the account credit data in each service date or each time batch to ensure the accuracy and reliability of the data.
Based on this, the embodiment of the present application provides a method for processing account credit data, which is executed by a transaction server, wherein a database server associated with the transaction server stores account credit data corresponding to a plurality of credit batches, as shown in fig. 2, the method includes the following steps S210 to S230:
step S210, determine a quota batch associated with the transaction batch of the account transaction request.
The method for processing the account credit data can be executed by a single transaction server, the database server is corresponding to the transaction server, and the database server stores the account credit data corresponding to a plurality of credit batches, namely the account credit data to be processed by the method. Before processing account amount data, a transaction server receives an account transaction request of a user, wherein the account transaction request can be a batch of received high concurrent account transaction requests, a small amount of or single account transaction requests, a deduction request for a certain account, or a repayment request, and the specific type of the requested transaction can be flexibly set by a person skilled in the art according to actual conditions, which is not specifically limited herein.
In a specific implementation, the account transaction request usually carries a timestamp of the transaction request, that is, it can be understood as a server time for receiving the account transaction request, and the transaction lot of the account transaction request can be set according to a time interval in which the time is located, where a time period from a starting time point to an ending time point of each hour is taken as a time lot, for example, 9: 00 to 9: 59 are divided into 9 th lots, 10: 00 to 10: 59 are divided into 10 th lots … …, and assuming that the time for the server to receive an account transaction request is 11: 15, the transaction lot of the account transaction request can be denoted as 11 th lot. A business date transaction may be divided into 24 batches.
The nature of the credit batch is also a time interval, which can be understood as a credit batch determined according to the transaction batch of the account transaction request received in real time, for example, at the time of initialization, the time of receiving the first account transaction request is 9: 00, the corresponding transaction batch is 9 th, and at this time, the 9 th transaction data is considered to have been received successively, and the current credit batch is marked as 9 th. The method and the device have the advantages that the account quota data are subdivided into a plurality of time batches, so that accurate quota data of each time batch can be obtained in the following process. Of course, besides dividing the batches every hour as described above, those skilled in the art may also flexibly set other dividing manners according to actual requirements, and are not limited specifically herein.
Therefore, after obtaining the transaction batch in the account transaction request, the credit batch associated with the transaction batch can be determined. Here, "associate" may be understood as that the account transaction request carries transaction batches, the transaction batches may affect the credit batches requiring credit adjustment, and since the aforementioned database server stores account credit data corresponding to a plurality of credit batches, that is, the account credit data correspond to a plurality of credit batches, it may be determined which credit batches the account credit data of which credit batches are to be modified are considered as the batches associated with the transaction batches.
For example, each credit batch records the result of credit processing according to the corresponding transaction batch, so it is easy to understand that each time data processing of a new credit batch is started, the initial credit is the same as the final credit of the previous credit batch. However, because the server has a time difference, the credit lot of batch 12 may be reached, but the account transaction request of transaction batch of batch 11 is received, and at this time, the account batch credit of batch 11 needs to be adjusted, but not only, because the account batch credit of batch 12 is inherited from batch 11, the adjustment should also be inherited, that is, the account batch credit of batch 12 is also adjusted accordingly, and so on.
Step S220, according to the determined quota batch, generating an account quota data operation request for the corresponding account quota data.
After obtaining the credit batch associated with the transaction batch of the currently received account transaction request, an account credit data operation request for account credit data of the corresponding credit batch can be generated according to the determined credit batch. The account credit line data operation request can be understood as a request for adjusting the account credit line data of the associated credit line batches, and the determined associated credit line batches are different, and the corresponding adjustment modes may also be different.
Step S230, sending the account quota data operation request to the database server, so that the database server modifies the corresponding account quota data.
After the account limit data operation request is obtained, the account limit data operation request is sent to a database server to carry out processing such as adjustment of corresponding data, and the processed account limit data can meet the requirements of data accuracy and reliability of the financial business industry.
The method for processing the account credit data can process highly-concurrent uninterrupted transaction requests without suspending business transactions, and ensures continuous transactions; in addition, accurate quota data of each batch can be obtained by isolating the transaction and the quota from the batch dimension, the requirement on data reliability of the financial industry is met, and an accurate data basis is provided for subsequent functions of quota generation check, bill supply to the outside and the like.
In an embodiment of the present application, the account credit data corresponding to each credit batch includes account batch credit and credit batch number, which are stored in the credit account summary table of the database server, and the determining the credit batch associated with the transaction batch of the account transaction request includes: determining a quota batch number which is not less than the transaction batch number of the account transaction request; the content of the account quota data operation request comprises the following contents: and according to the transaction content contained in the account transaction request, modifying the account batch credit corresponding to the credit batch number determined in the credit account summary table.
The account amount data of the embodiment of the application can be managed by an amount account summary table in the database server in a unified manner, and the amount account summary table can comprise account amount data such as an amount batch number and a corresponding account batch amount. Then, as previously mentioned, if the account transaction request is generated at 11 o' clock 15, it corresponds to the transaction lot of lot 11, which necessarily affects the account lot quota of the quota lot of lot 11, and possibly also affects the account lot quota (if any) of lots 12, 13, … …. Then only the credit batch number of the transaction batch not less than the 11 th batch needs to be found in the credit account summary table, and the corresponding account batch credit is modified.
Of course, according to the foregoing analysis, due to the time difference between the servers, there may be a case where there is no corresponding quota batch number in the quota account summary, and it is necessary to create a quota batch, for example, in the following embodiment.
In an embodiment of the present application, if the credit lot numbers stored in the credit account summary table are all smaller than the transaction lot number, the content of the account credit data operation request includes: and generating account credit data corresponding to a new credit batch in the credit account summary, wherein the transaction batch number is used as the credit batch number of the new credit batch, and the account batch credit of the new credit batch is determined by the account batch credit of the last credit batch in the credit account summary and the transaction content contained in the account transaction request.
If the currently received transaction batch number is larger than the maximum value of the stored credit batch number in the credit account summary table, it indicates that the credit data of the transaction batch is not stored in the current credit account summary table, so the corresponding operation request of the credit data of the account can be the credit data corresponding to the new credit batch generated in the credit account summary table, the currently received transaction batch number is used as the credit batch number of the new credit batch, and the credit of the account batch of the last credit batch in the credit account summary table and the transaction content contained in the transaction request of the account determine the credit of the account batch of the new credit batch.
For example, if the maximum value of the stored credit lot number in the credit account summary is lot 11 and the received transaction lot number is lot 12, a 12 th credit lot may be created in the credit account summary, where the 12 th credit account may be determined according to the 11 th credit account and the credit adjustment amount in the currently received account transaction request.
In an embodiment of the application, an account amount account table and a batch final amount table of an account are set in the database server, dynamic data of a current amount batch and dynamic data of a previous amount batch are stored in the account amount table, and static data of a historical amount batch is recorded in the batch final amount table; and when the dynamic data of the previous quota batch meets a preset time condition, the dynamic data can be used as a group of static data of historical quota batches to be stored in the batch final quota table.
Different from the above embodiments, the account amount data stored in the database server of the embodiment of the present application may also be managed by a plurality of data tables with different functions, for example, the data tables may include an amount account table and a batch end amount table, as shown in tables 1 and 2 below. The quota account table of table 1 is mainly used for recording dynamic data of a current quota batch and a previous quota batch, including account numbers, account batch quota of the current quota batch and the previous quota batch, and the batch terminal quota table of table 2 is mainly used for recording static data of each quota batch, including account numbers and final quota data of each quota batch. The advantage of this is that only the credit account table needs to be modified according to each transaction, and the batch end credit table can be modified periodically without frequent access, thus ensuring data stability.
The time difference of the server is usually not more than 5 seconds, so in order to obtain accurate batch final limit data, the last batch limit in the limit account table can be saved into the batch final limit table at 30 th minute of each hour, and the batch limit of the limit batch is considered to be basically unchanged. Of course, the specific selection of which time node synchronizes the previous batch of quota data in the quota account table to the batch terminal quota table can be flexibly set by a person skilled in the art according to the actual situation, and is not specifically limited herein.
TABLE 1
TABLE 2
In one embodiment of the present application, the method further comprises: if the account transaction request is not received within a certain preset time interval, generating an account amount data operation request at least comprising the following contents and sending the account amount data operation request to the database server: replacing the quota batch number and the account batch quota in the dynamic data of the previous quota batch in the quota account table with the quota batch number and the account batch quota in the dynamic data of the current quota batch; and replacing the quota batch number in the dynamic data of the current quota batch with a quota batch number corresponding to the current time.
In an actual financial transaction scenario, if no account transaction request is received within a time batch, an operation request for batch switching between the dynamic data of the current credit batch and the dynamic data of the previous credit batch in the credit account table may be generated and sent to the database server for processing. For example, the current quota batch is the 11 th batch, and no new account transaction request is received within the time interval from the 11 th batch to the 11 th 59 th batch corresponding to the quota batch, at this time, the database server may be notified to switch the current quota batch from the original 11 th batch to the 12 th batch, and the previous quota batch from the original 10 th batch to the 11 th batch, so that batch switching may be automatically completed to facilitate processing of subsequent batches of data.
In one embodiment of the present application, the determining a credit lot associated with the transaction lot of the account transaction request comprises: comparing the transaction batch number of the account transaction request with the quota batch number in the dynamic data of the current quota batch; if the transaction batch number is consistent with the quota batch number, taking the current quota batch as a related quota batch; the content of the account quota data operation request at least comprises the following contents: and modifying the account batch credit in the dynamic data of the current credit batch according to the transaction content contained in the account transaction request.
As mentioned above, the dynamic data of the current credit batch and the dynamic data of the previous credit batch are stored in the credit account table, after a new account transaction request is received, the transaction batch number of the account transaction request can be compared with the credit batch number in the dynamic data of the current credit batch to determine the associated credit batch, if the transaction batch number is equal to the determined credit batch number, it indicates that the received account transaction request is a request for adjusting the account credit data of the current credit batch, and the account batch credit in the dynamic data of the current credit batch can be adjusted directly according to the transaction content, such as the adjusted credit, included in the account transaction request.
For example, if an account transaction request x1 is currently received, the corresponding transaction lot number is lot 12, and a request for deduction is made 1000, the current quota lot number is also lot 12, and the corresponding account quota is 10000, the 12 th account quota can be deducted by the database server, and the account quota with quota lot 12 is 10000-.
In one embodiment of the present application, the determining a credit lot associated with the transaction lot of the account transaction request further comprises: if the transaction batch number is smaller than the quota batch number, both the current quota batch and the previous quota batch are taken as the related quota batch; the content of the account quota data operation request at least comprises the following contents: and according to the transaction content contained in the account transaction request, modifying the account batch credit in the dynamic data of the current credit batch and the account batch credit in the dynamic data of the previous credit batch.
If the transaction batch number is smaller than the quota batch number, it indicates that the quota data of the previous quota batch of the current quota batch is not completely processed due to the time difference of the server, the account quota data of the previous quota batch needs to be adjusted, and since the quota data of the current quota batch is related to the quota data of the previous quota batch and changes along with the change of the quota data of the previous quota batch, the account data of the current quota batch is also adjusted if the transaction batch number is smaller than the quota batch number. The specific adjustment method may be to simultaneously adjust the account batch credit in the dynamic data of the current credit batch and the previous credit batch according to the transaction content, such as the adjustment credit, included in the account transaction request.
For example, based on the above embodiment, if an account transaction request x2 is received at present, the corresponding transaction lot number is lot 11, the request deduction 2000 is made, the current credit lot number is lot 12, the corresponding account credit is 9000, the previous credit lot number is lot 11, and the corresponding account credit is 10000, the 12 th and 11 th account credits may be respectively deducted by the database server, so as to obtain the account credit of lot 12 of 9000-2000-7000, and the account credit of lot 11 of 10000-2000-8000.
To facilitate understanding of the above embodiments, a log graph is provided that adjusts account batch credits, as shown in FIG. 3. Specifically, the transaction of a business date can be divided into 24 batches, if the current credit batch number is batch 12, then only the 12 th batch of account credit needs to be adjusted for the received account transaction request of batch 12, and for the received account transaction request of batch 11, the 11 th and 12 th batches of account credit need to be adjusted.
In one embodiment of the present application, the determining a credit lot associated with the transaction lot of the account transaction request further comprises: if the transaction batch number is larger than the quota batch number, both the current quota batch and the previous quota batch are used as the related quota batch; the content of the account quota data operation request at least comprises the following contents: replacing the quota batch number and the account batch quota in the dynamic data of the previous quota batch with the quota batch number and the account batch quota in the dynamic data of the current quota batch; according to the transaction content contained in the account transaction request, modifying the account batch credit in the dynamic data of the current credit batch; and replacing the quota batch number in the dynamic data of the current quota batch with the transaction batch number.
If the transaction batch number is larger than the limit batch number, the account limit data of the transaction batch number is not stored in the limit account table, at this time, the limit batch number and the account batch limit of the current limit batch can be switched to the limit batch number and the account batch limit of the previous limit batch, and then the account batch limit of the current limit batch is determined according to the account batch limit of the previous limit batch and the transaction content in the currently received account transaction request, such as the adjustment limit and the like.
For example, the transaction lot number is batch 12, the request deduction is 2000, the credit lot number is batch 11, and the corresponding account credit is 7000, at this time, the current credit lot in the credit account table may be switched from batch 11 to batch 12, the previous credit lot may be switched from batch 10 to batch 11, and the corresponding account credit is 7000, and then according to the account credit of batch 11 and the transaction content in the currently received account transaction request, such as the adjustment credit, the account credit of batch 12 may be 7000-2000 ═ 5000.
It should be noted that, in an actual application scenario, the Time difference between the servers is checked through a clock server (NTP for short), if the Time difference exceeds a preset Time difference, for example, 5 seconds, an alarm is given, the server with the larger Time difference is removed, and it is further ensured that the Time difference of the server related to the technical scheme of the present application does not exceed 5 seconds.
The server-based time difference is short, so that only the credit data of adjacent credit batches are affected generally, and the situation of cross-credit batches is almost impossible, namely, if account transaction requests after 12 points are received at present, the account transaction requests after 10 points are unlikely to be received.
In an embodiment of the application, a transaction flow meter is arranged in the database server and used for storing the content of the account amount data operation request; the content of the account quota data operation request comprises the following contents: account number of account, transaction serial number, amount batch number, account batch amount adjustment form.
In addition to the credit account table and the batch end credit table, the database server of the embodiment of the present application may also store a transaction flow meter for recording transaction flow information, as shown in table 3 below, the transaction flow meter may specifically include information such as an account number, a transaction flow number, a credit batch number, an adjustment credit, and an adjustment type, and the transaction flow information may be obtained from the received account transaction request.
TABLE 3
In one embodiment of the present application, the account amount data stored in the database server may be used to check the amount of the occurrence and/or provide an external bill.
Through the processing flow of the account limit data of each embodiment, accurate and reliable account limit data of each batch can be finally obtained, and on the basis, the final limit (batch final limit) of a certain batch can be selected as the final limit (daily final limit) of a service date according to actual service requirements, so that daily cutting of the distributed account system is realized. For example, if the batch quota of 22 on day 1/9 is set as the daily quota of 1/9, the quota data after 22 on day 1/9 will be set as the quota data on day 2/9 on the next business date.
In an actual business scenario, the account amount data of each batch obtained in the above embodiment may also be used for checking the generated amount and providing a bill to the outside. The amount of the transaction can be understood as the sum of all the transactions of a certain service in the debit or credit in a certain period, in the embodiment of the present application, all the transactions of the same batch can be summarized and differentiated, and compared with the batch end limit of each account and the difference between the two batches, so as to check whether the amount of the transaction of each batch is accurate. In addition, transaction flow details can be provided according to the dimensions of the batches, and the sum of the terminal quota of all account batches of the corresponding batches is provided for the requesting party, so that different business requirements of the requesting party are met.
It should be noted that the numbering rules of the lot numbers mentioned in the above embodiments are only simplified for convenience of description, and in an actual application scenario, more complex numbering rules may be set according to different business requirements, for example, if an account transaction request is received 10 am on 1 st 10 am in 2020, the transaction lot number may be numbered 202009010010, where the last two digits may be represented as a transaction lot of 10 th lot. Specifically, the skilled person can flexibly select the setting according to the actual requirement, as long as each transaction batch or quota batch of each service date can be distinguished.
The embodiment of the present application further provides an apparatus 400 for processing account credit data, which is applied to a transaction server, wherein a database server associated with the transaction server stores account credit data corresponding to a plurality of credit batches, as shown in fig. 4, the apparatus 400 includes:
a determining unit 410 for determining a credit lot associated with a transaction lot of the account transaction request;
a generating unit 420, configured to generate an account quota data operation request for corresponding account quota data according to the determined quota batch;
the sending unit 430 is configured to send the account quota data operation request to the database server, so that the database server modifies the corresponding account quota data.
Fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present application. Referring to fig. 5, at a hardware level, the electronic device includes a processor, and optionally further includes an internal bus, a network interface, and a memory. The Memory may include a Memory, such as a Random-Access Memory (RAM), and may further include a non-volatile Memory, such as at least 1 disk Memory. Of course, the electronic device may also include hardware required for other services.
The processor, the network interface, and the memory may be connected to each other via an internal bus, which may be an ISA (Industry Standard Architecture) bus, a PCI (Peripheral Component Interconnect) bus, an EISA (Extended Industry Standard Architecture) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one double-headed arrow is shown in FIG. 5, but this does not indicate only one bus or one type of bus.
And the memory is used for storing programs. In particular, the program may include program code comprising computer operating instructions. The memory may include both memory and non-volatile storage and provides instructions and data to the processor.
The processor reads the corresponding computer program from the nonvolatile memory to the memory and then runs the computer program to form the processing device of the account quota data on the logic level. The processor is used for executing the program stored in the memory and is specifically used for executing the following operations:
determining a credit lot associated with a transaction lot of the account transaction request;
generating an account limit data operation request for corresponding account limit data according to the determined limit batch;
and sending the account quota data operation request to the database server so that the database server modifies the corresponding account quota data.
The method executed by the processing device of the account credit data disclosed in the embodiment of fig. 4 of the present application can be applied to or implemented by a processor. The processor may be an integrated circuit chip having signal processing capabilities. In implementation, the steps of the above method may be performed by integrated logic circuits of hardware in a processor or instructions in the form of software. The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but also Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components. The various methods, steps, and logic blocks disclosed in the embodiments of the present application may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in connection with the embodiments of the present application may be directly implemented by a hardware decoding processor, or implemented by a combination of hardware and software modules in the decoding processor. The software module may be located in ram, flash memory, rom, prom, or eprom, registers, etc. storage media as is well known in the art. The storage medium is located in a memory, and a processor reads information in the memory and combines hardware thereof to complete the steps of the method.
The electronic device may further execute the method executed by the processing device of the account credit data in fig. 4, and implement the function of the processing device of the account credit data in the embodiment shown in fig. 4, which is not described herein again in this embodiment of the present application.
An embodiment of the present application further provides a computer-readable storage medium, where the computer-readable storage medium stores one or more programs, where the one or more programs include instructions, and when the instructions are executed by an electronic device including multiple application programs, the instructions can cause the electronic device to perform a method performed by a processing apparatus of account quota data in the embodiment shown in fig. 4, and are specifically configured to perform:
determining a credit lot associated with a transaction lot of the account transaction request;
generating an account limit data operation request for corresponding account limit data according to the determined limit batch;
and sending the account quota data operation request to the database server so that the database server modifies the corresponding account quota data.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention has been described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (14)
1. A processing method of account quota data is executed by a transaction server, wherein account quota data corresponding to a plurality of quota batches are stored in a database server associated with the transaction server, and the method comprises the following steps:
determining a credit lot associated with a transaction lot of the account transaction request;
generating an account limit data operation request for corresponding account limit data according to the determined limit batch;
and sending the account quota data operation request to the database server so that the database server modifies the corresponding account quota data.
2. The method of claim 1, wherein each of the transaction batch and the credit batch respectively corresponds to a predetermined time interval.
3. The method of claim 2, wherein the account credit data for each credit batch includes account batch credits and credit batch numbers stored in a credit account summary table of the database server, the determining the credit batch associated with the transaction batch of the account transaction request including:
determining a quota batch number that is not less than the transaction batch number of the account transaction request;
the content of the account quota data operation request comprises the following contents: and according to the transaction content contained in the account transaction request, modifying the account batch credit corresponding to the credit batch number determined in the credit account summary table.
4. The method as described in claim 3, wherein if the credit lot numbers stored in the credit account summary table are all smaller than the transaction lot number, the content of the account credit data operation request includes:
and generating account credit data corresponding to a new credit batch in the credit account summary, wherein the transaction batch number is used as the credit batch number of the new credit batch, and the account batch credit of the new credit batch is determined according to the account batch credit of the latest credit batch in the credit account summary and the transaction content contained in the account transaction request.
5. The method of claim 2, wherein an account amount table and a batch end amount table of the account are set in the database server,
the line account table stores the dynamic data of the current line batch and the dynamic data of the previous line batch, and the batch end-rate table records the static data of historical line batches;
and when the dynamic data of the previous quota batch meets a preset time condition, the dynamic data can be used as a group of static data of historical quota batches to be stored in the batch final quota table.
6. The method of claim 5, wherein the method further comprises:
if the account transaction request is not received within a certain preset time interval, generating an account amount data operation request at least comprising the following contents and sending the account amount data operation request to the database server:
replacing the quota batch number and the account batch quota in the dynamic data of the previous quota batch in the quota account table with the quota batch number and the account batch quota in the dynamic data of the current quota batch;
and replacing the quota batch number in the dynamic data of the current quota batch with a quota batch number corresponding to the current time.
7. The method of claim 5, wherein the determining a credit lot associated with the transaction lot of the account transaction request comprises:
comparing the transaction batch number of the account transaction request with the quota batch number in the dynamic data of the current quota batch;
if the transaction batch number is consistent with the quota batch number, taking the current quota batch as a related quota batch;
the content of the account quota data operation request at least comprises the following contents: and modifying the account batch credit in the dynamic data of the current credit batch according to the transaction content contained in the account transaction request.
8. The method of claim 5, wherein the determining a credit lot associated with the transaction lot of the account transaction request further comprises:
if the transaction batch number is smaller than the quota batch number, both the current quota batch and the previous quota batch are taken as the associated quota batch;
the content of the account quota data operation request at least comprises the following contents: and modifying the account batch credit in the dynamic data of the current credit batch and the account batch credit in the dynamic data of the previous credit batch according to the transaction content contained in the account transaction request.
9. The method of claim 5, wherein the determining a credit lot associated with the transaction lot of the account transaction request further comprises:
if the transaction batch number is larger than the quota batch number, both the current quota batch and the previous quota batch are used as the related quota batch;
the content of the account quota data operation request at least comprises the following contents:
replacing the quota batch number and the account batch quota in the dynamic data of the previous quota batch with the quota batch number and the account batch quota in the dynamic data of the current quota batch;
according to the transaction content contained in the account transaction request, modifying the account batch credit in the dynamic data of the current credit batch;
and replacing the quota batch number in the dynamic data of the current quota batch with the transaction batch number.
10. The method as claimed in claim 1, wherein a transaction flow meter is arranged in the database server and used for storing the content of the account credit data operation request;
the content of the account quota data operation request comprises the following contents: account number, transaction serial number, amount batch number, account batch amount adjustment number and account batch amount adjustment form.
11. The method as claimed in claim 1, wherein the data of account amount stored in the database server can be used for checking the amount of occurrence and/or providing an external bill.
12. An account data processing device applied to a transaction server, wherein a database server associated with the transaction server stores account data corresponding to a plurality of credit batches, the device is used for realizing the method of any claim 1 to 11.
13. An electronic device, comprising:
a processor; and
a memory arranged to store computer executable instructions which, when executed, cause the processor to perform the method of any of claims 1 to 11.
14. A computer readable storage medium storing one or more programs which, when executed by an electronic device comprising a plurality of application programs, cause the electronic device to perform the method of any of claims 1-11.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011494088.9A CN114648402A (en) | 2020-12-17 | 2020-12-17 | Method and device for processing account limit data and electronic equipment |
| PCT/CN2021/136572 WO2022127675A1 (en) | 2020-12-17 | 2021-12-08 | Account limit data processing method and apparatus, and electronic device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011494088.9A CN114648402A (en) | 2020-12-17 | 2020-12-17 | Method and device for processing account limit data and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114648402A true CN114648402A (en) | 2022-06-21 |
Family
ID=81990809
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011494088.9A Pending CN114648402A (en) | 2020-12-17 | 2020-12-17 | Method and device for processing account limit data and electronic equipment |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN114648402A (en) |
| WO (1) | WO2022127675A1 (en) |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080021831A1 (en) * | 2006-07-19 | 2008-01-24 | Andrew Blaikie | Methods of processing a check in a payee positive pay system |
| CN109166045A (en) * | 2018-10-19 | 2019-01-08 | 中国银行股份有限公司 | A kind of transaction processing method, device and electronic equipment |
| US11200607B2 (en) * | 2019-01-28 | 2021-12-14 | Walmart Apollo, Llc | Methods and apparatus for anomaly detections |
| CN111507699A (en) * | 2020-04-03 | 2020-08-07 | 浙江省新华书店集团信息技术有限公司 | Supplier platform payment system |
| CN112053241A (en) * | 2020-08-27 | 2020-12-08 | 中信银行股份有限公司 | Transaction clearing method and device, electronic equipment and computer-readable storage medium |
-
2020
- 2020-12-17 CN CN202011494088.9A patent/CN114648402A/en active Pending
-
2021
- 2021-12-08 WO PCT/CN2021/136572 patent/WO2022127675A1/en active Application Filing
Also Published As
| Publication number | Publication date |
|---|---|
| WO2022127675A1 (en) | 2022-06-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111091358B (en) | Unified processing method and system for multiple payment channels | |
| CN110297837B (en) | Data updating method and device and data query method and device | |
| CN110060139B (en) | Accounting processing method and device | |
| WO2019047540A1 (en) | Transaction data processing method and apparatus, storage medium, and computer device | |
| CN108171488B (en) | Data processing method, device and system | |
| CN110688134A (en) | Method and device for gray scale publishing | |
| CN110489418B (en) | Data aggregation method and system | |
| CN111651522B (en) | Data synchronization method and device | |
| CN113194339A (en) | Live list generation method and device, electronic equipment and readable storage medium | |
| CN111400283B (en) | Data processing method, system, electronic equipment and storage medium | |
| CN107194712B (en) | Method and device for recording change information of shared account and method and system for supplementing account of internal account | |
| CN114648402A (en) | Method and device for processing account limit data and electronic equipment | |
| CN113076340B (en) | Account data processing method and device, electronic equipment and storage medium | |
| CN113672660B (en) | Data query method, device and equipment | |
| CN109615465B (en) | Service order processing method and device and electronic equipment | |
| CN114429346A (en) | Transaction flow data processing method and device and data processing system server | |
| CN110930013A (en) | Data processing method, device, server and storage medium | |
| CN113971007B (en) | Information processing method, device, electronic equipment and medium | |
| CN111402018A (en) | Method and system for reporting resource budget | |
| CN114648407A (en) | Method and device for cash-out transaction, electronic equipment and storage medium | |
| CN113807923B (en) | Order processing method and device, electronic equipment and readable storage medium | |
| CN115965480A (en) | Distributed account checking method, device and system | |
| CN115907974A (en) | Tracing charging method, device, system, electronic equipment and storage medium | |
| CN118277462A (en) | Account checking file generation method and device, electronic equipment and storage medium | |
| CN117591287A (en) | Interface memory resource allocation method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |