CN109614443B - 针对v9.7版本db2数据库的ddl同步方法及设备 - Google Patents
针对v9.7版本db2数据库的ddl同步方法及设备 Download PDFInfo
- Publication number
- CN109614443B CN109614443B CN201811312253.7A CN201811312253A CN109614443B CN 109614443 B CN109614443 B CN 109614443B CN 201811312253 A CN201811312253 A CN 201811312253A CN 109614443 B CN109614443 B CN 109614443B
- Authority
- CN
- China
- Prior art keywords
- ddl
- database
- auxiliary table
- operation information
- synchronization
- 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
- 238000000034 method Methods 0.000 title claims abstract description 73
- 238000013481 data capture Methods 0.000 claims abstract description 51
- 230000008569 process Effects 0.000 claims abstract description 28
- 230000008859 change Effects 0.000 claims description 16
- 239000000284 extract Substances 0.000 claims description 15
- 230000006870 function Effects 0.000 claims description 12
- 238000004891 communication Methods 0.000 claims description 8
- 238000000605 extraction Methods 0.000 claims description 4
- 238000013515 script Methods 0.000 claims description 4
- 239000000126 substance Substances 0.000 claims 1
- 238000012360 testing method Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000008094 contradictory effect Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000010076 replication Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (8)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811312253.7A CN109614443B (zh) | 2018-11-06 | 2018-11-06 | 针对v9.7版本db2数据库的ddl同步方法及设备 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811312253.7A CN109614443B (zh) | 2018-11-06 | 2018-11-06 | 针对v9.7版本db2数据库的ddl同步方法及设备 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109614443A CN109614443A (zh) | 2019-04-12 |
CN109614443B true CN109614443B (zh) | 2021-04-13 |
Family
ID=66002266
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811312253.7A Active CN109614443B (zh) | 2018-11-06 | 2018-11-06 | 针对v9.7版本db2数据库的ddl同步方法及设备 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109614443B (zh) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111241094B (zh) * | 2019-12-31 | 2021-06-08 | 武汉达梦数据库有限公司 | 一种基于日志解析的数据库删除列同步方法和装置 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2014101207A1 (en) * | 2012-12-31 | 2014-07-03 | Sybase, Inc. | Continuous change data capture without disruption of ddl |
CN106446166A (zh) * | 2016-09-23 | 2017-02-22 | 郑州云海信息技术有限公司 | 数据从db2数据库迁移到k‑db数据库的方法和装置 |
CN108460163A (zh) * | 2018-04-13 | 2018-08-28 | 郑州云海信息技术有限公司 | K-db数据库数据同步方法、装置、设备及存储介质 |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9880815B2 (en) * | 2013-01-22 | 2018-01-30 | Aptitude Software Limited | SQL visualizer |
CN103092970A (zh) * | 2013-01-24 | 2013-05-08 | 华为技术有限公司 | 一种数据库操作方法及设备 |
CN105426373B (zh) * | 2014-09-19 | 2019-06-07 | 阿里巴巴集团控股有限公司 | 一种数据库同步方法与设备 |
CN106326376A (zh) * | 2016-08-15 | 2017-01-11 | 东软集团股份有限公司 | 用于表结构变更后的信息复制方法和装置 |
-
2018
- 2018-11-06 CN CN201811312253.7A patent/CN109614443B/zh active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2014101207A1 (en) * | 2012-12-31 | 2014-07-03 | Sybase, Inc. | Continuous change data capture without disruption of ddl |
CN106446166A (zh) * | 2016-09-23 | 2017-02-22 | 郑州云海信息技术有限公司 | 数据从db2数据库迁移到k‑db数据库的方法和装置 |
CN108460163A (zh) * | 2018-04-13 | 2018-08-28 | 郑州云海信息技术有限公司 | K-db数据库数据同步方法、装置、设备及存储介质 |
Non-Patent Citations (2)
Title |
---|
使用SQLServer 2008的CDC功能实现数据变更捕获;發糞塗牆;《https://blog.csdn.net/dba_huangzj/java/article/details/8130448》;20121030;背景、详解、案例、日常使用情景 * |
元仓库与源数据库的元数据同步策略的研究与设计;叶国权 等;《现代电子技术》;20100901(第17期);正文第1-2节,图1-4 * |
Also Published As
Publication number | Publication date |
---|---|
CN109614443A (zh) | 2019-04-12 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109656934B (zh) | 基于日志解析的源端Oracle数据库DDL同步方法及设备 | |
CN109933630B (zh) | 数据库数据实时同步方法及设备 | |
CN109034993B (zh) | 对账方法、设备、系统及计算机可读存储介质 | |
CN110908997B (zh) | 数据血缘构建方法、装置、服务器及可读存储介质 | |
CN102737020B (zh) | 一种初始化多租户数据库的方法和装置 | |
KR20190060725A (ko) | Sql 검토 방법, 장치, 서버 및 저장 매체 | |
CN110569214B (zh) | 用于日志文件的索引构建方法、装置及电子设备 | |
CN106919612B (zh) | 一种上线结构化查询语言脚本的处理方法及装置 | |
CN104391881A (zh) | 一种基于分词算法的日志解析方法及系统 | |
CN111177779B (zh) | 数据库审计方法、其装置、电子设备及计算机存储介质 | |
CN110222114B (zh) | 数据库中数据双向同步的方法及设备 | |
CN111737227B (zh) | 数据修改方法及系统 | |
CN112231407B (zh) | PostgreSQL数据库的DDL同步方法、装置、设备和介质 | |
CN111046100A (zh) | 一种关系型数据库到非关系型数据库的同步方法和系统 | |
CN108255837A (zh) | 一种sql解析器及方法 | |
CN103716394A (zh) | 下载文件的管理方法及装置 | |
CN113282555A (zh) | 一种数据处理方法、装置、设备及存储介质 | |
CN109614443B (zh) | 针对v9.7版本db2数据库的ddl同步方法及设备 | |
CN114490554A (zh) | 数据同步方法及其装置、电子设备及存储介质 | |
Riadi et al. | A study of mobile forensic tools evaluation on android-based LINE messenger | |
CN111563131A (zh) | 数据库实体关系生成方法、装置、计算机设备和存储介质 | |
CN108694172B (zh) | 信息输出方法和装置 | |
US20200285630A1 (en) | Systems and methods for application data transaction auditing | |
CN107862016A (zh) | 一种专题页面的配置方法 | |
CN111753141B (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 | ||
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 | ||
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: 20230802 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 |