CN110222119B - 一种异构数据库的数据转换同步方法、设备及存储介质 - Google Patents
一种异构数据库的数据转换同步方法、设备及存储介质 Download PDFInfo
- Publication number
- CN110222119B CN110222119B CN201910436427.9A CN201910436427A CN110222119B CN 110222119 B CN110222119 B CN 110222119B CN 201910436427 A CN201910436427 A CN 201910436427A CN 110222119 B CN110222119 B CN 110222119B
- Authority
- CN
- China
- Prior art keywords
- data conversion
- data
- operation table
- message packet
- log message
- 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
- 238000006243 chemical reaction Methods 0.000 title claims abstract description 188
- 238000000034 method Methods 0.000 title claims abstract description 56
- 238000003860 storage Methods 0.000 title claims abstract description 19
- 238000012545 processing Methods 0.000 claims abstract description 123
- 230000006870 function Effects 0.000 claims description 26
- 238000013501 data transformation Methods 0.000 claims description 7
- 238000004891 communication Methods 0.000 claims description 6
- 238000004458 analytical method Methods 0.000 abstract description 8
- 238000004519 manufacturing process Methods 0.000 abstract description 8
- 238000012795 verification Methods 0.000 abstract 1
- 230000008569 process Effects 0.000 description 6
- 230000001360 synchronised effect Effects 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000007246 mechanism Effects 0.000 description 3
- 238000011084 recovery Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 238000012790 confirmation Methods 0.000 description 2
- 238000013075 data extraction Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000013500 data storage Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
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/25—Integrating or interfacing systems involving database management systems
-
- 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)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (8)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910436427.9A CN110222119B (zh) | 2019-05-23 | 2019-05-23 | 一种异构数据库的数据转换同步方法、设备及存储介质 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910436427.9A CN110222119B (zh) | 2019-05-23 | 2019-05-23 | 一种异构数据库的数据转换同步方法、设备及存储介质 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110222119A CN110222119A (zh) | 2019-09-10 |
CN110222119B true CN110222119B (zh) | 2021-08-31 |
Family
ID=67818053
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910436427.9A Active CN110222119B (zh) | 2019-05-23 | 2019-05-23 | 一种异构数据库的数据转换同步方法、设备及存储介质 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110222119B (zh) |
Families Citing this family (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111177239B (zh) * | 2019-12-13 | 2023-10-10 | 航天信息股份有限公司 | 一种基于hdp大数据集群的统一日志处理方法及系统 |
CN111159020B (zh) * | 2019-12-20 | 2021-11-05 | 武汉达梦数据库股份有限公司 | 一种应用于同步软件测试的方法和装置 |
CN111654498B (zh) * | 2020-06-03 | 2022-11-22 | 深圳市信锐网科技术有限公司 | 设备添加方法及物联网平台 |
CN112948477A (zh) * | 2021-03-31 | 2021-06-11 | 北京金山云网络技术有限公司 | 数据下档方法和装置、电子设备和存储介质 |
CN117763051B (zh) * | 2024-02-22 | 2024-04-26 | 广州睿帆科技有限公司 | 一种可扩展的cdc方式达梦数据库同步系统及其应用 |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102346775A (zh) * | 2011-09-26 | 2012-02-08 | 苏州博远容天信息科技有限公司 | 一种基于日志的异构多源数据库同步方法 |
CN102915377A (zh) * | 2012-11-14 | 2013-02-06 | 深圳市宏电技术股份有限公司 | 数据库转换或同步方法及系统 |
CN105205117A (zh) * | 2015-09-09 | 2015-12-30 | 郑州悉知信息科技股份有限公司 | 一种数据表迁移方法和装置 |
CN107357848A (zh) * | 2017-06-27 | 2017-11-17 | 中国电子科技集团公司第二十八研究所 | 基于驱动封装的数据库同步方法 |
CN108399256A (zh) * | 2018-03-06 | 2018-08-14 | 北京慧萌信安软件技术有限公司 | 异构数据库内容同步方法、装置及中间件 |
CN109271448A (zh) * | 2018-09-25 | 2019-01-25 | 武汉达梦数据库有限公司 | 基于数据库为平台的数据同步系统及方法 |
CN109656934A (zh) * | 2018-11-19 | 2019-04-19 | 武汉达梦数据库有限公司 | 基于日志解析的源端Oracle数据库DDL同步方法及设备 |
Family Cites Families (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9043765B2 (en) * | 2011-11-09 | 2015-05-26 | Microsoft Technology Licensing, Llc | Simultaneously targeting multiple homogeneous and heterogeneous runtime environments |
CN102508919B (zh) * | 2011-11-18 | 2014-10-29 | 从兴技术有限公司 | 数据处理方法及系统 |
CN103051729A (zh) * | 2013-01-14 | 2013-04-17 | 南京轨道交通系统工程有限公司 | 一种异构数据同步实现方法 |
-
2019
- 2019-05-23 CN CN201910436427.9A patent/CN110222119B/zh active Active
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102346775A (zh) * | 2011-09-26 | 2012-02-08 | 苏州博远容天信息科技有限公司 | 一种基于日志的异构多源数据库同步方法 |
CN102915377A (zh) * | 2012-11-14 | 2013-02-06 | 深圳市宏电技术股份有限公司 | 数据库转换或同步方法及系统 |
CN105205117A (zh) * | 2015-09-09 | 2015-12-30 | 郑州悉知信息科技股份有限公司 | 一种数据表迁移方法和装置 |
CN107357848A (zh) * | 2017-06-27 | 2017-11-17 | 中国电子科技集团公司第二十八研究所 | 基于驱动封装的数据库同步方法 |
CN108399256A (zh) * | 2018-03-06 | 2018-08-14 | 北京慧萌信安软件技术有限公司 | 异构数据库内容同步方法、装置及中间件 |
CN109271448A (zh) * | 2018-09-25 | 2019-01-25 | 武汉达梦数据库有限公司 | 基于数据库为平台的数据同步系统及方法 |
CN109656934A (zh) * | 2018-11-19 | 2019-04-19 | 武汉达梦数据库有限公司 | 基于日志解析的源端Oracle数据库DDL同步方法及设备 |
Also Published As
Publication number | Publication date |
---|---|
CN110222119A (zh) | 2019-09-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110222119B (zh) | 一种异构数据库的数据转换同步方法、设备及存储介质 | |
CN112463144B (zh) | 分布式存储的命令行服务方法、系统、终端及存储介质 | |
CN107171825B (zh) | 一种终端的重复日志过滤方法 | |
CN109951547B (zh) | 事务请求并行处理方法、装置、设备和介质 | |
CN108446171B (zh) | 电子装置、分布式系统执行任务分配方法及存储介质 | |
CN110427422B (zh) | 数据同步异常时数据一致性校验方法、设备及存储介质 | |
US20180150530A1 (en) | Method, Apparatus, Computing Device and Storage Medium for Analyzing and Processing Data | |
CN113590386B (zh) | 数据的容灾恢复方法、系统、终端设备及计算机存储介质 | |
CN104182683A (zh) | 一种联机事务的监控方法、装置及系统 | |
CN110222117A (zh) | 一种异构数据库的数据转换同步方法、设备及存储介质 | |
CN115794437A (zh) | 微服务的调用方法、装置、计算机设备及存储介质 | |
CN116248526A (zh) | 部署容器平台的方法、装置及电子设备 | |
CN112511636B (zh) | 数据传输系统、方法、装置、计算机设备及存储介质 | |
CN115203304A (zh) | 一种基于定时轮询的批量数据导入方法及相关设备 | |
CN114615325A (zh) | 消息推送方法、装置、计算机设备及存储介质 | |
CN113779117A (zh) | 一种数据监控方法、装置、存储介质和电子设备 | |
CN116302847B (zh) | 异常信息的动态采集方法、装置、计算机设备及介质 | |
CN112181900B (zh) | 一种服务器集群中的数据处理方法与装置 | |
US10303531B2 (en) | Console application through web service | |
US20150039750A1 (en) | Method of linking to and monitoring machining devices through a cloud service | |
CN117056052A (zh) | 一种定时任务处理方法、装置、设备及其存储介质 | |
CN117938619A (zh) | 异常节点处理方法、系统、计算设备及存储介质 | |
CN115914257A (zh) | 基于联邦学习的状态交互方法、系统、设备及存储介质 | |
CN115422012A (zh) | 一种数据处理方法、装置、电子设备及计算机可读介质 | |
CN111596896A (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 | ||
CB02 | Change of applicant information | ||
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: 430000 16-19 / F, building C3, future technology building, 999 Gaoxin Avenue, Donghu New Technology Development Zone, Wuhan, Hubei Province Applicant before: WUHAN DAMENG DATABASE Co.,Ltd. |
|
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 |
|
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220909 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 | ||
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 |