CN110427422A - 数据同步异常时数据一致性校验方法、设备及存储介质 - Google Patents
数据同步异常时数据一致性校验方法、设备及存储介质 Download PDFInfo
- Publication number
- CN110427422A CN110427422A CN201910436428.3A CN201910436428A CN110427422A CN 110427422 A CN110427422 A CN 110427422A CN 201910436428 A CN201910436428 A CN 201910436428A CN 110427422 A CN110427422 A CN 110427422A
- Authority
- CN
- China
- Prior art keywords
- affairs
- error
- data
- supplementary table
- transaction
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 230000001360 synchronised effect Effects 0.000 title claims abstract description 183
- 238000000034 method Methods 0.000 title claims abstract description 73
- 230000005856 abnormality Effects 0.000 title claims abstract description 57
- 238000012795 verification Methods 0.000 title claims abstract description 33
- 238000003780 insertion Methods 0.000 claims abstract description 41
- 230000037431 insertion Effects 0.000 claims abstract description 41
- 230000008859 change Effects 0.000 claims abstract description 32
- 230000008569 process Effects 0.000 claims abstract description 27
- 238000012545 processing Methods 0.000 claims description 17
- 238000013524 data verification Methods 0.000 claims description 15
- 230000006399 behavior Effects 0.000 claims description 14
- 230000002159 abnormal effect Effects 0.000 claims description 13
- 238000004891 communication Methods 0.000 claims description 6
- 238000006243 chemical reaction Methods 0.000 description 5
- 238000009434 installation Methods 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 230000009471 action Effects 0.000 description 2
- 238000012790 confirmation Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000002955 isolation Methods 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 238000003672 processing method Methods 0.000 description 2
- 239000002253 acid Substances 0.000 description 1
- 230000004888 barrier function Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Hardware Redundancy (AREA)
Abstract
Description
字段名 | 字段类型 | 字段说明 |
TRXID | NUMBER | 登记数据同步过程中执行过的事务ID |
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910436428.3A CN110427422B (zh) | 2019-05-23 | 2019-05-23 | 数据同步异常时数据一致性校验方法、设备及存储介质 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910436428.3A CN110427422B (zh) | 2019-05-23 | 2019-05-23 | 数据同步异常时数据一致性校验方法、设备及存储介质 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110427422A true CN110427422A (zh) | 2019-11-08 |
CN110427422B CN110427422B (zh) | 2020-10-30 |
Family
ID=68407549
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910436428.3A Active CN110427422B (zh) | 2019-05-23 | 2019-05-23 | 数据同步异常时数据一致性校验方法、设备及存储介质 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110427422B (zh) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111221800A (zh) * | 2019-12-19 | 2020-06-02 | 中国平安人寿保险股份有限公司 | 数据库迁移方法、装置、电子设备及存储介质 |
CN111367705A (zh) * | 2020-03-31 | 2020-07-03 | 中国工商银行股份有限公司 | 一种sql报错的处理方法及装置 |
CN111737331A (zh) * | 2020-06-22 | 2020-10-02 | 中国银行股份有限公司 | 一种数据库与对象存储的事务一致性处理方法及*** |
CN112307118A (zh) * | 2020-09-30 | 2021-02-02 | 武汉达梦数据库有限公司 | 基于日志解析同步的保障数据一致性的方法和同步*** |
CN113282393A (zh) * | 2021-06-04 | 2021-08-20 | 银盛支付服务股份有限公司 | 一种解决面向多个画像标签作业调度任务的方法 |
CN113761056A (zh) * | 2021-04-07 | 2021-12-07 | 西安京迅递供应链科技有限公司 | 一种分布式业务的处理方法、装置及*** |
Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105338093A (zh) * | 2015-11-16 | 2016-02-17 | 中国建设银行股份有限公司 | 一种数据同步方法和*** |
US20160147859A1 (en) * | 2014-11-25 | 2016-05-26 | Juchang Lee | Transactional and Parallel Log Replay for Asynchronous Table Replication |
US9436752B2 (en) * | 2003-10-02 | 2016-09-06 | Progress Software Corporation | High availability via data services |
CN106484807A (zh) * | 2016-09-23 | 2017-03-08 | 北京许继电气有限公司 | 构建自主可控数据库双活或多活集群架构的方法和*** |
CN106775959A (zh) * | 2016-12-06 | 2017-05-31 | 上海亿账通互联网科技有限公司 | 分布式事务处理方法和*** |
CN109241185A (zh) * | 2018-08-27 | 2019-01-18 | 武汉达梦数据库有限公司 | 一种数据同步的方法以及数据同步装置 |
CN109634970A (zh) * | 2018-10-19 | 2019-04-16 | 平安科技(深圳)有限公司 | 表数据同步方法、设备、存储介质及装置 |
CN109657007A (zh) * | 2018-12-17 | 2019-04-19 | 武汉达梦数据库有限公司 | 基于异步提交的数据库数据同步并行执行方法及设备 |
-
2019
- 2019-05-23 CN CN201910436428.3A patent/CN110427422B/zh active Active
Patent Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9436752B2 (en) * | 2003-10-02 | 2016-09-06 | Progress Software Corporation | High availability via data services |
US20160147859A1 (en) * | 2014-11-25 | 2016-05-26 | Juchang Lee | Transactional and Parallel Log Replay for Asynchronous Table Replication |
CN105338093A (zh) * | 2015-11-16 | 2016-02-17 | 中国建设银行股份有限公司 | 一种数据同步方法和*** |
CN106484807A (zh) * | 2016-09-23 | 2017-03-08 | 北京许继电气有限公司 | 构建自主可控数据库双活或多活集群架构的方法和*** |
CN106775959A (zh) * | 2016-12-06 | 2017-05-31 | 上海亿账通互联网科技有限公司 | 分布式事务处理方法和*** |
CN109241185A (zh) * | 2018-08-27 | 2019-01-18 | 武汉达梦数据库有限公司 | 一种数据同步的方法以及数据同步装置 |
CN109634970A (zh) * | 2018-10-19 | 2019-04-16 | 平安科技(深圳)有限公司 | 表数据同步方法、设备、存储介质及装置 |
CN109657007A (zh) * | 2018-12-17 | 2019-04-19 | 武汉达梦数据库有限公司 | 基于异步提交的数据库数据同步并行执行方法及设备 |
Non-Patent Citations (4)
Title |
---|
SUBHASH BHALLA ET AL.: ""Synchronization and Recovery in an Embedded Database System for Read-Only Transactions"", 《INTERNATIONAL CONFERENCE ON EMBEDDED AND UBIQUITOUS COMPUTING》 * |
刘娟娟 等: ""数据库同步技术的研究与实现"", 《软件工程》 * |
吴雅娟 等: ""基于操作日志的完井数据同步模型"", 《计算机***应用》 * |
钟容 等: ""基于事务日志的数据同步模型研究"", 《科技创新与应用》 * |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111221800A (zh) * | 2019-12-19 | 2020-06-02 | 中国平安人寿保险股份有限公司 | 数据库迁移方法、装置、电子设备及存储介质 |
CN111367705A (zh) * | 2020-03-31 | 2020-07-03 | 中国工商银行股份有限公司 | 一种sql报错的处理方法及装置 |
CN111367705B (zh) * | 2020-03-31 | 2023-08-04 | 中国工商银行股份有限公司 | 一种sql报错的处理方法及装置 |
CN111737331A (zh) * | 2020-06-22 | 2020-10-02 | 中国银行股份有限公司 | 一种数据库与对象存储的事务一致性处理方法及*** |
CN111737331B (zh) * | 2020-06-22 | 2023-08-18 | 中国银行股份有限公司 | 一种数据库与对象存储的事务一致性处理方法及*** |
CN112307118A (zh) * | 2020-09-30 | 2021-02-02 | 武汉达梦数据库有限公司 | 基于日志解析同步的保障数据一致性的方法和同步*** |
CN112307118B (zh) * | 2020-09-30 | 2024-03-22 | 武汉达梦数据库股份有限公司 | 基于日志解析同步的保障数据一致性的方法和同步*** |
CN113761056A (zh) * | 2021-04-07 | 2021-12-07 | 西安京迅递供应链科技有限公司 | 一种分布式业务的处理方法、装置及*** |
CN113282393A (zh) * | 2021-06-04 | 2021-08-20 | 银盛支付服务股份有限公司 | 一种解决面向多个画像标签作业调度任务的方法 |
Also Published As
Publication number | Publication date |
---|---|
CN110427422B (zh) | 2020-10-30 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110427422A (zh) | 数据同步异常时数据一致性校验方法、设备及存储介质 | |
CN109542639B (zh) | 一种保障微服务调用数据一致性的处理方法、处理装置 | |
US9286368B2 (en) | Linking framework for information technology management | |
CN109582731A (zh) | 一种数据实时同步方法及*** | |
CN104809202A (zh) | 一种数据库同步的方法和装置 | |
CN104809201A (zh) | 一种数据库同步的方法和装置 | |
US20150317175A1 (en) | Virtual machine synchronization system | |
CN111400104B (zh) | 数据同步方法及装置、电子设备、存储介质 | |
CN111026735B (zh) | 一种数据传输方法、装置、设备及介质 | |
EP2696297B1 (en) | System and method for generating information file based on parallel processing | |
CN110222119A (zh) | 一种异构数据库的数据转换同步方法、设备及存储介质 | |
CN110222117A (zh) | 一种异构数据库的数据转换同步方法、设备及存储介质 | |
CN115185787B (zh) | 处理事务日志的方法及装置 | |
CN113468143A (zh) | 数据迁移方法、***、计算设备及存储介质 | |
US20080178182A1 (en) | Work state returning apparatus, work state returning method, and computer product | |
CN112261114A (zh) | 一种数据备份***及方法 | |
WO2019196227A1 (zh) | 平台整合的方法、装置、计算机设备和存储介质 | |
US20070130146A1 (en) | Method and system for managing data | |
CN111090648B (zh) | 一种关系型数据库数据同步冲突解决方法 | |
CN114612101A (zh) | 面向连接的可靠链间路由跨链方法及*** | |
CN112800060B (zh) | 数据处理方法、装置、计算机可读存储介质及电子设备 | |
CN117763052B (zh) | 面向计费多中心内存数据库的数据同步方法及*** | |
CN103312728B (zh) | 一种存储***间的数据同步方法、***和装置 | |
CN115470031A (zh) | 一种异常事件冲正方法、装置、设备及介质 | |
CN117453825A (zh) | 数据同步方法、装置、介质和存储设备 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP01 | Change in the name or title of a patent holder |
Address after: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Patentee after: Wuhan dream database Co.,Ltd. Address before: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Patentee before: WUHAN DAMENG DATABASE Co.,Ltd. |
|
CP01 | Change in the name or title of a patent holder | ||
CB03 | Change of inventor or designer information | ||
CB03 | Change of inventor or designer information |
Inventor after: Sun Feng Inventor after: Yu Yuanlan Inventor after: Zhao Jiawei Inventor before: Fu Quan Inventor before: Sun Feng Inventor before: Yu Yuanlan Inventor before: Zhao Jiawei |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220914 Address after: 430073 16-19 / F, building C3, future science and technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan City, Hubei Province Patentee after: Wuhan dream database Co.,Ltd. Patentee after: HUAZHONG University OF SCIENCE AND TECHNOLOGY Address before: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Patentee before: Wuhan dream database Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20230725 Address after: 16-19/F, Building C3, Future Science and Technology Building, No. 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan City, Hubei Province, 430206 Patentee after: Wuhan dream database Co.,Ltd. Address before: 430073 16-19 / F, building C3, future science and technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan City, Hubei Province Patentee before: Wuhan dream database Co.,Ltd. Patentee before: HUAZHONG University OF SCIENCE AND TECHNOLOGY |