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 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 clearance tables of data can be used for protecting
Deposit the clearance data of liquidation organization.The liquidation organization for example may include bank, Unionpay etc..The clearance tables of data can have
There is at least one field.The field in field and the accounting data table in the clearance tables of data can part or all of phase
Together.The clearance data may include at least one element value.The type of element value and the account number in the clearance data
It can be partly or entirely identical according to the type of middle element value.In addition, some or all of described clearance tables of data field can be set
It is equipped with unique constraints.Unique constraints can guarantee that the data in field are unique in the clearance tables of data.In reality
During border, it can determine unique constraints is arranged to which field according to the needs of clearance data and accounting data verification.Example
Such as, it is whether consistent that order number is concerned only in audit process.So, order number field can be set in the clearance tables of data
Set unique constraints.As a further example, it is no consistent to need to pay close attention to order number, transaction amount etc. in audit process.So, described
Unique constraints can be arranged to order number field, transaction amount field etc. by clearing in tables of data.
The quantity of the accounting data table and the clearance tables of data can be respectively one.Alternatively, data scale compared with
In the case where big, multiple tables of data can be used and carry out storing data, to maintain performance when operating to data in tables of data.
The quantity of the accounting data table described in this way and the clearance tables of data can also be respectively multiple.Specifically, the account service
Device can be provided with multiple tables of data groups, and each tables of data group may include mutual corresponding accounting data table and clearance data
Table.Accounting data table and clearance tables of data in each tables of data group can respectively correspond table mark.For example, the account clothes
Business device can be provided with tables of data group A, B and C.Tables of data group A may include accounting data Table A _ ZW and clearance tables of data A_QS.
The corresponding table mark of accounting data Table A _ ZW can be A_ZW;Clearing the corresponding table mark of tables of data A_QS can be A_QS.Number
It may include accounting data table B_ZW and clearance tables of data B_QS according to table group B.Accounting data table B_ZW corresponding table mark can be with
For B_ZW;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 and
Clear tables of data C_QS.The corresponding table mark of accounting data table C_ZW can be C_ZW;Clear the corresponding table mark of tables of data C_QS
Knowledge 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, the liquidation organization and the Third-party payment mechanism can arrange have clearance mode.Root
According to the clearance mode of agreement, the clearance time between liquidation organization and Third-party payment mechanism is usually later than Third-party payment mechanism
Settlement time between user.For example, liquidation organization and Third-party payment mechanism can arrange the clearance side using " T+3 "
Formula, " T " refer to payment request submitting day;"+3 " refer to the third working day after payment request submission.As described mechanism
Server can receive payment request;The recharge amount can be deducted from the first account;It can be to the service server
Feed back successful message of withholing.It should be noted that the authority server will not be at this time according to the clearance mode of agreement
Increase the recharge amount in three accounts;But after the clearance time of agreement reaches, just in third account described in increase
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;The accounting data can be respectively written into accounting data table and
Clear tables of data.Here by accounting data write-in accounting data table and clearance tables of data, it can be understood as will be in accounting data
Accounting data table and clearance tables of data is written in element value.
Specifically, the quantity of the accounting data table and the clearance tables of data can be one.As described account clothes
The accounting data can be respectively written into the accounting data table and the clearance tables of data by business device.Alternatively, the account number
Quantity according to table and the clearance tables of data can be multiple.As described account server can therefrom choose target account number
Tables of data is cleared according to table and target;The accounting data can be respectively written into the target accounting data table and target clearance of selection
Tables of data.The account server introduced below chooses the process of target accounting data table, and the account server chooses target
The process of clearance tables of data, which can compare, to explain.The account server can provide N number of accounting data table.It is described N number of
Accounting data table corresponding table mark be respectively A0, A1, A2 ..., A (N-1).So, the account server can calculate institute
State the cryptographic Hash of some in accounting data or multiple element values (such as order number);The cryptographic Hash divided by N remainder be 0
When, the corresponding accounting data table of table mark A0 can be chosen as target accounting data table;It is divided by the remainder of N in the cryptographic Hash
When 1, the corresponding accounting data table of table mark A1 can be chosen as target accounting data table;And so on, it is removed in the cryptographic Hash
When with the remainder of N being N-1, table mark A (N-1) corresponding accounting data table can be chosen as target accounting data table.Certainly,
Those skilled in the art it should be understood that more than choose target accounting data table process it is merely illustrative, the actually described account
Business server can also choose target accounting data table using other way.
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 clearance 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 be
In the clearance tables of data by it is described clearance data reconciliation status indication be abnormality, alternatively, can also be by the clearance
The first tables of data is written in data, and first tables of data is used to save the clearance data that reconciliation state is abnormality.If write-in
The result shows that the clearance data are unsatisfactory for the unique constraints, the account server can determine the clearance data
Reconciliation state is normal condition;Accounting data corresponding with the clearance data can be obtained from the clearance tables of data to make
Be normal condition by the reconciliation status indication of the target accounting data for target accounting data, alternatively, can also will it is described clearly
It calculates tables of data and the second tables of data is written, second tables of data is used to save the clearance data that reconciliation state is normal condition.
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: by the accounting data write-in clearance tables of data from payment mechanism.
In the present embodiment, the clearance tables of data can be corresponding with liquidation organization, for saving the clear of liquidation organization
Count evidence.The clearance tables of data may include the field that at least one is provided with unique constraints.Unique constraints can be protected
The data demonstrate,proved in field are unique in the clearance tables of data.It in the actual process, can be according to clearance data and account
Verification of data needs to determine which field needs that unique constraints is arranged.For example, being concerned only with order number in audit process is
It is no consistent.So, unique constraints can be arranged to order number field in the clearance tables of data.As a further example, it is checking
It is no consistent to need to pay close attention to order number, transaction amount etc. in the process.It so, can be to order number word in the clearance tables of data
Unique constraints is arranged in section, transaction amount field etc..
In the present embodiment, the service server can send the corresponding account of every business to the account server
Data.The account server can receive the accounting data;The accounting data can be written to clearance tables of data.Here
Clearance tables of data is written in accounting data by the account server, it can be understood as by element some or all of in accounting data
Value write-in clearance tables of data.Specifically, the accounting data may include and be provided with that unique constraints field is corresponding wants
Element value.The element value write-in corresponding with unique constraints field is provided with can be cleared data by the account server
Table.
In the present embodiment, the quantity of the clearance tables of data can be one.As described account server can incite somebody to action
The clearance tables of data is written in the accounting data.Alternatively, the quantity of the clearance tables of data can be multiple.As described account
Being engaged in server can be according to the accounting data, and selection target clears tables of data from the multiple clearance tables of data;It can incite somebody to action
The target that the accounting data write-in is chosen clears tables of data.The process that the account server chooses target clearance tables of data can
With referring to aforementioned Sample Scenario, details are not described herein.
Step S12: 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 S14: the clearance tables of data is written into the clearance data.
In the present embodiment, clearance tables of data can be written in each clearance data by the account server.It is described here
Account server will clear data write-in clearance tables of data, it can be understood as write element value some or all of in clearance data
Enter to clear tables of data.Specifically, clearance data may include element value corresponding with unique constraints field is provided with.It is described
The element value write-in corresponding with unique constraints field is provided with can be cleared tables of data by account server.
In the present embodiment, the quantity of the clearance tables of data can be one.As described account server can incite somebody to action
The clearance tables of data is written in each clearance data.Alternatively, the quantity of the clearance tables of data can be multiple.So for every
A clearance data, the account server it is clear can to choose target according to the clearance data from the multiple clearance tables of data
Calculate tables of data;The clearance data can be written to the target chosen and clear tables of data.The account server chooses target clearance
The process of tables of data is referred to aforementioned Sample Scenario, and details are not described herein.
Step S16: according to the write-in of the clearance data as a result, determining the reconciliation state of the clearance data.
In the present embodiment, by step S10, the clearance tables of data can be previously written accounting data.Clear number
It with the accounting data in accounting data table is corresponding according to the accounting data in table.The clearance tables of data may include at least
One is provided with the field of unique constraints.Clearance data may include element corresponding with unique constraints field is provided with
Value.So shows that the clearance data meet the unique constraints if being written successfully for each clearance data, that is, show
There is no accounting data corresponding with the clearance data, the account server can determine the reconciliation state of the clearance data
For abnormality;If write-in failure, shows that the clearance data are unsatisfactory for the unique constraints, that is, show exist and the clearance
The corresponding accounting data of data, the account server can determine that the reconciliation state of the clearance data is normal condition.
In an embodiment of the present embodiment, determine it is described clearance data reconciliation state be abnormality with
Afterwards, the reconciliation status indication of the clearance data can be abnormal shape in the clearance tables of data by the account server
State;Alternatively, the first tables of data can also be written the clearance data.First tables of data is different for saving reconciliation state
The clearance data of normal state.After determining that the reconciliation state of the clearance data is normal condition, the account server can
To obtain accounting data corresponding with the clearance data from the clearance tables of data as target accounting data, can incite somebody to action
The reconciliation status indication of the target accounting data is normal condition;Alternatively, second can also be written the clearance tables of data
Tables of data.Second tables of data is used to save the clearance data that reconciliation state is normal condition.In a Sample Scenario, clearly
The evidence that counts and accounting data may each comprise the element value (such as order number) for capableing of one business of unique identification.So, described
Account server can obtain the account with the identical element value between the clearance data from the clearance tables of data
Data, as target accounting data corresponding with the clearance data.
In the present embodiment, clearance data can be written in the accounting data from payment mechanism by the account server
Table;It can receive the clearance data from liquidation organization;The clearance tables of data can be written into the clearance data;It can root
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 account service
Can accounting data be written in clearance tables of data in advance in device.In this way when clearing data and reaching, the account server can be with
In conjunction with the unique constraints of clearance tables of data, clearance data are checked item by item, so as to avoid reconciliation process to database
The influence of performance.
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.
First writing unit 20, for clearance tables of data will to be written from the accounting data of payment mechanism;The clearance number
Field corresponding with liquidation organization according to table and that unique constraints is provided with including at least one;
Receiving unit 22, for receiving the clearance data from liquidation organization;
Second writing unit 24, for the clearance tables of data to be written in the clearance data;
Determination unit 26, 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 to perform the steps of the accounting data write-in clearance tables of data from payment mechanism;Institute
State clearance tables of data it is corresponding with liquidation organization and including at least one provided with unique constraints field;It receives from clear
Calculate the clearance data of mechanism;The clearance tables of data is written into the clearance data;According to it is described clearance data write-in as a result,
Determine 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.