[go: up one dir, main page]

CN103345487B - A kind of multi-platform between the method and system of consistency verification of data - Google Patents

A kind of multi-platform between the method and system of consistency verification of data Download PDF

Info

Publication number
CN103345487B
CN103345487B CN201310253192.2A CN201310253192A CN103345487B CN 103345487 B CN103345487 B CN 103345487B CN 201310253192 A CN201310253192 A CN 201310253192A CN 103345487 B CN103345487 B CN 103345487B
Authority
CN
China
Prior art keywords
platform
information
parameter information
data
feature parameter
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.)
Expired - Fee Related
Application number
CN201310253192.2A
Other languages
Chinese (zh)
Other versions
CN103345487A (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

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

本发明公开了一种多平台之间数据一致性校验的方法,所述多平台包括互相通信的第一平台和第二平台,所述的方法包括:收集第一平台在预设时间段内的平台数据交互信息,从所述平台数据交互信息中提取第一特征参数信息并写入第一信息表;获取第二平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第二特征参数信息写入第二信息表;判断所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值是否一致。本发明可以对分布在平台之间的数据进行自动获取和比对,能够准确并且及时查找到平台间不一致的交互数据特征数值,减少了人为参与,减少了平台资源的耗费。

The invention discloses a method for checking data consistency between multiple platforms. The multiple platforms include a first platform and a second platform that communicate with each other. The method includes: collecting the first platform within a preset time period platform data interaction information, extract the first feature parameter information from the platform data interaction information and write it into the first information table; obtain the data record information of the second platform in the corresponding preset time period, and obtain the data record information from the data record information Extracting the second characteristic parameter information from the second information table and writing it into the second information table; judging whether the corresponding interaction data characteristic values in the first characteristic parameter information and the second characteristic parameter information are consistent. The invention can automatically acquire and compare the data distributed among the platforms, can accurately and timely find out the characteristic value of the interactive data inconsistent between the platforms, reduces human participation, and reduces the consumption of platform resources.

Description

一种多平台之间数据一致性校验的方法和系统A method and system for checking data consistency between multiple platforms

技术领域technical field

本发明涉及数据处理技术领域,具体涉及一种多平台之间数据一致性校验的方法和系统。The invention relates to the technical field of data processing, in particular to a method and system for checking data consistency between multiple platforms.

背景技术Background technique

现今,随着网络的日益普及,电子商务已经融入了人们的日常生活当中。通常意义上的电子商务通常是指在全球各地广泛的商业贸易活动中,在因特网开放的网络环境下,基于浏览器/服务器应用方式,买卖双方不谋面地进行各种商贸活动,实现消费者的网上购物、商户之间的网上交易和在线电子支付以及各种商务活动、交易活动、金融活动和相关的综合服务活动的一种新型的商业运营模式。Nowadays, with the increasing popularity of the Internet, e-commerce has been integrated into people's daily life. E-commerce in the usual sense usually refers to the wide range of commercial and trade activities around the world, under the open network environment of the Internet, based on the browser/server application mode, buyers and sellers carry out various commercial and trade activities without meeting each other, and realize consumer satisfaction. It is a new type of business operation mode of online shopping, online transactions between merchants and online electronic payment, as well as various business activities, transaction activities, financial activities and related comprehensive service activities.

近些年来电子商务蓬勃发展,这使得物理上相互独立,业务上又相互关联的各个平台间的数据一致性比对校验的任务越来越艰巨,而各平台间数据一致性比对检测又是业务平台健壮性主要指标之一,并且不可或缺。如果该功能缺失,会严重导致平台间业务数据的不确定性,进而导致业务异常、计费含混等问题。The vigorous development of e-commerce in recent years has made the task of comparing and verifying data consistency between platforms that are physically independent and interrelated in business more and more difficult, and the comparison and detection of data consistency between platforms has become more and more difficult. It is one of the main indicators of the robustness of the business platform and is indispensable. If this function is missing, it will seriously lead to the uncertainty of business data between platforms, which in turn will lead to problems such as business anomalies and billing ambiguity.

发明内容Contents of the invention

鉴于上述问题,提出了本发明以便提供一种克服上述问题或者至少部分地解决上述问题的种多平台之间数据一致性校验的方法和相应的种多平台之间数据一致性校验的系统。In view of the above problems, the present invention is proposed to provide a method for checking data consistency between multiple platforms and a corresponding system for checking data consistency between multiple platforms to overcome the above problems or at least partially solve the above problems .

依据本发明的一个方面,提供了一种多平台之间数据一致性校验的方法,所述多平台包括互相通信的第一平台和第二平台,所述的方法包括:According to one aspect of the present invention, a method for checking data consistency between multiple platforms is provided, the multiple platforms include a first platform and a second platform that communicate with each other, and the method includes:

收集第一平台在预设时间段内的平台数据交互信息,从所述平台数据交互信息中提取第一特征参数信息并写入第一信息表;所述特征参数信息包括:第一平台数据业务标识,交互数据特征数值,以及,第一数据处理状态标识;Collect platform data interaction information of the first platform within a preset time period, extract first characteristic parameter information from the platform data interaction information and write it into the first information table; the characteristic parameter information includes: first platform data service identification, the characteristic value of the interactive data, and the identification of the first data processing state;

获取第二平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第二特征参数信息写入第二信息表;其中,所述第二特征参数信息包括:第二平台数据业务标识,所述第二平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第二数据处理状态标识;Acquiring the data record information of the second platform within the corresponding preset time period, extracting the second characteristic parameter information from the data record information and writing it into the second information table; wherein, the second characteristic parameter information includes: the second platform A data service identifier, a first platform data service identifier associated with the second platform data service identifier, an interaction data feature value, and a second data processing status identifier;

逐条提取所述第二信息表中第二特征参数信息,依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息;Extracting the second characteristic parameter information in the second information table one by one, and extracting the corresponding first characteristic parameter information in the first information table according to the second characteristic parameter information;

判断所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值是否一致;Judging whether the corresponding interaction data feature values in the first feature parameter information and the second feature parameter information are consistent;

若一致,则将所述第一数据处理状态标识更新为清算完成状态,将所述第二数据处理状态标识更新为比对完成状态;If they are consistent, update the first data processing status identifier to a liquidation completion status, and update the second data processing status identifier to a comparison completion status;

若不一致,则将所述第二数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和/或第二特征参数信息写入第三信息表。If not, update the second data processing status identifier to the clearing comparison status, and extract the corresponding first characteristic parameter information and/or second characteristic parameter information and write it into the third information table.

可选地,所述依据第二特征参数信息提取所述第一信息表中对应的第一特征参数信息的步骤包括:Optionally, the step of extracting the corresponding first characteristic parameter information in the first information table according to the second characteristic parameter information includes:

提取所述第二特征参数信息中所述第二平台数据业务标识关联的第一平台数据业务标识;Extracting the first platform data service identifier associated with the second platform data service identifier in the second feature parameter information;

依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。Extract corresponding first feature parameter information from the first information table according to the first platform data service identifier.

可选地,所述方法还包括:Optionally, the method also includes:

在所述第一信息表和第二信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第二特征参数信息写入第四信息表。When the corresponding interaction data feature values in the first information table and the second information table are consistent, the corresponding first feature parameter information and/or second feature parameter information are extracted and written into the fourth information table.

可选地,所述第三信息表中还包括错误类型;所述方法还包括:Optionally, the third information table also includes an error type; the method also includes:

在依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;When extracting the corresponding first characteristic parameter information in the first information table according to the second characteristic parameter information fails, update the error type in the third information table to the error type of data search failure;

在所述第一信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。When the corresponding interaction data feature values in the first information table and the second information table are inconsistent, update the error type in the third information table to an error type of data inconsistency.

可选地,所述第三信息表还包括处理类型,所述处理类型包括未处理类型和处理完成类型;所述方法还包括:Optionally, the third information table further includes a processing type, and the processing type includes an unprocessed type and a processing completion type; the method further includes:

遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。Traverse the third information table to process the data records whose processing type is unprocessed one by one, and update the data processing type to the processing completed type after the processing is completed.

可选地,所述多平台还包括互相通信第一平台和第三平台;所述的方法还包括:Optionally, the multi-platform also includes communicating with the first platform and the third platform; the method also includes:

获取第三平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第三特征参数信息写入第五信息表;其中,所述第三特征参数信息包括:第三平台数据业务标识,所述第三平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第三数据处理状态标识;Obtain the data record information of the third platform within the corresponding preset time period, extract the third characteristic parameter information from the data record information and write it into the fifth information table; wherein, the third characteristic parameter information includes: the third platform The data service identifier, the first platform data service identifier associated with the third platform data service identifier, the interactive data feature value, and the third data processing status identifier;

逐条提取所述第五信息表中第三特征参数信息,依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息;Extracting the third characteristic parameter information in the fifth information table one by one, and extracting the corresponding first characteristic parameter information in the first information table according to the third characteristic parameter information;

判断所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值是否一致;Judging whether the corresponding interaction data feature values in the first feature parameter information and the third feature parameter information are consistent;

若一致,则将所述第一数据处理状态标识更新为清算完成状态,将所述第三数据处理状态标识更新为比对完成状态;If consistent, update the first data processing status identifier to a clearing completion status, and update the third data processing status identifier to a comparison completion status;

若不一致,则将所述第三数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和/或第三特征参数信息写入第三信息表。If not, update the third data processing status identifier to the clearing comparison status, and extract the corresponding first characteristic parameter information and/or third characteristic parameter information and write it into the third information table.

可选地,所述依据第三特征参数信息提取所述第一信息表中对应的第一特征参数信息的步骤包括:Optionally, the step of extracting the corresponding first characteristic parameter information in the first information table according to the third characteristic parameter information includes:

提取所述第三特征参数信息中所述第三平台数据业务标识关联的第一平台数据业务标识;Extracting the first platform data service identifier associated with the third platform data service identifier in the third characteristic parameter information;

依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。Extract corresponding first feature parameter information from the first information table according to the first platform data service identifier.

可选地,所述方法还包括:Optionally, the method also includes:

在所述第一信息表和第三信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第三特征参数信息写入第四信息表。When the corresponding interaction data feature values in the first information table and the third information table are consistent, the corresponding first feature parameter information and/or third feature parameter information are extracted and written into the fourth information table.

可选地,所述方法还包括:Optionally, the method also includes:

在依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;When extracting the corresponding first characteristic parameter information in the first information table according to the third characteristic parameter information fails, update the error type in the third information table to the error type of data search failure;

在所述第五信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。When the corresponding interaction data feature values in the fifth information table and the second information table are inconsistent, update the error type in the third information table to an error type of data inconsistency.

可选地,所述方法还包括:Optionally, the method also includes:

遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。Traverse the third information table to process the data records whose processing type is unprocessed one by one, and update the data processing type to the processing completed type after the processing is completed.

可选地,所述第一平台为第三方支付平台,所述第二平台为银行系统平台,所述第三平台为电子商务网站平台;所述第一平台数据业务标识为第三方支付平台的交易单号;所述第二平台数据业务标识为银行系统平台的交易单号;所述第三平台数据业务标识为电子商务网站平台的交易单号;所述交互数据特征数值为交易金额。Optionally, the first platform is a third-party payment platform, the second platform is a banking system platform, and the third platform is an e-commerce website platform; the data business identifier of the first platform is that of a third-party payment platform The transaction order number; the second platform data service identification is the transaction order number of the banking system platform; the third platform data service identification is the transaction order number of the e-commerce website platform; the interactive data feature value is the transaction amount.

根据本发明的另一方面,提供了一种多平台之间数据一致性校验的系统,所述多平台包括互相通信的第一平台和第二平台,所述的系统包括:According to another aspect of the present invention, a system for checking data consistency between multiple platforms is provided, the multiple platforms include a first platform and a second platform that communicate with each other, and the system includes:

收集模块,用于收集第一平台在预设时间段内的平台数据交互信息,从所述平台数据交互信息中提取第一特征参数信息并写入第一信息表;所述特征参数信息包括:第一平台数据业务标识,交互数据特征数值,以及,第一数据处理状态标识;The collecting module is used to collect the platform data interaction information of the first platform within a preset time period, extract the first characteristic parameter information from the platform data interaction information and write it into the first information table; the characteristic parameter information includes: The first platform data service identifier, the characteristic value of the interactive data, and the first data processing status identifier;

获取模块,用于获取第二平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第二特征参数信息写入第二信息表;其中,所述第二特征参数信息包括:第二平台数据业务标识,所述第二平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第二数据处理状态标识;An acquisition module, configured to acquire data record information of the second platform within a corresponding preset time period, extract second characteristic parameter information from the data record information, and write it into a second information table; wherein, the second characteristic parameter information Including: the second platform data service identifier, the first platform data service identifier associated with the second platform data service identifier, the interactive data feature value, and the second data processing status identifier;

提取模块,用于逐条提取所述第二信息表中第二特征参数信息,依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息;An extraction module, configured to extract the second characteristic parameter information in the second information table one by one, and extract the corresponding first characteristic parameter information in the first information table according to the second characteristic parameter information;

判断模块,用于判断所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值是否一致;A judging module, configured to judge whether the corresponding interaction data characteristic values in the first characteristic parameter information and the second characteristic parameter information are consistent;

更新模块,用于若所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值一致,则将所述第一数据处理状态标识更新为清算完成状态,将所述第二数据处理状态标识更新为比对完成状态;An update module, configured to update the first data processing status flag to a liquidation completion status if the first feature parameter information is consistent with the corresponding interaction data feature values in the second feature parameter information, and update the second data processing status The processing status flag is updated to the comparison completion status;

以及,若所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值不一致,则将所述第二数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和/或第二特征参数信息写入第三信息表。And, if the corresponding interaction data characteristic values in the first characteristic parameter information and the second characteristic parameter information are inconsistent, update the second data processing state flag to the clearing comparison state, and extract the corresponding first characteristic parameter The information and/or the second feature parameter information are written into the third information table.

可选地,所述提取模块包括:Optionally, the extraction module includes:

标识提取子模块,用于提取所述第二特征参数信息中所述第二平台数据业务标识关联的第一平台数据业务标识;An identifier extraction submodule, configured to extract the first platform data service identifier associated with the second platform data service identifier in the second characteristic parameter information;

参数查找子模块,用于依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。The parameter search submodule is configured to extract corresponding first feature parameter information from the first information table according to the first platform data service identifier.

可选地,其中,Optionally, where,

所述更新模块还用于在所述第一信息表和第二信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第二特征参数信息写入第四信息表。The update module is also used to extract the corresponding first feature parameter information and/or second feature parameter information and write it into the fourth information when the corresponding interaction data feature values in the first information table and the second information table are consistent. surface.

可选地,所述第三信息表中还包括错误类型;所述系统还包括:Optionally, the third information table also includes error types; the system also includes:

类型更新模块,用于在依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;A type update module, configured to update the error type in the third information table to an error of data search failure when the corresponding first characteristic parameter information in the first information table fails to be extracted according to the second characteristic parameter information Types of;

以及,所述类型更新模块还用于在所述第一信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。And, the type updating module is further configured to update the error type in the third information table to an error type of data inconsistency when the corresponding interaction data feature values in the first information table and the second information table are inconsistent.

可选地,所述第三信息表还包括处理类型,所述处理类型包括未处理类型和处理完成类型;所述系统还包括:Optionally, the third information table also includes a processing type, and the processing type includes an unprocessed type and a processing completion type; the system further includes:

所述遍历处理模块还用于遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。The traversal processing module is also used to traverse the third information table to process the data records whose processing type is unprocessed one by one, and update the data processing type to the processing completed type after the processing is completed.

可选地,所述多平台还包括互相通信的第一平台和第三平台;所述的系统还包括:Optionally, the multi-platform also includes a first platform and a third platform that communicate with each other; the system also includes:

所述获取模块还用于获取第三平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第三特征参数信息写入第五信息表;其中,所述第三特征参数信息包括:第三平台数据业务标识,所述第三平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第三数据处理状态标识;The obtaining module is also used to obtain data recording information of the third platform within a corresponding preset time period, and extract third characteristic parameter information from the data recording information and write it into the fifth information table; wherein, the third characteristic The parameter information includes: the third platform data service identifier, the first platform data service identifier associated with the third platform data service identifier, the interactive data feature value, and the third data processing status identifier;

所述提取模块还用于逐条提取所述第五信息表中第三特征参数信息,依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息;The extraction module is also used to extract the third characteristic parameter information in the fifth information table one by one, and extract the corresponding first characteristic parameter information in the first information table according to the third characteristic parameter information;

判断模块还用于判断所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值是否一致;The judging module is also used to judge whether the corresponding interaction data characteristic values in the first characteristic parameter information and the third characteristic parameter information are consistent;

所述更新模块还用于若所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值一致,则将所述第一数据处理状态标识更新为清算完成状态,将所述第三数据处理状态标识更新为比对完成状态;The update module is further configured to update the first data processing status flag to a liquidation completion status if the corresponding interaction data feature values in the first feature parameter information and the third feature parameter information are consistent, and update the second 3. The data processing status indicator is updated to the comparison completion status;

所述更新模块还用于若所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值不一致,则将所述第三数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和/或第三特征参数信息写入第三信息表。The update module is further configured to update the third data processing state identifier to the clearing comparison state if the corresponding interaction data characteristic values in the first characteristic parameter information and the third characteristic parameter information are inconsistent, and extract the corresponding The first feature parameter information and/or the third feature parameter information are written into the third information table.

可选地,所述提取模块包括:Optionally, the extraction module includes:

所述标识提取子模块还用于提取所述第三特征参数信息中所述第三平台数据业务标识关联的第一平台数据业务标识;The identifier extraction submodule is also used to extract the first platform data service identifier associated with the third platform data service identifier in the third characteristic parameter information;

所述参数提取子模块还用于依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。The parameter extraction sub-module is further configured to extract corresponding first characteristic parameter information in the first information table according to the first platform data service identifier.

可选地,其中,Optionally, where,

所述更新模块还用于在所述第一信息表和第五信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第三特征参数信息写入第四信息表。The update module is also used to extract the corresponding first feature parameter information and/or third feature parameter information and write it into the fourth information when the corresponding interaction data feature values in the first information table and the fifth information table are consistent. surface.

可选地,所述系统还包括:Optionally, the system also includes:

所述类型更新模块还用于在依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;The type update module is further configured to update the error type in the third information table to data lookup failure when the corresponding first characteristic parameter information in the first information table fails to be extracted according to the third characteristic parameter information the type of error;

以及,所述类型更新模块还用于在所述第五信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。And, the type updating module is further configured to update the error type in the third information table to an error type of data inconsistency when the corresponding interactive data feature values in the fifth information table and the second information table are inconsistent.

可选地,所述系统还包括:Optionally, the system also includes:

所述遍历处理模块还用于遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。The traversal processing module is also used to traverse the third information table to process the data records whose processing type is unprocessed one by one, and update the data processing type to the processing completed type after the processing is completed.

根据本发明的一种多平台之间数据一致性校验的方法和系统,可以对分布在平台之间的数据进行自动获取和比对,能够准确并且及时查找到平台间不一致的交互数据特征数值,减少了人为参与,减少了平台资源的耗费。本发明可以采用数据库来进行平台之间数据的比对,因此可直接利用数据库本身具有的事务功能,可以保证一旦发生宕机或者由于其他原因造成的执行中断,可以从头重新执行,并且不会产生中间数据实现简单,减少了开发的难度。另外,本发明还可以提供自动告警机制,若平台的数据没有获取成功,可以发出邮件或者短信报警,使得运维人员去联系各平台的相关负责人,去查询数据获取失败的具体原因,由此解决了多平台之间数据的不确定性,进而导致的业务异常、计费含混等问题,取得了提高多平台之间数据校验的效率,保护了多平台之间数据的一致性,保证了多平台之间业务的健壮性的有益效果。According to a method and system for checking data consistency between multiple platforms of the present invention, data distributed between platforms can be automatically acquired and compared, and inconsistent interactive data feature values between platforms can be found accurately and in a timely manner , reducing human participation and reducing the consumption of platform resources. The present invention can use the database to compare data between platforms, so it can directly use the transaction function of the database itself, which can ensure that once a downtime occurs or execution is interrupted due to other reasons, it can be re-executed from the beginning without generating The implementation of intermediate data is simple, which reduces the difficulty of development. In addition, the present invention can also provide an automatic alarm mechanism. If the data of the platform is not successfully acquired, an email or SMS alarm can be sent, so that the operation and maintenance personnel can contact the relevant person in charge of each platform to inquire about the specific reasons for the failure of data acquisition. It solves the uncertainty of data between multiple platforms, which leads to business abnormalities and billing ambiguity, etc., improves the efficiency of data verification between multiple platforms, protects the consistency of data between multiple platforms, and ensures The beneficial effect of the robustness of the business between multiple platforms.

上述说明仅是本发明技术方案的概述,为了能够更清楚了解本发明的技术手段,而可依照说明书的内容予以实施,并且为了让本发明的上述和其它目的、特征和优点能够更明显易懂,以下特举本发明的具体实施方式。The above description is only an overview of the technical solution of the present invention. In order to better understand the technical means of the present invention, it can be implemented according to the contents of the description, and in order to make the above and other purposes, features and advantages of the present invention more obvious and understandable , the specific embodiments of the present invention are enumerated below.

附图说明Description of drawings

通过阅读下文优选实施方式的详细描述,各种其他的优点和益处对于本领域普通技术人员将变得清楚明了。附图仅用于示出优选实施方式的目的,而并不认为是对本发明的限制。而且在整个附图中,用相同的参考符号表示相同的部件。在附图中:Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiment. The drawings are only for the purpose of illustrating a preferred embodiment and are not to be considered as limiting the invention. Also throughout the drawings, the same reference numerals are used to designate the same parts. In the attached picture:

图1示出了根据本发明一个实施例1的一种多平台之间数据一致性校验的方法实施例的步骤流程图;FIG. 1 shows a flow chart of the steps of a method embodiment of a data consistency check between multiple platforms according to Embodiment 1 of the present invention;

图2示出了根据本发明一个实施例2的一种多平台之间数据一致性校验的方法实施例的一部分的步骤流程图;FIG. 2 shows a flow chart of steps of a part of a method embodiment of a method for checking data consistency between multiple platforms according to Embodiment 2 of the present invention;

图3示出了根据本发明一个实施例1的一种多平台之间数据一致性校验的系统实施例的结构框图;FIG. 3 shows a structural block diagram of a system embodiment of a data consistency check between multiple platforms according to Embodiment 1 of the present invention;

图4示出了根据本发明一个实施例2的一种多平台之间数据一致性校验的系统实施例一部分的的结构框图。FIG. 4 shows a structural block diagram of a part of a system for checking data consistency between multiple platforms according to Embodiment 2 of the present invention.

具体实施方式detailed description

下面将参照附图更详细地描述本公开的示例性实施例。虽然附图中显示了本公开的示例性实施例,然而应当理解,可以以各种形式实现本公开而不应被这里阐述的实施例所限制。相反,提供这些实施例是为了能够更透彻地理解本公开,并且能够将本公开的范围完整的传达给本领域的技术人员。Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

参照图1,示出了本发明的一种多平台之间数据一致性校验的方法实施例的步骤流程图,所述多平台可以包括互相通信的第一平台和第二平台,所述的方法可以包括如下步骤:Referring to FIG. 1 , it shows a flow chart of steps of a method embodiment of a data consistency check between multiple platforms of the present invention, the multiple platforms may include a first platform and a second platform communicating with each other, and the The method may include the steps of:

步骤S101,收集第一平台在预设时间段内的平台数据交互信息,从所述平台数据交互信息中提取第一特征参数信息并写入第一信息表;所述特征参数信息包括:第一平台数据业务标识,交互数据特征数值,以及,第一数据处理状态标识;Step S101, collect the platform data interaction information of the first platform within a preset time period, extract the first characteristic parameter information from the platform data interaction information and write it into the first information table; the characteristic parameter information includes: the first Platform data service identifier, interactive data feature value, and first data processing status identifier;

步骤S103,获取第二平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第二特征参数信息写入第二信息表;其中,所述第二特征参数信息包括:第二平台数据业务标识,所述第二平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第二数据处理状态标识;Step S103, acquiring data record information of the second platform within a corresponding preset time period, extracting second characteristic parameter information from the data record information and writing it into a second information table; wherein, the second characteristic parameter information includes: The second platform data service identifier, the first platform data service identifier associated with the second platform data service identifier, the interactive data feature value, and the second data processing status identifier;

步骤S105,逐条提取所述第二信息表中第二特征参数信息,依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息;Step S105, extracting the second characteristic parameter information in the second information table one by one, and extracting the corresponding first characteristic parameter information in the first information table according to the second characteristic parameter information;

步骤S107,判断所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值是否一致;若一致,则执行步骤S109;若不一致,则执行步骤S111;Step S107, judging whether the corresponding interaction data feature values in the first feature parameter information and the second feature parameter information are consistent; if they are consistent, perform step S109; if they are not consistent, perform step S111;

步骤S109,将所述第一数据处理状态标识更新为清算完成状态,将所述第二数据处理状态标识更新为比对完成状态;Step S109, updating the first data processing status identifier to the liquidation completion status, and updating the second data processing status identifier to the comparison completion status;

步骤S111,将所述第二数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和/或第二特征参数信息写入第三信息表。Step S111 , updating the second data processing status flag to the clearing comparison status, and extracting the corresponding first characteristic parameter information and/or second characteristic parameter information and writing them into the third information table.

为了使本领域技术人员进一步了解本发明实施例,以下将通过电子商务中交易记录的校验来对本发明实施例进行详细说明。In order for those skilled in the art to further understand the embodiments of the present invention, the embodiments of the present invention will be described in detail below through the verification of transaction records in electronic commerce.

在电子商务中,所述第一平台可以为第三方支付平台,所述第二平台可以为银行系统平台,所述第三平台可以为电子商务网站平台;所述第一平台数据业务标识可以为第三方支付平台的交易单号;所述第二平台数据业务标识可以为银行系统平台的交易单号;所述第三平台数据业务标识可以为电子商务网站平台的交易单号;所述交互数据特征数值可以为交易金额。In e-commerce, the first platform may be a third-party payment platform, the second platform may be a banking system platform, and the third platform may be an e-commerce website platform; the data service identifier of the first platform may be The transaction order number of the third-party payment platform; the second platform data service identification can be the transaction order number of the banking system platform; the third platform data service identification can be the transaction order number of the e-commerce website platform; the interaction data The feature value can be transaction amount.

需要说明的是,所谓第三方支付平台,是一些和产品所在国家以及国外各大银行系统平台签约、并具备一定实力和信誉保障的第三方独立机构提供的交易支持平台。在通过第三方支付平台的交易中,买方选购商品后,使用第三方支付平台提供的账户进行货款支付,由第三方支付平台通知电子商务网站平台货款到达、进行发货;买方检验物品后,就可以通知付款给电子商务网站平台,第三方支付平台再将款项转至电子商务网站平台的账户。It should be noted that the so-called third-party payment platforms are transaction support platforms provided by third-party independent institutions that have signed contracts with the country where the product is located and major foreign banking system platforms, and have certain strength and reputation guarantee. In the transaction through the third-party payment platform, after the buyer purchases the goods, he uses the account provided by the third-party payment platform to pay for the goods, and the third-party payment platform notifies the e-commerce website platform that the payment has arrived and delivers the goods; after the buyer inspects the goods, You can notify the payment to the e-commerce website platform, and the third-party payment platform will transfer the money to the account of the e-commerce website platform.

在本发明实施例中,不同平台之间进行交易记录校验可以是使用从第三方支付平台和银行系统平台获取的交易记录导入数据库中来进行比对校验,由于有可能有部分交易记录,第三方支付平台发送后,银行系统平台可能会没有收到或者是没有处理完,因此使用银行系统平台已经处理完的交易记录进行比对是比较合理及准确的。In the embodiment of the present invention, the verification of transaction records between different platforms can be performed by using the transaction records obtained from the third-party payment platform and the banking system platform to import into the database for comparison and verification. Since there may be some transaction records, After the third-party payment platform sends, the banking system platform may not receive or process it, so it is more reasonable and accurate to use the transaction records that have been processed by the banking system platform for comparison.

在具体实现中,由于各平台原有的交易记录往往因为侧重点不同,记录的内容字段也有所不同,如果使用原本的用于记录交易记录的交易表,无法满足校验平台之间数据一致性的要求,所以,通常需要使用单独的表进行记录并校验。各平台的交易表的要素一般有外部触发产生该交易的电子商务网站平台的交易单号、电子商务网站平台的交易发起时间,第三方支付平台的交易发起时间,第三方支付平台的交易完成时间,银行系统平台的交易完成时间,银行系统平台返回的交易单号,银行系统平台的交易金额,银行系统平台的交易状态,等等。而比对校验的交易记录需要考虑的因素是第三方支付平台的交易单号,银行系统平台的交易单号,银行系统平台的交易金额,银行系统平台的交易时间,是否参与过比对,数据是否一致,错误的原因,等等。由于两者存在一定的区别,因此使用单独的表进行校验比较方便。In the specific implementation, since the original transaction records of each platform often have different emphases, the content fields of the records are also different. If the original transaction table used to record transaction records is used, the data consistency between the verification platforms cannot be satisfied. Therefore, it is usually necessary to use a separate table for recording and verification. The elements of the transaction table of each platform generally include the transaction order number of the e-commerce website platform that triggered the transaction externally, the transaction initiation time of the e-commerce website platform, the transaction initiation time of the third-party payment platform, and the transaction completion time of the third-party payment platform , the transaction completion time of the banking system platform, the transaction order number returned by the banking system platform, the transaction amount of the banking system platform, the transaction status of the banking system platform, and so on. The factors that need to be considered in the comparison and verification of transaction records are the transaction order number of the third-party payment platform, the transaction order number of the banking system platform, the transaction amount of the banking system platform, the transaction time of the banking system platform, whether they have participated in the comparison, Whether the data is consistent, the reason for the error, and so on. Since there are certain differences between the two, it is more convenient to use a separate table for verification.

首先,可以确定进行校验的周期为一个自然天,在每天凌晨两点(周期和时间仅仅是举例而言),第三方支付平台可以收集在该周期内的平台数据交互信息,即其与银行系统平台的交易记录写入第一信息表(收集表),然后收集银行系统平台的数据记录信息,即与第三方支付平台交易记录写入第二信息表(外部记录表)进行对比校验,若发现第三方支付平台的交易记录与银行系统平台的交易数据一致,则可以将该交易记录写入第四信息表(外平表),并将收集表中的第一数据处理状态标识更新为清算完成状态,将外部记录表中的第二数据处理状态标识更新为比对完成状态;若发现第三方支付平台的交易记录与银行系统平台的交易金额不一致,则可以将该交易记录写入第三信息表(外差表),并将外部记录表的第二数据处理状态标识更新为清算比对状态。First of all, it can be determined that the verification cycle is a natural day. At two o'clock in the morning every day (the cycle and time are just examples), the third-party payment platform can collect platform data interaction information during this cycle, that is, it and the bank The transaction records of the system platform are written into the first information table (collection table), and then the data record information of the banking system platform is collected, that is, the transaction records of the third-party payment platform are written into the second information table (external record table) for comparison and verification, If the transaction record of the third-party payment platform is found to be consistent with the transaction data of the banking system platform, the transaction record can be written into the fourth information table (outer flat table), and the first data processing state identification in the collection table is updated as In the status of liquidation completion, update the second data processing status identifier in the external record table to the status of comparison completion; if it is found that the transaction record of the third-party payment platform is inconsistent with the transaction amount of the banking system platform, the transaction record can be written into the first Three information tables (heterodyne tables), and update the second data processing status identifier of the external record table to the clearing and comparison status.

优选地是,第三方支付平台获取银行系统平台生成的交易记录的记录文件,可以使用FTP(File Transfer Protocol,文件传输协议)来进行获取,即每天到了固定时间,银行系统平台拷贝记录文件到指定的服务器上暴露FTP服务的路径位置上,例如路径:/home/ftp/,该路径暴露给远程计算机的位置是FTP://xxx.xxx.xxx.xxx./,这个路径位置可以是一个事先约定好的位置,这样第三方支付平台可以通过事先商定好的用户名和密码,每天在固定时间去该路径位置获取记录文件。Preferably, the third-party payment platform obtains the record file of the transaction record generated by the banking system platform, and can use FTP (File Transfer Protocol, File Transfer Protocol) to obtain, that is, at a fixed time every day, the bank system platform copies the record file to the specified The path where the FTP service is exposed on the server, such as the path: /home/ftp/, the location where the path is exposed to the remote computer is FTP://xxx.xxx.xxx.xxx./, this path location can be a prior The agreed location, so that the third-party payment platform can go to the path location to obtain the record file at a fixed time every day through the pre-agreed user name and password.

在本发明的一种优选实施例中,所述步骤S105以包括如下子步骤:In a preferred embodiment of the present invention, the step S105 may include the following sub-steps:

子步骤S11,提取所述第二特征参数信息中所述第二平台数据业务标识关联的第一平台数据业务标识;Sub-step S11, extracting the first platform data service identifier associated with the second platform data service identifier in the second characteristic parameter information;

子步骤S12,依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。Sub-step S12, extracting corresponding first feature parameter information from the first information table according to the first platform data service identifier.

在实际中,从银行系统平台获取并写入外部记录表的交易记录具有与第三方支付平台相关联的交易单号,可以依据银行系统平台的交易单号从收集表中提取出对应的第三方支付平台的交易记录。In practice, the transaction records obtained from the banking system platform and written into the external record table have a transaction order number associated with the third-party payment platform, and the corresponding third-party payment can be extracted from the collection table based on the transaction order number of the banking system platform. Transaction records of the payment platform.

可选地,所述方法还可以包括:Optionally, the method may also include:

在所述第一信息表和第二信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第二特征参数信息写入第四信息表。When the corresponding interaction data feature values in the first information table and the second information table are consistent, the corresponding first feature parameter information and/or second feature parameter information are extracted and written into the fourth information table.

在本发明实施例中,若收集表和外部记录表中对应的交易记录一致,可以提取该交易记录的写入外平表,表示该交易已经清算完成,银行系统平台与第三方支付平台已经完成了该笔交易。另外,若收集表和外部交易表中对应的交易记录不一致,可以提取该交易记录写入外差表,表示该交易尚未清算完成,银行系统平台与第三方支付平台还没完成该笔交易,还需进行相关的后续处理。In the embodiment of the present invention, if the corresponding transaction records in the collection table and the external record table are consistent, the transaction record can be extracted and written into the external table, indicating that the transaction has been cleared, and the banking system platform and the third-party payment platform have completed the transaction. In addition, if the corresponding transaction records in the collection table and the external transaction table are inconsistent, the transaction record can be extracted and written into the heterodyne table, indicating that the transaction has not been liquidated, and the banking system platform and the third-party payment platform have not yet completed the transaction. Relevant follow-up processing is required.

可选地,所述第三信息表中还可以包括错误类型;所述方法还可以包括:Optionally, the third information table may also include error types; the method may also include:

在依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;When extracting the corresponding first characteristic parameter information in the first information table according to the second characteristic parameter information fails, update the error type in the third information table to the error type of data search failure;

在所述第一信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。When the corresponding interaction data feature values in the first information table and the second information table are inconsistent, update the error type in the third information table to an error type of data inconsistency.

在本发明实施例中,在外差表中可以增加一个字段:错误类型。若在依据银行系统平台与第三方支付平台相关联的交易单号获取收集表中的交易记录失败时,将该字段更新为数据查找失败的错误类型,表示查找交易记录失败,在收集表中并无与银行系统平台相关的交易记录。若依据银行系统平台与第三方支付平台相关联的交易单号获取收集表中的交易记录成功,但发现双方的交易记录的交易金额不一致,则将该字段更新为数据不一致的错误类型,表示第三方支付平台的记录可能有错,或者尚未更新,与银行系统平台的交易记录达到同步。In the embodiment of the present invention, a field may be added in the heterodyne table: error type. If it fails to obtain the transaction records in the collection table based on the transaction order number associated with the banking system platform and the third-party payment platform, update this field to the error type of data search failure, indicating that the search for transaction records failed, and in the collection table and There are no transaction records related to the banking system platform. If the transaction record in the collection table is obtained successfully based on the transaction order number associated with the banking system platform and the third-party payment platform, but the transaction amount of the transaction records of both parties is found to be inconsistent, then update this field to an error type of data inconsistency, indicating that the first The records of the third-party payment platform may be wrong, or have not been updated, so as to synchronize with the transaction records of the banking system platform.

可选地,所述第三信息表还可以包括处理类型,所述处理类型可以包括未处理类型和处理完成类型;所述方法还可以包括:Optionally, the third information table may also include a processing type, and the processing type may include an unprocessed type and a processing completion type; the method may also include:

遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。Traverse the third information table to process the data records whose processing type is unprocessed one by one, and update the data processing type to the processing completed type after the processing is completed.

在本发明实施例中,在外差表中可以增加一个字段:处理类型,其中,处理类型可以包括未处理类型和处理完成类型。对于加入外差表的每笔交易记录,最终都需要进行处理,所以外差表的每笔交易记录会在处理类型标记一个属性,表示是否处理完成。对于在外差表沉淀的交易记录,运维人员可以根据交易单号去和银行系统平台的人员进行沟通,查找错误原因,最终将外差表的所有交易记录都打上“处理完成”的标志。In the embodiment of the present invention, a field may be added in the heterodyne table: processing type, where the processing type may include an unprocessed type and a processed type. For each transaction record added to the heterodyne table, it needs to be processed eventually, so each transaction record in the heterodyne table will mark an attribute in the processing type, indicating whether the processing is completed. For the transaction records accumulated in the foreign table, the operation and maintenance personnel can communicate with the personnel of the banking system platform according to the transaction order number, find out the cause of the error, and finally mark all the transaction records of the foreign table as "processing completed".

需要说明的是,交易记录进行校验的方式可以有很多种,在本发明实施例中可以使用数据库,数据库具有事务功能,这样可以保证一旦发生宕机或者由于其他原因造成的执行中断,可以从头重新执行,并且不会产生中间数据。在本发明实施例中选择将交易记录导入数据库再进行比对,好处在于可以充分利用数据库提供的很多现有功能,例如可以按照各个字段进行排序,使用数据库的事务性的功能,便捷的SQL查询功能,等等,并且实现简单,可以节省很多开发时间。It should be noted that there are many ways to verify the transaction records. In the embodiment of the present invention, a database can be used, and the database has a transaction function. Re-execute without generating intermediate data. In the embodiment of the present invention, choosing to import transaction records into the database for comparison has the advantage of being able to make full use of many existing functions provided by the database, such as sorting according to each field, using the transactional functions of the database, and convenient SQL query functions, etc., and the implementation is simple, which can save a lot of development time.

参照图2,示出了根据本发明一个实施例2的一种多平台之间数据一致性校验的方法实施例的一部分的步骤流程图;在本发明的上述实施例1的基础上,所述多平台还可以包括互相通信的第一平台和第三平台;所述方法还可以包括如下步骤:Referring to FIG. 2 , it shows a flow chart of steps of a part of a method embodiment of a data consistency check between multiple platforms according to an embodiment 2 of the present invention; on the basis of the above-mentioned embodiment 1 of the present invention, the The multi-platform may also include a first platform and a third platform communicating with each other; the method may also include the following steps:

步骤S201,获取第三平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第三特征参数信息写入第五信息表;其中,所述第三特征参数信息包括:第三平台数据业务标识,所述第三平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第三数据处理状态标识;Step S201, obtaining data record information of the third platform within a corresponding preset time period, extracting third characteristic parameter information from the data record information and writing it into the fifth information table; wherein, the third characteristic parameter information includes: The third platform data service identifier, the first platform data service identifier associated with the third platform data service identifier, the interactive data feature value, and the third data processing status identifier;

步骤S203,逐条提取所述第五信息表中第三特征参数信息,依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息;Step S203, extracting the third characteristic parameter information in the fifth information table one by one, and extracting the corresponding first characteristic parameter information in the first information table according to the third characteristic parameter information;

步骤S205,判断所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值是否一致;若一致,则执行步骤S207;若不一致,则执行步骤S209;Step S205, judging whether the corresponding interaction data feature values in the first feature parameter information and the third feature parameter information are consistent; if they are consistent, then perform step S207; if they are not consistent, then perform step S209;

步骤S207,将所述第一数据处理状态标识更新为清算完成状态,将所述第三数据处理状态标识更新为比对完成状态;Step S207, updating the first data processing status identifier to the liquidation completion status, and updating the third data processing status identifier to the comparison completion status;

步骤S209,将所述第三数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和第三特征参数信息写入第三信息表。Step S209, updating the third data processing status flag to the clearing and comparison status, and extracting the corresponding first characteristic parameter information and third characteristic parameter information and writing them into the third information table.

在本发明的一种优选实施例中,所述第三平台可以为电子商务网站平台;所述第三平台数据业务标识可以为电子商务网站平台的交易单号;所述交互数据特征数值可以为交易金额。In a preferred embodiment of the present invention, the third platform may be an e-commerce website platform; the data service identifier of the third platform may be the transaction order number of the e-commerce website platform; the characteristic value of the interactive data may be Transaction amount.

在本发明的一种优选实施例中,所述步骤S203可以包括如下子步骤:In a preferred embodiment of the present invention, the step S203 may include the following sub-steps:

子步骤S21,提取所述第三特征参数信息中所述第三平台数据业务标识关联的第一平台数据业务标识;Sub-step S21, extracting the first platform data service identifier associated with the third platform data service identifier in the third characteristic parameter information;

子步骤S22,依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。Sub-step S22, extracting corresponding first feature parameter information from the first information table according to the first platform data service identifier.

可选地,所述方法还可以包括:Optionally, the method may also include:

在所述第一信息表和第五信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第三特征参数信息写入第四信息表。When the corresponding interaction data feature values in the first information table and the fifth information table are consistent, the corresponding first feature parameter information and/or third feature parameter information are extracted and written into the fourth information table.

可选地,所述第三信息表中还可以包括错误类型;所述方法还可以包括:Optionally, the third information table may also include error types; the method may also include:

在依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;When extracting the corresponding first characteristic parameter information in the first information table according to the third characteristic parameter information fails, update the error type in the third information table to the error type of data search failure;

在所述第五信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。When the corresponding interaction data feature values in the fifth information table and the second information table are inconsistent, update the error type in the third information table to an error type of data inconsistency.

可选地,所述第三信息表还可以包括处理类型,所述处理类型可以包括未处理类型和处理完成类型;所述方法还可以包括:Optionally, the third information table may also include a processing type, and the processing type may include an unprocessed type and a processing completion type; the method may also include:

遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。Traverse the third information table to process the data records whose processing type is unprocessed one by one, and update the data processing type to the processing completed type after the processing is completed.

由于电子商务网站平台与第三方支付平台,银行系统平台与第三方支付平台之间的交易记录的进行比对方式与图1的方法实施例基本相似,所以描述的比较简单,相关之处参见方法实施例的部分说明即可。Since the comparison method of transaction records between the e-commerce website platform and the third-party payment platform, and the banking system platform and the third-party payment platform is basically similar to the method embodiment in Figure 1, the description is relatively simple. For relevant information, please refer to the method Part of the description of the examples will suffice.

对于方法实施例,为了简单描述,故将其都表述为一系列的动作组合,但是本领域技术人员应该知悉,本发明并不受所描述的动作顺序的限制,因为依据本发明,某些步骤可以采用其他顺序或者同时进行。其次,本领域技术人员也应该知悉,说明书中所描述的实施例均属于优选实施例,所涉及的动作和模块并不一定是本发明所必须的。For the method embodiment, for the sake of simple description, it is expressed as a series of action combinations, but those skilled in the art should know that the present invention is not limited by the described action sequence, because according to the present invention, certain steps Other sequences or concurrently may be used. Secondly, those skilled in the art should also know that the embodiments described in the specification belong to preferred embodiments, and the actions and modules involved are not necessarily required by the present invention.

参照图3,示出了根据本发明一个实施例1的一种多平台之间数据一致性校验的系统实施例的结构框图,所述多平台可以包括互相通信的第一平台和第二平台,所述的系统可以包括如下模块:Referring to FIG. 3 , it shows a structural block diagram of a system embodiment of a data consistency check between multiple platforms according to Embodiment 1 of the present invention. The multiple platforms may include a first platform and a second platform that communicate with each other. , the system may include the following modules:

收集模块301,用于收集第一平台在预设时间段内的平台数据交互信息,从所述平台数据交互信息中提取第一特征参数信息并写入第一信息表;所述特征参数信息包括:第一平台数据业务标识,交互数据特征数值,以及,第一数据处理状态标识;The collection module 301 is configured to collect platform data interaction information of the first platform within a preset time period, extract first characteristic parameter information from the platform data interaction information and write it into the first information table; the characteristic parameter information includes : first platform data service identifier, interactive data feature value, and first data processing status identifier;

获取模块303,用于获取第二平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第二特征参数信息写入第二信息表;其中,所述第二特征参数信息包括:第二平台数据业务标识,所述第二平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第二数据处理状态标识;The acquisition module 303 is configured to acquire data record information of the second platform within a corresponding preset time period, extract second characteristic parameter information from the data record information, and write it into a second information table; wherein, the second characteristic parameter The information includes: the second platform data service identifier, the first platform data service identifier associated with the second platform data service identifier, the interactive data feature value, and the second data processing status identifier;

提取模块305,用于逐条提取所述第二信息表中第二特征参数信息,依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息;An extraction module 305, configured to extract the second characteristic parameter information in the second information table one by one, and extract the corresponding first characteristic parameter information in the first information table according to the second characteristic parameter information;

判断模块307,用于判断所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值是否一致;A judging module 307, configured to judge whether the corresponding interaction data characteristic values in the first characteristic parameter information and the second characteristic parameter information are consistent;

更新模块309,用于若所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值一致,则将所述第一数据处理状态标识更新为清算完成状态,将所述第二数据处理状态标识更新为比对完成状态;An updating module 309, configured to update the first data processing status flag to a liquidation completion status if the corresponding interaction data feature values in the first feature parameter information and the second feature parameter information are consistent, and update the second The data processing status indicator is updated to the comparison completion status;

以及,若所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值不一致,则将所述第二数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和第二特征参数信息写入第三信息表。And, if the corresponding interaction data characteristic values in the first characteristic parameter information and the second characteristic parameter information are inconsistent, update the second data processing state flag to the clearing comparison state, and extract the corresponding first characteristic parameter The information and the second feature parameter information are written into the third information table.

在本发明的一种优选实施例中,所述提取模块305可以包括:In a preferred embodiment of the present invention, the extraction module 305 may include:

标识提取子模块,用于提取所述第二特征参数信息中所述第二平台数据业务标识关联的第一平台数据业务标识;An identifier extraction submodule, configured to extract the first platform data service identifier associated with the second platform data service identifier in the second characteristic parameter information;

参数查找子模块,用于依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。The parameter search submodule is configured to extract corresponding first feature parameter information from the first information table according to the first platform data service identifier.

可选地,所述系统还可以包括:Optionally, the system may also include:

所述更新模块309还用于在所述第一信息表和第二信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和第二特征参数信息写入第四信息表。The update module 309 is also used to extract the corresponding first feature parameter information and second feature parameter information and write them into the fourth information table when the corresponding interaction data feature values in the first information table and the second information table are consistent. .

可选地,所述第三信息表中还可以包括错误类型;所述系统还可以包括:Optionally, the third information table may also include error types; the system may also include:

类型更新模块,用于在依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;A type update module, configured to update the error type in the third information table to an error of data search failure when the corresponding first characteristic parameter information in the first information table fails to be extracted according to the second characteristic parameter information Types of;

以及,所述类型更新模块还用于在所述第一信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。And, the type updating module is further configured to update the error type in the third information table to an error type of data inconsistency when the corresponding interaction data feature values in the first information table and the second information table are inconsistent.

可选地,所述第三信息表还可以包括处理类型,所述处理类型可以包括未处理类型和处理完成类型;所述系统还可以包括:Optionally, the third information table may also include a processing type, and the processing type may include an unprocessed type and a processing completion type; the system may also include:

遍历处理模块,用于遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。The traversal processing module is used to traverse the third information table to process the data records whose processing type is unprocessed one by one, and update the data processing type to the processing completed type after the processing is completed.

对于图3的系统实施例而言,由于其与图1的方法实施例基本相似,所以描述的比较简单,相关之处参见方法实施例的部分说明即可。As for the system embodiment in FIG. 3 , since it is basically similar to the method embodiment in FIG. 1 , the description is relatively simple, and for related parts, please refer to the part of the description of the method embodiment.

参照图4,示出了根据本发明一个实施例的一种多平台之间数据一致性校验的系统实施例2的一部分的结构框图,在本发明的上述实施例3的基础上,所述多平台还可以包括互相通信的第一平台进行和第三平台;所述的系统还可以包括如下模块:Referring to FIG. 4 , it shows a structural block diagram of a part of Embodiment 2 of a system for checking data consistency between multiple platforms according to an embodiment of the present invention. On the basis of the above-mentioned Embodiment 3 of the present invention, the The multi-platform can also include the first platform and the third platform communicating with each other; the system can also include the following modules:

所述获取模块S401还用于获取第三平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第三特征参数信息写入第五信息表;其中,所述第三特征参数信息包括:第三平台数据业务标识,所述第三平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第三数据处理状态标识;The obtaining module S401 is also used to obtain data record information of the third platform within a corresponding preset time period, extract third characteristic parameter information from the data record information, and write it into the fifth information table; wherein, the third The characteristic parameter information includes: the third platform data service identifier, the first platform data service identifier associated with the third platform data service identifier, the interactive data characteristic value, and the third data processing status identifier;

所述提取模块S403还用于逐条提取所述第五信息表中第三特征参数信息,依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息;The extracting module S403 is further configured to extract third characteristic parameter information in the fifth information table one by one, and extract corresponding first characteristic parameter information in the first information table according to the third characteristic parameter information;

所述判断模块S405还用于判断所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值是否一致;The judging module S405 is also used to judge whether the corresponding interaction data characteristic values in the first characteristic parameter information and the third characteristic parameter information are consistent;

所述更新模块S407,用于若所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值一致,则将所述第一数据处理状态标识更新为清算完成状态,将所述第三数据处理状态标识更新为比对完成状态;The update module S407 is configured to update the first data processing status flag to a liquidation completion status if the corresponding interaction data feature values in the first feature parameter information and the third feature parameter information are consistent, and set the The third data processing status flag is updated to the comparison completion status;

所述更新模块S407还用于若所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值不一致,则将所述第三数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和/或第三特征参数信息写入第三信息表。The update module S407 is further configured to update the third data processing status flag to the clearing comparison status if the corresponding interaction data feature values in the first feature parameter information and the third feature parameter information are inconsistent, and extract The corresponding first feature parameter information and/or third feature parameter information is written into the third information table.

在本发明的一种优选实施例中,所述提取模块S403可以包括:In a preferred embodiment of the present invention, the extraction module S403 may include:

所述标识提取子模块还用于提取所述第三特征参数信息中所述第三平台数据业务标识关联的第一平台数据业务标识;The identifier extraction submodule is also used to extract the first platform data service identifier associated with the third platform data service identifier in the third characteristic parameter information;

所述参数提取子模块还用于依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。The parameter extraction sub-module is further configured to extract corresponding first characteristic parameter information in the first information table according to the first platform data service identifier.

可选地,所述系统还可以包括:Optionally, the system may also include:

所述更新模块S407还用于在所述第一信息表和第五信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第三特征参数信息写入第四信息表。The update module S407 is further configured to extract the corresponding first feature parameter information and/or third feature parameter information and write it into the fourth Information Sheet.

可选地,所述第三信息表中还可以包括错误类型;所述系统还可以包括:Optionally, the third information table may also include error types; the system may also include:

所述类型更新模块还用于在依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;The type update module is further configured to update the error type in the third information table to data lookup failure when the corresponding first characteristic parameter information in the first information table fails to be extracted according to the third characteristic parameter information the type of error;

以及,所述类型更新模块还用于在所述第五信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。And, the type updating module is further configured to update the error type in the third information table to an error type of data inconsistency when the corresponding interactive data feature values in the fifth information table and the second information table are inconsistent.

可选地,所述第三信息表还可以包括处理类型,所述处理类型可以包括未处理类型和处理完成类型;所述系统还可以包括:Optionally, the third information table may also include a processing type, and the processing type may include an unprocessed type and a processing completion type; the system may also include:

遍历处理模块还用于遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。The traversal processing module is also used to traverse the third information table to process the data records whose processing type is unprocessed one by one, and update the data processing type to the processing completed type after the processing is completed.

对于图4的系统实施例而言,由于其与图2的方法实施例基本相似,所以描述的比较简单,相关之处参见方法实施例的部分说明即可。As for the system embodiment in FIG. 4 , since it is basically similar to the method embodiment in FIG. 2 , the description is relatively simple, and for related parts, please refer to the part of the description of the method embodiment.

在此提供的算法和显示不与任何特定计算机、虚拟系统或者其它设备固有相关。各种通用系统也可以与基于在此的示教一起使用。根据上面的描述,构造这类系统所要求的结构是显而易见的。此外,本发明也不针对任何特定编程语言。应当明白,可以利用各种编程语言实现在此描述的本发明的内容,并且上面对特定语言所做的描述是为了披露本发明的最佳实施方式。The algorithms and displays presented herein are not inherently related to any particular computer, virtual system, or other device. Various generic systems can also be used with the teachings based on this. The structure required to construct such a system is apparent from the above description. Furthermore, the present invention is not specific to any particular programming language. It should be understood that various programming languages can be used to implement the content of the present invention described herein, and the above description of specific languages is for disclosing the best mode of the present invention.

在此处所提供的说明书中,说明了大量具体细节。然而,能够理解,本发明的实施例可以在没有这些具体细节的情况下实践。在一些实例中,并未详细示出公知的方法、结构和技术,以便不模糊对本说明书的理解。In the description provided herein, numerous specific details are set forth. However, it is understood that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure the understanding of this description.

类似地,应当理解,为了精简本公开并帮助理解各个发明方面中的一个或多个,在上面对本发明的示例性实施例的描述中,本发明的各个特征有时被一起分组到单个实施例、图、或者对其的描述中。然而,并不应将该公开的方法解释成反映如下意图:即所要求保护的本发明要求比在每个权利要求中所明确记载的特征更多的特征。更确切地说,如下面的权利要求书所反映的那样,发明方面在于少于前面公开的单个实施例的所有特征。因此,遵循具体实施方式的权利要求书由此明确地并入该具体实施方式,其中每个权利要求本身都作为本发明的单独实施例。Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, in order to streamline this disclosure and to facilitate an understanding of one or more of the various inventive aspects, various features of the invention are sometimes grouped together in a single embodiment, figure, or its description. This method of disclosure, however, is not to be interpreted as reflecting an intention that the claimed invention requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the Detailed Description are hereby expressly incorporated into this Detailed Description, with each claim standing on its own as a separate embodiment of this invention.

本领域那些技术人员可以理解,可以对实施例中的设备中的模块进行自适应性地改变并且把它们设置在与该实施例不同的一个或多个设备中。可以把实施例中的模块或单元或组件组合成一个模块或单元或组件,以及此外可以把它们分成多个子模块或子单元或子组件。除了这样的特征和/或过程或者单元中的至少一些是相互排斥之外,可以采用任何组合对本说明书(包括伴随的权利要求、摘要和附图)中公开的所有特征以及如此公开的任何方法或者设备的所有过程或单元进行组合。除非另外明确陈述,本说明书(包括伴随的权利要求、摘要和附图)中公开的每个特征可以由提供相同、等同或相似目的的替代特征来代替。Those skilled in the art can understand that the modules in the device in the embodiment can be adaptively changed and arranged in one or more devices different from the embodiment. Modules or units or components in the embodiments may be combined into one module or unit or component, and furthermore may be divided into a plurality of sub-modules or sub-units or sub-assemblies. All features disclosed in this specification (including accompanying claims, abstract and drawings) and any method or method so disclosed may be used in any combination, except that at least some of such features and/or processes or units are mutually exclusive. All processes or units of equipment are combined. Each feature disclosed in this specification (including accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.

此外,本领域的技术人员能够理解,尽管在此所述的一些实施例包括其它实施例中所包括的某些特征而不是其它特征,但是不同实施例的特征的组合意味着处于本发明的范围之内并且形成不同的实施例。例如,在下面的权利要求书中,所要求保护的实施例的任意之一都可以以任意的组合方式来使用。Furthermore, those skilled in the art will understand that although some embodiments described herein include some features included in other embodiments but not others, combinations of features from different embodiments are meant to be within the scope of the invention. and form different embodiments. For example, in the following claims, any of the claimed embodiments may be used in any combination.

本发明的各个部件实施例可以以硬件实现,或者以在一个或者多个处理器上运行的软件模块实现,或者以它们的组合实现。本领域的技术人员应当理解,可以在实践中使用微处理器或者数字信号处理器(DSP)来实现根据本发明实施例的多平台之间数据一致性校验设备中的一些或者全部部件的一些或者全部功能。本发明还可以实现为用于执行这里所描述的方法的一部分或者全部的设备或者装置程序(例如,计算机程序和计算机程序产品)。这样的实现本发明的程序可以存储在计算机可读介质上,或者可以具有一个或者多个信号的形式。这样的信号可以从因特网网站上下载得到,或者在载体信号上提供,或者以任何其他形式提供。The various component embodiments of the present invention may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. Those skilled in the art should understand that a microprocessor or a digital signal processor (DSP) can be used in practice to implement some or all of the components in the multi-platform data consistency check device according to the embodiment of the present invention. Or full functionality. The present invention can also be implemented as an apparatus or an apparatus program (for example, a computer program and a computer program product) for performing a part or all of the methods described herein. Such a program for realizing the present invention may be stored on a computer-readable medium, or may be in the form of one or more signals. Such a signal may be downloaded from an Internet site, or provided on a carrier signal, or provided in any other form.

应该注意的是上述实施例对本发明进行说明而不是对本发明进行限制,并且本领域技术人员在不脱离所附权利要求的范围的情况下可设计出替换实施例。在权利要求中,不应将位于括号之间的任何参考符号构造成对权利要求的限制。单词“包含”不排除存在未列在权利要求中的元件或步骤。位于元件之前的单词“一”或“一个”不排除存在多个这样的元件。本发明可以借助于包括有若干不同元件的硬件以及借助于适当编程的计算机来实现。在列举了若干装置的单元权利要求中,这些装置中的若干个可以是通过同一个硬件项来具体体现。单词第一、第二、以及第三等的使用不表示任何顺序。可将这些单词解释为名称。It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention can be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In a unit claim enumerating several means, several of these means can be embodied by one and the same item of hardware. The use of the words first, second, and third, etc. does not indicate any order. These words can be interpreted as names.

本发明的实施例公开了A1、一种多平台之间数据一致性校验的方法,所述多平台包括互相通信的第一平台和第二平台,所述的方法包括:收集第一平台在预设时间段内的平台数据交互信息,从所述平台数据交互信息中提取第一特征参数信息并写入第一信息表;所述特征参数信息包括:第一平台数据业务标识,交互数据特征数值,以及,第一数据处理状态标识;获取第二平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第二特征参数信息写入第二信息表;其中,所述第二特征参数信息包括:第二平台数据业务标识,所述第二平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第二数据处理状态标识;逐条提取所述第二信息表中第二特征参数信息,依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息;判断所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值是否一致;若一致,则将所述第一数据处理状态标识更新为清算完成状态,将所述第二数据处理状态标识更新为比对完成状态;若不一致,则将所述第二数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和/或第二特征参数信息写入第三信息表。A2、如A1所述的方法,所述依据第二特征参数信息提取所述第一信息表中对应的第一特征参数信息的步骤包括:提取所述第二特征参数信息中所述第二平台数据业务标识关联的第一平台数据业务标识;依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。A3、如A1所述的方法,还包括:在所述第一信息表和第二信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第二特征参数信息写入第四信息表。A4、如A1所述的方法,所述第三信息表中还包括错误类型;所述方法还包括:在依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;在所述第一信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。A5、如A1所述的方法,所述第三信息表还包括处理类型,所述处理类型包括未处理类型和处理完成类型;所述方法还包括:遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。A6、如A1所述的方法,所述多平台还包括互相通信第一平台和第三平台;所述的方法还包括:获取第三平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第三特征参数信息写入第五信息表;其中,所述第三特征参数信息包括:第三平台数据业务标识,所述第三平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第三数据处理状态标识;逐条提取所述第五信息表中第三特征参数信息,依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息;判断所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值是否一致;若一致,则将所述第一数据处理状态标识更新为清算完成状态,将所述第三数据处理状态标识更新为比对完成状态;若不一致,则将所述第三数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和/或第三特征参数信息写入第三信息表。A7、如A6所述的方法,所述依据第三特征参数信息提取所述第一信息表中对应的第一特征参数信息的步骤包括:提取所述第三特征参数信息中所述第三平台数据业务标识关联的第一平台数据业务标识;依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。A8、如A1或A6所述的方法,还包括:在所述第一信息表和第三信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第三特征参数信息写入第四信息表。A9、如A4或A6所述的方法,还包括:在依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;在所述第五信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。A10、如A1或A5或A7所述的方法,还包括:遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。A11、如A1所述的方法,所述第一平台为第三方支付平台,所述第二平台为银行系统平台,所述第三平台为电子商务网站平台;所述第一平台数据业务标识为第三方支付平台的交易单号;所述第二平台数据业务标识为银行系统平台的交易单号;所述第三平台数据业务标识为电子商务网站平台的交易单号;所述交互数据特征数值为交易金额。The embodiment of the present invention discloses A1, a method for checking data consistency between multiple platforms, the multiple platforms include a first platform and a second platform that communicate with each other, and the method includes: collecting the first platform in For the platform data interaction information within a preset time period, the first feature parameter information is extracted from the platform data interaction information and written into the first information table; the feature parameter information includes: the first platform data service identifier, the interaction data feature Value, and, the first data processing state identifier; obtain the data recording information of the second platform in the corresponding preset time period, extract the second characteristic parameter information from the data recording information and write it into the second information table; wherein, the The second characteristic parameter information includes: the second platform data service identifier, the first platform data service identifier associated with the second platform data service identifier, the interactive data characteristic value, and the second data processing status identifier; The second feature parameter information in the second information table, extracting the corresponding first feature parameter information in the first information table according to the second feature parameter information; judging the first feature parameter information and the second feature parameter information Whether the corresponding interactive data feature values are consistent; if they are consistent, update the first data processing status identifier to a clearing completion status, and update the second data processing status identifier to a comparison completion status; if not, update all The second data processing state flag is updated to the liquidation and comparison state, and the corresponding first characteristic parameter information and/or second characteristic parameter information are extracted and written into the third information table. A2. The method as described in A1, the step of extracting the corresponding first characteristic parameter information in the first information table according to the second characteristic parameter information includes: extracting the second platform in the second characteristic parameter information A first platform data service identifier associated with the data service identifier; extracting corresponding first characteristic parameter information in the first information table according to the first platform data service identifier. A3. The method according to A1, further comprising: extracting the corresponding first characteristic parameter information and/or second characteristic parameter information when the corresponding interaction data characteristic values in the first information table and the second information table are consistent Write the fourth information table. A4. The method as described in A1, the third information table also includes error types; the method further includes: extracting the corresponding first characteristic parameter in the first information table according to the second characteristic parameter information When the information fails, update the error type in the third information table to the error type of data search failure; when the corresponding interactive data feature values in the first information table and the second information table are inconsistent, update the third information table The error type in the information table is the error type of data inconsistency. A5. The method as described in A1, the third information table also includes a processing type, and the processing type includes an unprocessed type and a processing completion type; the method also includes: traversing the third information table for the processing type to be The unprocessed data records are processed one by one, and the data processing type is updated to the processing completion type after the processing is completed. A6. The method as described in A1, the multi-platform also includes the first platform and the third platform communicating with each other; the method also includes: acquiring the data record information of the third platform in the corresponding preset time period, from the The third feature parameter information is extracted from the data record information and written into the fifth information table; wherein, the third feature parameter information includes: the third platform data service identifier, the first platform data associated with the third platform data service identifier Business identifier, interactive data characteristic value, and third data processing status identifier; extract the third characteristic parameter information in the fifth information table one by one, and extract the corresponding information in the first information table according to the third characteristic parameter information The first feature parameter information; judging whether the corresponding interaction data feature values in the first feature parameter information and the third feature parameter information are consistent; if they are consistent, updating the first data processing status flag to the liquidation completion status, and The third data processing state identification is updated to the comparison completion state; if inconsistent, the third data processing state identification is updated to the liquidation comparison state, and the corresponding first feature parameter information and/or third feature are extracted The parameter information is written into the third information table. A7. The method as described in A6, the step of extracting the corresponding first characteristic parameter information in the first information table according to the third characteristic parameter information includes: extracting the third platform in the third characteristic parameter information A first platform data service identifier associated with the data service identifier; extracting corresponding first characteristic parameter information in the first information table according to the first platform data service identifier. A8. The method described in A1 or A6, further comprising: extracting the corresponding first feature parameter information and/or third feature when the corresponding interaction data feature values in the first information table and the third information table are consistent The parameter information is written into the fourth information table. A9. The method as described in A4 or A6, further comprising: when extracting the corresponding first characteristic parameter information in the first information table according to the third characteristic parameter information fails, updating the information in the third information table The error type is an error type of data search failure; when the corresponding interactive data feature values in the fifth information table and the second information table are inconsistent, update the error type in the third information table to an error type of data inconsistency. A10. The method described in A1 or A5 or A7, further comprising: traversing the third information table to process the data records whose processing type is unprocessed one by one, and updating the data processing type to the processing completed type after the processing is completed. A11, the method as described in A1, the first platform is a third-party payment platform, the second platform is a banking system platform, and the third platform is an e-commerce website platform; the data service identifier of the first platform is The transaction order number of the third-party payment platform; the second platform data service identification is the transaction order number of the banking system platform; the third platform data service identification is the transaction order number of the e-commerce website platform; the interactive data feature value is the transaction amount.

根据本发明的实施例还公开了B12、一种多平台之间数据一致性校验的系统,所述多平台包括互相通信的第一平台和第二平台,所述的系统包括:收集模块,用于收集第一平台在预设时间段内的平台数据交互信息,从所述平台数据交互信息中提取第一特征参数信息并写入第一信息表;所述特征参数信息包括:第一平台数据业务标识,交互数据特征数值,以及,第一数据处理状态标识;获取模块,用于获取第二平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第二特征参数信息写入第二信息表;其中,所述第二特征参数信息包括:第二平台数据业务标识,所述第二平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第二数据处理状态标识;提取模块,用于逐条提取所述第二信息表中第二特征参数信息,依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息;判断模块,用于判断所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值是否一致;更新模块,用于若所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值一致,则将所述第一数据处理状态标识更新为清算完成状态,将所述第二数据处理状态标识更新为比对完成状态;以及,若所述第一特征参数信息和第二特征参数信息中对应的交互数据特征数值不一致,则将所述第二数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和/或第二特征参数信息写入第三信息表。B13、如B12所述的系统,所述提取模块包括:标识提取子模块,用于提取所述第二特征参数信息中所述第二平台数据业务标识关联的第一平台数据业务标识;参数查找子模块,用于依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。B14、如B12所述的系统,其中,所述更新模块还用于在所述第一信息表和第二信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第二特征参数信息写入第四信息表。B15、如B12所述的系统,所述第三信息表中还包括错误类型;所述系统还包括:类型更新模块,用于在依据所述第二特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;以及,所述类型更新模块还用于在所述第一信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。B16、如B12所述的系统,所述第三信息表还包括处理类型,所述处理类型包括未处理类型和处理完成类型;所述系统还包括:所述遍历处理模块还用于遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。B17、如B12所述的系统,所述多平台还包括互相通信的第一平台和第三平台;所述的系统还包括:所述获取模块还用于获取第三平台在对应预设时间段内的数据记录信息,从所述数据记录信息中提取第三特征参数信息写入第五信息表;其中,所述第三特征参数信息包括:第三平台数据业务标识,所述第三平台数据业务标识关联的第一平台数据业务标识,交互数据特征数值,以及,第三数据处理状态标识;所述提取模块还用于逐条提取所述第五信息表中第三特征参数信息,依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息;判断模块还用于判断所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值是否一致;所述更新模块还用于若所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值一致,则将所述第一数据处理状态标识更新为清算完成状态,将所述第三数据处理状态标识更新为比对完成状态;所述更新模块还用于若所述第一特征参数信息和第三特征参数信息中对应的交互数据特征数值不一致,则将所述第三数据处理状态标识更新为清算比对状态,并提取对应的第一特征参数信息和/或第三特征参数信息写入第三信息表。B18、如B17所述的系统,所述提取模块包括:所述标识提取子模块还用于提取所述第三特征参数信息中所述第三平台数据业务标识关联的第一平台数据业务标识;所述参数提取子模块还用于依据所述第一平台数据业务标识在所述第一信息表中提取对应的第一特征参数信息。B19、如B12或B17所述的系统,其中,所述更新模块还用于在所述第一信息表和第五信息表中对应的交互数据特征数值一致时,提取对应的第一特征参数信息和/或第三特征参数信息写入第四信息表。B20、如B15或B17所述的系统,还包括:所述类型更新模块还用于在依据所述第三特征参数信息提取所述第一信息表中对应的第一特征参数信息失败时,更新所述第三信息表中的错误类型为数据查找失败的错误类型;以及,所述类型更新模块还用于在所述第五信息表和第二信息表中对应的交互数据特征数值不一致时,更新所述第三信息表中的错误类型为数据不一致的错误类型。B21、如B12或B16或B18所述的系统,还包括:所述遍历处理模块还用于遍历所述第三信息表对处理类型为未处理的数据记录逐条处理,在处理完成后更新数据处理类型为处理完成类型。The embodiment of the present invention also discloses B12, a system for checking data consistency between multiple platforms, the multiple platforms include a first platform and a second platform that communicate with each other, and the system includes: a collection module, It is used to collect the platform data interaction information of the first platform within a preset time period, extract the first characteristic parameter information from the platform data interaction information and write it into the first information table; the characteristic parameter information includes: the first platform Data service identifier, interactive data feature value, and first data processing status identifier; an acquisition module, configured to acquire data record information of the second platform within a corresponding preset time period, and extract the second feature from the data record information The parameter information is written into the second information table; wherein, the second characteristic parameter information includes: the second platform data service identifier, the first platform data service identifier associated with the second platform data service identifier, the interactive data characteristic value, and , the second data processing status identifier; the extraction module is used to extract the second characteristic parameter information in the second information table one by one, and extract the corresponding first characteristic parameter in the first information table according to the second characteristic parameter information information; a judging module, used to judge whether the corresponding interaction data feature values in the first feature parameter information and the second feature parameter information are consistent; an update module, used to determine if the first feature parameter information and the second feature parameter information If the corresponding interactive data feature values in the above are consistent, update the first data processing status flag to the liquidation completion status, and update the second data processing status logo to the comparison completion status; and, if the first feature parameter information is inconsistent with the corresponding interactive data characteristic values in the second characteristic parameter information, update the second data processing status flag to the clearing comparison status, and extract the corresponding first characteristic parameter information and/or second characteristic parameter information Write the third information table. B13, the system as described in B12, the extraction module includes: an identification extraction sub-module for extracting the first platform data service identification associated with the second platform data service identification in the second characteristic parameter information; parameter search A submodule, configured to extract corresponding first feature parameter information from the first information table according to the first platform data service identifier. B14. The system according to B12, wherein the update module is further configured to extract the corresponding first feature parameter information and/or when the corresponding interaction data feature values in the first information table and the second information table are consistent Or the second feature parameter information is written into the fourth information table. B15. The system as described in B12, the third information table also includes error types; the system also includes: a type update module, used to extract the first information table according to the second characteristic parameter information When the corresponding first feature parameter information fails, update the error type in the third information table to the error type of data search failure; When the corresponding interaction data feature values in the table are inconsistent, update the error type in the third information table to the error type of data inconsistency. B16, the system as described in B12, the third information table also includes processing types, and the processing types include unprocessed types and processing completion types; the system also includes: the traversal processing module is also used to traverse the The third information table processes the data records whose processing type is unprocessed one by one, and updates the data processing type to the processing completed type after the processing is completed. B17, the system as described in B12, the multi-platform also includes the first platform and the third platform that communicate with each other; the system also includes: the acquisition module is also used to acquire the third platform in the corresponding preset time period The data record information in the data record information, the third characteristic parameter information is extracted from the data record information and written into the fifth information table; wherein, the third characteristic parameter information includes: the third platform data service identifier, the third platform data The first platform data service identifier associated with the service identifier, the characteristic value of the interactive data, and the third data processing status identifier; the extraction module is also used to extract the third characteristic parameter information in the fifth information table one by one, according to the The third characteristic parameter information extracts the corresponding first characteristic parameter information in the first information table; the judging module is also used to judge whether the corresponding interactive data characteristic values in the first characteristic parameter information and the third characteristic parameter information are consistent; The update module is further configured to update the first data processing status flag to a liquidation completion status if the corresponding interaction data feature values in the first feature parameter information and the third feature parameter information are consistent, and update the second The third data processing state flag is updated to the comparison completion state; the update module is also used to process the third data if the corresponding interactive data feature values in the first feature parameter information and the third feature parameter information are inconsistent The status identification is updated to the liquidation comparison status, and the corresponding first characteristic parameter information and/or third characteristic parameter information are extracted and written into the third information table. B18. The system as described in B17, the extraction module includes: the identification extraction sub-module is also used to extract the first platform data service identification associated with the third platform data service identification in the third characteristic parameter information; The parameter extraction sub-module is further configured to extract corresponding first characteristic parameter information in the first information table according to the first platform data service identifier. B19. The system as described in B12 or B17, wherein the update module is also used to extract the corresponding first feature parameter information when the corresponding interaction data feature values in the first information table and the fifth information table are consistent And/or the third characteristic parameter information is written into the fourth information table. B20. The system as described in B15 or B17, further comprising: the type updating module is further configured to update The error type in the third information table is an error type of data search failure; and, the type updating module is further configured to, when the corresponding interaction data feature values in the fifth information table and the second information table are inconsistent, Updating the error type in the third information table to the error type of data inconsistency. B21, the system as described in B12 or B16 or B18, also includes: the traversal processing module is also used to traverse the third information table to process the unprocessed data records one by one, and update the data processing after the processing is completed Type is the processing completion type.

Claims (21)

1. between multi-platform, a method for consistency verification of data, communicates described multi-platform including mutually First platform of letter and the second platform, described method includes:
Collect first platform platform data interactive information in preset time period, from described platform number According to interactive information being extracted fisrt feature parameter information and writing first information table;Described characteristic parameter Information includes: the first platform data service identification, interaction data character numerical value, and, the first number According to processing status indicator;
Obtain second platform datalogging information in corresponding preset time period, remember from described data Record information is extracted second feature parameter information and writes the second information table;Wherein, described second feature Parameter information includes: the second platform data service identification, and described second platform data service identification closes First platform data service identification of connection, interaction data character numerical value, and, the second data process Status indicator;
Extract second feature parameter information in described second information table one by one, according to described second feature Parameter information extracts fisrt feature parameter information corresponding in described first information table;
Judge interaction data corresponding in described fisrt feature parameter information and second feature parameter information Character numerical value is the most consistent;
If consistent, then it is updated to clear completion status by described first data processing state mark, will Described second data processing state mark is updated to comparison completion status;
If inconsistent, then it is updated to clear comparison state by described second data processing state mark, And extract fisrt feature parameter information and/or second feature parameter information write the 3rd information of correspondence Table.
2. the method for claim 1, described described according to the extraction of second feature parameter information The step of fisrt feature parameter information corresponding in first information table includes:
Extract described in described second feature parameter information the of the second platform data service identification association One platform data service identification;
In described first information table, the of correspondence is extracted according to described first platform data service identification One characteristic parameter information.
3. the method for claim 1, also includes:
Interaction data character numerical value corresponding in described first information table and the second information table is consistent Time, extract corresponding fisrt feature parameter information and/or second feature parameter information write the 4th information Table.
4. the method for claim 1, also includes type of error in described 3rd information table; Described method also includes:
The first spy corresponding in described first information table is being extracted according to described second feature parameter information When levying parameter information failure, updating the type of error in described 3rd information table is data search failure Type of error;
Interaction data character numerical value corresponding in described first information table and the second information table is inconsistent Time, updating the type of error in described 3rd information table is the inconsistent type of errors of data.
5. the method for claim 1, described 3rd information table also includes processing type, institute State process type and include that untreated type and process complete type;Described method also includes:
Traveling through described 3rd information table to processing type is that untreated data record processes one by one, at place Updating data processing type after having managed is that process completes type.
6. the method for claim 1, described multi-platform also includes intercommunication the first platform With the 3rd platform;Described method also includes:
Obtain the 3rd platform datalogging information in corresponding preset time period, remember from described data Record information is extracted third feature parameter information write the 5th information table;Wherein, described third feature Parameter information includes: the 3rd platform data service identification, and described 3rd platform data service identification closes First platform data service identification of connection, interaction data character numerical value, and, the 3rd data process Status indicator;
Extract third feature parameter information in described 5th information table one by one, according to described third feature Parameter information extracts fisrt feature parameter information corresponding in described first information table;
Judge interaction data corresponding in described fisrt feature parameter information and third feature parameter information Character numerical value is the most consistent;
If consistent, then it is updated to clear completion status by described first data processing state mark, will Described 3rd data processing state mark is updated to comparison completion status;
If inconsistent, then it is updated to clear comparison state by described 3rd data processing state mark, And extract fisrt feature parameter information and/or third feature parameter information write the 3rd information of correspondence Table.
7. method as claimed in claim 6, described described according to the extraction of third feature parameter information The step of fisrt feature parameter information corresponding in first information table includes:
Extract described in described third feature parameter information the of the 3rd platform data service identification association One platform data service identification;
In described first information table, the of correspondence is extracted according to described first platform data service identification One characteristic parameter information.
8. the method as described in claim 1 or 6, also includes:
Interaction data character numerical value corresponding in described first information table and the 3rd information table is consistent Time, extract corresponding fisrt feature parameter information and/or third feature parameter information write the 4th information Table.
9. method as claimed in claim 6, also includes:
The first spy corresponding in described first information table is being extracted according to described third feature parameter information When levying parameter information failure, updating the type of error in described 3rd information table is data search failure Type of error;
Interaction data character numerical value corresponding in described 5th information table and the second information table is inconsistent Time, updating the type of error in described 3rd information table is the inconsistent type of errors of data.
10. method as claimed in claim 7, described 3rd information table also includes processing type, Described process type includes that untreated type and process complete type;Described method also includes:
Traveling through described 3rd information table to processing type is that untreated data record processes one by one, at place Updating data processing type after having managed is that process completes type.
11. methods as claimed in claim 6, described first platform is Third-party payment platform, Described second platform is banking system platform, and described 3rd platform is electronic commerce Website platform;Institute State the transaction odd numbers that the first platform data service identification is Third-party payment platform;Described second platform Data service is designated the transaction odd numbers of banking system platform;Described 3rd platform data service identification Transaction odd numbers for electronic commerce Website platform;Described interaction data character numerical value is dealing money.
12. 1 kinds multi-platform between the system of consistency verification of data, described multi-platform include mutually First platform of communication and the second platform, described system includes:
Collection module, for collecting first platform platform data interactive information in preset time period, From described platform data interactive information, extract fisrt feature parameter information and write first information table; Described characteristic parameter information includes: the first platform data service identification, interaction data character numerical value, And, the first data processing state mark;
Acquisition module, for obtaining second platform datalogging information in corresponding preset time period, From described datalogging information, extract second feature parameter information write the second information table;Wherein, Described second feature parameter information includes: the second platform data service identification, described second platform number The the first platform data service identification associated according to service identification, interaction data character numerical value, and, Second data processing state mark;
Extraction module, for extracting second feature parameter information in described second information table one by one, depends on Fisrt feature parameter letter corresponding in described first information table is extracted according to described second feature parameter information Breath;
Judge module, is used for judging in described fisrt feature parameter information and second feature parameter information Corresponding interaction data character numerical value is the most consistent;
More new module, if right in described fisrt feature parameter information and second feature parameter information The interaction data character numerical value answered is consistent, then be updated to clear by described first data processing state mark Calculate completion status, described second data processing state mark is updated to comparison completion status;
And, if corresponding mutual in described fisrt feature parameter information and second feature parameter information Data characteristics numerical value is inconsistent, then be updated to clear comparison by described second data processing state mark State, and extract fisrt feature parameter information and/or the second feature parameter information write the 3rd of correspondence Information table.
13. systems as claimed in claim 12, described extraction module includes:
Marker extraction submodule, is used for extracting the second platform described in described second feature parameter information First platform data service identification of data service mark association;
Parameter searches submodule, is used for according to described first platform data service identification described first Information table extracts the fisrt feature parameter information of correspondence.
14. systems as claimed in claim 12, wherein,
Described more new module is additionally operable in described first information table and the second information table the mutual of correspondence When data characteristics numerical value is consistent, extract corresponding fisrt feature parameter information and/or second feature parameter Information write the 4th information table.
15. systems as claimed in claim 12, also include type of error in described 3rd information table; Described system also includes:
Type more new module, for extracting described first letter according to described second feature parameter information When ceasing fisrt feature parameter information failure corresponding in table, update the mistake in described 3rd information table Type is the type of error that data search is failed;
And, described type more new module is additionally operable in described first information table and the second information table When corresponding interaction data character numerical value is inconsistent, update the type of error in described 3rd information table For the type of error that data are inconsistent.
16. systems as claimed in claim 12, described 3rd information table also includes processing type, Described process type includes that untreated type and process complete type;Described system also includes:
Traversal processing module, being used for traveling through described 3rd information table to processing type is untreated data Record processes one by one, and updating data processing type after processing is completed is that process completes type.
17. systems as claimed in claim 12, described multi-platform also include the first of intercommunication Platform and the 3rd platform;Described system also includes:
Described acquisition module is additionally operable to the data record obtaining the 3rd platform in corresponding preset time period Information, extracts third feature parameter information write the 5th information table from described datalogging information; Wherein, described third feature parameter information includes: the 3rd platform data service identification, the described 3rd First platform data service identification of platform data service identification association, interaction data character numerical value, And, the 3rd data processing state mark;
Described extraction module is additionally operable to extract one by one third feature parameter letter in described 5th information table Breath, extracts fisrt feature corresponding in described first information table according to described third feature parameter information Parameter information;
Judge module is additionally operable to judge in described fisrt feature parameter information and third feature parameter information Corresponding interaction data character numerical value is the most consistent;
If described more new module is additionally operable to described fisrt feature parameter information and third feature parameter information The interaction data character numerical value of middle correspondence is consistent, then described first data processing state mark updated For clearance completion status, described 3rd data processing state mark is updated to comparison completion status;
If described more new module is additionally operable to described fisrt feature parameter information and third feature parameter information The interaction data character numerical value of middle correspondence is inconsistent, then identified more by described 3rd data processing state New for clearing comparison state, and extract fisrt feature parameter information and/or the third feature parameter of correspondence Information write the 3rd information table.
18. systems as claimed in claim 17, described extraction module includes:
Described marker extraction submodule is additionally operable to extract described in described third feature parameter information the 3rd First platform data service identification of platform data service identification association;
Described parameter extraction submodule is additionally operable to according to described first platform data service identification described First information table extracts the fisrt feature parameter information of correspondence.
19. systems as described in claim 12 or 17, wherein,
Described more new module is additionally operable in described first information table and the 5th information table the mutual of correspondence When data characteristics numerical value is consistent, extract corresponding fisrt feature parameter information and/or third feature parameter Information write the 4th information table.
20. systems as claimed in claim 17, also include:
Type more new module, for extracting described first letter according to described third feature parameter information When ceasing fisrt feature parameter information failure corresponding in table, update the mistake in described 3rd information table Type is the type of error that data search is failed;
And, described type more new module is additionally operable in described 5th information table and the second information table When corresponding interaction data character numerical value is inconsistent, update the type of error in described 3rd information table For the type of error that data are inconsistent.
21. systems as claimed in claim 18, described 3rd information table also includes processing type, Described process type includes that untreated type and process complete type;Described system also includes:
Traversal processing module, being used for traveling through described 3rd information table to processing type is untreated data Record processes one by one, and updating data processing type after processing is completed is that process completes type.
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 CN103345487A (en) 2013-10-09
CN103345487B true 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)

Families Citing this family (19)

* 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
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
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
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
CN107885504B (en) * 2017-12-12 2021-01-12 北京四方继保自动化股份有限公司 Heterogeneous multi-platform system control logic consistency checking method
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, device and computer equipment for detecting quality of platform information dissemination
CN110111093A (en) * 2019-05-15 2019-08-09 深圳云免电子商务有限公司 A kind of online trading method, system and computer readable storage medium
CN110912766B (en) * 2019-10-18 2021-04-20 国家计算机网络与信息安全管理中心 Communication network multi-plane data consistency checking method
CN110737815A (en) * 2019-10-21 2020-01-31 广东多谷网络科技有限公司 network inquiry validity checking method and device
CN110990414B (en) * 2019-10-31 2023-06-16 口碑(上海)信息技术有限公司 Data processing method and device
CN111400187B (en) * 2020-03-19 2023-03-14 重庆富民银行股份有限公司 Parameter dynamic verification system and method based on customized data source
CN114679300B (en) * 2022-02-28 2023-10-13 福思(杭州)智能科技有限公司 Data verification method and device, electronic equipment and storage medium

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102970205A (en) * 2012-12-07 2013-03-13 四川长虹电器股份有限公司 Cross-platform data interaction method based on virtual private network (VPN)

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6553086B1 (en) * 1998-10-02 2003-04-22 Lg Electronics, Inc. Method and apparatus for recording time information for digital data streams

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102970205A (en) * 2012-12-07 2013-03-13 四川长虹电器股份有限公司 Cross-platform data interaction method based on virtual private network (VPN)

Also Published As

Publication number Publication date
CN103345487A (en) 2013-10-09

Similar Documents

Publication Publication Date Title
CN103345487B (en) A kind of multi-platform between the method and system of consistency verification of data
CN103391311B (en) A kind of multi-platform between the method and system of consistency verification of data
CN103605703B (en) It is a kind of it is multi-platform between data consistency detection method and system
CN103577571B (en) A data processing method and device
US8554670B1 (en) Systems and methods for crediting missed location-based electronic check-ins in a social network
US10915907B2 (en) Methods and systems for generating a transaction lifecycle output for a payment card transaction
AU2017370938B2 (en) Payment and invoice systems integration
Ou et al. Technical opinion Why eBay lost to TaoBao in China: the Glocal advantage
CN109313760A (en) System and method for position data verifying
CN105930259B (en) A kind of method and apparatus of WEB regression tests
JP2013514582A (en) Updating IP address database based on transaction information
CN109416801A (en) System and method for mapping invalidated data using verified data
US11379814B2 (en) Method and system for supporting promotion of use of digital local currency
KR101435615B1 (en) System and method for managing the real estate trust
TW201822089A (en) Method and device for detecting fund transaction route in electronic payment process
CN111815364A (en) Express industry information processing method, device and system
JP2015125455A (en) Credit management system using exchange detail information and method
KR20130017845A (en) The system which supports a win-win cooperation between the enterprise based on the currency of a account receivable
CN106920124A (en) A kind of Data acquisition and issuance method and device
US20140081833A1 (en) Systems and methods of monetizing debt
CN108320129A (en) A kind of test data automation building method and device
US20180232820A1 (en) Systems and methods for computing authenticity scores
JP5931836B2 (en) System and method for managing electronic record receivable information relating to financial services
US10417616B2 (en) Real-time data processing
CN108990424A (en) Banking system and the method executed by banking system

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
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20161228