CN103577571B

CN103577571B - A kind of data processing method and device

Info

Publication number: CN103577571B
Application number: CN201310534027.4A
Authority: CN
Inventors: 李连港
Original assignee: Beijing Qihoo Technology Co Ltd; Qizhi Software Beijing Co Ltd
Current assignee: Beijing Qihoo Technology Co Ltd
Priority date: 2013-10-31
Filing date: 2013-10-31
Publication date: 2016-11-09
Anticipated expiration: 2033-10-31
Also published as: CN103577571A

Abstract

The invention discloses a kind of data processing method, relate to field of computer technology.Described method includes: obtain inner core to result data table from first server system;Obtain the same files generated by each second server；Each same files is collected with affiliated second server for dimension；According to the form transformational rule of corresponding described second server, every record data in the same files after collecting, be converted to every conversion data in the first tables of data data sheet field matched with described inner core；Treat Nuclear Data by the first tables of data every, with inner core, result data table is verified；By do not meet verification condition treat Nuclear Data insert the first outer kernel to error list with carry out check error logging；Insertion first outer kernel of verification condition will be met to success table to check successfully record.This invention simplifies verification of data logic, enhance maintainability and system robustness, reduce the beneficial effect of human cost.

Description

A kind of data processing method and device

Technical field

The present invention relates to field of computer technology, be specifically related to a kind of data processing method and device.

Background technology

Along with inter net and the development of computer technology, increasing people carries out shopping and lives on the net Dynamic, it is such as mobile phone charge filling, online purchase electronic product etc., in this process, client (disappears The person of expense) and merchant server (corresponding merchant website) and the second server (service of such as Alipay Device, the server etc. of fast money), it is required between merchant server and second server carrying out substantial amounts of frequency Numerous alternately, could the most complete whole purchasing process, and along with the complication of network trading behavior, have big The electronic trade platform of amount is re-used as network participants and adds the transmitting procedure of whole network data.Such as business Family server connects electronic trade platform, and the electronic data of commodity is published to electronic trade platform；First Client connects electronic trade platform and clicks on the electronic data obtaining these commodity, then reconnects second service Device, is that this electronic data pays by second server, and payment data is then given to by second server Electronic trade platform；Electronic trade platform acknowledge receipt of after after this payment data, then confirm this electronic article The first client is given in data grant, and such primary electron is concluded the business, at electronic trade platform, second server One billing data of each existence.

But, along with the substantial increase of the network user, and the electronic transaction behavior of each network user is quick-fried Fried formula increases, the bill number between merchant server (businessman), electronic trade platform, second server According to also increasing severely, its, magnitude may be to 100,000 even million magnitudes every day, then in order to avoid because network etc. Problem causes payment data to be transmitted the most in time, it is ensured that the account of bank and electronic trade platform does not makes mistake, Then need to check the billing data of these both sides.But for the billing data of magnanimity, this adopts With being manually totally impossible thing.

In prior art, the method using computer to carry out checking is: the checking method of electronic trade platform It is to set up an anticipatory remark ground billing data table, by the transaction bill number of each channel of disbursement of acquisition at server According to all checking with this table.But, due to each channel of disbursement field to the table of record billing data Definition difference, and the verification file of different second server imports a large and complete core by unified rule To in file table, during verification with the transaction journal of first server system by transaction odd numbers one by one in table Joining and hook right, hooking and result is inserted unified checklist, mistake adjusts account to process also in unified checklist Complete, cause the process logical miss of server, easily produce mistake, cause system robustness the highest, Later maintenance difficulty, human cost is high.

Summary of the invention

In view of the above problems, it is proposed that the present invention is to provide one to overcome the problems referred to above or at least partly Ground solves the data processing equipment of the problems referred to above and corresponding data processing method.

According to one aspect of the present invention, it is provided that a kind of data processing method, including:

Inner core is obtained to result data table from first server system;

Obtain the same files generated by each second server；

Each same files is collected with affiliated second server for dimension；

According to the form transformational rule of corresponding described second server, the same files after collecting In every record data, be converted to the first tables of data data sheet field matched with described inner core In every conversion data；

Treat Nuclear Data by the first tables of data every, with inner core, result data table is verified；Will not Meet verification condition treats that Nuclear Data inserts the first outer kernel to error list to carry out checking error logging；Will Meet insertion first outer kernel of verification condition to success table to check successfully record.

Optionally, also include:

Being that the first tables of data arranges each first field, described each first field is taken from inner core to number of results Field according to table；

According in second server to the definition of the second field in transaction data, with first server system pair The definition of the first field, carries out corresponding by the first field defining content identical with the second field, and according to Corresponding relation builds the form transformational rule of corresponding described second server.

Optionally, the described form transformational rule according to corresponding described second server, the friendship after collecting The easily record of every in data file data, are converted to match data sheet field with described inner core Every conversion data in first tables of data include:

Resolve in every record data of described same files, the second field of corresponding each second field Value；

In the first tables of data, according to the corresponding pass of each second field first field each with the first tables of data System, is transformed into the second field value of corresponding second field under the first field, thus obtains and every record Every conversion data that data are corresponding.

Optionally, described Nuclear Data is treated by the first tables of data every, with inner core to result data table Verify；Treat that Nuclear Data inserts the first outer kernel to error list to carry out core by do not meet verification condition To error logging；Success table is successfully remembered by insertion the first outer kernel meeting verification condition to check Record includes:

Treat Nuclear Data for every in the first tables of data, described in inspection, treat the insider transaction word of Nuclear Data Whether segment value mates the insider transaction field value in result data table with inner core；If inner core pair Result data table does not has insider transaction field value, then will treat that Nuclear Data inserts the first outer kernel to mistake Table, and stop this subsequent check treating Nuclear Data；

If inner core is to there being insider transaction field value in result data table, then Nuclear Data is treated in verification Target value field value whether with inner core, the target value field value in result data table is mated；As Really both target value field value couplings, then will treat that Nuclear Data inserts the first outer kernel to error list to enter Row verification error logging, and stop this subsequent check treating Nuclear Data；

If both target value field values do not mate, then the stateful transaction word of Nuclear Data is treated in verification Whether segment value mates the stateful transaction field value in result data table with inner core；If both transaction State field value does not mates, then will treat that Nuclear Data inserts the first outer kernel to error list to carry out checking mistake Record, and stop this subsequent check treating Nuclear Data；

If both stateful transaction field value couplings, then the order clearance state of Nuclear Data is treated in verification Whether field value clears state field value with inner core to the order in result data table mates；If both Order clearance state field value do not mate, then will treat that Nuclear Data inserts the first outer kernel to error list to enter Row verification error logging, and stop this subsequent check treating Nuclear Data；

If both order clearance state field value couplings, then will treat that Nuclear Data inserts first outside Check successfully table to carry out checking successfully record.

Optionally, described will treat Nuclear Data insert the first outer kernel to error list with carry out check error logging Including:

According to corresponding checking stage, in the first outer kernel is to error list, record this mistake treating Nuclear Data Type by mistake；Described type of error includes: the no deal data in corresponding inspection insider transaction field value stage Type, the wrong account type in corresponding verification object numeric word segment value stage, corresponding checkout transaction state phase value Fall single type, the repetition Payment Type of corresponding verification order clearance state field value.

Optionally, also include:

For the first outer kernel to the type of error of each record in error list, hold for corresponding order The adjustment operation that row is corresponding, and operate in the first outer kernel is to error list adjusting after operation completes State recording.

Optionally, described each same files is collected with affiliated second server for dimension After, also include:

Analyze the type of service that in same files, each bar transaction record is corresponding, further according to type of service pair Each bar record data are collected.

Optionally, described from first server system obtain inner core result data table is included:

The web server externally interacted from first server system obtains the first Transaction Information Table；

The account server from first server system, account ID being managed obtains the second transaction Information table；

With the first Transaction Information table as standard, by every the transaction data and first in the second Transaction Information table Transaction Information table is checked, thus obtains inner core to result data table.

Optionally, described with the first Transaction Information table as standard, by every friendship in the second Transaction Information table Easily data are checked with the first Transaction Information table, thus obtain inner core and include result data table:

When checking successfully, then this transaction data in the second Transaction Information table is inserted inner core to success Table is to carry out checking successfully record；When checking unsuccessfully, then by this number of deals in the second Transaction Information table According to inserting inner core to error list to carry out checking error logging；

According to inner core to success table and inner core to error list, it is thus achieved that inner core is to result data table.

The invention also discloses a kind of data processing equipment, including:

Inner core, to result data table acquisition module, is suitable to obtain inner core to knot from first server system Really tables of data;

Channel same files acquisition module, is suitable to obtain the transaction data generated by each second server File；

Collection module, is suitable to converge each same files for dimension with affiliated second server Collection；

Standard handovers module, is suitable to the form transformational rule according to corresponding described second server, will collect After same files in every record data, be converted to described inner core data sheet field phase Every conversion data in first tables of data of coupling；

Verification module, is suitable to treat Nuclear Data by the first tables of data every, with inner core to result data table Verify；Treat that Nuclear Data inserts the first outer kernel to error list to carry out core by do not meet verification condition To error logging；Success table is successfully remembered by insertion the first outer kernel meeting verification condition to check Record.

Optionally, also include:

First tables of data arranges module, is suitable for the first tables of data and arranges each first field, and described each first Field is taken from the inner core field to result data table；

Transformational rule acquisition module, is suitable to determine the second field in transaction data according in second server Justice, and the first server system definition to the first field, the first identical field of content and the will be defined Two fields carry out correspondence, and build the form conversion rule of corresponding described second server according to corresponding relation Then.

Optionally, described standard handovers module includes:

Parsing module, every that is suitable to resolve described same files records in data, corresponding each second word Second field value of section；

First standard handovers module, is suitable in the first tables of data, according to each second field and the first data The corresponding relation of each first field in table, is transformed into the first field by the second field value of corresponding second field Under, thus obtain every the conversion data corresponding with every record data.

Optionally, described verification module includes:

Transaction number field correction verification module, is suitable to treat Nuclear Data, inspection institute for every in the first tables of data State treat the insider transaction field value of Nuclear Data whether with inner core to the insider transaction in result data table Number field value coupling；If inner core is not to having insider transaction field value in result data table, then will treat Nuclear Data inserts the first outer kernel to error list, and stops this subsequent check treating Nuclear Data；If it is interior Portion's checked result tables of data has insider transaction field value, then enters target value field value detection mould Block；

Target value field value detection module, be suitable to verify treat the target value field value of Nuclear Data whether with Target value field value in result data table is mated by inner core；If both target value field values Coupling, then will treat that Nuclear Data inserts the first outer kernel to error list to carry out checking error logging, and stop This treats the subsequent check of Nuclear Data；If both target value field values do not mate, then enter transaction State field value correction verification module；

Stateful transaction field value correction verification module, be suitable to verify treat the stateful transaction field value of Nuclear Data whether with Stateful transaction field value in result data table is mated by inner core；If both stateful transaction field values Do not mate, then will treat that Nuclear Data inserts the first outer kernel to error list to carry out checking error logging, and stop Only this treats the subsequent check of Nuclear Data；If both stateful transaction field value couplings, then enter order Clearance state field value correction verification module；

Order clearance state field value correction verification module, is suitable to verify the order clearance mode field treating Nuclear Data Whether value clears state field value with inner core to the order in result data table mates；If both order Single clearance state field value does not mates, then will treat that Nuclear Data inserts the first outer kernel to error list to carry out core To error logging, and stop this subsequent check treating Nuclear Data；If both order clearance status words Segment value mates, then will treat that Nuclear Data inserts the first outer kernel to success table to check successfully record.

Optionally, each correction verification module includes:

Error logging module, is suitable to, according to corresponding checking stage, remember in the first outer kernel is to error list Record this type of error treating Nuclear Data；Described type of error includes: corresponding inspection insider transaction field The no deal data type in value stage, the corresponding wrong account type in verification object numeric word segment value stage, correspondence Checkout transaction state phase value fall single type, corresponding verification order clearance state field value repeat payment Type.

Optionally, also include:

Remediation module, is suitable to for the first outer kernel the wrong class of each record in error list Type, performs corresponding adjustment operation for corresponding order, and after adjustment operation completes outside first Verification error list carries out mode of operation record.

Optionally, described collection module also includes:

First collection module, is suitable to analyze the service class that in same files, each bar transaction record is corresponding Each bar record data are collected by type further according to type of service.

Optionally, result data table acquisition module is included by described inner core:

First tran list acquisition module, is suitable to the web externally interacted from first server system Server obtains the first Transaction Information table；

Second tran list acquisition module, is suitable to be managed account ID from first server system Account server obtains the second Transaction Information table；

First inner core, to result data table acquisition module, is suitable to the first Transaction Information table as standard, will Every transaction data and the first Transaction Information table in second Transaction Information table are checked, thus in obtaining Portion's checked result tables of data.

Optionally, described with the first inner core, result data table acquisition module is included:

Second verification module, is suitable to when checking successfully, then by this number of deals in the second Transaction Information table According to inserting inner core to success table to check successfully record；When checking unsuccessfully, then by the second transaction letter This transaction data in breath table inserts inner core to error list to carry out checking error logging；

Tables of data processing module, be suitable to according to inner core to success table and inner core to error list, it is thus achieved that Inner core is to result data table.

Data processing method according to the present invention can be by the same files of each second server with institute The second server belonged to is that dimension is collected, and changes rule according to the form of corresponding described second server Then, every record data in the same files after collecting, be converted to and described inner core logarithm According to every conversion data in the first tables of data that literary name section matches, then in the first tables of data every is treated Nuclear Data, verifies result data table with inner core；Treat that Nuclear Data is inserted by do not meet verification condition Enter the first outer kernel to error list to carry out checking error logging；By outside the insertion first meeting verification condition Portion check successfully table to carry out checking successfully record, then, thus solve at large and complete verification file table The file of middle each second server of verification and cause the process logical miss of server, easily produce mistake By mistake, cause system robustness the highest, later maintenance difficulty, the problem that human cost is high, achieve permissible With under the dimension of second server, its transaction data is checked, check clear logic, improve verification of data Accuracy, make technical staff can simply confirm wrong data, simplify the complexity of verification of data, Enhance maintainability, strengthen system robustness, greatly reduce the beneficial effect of human cost.

Described above is only the general introduction of technical solution of the present invention, in order to better understand the skill of the present invention Art means, and can being practiced according to the content of description, and in order to allow, the present invention's is above and other Objects, features and advantages can become apparent, below especially exemplified by the detailed description of the invention of the present invention.

Accompanying drawing explanation

By reading the detailed description of hereafter preferred implementation, various other advantage and benefit for this Field those of ordinary skill will be clear from understanding.Accompanying drawing is only used for illustrating the purpose of preferred implementation, And it is not considered as limitation of the present invention.And in whole accompanying drawing, be denoted by the same reference numerals Identical parts.In the accompanying drawings:

Fig. 1 shows the schematic flow sheet of a kind of data processing method;

Fig. 2 shows the example interface obtaining same files according to an embodiment of the invention;

Fig. 3 shows the schematic flow sheet of a kind of data processing method;

Fig. 4 shows reconciliation example between payment platform and trade company according to an embodiment of the invention;

Fig. 5 shows first server system and second server reconciliation according to an embodiment of the invention The example of process;

Fig. 6 shows benefit single operation process example according to an embodiment of the invention;

Fig. 7 shows a kind of according to an embodiment of the invention data processing equipment structural representation;

Fig. 8 shows a kind of according to an embodiment of the invention data processing equipment structural representation.

Detailed description of the invention

It is more fully described the exemplary embodiment of the disclosure below with reference to accompanying drawings.Although accompanying drawing shows The exemplary embodiment of the disclosure, it being understood, however, that may be realized in various forms the disclosure and not Should be limited by embodiments set forth here.On the contrary, it is provided that these embodiments are able to more thoroughly Understand the disclosure, and complete for the scope of the present disclosure can be conveyed to those skilled in the art.

In embodiments of the present invention, an applied environment is to include: the first server system of network payment platform System, the second server that each bank is corresponding, may also include client corresponding to each trade company or server, consumption Person's correspondence client.

With reference to Fig. 1, it illustrates the schematic flow sheet of a kind of data processing method of the embodiment of the present invention, Specifically may include that

Step 102, obtains inner core to result data table from first server system;

In embodiments of the present invention, for the first server system of network payment platform, its with consumption When person's client or vendor end etc. interact, i.e. consumer is for the business of a certain shopping website Product object carries out payment action by the network payment platform of the present invention, then payment platform i.e. can be for this Payment action carries out record, such as generates transaction odd numbers, records time of payment, payment, service class The keywords such as type, second server mark, so obtain the log in data base, then to these records Table is checked inside payment platform, it is thus achieved that inner core is to result data table.

In embodiments of the present invention, by second server dimension, log can be collected, such as The interactive object as trading order form using second server corresponding to China Merchants Bank, then can be with second Server is that log is collected by dimension, then carries out verification acquisition inner core to result data table.When Log so first can also be carried out payment platform inner core pair, the tables of data after verification is being taken with second Business device is that dimension carries out collecting and obtains inner core to result data table.So can be targetedly for The inside result tables of data of two servers is checked, and reduces the data volume of each checking object, improves core To efficiency.

Further, the log that also can collect under the dimension of second server+type of service, carry out Verification, obtains the inner core of second server+type of service to result data table, so can have for Property so can be targetedly for the inside result data of second server+type of service to business Table is checked, and reduces the data volume of each checking object, improves verification efficiency further.

Step 104, obtains the same files generated by each second server；

In the present invention, described second server can be understood as the server of each channel of disbursement, such as The server of fast money channel of disbursement, the server of Alipay bill payment channel, wallet Alipay PC account Family channel of disbursement server, wallet Alipay WAP channel of disbursement server etc..

Step 106, collects each same files for dimension with affiliated second server；

Such as Fig. 2, it is thus the same files of the server of channel of disbursement acquisition, then will conclude the business Data file is uploaded in first server system.For same files, it may be included in the second clothes Business device ID, further and at second server generates the time, then the present invention is uploading number of deals During according to file, then may select second server (channel of disbursement in Fig. 2), or select second service Device and the time of generation, same files is collected and uploads.

In embodiments of the present invention, same files can be csv form or txt formatted data.

In embodiments of the present invention, when uploading same files, can be first to the transaction data literary composition collected Part judges;Such as, it is judged that whether same files having repetition order, if had, reporting an error, The technical staff that operator can contact corresponding second server according to reporting an error carries out order correction；The most such as Judging that same files form is wrong, then carry out form and report an error, concrete points out concrete form wrong By mistake, such as separator mistake, field errors etc., operator are then according to the corresponding second service of contact that reports an error The technical staff of device carries out order correction.

It addition, for repeating the same files imported, then record can be filtered out when importing collects Duplicate data, it is to avoid repeat verification.

Preferably, described each same files is collected with affiliated second server for dimension After, also include:

In embodiments of the present invention, can in advance business type field definition be carried out point by each second server Analysis, makes first server system can identify the business type field of second server, and identifies its word Which kind of type of service in the most corresponding present invention of segment value.Then the transaction data literary composition to certain second server Part, puies forward the type of service identifying its every data, then can remember each bar according to further according to type of service Record data are collected.

Complicated class of business then can be peeled off from channel of disbursement by so embodiment of the present invention, it is achieved by canal Business reconciliation is pressed in road.

Step 108, according to the form transformational rule of corresponding described second server, the transaction after collecting In data file every record data, be converted to described inner core, data sheet field to be matched the Every conversion data in one tables of data；

In actual applied environment, the second server of each bank may be according to the demand of oneself to having The object of same definition, the field of employing is different, such as the serial number of a transaction, at bank A Server may be " order number " for the second field of record, the employing of the server of bank B can Can be " task number ", and the employing of the first server system of the present invention may be " transaction odd numbers ", that Bank A and bank B for conclude the business the second field due to the first field with the present invention different, then this The first server system of invention then cannot Direct Recognition.The most such as, the field of the amount of money for paying, Bank's A server uses character string type inconsistent with the character string type of the amount of money of the present invention, then this Invention also cannot Direct Recognition.

So present invention then can extract corresponding for the form of the same files of each second server Transformational rule, then after the first server system of the present invention gets corresponding same files, Then can obtain corresponding transformational rule, then according to corresponding transformational rule to the transaction data after collecting Every record data in file, are converted to the first number matched data sheet field with described inner core According to every conversion data in table；

Preferably, also include:

Step A10, is that the first tables of data arranges each first field, and described each first field is taken from inside The field of checked result tables of data；

In the present invention, the every data in same files can be dumped to first data of the present invention In table, and result data table can be mated core with inner core by the data in the first tables of data for convenience The first field that is right, then that arrange in the first tables of data, it uses and can be matched with internal structure tables of data Field.

Step A20, according in second server to the definition of the second field in transaction data, with the first clothes The business device system definition to the first field, by define the first identical field of content and the second field carry out right Should, and the form transformational rule of corresponding described second server is built according to corresponding relation.

After being provided with each field of the first tables of data, in order to be able to the pieces of data made in same files Can be transformed in the first tables of data, then for each second server, according in second server to friendship The easily definition of the second field in data, will define content with first server system to the definition of the first field The first identical field carries out corresponding with the second field, and builds corresponding described second clothes according to corresponding relation The form transformational rule of business device.The most aforementioned to the serial number for every transaction, second word of bank A Section is " order number ", and what the server of bank B used is probably " task number ", and the first of the present invention What server system used may be " transaction odd numbers "；For the character string type of the amount of money, bank A's Character string type is A1, and the character string type of bank B is B1, and the character string type of the present invention is C1；The transformational rule of so bank A to first tables of data includes: " order number " " transaction odd numbers "； Character string type A1 is converted to character string type C1.The transformational rule bag of bank B to first tables of data Include: " task number " " transaction odd numbers "；Character string type B1 is converted to character string type C1.

Preferably, the described form transformational rule according to corresponding described second server, the friendship after collecting The easily record of every in data file data, are converted to match data sheet field with described inner core Every conversion data in first tables of data include:

Step B10, resolves in every record data of described same files, corresponding each second field Second field value；

The such as same files of bank A has field " order number ", " amount of money " " trade date ", The most sequentially may have a plurality of record data, for every record data, it is at corresponding second word Corresponding second field value is had under Duan.

Step B12, in the first tables of data, according to each second field and each first word in the first tables of data The corresponding relation of section, is transformed into the second field value of corresponding second field under the first field, thus obtains Every the conversion data corresponding with every record data.

For record data, after getting the second field value of the second field, according to the second field With the corresponding relation of the first field, the second field value of corresponding second field is transformed under the first field, Wherein, if character string type is identical, the most directly it is recorded under the first field, if character string type is not With, then the character string type being converted to the first field carries out record.Thus obtain and every record data pair Every the conversion data answered.

Step 110, treats Nuclear Data by the first tables of data every, carries out result data table with inner core Verification；By do not meet verification condition treat Nuclear Data insert the first outer kernel to error list with carry out verification mistake Misdescription is recorded；Insertion first outer kernel of verification condition will be met to success table to check successfully record.

In the embodiment of the present invention, the first outer kernel can be built error list, the field of this error list are also adopted by The expression identity of the first field list and the field of content, such as conclude the business odd numbers, trade date, dealing money； Which kind of also include for representing it is the field " type of error " of mistake；May also include after these data are carried out The continuous process mode field processed, such as " strikes out ", " mending single " etc.；May also include and hand over corresponding bank Easily the field of state, such as " confiscates fund ", " checking ", " repetition " etc..

Preferably, described treat Nuclear Data by the first tables of data every, with inner core, result data table is entered Row verification；Treat that Nuclear Data inserts the first outer kernel to error list to check by do not meet verification condition Error logging；Insertion first outer kernel of verification condition will be met to success table to check successfully record Including:

C10, treats Nuclear Data for every in the first tables of data, treats that the inside of Nuclear Data is handed over described in inspection Whether easy field value mates the insider transaction field value in result data table with inner core；If it is interior Portion's checked result tables of data does not has insider transaction field value, then enters step C12；If inner core To result data table has insider transaction field value, then enter step C14；

In the embodiment of the present invention, first whether inspection record corresponding to same files have the present invention the Insider transaction number in one server system, i.e. by first tables of data corresponding with same files with Result data table is checked by inner core, if inner core does not has identical transaction to result data table Number, the record existing problems to this transaction in the server of channel of disbursement are described, then need not the most down remember Record, enters step C12.

The most in this step, second server ID can also be verified the most normal.Than such as whether have the The ID of two servers.

Step C12, will treat that Nuclear Data inserts the first outer kernel to error list, and stop this and treat Nuclear Data Subsequent check；

Preferably, described will treat Nuclear Data insert the first outer kernel to error list with carry out check error logging Including:

Step D10, according to corresponding checking stage, records this in the first outer kernel is to error list and treats The type of error of Nuclear Data；Described type of error includes: the corresponding inspection insider transaction field value stage No deal data type, the wrong account type in corresponding verification object numeric word segment value stage, corresponding checkout transaction State phase value fall single type, the repetition Payment Type of corresponding verification order clearance state field value.

Corresponding with field in the first tables of data to error list in the present invention the first outer kernel: transaction odd numbers, friendship The easily date, dealing money etc., the most extra fields such as type of error of adding, the most wrong to record every data By mistake.Such as transaction odd numbers be the record of 10001, if do not had in inner core is to result data table One record of 10001, then insert the first external errors table by this record, and record its type of error For " no deal data ".

Step C14, verification treat the target value field value of Nuclear Data whether with inner core to result data table In target value field value coupling；If both target value field value couplings, then enter step C16；If both target value field values do not mate, enter step C18；

Step C16, will treat that Nuclear Data inserts the first outer kernel to error list to carry out checking error logging, And stop this subsequent check treating Nuclear Data；

In embodiments of the present invention, described target value can be " dealing money ", such as trading card Number it is the record of 10002, if the dealing money of 10002 is 100 in inner core is to result data table, And the dealing money of 10002 is 50 in the first tables of data, then this record is inserted the first external errors Table, and record its type of error for " wrong account ".

Step C18, verification treat the stateful transaction field value of Nuclear Data whether with inner core to result data table In stateful transaction field value coupling；If both stateful transaction field values do not mate, then enter step C20；If both stateful transaction field value couplings, then enter step C22；

Step C20, will treat that Nuclear Data inserts the first outer kernel to error list to carry out checking error logging, And stop this subsequent check treating Nuclear Data；

In the present invention, real-time concluding the business for every, first server system can generate an order, The original state of this order is for waiting to collect money, then (such as corresponding industrial and commercial to corresponding channel of disbursement server The second server of bank) request gathering, this request is then responded by channel of disbursement, if for this Order responds successfully, and payment success, then the order status of this order is revised as collecting money into Merit, then for the Transaction Identification Number of this order in inner core is to result data table, then can record and collect money successfully； If it fails, then can respective record wait to collect money.

Such as transaction odd numbers be the record of 10003, if in inner core in result data table This record for waiting to collect money, is then inserted the first external errors table, and records it by the stateful transaction of 10003 Type of error is " falling list ".

Step C22, verification treat the order clearance state field value of Nuclear Data whether with inner core to number of results State field value coupling is cleared according to the order in table；If both order clearance state field value are not Join, then enter step C24；If both order clearance state field value couplings, then enter step C26；

Step C24, will treat that Nuclear Data inserts the first outer kernel to error list to carry out checking error logging, And stop this subsequent check treating Nuclear Data；

In embodiments of the present invention, after successfully passing all verifications of the present invention, or by other means After order is cleared, then can be by the order shape of the corresponding odd numbers of concluding the business of internal data checked result tables of data State is revised as clearance state, if do not cleared, then the clearance state of odd numbers of concluding the business does not clears state.

So, such as transaction odd numbers be the record of 10004, if in inner core to result data table In 10003 clearance state for clear, then illustrate that this order has received corresponding fund, clear successfully, Again clearing again specifically, then this record is being inserted the first external errors table, and record its type of error For " repeating number of paying the bill ".

Step C26 will treat that Nuclear Data inserts the first outer kernel to success table to check successfully record.

If all clearance states are not for clear, then will treat Nuclear Data insert the first outer kernel to success table with Carry out checking successfully record, by inner core to result data table this record clearance status modifier be Clearance.

Preferably, also include:

Step C28, for the first outer kernel to the type of error of each record in error list, for phase The order answered performs corresponding adjustment operation, and is adjusting after operation completes in the first outer kernel error list In carry out mode of operation record.

I.e. for each type of error, all can be adjusted operation, described adjustment operation include striking out and Mend single:

Striking out: represent that this error log is canceled after artificial verification, the data made mistakes can propped up Pay reconciliation again after manual modification in the transaction journal of channel.

Mend single: represent that this transaction has been cleared but at payment system record in the transaction journal of channel of disbursement Do not collect money successfully, so the gathering state of this transaction in charge slip to be updated, and error log is moved to Reconciliation success table.

In embodiments of the present invention, also include: reconciliation result table is split by corresponding trade company ID, And provide reconciliation query interface for trade company ID.

So when trade company clicks in the page and checks and accepts interface, reconciliation situation can be checked.

The present invention solve check in large and complete verification file table each second server file and Causing the process logical miss of server, easily produce mistake, cause system robustness the highest, the later stage ties up Protecting difficulty, the problem that human cost is high, achieving can be with under the dimension of second server, by its number of deals According to checking, check clear logic, improve the accuracy of verification of data, make the technical staff can the most really Recognize wrong data, simplify the complexity of verification of data, enhance maintainability, strengthen system robustness, Greatly reduce the beneficial effect of human cost.

Embodiment two

With reference to Fig. 3, it illustrates the schematic flow sheet of a kind of data processing method of the present invention, specifically may be used To include:

Step 202, obtains first from first server system in the web server externally interacted Transaction Information table；

Step 204, obtains in the account server being managed account ID from first server system Take the second Transaction Information table；

Step 206, with the first Transaction Information table as standard, by every transaction in the second Transaction Information table Data are checked with the first Transaction Information table, thus obtain inner core to result data table.

In embodiments of the present invention, first server system includes web server and account server, when Trade company ID, or when consumer ID is specifically applied access and pays by mutual web server, Web server can record the first transaction flow water meter, and every transaction can call account server operation phase Answer ID to carry out account operation, such as gathering etc. the most also to remember under each account ID of account server Record the second transaction flow water meter.

Preferably, described with the first Transaction Information table as standard, by every friendship in the second Transaction Information table Easily data are checked with the first Transaction Information table, thus obtain inner core and include result data table:

Step E10, when checking successfully, then in being inserted by this transaction data in the second Transaction Information table Portion check successfully table to carry out checking successfully record；When checking unsuccessfully, then by the second Transaction Information table This transaction data inserts inner core to error list to carry out checking error logging；

Step E12, according to inner core to success table and inner core to error list, it is thus achieved that inner core is to knot Really tables of data.

In embodiments of the present invention step 202 206 be the internal reconciliation of first server it can be understood as Reconciliation between payment platform and trade company.With reference to Fig. 4, it is payment platform (first server of the present invention System) and trade company between reconciliation example.In embodiments of the present invention, automated system operation in morning every day Complete the transaction hook between each business payment platform and trade company of a day of trade right:

S10, obtains transaction data yesterday under each account ID in account server, it is thus achieved that Accounting system Transaction Information table；

S12, obtains the transaction flow water meter of web server,

S13, incites somebody to action and described transaction flow water meter is checked with described Accounting system Transaction Information table, it is thus achieved that internal Reconciliation result table.

1., according to insider transaction odd numbers, from tran list, associate out gathering odd numbers

2. hook condition:

Gathering odd numbers

Gathering state

Exchange hour is all yesterday

3. hook process:

Based on cashier data

Reconciliation is put down, and inserts internal reconciliation success table, updates this record reconciliation success of transaction flow water meter；

Reconciliation is uneven, inserts internal reconciliation error list, updates this record reconciliation failure of transaction flow water meter.

4, according to above-mentioned internal reconciliation success table and internal reconciliation error list, it is thus achieved that inside checked result Tables of data.

Step 210, obtains the same files generated by each second server；

Step 212, and collects each same files with affiliated second server for dimension；

Step 214, analyzes the type of service that in same files, each bar transaction record is corresponding, further according to Each bar record data are collected by type of service；

Step 216, according to the form transformational rule of corresponding described second server, the transaction after collecting In data file every record data, be converted to described inner core, data sheet field to be matched the Every conversion data in one tables of data；

Step 218, treats Nuclear Data by the first tables of data every, carries out result data table with inner core Verification；By do not meet verification condition treat Nuclear Data insert the first outer kernel to error list with carry out verification mistake Misdescription is recorded；Insertion first outer kernel of verification condition will be met to success table to check successfully record.

Step 220, for the first outer kernel to the type of error of each record in error list, for phase The order answered performs corresponding adjustment operation, and is adjusting after operation completes in the first outer kernel error list In carry out mode of operation record.

First outer kernel does not set major key to error list in embodiments of the present invention, reduces server resource and disappears Consumption.

In the embodiment of the present invention, step 210 is to step 220, for payment platform (first server system) And the reconciliation process between channel of disbursement (second server).With reference to Fig. 5, it illustrates invention first Server system and the example of second server reconciliation process:

In this example, bank clearing file correspondence same files, corresponding first number of bank's flowing water table According to table, corresponding first outer kernel of outside reconciliation error list is to error list, outside reconciliation success table correspondence first Outer kernel is to successful table, and internal reconciliation result table correspondence inner core is to result data table.

S21, obtains bank clearing file；

S22, imports bank clearing file；If reported an error, then enter S23；If normal, then enter Enter S24；

Will collect by business with by channel by bank clearing file.

S23, carries out the situation that reports an error and processes.

Situation:

1, file has repetition order

Process: the prompting that reports an error repeats order number;Operator contacts bank

2, form is wrong

Process: report an error the concrete mistake of prompting, such as separator, field etc.;Operator contacts bank Continue normal importing after adjusting, then enter S24.

S24, prepares the data imported and internal reconciliation result table reconciliation；By every number after being ready to complete According to proceeding by verification, enter S25；

Bank's pipelined data (in abovementioned steps not the first tables of data) is main in this process, and bank flows The non-reconciliation of data of water meter original state, internal reconciliation table data initial state reconciliation is not fully complete.

S25, verification insider transaction number and bank ID；If no data, enter S26；If there being number According to, enter S27；

S26, process no deal data cases processes.

Situation: no deal data

Process: check that error list exists the most, do not exist, charge to outside reconciliation error list, reconciliation shape State does not terminates, and updates bank's this record reconciliation completion status of flowing water table, and shows the result queries page;

Operator contacts bank, consistency operation: strike out, and updates outside reconciliation error list reconciliation state and terminates.

S27, checks the amount of money；If the amount of money is inconsistent, enter S28, if the amount of money unanimously enters S29；

S28, carries out wrong account situation and processes.

Situation: wrong account

Process: charging to outside reconciliation error list, reconciliation state does not terminates, and updates bank's this record of flowing water table Reconciliation completion status, and show the result queries page;

S29, checkout transaction state；If waiting to collect money, then enter S30；If collecting money successfully, Then enter S31；

S30, carries out one-state and processes.

Situation: fall single process: charging to outside reconciliation error list, reconciliation state does not terminates, update bank's stream This record reconciliation completion status of water meter, updates internal reconciliation result table reconciliation completion status, shows that result is looked into Ask the page;

Consistency operation: mend single, be i.e. as the criterion with bank clearing data, manual amendment backstage stateful transaction.

S31, verification charge slip clearance state；If cleared, then enter S32；If do not cleared, Then enter S33.

S32, carries out repeating number situation process of paying the bill.

Situation: repeat number (this order status is: clear) of paying the bill

Operator contacts bank, consistency operation: strike out, and updates outside reconciliation error list reconciliation state knot Bundle.

S33, carries out the flat operation of reconciliation.

Reconciliation is put down, and inserts outside reconciliation success table, updates bank's this record reconciliation completion status of flowing water table, Update internal reconciliation result table reconciliation complete and cleared state；Update charge slip gathering state: clear.

In above process, striking out operating process described in is: issued transaction:

Updating the annotation of this record of external errors table, updating reconciliation state is end-state.Then It is updated to strike out successfully by the process state of respective transaction odd numbers in outside reconciliation error list.

In above process, described benefit single operation process such as Fig. 6:

S41, write-back updates Accounting system charge slip state and collects money successfully；

I.e. for each transaction odd numbers, corresponding account ID in account server, a gathering can be built Single, when not receiving corresponding server gathering response, its charge slip state is for waiting to collect money.

So the present embodiment is at the manual manual write-back of write-back mode: updates Accounting system charge slip state and receives Money success.

S42, it may be judged whether write-back success；If it is not, then enter S43；The most then enter S44；

S43, write-back is collected money successfully failed, error code 2001；

This operation can notify which stage write-back mistake operator are.

S44, it is manual that renewal Accounting system charge slip state clears successfully WriteMode, and write-back trading card is paid the bill Success；

Then manually update in web server side at write-back, one can be generated when transaction for an order number Individual trading card, in process of exchange, the state of this trading card can be modified along with business.

So can manual write-back trading card successful payment at this in the present embodiment.

S45, it may be judged whether write-back success；If it is not, then enter S46；The most then enter S47；

S46, write-back clears successfully failure, error code 2002；

S47, record moves into outside reconciliation success table；

Corresponding transaction record is moved into outside reconciliation success table, and recording status.

S48, updates internal reconciliation result table gathering state for collect money successfully；

S49, the banker's payment of the transaction flow water meter updating web server is masked as successfully, web services Device notice trade company ID keeps accounts；

Above-mentioned benefit list, striking out operation all for a data, each table is searched mutually by odd numbers of concluding the business, with Data in change respective table.

The present embodiment step principle similar with embodiment one is similar to, and the most no longer describes in detail.

The present invention solve check in large and complete verification file table each second server file and Causing the process logical miss of server, easily produce mistake, cause system robustness the highest, the later stage ties up Protecting difficulty, the problem that human cost is high, achieving can be with under the dimension of second server, by its number of deals According to checking, check clear logic, improve the accuracy of verification of data, make the technical staff can the most really Recognize wrong data, simplify the complexity of verification of data, enhance maintainability, strengthen system robustness, Greatly reduce the beneficial effect of human cost.The process difference payment canal that the present invention is self-defined, differential The reconciliation at end day in road, simplifies the complexity of reconciliation, enhances maintainability.The present invention is by complicated industry Business kind is peeled off from channel of disbursement, it is achieved by channel by business reconciliation, each business financial standing is clear. The present invention can help trade company's real-time query to the transaction journal on payment platform and reconciliation file, permissible Reconciliation at any time.The present invention can help payment system operational control personnel conveniently to perform reconciliation, inspection Check account result, execution error processes.

Embodiment three

With reference to Fig. 7, it illustrates one data processing equipment structural representation of the present invention, including:

Inner core, to result data table acquisition module 302, is suitable to obtain inner core from first server system To result data table;

Channel same files acquisition module 304, is suitable to obtain the transaction generated by each second server Data file；

Collection module 306, is suitable to carry out each same files for dimension with affiliated second server Collect；

Standard handovers module 308, is suitable to the form transformational rule according to corresponding described second server, will Every record data in same files after collecting, are converted to described inner core data literary name Every conversion data in the first tables of data that section matches；

Verification module 310, is suitable to treat Nuclear Data, with inner core to number of results by the first tables of data every Verify according to table；Treat that Nuclear Data inserts the first outer kernel to error list to enter by do not meet verification condition Row verification error logging；Insertion first outer kernel of verification condition will be met to success table to check into Merit record.

Optionally, also include:

Optionally, described standard handovers module includes:

Optionally, described verification module includes:

Optionally, each correction verification module includes:

Optionally, also include:

Optionally, described collection module also includes:

Embodiment four

With reference to Fig. 8, it illustrates one data processing equipment structural representation of the present invention, including:

First tran list acquisition module 402, is suitable to externally to interact from first server system Web server obtains the first Transaction Information table；

Second tran list acquisition module 404, is suitable to manage account ID from first server system The account server of reason obtains the second Transaction Information table；

First inner core, to result data table acquisition module 406, is suitable to the first Transaction Information table as standard, Every transaction data in second Transaction Information table and the first Transaction Information table are checked, thus obtains Inner core is to result data table.

Channel same files acquisition module 500, is suitable to obtain the transaction generated by each second server Data file；

Collection module 502, is suitable to carry out each same files for dimension with affiliated second server Collect；

First collection module 504, is suitable to analyze the business that in same files, each bar transaction record is corresponding Each bar record data are collected by type further according to type of service.

Standard handovers module 506, is suitable to the form transformational rule according to corresponding described second server, will Every record data in same files after collecting, are converted to described inner core data literary name Every conversion data in the first tables of data that section matches；

Verification module 508, is suitable to treat Nuclear Data, with inner core to number of results by the first tables of data every Verify according to table；Treat that Nuclear Data inserts the first outer kernel to error list to enter by do not meet verification condition Row verification error logging；Insertion first outer kernel of verification condition will be met to success table to check into Merit record.

Remediation module 510, be suitable to for the first outer kernel the mistake of each record in error list Type, performs corresponding adjustment operation for corresponding order, and after adjustment operation completes outside first Verification error list in portion's carries out mode of operation record.

Algorithm and display be not solid with any certain computer, virtual system or miscellaneous equipment provided herein Have relevant.Various general-purpose systems can also be used together with based on teaching in this.As described above, Construct the structure required by this kind of system to be apparent from.Additionally, the present invention is also not for any specific Programming language.It is understood that, it is possible to use various programming languages realize the content of invention described herein, And the description done language-specific above is the preferred forms in order to disclose the present invention.

In description mentioned herein, illustrate a large amount of detail.It is to be appreciated, however, that this Inventive embodiment can be put into practice in the case of not having these details.In some instances, not It is shown specifically known method, structure and technology, in order to do not obscure the understanding of this description.

Similarly, it will be appreciated that in order to simplify the disclosure and help understand in each inventive aspect one Or multiple, above in the description of the exemplary embodiment of the present invention, each feature of the present invention is sometimes It is grouped together in single embodiment, figure or descriptions thereof.But, should be by the disclosure Method be construed to reflect an intention that i.e. the present invention for required protection require ratio in each claim The middle more feature of feature be expressly recited.More precisely, as the following claims reflect As, inventive aspect is all features less than single embodiment disclosed above.Therefore, it then follows Claims of detailed description of the invention are thus expressly incorporated in this detailed description of the invention, the most each right Requirement itself is all as the independent embodiment of the present invention.

Those skilled in the art are appreciated that and can carry out the module in the equipment in embodiment certainly Change adaptively and they are arranged in one or more equipment different from this embodiment.Permissible Module in embodiment or unit or assembly are combined into a module or unit or assembly, and in addition may be used To put them into multiple submodule or subelement or sub-component.Except such feature and/or process or Outside at least some in unit excludes each other, can use any combination that (this specification is included companion With claim, summary and accompanying drawing) disclosed in all features and so disclosed any method or All processes of person's equipment or unit are combined.Unless expressly stated otherwise, this specification (includes companion With claim, summary and accompanying drawing) disclosed in each feature can by provide identical, equivalent or phase Replace like the alternative features of purpose.

Although additionally, it will be appreciated by those of skill in the art that embodiments more described herein include it Some feature included in its embodiment rather than further feature, but the group of the feature of different embodiment Close and mean to be within the scope of the present invention and formed different embodiments.Such as, in following power In profit claim, one of arbitrarily can mode making in any combination of embodiment required for protection With.

The all parts embodiment of the present invention can realize with hardware, or to process at one or more The software module run on device realizes, or realizes with combinations thereof.Those skilled in the art should Understand, microprocessor or digital signal processor (DSP) can be used in practice to realize basis The embodiment of the present inventionData processing equipmentSome or all parts in equipment some or all Function.The present invention be also implemented as perform method as described herein part or all Equipment or device program (such as, computer program and computer program).Such realization is originally The program of invention can store on a computer-readable medium, or can have one or more signal Form.Such signal can be downloaded from internet website and obtain, or provides on carrier signal, Or provide with any other form.

The present invention will be described rather than limits the invention to it should be noted above-described embodiment, And those skilled in the art can design replacement without departing from the scope of the appended claims Embodiment.In the claims, any reference marks that should not will be located between bracket is configured to right The restriction required.Word " comprises " and does not excludes the presence of the element or step not arranged in the claims.Position Word "a" or "an" before element does not excludes the presence of multiple such element.The present invention can With by means of including the hardware of some different elements and realizing by means of properly programmed computer. If in the unit claim listing equipment for drying, several in these devices can be by same Individual hardware branch specifically embodies.Word first, second and third use do not indicate that any order. Can be title by these word explanations.

The invention discloses A1, a kind of data processing method, including:

Inner core is obtained to result data table from first server system;

Obtain the same files generated by each second server；

Each same files is collected with affiliated second server for dimension；

A2, method as described in A1, also include:

A3, method as described in A2, the described form according to corresponding described second server changes rule Then, every record data in the same files after collecting, be converted to and described inner core logarithm Include according to every conversion data in the first tables of data that literary name section matches:

A4, method as described in A1, described treat Nuclear Data by the first tables of data every, with inside Checked result tables of data verifies；Treat that Nuclear Data inserts the first outer kernel pair by do not meet verification condition Error list is to carry out checking error logging；By meet insertion first outer kernel of verification condition to success table with Carry out checking successfully record to include:

A5, method as described in A4, described will treat Nuclear Data insert the first outer kernel to error list with Carry out checking error logging to include:

A6, method as described in A5, also include:

A7, method as described in A5, described by each same files with affiliated second server After collecting for dimension, also include:

A8, method as described in A1, described obtain inner core to number of results from first server system Include according to table:

A9, method as described in A9, described with the first Transaction Information table as standard, conclude the business second Every transaction data and the first Transaction Information table in information table are checked, thus obtain inner core to knot Really tables of data includes:

The invention also discloses A10, a kind of data processing equipment, including:

A11, device as described in A10, also include:

A12, device as described in A11, described standard handovers module includes:

A13, device as described in A10, described verification module includes:

A14, device as described in A13, each correction verification module includes:

A15, device as described in A14, also include:

A16, device as described in A15, described collection module also includes:

A17, device as described in A10, result data table acquisition module is included by described inner core:

A18, device as described in A17, described with the first inner core to result data table acquisition module Including:

Claims

1. a data processing method, including:

Inner core is obtained to result data table from first server system；

Obtain the same files generated by each second server；

Each same files is collected with affiliated second server for dimension；

Treat Nuclear Data by the first tables of data every, with inner core, result data table is verified；Will not Meet verification condition treats that Nuclear Data inserts the first outer kernel to error list to carry out checking error logging；Will Meet insertion first outer kernel of verification condition to success table to check successfully record；

Wherein, also include:

2. the method for claim 1, it is characterised in that described according to described second clothes of correspondence The form transformational rule of business device, every record data in the same files after collecting, be converted to Every conversion data in the first tables of data matched data sheet field with described inner core include:

3. the method for claim 1, it is characterised in that described by the first tables of data every Treat Nuclear Data, with inner core, result data table is verified；Nuclear Data is treated by do not meet verification condition Insert the first outer kernel to error list to carry out checking error logging；The insertion first of verification condition will be met Success table is included by outer kernel to check successfully record:

4. method as claimed in claim 3, it is characterised in that described will treat Nuclear Data insertion first Error list is included by outer kernel to carry out verification error logging:

5. method as claimed in claim 4, it is characterised in that also include:

6. method as claimed in claim 4, it is characterised in that described by each same files with Affiliated second server is, after dimension is collected, also to include:

7. the method for claim 1, it is characterised in that described obtain from first server system Take inner core result data table is included:

8. method as claimed in claim 7, it is characterised in that described with the first Transaction Information table be Standard, checks every transaction data in the second Transaction Information table and the first Transaction Information table, from And obtain inner core and result data table is included:

9. a data processing equipment, including:

Inner core, to result data table acquisition module, is suitable to obtain inner core to knot from first server system Really tables of data；

Verification module, is suitable to treat Nuclear Data by the first tables of data every, with inner core to result data table Verify；Treat that Nuclear Data inserts the first outer kernel to error list to carry out core by do not meet verification condition To error logging；Success table is successfully remembered by insertion the first outer kernel meeting verification condition to check Record；

Wherein, also include:

10. device as claimed in claim 9, it is characterised in that described standard handovers module includes:

11. devices as claimed in claim 9, it is characterised in that described verification module includes:

12. devices as claimed in claim 11, it is characterised in that each correction verification module includes:

13. devices as claimed in claim 12, it is characterised in that also include:

14. devices as claimed in claim 13, it is characterised in that described collection module also includes:

15. devices as claimed in claim 9, it is characterised in that described inner core is to result data table Acquisition module includes:

16. devices as claimed in claim 15, it is characterised in that described with the first inner core to knot Really tables of data acquisition module includes: