CN109656934A - Source oracle database DDL synchronous method and equipment based on log parsing - Google Patents
Source oracle database DDL synchronous method and equipment based on log parsing Download PDFInfo
- Publication number
- CN109656934A CN109656934A CN201811377371.6A CN201811377371A CN109656934A CN 109656934 A CN109656934 A CN 109656934A CN 201811377371 A CN201811377371 A CN 201811377371A CN 109656934 A CN109656934 A CN 109656934A
- Authority
- CN
- China
- Prior art keywords
- ddl
- database
- oracle
- log
- source
- 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
- 238000000034 method Methods 0.000 title claims abstract description 32
- 230000001360 synchronised effect Effects 0.000 title claims abstract description 13
- 238000013507 mapping Methods 0.000 claims description 20
- 238000004891 communication Methods 0.000 claims description 8
- 230000006870 function Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000008094 contradictory effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (8)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811377371.6A CN109656934B (en) | 2018-11-19 | 2018-11-19 | Source Oracle database DDL synchronization method and device based on log analysis |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811377371.6A CN109656934B (en) | 2018-11-19 | 2018-11-19 | Source Oracle database DDL synchronization method and device based on log analysis |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109656934A true CN109656934A (en) | 2019-04-19 |
CN109656934B CN109656934B (en) | 2020-10-27 |
Family
ID=66111286
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811377371.6A Active CN109656934B (en) | 2018-11-19 | 2018-11-19 | Source Oracle database DDL synchronization method and device based on log analysis |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109656934B (en) |
Cited By (25)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110083617A (en) * | 2019-05-05 | 2019-08-02 | 上海达梦数据库有限公司 | A kind of processing method, device, electronic equipment and the medium of DDL sentence |
CN110222119A (en) * | 2019-05-23 | 2019-09-10 | 武汉达梦数据库有限公司 | A kind of data conversion synchronous method, equipment and the storage medium of heterogeneous database |
CN110457181A (en) * | 2019-08-02 | 2019-11-15 | 武汉达梦数据库有限公司 | A kind of the log method for optimization analysis and device of database |
CN110515913A (en) * | 2019-08-02 | 2019-11-29 | 北京互金新融科技有限公司 | Log processing method and device |
CN110727548A (en) * | 2019-09-29 | 2020-01-24 | 上海英方软件股份有限公司 | Continuous data protection method and device based on database DML synchronization |
CN110784352A (en) * | 2019-10-30 | 2020-02-11 | 国网山东省电力公司信息通信公司 | Data synchronous monitoring and alarming method and device based on Oracle golden gate |
CN110990482A (en) * | 2019-11-11 | 2020-04-10 | 中国建设银行股份有限公司 | Data synchronization method and device between asynchronous databases |
CN111221909A (en) * | 2019-12-31 | 2020-06-02 | 武汉达梦数据库有限公司 | Database modification column synchronization method and device based on log analysis |
CN111241094A (en) * | 2019-12-31 | 2020-06-05 | 武汉达梦数据库有限公司 | Database deleted column synchronization method and device based on log analysis |
CN111241193A (en) * | 2019-12-31 | 2020-06-05 | 武汉达梦数据库有限公司 | Database added column synchronization method and device based on log analysis |
CN111444278A (en) * | 2020-04-01 | 2020-07-24 | Oppo(重庆)智能科技有限公司 | Data synchronization method and device and transfer server |
CN111694799A (en) * | 2020-04-30 | 2020-09-22 | 武汉达梦数据库有限公司 | Parallel log analysis method and data synchronization system based on log analysis synchronization |
CN111858744A (en) * | 2019-04-29 | 2020-10-30 | 北京嘀嘀无限科技发展有限公司 | Database data synchronization method, server and system |
CN111858505A (en) * | 2020-06-04 | 2020-10-30 | 武汉达梦数据库有限公司 | Parallel execution method and data synchronization system based on log analysis synchronization |
CN112000646A (en) * | 2020-08-25 | 2020-11-27 | 北京浪潮数据技术有限公司 | Database initialization method and device, electronic equipment and storage medium |
CN112162989A (en) * | 2020-09-24 | 2021-01-01 | 北京人大金仓信息技术股份有限公司 | Database data consistency detection method, device, medium and electronic equipment |
CN112231407A (en) * | 2020-10-22 | 2021-01-15 | 北京人大金仓信息技术股份有限公司 | DDL synchronization method, device, equipment and medium of PostgreSQL database |
CN112433992A (en) * | 2020-11-16 | 2021-03-02 | 武汉船舶通信研究所(中国船舶重工集团公司第七二二研究所) | Data synchronization log optimization method |
CN112612859A (en) * | 2020-12-31 | 2021-04-06 | 上海英方软件股份有限公司 | DDL analysis method and device based on log analysis |
CN112966025A (en) * | 2021-03-17 | 2021-06-15 | 焦点科技股份有限公司 | Binlog log mining dictionary implementation method |
CN113282605A (en) * | 2021-04-14 | 2021-08-20 | 上海瀚之友信息技术服务有限公司 | Real-time synchronization system and method for heterogeneous database |
CN114661821A (en) * | 2022-03-25 | 2022-06-24 | 北京海量数据技术股份有限公司 | Real-time synchronization method and system for Oracle and Opengauss bidirectional data |
CN116804994A (en) * | 2023-08-23 | 2023-09-26 | 北京逐风科技有限公司 | Data synchronization method, system, device, electronic equipment and storage medium |
CN117331963A (en) * | 2023-11-28 | 2024-01-02 | 恒生电子股份有限公司 | Data access processing method and device, electronic equipment and storage medium |
CN118069743A (en) * | 2024-02-23 | 2024-05-24 | 成都虚谷伟业科技有限公司 | Method, equipment and medium for synchronizing data and structures of different databases in real time |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102752372A (en) * | 2012-06-18 | 2012-10-24 | 天津神舟通用数据技术有限公司 | File based database synchronization method |
CN103617176A (en) * | 2013-11-04 | 2014-03-05 | 广东电子工业研究院有限公司 | Method for achieving automatic synchronization of multi-source heterogeneous data resources |
CN105005618A (en) * | 2015-07-21 | 2015-10-28 | 杭州合众数据技术有限公司 | Data synchronization method and system among heterogeneous databases |
US20150347401A1 (en) * | 2014-05-29 | 2015-12-03 | Oracle International Corporation | Moving data between partitions |
-
2018
- 2018-11-19 CN CN201811377371.6A patent/CN109656934B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102752372A (en) * | 2012-06-18 | 2012-10-24 | 天津神舟通用数据技术有限公司 | File based database synchronization method |
CN103617176A (en) * | 2013-11-04 | 2014-03-05 | 广东电子工业研究院有限公司 | Method for achieving automatic synchronization of multi-source heterogeneous data resources |
US20150347401A1 (en) * | 2014-05-29 | 2015-12-03 | Oracle International Corporation | Moving data between partitions |
CN105005618A (en) * | 2015-07-21 | 2015-10-28 | 杭州合众数据技术有限公司 | Data synchronization method and system among heterogeneous databases |
Non-Patent Citations (1)
Title |
---|
刘传尧: "基于日志解析的Oracle远程数据库同步方法研究及实现", 《中国优秀硕士学位论文全文数据库》 * |
Cited By (42)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111858744A (en) * | 2019-04-29 | 2020-10-30 | 北京嘀嘀无限科技发展有限公司 | Database data synchronization method, server and system |
CN110083617B (en) * | 2019-05-05 | 2021-06-01 | 上海达梦数据库有限公司 | DDL statement processing method and device, electronic device and medium |
CN110083617A (en) * | 2019-05-05 | 2019-08-02 | 上海达梦数据库有限公司 | A kind of processing method, device, electronic equipment and the medium of DDL sentence |
CN110222119B (en) * | 2019-05-23 | 2021-08-31 | 武汉达梦数据库股份有限公司 | Data conversion synchronization method, equipment and storage medium for heterogeneous database |
CN110222119A (en) * | 2019-05-23 | 2019-09-10 | 武汉达梦数据库有限公司 | A kind of data conversion synchronous method, equipment and the storage medium of heterogeneous database |
CN110457181A (en) * | 2019-08-02 | 2019-11-15 | 武汉达梦数据库有限公司 | A kind of the log method for optimization analysis and device of database |
CN110515913A (en) * | 2019-08-02 | 2019-11-29 | 北京互金新融科技有限公司 | Log processing method and device |
CN110457181B (en) * | 2019-08-02 | 2023-05-16 | 武汉达梦数据库股份有限公司 | Log optimization analysis method and device for database |
CN110515913B (en) * | 2019-08-02 | 2022-08-09 | 北京互金新融科技有限公司 | Log processing method and device |
CN110727548A (en) * | 2019-09-29 | 2020-01-24 | 上海英方软件股份有限公司 | Continuous data protection method and device based on database DML synchronization |
CN110784352B (en) * | 2019-10-30 | 2022-04-01 | 国网山东省电力公司信息通信公司 | Data synchronous monitoring and alarming method and device based on Oracle golden gate |
CN110784352A (en) * | 2019-10-30 | 2020-02-11 | 国网山东省电力公司信息通信公司 | Data synchronous monitoring and alarming method and device based on Oracle golden gate |
CN110990482A (en) * | 2019-11-11 | 2020-04-10 | 中国建设银行股份有限公司 | Data synchronization method and device between asynchronous databases |
CN111221909B (en) * | 2019-12-31 | 2021-05-28 | 武汉达梦数据库股份有限公司 | Database modification column synchronization method and device based on log analysis |
CN111241094A (en) * | 2019-12-31 | 2020-06-05 | 武汉达梦数据库有限公司 | Database deleted column synchronization method and device based on log analysis |
CN111241193A (en) * | 2019-12-31 | 2020-06-05 | 武汉达梦数据库有限公司 | Database added column synchronization method and device based on log analysis |
CN111241193B (en) * | 2019-12-31 | 2021-04-27 | 武汉达梦数据库股份有限公司 | Database added column synchronization method and device based on log analysis |
CN111221909A (en) * | 2019-12-31 | 2020-06-02 | 武汉达梦数据库有限公司 | Database modification column synchronization method and device based on log analysis |
CN111241094B (en) * | 2019-12-31 | 2021-06-08 | 武汉达梦数据库有限公司 | Database deleted column synchronization method and device based on log analysis |
CN111444278B (en) * | 2020-04-01 | 2023-08-29 | Oppo(重庆)智能科技有限公司 | Data synchronization method and device and transfer server |
CN111444278A (en) * | 2020-04-01 | 2020-07-24 | Oppo(重庆)智能科技有限公司 | Data synchronization method and device and transfer server |
CN111694799B (en) * | 2020-04-30 | 2023-04-25 | 武汉达梦数据库股份有限公司 | Parallel log analysis method and data synchronization system based on log analysis synchronization |
CN111694799A (en) * | 2020-04-30 | 2020-09-22 | 武汉达梦数据库有限公司 | Parallel log analysis method and data synchronization system based on log analysis synchronization |
CN111858505A (en) * | 2020-06-04 | 2020-10-30 | 武汉达梦数据库有限公司 | Parallel execution method and data synchronization system based on log analysis synchronization |
CN111858505B (en) * | 2020-06-04 | 2024-04-16 | 武汉达梦数据库股份有限公司 | Parallel execution method and data synchronization system based on log analysis synchronization |
CN112000646B (en) * | 2020-08-25 | 2022-08-02 | 北京浪潮数据技术有限公司 | Database initialization method and device, electronic equipment and storage medium |
CN112000646A (en) * | 2020-08-25 | 2020-11-27 | 北京浪潮数据技术有限公司 | Database initialization method and device, electronic equipment and storage medium |
CN112162989B (en) * | 2020-09-24 | 2023-09-15 | 北京人大金仓信息技术股份有限公司 | Database data consistency detection method and device, medium and electronic equipment |
CN112162989A (en) * | 2020-09-24 | 2021-01-01 | 北京人大金仓信息技术股份有限公司 | Database data consistency detection method, device, medium and electronic equipment |
CN112231407B (en) * | 2020-10-22 | 2023-09-15 | 北京人大金仓信息技术股份有限公司 | DDL synchronization method, device, equipment and medium of PostgreSQL database |
CN112231407A (en) * | 2020-10-22 | 2021-01-15 | 北京人大金仓信息技术股份有限公司 | DDL synchronization method, device, equipment and medium of PostgreSQL database |
CN112433992A (en) * | 2020-11-16 | 2021-03-02 | 武汉船舶通信研究所(中国船舶重工集团公司第七二二研究所) | Data synchronization log optimization method |
CN112612859A (en) * | 2020-12-31 | 2021-04-06 | 上海英方软件股份有限公司 | DDL analysis method and device based on log analysis |
CN112966025B (en) * | 2021-03-17 | 2022-07-19 | 焦点科技股份有限公司 | Binlog log mining dictionary implementation method |
CN112966025A (en) * | 2021-03-17 | 2021-06-15 | 焦点科技股份有限公司 | Binlog log mining dictionary implementation method |
CN113282605A (en) * | 2021-04-14 | 2021-08-20 | 上海瀚之友信息技术服务有限公司 | Real-time synchronization system and method for heterogeneous database |
CN114661821A (en) * | 2022-03-25 | 2022-06-24 | 北京海量数据技术股份有限公司 | Real-time synchronization method and system for Oracle and Opengauss bidirectional data |
CN116804994A (en) * | 2023-08-23 | 2023-09-26 | 北京逐风科技有限公司 | Data synchronization method, system, device, electronic equipment and storage medium |
CN116804994B (en) * | 2023-08-23 | 2023-11-14 | 北京逐风科技有限公司 | Data synchronization method, system, device, electronic equipment and storage medium |
CN117331963A (en) * | 2023-11-28 | 2024-01-02 | 恒生电子股份有限公司 | Data access processing method and device, electronic equipment and storage medium |
CN117331963B (en) * | 2023-11-28 | 2024-03-08 | 恒生电子股份有限公司 | Data access processing method and device, electronic equipment and storage medium |
CN118069743A (en) * | 2024-02-23 | 2024-05-24 | 成都虚谷伟业科技有限公司 | Method, equipment and medium for synchronizing data and structures of different databases in real time |
Also Published As
Publication number | Publication date |
---|---|
CN109656934B (en) | 2020-10-27 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109656934B (en) | Source Oracle database DDL synchronization method and device based on log analysis | |
CN109034993B (en) | Account checking method, account checking equipment, account checking system and computer readable storage medium | |
CN109739894B (en) | Method, device, equipment and storage medium for supplementing metadata description | |
US20170344433A1 (en) | Apparatus and method for data migration | |
CN107220142B (en) | Method and device for executing data recovery operation | |
CN110569214B (en) | Index construction method and device for log file and electronic equipment | |
CN110908997A (en) | Data blood margin construction method and device, server and readable storage medium | |
CN111324610A (en) | Data synchronization method and device | |
CN109634970B (en) | Table data synchronization method, apparatus, storage medium and device | |
CN110543513B (en) | Incremental data synchronization method, equipment and storage medium for distributed database | |
CN110232093A (en) | Initialization stowage and equipment in database synchronization based on flashback query | |
CN110716739B (en) | Code change information statistical method, system and readable storage medium | |
CN109062592B (en) | Game numerical value synchronization method and system | |
CN114490554A (en) | Data synchronization method and device, electronic equipment and storage medium | |
CN105574026A (en) | Method and device for service supporting by using non-relational database | |
CN108108478B (en) | Data format conversion method and system and electronic equipment | |
CN109271448A (en) | It is the data synchronous system and method for platform based on database | |
CN111625528B (en) | Verification method and device for configuration management database and readable storage medium | |
CN106959989A (en) | The synchronous method and device in master/slave data storehouse | |
CN111026736B (en) | Data blood margin management method and device and data blood margin analysis method and device | |
CN111176901B (en) | HDFS deleted file recovery method, terminal device and storage medium | |
CN110196786B (en) | Method and equipment for controlling memory in database rollback synchronization | |
US20120317073A1 (en) | Replication Support for Procedures with Arguments of Unsupported Types | |
CN115658815A (en) | CDC (control data center) -based data synchronization method | |
CN106469086B (en) | Event processing method and device |
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: Sun Feng Inventor after: Fu Quan Inventor after: Chen Yan Inventor before: Sun Feng Inventor before: Fu Quan Inventor before: Chen Yan 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: 20220902 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: 20230728 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 |