CN109271452B - Db2数据库数据同步更新方法及设备 - Google Patents
Db2数据库数据同步更新方法及设备 Download PDFInfo
- Publication number
- CN109271452B CN109271452B CN201811219296.0A CN201811219296A CN109271452B CN 109271452 B CN109271452 B CN 109271452B CN 201811219296 A CN201811219296 A CN 201811219296A CN 109271452 B CN109271452 B CN 109271452B
- Authority
- CN
- China
- Prior art keywords
- database
- data
- source
- target
- lsn
- 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.)
- Active
Links
- 230000001360 synchronised effect Effects 0.000 title claims abstract description 59
- 238000000034 method Methods 0.000 title claims abstract description 41
- 230000008859 change Effects 0.000 claims abstract description 18
- 238000004891 communication Methods 0.000 claims description 8
- 238000012217 deletion Methods 0.000 claims description 8
- 230000037430 deletion Effects 0.000 claims description 8
- 230000000977 initiatory effect Effects 0.000 claims description 3
- 239000000126 substance Substances 0.000 claims 1
- 230000002411 adverse Effects 0.000 abstract description 5
- 230000000694 effects Effects 0.000 abstract description 5
- 230000008569 process Effects 0.000 description 7
- 238000004458 analytical method Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000007246 mechanism Effects 0.000 description 3
- 230000010076 replication Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000008094 contradictory effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Abstract
Description
Claims (7)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811219296.0A CN109271452B (zh) | 2018-10-19 | 2018-10-19 | Db2数据库数据同步更新方法及设备 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811219296.0A CN109271452B (zh) | 2018-10-19 | 2018-10-19 | Db2数据库数据同步更新方法及设备 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109271452A CN109271452A (zh) | 2019-01-25 |
CN109271452B true CN109271452B (zh) | 2021-04-13 |
Family
ID=65193510
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811219296.0A Active CN109271452B (zh) | 2018-10-19 | 2018-10-19 | Db2数据库数据同步更新方法及设备 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109271452B (zh) |
Families Citing this family (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109977168B (zh) * | 2019-03-18 | 2021-11-05 | 武汉达梦数据库股份有限公司 | 基于数据页预加载的数据库数据同步方法及设备 |
CN110222115A (zh) * | 2019-04-30 | 2019-09-10 | 武汉达梦数据库有限公司 | 基于表初始化分组装载的数据库同步方法及设备 |
CN110196859A (zh) * | 2019-06-10 | 2019-09-03 | 天津神舟通用数据技术有限公司 | 基于jdbc分发器的数据库读写分离集群实时一致性方法 |
CN110502523A (zh) * | 2019-08-01 | 2019-11-26 | 广东浪潮大数据研究有限公司 | 业务数据存储方法、装置、服务器及计算机可读存储介质 |
CN111782869B (zh) * | 2020-07-08 | 2022-02-18 | 珠海大横琴科技发展有限公司 | 视频大数据事件库构建方法、装置及计算机设备 |
CN113190281B (zh) * | 2021-04-08 | 2022-05-17 | 武汉达梦数据库股份有限公司 | 一种基于rowid区间的初始化装载方法与装置 |
CN113590716B (zh) * | 2021-08-09 | 2022-06-10 | 深圳市携客互联科技有限公司 | 基于erp系统集成接口业务数据自动同步方法 |
CN113722396B (zh) * | 2021-08-25 | 2023-12-22 | 武汉达梦数据库股份有限公司 | 一种数据同步接收端服务主备切换的方法及设备 |
Family Cites Families (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN100368998C (zh) * | 2004-07-23 | 2008-02-13 | 中兴通讯股份有限公司 | 一种多数据库数据同步方法 |
CN101183377B (zh) * | 2007-12-10 | 2010-09-08 | 华中科技大学 | 一种基于消息中间件的高可用性数据库集群系统 |
CN104750720B (zh) * | 2013-12-30 | 2018-04-27 | 中国银联股份有限公司 | 多线程并发访问环境下高性能数据处理的实现 |
CN106155839B (zh) * | 2015-04-28 | 2019-07-30 | 阿里巴巴集团控股有限公司 | 一种用于备份数据的方法与设备 |
CN105589961B (zh) * | 2015-12-21 | 2019-02-19 | 武汉达梦数据库有限公司 | 一种数据库实时同步系统数据一致性的检测方法及系统 |
CN108182291A (zh) * | 2018-01-30 | 2018-06-19 | 国网江苏省电力有限公司扬州供电分公司 | 一种基于NoSql数据库同关系型数据库的数据交互机制 |
-
2018
- 2018-10-19 CN CN201811219296.0A patent/CN109271452B/zh active Active
Also Published As
Publication number | Publication date |
---|---|
CN109271452A (zh) | 2019-01-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109271452B (zh) | Db2数据库数据同步更新方法及设备 | |
CN109656934B (zh) | 基于日志解析的源端Oracle数据库DDL同步方法及设备 | |
CN105630863B (zh) | 用于多版本并发提交状态的事务控制块 | |
CN110209735B (zh) | 数据库备份方法、数据库备份装置、计算设备和存储介质 | |
CN108536752B (zh) | 一种数据同步方法、装置和设备 | |
TWI521363B (zh) | Method, device and system for implementing incremental data extraction | |
CN110232093B (zh) | 数据库同步中基于闪回查询的初始化装载方法及设备 | |
JP6521402B2 (ja) | KeyValueデータベースのデータテーブルを更新するための方法およびテーブルデータを更新するための装置 | |
CN108121827B (zh) | 一种全量数据的同步方法及装置 | |
US11347933B1 (en) | Distributed collaborative storage with operational transformation | |
CN108205560B (zh) | 一种数据同步方法以及装置 | |
CN109977168B (zh) | 基于数据页预加载的数据库数据同步方法及设备 | |
CN111414362B (zh) | 数据读取方法、装置、设备及存储介质 | |
CN110008284B (zh) | 基于数据页预加载及回滚的数据库数据同步方法及设备 | |
CN115730008A (zh) | 一种日志解析方法、数据同步系统、电子设备及存储介质 | |
US8935294B2 (en) | Minimizing computer resource usage when converting data types of a table column | |
US20090307279A1 (en) | Refresh and filter anchors | |
CN111352766A (zh) | 一种数据库的双活实现方法及装置 | |
CN110196786B (zh) | 数据库回滚同步中内存的控制方法及设备 | |
US8818947B2 (en) | Landscape transformation replication server | |
CN115658815A (zh) | 基于cdc实现的数据同步的方法 | |
CN116069859A (zh) | 数据库的增量数据同步方法、存储介质与计算机设备 | |
CN111966650B (zh) | 一种运维大数据共享数据表的处理方法、装置及存储介质 | |
CN111241193B (zh) | 一种基于日志解析的数据库添加列同步方法和装置 | |
CN114741453A (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 | ||
CB03 | Change of inventor or designer information |
Inventor after: Fu Quan Inventor after: Sun Feng Inventor after: Zhao Jiawei Inventor before: Fu Quan Inventor before: Sun Feng Inventor before: Zhao Jiawei Inventor before: Yang Chun |
|
CB03 | Change of inventor or designer information | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CB03 | Change of inventor or designer information |
Inventor after: Sun Feng Inventor after: Zhao Jiawei Inventor before: Fu Quan Inventor before: Sun Feng Inventor before: Zhao Jiawei |
|
CB03 | Change of inventor or designer information | ||
CP03 | Change of name, title or address |
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: 430014 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 DAMENG DATABASE Co.,Ltd. |
|
CP03 | Change of name, title or address | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220913 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 |
|
TR01 | Transfer of patent right |