CN109508346A - 一种ddl操作的级联同步控制方法及系统 - Google Patents
一种ddl操作的级联同步控制方法及系统 Download PDFInfo
- Publication number
- CN109508346A CN109508346A CN201811219313.0A CN201811219313A CN109508346A CN 109508346 A CN109508346 A CN 109508346A CN 201811219313 A CN201811219313 A CN 201811219313A CN 109508346 A CN109508346 A CN 109508346A
- Authority
- CN
- China
- Prior art keywords
- ddl
- synchronous
- cascade
- sql statement
- cascade data
- 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 claims abstract description 107
- 239000000284 extract Substances 0.000 claims abstract description 5
- 238000004458 analytical method Methods 0.000 claims description 23
- 238000000034 method Methods 0.000 claims description 12
- 238000004590 computer program Methods 0.000 claims description 3
- 230000005540 biological transmission Effects 0.000 abstract 1
- 230000000694 effects Effects 0.000 description 2
- 238000003780 insertion Methods 0.000 description 2
- 230000037431 insertion Effects 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 239000002253 acid Substances 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 239000003550 marker Substances 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000007363 ring formation reaction Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
Description
Claims (7)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811219313.0A CN109508346B (zh) | 2018-10-19 | 2018-10-19 | 一种ddl操作的级联同步控制方法及系统 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811219313.0A CN109508346B (zh) | 2018-10-19 | 2018-10-19 | 一种ddl操作的级联同步控制方法及系统 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109508346A true CN109508346A (zh) | 2019-03-22 |
CN109508346B CN109508346B (zh) | 2021-02-02 |
Family
ID=65746832
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811219313.0A Active CN109508346B (zh) | 2018-10-19 | 2018-10-19 | 一种ddl操作的级联同步控制方法及系统 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109508346B (zh) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111782721A (zh) * | 2020-05-09 | 2020-10-16 | 宁波小遛共享信息科技有限公司 | 一种数据同步方法、装置、电子设备及存储介质 |
CN111858504A (zh) * | 2020-06-04 | 2020-10-30 | 武汉达梦数据库有限公司 | 基于日志解析同步的操作合并执行方法和数据同步系统 |
CN112035463A (zh) * | 2020-07-22 | 2020-12-04 | 武汉达梦数据库有限公司 | 基于日志解析的异构数据库的双向同步方法和同步装置 |
CN112559626A (zh) * | 2020-12-11 | 2021-03-26 | 武汉达梦数据库股份有限公司 | 一种基于日志解析的ddl操作的同步方法和同步系统 |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104376062A (zh) * | 2014-11-11 | 2015-02-25 | 中国有色金属长沙勘察设计研究院有限公司 | 一种异构数据库平台数据的同步方法 |
US20180246948A1 (en) * | 2017-02-28 | 2018-08-30 | Sap Se | Replay of Redo Log Records in Persistency or Main Memory of Database Systems |
-
2018
- 2018-10-19 CN CN201811219313.0A patent/CN109508346B/zh active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104376062A (zh) * | 2014-11-11 | 2015-02-25 | 中国有色金属长沙勘察设计研究院有限公司 | 一种异构数据库平台数据的同步方法 |
US20180246948A1 (en) * | 2017-02-28 | 2018-08-30 | Sap Se | Replay of Redo Log Records in Persistency or Main Memory of Database Systems |
Non-Patent Citations (1)
Title |
---|
李永祥: "利用GoldenGate实现灾备", 《基础设施与数据管理》 * |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111782721A (zh) * | 2020-05-09 | 2020-10-16 | 宁波小遛共享信息科技有限公司 | 一种数据同步方法、装置、电子设备及存储介质 |
CN111782721B (zh) * | 2020-05-09 | 2024-03-01 | 浙江小遛信息科技有限公司 | 一种数据同步方法、装置、电子设备及存储介质 |
CN111858504A (zh) * | 2020-06-04 | 2020-10-30 | 武汉达梦数据库有限公司 | 基于日志解析同步的操作合并执行方法和数据同步系统 |
CN111858504B (zh) * | 2020-06-04 | 2023-12-12 | 武汉达梦数据库股份有限公司 | 基于日志解析同步的操作合并执行方法和数据同步系统 |
CN112035463A (zh) * | 2020-07-22 | 2020-12-04 | 武汉达梦数据库有限公司 | 基于日志解析的异构数据库的双向同步方法和同步装置 |
CN112559626A (zh) * | 2020-12-11 | 2021-03-26 | 武汉达梦数据库股份有限公司 | 一种基于日志解析的ddl操作的同步方法和同步系统 |
CN112559626B (zh) * | 2020-12-11 | 2022-06-21 | 武汉达梦数据库股份有限公司 | 一种基于日志解析的ddl操作的同步方法和同步系统 |
Also Published As
Publication number | Publication date |
---|---|
CN109508346B (zh) | 2021-02-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109508346A (zh) | 一种ddl操作的级联同步控制方法及系统 | |
CN109656934B (zh) | 基于日志解析的源端Oracle数据库DDL同步方法及设备 | |
CN110908997B (zh) | 数据血缘构建方法、装置、服务器及可读存储介质 | |
CN110347746B (zh) | 一种异构数据库同步数据一致性校验方法及装置 | |
CN109460349B (zh) | 一种基于日志的测试用例生成方法和装置 | |
CN105095319B (zh) | 基于时间序列化的文档的标识、关联、搜索及展现的系统 | |
CN110222114B (zh) | 数据库中数据双向同步的方法及设备 | |
US20180004781A1 (en) | Data lineage analysis | |
CN107544984A (zh) | 一种数据处理的方法和装置 | |
CN103824053A (zh) | 一种人脸图像的性别标注方法及人脸性别检测方法 | |
CN109299073A (zh) | 一种数据血缘的生成方法、系统、电子设备和存储介质 | |
CN106843840A (zh) | 一种基于相似度分析的源代码版本演化注释复用方法 | |
CN106209431A (zh) | 一种告警关联方法及网管系统 | |
Leno et al. | Automated discovery of data transformations for robotic process automation | |
CN113204598B (zh) | 一种数据同步方法、系统及存储介质 | |
CN107423390A (zh) | 一种基于oltp‑olap混合关系型数据库系统内部的数据实时同步算法 | |
CN113204465A (zh) | 一种基于执行跟踪的微服务提取方法 | |
CN111694799B (zh) | 基于日志解析同步的并行日志解析方法和数据同步系统 | |
CN110334326A (zh) | 一种识别配方文件并转化为xml文件的方法及系统 | |
CN115858513A (zh) | 数据治理方法、装置、计算机设备和存储介质 | |
CN114780370A (zh) | 基于日志的数据修正方法、装置、电子设备及存储介质 | |
CN105095436A (zh) | 数据源数据自动建模方法 | |
CN112416944A (zh) | 一种同步业务数据的方法和设备 | |
CN116932649A (zh) | 数据库同步方法、数据库同步设备以及可读存储介质 | |
CN117076742A (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 | ||
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 |
|
CB02 | Change of applicant information |
Address after: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Applicant 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 Applicant before: WUHAN DAMENG DATABASE Co.,Ltd. |
|
CB02 | Change of applicant information | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220907 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: 20230726 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 |