CN110046877A - Account checking method and device, server - Google Patents
Account checking method and device, server Download PDFInfo
- Publication number
- CN110046877A CN110046877A CN201811450720.2A CN201811450720A CN110046877A CN 110046877 A CN110046877 A CN 110046877A CN 201811450720 A CN201811450720 A CN 201811450720A CN 110046877 A CN110046877 A CN 110046877A
- Authority
- CN
- China
- Prior art keywords
- data
- clearance
- tables
- idempotent
- write
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/085—Payment architectures involving remote charge determination or related payment systems
- G06Q20/0855—Payment architectures involving remote charge determination or related payment systems involving a third party
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Technology Law (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This specification embodiment provides a kind of account checking method and device, server.The account checking method includes: to receive the clearance data from liquidation organization；Idempotent tables of data is written into the clearance data；The idempotent tables of data includes that at least one is provided with the field of unique constraints and is previously written the accounting data from payment mechanism；According to the write-in of the clearance data as a result, determining the reconciliation state of the clearance data.
Description
Technical field
This specification embodiment is related to field of computer technology, in particular to a kind of account checking method and device, server.
Background technique
Third-party payment refers to the Third-party payment mechanism for having certain strength and prestige guarantee, signs using with each big bank
Mode about, the network payment mode for facilitating both parties to trade and docking with bank payment settlement system interface.
Due to Third-party payment reduce government, enterprise, direct-connected bank, public institution cost and ensured the interests of both parties
Deng advantage grown rapidly.
Normally, account number can be written in we's registration, relevant to transaction accounting data by Third-party payment mechanism
According to table.Bank can send clearance file to the Third-party payment mechanism.The Third-party payment mechanism can receive clearance
File；It can parse clearance file, obtain clearance data that bank registers, relevant to transaction；It can be by the clearance data
Write-in clearance tables of data.In this way in reconciliation, the Third-party payment mechanism can be by the accounting data table and the clearance
Tables of data carries out full table correlation inquiry, to realize accounting data and clear the verification between data.
Normally, the data volume in accounting data table and clearance tables of data is very more.It is needed during reconciliation
Full dose data in account tables of data and clearance tables of data are scanned for and checked, are possible to influence the property of database in this way
Can, cause the shake of database.
Summary of the invention
The purpose of this specification embodiment is to provide a kind of account checking method and device, server, to avoid in reconciliation process
The middle performance for influencing database.
To achieve the above object, this specification embodiment provides a kind of account checking method, comprising: receives from liquidation organization
Clear data；Idempotent tables of data is written into the clearance data；The idempotent tables of data includes that at least one is provided with uniqueness
The field of constraint and it is previously written the accounting data from payment mechanism；According to the write-in of the clearance data as a result, determining
The reconciliation state of the clearance data.
To achieve the above object, this specification embodiment provides a kind of account checking apparatus, comprising: receiving unit, for receiving
Clearance data from liquidation organization；R/w cell, for idempotent tables of data to be written in the clearance data；The idempotent tables of data
The field of unique constraints is provided with including at least one and is previously written the accounting data from payment mechanism；It determines single
Member, for the write-in according to the clearance data as a result, determining the reconciliation state of the clearance data.
To achieve the above object, this specification embodiment provides a kind of server, comprising: memory is calculated for storing
Machine instruction；Processor performs the steps of clearance data of the reception from liquidation organization for executing the computer instruction；
Idempotent tables of data is written into the clearance data；The idempotent tables of data includes the word that at least one is provided with unique constraints
Section and be previously written the accounting data from payment mechanism；According to the write-in of the clearance data as a result, determining the clearance
The reconciliation state of data.
For the technical solution provided by above this specification embodiment as it can be seen that in this specification embodiment, account server can
To receive the clearance data from liquidation organization；Idempotent tables of data, the idempotent tables of data can be written into the clearance data
It may include that at least one is provided with the field of unique constraints and is previously written the accounting data from payment mechanism；It can
With being written as a result, determining the reconciliation state of the clearance data according to the clearance data.So in the present embodiment, described
Account server, in conjunction with the unique constraints of idempotent tables of data, can carry out one by one clearance data when clearing data arrival
Verification, the influence so as to avoid reconciliation process to database performance.
Detailed description of the invention
In order to illustrate more clearly of this specification embodiment or technical solution in the prior art, below will to embodiment or
Attached drawing needed to be used in the description of the prior art is briefly described, it should be apparent that, the accompanying drawings in the following description is only
The some embodiments recorded in this specification, for those of ordinary skill in the art, in not making the creative labor property
Under the premise of, it is also possible to obtain other drawings based on these drawings.
Fig. 1 is a kind of schematic diagram of account checking method of this specification embodiment；
Fig. 2 is a kind of schematic diagram of account checking method of this specification embodiment；
Fig. 3 is a kind of flow chart of account checking method of this specification embodiment；
Fig. 4 is a kind of functional structure chart of account checking apparatus of this specification embodiment；
Fig. 5 is a kind of functional structure chart of server of this specification embodiment.
Specific embodiment
Below in conjunction with the attached drawing in this specification embodiment, the technical solution in this specification embodiment is carried out clear
Chu is fully described by, it is clear that described embodiment is only this specification a part of the embodiment, rather than whole implementation
Example.The embodiment of base in this manual, those of ordinary skill in the art are obtained without creative efforts
Every other embodiment, all should belong to this specification protection range.
Please refer to Fig. 1, Fig. 2 and Fig. 3.This specification embodiment provides a kind of data processing system.
In the present embodiment, the data processing system may include client.The client for example can for PC machine,
Server, industrial personal computer (industrial control computer), intelligent movable phone, Flat electronic equipment, portable computer (such as are taken down notes
This computer etc.), personal digital assistant (PDA) or desktop computer or intelligent wearable device etc..
In the present embodiment, the data processing system can also include the service server of Third-party payment mechanism.Institute
Stating Third-party payment mechanism for example may include Alipay, logical, the Baidu's wallet of wealth pair etc..The service server can be used for mentioning
For business service, such as provide the business services such as account charging, loan, shopping at network.The service server can be one
Server, alternatively, can also be the server cluster for including multiple servers.
In the present embodiment, the data processing system can also include the account server of Third-party payment mechanism.Institute
Stating account server may be used to provide book keeping operation and reconciliation service.The account server can be a server, alternatively, also
It can be the server cluster for including multiple servers.The account server and the service server can be respectively independent
Server, alternatively, same server can also be integrated in.The account server can be provided with accounting data table, idempotent
Tables of data and clearance tables of data.
The accounting data table can be used to save the accounting data of the Third-party payment mechanism.The accounting data table
It can have at least one field, the accounting data may include the element value corresponding at least one field.For example,
The accounting data table may include order number field, transaction amount field, transaction channel field, currency type field etc., the account
Data of being engaged in may include the elements value such as order number, transaction amount, transaction channel, currency type.The idempotent tables of data can be used for pair
Accounting data carries out idempotent processing, saves to avoid by duplicate accounting data to the accounting data table.The idempotent data
Table can have at least one field.In the actual process, can according to business need from the accounting data table choose to
A few field is as the field in the idempotent tables of data.It, can be from the accounting data table in a Sample Scenario
It chooses corresponding data value and is capable of the field (such as order number field) of one business of unique identification as the idempotent tables of data
In field.Unique constraints has can be set in some or all of idempotent tables of data field.Unique constraints can be protected
The data demonstrate,proved in field are unique in the idempotent tables of data.In this way by unique constraints, can realize to account
The idempotent of data is handled.The clearance tables of data can be used to save the clearance data of liquidation organization.The liquidation organization is for example
It may include bank, Unionpay etc..The clearance tables of data can have at least one field.Field in the clearance tables of data
It can be partly or entirely identical with the field in the accounting data table.The clearance data may include at least one element
Value.The type of element value can be partly or entirely identical in the type of element value and the accounting data in the clearance data.
The quantity of the accounting data table, the idempotent tables of data and the clearance tables of data can be respectively one.Or
Person can be used multiple tables of data and carry out storing data in the biggish situation of data scale, with maintain to data in tables of data into
Performance when row operation.The quantity of the accounting data table described in this way, the idempotent tables of data and the clearance tables of data can be with
It is respectively multiple.Specifically, the account server can be provided with multiple tables of data groups, and each tables of data group may include phase
Mutual corresponding accounting data table, idempotent tables of data and clearance tables of data.Accounting data table, idempotent data in each tables of data group
Table and clearance tables of data can respectively correspond table mark.For example, the account server can be provided with tables of data group A, B and
C.Tables of data group A may include accounting data Table A _ ZW, idempotent data Table A _ MD, clearance tables of data A_QS.Accounting data Table A _
The corresponding table mark of ZW can be A_ZW；The corresponding table mark of idempotent data Table A _ MD can be A_MD；Clear tables of data A_QS
Corresponding table mark can be A_QS.Tables of data group B may include accounting data table B_ZW, idempotent tables of data B_MD, clearance number
According to table B_QS.The corresponding table mark of accounting data table B_ZW can be B_ZW；Idempotent tables of data B_MD corresponding table mark can be with
For B_MD；Clearing the corresponding table mark of tables of data B_QS can be B_QS.Tables of data group C may include accounting data table C_ZW,
Idempotent tables of data C_MD, clearance tables of data C_QS.The corresponding table mark of accounting data table C_ZW can be C_ZW；Idempotent tables of data
The corresponding table mark of C_MD can be C_MD；Clearing the corresponding table mark of tables of data C_QS can be C_QS.
In the present embodiment, the data processing system can also include the authority server of liquidation organization.The clearance
Mechanism for example may include bank, Unionpay etc..The authority server may be used to provide payment services.The authority server
It can be a server, alternatively, can also be the server cluster for including multiple servers.
Based on the Third-party payment mechanism, user can be supplemented with money and (be also known as transferred to), clearing (also known as withdrawing deposit),
The operation such as pay and transfer accounts.Below for supplementing scene with money, the technical solution of this specification embodiment is discussed in detail.This scene is shown
The account that example is related to may include the first account, the second account and third account.First account may include that user exists
The account that liquidation organization opens up, such as the account that user opens up in banks such as Construction Bank, industrial and commercial banks.Second account can
To include account that user opens up in Third-party payment mechanism, such as user pays the third parties such as logical, Baidu's wallet in Alipay, wealth
The account that payment mechanism opens up.The third account may include the account that Third-party payment mechanism is opened up in liquidation organization, example
The account that such as Alipay is opened up in Construction Bank, bank, industrial and commercial bank.
In this Sample Scenario, user can carry out supplementing operation with money in the client.Operation, institute are supplemented with money in response to described
Charging request can be sent to the service server by stating client, can be carried the first account in the charging request, be filled
It is worth the information such as the amount of money and the second account.The service server can receive the charging request；Can by financial channel to
The authority server sends payment request, with notify the liquidation organization deducted from the first account the recharge amount and
Increase the recharge amount in third account.
In this Sample Scenario, it can arrange have clearance side between the liquidation organization and the Third-party payment mechanism
Formula.According to the clearance mode of agreement, the clearance time between liquidation organization and Third-party payment mechanism is usually later than third party's branch
Pay the settlement time between mechanism and user.For example, liquidation organization and Third-party payment mechanism can arrange using the clear of " T+3 "
Calculation mode, " T " refer to payment request submitting day；"+3 " refer to the third working day after payment request submission.As described
Authority server can receive payment request；The recharge amount can be deducted from the first account；It can be taken to the business
Business device feeds back successful message of withholing.It should be noted that the authority server will not at this time according to the clearance mode of agreement
Increase the recharge amount in third account；But after the clearance time of agreement reaches, just increase in third account
The recharge amount.
In this Sample Scenario, the service server can receive successful message of withholing；It can be in the second account
Increase the recharge amount；It can be to the information of the client feedback successful recharging.The client, which can receive, supplements with money into
The information of function.Furthermore the service server can also send the corresponding account number of this recharging service to the account server
According to.The account server can receive the accounting data；Idempotent tables of data can be written into the accounting data.If write-in
Success, then show that the accounting data meets the unique constraints of idempotent tables of data, that is, show that this recharging service is not user
Repetitive operation, the account server can by the accounting data be written accounting data table.If write-in failure, shows institute
The unique constraints that accounting data is unsatisfactory for idempotent tables of data is stated, that is, shows that this recharging service is the repetitive operation of user, institute
The accounting data can be ignored by stating account server.If write-in failure certainly, the account server can also be performed other
Predetermined action, details are not described herein.It should be noted that including some or all of in accounting data table in view of idempotent tables of data
Idempotent tables of data is written here, it can be understood as write element value some or all of in accounting data in accounting data by field
Enter idempotent tables of data, such as idempotent tables of data is written into element value corresponding with the field of idempotent tables of data in accounting data.
The quantity of the idempotent tables of data can be one.As described account server can write the accounting data
Enter the idempotent tables of data.Alternatively, the quantity of the idempotent tables of data can be multiple.As described account server can be from
Target idempotent tables of data is chosen in the multiple idempotent tables of data；The target idempotent number chosen can be written into the accounting data
According to table.For example, the account server can provide N number of idempotent tables of data.The corresponding table mark point of N number of idempotent tables of data
Not Wei A0, A1, A2 ..., A (N-1).So, the account server can calculate some in the accounting data or multiple
The cryptographic Hash of element value (such as order number)；When it is 0 that the cryptographic Hash is divided by the remainder of N, it is corresponding that table mark A0 can be chosen
Idempotent tables of data is as target idempotent tables of data；When it is 1 that the cryptographic Hash is divided by the remainder of N, it is corresponding that table mark A1 can be chosen
Idempotent tables of data as target idempotent tables of data；And so on, when it is N-1 that the cryptographic Hash is divided by the remainder of N, can choose
Table identifies A (N-1) corresponding idempotent tables of data as target idempotent tables of data.Certainly, those skilled in the art should can manage
Solution, the above process for choosing target idempotent tables of data is merely illustrative, and the actually described account server can also use other sides
Formula chooses target idempotent tables of data.
The quantity of the accounting data table can be one.As described account server can write the accounting data
Enter the accounting data table.Alternatively, the quantity of the accounting data table can be multiple.As described account server can be from
Target accounting data table is chosen in the multiple accounting data table；The target account number chosen can be written into the accounting data
According to table.The account server chooses the process of target accounting data table, can be with the process pair of selection target idempotent tables of data
According to explanation.
In this Sample Scenario, after the clearance time of agreement reaches, the authority server can also be to the account
Business server sends clearance file.The account server can receive clearance file；It can parse the clearance file, obtain
Clear data；The idempotent tables of data can be written into the clearance data.If write-in is the result shows that the clearance data meet
The unique constraints, the account server can determine that the reconciliation state of the clearance data is abnormality；It can incite somebody to action
Abnormality data table is written in the clearance data, and the abnormality data table is used to save the clearance number that reconciliation state is abnormality
According to.If write-in is the result shows that the clearance data are unsatisfactory for the unique constraints, the account server can determine described
The reconciliation state for clearing data is state to be checked；The clearance tables of data can be written to clearance tables of data, the clearance number
It is used to save the clearance data that reconciliation state is state to be checked according to table.
In this Sample Scenario, since the clearance time arranged between liquidation organization and Third-party payment mechanism is usually later than
Settlement time between Third-party payment mechanism and user, the then time that the account server obtains clearance data are usually later than
Obtain the time of accounting data.Using this feature, this Sample Scenario can realize account number when clearing data landing
According to the verification between clearance data, the performance for influencing database is avoided.
Usually it is later than Third-party payment mechanism in view of the clearance time arranged between liquidation organization and Third-party payment mechanism
Settlement time between user, then account server obtain clearance data time be usually later than obtain accounting data when
Between.A kind of account checking method can be provided based on this feature this specification embodiment.The account checking method is with account server
Executing subject.Please refer to Fig. 1, Fig. 2 and Fig. 3.The account checking method may comprise steps of.
Step S10: the clearance data from liquidation organization are received.
In the present embodiment, the authority server of the liquidation organization can send clearance text to the account server
Part.The account server can receive clearance file；The clearance file can be parsed, obtain at least one clearance
Data.Specifically, the authority server directly can send clearance file to the account server, alternatively, can also be through
Clearance file is sent to the account server indirectly from other servers.The clearance file can be Third-party payment mechanism
A kind of fund detail mutual files arranged between liquidation organization can specifically include the corresponding clearance number of an at least business
According to.
Step S12: idempotent tables of data is written into the clearance data.
In the present embodiment, the idempotent tables of data may include at least one field for being provided with unique constraints.Institute
Stating idempotent tables of data can be used for carrying out idempotent processing to accounting data, save to avoid by duplicate accounting data to account number
According to table.Usually it is later than the time for obtaining accounting data, the idempotent data in view of the time that account server obtains clearance data
Accounting data can be previously written in table.Specifically, the accounting data may include and be provided with unique constraints field
Corresponding element value can be previously written described corresponding with unique constraints field is provided in the idempotent tables of data
Element value.
In the present embodiment, idempotent tables of data can be written in each clearance data by the account server.It is described here
Account server will clear data and idempotent tables of data is written, it can be understood as write element value some or all of in clearance data
Enter idempotent tables of data, such as idempotent tables of data is written into element value corresponding with the field of idempotent tables of data in clearance data.
Specifically, the quantity of the idempotent tables of data can be one.As described account server can write each clearance data
Enter the idempotent tables of data.Alternatively, the quantity of the idempotent tables of data can be multiple.So it is directed to each clearance data, institute
Target idempotent tables of data can be chosen according to the clearance data from the multiple idempotent tables of data by stating account server；It can be with
The target idempotent tables of data that clearance data write-in is chosen.The process that the account server chooses target idempotent tables of data can
With referring to aforementioned Sample Scenario, details are not described herein.
Step S13: according to the write-in of the clearance data as a result, determining the reconciliation state of the clearance data.
In the present embodiment, the reconciliation state may include abnormality and state to be checked.The abnormality example
It such as may include more account states, the state to be checked for example may include normal condition and error condition.Below with a field
Scape example introduces more account states, normal condition and error condition.In the Sample Scenario, data and accounting data are cleared
To include the element value (such as order number) for capableing of one business of unique identification.For ease of description, which can be claimed
For key element value.So, for a certain clearance data, when there is no have identical key element value between the clearance data
Accounting data when, can assert there is no accounting data corresponding with the clearance data, and then can be assumed that the clearance
The reconciliation state of data is more account states；When the accounting data for existing with there is identical key element value between the clearance data
When, it can assert in the presence of accounting data corresponding with the clearance data, and then can be assumed that the reconciliation shape of the clearance data
State is state to be checked.Further, when exist between the clearance data with identical key element value accounting data and
When other elements value between the clearance data and the accounting data is all the same, the reconciliation state of the clearance data can be assert
For normal condition；When exist between the clearance data with identical key element value accounting data but the clearance data with
There are the reconciliation state of the clearance data when different other element values, can be assert for wrong shape between the accounting data
State.
In the present embodiment, accounting data can be previously written in idempotent tables of data.Account number in idempotent tables of data
It is corresponding according to the accounting data in accounting data table.Idempotent tables of data may include that at least one is provided with uniqueness about
The field of beam.Clearance data may include element value corresponding with unique constraints field is provided with.So for each clear
Count evidence, if being written successfully, shows that the clearance data meet the unique constraints, that is, shows to be not present and the clearance data
Corresponding accounting data, the account server can determine that the reconciliation state of the clearance data is abnormality；If write-in
Failure, then show that the clearance data are unsatisfactory for the unique constraints, that is, shows there is account corresponding with the clearance data
Data, the account server can determine that the reconciliation state of the clearance data is state to be checked.
In an embodiment of the present embodiment, determine it is described clearance data reconciliation state be abnormality with
Afterwards, abnormality data table can also be written in the clearance data by the account server.The abnormality data table can be used for protecting
Deposit the clearance data that reconciliation state is abnormality.Determine it is described clearance data reconciliation state be after verification state,
Clearance tables of data can also be written in the clearance data by the account server.The clearance tables of data is for saving reconciliation shape
State is the clearance data of state to be checked.Specifically, the quantity of the clearance tables of data can be one.As described account clothes
Being engaged in device can be by the clearance data write-in clearance tables of data.Alternatively, the quantity of the clearance tables of data can be multiple.
As described account server can choose target clearance tables of data from the multiple clearance tables of data；It can be by the clearance
The target that data write-in is chosen clears tables of data.Before the process that the account server chooses target clearance tables of data is referred to
Sample Scenario is stated, details are not described herein.It should be noted that the account server can also be using other methods come further
The reconciliation state of data is cleared in identification clearance tables of data.For example, the account server can also be by accounting data table and clear
It calculates tables of data and carries out full table correlation inquiry, to clear the reconciliation state of data as normal condition in further identification clearance tables of data
Or error condition.
In this specification embodiment, account server can receive the clearance data from liquidation organization；It can will be described
Clear data be written idempotent tables of data, the idempotent tables of data may include at least one be provided with unique constraints field,
And it is previously written the accounting data from payment mechanism；It can be according to the write-in of the clearance data as a result, determining described clear
The reconciliation state for the evidence that counts.So in the present embodiment, the account server can be when clearing data arrival, in conjunction with idempotent
The unique constraints of tables of data checks clearance data item by item, so as to avoid reconciliation process to the shadow of database performance
It rings.
Please refer to Fig. 4.This specification embodiment also provides a kind of account checking apparatus.The account checking apparatus may include to place an order
Member.
Receiving unit 20, for receiving the clearance data from liquidation organization；
R/w cell 22, for idempotent tables of data to be written in the clearance data；The idempotent tables of data includes at least one
Field provided with unique constraints and it is previously written the accounting data from payment mechanism；
Determination unit 24, for the write-in according to the clearance data as a result, determining the reconciliation state of the clearance data.
Please refer to Fig. 5.This specification embodiment also provides a kind of server.The server may include memory and place
Manage device.
In the present embodiment, the memory can be implemented in any suitable manner.For example, the memory can be
Read-only memory, mechanical hard disk, solid state hard disk or USB flash disk etc..The memory can be used for storing computer instruction.
In the present embodiment, the processor can be implemented in any suitable manner.For example, processor can take example
Such as microprocessor or processor and storage can by (micro-) processor execute computer readable program code (such as software or
Firmware) computer-readable medium, logic gate, switch, specific integrated circuit (Application Specific
Integrated Circuit, ASIC), programmable logic controller (PLC) and the form etc. for being embedded in microcontroller.The processor
The computer instruction can be executed and perform the steps of clearance data of the reception from liquidation organization；By the clearance data
Idempotent tables of data is written；The idempotent tables of data includes that at least one is provided with the field of unique constraints and has been previously written
Accounting data from payment mechanism；According to the write-in of the clearance data as a result, determining the reconciliation state of the clearance data.
It should be noted that all the embodiments in this specification are described in a progressive manner, each embodiment it
Between same and similar part may refer to each other, each embodiment focuses on the differences from other embodiments.
For server example and Installation practice, since it is substantially similar to the method embodiment, so the ratio of description
Relatively simple, the relevent part can refer to the partial explaination of embodiments of method.
Further it will be understood that one of ordinary skill in the art may not need creation after reading this specification file
Property labour some or all of expect in this specification file enumerating and can be combined between embodiment, these combinations are also in this explanation
In the range of book is disclosed and is protected.
In the 1990s, the improvement of a technology can be distinguished clearly be on hardware improvement (for example,
Improvement to circuit structures such as diode, transistor, switches) or software on improvement (improvement for method flow).So
And with the development of technology, the improvement of current many method flows can be considered as directly improving for hardware circuit.
Designer nearly all obtains corresponding hardware circuit by the way that improved method flow to be programmed into hardware circuit.Cause
This, it cannot be said that the improvement of a method flow cannot be realized with hardware entities module.For example, programmable logic device
(Programmable Logic Device, PLD) (such as field programmable gate array (Field Programmable Gate
Array, FPGA)) it is exactly such a integrated circuit, logic function determines device programming by user.By designer
Voluntarily programming comes a digital display circuit " integrated " on a piece of PLD, designs and makes without asking chip maker
Dedicated IC chip 2.Moreover, nowadays, substitution manually makes IC chip, and this programming is also used instead mostly
" logic compiler (logic compiler) " software realizes that software compiler used is similar when it writes with program development
Seemingly, and the source code before compiling also handy specific programming language is write, this is referred to as hardware description language
(Hardware Description Language, HDL), and HDL is also not only a kind of, but there are many kind, such as ABEL
(Advanced Boolean Expression Language)、AHDL(Altera Hardware Description
Language)、Confluence、CUPL(Cornell University Programming Language)、HDCal、JHDL
(Java Hardware Description Language)、Lava、Lola、MyHDL、PALASM、RHDL(Ruby
Hardware Description Language) etc., VHDL (Very-High-Speed is most generally used at present
Integrated Circuit Hardware Description Language) and Verilog2.Those skilled in the art
It will be apparent to the skilled artisan that only needing method flow slightly programming in logic and being programmed into integrated circuit with above-mentioned several hardware description languages
In, so that it may it is readily available the hardware circuit for realizing the logical method process.
System, device, module or the unit that above-described embodiment illustrates can specifically realize by computer chip or entity,
Or it is realized by the product with certain function.It is a kind of typically to realize that equipment is computer.Specifically, computer for example may be used
Think personal computer, laptop computer, cellular phone, camera phone, smart phone, personal digital assistant, media play
It is any in device, navigation equipment, electronic mail equipment, game console, tablet computer, wearable device or these equipment
The combination of equipment.
As seen through the above description of the embodiments, those skilled in the art can be understood that this specification
It can realize by means of software and necessary general hardware platform.Based on this understanding, the technical solution of this specification
Substantially the part that contributes to existing technology can be embodied in the form of software products in other words, the computer software
Product can store in storage medium, such as ROM/RAM, magnetic disk, CD, including some instructions are used so that a computer
Equipment (can be personal computer, server or the network equipment etc.) executes each embodiment of this specification or embodiment
Certain parts described in method.
This specification can be used in numerous general or special purpose computing system environments or configuration.Such as: personal computer,
Server computer, handheld device or portable device, laptop device, multicomputer system, microprocessor-based system,
Set top box, programmable consumer-elcetronics devices, network PC, minicomputer, mainframe computer including any of the above system are set
Standby distributed computing environment etc..
This specification can describe in the general context of computer-executable instructions executed by a computer, such as journey
Sequence module.Generally, program module include routines performing specific tasks or implementing specific abstract data types, programs, objects,
Component, data structure etc..This specification can also be practiced in a distributed computing environment, in these distributed computing environment
In, by executing task by the connected remote processing devices of communication network.In a distributed computing environment, program module
It can be located in the local and remote computer storage media including storage equipment.
Although depicting this specification by embodiment, it will be appreciated by the skilled addressee that there are many become for this specification
Shape and the spirit changed without departing from this specification, it is desirable to which the attached claims include these deformations and change without departing from this
The spirit of specification.
Claims (10)
1. a kind of account checking method, comprising:
Receive the clearance data from liquidation organization；
Idempotent tables of data is written into the clearance data；The idempotent tables of data includes that at least one is provided with unique constraints
Field and it is previously written the accounting data from payment mechanism；
According to the write-in of the clearance data as a result, determining the reconciliation state of the clearance data.
2. the method as described in claim 1, the clearance data of the reception from liquidation organization, comprising:
Receive the clearance file from liquidation organization；
The clearance file is parsed, clearance data are obtained.
3. the method as described in claim 1, the field includes order number field.
4. the method as described in claim 1 is provided with multiple idempotent tables of data；Correspondingly, described to write the clearance data
Enter idempotent tables of data, comprising:
According to the clearance data, target idempotent tables of data is chosen from the multiple idempotent tables of data；
The target idempotent tables of data that the clearance data write-in is chosen.
5. the method as described in claim 1, the reconciliation state of the determination clearance data, comprising:
If write-in the result shows that the clearance data meet the unique constraints, determines the reconciliation state for clearing data and is
Abnormality.
6. method as claimed in claim 5, the method also includes:
Abnormality data table is written into the clearance data；It is the clear of abnormality that the abnormality data table, which is used to save reconciliation state,
Count evidence.
7. the method as described in claim 1, the reconciliation state of the determination clearance data, comprising:
If write-in the result shows that the clearance data are unsatisfactory for the unique constraints, determines the reconciliation state for clearing data
For state to be checked.
8. it is the method for claim 7, the method also includes:
Clearance tables of data is written into the clearance tables of data；The clearance tables of data is state to be checked for saving reconciliation state
Clearance data.
9. a kind of account checking apparatus, comprising:
Receiving unit, for receiving the clearance data from liquidation organization；
R/w cell, for idempotent tables of data to be written in the clearance data；The idempotent tables of data includes that at least one is provided with
The field of unique constraints and it is previously written the accounting data from payment mechanism；
Determination unit, for the write-in according to the clearance data as a result, determining the reconciliation state of the clearance data.
10. a kind of server, comprising:
Memory, for storing computer instruction；
Processor performs the steps of clearance data of the reception from liquidation organization for executing the computer instruction；By institute
State clearance data write-in idempotent tables of data；The idempotent tables of data include at least one be provided with unique constraints field and
It is previously written the accounting data from payment mechanism；According to the write-in of the clearance data as a result, determining the clearance data
Reconciliation state.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811450720.2A CN110046877B (en) | 2018-11-30 | 2018-11-30 | Account checking method and device and server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811450720.2A CN110046877B (en) | 2018-11-30 | 2018-11-30 | Account checking method and device and server |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110046877A true CN110046877A (en) | 2019-07-23 |
| CN110046877B CN110046877B (en) | 2023-09-29 |
Family
ID=67273259
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811450720.2A Active CN110046877B (en) | 2018-11-30 | 2018-11-30 | Account checking method and device and server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110046877B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112637243A (en) * | 2021-01-06 | 2021-04-09 | 中国工商银行股份有限公司 | Method, apparatus, device, storage medium and program product for processing clearing messages |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103325032A (en) * | 2012-03-21 | 2013-09-25 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| US20170112407A1 (en) * | 2013-11-15 | 2017-04-27 | Yibing Wu | A life maintenance mode, a brain inhibition therapy and a personal health information platform |
| CN106651572A (en) * | 2016-12-29 | 2017-05-10 | 中国建设银行股份有限公司 | Business rule assembly method and apparatus |
| CN107169749A (en) * | 2017-04-01 | 2017-09-15 | 北京波若科技有限公司 | Network payment account checking method and system |
| CN107229455A (en) * | 2016-03-24 | 2017-10-03 | 阿里巴巴集团控股有限公司 | A kind of method for processing business, apparatus and system |
| CN107730228A (en) * | 2017-08-24 | 2018-02-23 | 上海壹账通金融科技有限公司 | Account settle accounts calculation method, equipment and storage medium |
| CN107798109A (en) * | 2017-11-01 | 2018-03-13 | 深圳市牛鼎丰科技有限公司 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
| CN107833129A (en) * | 2017-09-13 | 2018-03-23 | 深圳市金证科技股份有限公司 | A kind of silver spreads out liquidation method, device and terminal device |
| CN107993141A (en) * | 2017-11-22 | 2018-05-04 | 中国银行股份有限公司 | Data processing method and device, server |
| CN108171489A (en) * | 2017-12-18 | 2018-06-15 | 深圳前海微众银行股份有限公司 | Data liquidation method, system and computer readable storage medium |
| CN108874654A (en) * | 2017-05-15 | 2018-11-23 | 阿里巴巴集团控股有限公司 | Idempotent validity test method, device and equipment, readable medium |
-
2018
- 2018-11-30 CN CN201811450720.2A patent/CN110046877B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103325032A (en) * | 2012-03-21 | 2013-09-25 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| US20170112407A1 (en) * | 2013-11-15 | 2017-04-27 | Yibing Wu | A life maintenance mode, a brain inhibition therapy and a personal health information platform |
| CN107229455A (en) * | 2016-03-24 | 2017-10-03 | 阿里巴巴集团控股有限公司 | A kind of method for processing business, apparatus and system |
| CN106651572A (en) * | 2016-12-29 | 2017-05-10 | 中国建设银行股份有限公司 | Business rule assembly method and apparatus |
| CN107169749A (en) * | 2017-04-01 | 2017-09-15 | 北京波若科技有限公司 | Network payment account checking method and system |
| CN108874654A (en) * | 2017-05-15 | 2018-11-23 | 阿里巴巴集团控股有限公司 | Idempotent validity test method, device and equipment, readable medium |
| CN107730228A (en) * | 2017-08-24 | 2018-02-23 | 上海壹账通金融科技有限公司 | Account settle accounts calculation method, equipment and storage medium |
| CN107833129A (en) * | 2017-09-13 | 2018-03-23 | 深圳市金证科技股份有限公司 | A kind of silver spreads out liquidation method, device and terminal device |
| CN107798109A (en) * | 2017-11-01 | 2018-03-13 | 深圳市牛鼎丰科技有限公司 | Method, apparatus, computer equipment and the storage medium of reconciliation clearance |
| CN107993141A (en) * | 2017-11-22 | 2018-05-04 | 中国银行股份有限公司 | Data processing method and device, server |
| CN108171489A (en) * | 2017-12-18 | 2018-06-15 | 深圳前海微众银行股份有限公司 | Data liquidation method, system and computer readable storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 蔡维德;郁莲;袁波;邓佑权;李琪;郭斌;: "面向大数据的区块链在清算系统中的应用", 大数据, no. 01 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112637243A (en) * | 2021-01-06 | 2021-04-09 | 中国工商银行股份有限公司 | Method, apparatus, device, storage medium and program product for processing clearing messages |
| CN112637243B (en) * | 2021-01-06 | 2022-12-23 | 中国工商银行股份有限公司 | Method, apparatus, device, storage medium and program product for processing clearing messages |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110046877B (en) | 2023-09-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102419050B1 (en) | Blockchain balance adjustment method and device, and electronic device | |
| JP7366208B2 (en) | Transaction processing methods and systems with full cryptographic auditing capabilities | |
| CN109615495B (en) | Data reconciliation method, device, equipment and system | |
| WO2019143914A1 (en) | Fund flow method and apparatus, and electronic device | |
| CN108920257B (en) | Transaction processing method, device, equipment and storage medium | |
| US20190122187A1 (en) | System and method for electronic transaction databases for sub-merchant funding | |
| CN108647950A (en) | A kind of transfer request processing method, device and equipment | |
| US11580549B2 (en) | Transaction tracking and fraud detection using voice and/or video data | |
| US11625709B1 (en) | Assured payment system using delayed transaction queue | |
| CN109472680A (en) | A kind of accounting processing method and system | |
| CN107993141A (en) | Data processing method and device, server | |
| CN110046977B (en) | Accounting method, accounting device and server | |
| CN110046877A (en) | Account checking method and device, server | |
| EP3477570A1 (en) | Method and device facilitating expansion of primary payment instruments | |
| US11861692B2 (en) | Automated hybrid pipeline for customer identification | |
| CN110046976A (en) | Account checking method and device, server | |
| CN113822660B (en) | Data processing method, device, electronic equipment and medium | |
| CN114548963B (en) | Payment interaction processing method and device | |
| US20210117951A1 (en) | Method, system, and non-transitory computer-readable record medium to change payment account using messenger | |
| JP5758948B2 (en) | Electronic record receivable liquidation management system | |
| CN113094414A (en) | Circulation map generation method and device | |
| JP2018520440A (en) | Co-processing of electrical signals for redundancy | |
| CN109961363A (en) | Account checking method and device | |
| CN116468432B (en) | Order processing method, device, equipment and medium | |
| US20230334500A1 (en) | Risk reserves |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20201012 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20201012 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: Greater Cayman, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |