CN113159968A - Data processing method and device based on financial core batch transaction scene - Google Patents

Data processing method and device based on financial core batch transaction scene Download PDF

Info

Publication number
CN113159968A
CN113159968A CN202110493686.2A CN202110493686A CN113159968A CN 113159968 A CN113159968 A CN 113159968A CN 202110493686 A CN202110493686 A CN 202110493686A CN 113159968 A CN113159968 A CN 113159968A
Authority
CN
China
Prior art keywords
transaction
interest
account
result
data
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
Application number
CN202110493686.2A
Other languages
Chinese (zh)
Inventor
夏康
林承军
彭卫华
刘静
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Industrial and Commercial Bank of China Ltd ICBC
Original Assignee
Industrial and Commercial Bank of China Ltd ICBC
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Industrial and Commercial Bank of China Ltd ICBC filed Critical Industrial and Commercial Bank of China Ltd ICBC
Priority to CN202110493686.2A priority Critical patent/CN113159968A/en
Publication of CN113159968A publication Critical patent/CN113159968A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/06Asset management; Financial planning or analysis
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/211Schema design and management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02Banking, e.g. interest calculation or account maintenance
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/04Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Development Economics (AREA)
  • Databases & Information Systems (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Game Theory and Decision Science (AREA)
  • Human Resources & Organizations (AREA)
  • Operations Research (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention provides a data processing method and device based on a financial core batch transaction scene, which can be used in the financial field or other fields. The data processing method comprises the following steps: acquiring transaction data based on a financial core batch transaction scene; carrying out batch account checking transaction processing according to the transaction data to obtain an account checking result; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register; and performing batch interest settlement transaction processing according to the transaction data to obtain an interest settlement result, writing the interest settlement result into a preset account interest detail table, and deducting the interest settlement amount in the interest settlement result in a preset internal accounting table of the financial institution. The invention can dynamically check whether the transaction data is in the consistency state of account checking balance by periodically executing account checking transaction, and can ensure the consistency of the data in a fault scene.

Description

Data processing method and device based on financial core batch transaction scene
Technical Field
The invention relates to the technical field of database testing, in particular to testing of a financial field database, and specifically relates to a data processing method and device based on a financial core batch transaction scene.
Background
In the field of database benchmark, it is necessary to simulate traffic load to perform transaction processing on data stored in a database, so as to evaluate performance (such as transaction throughput, response time, and the like) and capacity (such as concurrency number, storage capacity, and the like) that can be supported by a database product. At present, the commonly used database benchmark test scheme comprises a Sysbench test adopting a random read-write transaction model and a TPC-H test based on an accessory sales management model. The Sysbench tool is an open-source benchmark test tool and can perform performance benchmark tests in the aspects of CPU/memory/thread/IO/database and the like. TPC-H is a benchmark test for database on-line Transaction Performance issued by the Transaction Performance Committee (TPC).
Compared with the requirements of the financial industry on database products, the transaction flow for processing data in the prior art is simple, the workload of the database in the batch transaction scene of the financial industry cannot be well simulated, the characteristic that one financial core system accesses the database is difficult to embody, and the requirements of the financial industry on the type selection evaluation of the database products are difficult to meet.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides a data processing method and a data processing device based on a financial core batch transaction scene, which specifically comprise the following technical scheme:
in a first aspect, the present invention provides a data processing method based on a financial core batch transaction scenario, including:
acquiring transaction data based on a financial core batch transaction scene;
carrying out batch account checking transaction processing according to the transaction data to obtain account checking results; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register;
and performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution.
Further, after obtaining the result of batch interest-bearing transaction processing according to the transaction data, the method further comprises the following steps:
the customer status in the account details table is updated to be the interest bearing and the most recent interest bearing date information in the account details table.
Further, after obtaining the result of batch interest-bearing transaction processing according to the transaction data, the method further comprises the following steps:
and if the account checking result is that the account checking is unbalanced, sending an early warning signal for indicating that data inconsistency occurs.
Wherein, the batch reconciliation transaction processing according to the transaction data to obtain a reconciliation result comprises the following steps:
calculating the current transaction summary gross of each financial account according to the transaction data and acquiring the current balance and the current balance of each financial account;
and determining a reconciliation result based on the current transaction summary running difference, the current balance and the current balance.
Wherein, the obtaining result of batch interest-bearing transaction processing according to the transaction data comprises:
sorting the account interest list in the transaction data, and calculating interest processing on the accounts according to the sorting sequence to obtain a result of interest bearing;
wherein the result of interest includes an interest amount.
In a second aspect, the present invention provides a data processing apparatus based on a financial core batch transaction scenario, comprising:
the acquisition module is used for acquiring transaction data based on a financial core batch transaction scene;
the account checking module is used for carrying out batch account checking transaction processing according to the transaction data to obtain an account checking result; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register;
and the interest bearing module is used for carrying out batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution.
Further, still include:
and the updating module is used for updating the client state in the account detail table as the interest and the latest interest date information in the account detail table.
Further, still include:
and the early warning module is used for sending an early warning signal for indicating that the data are inconsistent if the account checking result is that the account checking is not balanced.
Wherein, the reconciliation module comprises:
the acquisition unit is used for calculating the current transaction summary gross of each financial account according to the transaction data and acquiring the current balance and the current balance of each financial account;
and the calculation unit is used for determining a reconciliation result based on the current transaction summary netting difference, the current balance and the current balance.
Wherein, the information module includes:
the interest accounting unit is used for sequencing the account interest list in the transaction data and performing interest calculation processing on the accounts according to the sequencing order to obtain an interest bearing result;
wherein the result of interest includes an interest amount.
In a third aspect, the present invention provides an electronic device, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the data processing method based on the financial core batch transaction scenario when executing the program.
In a fourth aspect, the present invention provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the data processing method based on a financial core batch trading scenario.
According to the technical scheme, the invention provides the data processing method and the data processing device based on the financial core batch transaction scene, and the transaction data based on the financial core batch transaction scene is obtained; carrying out batch account checking transaction processing according to the transaction data to obtain account checking results; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register; and performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution. The account reconciliation transaction can be periodically executed, whether the transaction data is in a reconciliation balance consistency state or not can be dynamically checked, and the consistency of the data can be ensured in a fault scene.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a flowchart illustrating a data processing method based on a financial core batch transaction scenario according to an embodiment of the present invention.
Fig. 2 is a schematic structural diagram of a data processing apparatus based on a financial core batch transaction scenario according to an embodiment of the present invention.
Fig. 3 is a schematic structural diagram of an electronic device in an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. 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 invention.
Before describing the embodiments of the present invention, an application scenario and key terms of the embodiments of the present invention are described. Based on a core system of the real banking industry, a bank has M institutions and N tellers, P accounts are initially provided, and each account has a certain initial amount. At the same time, T operative tellers concurrently initiate a business transaction. The trade operation teller in the channels of internet bank, mobile phone bank and the like is a virtual teller. The financial industry is in currency and is honored, the transaction executed by each teller can serve any account, and when a plurality of transactions are accessed to the same account in a centralized way, the phenomenon of hot account occurs.
Wherein, the interest means interest calculation. For banks, interest is calculated in advance. Currently, financial institutions generally adopt two methods of interest: the first is a method of interest-bearing on the year, month and day, that is, for a deposit or loan, the interest is calculated according to the whole year, month and day, and then the interest is calculated by adding the interest-bearing points to calculate the whole deposit period or loan period. The second is a daily accumulation method, namely, the daily accumulation is calculated by multiplying the principal by the number of days, and then all interest is obtained according to the daily accumulation program daily interest rate.
The interest bearing means that the interest is actually paid, and the interest obtained by the client deposit is transferred to the client account. Financial institutions do not pay or receive interest on a daily basis for a deposit or loan, and typically focus on actually receiving interest on a particular date.
Legal currency means that the currency does not represent actual goods or goods, and the issuer does not convert the currency into physical obligations; only by government regulations, it is the currency of legal currency.
For example: according to the Ministry of people's republic of China, the unit of the RMB is Yuan, and the unit of the RMB and the auxiliary currency is corner and minute. Thus, the statutory minimum monetary unit of RMB is minutes. The unit of centi, milli, etc. can be used for illegally ordering currency unit.
The amounts are all of the integer type, and are in units of the statutory minimum currency of the designated currency, and the processing of the amounts such as settlement in the system is based on the minimum currency unit. For example, the money unit of the RMB account is 1 minute, and the conversion of units such as Yuan, jiao and grade is not involved.
The invention provides an embodiment of a data processing method based on a financial core batch transaction scene, which specifically comprises the following contents in reference to fig. 1:
s101: acquiring transaction data based on a financial core batch transaction scene;
s102: carrying out batch account checking transaction processing according to the transaction data to obtain account checking results; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register;
in this step, the batch reconciliation transaction processing is performed according to the transaction data to obtain a reconciliation result, which includes:
calculating the current transaction summary gross of each financial account according to the transaction data and acquiring the current balance and the current balance of each financial account;
and determining a reconciliation result based on the current transaction summary running difference, the current balance and the current balance.
S103: and performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution.
In this step, the processing of batch interest-bearing transactions according to the transaction data to obtain an interest-bearing result includes: sorting the account interest list in the transaction data, and calculating interest processing on the accounts according to the sorting sequence to obtain a result of interest bearing; wherein the result of interest includes an interest amount.
In this embodiment, the acquiring and processing transaction data based on the transaction data of the financial core batch transaction scenario specifically includes:
configuring parameters of a batch transaction of a transaction execution, comprising: run time, interest batch execution period and reconciliation batch execution period;
for convenience of expression, the parameters of a batch transaction are referred to herein by the following variable names:
Figure BDA0003053439100000061
the batch process is started.
Executing batch reconciliation transaction once every time period of reconciliation batch execution period (i _ verify _ cycle), wherein the transaction can calculate the current transaction summary netting difference of each financial account, check the current balance and the current balance of each financial account and judge the following reconciliation results:
RESAMT (current balance-current balance) -current transaction summary netting
If the RESAMT is equal to 0, the balance of the current balance is equal to the previous balance + the difference of various transactions in the period of time, i.e. the balance of the account.
If RESAMT! And (0) accounting imbalance is described, and if fund errors occur, the transaction data is subjected to accounting complementing processing according to the transaction log corresponding to the transaction data. In this embodiment, a manual reconciliation flow and a reconciliation process need to be started according to the transaction log.
Further, if the account checking result is that the account checking is unbalanced, an early warning signal for indicating that data inconsistency occurs is sent.
And writing the reconciliation result of the batch reconciliation transaction into a reconciliation result register table.
And executing batch interest transaction once every time period of an interest batch execution period (i _ interior _ cycle), summarizing and settling each transaction interest according to the account interest list, settling the interest to the account balance list, and writing the interest result into the account interest list.
Further, the customer status in the account statement is updated to be the interest and the most recent interest date information in the account statement. And deducting the settlement amount in an internal accounting table of the financial institution.
The running time i _ runtime ends.
As can be seen from the above description, the present invention provides a data processing method based on financial core batch transaction scenarios, by acquiring transaction data based on financial core batch transaction scenarios; carrying out batch account checking transaction processing according to the transaction data to obtain account checking results; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register; and performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution. The load pressure of the financial core system batch business on the database products can be better simulated, workload scenes such as batch insertion, batch updating, large affairs and the like under the condition of large data volume are provided through account checking and interest bearing financial core batch trading, and the service support capability of the database products on the financial industry batch trading can be better checked. By periodically performing an "account tie-out" transaction, it is dynamically verified whether the data processed by the system is in a tie-out balanced coherency state. By the method, whether the tested product can ensure the data consistency under the system fault scene can be checked.
The embodiment provides a specific implementation manner of batch reconciliation transaction processing, which specifically includes:
(1) starting account checking according to a set time period;
(2) acquiring system time as a transaction date v _ workdate;
(3) inquiring an account detail table, and calculating current-period summary netting difference amount for each account;
Figure BDA0003053439100000071
subsequently, each account is processed:
and assigning the inquired account number field1 to v _ account, the currency field2 to v _ current, and the current summary netting difference AMT to v _ detail _ account _ total.
(4) Inquiring the current balance and the current balance of the current account checking account;
Figure BDA0003053439100000072
(5) calculate RESAMT (current balance-last balance) -v _ detail _ amount _ total.
If RESAMT! If 0, the account is checked incorrectly.
And registering a reconciliation result register.
Figure BDA0003053439100000073
The embodiment provides a specific implementation manner of batch interest transaction processing, which specifically includes:
(1) acquiring a system date as a transaction date v _ workdate;
(2) setting a unique service number v _ seq;
(3) setting an execution mechanism v _ instruction and an execution teller v _ teller;
(4) sorting the account information detail table according to the account number and the date;
Figure BDA0003053439100000081
(5) and calculating interest according to the account, and acquiring the interest amount v _ interest _ amount. The calculation method is as follows:
for each account (the current processing account is assigned to the variable v _ account, and the current processing currency is assigned to the variable v _ currenty), sequentially obtaining the information detail records R1.
Figure BDA0003053439100000082
Where field11 represents the benchmark interest rate field in the account interest list, which is 100000000 times the actual interest rate. The interest rate is fixed in a rest period.
For all accounts with balance less than 0 (including the account to be interest bearing record and all the accounts bearing in the interest bearing list), adding an interest amount, and bearing according to the amount of the last interest bearing detail from max (the last interest bearing detail bearing end date and the last interest bearing date) to the current interest bearing transaction day:
Figure BDA0003053439100000083
where v _ tmp _ date is max (the last interest-bearing date of the interest-bearing details, the last interest-bearing date).
Among them, several situations are involved:
the balance has not changed after the last interest-bearing of an account, and the interest is charged from the last interest-bearing date to the current 'account interest-bearing' transaction day. Then equation 1 results in 0 and equation 2 calculates interest.
-the balance changes after the last settlement of an account, and the "account settlement" transaction is carried out the same day after the last balance change is inserted into the settlement statement. Then equation 1 results in an interest due, equation 2 plus 0.
The balance changes after the last settlement of an account, and the transaction of 'account settlement' is only started every several days after the last balance change is inserted into the settlement list. The result of equation 1 is the interest due for each balance change, and equation 2 adds the interest due during the time from the last balance change to the current "account balance" transaction.
(6) The account balance table is updated after the interest amount is calculated for each (account v _ account, currency v _ currenty).
Figure BDA0003053439100000084
Figure BDA0003053439100000091
An account may correspond to multiple currencies, and both cash and settlement transactions are based on account number + currency.
(7) An account settlement list is registered for each (account v _ account, currency v _ currenty) combination. Example SQL is as follows:
Figure BDA0003053439100000092
(8) an account list is registered for each account v _ account. Example SQL is as follows:
Figure BDA0003053439100000093
Figure BDA0003053439100000101
(9) updating the status of the account statement for each account;
Figure BDA0003053439100000102
(10) updating an account deposit protocol table for each account number;
Figure BDA0003053439100000103
the last settlement date field4 in the account deposit agreement table is updated based on the account currency, and the fields such as institution number, teller number, etc. are not modified.
(11) Updating an internal accounting table of the financial institution;
the total amount of interest v _ interest _ all is the sum of all account interest amounts.
First, whether a financial institution internal accounting table record exists is inquired.
Figure BDA0003053439100000104
If the record does not exist, a pen is inserted first.
Figure BDA0003053439100000111
Updating internal accounting tables of financial institutions
Figure BDA0003053439100000112
The specific formats of the account interest list, the reconciliation result register and the internal accounting list of the financial institution in the above embodiments are provided in this embodiment:
account interest detail table:
(1) field definitions
Figure BDA0003053439100000113
(2) Index definition
Index name Index field Properties
IDX1 FIELD1+FIELD2+FIELD3 UNIQUE
Account statement
(1) Field definitions
Figure BDA0003053439100000114
Figure BDA0003053439100000121
(2) Index definition
Index name Index field Properties
IDX1 FIELD1+FIELD2+FIELD3 UNIQUE
Account checking result register:
(1) field definitions
Name of English Name of Chinese Data type Note description
FIELD1 Account number UNSIGNED BIGINT(19)
FIELD2 Coin kind UNSIGNED INT(3)
FIELD3 Date of account checking DATE YYYY-MM-DD
FIELD4 Amount of miscount BIGINT(17)
(2) Index definition
Index name Index field Properties
IDX1 FIELD1 UNIQUE
Financial institution internal accounting table:
(1) field definitions
Figure BDA0003053439100000122
(2) Index definition
Index name Index field Properties
IDX1 FIELD1+FIELD2 UNIQUE
It should be noted that a type of transaction corresponds to an internal user, for example, cash transactions correspond to an internal user, and the result is also an internal user. Only one record is available in one batch, and each internal user only has one processing direction, so that unique key conflict caused by different processing directions can be avoided.
Where the data constraints are as follows:
(1) all tables must define primary keys. In practical application, a unique index in the data model can be used as a main key, and a ROWID column without service significance can be added as the main key.
(2) All fields need to define NOT NULL attributes, and NULL values can be represented by special values outside the normal service value domain.
From the above description, the load pressure of the financial core system batch business on the database product can be better simulated, workload scenes such as batch insertion, batch update, large affairs and the like under the condition of large data volume are provided through financial core batch transactions such as account checking, interest bearing and the like, and the service support capability of the database product on the financial industry batch transactions can be better verified. By periodically performing an "account tie-out" transaction, it is dynamically verified whether the data processed by the system is in a tie-out balanced coherency state. By the method, whether the tested product can ensure the data consistency under the system fault scene can be checked.
An embodiment of the present invention provides a specific implementation manner of a data processing apparatus based on a financial core batch transaction scenario, which is capable of implementing all contents in the data processing method based on the financial core batch transaction scenario, and referring to fig. 2, the data processing apparatus based on the financial core batch transaction scenario specifically includes the following contents:
the system comprises an acquisition module 10, a data processing module and a data processing module, wherein the acquisition module is used for acquiring transaction data based on a financial core batch transaction scene;
the reconciliation module 20 is used for carrying out batch reconciliation transaction processing according to the transaction data to obtain a reconciliation result; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register;
and the interest bearing module 30 is used for performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution.
Further, still include:
and the updating module is used for updating the client state in the account detail table as the interest and the latest interest date information in the account detail table.
Further, still include:
and the early warning module is used for sending an early warning signal for indicating that the data are inconsistent if the account checking result is that the account checking is not balanced.
Wherein, the reconciliation module comprises:
the acquisition unit is used for calculating the current transaction summary gross of each financial account according to the transaction data and acquiring the current balance and the current balance of each financial account;
and the calculation unit is used for determining a reconciliation result based on the current transaction summary netting difference, the current balance and the current balance.
Wherein, the information module includes:
the interest accounting unit is used for sequencing the account interest list in the transaction data and performing interest calculation processing on the accounts according to the sequencing order to obtain an interest bearing result;
wherein the result of interest includes an interest amount.
The embodiment of the data processing apparatus based on the financial core batch transaction scenario provided by the present invention may be specifically configured to execute the processing flow of the embodiment of the data processing method based on the financial core batch transaction scenario in the above embodiment, and the functions of the processing flow are not described herein again, and reference may be made to the detailed description of the embodiment of the method.
As can be seen from the above description, the data processing apparatus based on the financial core batch transaction scenario provided in the embodiment of the present invention obtains the transaction data based on the financial core batch transaction scenario; carrying out batch account checking transaction processing according to the transaction data to obtain account checking results; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register; and performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution. The account reconciliation transaction can be periodically executed, whether the transaction data is in a reconciliation balance consistency state or not can be dynamically checked, and the consistency of the data can be ensured in a fault scene.
The application provides an embodiment of an electronic device for implementing all or part of contents in the data processing method based on the financial core batch transaction scenario, where the electronic device specifically includes the following contents:
a processor (processor), a memory (memory), a communication Interface (Communications Interface), and a bus; the processor, the memory and the communication interface complete mutual communication through the bus; the communication interface is used for realizing information transmission between related devices; the electronic device may be a desktop computer, a tablet computer, a mobile terminal, and the like, but the embodiment is not limited thereto. In this embodiment, the electronic device may be implemented with reference to the embodiment of the data processing method for implementing the financial core batch transaction scenario and the embodiment of the data processing apparatus for implementing the financial core batch transaction scenario, which are incorporated herein, and repeated details are not repeated.
Fig. 3 is a schematic block diagram of a system configuration of an electronic device 9600 according to an embodiment of the present application. As shown in fig. 3, the electronic device 9600 can include a central processor 9100 and a memory 9140; the memory 9140 is coupled to the central processor 9100. Notably, this FIG. 3 is exemplary; other types of structures may also be used in addition to or in place of the structure to implement telecommunications or other functions.
In one embodiment, the data processing functionality based on the financial core batch trading scenario may be integrated into the central processor 9100. The central processor 9100 may be configured to control as follows:
acquiring transaction data based on a financial core batch transaction scene; carrying out batch account checking transaction processing according to the transaction data to obtain account checking results; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register; and performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution.
As can be seen from the above description, the electronic device provided in the embodiments of the present application obtains transaction data based on a financial core batch transaction scenario; carrying out batch account checking transaction processing according to the transaction data to obtain account checking results; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register; and performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution. The account reconciliation transaction can be periodically executed, whether the transaction data is in a reconciliation balance consistency state or not can be dynamically checked, and the consistency of the data can be ensured in a fault scene.
In another embodiment, the data processing apparatus based on the financial core batch transaction scenario may be configured separately from the central processor 9100, for example, the data processing apparatus based on the financial core batch transaction scenario may be configured as a chip connected to the central processor 9100, and the data processing function based on the financial core batch transaction scenario is implemented by the control of the central processor.
As shown in fig. 3, the electronic device 9600 may further include: a communication module 9110, an input unit 9120, an audio processor 9130, a display 9160, and a power supply 9170. It is noted that the electronic device 9600 also does not necessarily include all of the components shown in fig. 3; further, the electronic device 9600 may further include components not shown in fig. 3, which may be referred to in the art.
As shown in fig. 3, a central processor 9100, sometimes referred to as a controller or operational control, can include a microprocessor or other processor device and/or logic device, which central processor 9100 receives input and controls the operation of the various components of the electronic device 9600.
The memory 9140 can be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information relating to the failure may be stored, and a program for executing the information may be stored. And the central processing unit 9100 can execute the program stored in the memory 9140 to realize information storage or processing, or the like.
The input unit 9120 provides input to the central processor 9100. The input unit 9120 is, for example, a key or a touch input device. Power supply 9170 is used to provide power to electronic device 9600. The display 9160 is used for displaying display objects such as images and characters. The display may be, for example, an LCD display, but is not limited thereto.
The memory 9140 can be a solid state memory, e.g., Read Only Memory (ROM), Random Access Memory (RAM), a SIM card, or the like. There may also be a memory that holds information even when power is off, can be selectively erased, and is provided with more data, an example of which is sometimes called an EPROM or the like. The memory 9140 could also be some other type of device. Memory 9140 includes a buffer memory 9141 (sometimes referred to as a buffer). The memory 9140 may include an application/function storage portion 9142, the application/function storage portion 9142 being used for storing application programs and function programs or for executing a flow of operations of the electronic device 9600 by the central processor 9100.
The memory 9140 can also include a data store 9143, the data store 9143 being used to store data, such as contacts, digital data, pictures, sounds, and/or any other data used by an electronic device. The driver storage portion 9144 of the memory 9140 may include various drivers for the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging applications, contact book applications, etc.).
The communication module 9110 is a transmitter/receiver 9110 that transmits and receives signals via an antenna 9111. The communication module (transmitter/receiver) 9110 is coupled to the central processor 9100 to provide input signals and receive output signals, which may be the same as in the case of a conventional mobile communication terminal.
Based on different communication technologies, a plurality of communication modules 9110, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, may be provided in the same electronic device. The communication module (transmitter/receiver) 9110 is also coupled to a speaker 9131 and a microphone 9132 via an audio processor 9130 to provide audio output via the speaker 9131 and receive audio input from the microphone 9132, thereby implementing ordinary telecommunications functions. The audio processor 9130 may include any suitable buffers, decoders, amplifiers and so forth. In addition, the audio processor 9130 is also coupled to the central processor 9100, thereby enabling recording locally through the microphone 9132 and enabling locally stored sounds to be played through the speaker 9131.
An embodiment of the present invention further provides a computer-readable storage medium capable of implementing all the steps of the data processing method based on the financial core batch transaction scenario in the above-mentioned embodiment, where the computer-readable storage medium stores thereon a computer program, and when the computer program is executed by a processor, the computer program implements all the steps of the data processing method based on the financial core batch transaction scenario in the above-mentioned embodiment, for example, when the processor executes the computer program, the processor implements the following steps:
acquiring transaction data based on a financial core batch transaction scene; carrying out batch account checking transaction processing according to the transaction data to obtain account checking results; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register; and performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution.
As can be seen from the above description, the computer-readable storage medium provided by the embodiment of the present invention obtains transaction data based on a financial core batch transaction scenario; carrying out batch account checking transaction processing according to the transaction data to obtain account checking results; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register; and performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution. The account reconciliation transaction can be periodically executed, whether the transaction data is in a reconciliation balance consistency state or not can be dynamically checked, and the consistency of the data can be ensured in a fault scene.
Although the present invention provides method steps as described in the examples or flowcharts, more or fewer steps may be included based on routine or non-inventive labor. The order of steps recited in the embodiments is merely one manner of performing the steps in a multitude of orders and does not represent the only order of execution. When an actual apparatus or client product executes, it may execute sequentially or in parallel (e.g., in the context of parallel processors or multi-threaded processing) according to the embodiments or methods shown in the figures.
As will be appreciated by one skilled in the art, embodiments of the present description may be provided as a method, apparatus (system) or computer program product. Accordingly, embodiments of the present description 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 is 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.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict. The present invention is not limited to any single aspect, nor is it limited to any single embodiment, nor is it limited to any combination and/or permutation of these aspects and/or embodiments. Moreover, each aspect and/or embodiment of the present invention may be utilized alone or in combination with one or more other aspects and/or embodiments thereof.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; such modifications and substitutions do not depart from the spirit and scope of the present invention, and they should be construed as being included in the following claims and description.

Claims (12)

1. A data processing method based on financial core batch transaction scenes is characterized by comprising the following steps:
acquiring transaction data based on a financial core batch transaction scene;
carrying out batch account checking transaction processing according to the transaction data to obtain account checking results; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register;
and performing batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution.
2. The data processing method based on financial core batch transaction scenario of claim 1, further comprising, after obtaining the result of batch interest-bearing transaction processing according to the transaction data:
the customer status in the account details table is updated to be the interest bearing and the most recent interest bearing date information in the account details table.
3. The data processing method based on financial core batch transaction scenario of claim 1, further comprising, after obtaining the result of batch interest-bearing transaction processing according to the transaction data:
and if the account checking result is that the account checking is unbalanced, sending an early warning signal for indicating that data inconsistency occurs.
4. The data processing method based on financial core batch transaction scenario as claimed in claim 1, wherein the batch reconciliation transaction processing according to the transaction data to obtain a reconciliation result comprises:
calculating the current transaction summary gross of each financial account according to the transaction data and acquiring the current balance and the current balance of each financial account;
and determining a reconciliation result based on the current transaction summary running difference, the current balance and the current balance.
5. The data processing method based on financial core batch transaction scenario as claimed in claim 1, wherein the processing of batch interest-bearing transaction according to the transaction data to obtain the result of interest comprises:
sorting the account interest list in the transaction data, and calculating interest processing on the accounts according to the sorting sequence to obtain a result of interest bearing;
wherein the result of interest includes an interest amount.
6. A data processing apparatus based on a financial core batch transaction scenario, comprising:
the acquisition module is used for acquiring transaction data based on a financial core batch transaction scene;
the account checking module is used for carrying out batch account checking transaction processing according to the transaction data to obtain an account checking result; if the account checking result is that the account checking is unbalanced, performing account compensation processing on the transaction data according to a transaction log corresponding to the transaction data; writing the reconciliation result into a preset reconciliation result register;
and the interest bearing module is used for carrying out batch interest bearing transaction processing according to the transaction data to obtain an interest bearing result, writing the interest bearing result into a preset account interest detail table, and deducting the interest bearing amount in the interest bearing result in a preset internal accounting table of the financial institution.
7. The financial core batch transaction scenario-based data processing apparatus of claim 6, further comprising:
and the updating module is used for updating the client state in the account detail table as the interest and the latest interest date information in the account detail table.
8. The financial core batch transaction scenario-based data processing apparatus of claim 6, further comprising:
and the early warning module is used for sending an early warning signal for indicating that the data are inconsistent if the account checking result is that the account checking is not balanced.
9. The financial core batch transaction scenario-based data processing apparatus of claim 6, wherein the reconciliation module comprises:
the acquisition unit is used for calculating the current transaction summary gross of each financial account according to the transaction data and acquiring the current balance and the current balance of each financial account;
and the calculation unit is used for determining a reconciliation result based on the current transaction summary netting difference, the current balance and the current balance.
10. The financial core batch transaction scenario-based data processing apparatus of claim 6, wherein the interest bearing module comprises:
the interest accounting unit is used for sequencing the account interest list in the transaction data and performing interest calculation processing on the accounts according to the sequencing order to obtain an interest bearing result;
wherein the result of interest includes an interest amount.
11. An electronic 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 steps of the method of data processing based on financial core batch trading scenarios of any one of claims 1 to 5.
12. A computer-readable storage medium, on which a computer program is stored, the computer program, when being executed by a processor, implementing the steps of the data processing method based on financial core batch trading scenario of any one of claims 1 to 5.
CN202110493686.2A 2021-05-07 2021-05-07 Data processing method and device based on financial core batch transaction scene Pending CN113159968A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110493686.2A CN113159968A (en) 2021-05-07 2021-05-07 Data processing method and device based on financial core batch transaction scene

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110493686.2A CN113159968A (en) 2021-05-07 2021-05-07 Data processing method and device based on financial core batch transaction scene

Publications (1)

Publication Number Publication Date
CN113159968A true CN113159968A (en) 2021-07-23

Family

ID=76873756

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110493686.2A Pending CN113159968A (en) 2021-05-07 2021-05-07 Data processing method and device based on financial core batch transaction scene

Country Status (1)

Country Link
CN (1) CN113159968A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117437013A (en) * 2023-12-21 2024-01-23 成都房联云码科技有限公司 Special maintenance fund settlement method and system based on double-account system
CN117648519A (en) * 2023-12-15 2024-03-05 集友科技创新(深圳)有限公司 Method and device for calculating demand deposit interest in time sharing mode

Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20040002807A (en) * 2003-07-12 2004-01-07 주식회사 조흥은행 System for managing account aggregation being used in transaction of bank and method therefor
CN101556678A (en) * 2009-05-21 2009-10-14 中国建设银行股份有限公司 Processing method of batch processing services, system and service processing control equipment
CN101996380A (en) * 2009-08-11 2011-03-30 中国工商银行股份有限公司 Method, device and system for searching incorrect account
CN107886427A (en) * 2017-11-07 2018-04-06 中国银行股份有限公司 A kind of methods of figuring interest and system
CN108319521A (en) * 2018-01-29 2018-07-24 中国工商银行股份有限公司 It is automatic to mend account processing method and processing device
CN109493201A (en) * 2018-09-18 2019-03-19 深圳壹账通智能科技有限公司 Account checking method, device, computer equipment and storage medium
CN110046988A (en) * 2019-04-18 2019-07-23 重庆天蓬网络有限公司 A kind of batch processing system operational approach, device, medium and electronic equipment
CN110134701A (en) * 2019-04-30 2019-08-16 阿里巴巴集团控股有限公司 A kind of buffering benefit account method and device
CN110175900A (en) * 2019-04-30 2019-08-27 阿里巴巴集团控股有限公司 A kind of buffering benefit account method and device
CN110264328A (en) * 2019-06-14 2019-09-20 深圳前海微众银行股份有限公司 Account checking method, device, equipment, system and computer readable storage medium
CN110634066A (en) * 2019-09-20 2019-12-31 中国银行股份有限公司 Method, device and equipment for determining settlement interest

Patent Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20040002807A (en) * 2003-07-12 2004-01-07 주식회사 조흥은행 System for managing account aggregation being used in transaction of bank and method therefor
CN101556678A (en) * 2009-05-21 2009-10-14 中国建设银行股份有限公司 Processing method of batch processing services, system and service processing control equipment
CN101996380A (en) * 2009-08-11 2011-03-30 中国工商银行股份有限公司 Method, device and system for searching incorrect account
CN107886427A (en) * 2017-11-07 2018-04-06 中国银行股份有限公司 A kind of methods of figuring interest and system
CN108319521A (en) * 2018-01-29 2018-07-24 中国工商银行股份有限公司 It is automatic to mend account processing method and processing device
CN109493201A (en) * 2018-09-18 2019-03-19 深圳壹账通智能科技有限公司 Account checking method, device, computer equipment and storage medium
CN110046988A (en) * 2019-04-18 2019-07-23 重庆天蓬网络有限公司 A kind of batch processing system operational approach, device, medium and electronic equipment
CN110134701A (en) * 2019-04-30 2019-08-16 阿里巴巴集团控股有限公司 A kind of buffering benefit account method and device
CN110175900A (en) * 2019-04-30 2019-08-27 阿里巴巴集团控股有限公司 A kind of buffering benefit account method and device
CN110264328A (en) * 2019-06-14 2019-09-20 深圳前海微众银行股份有限公司 Account checking method, device, equipment, system and computer readable storage medium
CN110634066A (en) * 2019-09-20 2019-12-31 中国银行股份有限公司 Method, device and equipment for determining settlement interest

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117648519A (en) * 2023-12-15 2024-03-05 集友科技创新(深圳)有限公司 Method and device for calculating demand deposit interest in time sharing mode
CN117648519B (en) * 2023-12-15 2024-07-05 集友科技创新(深圳)有限公司 Method and device for calculating demand deposit interest in time sharing mode
CN117437013A (en) * 2023-12-21 2024-01-23 成都房联云码科技有限公司 Special maintenance fund settlement method and system based on double-account system
CN117437013B (en) * 2023-12-21 2024-03-26 成都房联云码科技有限公司 Special maintenance fund settlement method and system based on double-account system

Similar Documents

Publication Publication Date Title
US8666889B2 (en) Methods and apparatus for funding transactions using debit cards issued by one institution and funds from accounts at other institutions
KR20220154242A (en) Method and system for transaction processing with complete cryptographic auditability
US20100076873A1 (en) Fee refund management
CN109727105A (en) Travel charge is self-service to check and write off processing method, device, equipment and computer storage medium
CN111797019B (en) Transaction accounting test method and device, electronic equipment and storage medium
US8146810B1 (en) Systems and methods for automated reward redemption
CN112163946A (en) Accounting processing method and device based on distributed transaction system
CN113159968A (en) Data processing method and device based on financial core batch transaction scene
CN111444073A (en) Method, device and system for testing performance of financial database
CN110889687A (en) Method and device for processing account balance under distributed architecture
US20150332391A1 (en) Non pre-approved channel filtering for card acquisition
CN112116451A (en) Data sorting method and device based on virtual account system
CN113010443B (en) Database test data generation method and device based on financial core transaction scene
CN113064837B (en) Database benchmark test method and device based on transaction scene
CN113298631A (en) Bearing processing method and device
CN111882323B (en) User financing risk control method and device based on cloud service lease
CN113191887A (en) Abnormal account early warning method and device
US7708193B1 (en) Systems and methods for automated reward redemption
CN115456747B (en) Automatic intelligent account settling method and device for ERP system and storage medium
CN113159967A (en) Data processing method and device based on financial core online transaction scene
CN111144892A (en) Counter exchange rate checking method and device
CN115082234A (en) In-system reconciliation method and system based on cash in and out mark
CN114139219A (en) Account balance tamper-proofing method
CN114239519A (en) Credit investigation data processing method and device, electronic equipment and computer readable medium
CN112102094A (en) Method and apparatus for securitization and stratification of assets

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