CN111882427A - Loan system data processing method, loan system data processing device, loan system data processing equipment and loan system data processing storage medium - Google Patents
Loan system data processing method, loan system data processing device, loan system data processing equipment and loan system data processing storage medium Download PDFInfo
- Publication number
- CN111882427A CN111882427A CN202010731301.7A CN202010731301A CN111882427A CN 111882427 A CN111882427 A CN 111882427A CN 202010731301 A CN202010731301 A CN 202010731301A CN 111882427 A CN111882427 A CN 111882427A
- Authority
- CN
- China
- Prior art keywords
- account
- batch
- data
- loan system
- interest
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 31
- 238000003860 storage Methods 0.000 title claims abstract description 25
- 238000004140 cleaning Methods 0.000 claims description 29
- 239000004594 Masterbatch (MB) Substances 0.000 claims description 12
- 230000010365 information processing Effects 0.000 claims description 12
- 238000005096 rolling process Methods 0.000 claims description 8
- 238000004590 computer program Methods 0.000 claims description 3
- 238000000151 deposition Methods 0.000 claims description 3
- 238000004364 calculation method Methods 0.000 abstract description 25
- 238000000034 method Methods 0.000 abstract description 12
- 238000000926 separation method Methods 0.000 abstract description 6
- 238000005520 cutting process Methods 0.000 description 14
- 238000010586 diagram Methods 0.000 description 5
- 238000007781 pre-processing Methods 0.000 description 5
- 230000000694 effects Effects 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
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/03—Credit; Loans; Processing thereof
-
- 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/23—Updating
- G06F16/2372—Updates performed during offline database operations
-
- 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/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
- G06F16/2386—Bulk updating operations
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- General Business, Economics & Management (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a loan system data processing method, device, equipment and storage medium. The method comprises the following steps: when the pre-batching condition is met, acquiring first account data of each historical account in the loan system, performing pre-batching interest-calculating processing on each historical account according to each first account data, and storing each pre-batching interest-calculating processing result in a temporary file; and when the main batch condition is met, acquiring second account data of each current account in the loan system, and updating the account data of each current account in the loan system by combining the pre-batch account processing result, wherein the current account comprises the historical account and the newly added account. According to the invention, through the division of the pre-batch and the main batch, batch processing errors can be exposed in advance during the pre-batch period, dirty data are prevented from being directly stored in a warehouse, the risk of the system is reduced, account batch calculation can be carried out in an online state of the system, the separation of calculation and storage is realized, the system calculation pressure during the previous batch processing period is shared, and the data updating speed is improved.
Description
Technical Field
The embodiment of the invention relates to a data processing technology, in particular to a loan system data processing method, a loan system data processing device, loan system data processing equipment and a loan system data processing storage medium.
Background
In the bank loan system, the activity period of the loan account varies from several days to several years, and can reach several decades at the longest. The transactions of most accounts occurring during the activity period can be divided into two types, one type is account transactions which need online processing and have higher timeliness requirements and are random in time, such as opening an account, paying for money, repayment and the like; the other is batch operation with low requirement on timeliness, such as interest bearing, overdue account processing, interest rate adjustment and the like.
Different from other application systems, the financial application system has higher requirements on the accuracy and the safety of data and lower tolerance to abnormity, so that the prior bank loan system puts all batch jobs with low timeliness requirements on daily processing. With the increasing frequency of financial activities of customers, transaction data is more and more, and the risk degree of the system is higher. Meanwhile, the loan system has small transaction amount in an online mode and low demand on computing resources, but the cost of the computing resources required by a batch mode is high, batch processing is carried out at the end of the day, and the cost of the computing resources required is high, so that the hardware cost of the loan system is high but the utilization rate is low.
Disclosure of Invention
The invention provides a loan system data processing method, a loan system data processing device, loan system data processing equipment and a loan system data processing storage medium, which are used for relieving the calculation pressure during batch processing of the current bank loan system, improving the updating speed of system data, reducing the system risk and enhancing the system safety.
In a first aspect, an embodiment of the present invention provides a loan system data processing method, including:
when the pre-batching condition is met, acquiring first account data of each historical account in the loan system, performing pre-batching interest-calculating processing on each historical account according to each first account data, and storing each pre-batching interest-calculating processing result in a temporary file;
and when the main batch condition is met, acquiring second account data of each current account in the loan system, and updating the account data of each current account in the loan system by combining the pre-batch account processing result, wherein the current account comprises the historical account and the newly added account.
In a second aspect, an embodiment of the present invention further provides a loan system data processing apparatus, including:
the system comprises a pre-batching module, a temporary file and a data processing module, wherein the pre-batching module is used for acquiring first account data of each historical account in a loan system when a pre-batching condition is met, performing pre-batching interest-calculating processing on each historical account according to each first account data and storing each pre-batching interest-calculating processing result in the temporary file;
and the master batch processing module is used for acquiring second account data of each current account in the loan system when a master batch condition is met, and updating the account data of each current account in the loan system by combining the pre-batch account processing result, wherein the current account comprises the historical account and the newly added account.
In a third aspect, an embodiment of the present invention further provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor executes the computer program to implement the loan system data processing method according to any embodiment of the present invention.
In a fourth aspect, embodiments of the present invention also provide a storage medium containing computer-executable instructions, which when executed by a computer processor, are configured to perform a loan system data processing method according to any of the embodiments of the present invention.
The invention carries out pre-batch interest-calculating processing on each historical account in the loan system according to each first account data by dividing the pre-batch stage and the main batch stage during the pre-batch, stores each pre-batch interest-calculating processing result in a temporary file, and updates the interest-calculating data of each current account in the loan system according to the second account data of each current account in the loan system and combining the pre-batch interest-calculating processing result during the main batch, through the division of the pre-batch stage and the main batch stage, the invention can lead batch processing errors to be exposed in advance during the pre-batch period, avoid direct storage of dirty data, reduce system risks, and carry out account batch calculation under the online state of the system, solve the problems of higher system risk degree, large expense of required calculation resources, high hardware cost and low utilization rate caused by centralized batch processing time, realize the separation of calculation and storage, and share the system calculation pressure during the previous batch processing period, the data updating speed is improved.
Drawings
Fig. 1 is a flow chart of a data processing method of a loan system according to an embodiment of the invention;
fig. 2 is a flowchart of a data processing method of a loan system according to a second embodiment of the invention;
FIG. 3 is a diagram illustrating the data states of the stages of the data processing method of the loan system according to the second embodiment of the invention;
fig. 4 is a block diagram of a data processing apparatus of a loan system according to a third embodiment of the invention;
fig. 5 is a block diagram of a computer device according to a fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be noted that, for convenience of description, only a part of the structures related to the present invention, not all of the structures, are shown in the drawings, and furthermore, embodiments of the present invention and features of the embodiments may be combined with each other without conflict.
Example one
Fig. 1 is a flowchart of a loan system data processing method according to an embodiment of the present invention, where the present embodiment is applicable to a bank loan system for batch processing of account charges, and the method may be executed by a loan system data processing apparatus, and the apparatus may be implemented by software and/or hardware.
As shown in fig. 1, the method specifically includes the following steps:
and step 110, when the pre-batching condition is met, acquiring first account data of each historical account in the loan system, performing pre-batching interest-calculating processing on each historical account according to each first account data, and storing each pre-batching interest-calculating processing result in a temporary file.
The pre-batch condition may be understood as a precondition for allowing the pre-batch operation to be entered, and may include a preset condition of a system state and a preset condition of an account state. Historical account may be understood as the account information stored in the loan system at the point of the system's batch processing. The first account data may be understood as parameter data in the historical account, such as an account number, various transaction data of the account, stage identifications and operation identifications of the account, and the like. The pre-batch interest processing can be understood as the conventional operations of interest improvement, overdue account processing, interest rate adjustment and the like on the historical account, and correspondingly, the pre-batch interest processing result can be understood as the operation result of pre-batch interest processing on the historical account. A temporary file may be understood as a storage space for temporarily storing data.
Specifically, the account information stored when the loan system is about to perform batch processing may be determined as a historical account, for example, 5/12/9: 00, the loan system receives the batch indication, then 5/12/2019 may be earlier by 9: the current account information in the 00 loan system determines the historical account. The loan system data processing apparatus needs to determine whether the system satisfies predetermined pre-approval conditions, such as whether the system is online, whether the status of each account in the system is normal, and the like. When the pre-batching condition is met, the loan system data processing device can perform pre-batching interest-counting processing on each historical account according to the related parameters in the acquired first account data, and after the pre-batching interest-counting processing is completed, the pre-batching interest-counting processing results are stored in a temporary file and are not written into a loan system database.
And step 120, when the main batch condition is met, acquiring second account data of each current account in the loan system, and updating the interest data of each current account in the loan system by combining the pre-batch interest processing result.
The master batch conditions can be understood as preconditions for allowing the master batch operation to enter, and can include preset conditions of system states and preset conditions of account states. The current account may be understood as account information stored in the loan system at the current time, and may include historical accounts and newly added accounts. The second account data may be understood as parameter data in the current account, such as an account number, various transaction data of the account, stage identifications and operation identifications of the account, and the like. The interest data may be understood as operational data generated after batch processing of the account in the loan system.
Specifically, the loan system data processing apparatus needs to determine whether the system satisfies a predetermined primary condition, for example, whether the system is in a stand-alone state, whether the status of each account in the system can enter a primary stage, and the like. When the pre-batching condition is met, the loan system data processing device can determine the interest data of each current account according to the related parameters in the acquired second account data. For example, the loan system data processing apparatus acquires second account data of each current account, and determines whether transaction data is written into the current account during the whole batch processing period according to related parameter information in the second account data, that is, whether a transaction has occurred to the current account during the current time from the time when a historical account is determined, if not, the interest data of the current account may be directly updated by using a corresponding pre-batch information processing result, and if a transaction has occurred or the current account is a newly added account, the interest data of the current account may be updated after the interest processing is performed again to the current account.
The embodiment of the invention carries out pre-batch interest-calculating processing on each historical account in the loan system according to each first account data during pre-batch by dividing the pre-batch stage and the main batch stage, stores each pre-batch interest-calculating processing result in a temporary file, and updates the interest-calculating data of each current account in the loan system according to each current account data in the loan system and the pre-batch interest-calculating processing result during main batch by combining the pre-batch interest-calculating processing result with the pre-batch and main batch dividing, thereby the invention can lead batch processing errors to be exposed in advance during the pre-batch period, avoid dirty data to be directly warehoused, reduce the online risk of the system, and can carry out batch account calculation in the system state, solve the problems of higher system risk degree, large expense of required calculation resources, high hardware cost and low utilization rate caused by centralized batch processing time, realize the separation of calculation and storage, and share the system calculation pressure during the previous batch processing period, the data updating speed is improved.
Example two
Fig. 2 is a flowchart of a data processing method of a loan system according to a second embodiment of the invention. The present embodiment further optimizes the loan system data processing method based on the above embodiments.
As shown in fig. 2, the method specifically includes:
The batch processing instruction may be instruction information for instructing the system to perform batch processing operation, and may be instruction information sent by a user, or instruction information triggered after a preset batch processing time is reached. The system state of the loan system can be divided into an online state and a stand-alone state, account transactions with higher timeliness requirements and random time, such as account opening, payment and repayment, can be carried out in the online state, and the system database can be updated in the stand-alone state.
Specifically, after the loan system data processing apparatus receives the batch processing instruction, the system state at the current time may be obtained, and it is determined whether the current system state of the loan system is an online state, if so, step 210 is performed; otherwise, step 210-1 is performed.
And step 210, determining the current online date as the current batch date, and performing data cleaning before batch on each historical account.
Optionally, the pre-batch data cleaning is performed on each historical account, and the pre-batch data cleaning includes:
and carrying out failure snapshot cleaning, temporary file snapshot cleaning, next-file snapshot cleaning, data cleaning and table cleaning on each historical account.
The current online date can be understood as the online date of the loan system at the current time, and the current batch date can be understood as the online date of the batch processing operation.
Specifically, when the current system state of the loan system is an online state, a batch preprocessing stage is entered, the current online date can be determined as the current batch date, and the data before batch is cleaned for each historical account. The system phase may also be modified to a pre-batch state as a precondition to entering the pre-batch processing phase.
And step 210-1, prompting the system state abnormity.
Specifically, only the online state is allowed to be switched to the batch preprocessing stage, that is, the data of each historical account is cleaned before batch, otherwise, the process can be interrupted and an exception prompt of 'system state check failure' can be thrown out.
Optionally, satisfying the pre-batch condition includes: the current system state of the loan system is an online state, and each historical account completes pre-batch data cleaning.
Specifically, the relevant system parameter values may be obtained, and it is determined whether the system meets the pre-batching condition, such as whether the current system state of the loan system is an online state, and whether the system stage is a pre-batching state, and if so, proceed to step 230; otherwise, step 230-1 is performed.
Transaction data may be understood, among other things, as data information about financial transactions in an account. The first interest amount may be understood as the interest data generated at the current batch date calculated based on the first account data. The pre-batch interest flag may be understood as flag information whether or not the pre-batch interest processing is completed.
Specifically, the system enters a pre-batching stage, the loan system data processing device can acquire first account data of each historical account in the loan system, extract transaction data in the first account data, respectively calculate first interest amount of each historical account at the current batch date, determine the first interest amount as a pre-batching interest processing result and store the pre-batching interest processing result in a temporary file, mark pre-batching interest identification in the historical account which completes calculation of the first interest amount as the pre-batching interest processing completion, and can be used for judging whether the account completes the pre-batching interest processing or not in a main batching stage. The system phase may also be modified to a pre-batch state as a precondition to the possibility to enter the next batch processing phase.
And step 230-1, prompting system abnormity.
Specifically, only the online state is allowed to be switched to the pre-batch processing stage, that is, pre-batch interest counting processing is performed on each historical account, otherwise, the process can be interrupted and an exception prompt of 'system check failure' can be thrown out.
Specifically, after the pre-batch processing operation is completed, the online daily cutting stage may be entered. If the system phase is checked to be in a pre-batch state, the current online date can be rolled forward, and the system phase can be modified into an online daily cutting state as a precondition for entering the next batch processing phase.
And step 250, judging whether the main batch condition is met.
Optionally, satisfying the master batch conditions includes: the current system state of the loan system is a single machine state, and each historical account completes the pre-batch interest-calculating processing.
Specifically, because the loan system has high requirements on the accuracy and the safety of the data, the embodiment of the invention enables the operation of the main batch to be carried out in a single machine state, and avoids new transaction data being written in the main batch. After the loan system data processing device receives the main batch instruction, the loan system data processing device can acquire relevant system parameter values and judge whether the system meets the main batch conditions, such as whether the current system state of the loan system is a single machine state and whether the system stage is an online daily cutting state. If yes, go to step 260; otherwise, go to step 260-1.
And step 260, aiming at each current account of the loan system, judging whether the current account completes the pre-batch information processing and no transaction data is written according to the pre-batch information identification and the account transaction identification in the second account data corresponding to the current account.
The account transaction identification can be understood as whether the account has the mark information written by the transaction data during the whole batch processing.
Specifically, the system enters a main batch processing stage, the loan system data processing device may acquire second account data of each current account of the loan system for the account, determine whether the current account completes the pre-batch information processing according to the pre-batch information identifier in the second account data, determine whether transaction data is written into the current account after entering a batch pre-processing stage according to the account transaction identifier in the second account data, and if the current account completes the pre-batch information processing and no transaction data is written into the current account, perform step 270-1; otherwise, step 270-2 is performed.
And step 260-1, prompting system abnormity.
Specifically, only the stand-alone state is allowed to be switched to the main batch processing stage, that is, the information data of each current account is updated, otherwise, the process can be interrupted and an abnormal prompt of 'system check failure' can be thrown out.
And 270-1, storing the corresponding pre-batch message processing result into the message data of the current account.
Specifically, if the current account completes the pre-batch information processing and no transaction data is written, the pre-batch information processing performed on the historical account corresponding to the current account is considered to be valid, and the corresponding pre-batch information processing result is stored in the information data of the current account.
And 270-2, determining a second interest amount of the current account according to the transaction data in the second account data, and depositing the second interest amount into the interest data of the current account.
Wherein the second interest amount may be understood as the interest data generated at the current batch date calculated based on the second account data.
Specifically, if the current account does not complete the pre-batch interest-bearing processing or transaction data is written in, the current account may be considered as a new added account, the pre-batch interest-bearing processing is not performed on the current account, or the account is transacted when the pre-batch interest-bearing processing is performed on the historical account corresponding to the current account, and the pre-batch interest-bearing processing performed on the historical account corresponding to the current account is invalid, so that the current account needs to be re-interest-bearing processed according to the transaction data in the second account data, and the second interest amount obtained through the interest-bearing processing is stored in the interest-bearing data of the current account.
After steps 270-1 and 270-2 are completed, the system phase may also be modified to the master batch state as a precondition to the next batch phase being entered.
Specifically, after the main batch processing operation is completed, the batch daily cutting stage may be entered. If the system stage is checked to be in a main batch state, if so, the current batch date can be rolled forward to clean each pre-batch interest-counting processing result in the temporary file. The system phase can also be modified into a batch daily cutting state as a precondition for entering the next batch processing phase.
Step 290 sets the system state of the loan system to online.
Specifically, after the batch daily cutting operation is completed, a complete batch processing operation can be considered to be completed, and at this time, the system state of the loan system is set to be an online state, so that the instant transactions such as request messages initiated by various channels can be processed.
Illustratively, as shown in fig. 3, 5/12/9/2019: 00, after receiving a batch processing instruction, determining that the current system state of the loan system is an online state, entering a batch pre-processing stage, wherein the online date is 2019, 5, 12 and the batch date is 2019, 5, 12, cleaning pre-batch data of each historical account, entering a pre-batch processing stage after meeting a pre-batch condition, the online date and the batch date are still 2019, 5, 12 and carrying out pre-batch interest-bearing processing on each historical account, storing the pre-batch interest-bearing processing result in a temporary file, entering an online day cutting stage, rolling the online date to 2019, 5, 13 and the batch date to 2019, 5, 12 and the batch date to 2019, when the loan system data processing device receives a main batch instruction, determining that the system meets a main batch condition, entering the main batch processing stage, and keeping the system in a stand-alone state, and updating the interest data of each current account in the loan system according to the situation by combining the second account data of each current account in the loan system with the pre-batch interest-counting processing result, wherein the online date is 5 and 13 days in 2019, the batch date is 5 and 12 days in 2019, after the main batch is finished, the batch date cutting stage can be entered, the batch date is rolled to 5 and 13 days in 2019, and the online state of the system is recovered. In the batch processing process, the snapshot file can be used for storing all data of any account at a certain time point, the snapshot can be used for temporarily storing intermediate data, and can also be used for tracing account history data, as shown in fig. 3, 99999999 represents a failure snapshot, 00000000 represents a temporary file, and after a batch is cut daily, the snapshot of the previous day fails.
The embodiment of the invention carries out pre-batch interest-calculating processing on each historical account in the loan system according to each first account data by dividing different batch processing stages during pre-batch, stores each pre-batch interest-calculating processing result in a temporary file, and updates the interest-calculating data of each current account in the loan system according to each current account data in the loan system and the pre-batch interest-calculating processing result when carrying out main batch, through the division of the pre-batch and the main batch, the invention can lead batch processing errors to be exposed in advance during the pre-batch period, avoid direct storage of dirty data, reduce system risks, and carry out batch account calculation under the online state of the system, solve the problems of higher system risk degree, large expense of required calculation resources, high hardware cost and low utilization rate caused by concentrated batch processing time, realize the separation of calculation and storage, and share the system calculation pressure during the previous batch processing period, the data updating speed is improved. Meanwhile, the current online date and the current batch date are rolled forward through the online daily cutting stage and the batch daily cutting stage, so that the rotation of the loan system can be realized.
EXAMPLE III
The loan system data processing device provided by the embodiment of the invention can execute the loan system data processing method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method. Fig. 4 is a block diagram of a data processing apparatus of a loan system according to a third embodiment of the invention, as shown in fig. 4, the apparatus including: a pre-batch module 310 and a main batch module 320.
The pre-batching module 310 is used for acquiring first account data of each historical account in the loan system when a pre-batching condition is met, performing pre-batching interest-calculating processing on each historical account according to each first account data, and storing each pre-batching interest-calculating processing result in a temporary file;
and the master batch processing module 320 is configured to, when a master batch condition is met, obtain second account data of each current account in the loan system, and update the account data of each current account in the loan system in combination with the pre-batch account processing result, where the current account includes the historical account and the newly added account.
The embodiment of the invention carries out pre-batch interest-calculating processing on each historical account in the loan system according to each first account data by dividing the pre-batch stage and the main batch stage during pre-batch, stores each pre-batch interest-calculating processing result in a temporary file, and updates the interest-calculating data of each current account in the loan system according to the second account data of each current account in the loan system and in combination with the pre-batch interest-calculating processing result during main batch, through the division of the pre-batch stage and the main batch stage, the embodiment of the invention can lead batch processing errors to be exposed in advance during the pre-batch period, avoid dirty data to be directly put in storage, reduce the system risk, and can carry out account batch calculation under the online state of the system, solve the problems of higher system risk degree, large required calculation resource expense, high hardware cost and low utilization rate caused by centralized batch processing time, and realize the separation of calculation and storage, the system calculation pressure in the past batch processing period is shared, and the data updating speed is improved.
Optionally, the pre-batching information processing on each historical account according to each first account data includes:
and for each historical account, determining a first interest amount of the historical account according to transaction data in first account data corresponding to the historical account, determining the first interest amount as a pre-batch information processing result corresponding to the current batch date, and updating a pre-batch information identifier of the historical account.
Optionally, the obtaining second account data of each current account in the loan system, and updating the account data of each current account in the loan system by combining the pre-batch account processing result includes:
for each current account of the loan system, determining whether the current account completes the pre-batch information processing and no transaction data is written according to a pre-batch information mark and an account transaction mark in second account data corresponding to the current account;
if so, storing the corresponding pre-batch interest processing result into the interest data of the current account;
if not, determining a second interest amount of the current account according to the transaction data in the second account data, and depositing the second interest amount into the interest data of the current account.
Optionally, the apparatus further comprises:
the batch preprocessing module is used for determining whether the current system state of the loan system is an online state after receiving a batch processing instruction, determining the current online date as the current batch date if the current system state of the loan system is the online state, and performing batch data cleaning on each historical account; if not, then,
and prompting the system state abnormity.
Optionally, the performing data cleansing in advance for each historical account includes:
and performing failure snapshot cleaning, temporary file snapshot cleaning, next-file snapshot cleaning, data cleaning and table cleaning on each historical account.
Optionally, the apparatus further comprises:
and the online daily cutting module is used for rolling forward the current online date after carrying out the pre-batch interest-counting processing on each historical account.
Optionally, the apparatus further comprises:
and the batch daily cutting module is used for rolling forward the current batch date after updating the interest data of each current account in the loan system and cleaning each pre-batch interest processing result in the temporary file.
Optionally, the apparatus further comprises:
and the online module is used for setting the system state of the loan system to be an online state.
Optionally, the meeting the pre-batch condition includes:
the current system state of the loan system is an online state, and each historical account completes pre-batch data cleaning.
Optionally, the satisfying the master batch condition includes:
the current system state of the loan system is a single machine state, and each historical account completes the pre-batch interest-calculating processing.
The embodiment of the invention carries out pre-batch interest-calculating processing on each historical account in the loan system according to each first account data by dividing different batch processing stages during pre-batch, stores each pre-batch interest-calculating processing result in a temporary file, and updates the interest-calculating data of each current account in the loan system according to each current account data in the loan system and the pre-batch interest-calculating processing result when carrying out main batch, through the division of the pre-batch and the main batch, the invention can lead batch processing errors to be exposed in advance during the pre-batch period, avoid direct storage of dirty data, reduce system risks, and carry out batch account calculation under the online state of the system, solve the problems of higher system risk degree, large expense of required calculation resources, high hardware cost and low utilization rate caused by concentrated batch processing time, realize the separation of calculation and storage, and share the system calculation pressure during the previous batch processing period, the data updating speed is improved. Meanwhile, the current online date and the current batch date are rolled forward through the online daily cutting stage and the batch daily cutting stage, so that the rotation of the loan system can be realized.
Example four
Fig. 5 is a block diagram of a computer apparatus according to a fourth embodiment of the present invention, as shown in fig. 5, the computer apparatus includes a processor 410, a memory 420, an input device 430, and an output device 440; the number of the processors 410 in the computer device may be one or more, and one processor 410 is taken as an example in fig. 5; the processor 410, the memory 420, the input device 430 and the output device 440 in the computer apparatus may be connected by a bus or other means, and the connection by the bus is exemplified in fig. 5.
The memory 420 serves as a computer-readable storage medium for storing software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to the loan system data processing method in the embodiments of the present invention (e.g., the pre-batch processing module 310 and the main batch processing module 320 in the loan system data processing apparatus). The processor 410 executes various functional applications of the computer device and data processing by executing software programs, instructions and modules stored in the memory 420, namely, implements the loan system data processing method described above.
The memory 420 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal, and the like. Further, the memory 420 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, memory 420 may further include memory located remotely from processor 410, which may be connected to a computer device through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 430 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function control of the computer apparatus. The output device 440 may include a display device such as a display screen.
EXAMPLE five
Embodiments of the present invention also provide a storage medium containing computer-executable instructions, which when executed by a computer processor, perform a loan system data processing method, the method comprising:
when the pre-batching condition is met, acquiring first account data of each historical account in the loan system, performing pre-batching interest-calculating processing on each historical account according to each first account data, and storing each pre-batching interest-calculating processing result in a temporary file;
and when the main batch condition is met, acquiring second account data of each current account in the loan system, and updating the account data of each current account in the loan system by combining the pre-batch account processing result, wherein the current account comprises the historical account and the newly added account.
Of course, the embodiments of the present invention provide a storage medium containing computer-executable instructions, which are not limited to the above-described method operations, but can also perform related operations in the loan system data processing method provided in any embodiments of the present invention.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.
It should be noted that, in the embodiment of the loan system data processing apparatus, the included units and modules are merely divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (13)
1. A loan system data processing method, comprising:
when the pre-batching condition is met, acquiring first account data of each historical account in the loan system, performing pre-batching interest-calculating processing on each historical account according to each first account data, and storing each pre-batching interest-calculating processing result in a temporary file;
and when the main batch condition is met, acquiring second account data of each current account in the loan system, and updating the account data of each current account in the loan system by combining the pre-batch account processing result, wherein the current account comprises the historical account and the newly added account.
2. The loan system data processing method according to claim 1, wherein the pre-batching of the interest in each of the historical accounts based on the data of each of the first accounts comprises:
and for each historical account, determining a first interest amount of the historical account according to transaction data in first account data corresponding to the historical account, determining the first interest amount as a pre-batch information processing result corresponding to the current batch date, and updating a pre-batch information identifier of the historical account.
3. The loan system data processing method of claim 1, wherein the obtaining of the second account data of each current account in the loan system and the updating of the interest data of each current account in the loan system in combination with the pre-approval interest processing result comprise:
for each current account of the loan system, determining whether the current account completes the pre-batch information processing and no transaction data is written according to a pre-batch information mark and an account transaction mark in second account data corresponding to the current account;
if so, storing the corresponding pre-batch interest processing result into the interest data of the current account;
if not, determining a second interest amount of the current account according to the transaction data in the second account data, and depositing the second interest amount into the interest data of the current account.
4. The loan system data processing method according to claim 2, further comprising, before the pre-batching interest processing for each of the historical accounts:
after receiving a batch processing instruction, determining whether the current system state of the loan system is an online state, if so, determining the current online date as the current batch date, and performing data cleaning before batch on each historical account; if not, then,
and prompting the system state abnormity.
5. The loan system data processing method according to claim 4, wherein the pre-batch data cleaning of each historical account comprises:
and performing failure snapshot cleaning, temporary file snapshot cleaning, next-file snapshot cleaning, data cleaning and table cleaning on each historical account.
6. The loan system data processing method according to claim 4, further comprising, after the pre-batching interest processing for each of the historical accounts:
rolling forward the current online date.
7. The loan system data processing method according to claim 2, further comprising, after updating the interest data of each current account in the loan system:
and rolling the current batch date forward, and cleaning each pre-batch interest-counting processing result in the temporary file.
8. The loan system data processing method according to claim 7, further comprising, after rolling forward the current batch date, cleaning each of the pre-batch interest processing results in the temporary file:
setting a system state of the loan system to an online state.
9. The loan system data processing method according to claim 1, wherein the satisfying the pre-batch condition comprises:
the current system state of the loan system is an online state, and each historical account completes pre-batch data cleaning.
10. The loan system data processing method according to claim 1, wherein the satisfying the master batch condition comprises:
the current system state of the loan system is a single machine state, and each historical account completes the pre-batch interest-calculating processing.
11. A loan system data processing apparatus, comprising:
the system comprises a pre-batching module, a temporary file and a data processing module, wherein the pre-batching module is used for acquiring first account data of each historical account in a loan system when a pre-batching condition is met, performing pre-batching interest-calculating processing on each historical account according to each first account data and storing each pre-batching interest-calculating processing result in the temporary file;
and the master batch processing module is used for acquiring second account data of each current account in the loan system when a master batch condition is met, and updating the account data of each current account in the loan system by combining the pre-batch account processing result, wherein the current account comprises the historical account and the newly added account.
12. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor when executing the program implements the loan system data processing method according to any of claims 1 to 10.
13. A storage medium containing computer-executable instructions for performing the loan system data processing method of any of claims 1-10 when executed by a computer processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010731301.7A CN111882427A (en) | 2020-07-27 | 2020-07-27 | Loan system data processing method, loan system data processing device, loan system data processing equipment and loan system data processing storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010731301.7A CN111882427A (en) | 2020-07-27 | 2020-07-27 | Loan system data processing method, loan system data processing device, loan system data processing equipment and loan system data processing storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111882427A true CN111882427A (en) | 2020-11-03 |
Family
ID=73200703
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010731301.7A Pending CN111882427A (en) | 2020-07-27 | 2020-07-27 | Loan system data processing method, loan system data processing device, loan system data processing equipment and loan system data processing storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111882427A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113486032A (en) * | 2021-07-02 | 2021-10-08 | 中国建设银行股份有限公司 | Date switching method and device, electronic equipment and computer readable medium |
| CN113971007A (en) * | 2021-10-29 | 2022-01-25 | 中国建设银行股份有限公司 | Information processing method, information processing apparatus, electronic device, and medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106648842A (en) * | 2016-12-27 | 2017-05-10 | 中国建设银行股份有限公司 | Method and device for continuous running of batch jobs |
| CN106708845A (en) * | 2015-11-12 | 2017-05-24 | 阿里巴巴集团控股有限公司 | Data processing method and device for Internet account |
| CN110008018A (en) * | 2019-01-17 | 2019-07-12 | 阿里巴巴集团控股有限公司 | A kind of batch tasks processing method, device and equipment |
| CN110009477A (en) * | 2019-02-25 | 2019-07-12 | 阿里巴巴集团控股有限公司 | A kind of interest meter proposes method, system and equipment |
-
2020
- 2020-07-27 CN CN202010731301.7A patent/CN111882427A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106708845A (en) * | 2015-11-12 | 2017-05-24 | 阿里巴巴集团控股有限公司 | Data processing method and device for Internet account |
| CN106648842A (en) * | 2016-12-27 | 2017-05-10 | 中国建设银行股份有限公司 | Method and device for continuous running of batch jobs |
| CN110008018A (en) * | 2019-01-17 | 2019-07-12 | 阿里巴巴集团控股有限公司 | A kind of batch tasks processing method, device and equipment |
| CN110009477A (en) * | 2019-02-25 | 2019-07-12 | 阿里巴巴集团控股有限公司 | A kind of interest meter proposes method, system and equipment |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113486032A (en) * | 2021-07-02 | 2021-10-08 | 中国建设银行股份有限公司 | Date switching method and device, electronic equipment and computer readable medium |
| CN113971007A (en) * | 2021-10-29 | 2022-01-25 | 中国建设银行股份有限公司 | Information processing method, information processing apparatus, electronic device, and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110232565B (en) | Resource clearing method, device, computer equipment and storage medium | |
| CN107038645B (en) | Service processing method, device and system and server | |
| CN111553656A (en) | Capital settlement method and device based on big data, electronic equipment and medium | |
| CN111882427A (en) | Loan system data processing method, loan system data processing device, loan system data processing equipment and loan system data processing storage medium | |
| CN111475532A (en) | Data processing optimization method and device, storage medium and terminal | |
| CN111400283B (en) | Data processing method, system, electronic equipment and storage medium | |
| CN112685208B (en) | Batch processing method, device, equipment and storage medium | |
| CN107169767B (en) | Transaction processing method and system | |
| CN112907344A (en) | Accounting data processing method and device, electronic equipment and storage medium | |
| CN112950191A (en) | Service data processing method and device based on fee refunding service and computer equipment | |
| CN112465628A (en) | Data verification method and device, electronic equipment and storage medium | |
| CN112801616B (en) | Abnormal account book processing method and device | |
| CN111506784B (en) | Asset creditor matching method, device, computer equipment and storage medium | |
| CN110765148B (en) | Service data processing method and device | |
| CN112241889A (en) | Account detail repairing method, device, equipment and storage medium | |
| CN112099934A (en) | Batch processing method, system, computer equipment and storage medium | |
| CN111639057A (en) | Log message processing method and device, computer equipment and storage medium | |
| CN112365337B (en) | Method, device, server and storage medium for identifying imposition loan | |
| CN108596751A (en) | A kind of account repayment method, device, terminal device and storage medium | |
| CN107730381B (en) | Method and device for backing up cross section data | |
| CN114254921A (en) | Transaction processing rule matching method and device | |
| CN115357627A (en) | Blacklist screening system, method, device, medium and computer program product | |
| CN115936843A (en) | Credit card management method, device and system | |
| CN114493846A (en) | Method, device, equipment and medium for approving contracts of same industry | |
| CN115471316A (en) | Repayment option default setting method and device |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220922 Address after: 25 Financial Street, Xicheng District, Beijing 100033 Applicant after: CHINA CONSTRUCTION BANK Corp. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |