CN103345487A - Method and system of verifying data consistency between multiple platforms - Google Patents

Method and system of verifying data consistency between multiple platforms Download PDF

Info

Publication number
CN103345487A
CN103345487A CN2013102531922A CN201310253192A CN103345487A CN 103345487 A CN103345487 A CN 103345487A CN 2013102531922 A CN2013102531922 A CN 2013102531922A CN 201310253192 A CN201310253192 A CN 201310253192A CN 103345487 A CN103345487 A CN 103345487A
Authority
CN
China
Prior art keywords
characteristic parameter
platform
parameter information
data
information
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN2013102531922A
Other languages
Chinese (zh)
Other versions
CN103345487B (en
Inventor
徐洪周
柴昱
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Qihoo Technology Co Ltd
Qizhi Software Beijing Co Ltd
Original Assignee
Beijing Qihoo Technology Co Ltd
Qizhi Software Beijing Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Qihoo Technology Co Ltd, Qizhi Software Beijing Co Ltd filed Critical Beijing Qihoo Technology Co Ltd
Priority to CN201310253192.2A priority Critical patent/CN103345487B/en
Publication of CN103345487A publication Critical patent/CN103345487A/en
Application granted granted Critical
Publication of CN103345487B publication Critical patent/CN103345487B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Abstract

The invention discloses a method of verifying data consistency between multiple platforms. The multiple platforms comprise a first platform and a second platform which is in communication with the first platform. The method comprises the following steps that platform data interaction information of the first platform within a preset time range is collected, and first characteristic parameter information is extracted from the platform data interaction information and written in a first information table; data recording information of the second platform is obtained within the corresponding preset time range, and second characteristic parameter information is extracted from the data recording information and written in a second information table; whether corresponding interaction data characteristic values in the first characteristic parameter information and the second characteristic parameter information are consistent or not is judged. By means of the method, data distributed between the platforms can be automatically obtained and compared, inconsistent interaction data characteristic values between the platforms can be accurately and timely found, human participation is reduced, and waste of resources of the platforms is reduced.

Description

A kind of multi-platform between the method and system of data consistency verification
Technical field
The present invention relates to technical field of data processing, be specifically related to a kind of multi-platform between the method and system of data consistency verification.
Background technology
Now, universal day by day along with network, ecommerce has incorporated in the middle of the daily life.Ecommerce on the ordinary meaning typically refers in the commerce and trade activity widely of all parts of the world, under the open network environment in the Internet, based on the browser/server application mode, both parties do not carry out various commercial activities with meeting, realize a kind of novel commercial operation pattern of consumer's shopping online, the online transaction between the trade company and online E-Payment and various commercial activity, transaction, finance activities and relevant integrated service activity.
Ecommerce was flourish in the last few years, this makes physically independent, the task of the data consistency comparison verification between each platform of being mutually related again on the business is more and more arduous, and data consistency comparison detection is one of business platform robustness leading indicator between each platform, and indispensable.If this afunction can seriously cause the uncertainty of business datum between platform, and then cause problems such as service exception, charging ambiguity.
Summary of the invention
In view of the above problems, the present invention has been proposed in case provide a kind of kind that overcomes the problems referred to above or address the above problem at least in part multi-platform between the data consistency verification method and plant accordingly multi-platform between the system of data consistency verification.
According to one aspect of the present invention, provide a kind of multi-platform between the method for data consistency verification, described multi-platform first platform and second platform that comprises mutual communication, described method comprises:
Collect the platform data interactive information of first platform in the Preset Time section, from described platform data interactive information, extract the first characteristic parameter information and write first information table; Described characteristic parameter information comprises: the first platform data service identification, and the interaction data character numerical value, and, first data treatment state sign;
Obtain the data recording information of second platform in corresponding Preset Time section, the second characteristic parameter information of extracting from described data recording information writes second information table; Wherein, the described second characteristic parameter information comprises: the second platform data service identification, and the first platform data service identification of the described second platform data service identification association, the interaction data character numerical value, and, second data treatment state sign;
Extract the second characteristic parameter information in described second information table one by one, according to first corresponding in the described first information table of the described second characteristic parameter information extraction characteristic parameter information;
Judge whether interaction data character numerical value corresponding in the described first characteristic parameter information and the second characteristic parameter information is consistent;
If consistent, then the described first data treatment state identification renewal is the clearance completion status, the described second data treatment state identification renewal is the comparison completion status;
If inconsistent, then the described second data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the second characteristic parameter information of extraction writes the 3rd information table.
Alternatively, the step of the first corresponding characteristic parameter information comprises in the described first information table of the described foundation second characteristic parameter information extraction:
Extract the first platform data service identification of the second platform data service identification association described in the described second characteristic parameter information;
In described first information table, extract the first corresponding characteristic parameter information according to the described first platform data service identification.
Alternatively, described method also comprises:
When described first information table is consistent with the interaction data character numerical value of correspondence in second information table, extracts the corresponding first characteristic parameter information and/or the second characteristic parameter information and write the 4th information table.
Alternatively, also comprise type of error in described the 3rd information table; Described method also comprises:
When the first corresponding characteristic parameter information was failed in according to the described first information table of the described second characteristic parameter information extraction, the type of error that upgrades in described the 3rd information table was the type of error of data search failure;
When the interaction data character numerical value of correspondence was inconsistent in described first information table and second information table, the type of error that upgrades in described the 3rd information table was the inconsistent type of errors of data.
Alternatively, described the 3rd information table also comprises the processing type, and described processing type comprises be untreated type and the type of finishing dealing with; Described method also comprises:
Traveling through described the 3rd information table is that untreated data recording is handled one by one to handling type, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.
Alternatively, described multi-platform mutual communication first platform and the 3rd platform of also comprising; Described method also comprises:
Obtain the data recording information of the 3rd platform in corresponding Preset Time section, the 3rd characteristic parameter information of extracting from described data recording information writes the 5th information table; Wherein, described the 3rd characteristic parameter information comprises: the 3rd platform data service identification, and the first platform data service identification of described the 3rd platform data service identification association, the interaction data character numerical value, and, the 3rd data treatment state sign;
Extract the 3rd characteristic parameter information in described the 5th information table one by one, according to first corresponding in the described first information table of described the 3rd characteristic parameter information extraction characteristic parameter information;
Judge whether interaction data character numerical value corresponding in the described first characteristic parameter information and the 3rd characteristic parameter information is consistent;
If consistent, then the described first data treatment state identification renewal is the clearance completion status, described the 3rd data treatment state identification renewal is the comparison completion status;
If inconsistent, then described the 3rd data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information of extraction writes the 3rd information table.
Alternatively, the step of the first corresponding characteristic parameter information comprises in the described first information table of described foundation the 3rd characteristic parameter information extraction:
Extract the first platform data service identification of the 3rd platform data service identification association described in described the 3rd characteristic parameter information;
In described first information table, extract the first corresponding characteristic parameter information according to the described first platform data service identification.
Alternatively, described method also comprises:
When described first information table is consistent with the interaction data character numerical value of correspondence in the 3rd information table, extracts the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information and write the 4th information table.
Alternatively, described method also comprises:
When the first corresponding characteristic parameter information was failed in according to the described first information table of described the 3rd characteristic parameter information extraction, the type of error that upgrades in described the 3rd information table was the type of error of data search failure;
When the interaction data character numerical value of correspondence was inconsistent in described the 5th information table and second information table, the type of error that upgrades in described the 3rd information table was the inconsistent type of errors of data.
Alternatively, described method also comprises:
Traveling through described the 3rd information table is that untreated data recording is handled one by one to handling type, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.
Alternatively, described first platform is third party's payment platform, and described second platform is the banking system platform, and described the 3rd platform is the e-business network platform; The described first platform data service identification is the transaction odd numbers of third party's payment platform; The described second platform data service identification is the transaction odd numbers of banking system platform; Described the 3rd platform data service identification is the transaction odd numbers of e-business network platform; Described interaction data character numerical value is dealing money.
According to a further aspect in the invention, provide a kind of multi-platform between the system of data consistency verification, described multi-platform first platform and second platform that comprises mutual communication, described system comprises:
Collection module is used for collecting the platform data interactive information of first platform in the Preset Time section, extracts the first characteristic parameter information and write first information table from described platform data interactive information; Described characteristic parameter information comprises: the first platform data service identification, and the interaction data character numerical value, and, first data treatment state sign;
Acquisition module is used for obtaining the data recording information of second platform in corresponding Preset Time section, and the second characteristic parameter information of extracting from described data recording information writes second information table; Wherein, the described second characteristic parameter information comprises: the second platform data service identification, and the first platform data service identification of the described second platform data service identification association, the interaction data character numerical value, and, second data treatment state sign;
Extraction module is used for extracting one by one described second information table, the second characteristic parameter information, according to first corresponding in the described first information table of the described second characteristic parameter information extraction characteristic parameter information;
Judge module is used for judging whether the corresponding interaction data character numerical value of the described first characteristic parameter information and the second characteristic parameter information is consistent;
Update module, be used for if the described first characteristic parameter information is consistent with the interaction data character numerical value of second characteristic parameter information correspondence, then the described first data treatment state identification renewal is the clearance completion status, the described second data treatment state identification renewal is the comparison completion status;
And, if interaction data character numerical value corresponding in the described first characteristic parameter information and the second characteristic parameter information is inconsistent, then the described second data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the second characteristic parameter information of extraction writes the 3rd information table.
Alternatively, described extraction module comprises:
Sign is extracted submodule, is used for extracting the first platform data service identification of the second platform data service identification association described in the described second characteristic parameter information;
Parameter is searched submodule, is used for extracting the first corresponding characteristic parameter information according to the described first platform data service identification at described first information table.
Alternatively, wherein,
Described update module also is used for extracting the corresponding first characteristic parameter information and/or the second characteristic parameter information and writing the 4th information table when the corresponding interaction data character numerical value of described first information table and second information table is consistent.
Alternatively, also comprise type of error in described the 3rd information table; Described system also comprises:
The type update module is used for when failing according to the first corresponding characteristic parameter information of the described first information table of the described second characteristic parameter information extraction, and the type of error that upgrades in described the 3rd information table is the type of error of data search failure;
And described type update module also is used for when the interaction data character numerical value of described first information table and second information table correspondence is inconsistent, and the type of error that upgrades in described the 3rd information table is the inconsistent type of errors of data.
Alternatively, described the 3rd information table also comprises the processing type, and described processing type comprises be untreated type and the type of finishing dealing with; Described system also comprises:
It is that untreated data recording is handled one by one to handling type that described traversal processing module also is used for described the 3rd information table of traversal, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.
Alternatively, described multi-platform first platform and the 3rd platform that also comprises mutual communication; Described system also comprises:
Described acquisition module also is used for obtaining the data recording information of the 3rd platform in corresponding Preset Time section, and the 3rd characteristic parameter information of extracting from described data recording information writes the 5th information table; Wherein, described the 3rd characteristic parameter information comprises: the 3rd platform data service identification, and the first platform data service identification of described the 3rd platform data service identification association, the interaction data character numerical value, and, the 3rd data treatment state sign;
Described extraction module also is used for extracting one by one described the 5th information table the 3rd characteristic parameter information, according to first corresponding in the described first information table of described the 3rd characteristic parameter information extraction characteristic parameter information;
Judge module is used for also judging whether the corresponding interaction data character numerical value of the described first characteristic parameter information and the 3rd characteristic parameter information is consistent;
Described update module also is used for if the described first characteristic parameter information is consistent with the interaction data character numerical value of the 3rd characteristic parameter information correspondence, then the described first data treatment state identification renewal is the clearance completion status, described the 3rd data treatment state identification renewal is the comparison completion status;
Described update module also is used for if the interaction data character numerical value of the described first characteristic parameter information and the 3rd characteristic parameter information correspondence is inconsistent, then described the 3rd data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information of extraction writes the 3rd information table.
Alternatively, described extraction module comprises:
Described sign is extracted the first platform data service identification that submodule also is used for extracting the 3rd platform data service identification association described in described the 3rd characteristic parameter information;
Described parameter extraction submodule also is used for extracting the first corresponding characteristic parameter information according to the described first platform data service identification at described first information table.
Alternatively, wherein,
Described update module also is used for extracting the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information and writing the 4th information table when the corresponding interaction data character numerical value of described first information table and the 5th information table is consistent.
Alternatively, described system also comprises:
Described type update module also is used for when failing according to the first corresponding characteristic parameter information of the described first information table of described the 3rd characteristic parameter information extraction, and the type of error that upgrades in described the 3rd information table is the type of error of data search failure;
And described type update module also is used for when the interaction data character numerical value of described the 5th information table and second information table correspondence is inconsistent, and the type of error that upgrades in described the 3rd information table is the inconsistent type of errors of data.
Alternatively, described system also comprises:
It is that untreated data recording is handled one by one to handling type that described traversal processing module also is used for described the 3rd information table of traversal, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.
According to of the present invention a kind of multi-platform between the method and system of data consistency verification, can obtain automatically and compare the data that are distributed between the platform, can be accurately and in time find inconsistent interaction data character numerical value between platform, reduce artificial participation, reduced expending of platform resource.The present invention can adopt database to carry out the comparison of data between the platform, so the transaction functionality that can directly utilize database itself to have, in case can guarantee the machine of delaying or since the execution that causes of other reasons interrupt, can from the beginning re-execute, and can not produce intermediate data realizes simply having reduced development difficulty.In addition; the present invention can also provide automatic alarming mechanism; if the data of platform are not obtained success; can send mail or SMS alarm; make the O﹠M personnel go to contact the relevant responsible official of each platform; go data query to obtain the concrete reason of failure; solved thus multi-platform between the uncertainty of data; and then problem such as the service exception that causes, charging ambiguity; obtained improve multi-platform between the efficient of data check; protected multi-platform between the consistance of data, guaranteed the beneficial effect of robustness professional between multi-platform.
Above-mentioned explanation only is the general introduction of technical solution of the present invention, for can clearer understanding technological means of the present invention, and can be implemented according to the content of instructions, and for above and other objects of the present invention, feature and advantage can be become apparent, below especially exemplified by the specific embodiment of the present invention.
Description of drawings
By reading hereinafter detailed description of the preferred embodiment, various other advantage and benefits will become cheer and bright for those of ordinary skills.Accompanying drawing only is used for the purpose of preferred implementation is shown, and does not think limitation of the present invention.And in whole accompanying drawing, represent identical parts with identical reference symbol.In the accompanying drawings:
Fig. 1 shows the flow chart of steps according to the method embodiment of data consistency verification between one embodiment of the invention 1 a kind of multi-platform;
Fig. 2 shows the flow chart of steps according to the part of the method embodiment of data consistency verification between one embodiment of the invention 2 a kind of multi-platform;
Fig. 3 shows the structured flowchart according to the system embodiment of data consistency verification between one embodiment of the invention 1 a kind of multi-platform;
Fig. 4 show according to the system embodiment part of data consistency verification between one embodiment of the invention 2 a kind of multi-platform structured flowchart.
Embodiment
Exemplary embodiment of the present disclosure is described below with reference to accompanying drawings in more detail.Though shown exemplary embodiment of the present disclosure in the accompanying drawing, yet should be appreciated that and to realize the disclosure and the embodiment that should do not set forth limits here with various forms.On the contrary, it is in order to understand the disclosure more thoroughly that these embodiment are provided, and can with the scope of the present disclosure complete convey to those skilled in the art.
With reference to Fig. 1, show of the present invention a kind of multi-platform between the flow chart of steps of method embodiment of data consistency verification, described multi-platform first platform and second platform that can comprise mutual communication, described method can comprise the steps:
Step S101 collects the platform data interactive information of first platform in the Preset Time section, extracts the first characteristic parameter information and write first information table from described platform data interactive information; Described characteristic parameter information comprises: the first platform data service identification, and the interaction data character numerical value, and, first data treatment state sign;
Step S103 obtains the data recording information of second platform in corresponding Preset Time section, and the second characteristic parameter information of extracting from described data recording information writes second information table; Wherein, the described second characteristic parameter information comprises: the second platform data service identification, and the first platform data service identification of the described second platform data service identification association, the interaction data character numerical value, and, second data treatment state sign;
Step S105 extracts the second characteristic parameter information in described second information table one by one, according to first corresponding in the described first information table of the described second characteristic parameter information extraction characteristic parameter information;
Step S107 judges whether interaction data character numerical value corresponding in the described first characteristic parameter information and the second characteristic parameter information is consistent; If unanimity, then execution in step S109; If inconsistent, execution in step S111 then;
Step S109 is the clearance completion status with the described first data treatment state identification renewal, and the described second data treatment state identification renewal is the comparison completion status;
Step S111 the described second data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the second characteristic parameter information of extraction writes the 3rd information table.
In order to make those skilled in the art further understand the embodiment of the invention, below will come by the verification of transaction record in the ecommerce embodiment of the invention is elaborated.
In ecommerce, described first platform can be third party's payment platform, and described second platform can be the banking system platform, and described the 3rd platform can be the e-commerce website platform; The described first platform data service identification can be the transaction odd numbers of third party's payment platform; The described second platform data service identification can be the transaction odd numbers of banking system platform; Described the 3rd platform data service identification can be the transaction odd numbers of e-commerce website platform; Described interaction data character numerical value can be dealing money.
Need to prove that so-called third party's payment platform is some and product the country one belongs to and each big bank's system platform is signatory and possess the transaction supporting platform that third party's independent agency of certain strength and prestige guarantee provides abroad.In passing through the transaction of third party's payment platform, after buyer's free choice of goods, the account of using third party's payment platform to provide is carried out the payment for goods payment, is arrived, is delivered by the payment for goods of third party's payment platform notice e-business network platform; Behind buyer's item inspecting, just can give the e-business network platform by advice and pay, third party's payment platform goes to fund the account of e-business network platform again.
In embodiments of the present invention, carrying out the transaction record verification between the different platform can be to use the transaction record that obtains from third party's payment platform and banking system platform to import the verification of comparing the database, because the part transaction record might be arranged, after third party's payment platform sends, the banking system platform may not received or not handle, and it is relatively rationally and accurately that the transaction record that therefore uses the banking system platform to handle is compared.
In specific implementation, because the original transaction record of each platform is often because the emphasis difference, the content field of record is also different, if use the tran list that is used for the record transaction record originally, can't satisfy the requirement of data consistency between the verification platform, so, need usually to use independent table to record and verification.The key element of the tran list of each platform generally has external trigger to produce the transaction odd numbers of the e-business network platform of this transaction, the time is initiated in the transaction of e-business network platform, the time is initiated in the transaction of third party's payment platform, the transaction deadline of third party's payment platform, the transaction deadline of banking system platform, the transaction odd numbers that the banking system platform returns, the dealing money of banking system platform, the stateful transaction of banking system platform, etc.And the factor that the transaction record of comparison verification need be considered is the transaction odd numbers of third party's payment platform, the transaction odd numbers of banking system platform, the dealing money of banking system platform, whether the exchange hour of banking system platform participated in comparison, and whether data are consistent, the reason of mistake, etc.Because there is certain difference in both, it is more convenient therefore to use independent table to carry out verification.
At first, the cycle that can determine to carry out verification is a nature day, two o'clock in the morning every day (cycle and time only are for example), third party's payment platform can be collected in the platform data interactive information in this cycle, the transaction record that is itself and banking system platform writes first information table (collecting table), collect the data recording information of banking system platform then, namely write second information table (external record table) with third party's payment platform transaction record and compare verification, if find that the transaction record of third party's payment platform is consistent with the transaction data of banking system platform, then this transaction record can be write the 4th information table (outer flat table), and will collect the table in the first data treatment state identification renewal for the clearance completion status, with the second data treatment state identification renewal in the external record table for the comparison completion status; If the transaction record of discovery third party payment platform and the dealing money of banking system platform are inconsistent, then this transaction record can be write the 3rd information table (heterodyne table), and the second data treatment state identification renewal of external record table is clearance comparison state.
Preferably, third party's payment platform obtains the log file of the transaction record of banking system platform generation, can use FTP (File Transfer Protocol, file transfer protocol (FTP)) obtains, it is every day to the set time, banking system platform copy log file exposes on the path position of FTP service on specified server, path :/home/ftp/ for example, the position that this path is exposed to remote computer is FTP: //xxx.xxx.xxx.xxx./, this path position can be a position of appointing in advance, third party's payment platform can be by the username and password of deciding through consultation in advance like this, and go this path position to obtain log file in the set time every day.
In a preferred embodiment of the present invention, described step S105 is to comprise following substep:
Substep S11 extracts the first platform data service identification of the second platform data service identification association described in the described second characteristic parameter information;
Substep S12 extracts the first corresponding characteristic parameter information according to the described first platform data service identification in described first information table.
In practice, the transaction record that obtains and write the external record table from the banking system platform has the transaction odd numbers that is associated with third party's payment platform, can extract the transaction record of corresponding third party's payment platform according to the transaction odd numbers of banking system platform from the collection table.
Alternatively, described method can also comprise:
When described first information table is consistent with the interaction data character numerical value of correspondence in second information table, extracts the corresponding first characteristic parameter information and/or the second characteristic parameter information and write the 4th information table.
In embodiments of the present invention, if it is consistent with the transaction record of correspondence in the external record table to collect table, can extract the outer flat table of writing of this transaction record, represent that this transaction has been cleared to finish that banking system platform and third party's payment platform have been finished this transaction.In addition, if it is inconsistent to collect transaction record corresponding in table and the external transaction table, can extract this transaction record and write the heterodyne table, represent that this transaction is cleared as yet to finish, banking system platform and third party's payment platform are not also finished this transaction, the also subsequent treatment that need be correlated with.
Alternatively, can also comprise type of error in described the 3rd information table; Described method can also comprise:
When the first corresponding characteristic parameter information was failed in according to the described first information table of the described second characteristic parameter information extraction, the type of error that upgrades in described the 3rd information table was the type of error of data search failure;
When the interaction data character numerical value of correspondence was inconsistent in described first information table and second information table, the type of error that upgrades in described the 3rd information table was the inconsistent type of errors of data.
In embodiments of the present invention, in the heterodyne table, can increase a field: type of error.If the transaction odd numbers that is associated with third party's payment platform at foundation banking system platform obtains transaction record in the collection table when failing, this field is updated to the type of error of data search failure, the transaction record failure is searched in expression, there is no the transaction record relevant with the banking system platform in the collection table.If the transaction record that the transaction odd numbers that is associated with third party's payment platform according to the banking system platform obtains in the collection table is successful, but the dealing money of discovery both sides' transaction record is inconsistent, then this field is updated to the inconsistent type of error of data, the record of expression third party payment platform may be wrong, perhaps upgrade as yet, reach synchronous with the transaction record of banking system platform.
Alternatively, described the 3rd information table can also comprise the processing type, and described processing type can comprise be untreated type and the type of finishing dealing with; Described method can also comprise:
Traveling through described the 3rd information table is that untreated data recording is handled one by one to handling type, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.
In embodiments of the present invention, in the heterodyne table, can increase a field: handle type, wherein, handle type and can comprise be untreated type and the type of finishing dealing with.Every transaction record for adding the heterodyne table finally all needs to handle, so every transaction record of heterodyne table can handled attribute of type mark, whether expression finishes dealing with.For the transaction record in heterodyne table precipitation, the O﹠M personnel can go to link up with the personnel of banking system platform according to the transaction odd numbers, search error reason, and the sign of " finishing dealing with " all stamped in the All Activity of heterodyne table record the most at last.
Need to prove, the mode that transaction record carries out verification can have a variety of, can use database in embodiments of the present invention, database has transaction functionality, in case can guarantee like this machine of delaying or since the execution that causes of other reasons interrupt, can from the beginning re-execute, and can not produce intermediate data.Selecting that in embodiments of the present invention transaction record is imported database compares again, benefit is to take full advantage of a lot of existing capabilitys that database provides, for example can sort according to each field, use the businesslike function of database, SQL query function easily, etc., and realize simply can saving a lot of development times.
With reference to Fig. 2, show the flow chart of steps according to the part of the method embodiment of data consistency verification between one embodiment of the invention 2 a kind of multi-platform; On the basis of the above embodiment of the present invention 1, described multi-platform first platform and the 3rd platform that can also comprise mutual communication; Described method can also comprise the steps:
Step S201 obtains the data recording information of the 3rd platform in corresponding Preset Time section, and the 3rd characteristic parameter information of extracting from described data recording information writes the 5th information table; Wherein, described the 3rd characteristic parameter information comprises: the 3rd platform data service identification, and the first platform data service identification of described the 3rd platform data service identification association, the interaction data character numerical value, and, the 3rd data treatment state sign;
Step S203 extracts the 3rd characteristic parameter information in described the 5th information table one by one, according to first corresponding in the described first information table of described the 3rd characteristic parameter information extraction characteristic parameter information;
Step S205 judges whether interaction data character numerical value corresponding in the described first characteristic parameter information and the 3rd characteristic parameter information is consistent; If unanimity, then execution in step S207; If inconsistent, execution in step S209 then;
Step S207 is the clearance completion status with the described first data treatment state identification renewal, and described the 3rd data treatment state identification renewal is the comparison completion status;
Step S209 described the 3rd data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and the 3rd characteristic parameter information of extraction writes the 3rd information table.
In a preferred embodiment of the present invention, described the 3rd platform can be the e-commerce website platform; Described the 3rd platform data service identification can be the transaction odd numbers of e-commerce website platform; Described interaction data character numerical value can be dealing money.
In a preferred embodiment of the present invention, described step S203 can comprise following substep:
Substep S21 extracts the first platform data service identification of the 3rd platform data service identification association described in described the 3rd characteristic parameter information;
Substep S22 extracts the first corresponding characteristic parameter information according to the described first platform data service identification in described first information table.
Alternatively, described method can also comprise:
When described first information table is consistent with the interaction data character numerical value of correspondence in the 5th information table, extracts the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information and write the 4th information table.
Alternatively, can also comprise type of error in described the 3rd information table; Described method can also comprise:
When the first corresponding characteristic parameter information was failed in according to the described first information table of described the 3rd characteristic parameter information extraction, the type of error that upgrades in described the 3rd information table was the type of error of data search failure;
When the interaction data character numerical value of correspondence was inconsistent in described the 5th information table and second information table, the type of error that upgrades in described the 3rd information table was the inconsistent type of errors of data.
Alternatively, described the 3rd information table can also comprise the processing type, and described processing type can comprise be untreated type and the type of finishing dealing with; Described method can also comprise:
Traveling through described the 3rd information table is that untreated data recording is handled one by one to handling type, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.
Because e-business network platform and third party's payment platform, the mode of comparing of the transaction record between banking system platform and the third party's payment platform is similar substantially to the method embodiment of Fig. 1, so that describes is fairly simple, relevant part gets final product referring to the part explanation of method embodiment.
For method embodiment, for simple description, so it all is expressed as a series of combination of actions, but those skilled in the art should know, the present invention is not subjected to the restriction of described sequence of movement, because according to the present invention, some step can adopt other orders or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in the instructions all belongs to preferred embodiment, and related action and module might not be that the present invention is necessary.
With reference to Fig. 3, show the structured flowchart according to the system embodiment of data consistency verification between one embodiment of the invention 1 a kind of multi-platform, described multi-platform first platform and second platform that can comprise mutual communication, described system can comprise as lower module:
Collection module 301 is used for collecting the platform data interactive information of first platform in the Preset Time section, extracts the first characteristic parameter information and write first information table from described platform data interactive information; Described characteristic parameter information comprises: the first platform data service identification, and the interaction data character numerical value, and, first data treatment state sign;
Acquisition module 303 is used for obtaining the data recording information of second platform in corresponding Preset Time section, and the second characteristic parameter information of extracting from described data recording information writes second information table; Wherein, the described second characteristic parameter information comprises: the second platform data service identification, and the first platform data service identification of the described second platform data service identification association, the interaction data character numerical value, and, second data treatment state sign;
Extraction module 305 is used for extracting one by one described second information table, the second characteristic parameter information, according to first corresponding in the described first information table of the described second characteristic parameter information extraction characteristic parameter information;
Judge module 307 is used for judging whether the corresponding interaction data character numerical value of the described first characteristic parameter information and the second characteristic parameter information is consistent;
Update module 309, be used for if the described first characteristic parameter information is consistent with the interaction data character numerical value of second characteristic parameter information correspondence, then the described first data treatment state identification renewal is the clearance completion status, the described second data treatment state identification renewal is the comparison completion status;
And, if interaction data character numerical value corresponding in the described first characteristic parameter information and the second characteristic parameter information is inconsistent, then the described second data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and the second characteristic parameter information of extraction writes the 3rd information table.
In a preferred embodiment of the present invention, described extraction module 305 can comprise:
Sign is extracted submodule, is used for extracting the first platform data service identification of the second platform data service identification association described in the described second characteristic parameter information;
Parameter is searched submodule, is used for extracting the first corresponding characteristic parameter information according to the described first platform data service identification at described first information table.
Alternatively, described system can also comprise:
Described update module 309 also is used for extracting the corresponding first characteristic parameter information and the second characteristic parameter information and writing the 4th information table when the corresponding interaction data character numerical value of described first information table and second information table is consistent.
Alternatively, can also comprise type of error in described the 3rd information table; Described system can also comprise:
The type update module is used for when failing according to the first corresponding characteristic parameter information of the described first information table of the described second characteristic parameter information extraction, and the type of error that upgrades in described the 3rd information table is the type of error of data search failure;
And described type update module also is used for when the interaction data character numerical value of described first information table and second information table correspondence is inconsistent, and the type of error that upgrades in described the 3rd information table is the inconsistent type of errors of data.
Alternatively, described the 3rd information table can also comprise the processing type, and described processing type can comprise be untreated type and the type of finishing dealing with; Described system can also comprise:
The traversal processing module, being used for described the 3rd information table of traversal is that untreated data recording is handled one by one to handling type, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.
For the system embodiment of Fig. 3, because its method embodiment to Fig. 1 is similar substantially, so description is fairly simple, relevant part gets final product referring to the part explanation of method embodiment.
With reference to Fig. 4, show a kind of according to an embodiment of the invention multi-platform between the structured flowchart of a part of system embodiment 2 of data consistency verification, on the basis of the above embodiment of the present invention 3, described multi-platform first platform of mutual communication that can also comprise carries out and the 3rd platform; Described system can also comprise as lower module:
Described acquisition module S401 also is used for obtaining the data recording information of the 3rd platform in corresponding Preset Time section, and the 3rd characteristic parameter information of extracting from described data recording information writes the 5th information table; Wherein, described the 3rd characteristic parameter information comprises: the 3rd platform data service identification, and the first platform data service identification of described the 3rd platform data service identification association, the interaction data character numerical value, and, the 3rd data treatment state sign;
Described extraction module S403 also is used for extracting one by one described the 5th information table the 3rd characteristic parameter information, according to first corresponding in the described first information table of described the 3rd characteristic parameter information extraction characteristic parameter information;
Described judge module S405 is used for also judging whether the corresponding interaction data character numerical value of the described first characteristic parameter information and the 3rd characteristic parameter information is consistent;
Described update module S407, be used for if the described first characteristic parameter information is consistent with the interaction data character numerical value of the 3rd characteristic parameter information correspondence, then the described first data treatment state identification renewal is the clearance completion status, described the 3rd data treatment state identification renewal is the comparison completion status;
Described update module S407 also is used for if the interaction data character numerical value of the described first characteristic parameter information and the 3rd characteristic parameter information correspondence is inconsistent, then described the 3rd data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information of extraction writes the 3rd information table.
In a preferred embodiment of the present invention, described extraction module S403 can comprise:
Described sign is extracted the first platform data service identification that submodule also is used for extracting the 3rd platform data service identification association described in described the 3rd characteristic parameter information;
Described parameter extraction submodule also is used for extracting the first corresponding characteristic parameter information according to the described first platform data service identification at described first information table.
Alternatively, described system can also comprise:
Described update module S407 also is used for extracting the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information and writing the 4th information table when the corresponding interaction data character numerical value of described first information table and the 5th information table is consistent.
Alternatively, can also comprise type of error in described the 3rd information table; Described system can also comprise:
Described type update module also is used for when failing according to the first corresponding characteristic parameter information of the described first information table of described the 3rd characteristic parameter information extraction, and the type of error that upgrades in described the 3rd information table is the type of error of data search failure;
And described type update module also is used for when the interaction data character numerical value of described the 5th information table and second information table correspondence is inconsistent, and the type of error that upgrades in described the 3rd information table is the inconsistent type of errors of data.
Alternatively, described the 3rd information table can also comprise the processing type, and described processing type can comprise be untreated type and the type of finishing dealing with; Described system can also comprise:
It is that untreated data recording is handled one by one to handling type that the traversal processing module also is used for described the 3rd information table of traversal, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.
For the system embodiment of Fig. 4, because its method embodiment to Fig. 2 is similar substantially, so description is fairly simple, relevant part gets final product referring to the part explanation of method embodiment.
Intrinsic not relevant with any certain computer, virtual system or miscellaneous equipment with demonstration at this algorithm that provides.Various general-purpose systems also can be with using based on the teaching at this.According to top description, it is apparent constructing the desired structure of this type systematic.In addition, the present invention is not also at any certain programmed language.Should be understood that and to utilize various programming languages to realize content of the present invention described here, and the top description that language-specific is done is in order to disclose preferred forms of the present invention.
In the instructions that provides herein, a large amount of details have been described.Yet, can understand, embodiments of the invention can be put into practice under the situation of these details not having.In some instances, be not shown specifically known method, structure and technology, so that not fuzzy understanding of this description.
Similarly, be to be understood that, in order to simplify the disclosure and to help to understand one or more in each inventive aspect, in the description to exemplary embodiment of the present invention, each feature of the present invention is grouped together in single embodiment, figure or the description to it sometimes in the above.Yet the method for the disclosure should be construed to the following intention of reflection: namely the present invention for required protection requires the more feature of feature clearly put down in writing than institute in each claim.Or rather, as following claims reflected, inventive aspect was to be less than all features of the disclosed single embodiment in front.Therefore, follow claims of embodiment and incorporate this embodiment thus clearly into, wherein each claim itself is as independent embodiment of the present invention.
Those skilled in the art are appreciated that and can adaptively change and they are arranged in one or more equipment different with this embodiment the module in the equipment among the embodiment.Can become a module or unit or assembly to the module among the embodiment or unit or combination of components, and can be divided into a plurality of submodules or subelement or sub-component to them in addition.In such feature and/or process or unit at least some are mutually repelling, and can adopt any combination to disclosed all features in this instructions (comprising claim, summary and the accompanying drawing followed) and so all processes or the unit of disclosed any method or equipment make up.Unless clearly statement in addition, disclosed each feature can be by providing identical, being equal to or the alternative features of similar purpose replaces in this instructions (comprising claim, summary and the accompanying drawing followed).
In addition, those skilled in the art can understand, although embodiment more described herein comprise some feature rather than further feature included among other embodiment, the combination of features of different embodiment means and is within the scope of the present invention and forms different embodiment.For example, in the following claims, the one of any of embodiment required for protection can be used with array mode arbitrarily.
Each parts embodiment of the present invention can realize with hardware, perhaps realizes with the software module of moving at one or more processor, and perhaps the combination with them realizes.It will be understood by those of skill in the art that and to use microprocessor or digital signal processor (DSP) to realize according to some or all some or repertoire of parts in the data consistency calibration equipment between the embodiment of the invention multi-platform in practice.The present invention can also be embodied as for part or all equipment or the device program (for example, computer program and computer program) of carrying out method as described herein.Such realization program of the present invention can be stored on the computer-readable medium, perhaps can have the form of one or more signal.Such signal can be downloaded from internet website and obtain, and perhaps provides at carrier signal, perhaps provides with any other form.
It should be noted above-described embodiment the present invention will be described rather than limit the invention, and those skilled in the art can design alternative embodiment under the situation of the scope that does not break away from claims.In the claims, any reference symbol between bracket should be configured to limitations on claims.Word " comprises " not to be got rid of existence and is not listed in element or step in the claim.Being positioned at word " " before the element or " one " does not get rid of and has a plurality of such elements.The present invention can realize by means of the hardware that includes some different elements and by means of the computing machine of suitably programming.In having enumerated the unit claim of some devices, several in these devices can be to come imbody by same hardware branch.Any order is not represented in the use of word first, second and C grade.Can be title with these word explanations.
Embodiments of the invention disclose A1, a kind of multi-platform between the method for data consistency verification, described multi-platform first platform and second platform that comprises mutual communication, described method comprises: collect the platform data interactive information of first platform in the Preset Time section, extract the first characteristic parameter information and write first information table from described platform data interactive information; Described characteristic parameter information comprises: the first platform data service identification, and the interaction data character numerical value, and, first data treatment state sign; Obtain the data recording information of second platform in corresponding Preset Time section, the second characteristic parameter information of extracting from described data recording information writes second information table; Wherein, the described second characteristic parameter information comprises: the second platform data service identification, and the first platform data service identification of the described second platform data service identification association, the interaction data character numerical value, and, second data treatment state sign; Extract the second characteristic parameter information in described second information table one by one, according to first corresponding in the described first information table of the described second characteristic parameter information extraction characteristic parameter information; Judge whether interaction data character numerical value corresponding in the described first characteristic parameter information and the second characteristic parameter information is consistent; If consistent, then the described first data treatment state identification renewal is the clearance completion status, the described second data treatment state identification renewal is the comparison completion status; If inconsistent, then the described second data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the second characteristic parameter information of extraction writes the 3rd information table.A2, as the described method of A1, the step of the first corresponding characteristic parameter information comprises in the described first information table of the described foundation second characteristic parameter information extraction: the first platform data service identification that extracts the second platform data service identification association described in the described second characteristic parameter information; In described first information table, extract the first corresponding characteristic parameter information according to the described first platform data service identification.A3, as the described method of A1, also comprise: when corresponding interaction data character numerical value was consistent in described first information table and second information table, the first characteristic parameter information and/or the second characteristic parameter information of extracting correspondence write the 4th information table.A4, as the described method of A1, also comprise type of error in described the 3rd information table; Described method also comprises: when the first corresponding characteristic parameter information was failed in according to the described first information table of the described second characteristic parameter information extraction, the type of error that upgrades in described the 3rd information table was the type of error of data search failure; When the interaction data character numerical value of correspondence was inconsistent in described first information table and second information table, the type of error that upgrades in described the 3rd information table was the inconsistent type of errors of data.A5, as the described method of A1, described the 3rd information table also comprises the processing type, described processing type comprises be untreated type and the type of finishing dealing with; Described method also comprises: traveling through described the 3rd information table is that untreated data recording is handled one by one to handling type, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.A6, as the described method of A1, described multi-platform mutual communication first platform and the 3rd platform of also comprising; Described method also comprises: obtain the data recording information of the 3rd platform in corresponding Preset Time section, the 3rd characteristic parameter information of extracting from described data recording information writes the 5th information table; Wherein, described the 3rd characteristic parameter information comprises: the 3rd platform data service identification, and the first platform data service identification of described the 3rd platform data service identification association, the interaction data character numerical value, and, the 3rd data treatment state sign; Extract the 3rd characteristic parameter information in described the 5th information table one by one, according to first corresponding in the described first information table of described the 3rd characteristic parameter information extraction characteristic parameter information; Judge whether interaction data character numerical value corresponding in the described first characteristic parameter information and the 3rd characteristic parameter information is consistent; If consistent, then the described first data treatment state identification renewal is the clearance completion status, described the 3rd data treatment state identification renewal is the comparison completion status; If inconsistent, then described the 3rd data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information of extraction writes the 3rd information table.A7, as the described method of A6, the step of the first corresponding characteristic parameter information comprises in the described first information table of described foundation the 3rd characteristic parameter information extraction: the first platform data service identification that extracts the 3rd platform data service identification association described in described the 3rd characteristic parameter information; In described first information table, extract the first corresponding characteristic parameter information according to the described first platform data service identification.A8, as A1 or the described method of A6, also comprise: when corresponding interaction data character numerical value was consistent in described first information table and the 3rd information table, the first characteristic parameter information and/or the 3rd characteristic parameter information of extracting correspondence write the 4th information table.A9, as A4 or the described method of A6, also comprise: when the first corresponding characteristic parameter information was failed in according to the described first information table of described the 3rd characteristic parameter information extraction, the type of error that upgrades in described the 3rd information table was the type of error of data search failure; When the interaction data character numerical value of correspondence was inconsistent in described the 5th information table and second information table, the type of error that upgrades in described the 3rd information table was the inconsistent type of errors of data.A10, as A1 or A5 or the described method of A7, also comprise: traveling through described the 3rd information table is that untreated data recording is handled one by one to handling type, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.A11, as the described method of A1, described first platform is third party's payment platform, described second platform is the banking system platform, described the 3rd platform is the e-business network platform; The described first platform data service identification is the transaction odd numbers of third party's payment platform; The described second platform data service identification is the transaction odd numbers of banking system platform; Described the 3rd platform data service identification is the transaction odd numbers of e-business network platform; Described interaction data character numerical value is dealing money.
According to embodiments of the invention also disclose B12, a kind of multi-platform between the system of data consistency verification, described multi-platform first platform and second platform that comprises mutual communication, described system comprises: collection module, be used for collecting the platform data interactive information of first platform in the Preset Time section, from described platform data interactive information, extract the first characteristic parameter information and write first information table; Described characteristic parameter information comprises: the first platform data service identification, and the interaction data character numerical value, and, first data treatment state sign; Acquisition module is used for obtaining the data recording information of second platform in corresponding Preset Time section, and the second characteristic parameter information of extracting from described data recording information writes second information table; Wherein, the described second characteristic parameter information comprises: the second platform data service identification, and the first platform data service identification of the described second platform data service identification association, the interaction data character numerical value, and, second data treatment state sign; Extraction module is used for extracting one by one described second information table, the second characteristic parameter information, according to first corresponding in the described first information table of the described second characteristic parameter information extraction characteristic parameter information; Judge module is used for judging whether the corresponding interaction data character numerical value of the described first characteristic parameter information and the second characteristic parameter information is consistent; Update module, be used for if the described first characteristic parameter information is consistent with the interaction data character numerical value of second characteristic parameter information correspondence, then the described first data treatment state identification renewal is the clearance completion status, the described second data treatment state identification renewal is the comparison completion status; And, if interaction data character numerical value corresponding in the described first characteristic parameter information and the second characteristic parameter information is inconsistent, then the described second data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the second characteristic parameter information of extraction writes the 3rd information table.B13, as the described system of B12, described extraction module comprises: sign is extracted submodule, is used for extracting the first platform data service identification of the second platform data service identification association described in the described second characteristic parameter information; Parameter is searched submodule, is used for extracting the first corresponding characteristic parameter information according to the described first platform data service identification at described first information table.B14, as the described system of B12, wherein, described update module also is used for extracting the corresponding first characteristic parameter information and/or the second characteristic parameter information and writing the 4th information table when the corresponding interaction data character numerical value of described first information table and second information table is consistent.B15, as the described system of B12, also comprise type of error in described the 3rd information table; Described system also comprises: the type update module, be used for when failing according to the first corresponding characteristic parameter information of the described first information table of the described second characteristic parameter information extraction, the type of error that upgrades in described the 3rd information table is the type of error of data search failure; And described type update module also is used for when the interaction data character numerical value of described first information table and second information table correspondence is inconsistent, and the type of error that upgrades in described the 3rd information table is the inconsistent type of errors of data.B16, as the described system of B12, described the 3rd information table also comprises the processing type, described processing type comprises be untreated type and the type of finishing dealing with; Described system also comprises: it is that untreated data recording is handled one by one to handling type that described traversal processing module also is used for described the 3rd information table of traversal, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.B17, as the described system of B12, described multi-platform first platform and the 3rd platform that also comprises mutual communication; Described system also comprises: described acquisition module also is used for obtaining the data recording information of the 3rd platform in corresponding Preset Time section, and the 3rd characteristic parameter information of extracting from described data recording information writes the 5th information table; Wherein, described the 3rd characteristic parameter information comprises: the 3rd platform data service identification, and the first platform data service identification of described the 3rd platform data service identification association, the interaction data character numerical value, and, the 3rd data treatment state sign; Described extraction module also is used for extracting one by one described the 5th information table the 3rd characteristic parameter information, according to first corresponding in the described first information table of described the 3rd characteristic parameter information extraction characteristic parameter information; Judge module is used for also judging whether the corresponding interaction data character numerical value of the described first characteristic parameter information and the 3rd characteristic parameter information is consistent; Described update module also is used for if the described first characteristic parameter information is consistent with the interaction data character numerical value of the 3rd characteristic parameter information correspondence, then the described first data treatment state identification renewal is the clearance completion status, described the 3rd data treatment state identification renewal is the comparison completion status; Described update module also is used for if the interaction data character numerical value of the described first characteristic parameter information and the 3rd characteristic parameter information correspondence is inconsistent, then described the 3rd data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information of extraction writes the 3rd information table.B18, as the described system of B17, described extraction module comprises: described sign is extracted the first platform data service identification that submodule also is used for extracting the 3rd platform data service identification association described in described the 3rd characteristic parameter information; Described parameter extraction submodule also is used for extracting the first corresponding characteristic parameter information according to the described first platform data service identification at described first information table.B19, as B12 or the described system of B17, wherein, described update module also is used for extracting the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information and writing the 4th information table when the corresponding interaction data character numerical value of described first information table and the 5th information table is consistent.B20, as B15 or the described system of B17, also comprise: described type update module also is used for when failing according to the first corresponding characteristic parameter information of the described first information table of described the 3rd characteristic parameter information extraction, and the type of error that upgrades in described the 3rd information table is the type of error of data search failure; And described type update module also is used for when the interaction data character numerical value of described the 5th information table and second information table correspondence is inconsistent, and the type of error that upgrades in described the 3rd information table is the inconsistent type of errors of data.B21, as B12 or B16 or the described system of B18, also comprise: it is that untreated data recording is handled one by one to handling type that described traversal processing module also is used for described the 3rd information table of traversal, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.

Claims (10)

  1. One kind multi-platform between the method for data consistency verification, described multi-platform first platform and second platform that comprises mutual communication, described method comprises:
    Collect the platform data interactive information of first platform in the Preset Time section, from described platform data interactive information, extract the first characteristic parameter information and write first information table; Described characteristic parameter information comprises: the first platform data service identification, and the interaction data character numerical value, and, first data treatment state sign;
    Obtain the data recording information of second platform in corresponding Preset Time section, the second characteristic parameter information of extracting from described data recording information writes second information table; Wherein, the described second characteristic parameter information comprises: the second platform data service identification, and the first platform data service identification of the described second platform data service identification association, the interaction data character numerical value, and, second data treatment state sign;
    Extract the second characteristic parameter information in described second information table one by one, according to first corresponding in the described first information table of the described second characteristic parameter information extraction characteristic parameter information;
    Judge whether interaction data character numerical value corresponding in the described first characteristic parameter information and the second characteristic parameter information is consistent;
    If consistent, then the described first data treatment state identification renewal is the clearance completion status, the described second data treatment state identification renewal is the comparison completion status;
    If inconsistent, then the described second data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the second characteristic parameter information of extraction writes the 3rd information table.
  2. 2. the method for claim 1, the step of the first corresponding characteristic parameter information comprises in the described first information table of the described foundation second characteristic parameter information extraction:
    Extract the first platform data service identification of the second platform data service identification association described in the described second characteristic parameter information;
    In described first information table, extract the first corresponding characteristic parameter information according to the described first platform data service identification.
  3. 3. the method for claim 1 also comprises:
    When described first information table is consistent with the interaction data character numerical value of correspondence in second information table, extracts the corresponding first characteristic parameter information and/or the second characteristic parameter information and write the 4th information table.
  4. 4. the method for claim 1 also comprises type of error in described the 3rd information table; Described method also comprises:
    When the first corresponding characteristic parameter information was failed in according to the described first information table of the described second characteristic parameter information extraction, the type of error that upgrades in described the 3rd information table was the type of error of data search failure;
    When the interaction data character numerical value of correspondence was inconsistent in described first information table and second information table, the type of error that upgrades in described the 3rd information table was the inconsistent type of errors of data.
  5. 5. the method for claim 1, described the 3rd information table also comprises the processing type, described processing type comprises be untreated type and the type of finishing dealing with; Described method also comprises:
    Traveling through described the 3rd information table is that untreated data recording is handled one by one to handling type, upgrades data processing type in the back of finishing dealing with and is the type of finishing dealing with.
  6. 6. the method for claim 1, described multi-platform mutual communication first platform and the 3rd platform of also comprising; Described method also comprises:
    Obtain the data recording information of the 3rd platform in corresponding Preset Time section, the 3rd characteristic parameter information of extracting from described data recording information writes the 5th information table; Wherein, described the 3rd characteristic parameter information comprises: the 3rd platform data service identification, and the first platform data service identification of described the 3rd platform data service identification association, the interaction data character numerical value, and, the 3rd data treatment state sign;
    Extract the 3rd characteristic parameter information in described the 5th information table one by one, according to first corresponding in the described first information table of described the 3rd characteristic parameter information extraction characteristic parameter information;
    Judge whether interaction data character numerical value corresponding in the described first characteristic parameter information and the 3rd characteristic parameter information is consistent;
    If consistent, then the described first data treatment state identification renewal is the clearance completion status, described the 3rd data treatment state identification renewal is the comparison completion status;
    If inconsistent, then described the 3rd data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information of extraction writes the 3rd information table.
  7. 7. method as claimed in claim 6, the step of the first corresponding characteristic parameter information comprises in the described first information table of described foundation the 3rd characteristic parameter information extraction:
    Extract the first platform data service identification of the 3rd platform data service identification association described in described the 3rd characteristic parameter information;
    In described first information table, extract the first corresponding characteristic parameter information according to the described first platform data service identification.
  8. 8. as claim 1 or 6 described methods, also comprise:
    When described first information table is consistent with the interaction data character numerical value of correspondence in the 3rd information table, extracts the corresponding first characteristic parameter information and/or the 3rd characteristic parameter information and write the 4th information table.
  9. 9. as claim 4 or 6 described methods, also comprise:
    When the first corresponding characteristic parameter information was failed in according to the described first information table of described the 3rd characteristic parameter information extraction, the type of error that upgrades in described the 3rd information table was the type of error of data search failure;
    When the interaction data character numerical value of correspondence was inconsistent in described the 5th information table and second information table, the type of error that upgrades in described the 3rd information table was the inconsistent type of errors of data.
  10. One kind multi-platform between the system of data consistency verification, described multi-platform first platform and second platform that comprises mutual communication, described system comprises:
    Collection module is used for collecting the platform data interactive information of first platform in the Preset Time section, extracts the first characteristic parameter information and write first information table from described platform data interactive information; Described characteristic parameter information comprises: the first platform data service identification, and the interaction data character numerical value, and, first data treatment state sign;
    Acquisition module is used for obtaining the data recording information of second platform in corresponding Preset Time section, and the second characteristic parameter information of extracting from described data recording information writes second information table; Wherein, the described second characteristic parameter information comprises: the second platform data service identification, and the first platform data service identification of the described second platform data service identification association, the interaction data character numerical value, and, second data treatment state sign;
    Extraction module is used for extracting one by one described second information table, the second characteristic parameter information, according to first corresponding in the described first information table of the described second characteristic parameter information extraction characteristic parameter information;
    Judge module is used for judging whether the corresponding interaction data character numerical value of the described first characteristic parameter information and the second characteristic parameter information is consistent;
    Update module, be used for if the described first characteristic parameter information is consistent with the interaction data character numerical value of second characteristic parameter information correspondence, then the described first data treatment state identification renewal is the clearance completion status, the described second data treatment state identification renewal is the comparison completion status;
    And, if interaction data character numerical value corresponding in the described first characteristic parameter information and the second characteristic parameter information is inconsistent, then the described second data treatment state identification renewal is clearance comparison state, and the corresponding first characteristic parameter information and/or the second characteristic parameter information of extraction writes the 3rd information table.
CN201310253192.2A 2013-06-24 2013-06-24 A kind of multi-platform between the method and system of consistency verification of data Expired - Fee Related CN103345487B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201310253192.2A CN103345487B (en) 2013-06-24 2013-06-24 A kind of multi-platform between the method and system of consistency verification of data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201310253192.2A CN103345487B (en) 2013-06-24 2013-06-24 A kind of multi-platform between the method and system of consistency verification of data

Publications (2)

Publication Number Publication Date
CN103345487A true CN103345487A (en) 2013-10-09
CN103345487B CN103345487B (en) 2016-12-28

Family

ID=49280282

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201310253192.2A Expired - Fee Related CN103345487B (en) 2013-06-24 2013-06-24 A kind of multi-platform between the method and system of consistency verification of data

Country Status (1)

Country Link
CN (1) CN103345487B (en)

Cited By (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103532959A (en) * 2013-10-21 2014-01-22 济南政和科技有限公司 Cross-platform network communication method
CN103605703A (en) * 2013-11-08 2014-02-26 北京奇虎科技有限公司 Method and system for data consistency detection among multiple platforms
CN103744948A (en) * 2013-12-31 2014-04-23 金蝶软件(中国)有限公司 Method and system for searching data to check difference reasons
CN105335443A (en) * 2014-08-13 2016-02-17 阿里巴巴集团控股有限公司 Method and device for abnormity detection in data synchronization
CN105653579A (en) * 2015-12-18 2016-06-08 北京百度网讯科技有限公司 Method and device for testing distributed transactions
CN105978723A (en) * 2016-05-11 2016-09-28 广州唯品会信息科技有限公司 Network information management method and device
CN106604072A (en) * 2015-10-14 2017-04-26 北京国双科技有限公司 IPTV data difference analysis method and device
CN107292624A (en) * 2016-03-30 2017-10-24 阿里巴巴集团控股有限公司 The method and device of commodity object information is provided
CN107391620A (en) * 2017-07-06 2017-11-24 天脉聚源(北京)传媒科技有限公司 A kind of method and device for handling collaboration update abnormal
CN107784544A (en) * 2016-08-30 2018-03-09 阿里巴巴集团控股有限公司 The method and apparatus that a kind of information compares
CN107885504A (en) * 2017-12-12 2018-04-06 北京四方继保自动化股份有限公司 A kind of method of the multiple platform system control logic consistency desired result of isomery
CN108829495A (en) * 2018-05-08 2018-11-16 中国平安人寿保险股份有限公司 Verification method, device, equipment and the storage medium of multiple database modification affairs
CN110111093A (en) * 2019-05-15 2019-08-09 深圳云免电子商务有限公司 A kind of online trading method, system and computer readable storage medium
CN110912766A (en) * 2019-10-18 2020-03-24 国家计算机网络与信息安全管理中心 Communication network multi-plane data consistency checking method
CN110990414A (en) * 2019-10-31 2020-04-10 口碑(上海)信息技术有限公司 Data processing method and device
CN111400187A (en) * 2020-03-19 2020-07-10 重庆富民银行股份有限公司 Parameter dynamic verification system and method based on customized data source
CN111832865A (en) * 2019-04-23 2020-10-27 广州数鹏通科技有限公司 Method and device for detecting platform information propagation quality and computer equipment
CN114679300A (en) * 2022-02-28 2022-06-28 福思(杭州)智能科技有限公司 Data verification method and device, electronic equipment and storage medium

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040091244A1 (en) * 1998-10-02 2004-05-13 Lg Electronics Inc. Method and apparatus for recording time information for digital data streams
CN102970205A (en) * 2012-12-07 2013-03-13 四川长虹电器股份有限公司 Cross-platform data interaction method based on virtual private network (VPN)

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040091244A1 (en) * 1998-10-02 2004-05-13 Lg Electronics Inc. Method and apparatus for recording time information for digital data streams
CN102970205A (en) * 2012-12-07 2013-03-13 四川长虹电器股份有限公司 Cross-platform data interaction method based on virtual private network (VPN)

Cited By (29)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103532959A (en) * 2013-10-21 2014-01-22 济南政和科技有限公司 Cross-platform network communication method
CN103605703B (en) * 2013-11-08 2017-07-04 北京奇虎科技有限公司 It is a kind of it is multi-platform between data consistency detection method and system
CN103605703A (en) * 2013-11-08 2014-02-26 北京奇虎科技有限公司 Method and system for data consistency detection among multiple platforms
CN103744948A (en) * 2013-12-31 2014-04-23 金蝶软件(中国)有限公司 Method and system for searching data to check difference reasons
CN103744948B (en) * 2013-12-31 2018-01-12 金蝶软件(中国)有限公司 Searching data checks the method and system of reason of discrepancies
CN105335443A (en) * 2014-08-13 2016-02-17 阿里巴巴集团控股有限公司 Method and device for abnormity detection in data synchronization
CN106604072B (en) * 2015-10-14 2019-05-03 北京国双科技有限公司 The difference analysis method and device of Web TV data
CN106604072A (en) * 2015-10-14 2017-04-26 北京国双科技有限公司 IPTV data difference analysis method and device
CN105653579A (en) * 2015-12-18 2016-06-08 北京百度网讯科技有限公司 Method and device for testing distributed transactions
CN105653579B (en) * 2015-12-18 2019-06-28 北京百度网讯科技有限公司 The method and apparatus that a kind of pair of distributed transaction is tested
CN107292624A (en) * 2016-03-30 2017-10-24 阿里巴巴集团控股有限公司 The method and device of commodity object information is provided
CN105978723A (en) * 2016-05-11 2016-09-28 广州唯品会信息科技有限公司 Network information management method and device
CN107784544A (en) * 2016-08-30 2018-03-09 阿里巴巴集团控股有限公司 The method and apparatus that a kind of information compares
CN107784544B (en) * 2016-08-30 2021-08-17 阿里巴巴集团控股有限公司 Information comparison method and equipment
CN107391620A (en) * 2017-07-06 2017-11-24 天脉聚源(北京)传媒科技有限公司 A kind of method and device for handling collaboration update abnormal
CN107885504A (en) * 2017-12-12 2018-04-06 北京四方继保自动化股份有限公司 A kind of method of the multiple platform system control logic consistency desired result of isomery
CN107885504B (en) * 2017-12-12 2021-01-12 北京四方继保自动化股份有限公司 Heterogeneous multi-platform system control logic consistency checking method
CN108829495A (en) * 2018-05-08 2018-11-16 中国平安人寿保险股份有限公司 Verification method, device, equipment and the storage medium of multiple database modification affairs
CN108829495B (en) * 2018-05-08 2023-11-14 中国平安人寿保险股份有限公司 Verification method, device, equipment and storage medium for multi-database modification transaction
CN111832865A (en) * 2019-04-23 2020-10-27 广州数鹏通科技有限公司 Method and device for detecting platform information propagation quality and computer equipment
CN110111093A (en) * 2019-05-15 2019-08-09 深圳云免电子商务有限公司 A kind of online trading method, system and computer readable storage medium
CN110912766A (en) * 2019-10-18 2020-03-24 国家计算机网络与信息安全管理中心 Communication network multi-plane data consistency checking method
CN110912766B (en) * 2019-10-18 2021-04-20 国家计算机网络与信息安全管理中心 Communication network multi-plane data consistency checking method
CN110990414B (en) * 2019-10-31 2023-06-16 口碑(上海)信息技术有限公司 Data processing method and device
CN110990414A (en) * 2019-10-31 2020-04-10 口碑(上海)信息技术有限公司 Data processing method and device
CN111400187A (en) * 2020-03-19 2020-07-10 重庆富民银行股份有限公司 Parameter dynamic verification system and method based on customized data source
CN111400187B (en) * 2020-03-19 2023-03-14 重庆富民银行股份有限公司 Parameter dynamic verification system and method based on customized data source
CN114679300A (en) * 2022-02-28 2022-06-28 福思(杭州)智能科技有限公司 Data verification method and device, electronic equipment and storage medium
CN114679300B (en) * 2022-02-28 2023-10-13 福思(杭州)智能科技有限公司 Data verification method and device, electronic equipment and storage medium

Also Published As

Publication number Publication date
CN103345487B (en) 2016-12-28

Similar Documents

Publication Publication Date Title
CN103345487A (en) Method and system of verifying data consistency between multiple platforms
CN103391311A (en) Method and system for consistency verification of data among multiple platforms
CN103577571A (en) Data processing method and device
US11748752B2 (en) Modular, configurable smart contracts for blockchain transaction processing validations
CN103605703A (en) Method and system for data consistency detection among multiple platforms
US9563920B2 (en) Method, system and program product for matching of transaction records
CN108520008A (en) The construction method and construction device of data warehouse model
CN106570741A (en) Application of automatic matching method in network spot transaction platform
CN109416801A (en) System and method for mapping invalidated data using verified data
CN112069196B (en) Database-based data processing method, device, equipment and readable storage medium
CN109254911A (en) Transaction software market monitoring method and storage medium
Alghushairy et al. Data storage
US20230351524A1 (en) Duplicate invoice detection and management
JPWO2018179284A1 (en) Company group management method and system
CN110083596A (en) A kind of method of data history tracking and the tracking of data change histories
CN109597706A (en) It is a kind of to check the detection method of variance data, apparatus and system
CN110544165B (en) Credit risk score card creating method and device and electronic equipment
CN107533559A (en) Data structure, the model for filling data structure and the method being programmed using data structure to processing unit
CN104715433A (en) Parameter setting method for PLC (programmable logic controller) communication system in new program slicing technology for E-business website industry
CN109766360A (en) A kind of list screening method and device
Mwangi Development of integrated land information management system in Kenya
EP4024227A1 (en) Machine identification of original transaction in large transaction datasets
CN112767138B (en) International balance reporting data missing report detection method and system
CN116484054A (en) Data processing method and related device
Kasztelnik et al. Smart Blockchain Contracts and Firm Value: An Interrupted Time Series Model.

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20161228

CF01 Termination of patent right due to non-payment of annual fee