CN107590657A - A kind of bank data processing method and processing device - Google Patents
A kind of bank data processing method and processing device Download PDFInfo
- Publication number
- CN107590657A CN107590657A CN201710691655.1A CN201710691655A CN107590657A CN 107590657 A CN107590657 A CN 107590657A CN 201710691655 A CN201710691655 A CN 201710691655A CN 107590657 A CN107590657 A CN 107590657A
- Authority
- CN
- China
- Prior art keywords
- business
- background system
- information
- current
- service related
- 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.)
- Granted
Links
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The embodiments of the invention provide the service related information that a kind of bank data processing method and processing device, the current background system being related to by receiving current business are sent, the service related information includes account, class of business and business unique designation；According to the result that the business unique designation is inquired about in the business information storage table being locally stored, to the business information storage table execution information write operation；According to the result that the business unique designation is inquired about in the accuracy table being locally stored, state write operation is performed to the accuracy table；According to the processing sequence residing for all the background system states and current business that current business is related to, judge whether the service related information to each background system corresponding to backstage auditing system transmission current business, to handle the service related information of each background system corresponding to current business.This invention ensures that requirement of the bank transaction to the integrality of transaction data, accuracy and security.
Description
Technical field
The present invention relates to banking system technical field of data processing, more particularly to a kind of bank data processing method and dress
Put.
Background technology
With being continuously increased for banking, generally along with the multiple modules of background system when occurring a business operation
Data variation.Therefore guarantee data integrity, accuracy and security be always information technology important content, can be quickly
(being transmitted for example with message queue (MQ)) obtains complete, accurate and safe data message to be had for system robustness itself
Very big meaning.Therefore when a newly-built system module is to gather the data of original module, the method for data processing needs
The major issue considered is how to keep the complete, accurate and safe of data.
At present, the common data processing method for reconciliation system of the method for data processing.Reconciliation system is in night batch
When, be sent to reconciliation system data text by each system is to check the accounting data in each phylogenetic business
It is no consistent, complete etc..
Above technical scheme has the shortcomings that data are imperfect, data are inaccurate and safety coefficient is low.
The content of the invention
To solve problem of the prior art, the present invention proposes a kind of bank data processing method and processing device.The present invention passes through
Integrity data table, accuracy data table, table data store and business information processing logic, solve in the prior art that data are not
Completely, data are inaccurate and the problem of safety coefficient is low, ensure that the robustness of system.
The invention provides a kind of bank data processing method, this method includes：
Receive the service related information that the current background system that current business is related to is sent, the service related information bag
Contain：Account, class of business and business unique designation；
Inquire about in the business information storage table being locally stored and whether there is the business unique designation, the inquiry knot of generation first
Fruit；
According to first Query Result to the business information storage table execution information write operation；
Inquire about in the accuracy table being locally stored and whether there is the business unique designation, generate the second Query Result, institute
Accuracy table is stated for the processing sequence corresponding to record traffic residing for each background system state and current business；
State write operation is performed to the accuracy table according to second Query Result；
Processing sequence according to residing for all the background system states and current business that current business is related to judges whether need
Handle the service related information of each background system corresponding to current business；
If it is, the service related information of each background system corresponding to current business is sent to backstage auditing system, with place
Manage the service related information of each background system corresponding to current business.
In one embodiment, in addition to：Localling create integrality table, business information storage table and accuracy table；
The integrality table includes：Class of business and background system, the background system being related to for defining class of business；
The business information storage table includes：Account, class of business, business unique designation and background system Information；Institute
Background system Information is stated, for storing service related information corresponding to each background system；
The accuracy table includes：Account, sequence number, class of business, business unique designation and background system state；After described
Platform system mode includes：Have been received by, do not receive and uncorrelated, for storing the state of each background system；The numbering of the sequence number
Rule is, in account corresponding to the sequence number, me is used according to the order for the service related information for receiving different business species
Primary numerical order writes the sequence number.
In one embodiment, when first Query Result is business be present in the business information storage table uniquely to mark
During will；
It is described that the business information storage table execution information write operation is included according to first Query Result：
The service related information that current background system is sent is write in corresponding background system Information.
In one embodiment, it is unique for business is not present in the business information storage table when first Query Result
During mark；
It is described that the business information storage table execution information write operation is included according to first Query Result：
The first data record is inserted in the business information storage table；First data record includes：The business
The account of relevant information, the class of business of the service related information, the service related information business unique designation and after
Platform system information column；
The service related information for sending current background system in first data record writes corresponding backstage
In system Information.
In one embodiment, when second Query Result is the business unique designation be present in the accuracy table
When；
It is described that accuracy table execution state write operation is included according to second Query Result：
Background system state corresponding to current background system is updated in the accuracy table.
In one embodiment, when second Query Result is uniquely to be marked in the absence of the business in the accuracy table
During will；
It is described that accuracy table execution state write operation is included according to second Query Result：
The second data record is inserted in the accuracy table；Second data record includes：The related letter of the business
The account of breath, the sequence number of the service related information, the class of business of the service related information, the service related information
Business unique designation and background system state；
The class of business of the service related information sent according to current background system obtains currently in the integrality table
All background systems that business is related to, initialize all background system states in second data record；
Background system state corresponding to current background system is updated in the background system state of second data record.
In one embodiment, it is described according to residing for all the background system states and current business that current business is related to
Processing sequence judges whether to need to handle the service related information of each background system corresponding to current business, including：
Judge whether all background system states that the current business is related to are to have been received by and current business sequence number is
Minimum sequence number in the no account for current business.
In one embodiment, the business phase that each background system corresponding to current business is sent to backstage auditing system
Information is closed, to handle the service related information of each background system corresponding to current business, including：
By the business unique designation obtain that current business in the business information storage table that is locally stored is related to it is each after
The service related information of platform system；
Each service related information being related to backstage auditing system transmission current business；
Delete in the business information storage table current business number in the record of current service data and the accuracy table
According to record.
Bank data processing method provided by the invention, solve in the prior art that data are imperfect, data are inaccurate and
The problem of safety coefficient is low.Bank data processing method provided by the invention, store what miscellaneous service was related to by integrality table
Background system, the business datum of each background system of business datum storage table storage and accuracy table storage current business are related to each
Background system state, ensure that the complete card of a banking business data and accurate, and most at last current business be related to it is each
The business information of background system is sent to the logic that background audit system is handled simultaneously, ensure that the safety of bank transaction
Property, so as to ensure that the robustness of banking system.
Present invention also offers a kind of bank data processing unit, including：
Information receiving unit, the service related information sent for receiving the current background system that current business is related to, institute
Service related information is stated to include：Account, class of business and business unique designation；
First query unit, uniquely marked with the presence or absence of the business for inquiring about in the business information storage table being locally stored
Will, generate the first Query Result；
First writing unit, for being write according to first Query Result to the business information storage table execution information
Operation；
Second query unit, it whether there is the business unique designation for inquiring about in the accuracy table being locally stored, it is raw
Into the second Query Result, the accuracy table is used for the place corresponding to record traffic residing for each background system state and current business
Make sequence in order；
Second writing unit, for performing state write operation to the accuracy table according to second Query Result；
Judging unit, it is suitable for the processing according to residing for all the background system states and current business that current business is related to
Sequence judges whether to need the service related information for handling each background system corresponding to current business；
Processing unit, the related letter of business for sending each background system corresponding to current business to backstage auditing system
Breath, to handle the service related information of each background system corresponding to current business.
In one embodiment, in addition to：Tables of data creating unit, for localling create integrality table, business information
Storage table and accuracy table；
The integrality table includes：Class of business and background system, the background system being related to for defining class of business；
The business information storage table includes：Account, class of business, business unique designation and background system Information；Institute
Background system Information is stated, for storing service related information corresponding to each background system；
The accuracy table includes：Account, sequence number, class of business, business unique designation and background system state；After described
Platform system mode includes：Have been received by, do not receive and uncorrelated, for storing the state of each background system；The numbering of the sequence number
Rule is, in account corresponding to the sequence number, me is used according to the order for the service related information for receiving different business species
Primary numerical order writes the sequence number.
In one embodiment, first writing unit is specifically used for：Write in corresponding background system Information
The service related information that current background system is sent.
In one embodiment, first writing unit includes：
First Data insertion module, for inserting the first data record in the business information storage table；Described first
Data record includes：The related letter of the account of the service related information, the class of business of the service related information, the business
The business unique designation and background system Information of breath；
First information writing module, the business for sending current background system in first data record are related
In background system Information corresponding to information write-in.
In one embodiment, second writing unit is specifically used for：Current background is updated in the accuracy table
Background system state corresponding to system.
In one embodiment, second writing unit includes：
Second Data insertion module, for inserting the second data record in the accuracy table；The second data note
Record includes：The account of the service related information, the sequence number of the service related information, the business kind of the service related information
Class, the business unique designation of the service related information and background system state；
Initialization module, for the class of business of service related information that is sent according to current background system described complete
Property table in obtain all background systems for being related to of current business, initialize all background system shapes in second data record
State；
Second information writing module, for updating current background system in the background system state of second data record
Background system state corresponding to system.
In one embodiment, the judging unit is specifically used for：Judge all backstage systems that the current business is related to
System state whether be have been received by and current business sequence number whether be current business account in minimum sequence number.
In one embodiment, the processing unit includes：
Obtain information module, for by the business unique designation obtain in the business information storage table that is locally stored when
The service related information for each background system that preceding business is related to；
Information module is sent, for each service related information being related to backstage auditing system transmission current business；
Information module is deleted, for deleting in the business information storage table record of current service data and described accurate
The record of current service data in property table.
Bank data processing unit provided by the invention, can solve in the prior art that data are imperfect, data are inaccurate
And safety coefficient it is low the shortcomings that.The complete of transaction data is ensured by the first query unit, the second query unit and judging unit
Property and accuracy, and complete transaction data is most always sent to the data process method of background audit system, it ensure that friendship
Easy security, the defects of so as to overcome in the prior art.
The problem of data are imperfect, data are inaccurate and safety coefficient is low in being merchandised for current bank data, the present invention
Embodiment provides a kind of bank data processing method and processing device, receives the industry that the current background system that current business is related to is sent
Business relevant information, the service related information include：Account, class of business and business unique designation；Inquire about the industry being locally stored
It whether there is the business unique designation in business message store table, generate the first Query Result；According to first Query Result
To the business information storage table execution information write operation；Inquire about in the accuracy table being locally stored and whether there is the business
Unique designation, the second Query Result is generated, the accuracy table is for each background system state corresponding to record traffic and currently
Processing sequence residing for business；State write operation is performed to the accuracy table according to second Query Result；According to work as
The processing sequence residing for all background system states and current business that preceding business is related to judges whether to need to handle current business
The service related information of corresponding each background system；If it is, send each backstage corresponding to current business to backstage auditing system
The service related information of system, to handle the service related information of each background system corresponding to current business.This invention ensures that
The integrality and accuracy of data during one transaction occur for bank, while by handling the service related information of each background system
Logic, the security of transaction is ensure that, meet complete, the accurate and safe requirement of current data transaction.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can be with
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is a kind of flow chart for bank data processing method that the application proposes；
Fig. 2 is the integrality table structure chart of the embodiment of the application one；
When Fig. 3 A, Fig. 3 B, Fig. 3 C and Fig. 3 D are that the business information storage table of the embodiment of the application one receives different pieces of information
Structure chart；
Structure chart when Fig. 4 A, Fig. 4 B, Fig. 4 C and Fig. 4 D are the accuracy table reception different pieces of informations of the embodiment of the application one；
Fig. 5 is the flow chart of data processing figure of another embodiment of the application；
Fig. 6 is a kind of structural representation of bank data processing unit of the application；
Fig. 7 is the structural representation of the tables of data creating unit of the embodiment of the application one；
Fig. 8 is the structural representation of the first writing unit of the embodiment of the application one；
Fig. 9 is the structural representation of the second writing unit of the embodiment of the application one；
Figure 10 is the structural representation of the processing unit of the embodiment of the application one.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other under the premise of creative work is not made
Embodiment, belong to the scope of protection of the invention.
The embodiments of the invention provide a kind of bank data processing method, its flow chart is as shown in figure 1, including following step
Suddenly：
S101：Receive the service related information that the current background system that current business is related to is sent, the related letter of the business
Breath includes：Account, class of business and business unique designation；
S102：Inquire about in the business information storage table being locally stored and whether there is the business unique designation, generation first
Query Result；
S103：According to first Query Result to the business information storage table execution information write operation；
S104：Inquire about in the accuracy table being locally stored and whether there is the business unique designation, the inquiry knot of generation second
Fruit, the accuracy table are used for the processing sequence corresponding to record traffic residing for each background system state and current business；
S105：State write operation is performed to the accuracy table according to second Query Result；
S106：Processing sequence according to residing for all the background system states and current business that current business is related to judges
The no service related information for needing to handle each background system corresponding to current business；
S107：If it is, the service related information of each background system corresponding to current business is sent to backstage auditing system,
To handle the service related information of each background system corresponding to current business.
Flow as shown in Figure 1 is understood, the embodiments of the invention provide a kind of bank data processing system and method, is passed through
Receive account, class of business and the business unique designation for the service related information that the current background system that current business is related to is sent
Etc. information, inquire about in the business information storage table being locally stored and whether there is business unique designation, according to Query Result to business
Message store table execution information write operation；Inquire about in the accuracy table being locally stored and whether there is business unique designation, wherein
Accuracy table is used for the processing sequence corresponding to record traffic residing for each background system state and current business, according to Query Result
State write operation is performed to accuracy table；According to residing for all the background system states and current business that current business is related to
Processing sequence judges whether to handle the service related information of each background system corresponding to current business.This invention ensures that bank is sent out
The integrality and accuracy of data during a raw transaction, while the logic of the service related information by handling each background system,
The security of transaction is ensure that, meets complete, the accurate and safe requirement of current data transaction.
In above-mentioned S101, service related information includes account, class of business and business unique designation etc., and the present invention is not with this
It is limited.
In one embodiment, bank data processing system receives the business phase that the current background system that current business is related to is sent
Information is closed, the service related information includes：Account, class of business and business unique designation etc., the present invention is not limited.
When it is implemented, bank data processing system is localling create integrality table, business information storage table and accuracy
Table.
The integrality table includes：Class of business and background system, the background system being related to for defining class of business.Figure
2 be the integrality table structure of the embodiment of the application one.As shown in Fig. 2 integrality table includes class of business and background system, it is used for
The background system that class of business is related to is defined, ensures the complete of data.Wherein banking species include withdraw the money, it is remitted and cross-border
Any banking, the present invention such as remittance are not limited.Background system is related to all including different classs of business
The set of background system.Integrality table defines the background system that the every kind of class of business of bank is related to, and is used as subsequent treatment mistake
The basic data of journey.
The business information storage table includes：Account, class of business, business unique designation and background system Information, its
Middle background system Information, for storing service related information corresponding to each background system.Fig. 3 is the industry of the embodiment of the application one
Business message store table structure.As shown in figure 3, business information storage table includes account, class of business, business unique designation and backstage
System information column, for storing the business information of every kind of class of business.Wherein banking species include withdraw the money, it is remitted and cross-border
Any banking, the present invention such as remittance are not limited.Each background system Information is used to store each background system pair
The business information answered, background system Information are the set for the background system that each class of business is related to.Every banking has
Unique business unique designation, the background system that every banking is related to include this business unique designation.
The accuracy table includes：Account, sequence number, class of business, business unique designation and background system state, wherein after
Platform system mode includes：Have been received by, do not receive and uncorrelated, for storing the state of each background system；The coding rule of sequence number
For in account corresponding to the sequence number, according to the order for the service related information for receiving different business species with Arabic number
Word order writes the sequence number.Fig. 4 is the accuracy table of the embodiment of the application one.As shown in figure 4, accuracy table include account,
Sequence number, class of business, business unique designation and background system state, the state for storing background system ensure the standard of data
Really.The coding rule of wherein sequence number is, according to the service related information for receiving different business species in account corresponding to sequence number
Order write the sequence number with Arabic numerals order.Banking species include withdraw the money, it is remitted and it is cross-border remittance etc. it is any
A kind of banking, the present invention are not limited.Each background system state is used to store reception business corresponding to each background system
The state of information, background system state include having been received by, not received and uncorrelated three kinds of states.Background system state is each business
The set for the background system state that species is related to.Every banking has unique business unique designation, every banking
The background system being related to includes this business unique designation.
In above-mentioned S102, the first Query Result corresponds to business unique designation and is present in the business information storage being locally stored
One of two kinds of results of business information storage table that table or be not present in is locally stored.
In one embodiment, inquire about and whether there is the business unique designation in the business information storage table being locally stored, it is raw
Into the first Query Result.
In above-mentioned S103, information write operation corresponds to write-in data and insertion a data record writes two kinds of data again
Operation.
In one embodiment, according to first Query Result to the business information storage table execution information write operation.
When it is implemented, when the first Query Result is business unique designation be present in business information storage table, corresponding
Background system Information in write the service related information that current background system is sent.
When it is implemented, when the first Query Result is that business unique designation is not present in business information storage table, in institute
State and the first data record is inserted in business information storage table, wherein the first data record includes：Account, the industry of service related information
The class of business for relevant information of being engaged in, the business unique designation and background system Information of service related information.Remember in the first data
In background system Information corresponding to the service related information write-in for sending current background system in record.
In above-mentioned S104, the second Query Result correspond to business unique designation be present in the accuracy table that is locally stored or
It is not present in one of two kinds of results of accuracy table for being locally stored.
In one embodiment, inquire about and whether there is the business unique designation in the accuracy table being locally stored, generation second
The processing that Query Result, wherein accuracy table are used for corresponding to record traffic residing for each background system state and current business is suitable
Sequence.
In above-mentioned S105, state write operation corresponds to renewal background system state and insertion a data record updates again
The two kinds of operations of background system state.
In one embodiment, state write operation is performed to the accuracy table according to second Query Result.
When it is implemented, when the second Query Result is business unique designation be present in accuracy table, in accuracy table
Update background system state corresponding to current background system.
When it is implemented, when the second Query Result is that business unique designation is not present in the accuracy table, accurate
The second data record is inserted in property table, wherein the second data record includes：The related letter of the account of service related information, the business
The sequence number of breath, the class of business of service related information, the business unique designation of service related information and background system state.According to
The class of business for the service related information that current background system is sent obtains the institute that current business is related in the integrality table
There is a background system, all background system states in initialising second data record, wherein the background system related to current business
State initialization is initialized as uncorrelated not receive to the incoherent background system of current business.In the second data record
Background system state corresponding to updating current background system in background system state, is updated to have been received by state.
In above-mentioned S106, all background system states is have been received by, not received and one of uncorrelated three kinds of states, processing are suitable
Sequence corresponds to current business sequence number.
In one embodiment, according to the processing sequence residing for all the background system states and current business that current business is related to
Judge whether to need the service related information for handling each background system corresponding to current business；
When it is implemented, the processing sequence according to residing for all the background system states and current business that current business is related to
The service related information for judging whether to need to handle each background system corresponding to current business includes：Judge that the current business relates to
And all background system states whether be have been received by and current business sequence number whether be current business account in it is minimum
Sequence number.
In above-mentioned S107, processing current business corresponds to the data note that current business is sent and deleted to backstage auditing system
Record.The data record of current business corresponds in business information storage table the data record and accuracy table for the current business inserted
The data record of the current business of middle insertion.
In one embodiment, if it is, sending the business phase of each background system corresponding to current business to backstage auditing system
Information is closed, to handle the service related information of each background system corresponding to current business.
When it is implemented, the service related information of each background system includes corresponding to processing current business：By business only
One mark obtains the service related information of each background system that current business is related in the business information storage table being locally stored.To
Background audit system sends each service related information that current business is related to, and deletes current business in the business information storage table
The record of current service data in the record of data and the accuracy table.
According to above-mentioned steps, the present embodiment passes through integrality table, business storage table and the side of accuracy table and data processing
Method, solve the problems, such as that data are imperfect during banking system one transaction of generation, inaccurate and safety coefficient is low.
In another embodiment of the present invention, there is provided a kind of bank data processing method, its flow chart as shown in figure 5, including
Following steps：
S501：Receive MQ information.
When it is implemented, service related information is not limited with MQ information transfers, the present invention.Bank data processing system
Being sequentially received the business phase relation information of background system transmission includes：The MQ information for the system A transmissions that withdrawal business is related to, take
The MQ information for the system C system transmission that the MQ information for the system B transmissions that money business is related to, money transfer transactions are related to, money transfer transactions relate to
And the MQ information that sends of system B, the MQ information that sends of the system C that is related to of withdrawal business.MQ information includes account, business kind
The information such as class, business unique designation.
S502：Judgement business unique designation number whether there is in the business information storage table being locally stored.
When it is implemented, the MQ that the system A that the withdrawal business that bank data processing system handles reception first is related to is sent
Information.The inquiry business unique designation first in the business information storage table being locally stored, judge the system A that withdrawal business is related to
The business unique designation number of the MQ information of transmission whether there is in the business information storage table being locally stored.If withdrawal business
The business unique designation number for the MQ information that the system A being related to is sent is present in the business information storage table being locally stored, and enters
S503；If the business unique designation number for the MQ information that the system A that withdrawal business is related to is sent is not present in the industry being locally stored
It is engaged in message store table, into S504.
S504：A record is inserted in the business information storage table being locally stored, and current MQ data messages are stored in
Background system Information corresponding to current business.
When it is implemented, as shown in Figure 3A, recorded first in the business information storage table insertion a data being locally stored,
Account is 62178888, and class of business is withdraws the money, and business unique designation is x1, and the Information init state of each background system is
It is empty.Secondly system A information corresponding to the MQ information deposit current account withdrawal business that system A withdrawal business being related to is sent
In column, the information of system A Information is MQ1-A information by the space-variant of initial storage.Now, the withdrawal row of account 62178888
In do not receive the system modes of MQ data messages and remain sky information.
S505：Judgement business unique designation number whether there is in the accuracy table being locally stored.
When it is implemented, after the MQ information that the system A that the withdrawal business that bank data processing system receives is related to is sent, lead to
Cross MQ information services species and the background system that withdrawal business is related to is obtained in the integrality table being locally stored.As shown in Fig. 2 take
The background system that money business is related to includes system A, system B and system C.Then inquiry whether there is withdrawal industry in accuracy table
The business unique designation for the MQ information that the system A for being engaged in being related to is sent.If in accuracy table there is withdrawal business and be related in inquiry
System A send MQ information business unique designation, into S506；If withdrawal business is not present in inquiry in accuracy table
The business unique designation for the MQ information that the system A being related to is sent, into S507.
S507：A data record is inserted in the accuracy table being locally stored.
When it is implemented, as shown in Figure 4 A, it is in the accuracy table insertion a data record being locally stored, account first
62178888, the class of business of serial number 001 is withdraws the money, and business unique designation is x1, the shape for the background system that withdrawal business is related to
For state init state not receive, the background system state not being related to is uncorrelated.Secondly system A's withdrawal business being related to
State is changed into having been received by from not receiving for initial storage.Now, the background system being related in the withdrawal row of account 62178888 is not
The system mode for receiving MQ data messages is remained and not received.The coding rule of wherein sequence number is, in account 62178888
In, first MQ data message for receiving withdrawal class of business, therefore in account 62178888 withdrawal business serial number
001。
S508：Judge whether that the background system state that current business is related to is " having been received by ".
When it is implemented, as shown in Figure 4 A, by business unique designation, judge that the withdrawal business of account 62178888 is related to
Background system state whether be to have been received by.If the background system state that the withdrawal business of account 62178888 is related to is
State is had been received by, into S509；It is to have received that if the background system state that the withdrawal business of account 62178888 is related to, which is not,
To state, next MQ data message is handled into S501.
S509：Whether the sequence number for judging MQ data messages is smallest sequence number in the account.
When it is implemented, as shown in Figure 4 A, whether the sequence number for judging the withdrawal business of account 62178888 is account
Minimum sequence number in 62178888.If sequence number minimum in account 62178888, into S610；If not account
Minimum sequence number in 62178888, next MQ data message is handled into S501.
The MQ information that the system B that the withdrawal business that bank data processing system processing receives is related to is sent.
When it is implemented, the industry for the system B that withdrawal business is related to is searched in local service message store table according to S502
Business unique designation is existing, into S503.
S503：Update the information of system corresponding to withdrawal business in corresponding account in the business information storage table being locally stored
MQ data messages in column.
When it is implemented, as shown in Figure 3 B, system B Information is by initially depositing in the withdrawal row of more New Account 62178888
The dummy status of storage is changed into MQ1-B information.Now, the system shape of MQ data messages is not received in the withdrawal row of account 62178888
State is sky, into S505.
The business unique designation x1 for the system B that withdrawal business is related to is searched in the accuracy table being locally stored according to S505
It is existing, into S506.
S506：Update the state of system B corresponding to withdrawal business in corresponding account in the accuracy table being locally stored.
In the accuracy table being locally stored according to S506, as shown in Figure 4 B, it is in the withdrawal row of more New Account 62178888
System B state is changed into having been received by state from the state that do not receive of initial storage, into S508.
According to the S508 system C being related to due to withdrawal business state still not receive state, therefore go successively to S501
Handle next MQ data message.
Bank data processing system is handled successively receives MQ information and remittance industry that the system C that money transfer transactions are related to is sent
The MQ information that the system B for being engaged in being related to is sent.
When it is implemented, according to the step of S502 to S509, as shown in Figure 3 C, in the more remittance house of New Account 62178888
System B and system C Information are changed into MQ2-B and MQ2-C information from the dummy status of initial storage；As shown in Figure 4 C, according to
In the accuracy table that S506 is locally stored, system B and system C state are by initially depositing in the more remittance house of New Account 62178888
The state that do not receive of storage is changed into having been received by state, into S508.
Judge whether that the background system state that current business is related to is " having been received by " according to S508, as shown in Figure 4 C, can
Know that the background system state that money transfer transactions corresponding to the sequence number 002 of account 62178888 are related to is " having been received by ".Such as Fig. 5 institutes
Show, whether the sequence number that MQ data messages are judged into S509 is smallest sequence number in the account, due to the serial number 002 of money transfer transactions
It is not sequence number minimum in account 62178888, next MQ data message is handled into S501.
Bank data processing system processing receives the MQ information that the system C that withdrawal business is related to is sent.
When it is implemented, according to the step of S502 to S509, the business information storage table being locally stored as shown in Figure 3 D, this
The accuracy table of ground storage, as shown in Figure 4 D.As shown in figure 5, judge whether the sequence number of MQ data messages is the account into S509
Smallest sequence number in number, because the serial number 001 of withdrawal business is that sequence number minimum in account 62178888 enters S610.
S610：Send MQ data messages.
When it is implemented, bank data processing system is by withdrawal industry corresponding to sequence number 001 minimum in account 62178888
The MQ data messages that the Information for the background system for being engaged in being related to stores, are sent to background audit system, carry out subsequent treatment.Withdraw the money
The MQ data messages for the background system that business is related to include：The MQ1-A, system B of system A Information storage Information storage
MQ1-B and system C Information storage MQ1-C.
S611：The MQ data messages in accuracy table and business information storage table are deleted to record
When it is implemented, deleting in accuracy table, the withdrawal data record of sequence number 001 and business are believed in account 62178888
The withdrawal data record of account 62178888 in storage table is ceased, next MQ data message is handled into S501.
Bank data processing method provided by the invention, solve in the prior art that data are imperfect, data are inaccurate and
The problem of safety coefficient is low.Bank data processing method provided by the invention, store what miscellaneous service was related to by integrality table
Background system, the business datum of each background system of business datum storage table storage and accuracy table storage current business are related to each
Background system state, ensure that the complete card of a banking business data and accurate, and most at last current business be related to it is each
The business information of background system is sent to the logic that background audit system is handled simultaneously, ensure that and a banking occurs
Security, so as to ensure that the robustness of banking system.
Based on conceiving with above-mentioned bank data processing method identical application, the application provides a kind of bank data processing dress
Put, as described in example below.Because the bank data processing unit solves the principle and bank data processing method phase of problem
Seemingly, therefore the implementation of the bank data processing unit may refer to the implementation of bank data processing method, and it is no longer superfluous to repeat part
State.
Fig. 6 is the structural representation of the bank data processing unit of the embodiment of the present application, as shown in fig. 6, the bank data
Processing unit includes：Information receiving unit 601, the first query unit 602, the first writing unit 603, the second query unit 604,
Second writing unit 605, judging unit 606 and processing unit 607.
Information receiving unit 601, the service related information sent for receiving the current background system that current business is related to,
The service related information includes：Account, class of business and business unique designation；
First query unit 602, it whether there is the business only for inquiring about in the business information storage table being locally stored
One mark, generates the first Query Result；
First writing unit 603, for according to first Query Result to the business information storage table execution information
Write operation；
Second query unit 604, it whether there is the business unique designation for inquiring about in the accuracy table being locally stored,
The second Query Result is generated, the accuracy table is used for residing for each background system state and current business corresponding to record traffic
Processing sequence；
Second writing unit 605, for performing state write-in behaviour to the accuracy table according to second Query Result
Make；
Judging unit 606, for the place according to residing for all the background system states and current business that current business is related to
Sequence is made in order to judge whether to need the service related information for handling each background system corresponding to current business；
Processing unit 607, the business for sending each background system corresponding to current business to backstage auditing system are related
Information, to handle the service related information of each background system corresponding to current business.
In one embodiment, as shown in fig. 7, the bank data processing unit also includes：Tables of data creating unit 608,
For localling create integrality table 701, business information storage table 702 and accuracy table 703.
Integrality table 701 includes：Class of business and background system, the background system being related to for defining class of business；
Business information storage table 702 includes：Account, class of business, business unique designation and background system Information, wherein
Background system Information, for storing service related information corresponding to each background system；
Accuracy table 703 includes：Account, sequence number, class of business, business unique designation and background system state, wherein after
Platform system mode includes：Have been received by, do not receive and uncorrelated, for storing the state of each background system.The coding rule of sequence number
For in account corresponding to the sequence number, according to the order for the service related information for receiving different business species with Arabic number
Word order writes the sequence number.
In one embodiment, the first writing unit 603 is specifically used for：Write-in is worked as in corresponding background system Information
The service related information that back-fore ground system is sent.
In one embodiment, as shown in figure 8, the first writing unit 603 includes：First Data insertion module 801 and
One information writing module 802.
First Data insertion module 801, for inserting the first data record in the business information storage table；Described
One data record includes：The account of the service related information, the class of business of the service related information, the business are related
The business unique designation and background system Information of information；
First information writing module 802, for the business for sending current background system in first data record
In background system Information corresponding to relevant information write-in.
In one embodiment, the second writing unit 605 is specifically used for：Current background system is updated in the accuracy table
Background system state corresponding to system.
In one embodiment, as shown in figure 9, the second writing unit 605 includes：It is second Data insertion module 901, initial
Change the information writing module 903 of module 902 and second.
Second Data insertion module 901, for inserting the second data record in the accuracy table；Second data
Record includes：The account of the service related information, the sequence number of the service related information, the business of the service related information
Species, the business unique designation of the service related information and background system state；
Initialization module 902, for the class of business of service related information that is sent according to current background system described
All background systems that current business is related to are obtained in integrality table, initialize all background systems in second data record
State, wherein the background system state initialization related to current business is not receive, with the incoherent backstage system of current business
State initialization of uniting is uncorrelated；
Second information writing module 903, before and after renewal is worked as in the background system state of second data record
Background system state corresponding to platform system.
In one embodiment, judging unit 606 is specifically used for：Judge all background systems that the current business is related to
State whether be have been received by and current business sequence number whether be current business account in minimum sequence number.
In one embodiment, as shown in Figure 10, processing unit 607 includes：Obtain information module 1001, send information mould
Block 1002 and deletion information module 1003.
Information module 1001 is obtained, for obtaining the business information storage table being locally stored by the business unique designation
The service related information for each background system that middle current business is related to；
Information module 1002 is sent, for each service related information being related to backstage auditing system transmission current business；
Information module 1003 is deleted, for deleting in the business information storage table record of current service data and described
The record of current service data in accuracy table.
Bank data processing system provided by the invention, can solve in the prior art that data are imperfect, data are inaccurate
And safety coefficient it is low the shortcomings that.Ensure that module ensures to hand over by completeness guarantee's module, business information memory module and accuracy
The integrality and accuracy of easy data, and the data processing that complete transaction data is most always sent to background audit system is patrolled
Volume, the security of transaction is ensure that, the defects of so as to overcome in the prior art.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or computer program
Product.Therefore, the present invention can use the reality in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Apply the form of example.Moreover, the present invention can use the computer for wherein including computer usable program code in one or more
The computer program production that usable storage medium is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.)
The form of product.
The present invention is the flow with reference to method according to embodiments of the present invention, equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that can be by every first-class in computer program instructions implementation process figure and/or block diagram
Journey and/or the flow in square frame and flow chart and/or block diagram and/or the combination of square frame.These computer programs can be provided
The processors of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that produced by the instruction of computer or the computing device of other programmable data processing devices for real
The device for the function of being specified in present one flow of flow chart or one square frame of multiple flows and/or block diagram or multiple square frames.
These computer program instructions, which may be alternatively stored in, can guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works so that the instruction being stored in the computer-readable memory, which produces, to be included referring to
Make the manufacture of device, the command device realize in one flow of flow chart or multiple flows and/or one square frame of block diagram or
The function of being specified in multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that counted
Series of operation steps is performed on calculation machine or other programmable devices to produce computer implemented processing, so as in computer or
The instruction performed on other programmable devices is provided for realizing in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in individual square frame or multiple square frames.
Apply specific embodiment in the present invention to be set forth the principle and embodiment of the present invention, above example
Explanation be only intended to help understand the present invention method and its core concept；Meanwhile for those of ordinary skill in the art,
According to the thought of the present invention, there will be changes in specific embodiments and applications, in summary, in this specification
Appearance should not be construed as limiting the invention.
Claims (16)
1. a kind of bank data processing method, it is characterised in that this method includes：
The service related information that the current background system that current business is related to is sent is received, the service related information includes：Account
Family, class of business and business unique designation；
Inquire about in the business information storage table being locally stored and whether there is the business unique designation, generate the first Query Result；
According to first Query Result to the business information storage table execution information write operation；
Inquire about in the accuracy table being locally stored and whether there is the business unique designation, generate the second Query Result, the standard
True property table is used for the processing sequence corresponding to record traffic residing for each background system state and current business；
State write operation is performed to the accuracy table according to second Query Result；
Processing sequence according to residing for all the background system states and current business that current business is related to judges whether to need to locate
Manage the service related information of each background system corresponding to current business；
If it is, sending the service related information of each background system corresponding to current business to backstage auditing system, worked as with processing
The service related information of each background system corresponding to preceding business.
2. bank data processing method according to claim 1, it is characterised in that also include：Localling create integrality
Table, business information storage table and accuracy table；
The integrality table includes：Class of business and background system, the background system being related to for defining class of business；
The business information storage table includes：Account, class of business, business unique designation and background system Information；After described
Platform system information column, for storing service related information corresponding to each background system；
The accuracy table includes：Account, sequence number, class of business, business unique designation and background system state；The backstage system
System state includes：Have been received by, do not receive and uncorrelated, for storing the state of each background system；The coding rule of the sequence number
For in account corresponding to the sequence number, according to the order for the service related information for receiving different business species with Arabic number
Word order writes the sequence number.
3. bank data processing method according to claim 2, it is characterised in that when first Query Result is described
When business unique designation in business information storage table be present；
It is described that the business information storage table execution information write operation is included according to first Query Result：
The service related information that current background system is sent is write in corresponding background system Information.
4. bank data processing method according to claim 2, it is characterised in that when first Query Result is described
When business unique designation being not present in business information storage table；
It is described that the business information storage table execution information write operation is included according to first Query Result：
The first data record is inserted in the business information storage table；First data record includes：The business is related
The account of information, the class of business of the service related information, the business unique designation of the service related information and backstage are
System Information；
Background system corresponding to the service related information write-in for sending current background system in first data record is believed
Cease in column.
5. bank data processing method according to claim 2, it is characterised in that when second Query Result is described
When the business unique designation in accuracy table be present；
It is described that accuracy table execution state write operation is included according to second Query Result：
Background system state corresponding to current background system is updated in the accuracy table.
6. bank data processing method according to claim 2, it is characterised in that when second Query Result is described
When the business unique designation being not present in accuracy table；
It is described that accuracy table execution state write operation is included according to second Query Result：
The second data record is inserted in the accuracy table；Second data record includes：The service related information
Account, the sequence number of the service related information, the class of business of the service related information, the business of the service related information
Unique designation and background system state；
The class of business of the service related information sent according to current background system obtains current business in the integrality table
All background systems being related to, initialize all background system states in second data record；
Background system state corresponding to current background system is updated in the background system state of second data record.
7. bank data processing method according to claim 2, it is characterised in that the institute being related to according to current business
There is a background system state and the processing sequence residing for current business judges whether to need to handle each backstage corresponding to current business and is
The service related information of system, including：
Judge all background system states that the current business is related to whether be have been received by and current business sequence number whether be
Minimum sequence number in the account of current business.
8. bank data processing method according to claim 2, it is characterised in that described sent to backstage auditing system is worked as
The service related information of each background system corresponding to preceding business, to handle the business of each background system corresponding to current business correlation
Information, including：
Each backstage that current business is related in the business information storage table being locally stored by business unique designation acquisition is
The service related information of system；
Each service related information being related to backstage auditing system transmission current business；
Delete in the business information storage table current service data in the record of current service data and the accuracy table
Record.
A kind of 9. bank data processing unit, it is characterised in that including：
Information receiving unit, the service related information sent for receiving the current background system that current business is related to, the industry
Business relevant information includes：Account, class of business and business unique designation；
First query unit, it whether there is the business unique designation for inquiring about in the business information storage table being locally stored,
Generate the first Query Result；
First writing unit, grasped for being write according to first Query Result to the business information storage table execution information
Make；
Second query unit, whether there is the business unique designation for inquiring about in the accuracy table that is locally stored, generate the
Two Query Results, the processing that the accuracy table is used for corresponding to record traffic residing for each background system state and current business are suitable
Sequence；
Second writing unit, for performing state write operation to the accuracy table according to second Query Result；
Judging unit, sentence for the processing sequence according to residing for all the background system states and current business that current business is related to
The disconnected service related information for whether needing to handle each background system corresponding to current business；
Processing unit, for sending the service related information of each background system corresponding to current business to backstage auditing system, with
Handle the service related information of each background system corresponding to current business.
10. bank data processing unit according to claim 9, it is characterised in that also include：Tables of data creating unit,
For localling create integrality table, business information storage table and accuracy table；
The integrality table includes：Class of business and background system, the background system being related to for defining class of business；
The business information storage table includes：Account, class of business, business unique designation and background system Information；After described
Platform system information column, for storing service related information corresponding to each background system；
The accuracy table includes：Account, sequence number, class of business, business unique designation and background system state；The backstage system
System state includes：Have been received by, do not receive and uncorrelated, for storing the state of each background system；The coding rule of the sequence number
For in account corresponding to the sequence number, according to the order for the service related information for receiving different business species with Arabic number
Word order writes the sequence number.
11. bank data processing unit according to claim 10, it is characterised in that first writing unit is specifically used
In：The service related information that current background system is sent is write in corresponding background system Information.
12. bank data processing unit according to claim 10, it is characterised in that first writing unit includes：
First Data insertion module, for inserting the first data record in the business information storage table；First data
Record includes：The account of the service related information, the class of business of the service related information, the service related information
Business unique designation and background system Information；
First information writing module, for the service related information for sending current background system in first data record
In background system Information corresponding to write-in.
13. bank data processing unit according to claim 10, it is characterised in that second writing unit is specifically used
In：Background system state corresponding to current background system is updated in the accuracy table.
14. bank data processing unit according to claim 10, it is characterised in that second writing unit includes：
Second Data insertion module, for inserting the second data record in the accuracy table；The second data record bag
Include：The account of the service related information, the sequence number of the service related information, the class of business of the service related information,
The business unique designation and background system state of the service related information；
Initialization module, for the class of business of service related information that is sent according to current background system in the integrality table
The middle all background systems for obtaining current business and being related to, initialize all background system states in second data record；
Second information writing module, for updating current background system pair in the background system state of second data record
The background system state answered.
15. bank data processing unit according to claim 10, it is characterised in that the judging unit is specifically used for：
Judge whether all background system states that the current business is related to are to have been received by and whether current business sequence number is current
Minimum sequence number in the account of business.
16. bank data processing unit according to claim 10, it is characterised in that the processing unit includes：
Information module is obtained, for obtaining current industry in the business information storage table being locally stored by the business unique designation
The service related information for each background system that business is related to；
Information module is sent, for each service related information being related to backstage auditing system transmission current business；
Information module is deleted, for deleting the record of current service data and the accuracy table in the business information storage table
The record of middle current service data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710691655.1A CN107590657B (en) | 2017-08-14 | 2017-08-14 | Bank data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710691655.1A CN107590657B (en) | 2017-08-14 | 2017-08-14 | Bank data processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107590657A true CN107590657A (en) | 2018-01-16 |
| CN107590657B CN107590657B (en) | 2021-08-20 |
Family
ID=61042476
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710691655.1A Active CN107590657B (en) | 2017-08-14 | 2017-08-14 | Bank data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107590657B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080097879A1 (en) * | 2006-10-20 | 2008-04-24 | Tsys Acquiring Solutions, L.L.C. | System and Method of Interfacing Web Services to Express Creation and Initialization of Merchant Accounts |
| CN101504754A (en) * | 2009-03-27 | 2009-08-12 | 中国工商银行股份有限公司 | Banking business data sorting and processing system based on image information |
| CN103366306A (en) * | 2013-06-28 | 2013-10-23 | 中国工商银行股份有限公司 | Shared capital data processing device and use method thereof |
| CN104767716A (en) * | 2014-01-03 | 2015-07-08 | 腾讯科技（深圳）有限公司 | Service request processing method and device |
-
2017
- 2017-08-14 CN CN201710691655.1A patent/CN107590657B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080097879A1 (en) * | 2006-10-20 | 2008-04-24 | Tsys Acquiring Solutions, L.L.C. | System and Method of Interfacing Web Services to Express Creation and Initialization of Merchant Accounts |
| CN101504754A (en) * | 2009-03-27 | 2009-08-12 | 中国工商银行股份有限公司 | Banking business data sorting and processing system based on image information |
| CN103366306A (en) * | 2013-06-28 | 2013-10-23 | 中国工商银行股份有限公司 | Shared capital data processing device and use method thereof |
| CN104767716A (en) * | 2014-01-03 | 2015-07-08 | 腾讯科技（深圳）有限公司 | Service request processing method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107590657B (en) | 2021-08-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106991165A (en) | Method, device and the electronic equipment of processing financial data based on block chain | |
| CN106649838A (en) | Data transmission method, block chain node and distributed database | |
| CN104867250B (en) | A kind of processing method and processing device of business handling data | |
| CN107507093A (en) | The data processing method and device of domestic customers demand for insurance | |
| CN106447426A (en) | Method and apparatus for settling earning distribution | |
| CN112204557A (en) | System and method for automated decentralized multilateral transaction processing | |
| CN106033510B (en) | A kind of user equipment recognition methods and system | |
| CN104508657B (en) | Mediation computing device and the method associated for producing semantic label | |
| CN109299222A (en) | Verification of data method and device | |
| CN110175916A (en) | Cash flow checking method and device | |
| CN106598946A (en) | Content extracting method and device | |
| CN107133289A (en) | A kind of method and apparatus of determination commercial circle | |
| CN109377224A (en) | Block chain method of commerce and device, electronic equipment | |
| CN106095972B (en) | Information classification method and device | |
| CN109543373A (en) | A kind of information identifying method and device based on user behavior | |
| CN106570097A (en) | Sequence generating method and device | |
| CN107403311A (en) | The recognition methods of account purposes and device | |
| CN110162570A (en) | The gradation acquisition methods and device of block chain data | |
| CN109800401A (en) | Information report automatic generation method and device | |
| CN110084690A (en) | Data processing method, device, computer installation and storage medium | |
| CN104699790B (en) | A kind of bank data relation establishing method and device | |
| US20140012763A1 (en) | Money transfer fraud prevention methods and systems | |
| CN104408183B (en) | The data lead-in method and device of data system | |
| Golumbia | Zealots of the Blockchain: the true believers of the Bitcoin cult | |
| CN110162521A (en) | A kind of payment system transaction data processing method and system |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |