CN111221907B - 一种基于日志解析的数据库添加列同步方法和装置 - Google Patents
一种基于日志解析的数据库添加列同步方法和装置 Download PDFInfo
- Publication number
- CN111221907B CN111221907B CN201911413264.9A CN201911413264A CN111221907B CN 111221907 B CN111221907 B CN 111221907B CN 201911413264 A CN201911413264 A CN 201911413264A CN 111221907 B CN111221907 B CN 111221907B
- Authority
- CN
- China
- Prior art keywords
- database
- log
- column
- synchronization
- destination
- 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 61
- 238000004458 analytical method Methods 0.000 title claims abstract description 9
- 230000001360 synchronised effect Effects 0.000 claims abstract description 20
- 238000003780 insertion Methods 0.000 claims abstract description 16
- 230000037431 insertion Effects 0.000 claims abstract description 16
- 230000008569 process Effects 0.000 claims description 18
- 230000015654 memory Effects 0.000 claims description 15
- 239000000284 extract Substances 0.000 claims description 6
- 238000013507 mapping Methods 0.000 claims description 4
- 230000004048 modification Effects 0.000 description 11
- 238000012986 modification Methods 0.000 description 11
- 238000003860 storage Methods 0.000 description 5
- 230000006872 improvement Effects 0.000 description 3
- 230000007246 mechanism Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000005096 rolling process Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
-
- 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/23—Updating
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911413264.9A CN111221907B (zh) | 2019-12-31 | 2019-12-31 | 一种基于日志解析的数据库添加列同步方法和装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911413264.9A CN111221907B (zh) | 2019-12-31 | 2019-12-31 | 一种基于日志解析的数据库添加列同步方法和装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN111221907A CN111221907A (zh) | 2020-06-02 |
CN111221907B true CN111221907B (zh) | 2021-03-30 |
Family
ID=70808175
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201911413264.9A Active CN111221907B (zh) | 2019-12-31 | 2019-12-31 | 一种基于日志解析的数据库添加列同步方法和装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111221907B (zh) |
Families Citing this family (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111858503B (zh) * | 2020-06-04 | 2023-03-28 | 武汉达梦数据库股份有限公司 | 一种基于日志解析同步的并行执行方法和数据同步系统 |
CN111858505B (zh) * | 2020-06-04 | 2024-04-16 | 武汉达梦数据库股份有限公司 | 一种基于日志解析同步的并行执行方法和数据同步系统 |
CN112765180B (zh) * | 2021-01-27 | 2023-01-17 | 上海英方软件股份有限公司 | 一种对db2数据库建表日志列名解析的方法及装置 |
CN115113989B (zh) * | 2021-11-05 | 2023-05-26 | 腾讯科技(深圳)有限公司 | 事务执行方法、装置、计算设备及存储介质 |
Family Cites Families (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9405654B2 (en) * | 2013-06-20 | 2016-08-02 | Microsoft Technology Licensing, Llc | Monitoring mobile application performance |
CN105205053A (zh) * | 2014-05-30 | 2015-12-30 | 阿里巴巴集团控股有限公司 | 一种数据库增量日志解析方法及系统 |
CN105005618A (zh) * | 2015-07-21 | 2015-10-28 | 杭州合众数据技术有限公司 | 一种异构数据库之间的数据同步方法及系统 |
EP3416354B1 (en) * | 2017-06-13 | 2020-07-15 | Tritan Software International | Method and apparatus for bi-directional communication and data replication between multiple locations during intermittent connectivity |
CN109189852B (zh) * | 2018-08-01 | 2021-05-28 | 武汉达梦数据库有限公司 | 一种数据同步的方法及用于数据同步的装置 |
CN109165263A (zh) * | 2018-10-16 | 2019-01-08 | 农信银资金清算中心有限责任公司 | 数据库的日志分析处理方法及装置、ddl同步方法及装置 |
CN109558452B (zh) * | 2018-11-19 | 2020-12-08 | 武汉达梦数据库有限公司 | 一种查询建表操作的同步方法 |
-
2019
- 2019-12-31 CN CN201911413264.9A patent/CN111221907B/zh active Active
Also Published As
Publication number | Publication date |
---|---|
CN111221907A (zh) | 2020-06-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN111221907B (zh) | 一种基于日志解析的数据库添加列同步方法和装置 | |
CN111241094B (zh) | 一种基于日志解析的数据库删除列同步方法和装置 | |
CN109241185B (zh) | 一种数据同步的方法以及数据同步装置 | |
CN110262929B (zh) | 一种保证复制事务一致性的方法以及相应的复制装置 | |
US10430298B2 (en) | Versatile in-memory database recovery using logical log records | |
US20160078044A1 (en) | Main-memory database checkpointing | |
US20170192863A1 (en) | System and method of failover recovery | |
US20150178329A1 (en) | Multiple rid spaces in a delta-store-based database to support long running transactions | |
CN107515874B (zh) | 一种分布式非关系型数据库中同步增量数据的方法与设备 | |
US11886298B2 (en) | Using a storage log to generate an incremental backup | |
CN103875229A (zh) | 异步复制方法、装置与系统 | |
CN111221909B (zh) | 一种基于日志解析的数据库修改列同步方法和装置 | |
CN111858501B (zh) | 一种基于日志解析同步的日志读取方法和数据同步系统 | |
CN111177159B (zh) | 一种数据处理的系统、方法和数据更新设备 | |
US20200034472A1 (en) | Asynchronous cache coherency for mvcc based database systems | |
CN114741453A (zh) | 数据同步的方法、系统及计算机可读存储介质 | |
US10579604B2 (en) | Database system, information processing device, method and medium | |
CN111241193B (zh) | 一种基于日志解析的数据库添加列同步方法和装置 | |
CN115309819A (zh) | 数据处理方法、装置、系统、计算机设备和存储介质 | |
US20200097581A1 (en) | Systems and methods of managing manifest refresh in a database | |
US9020905B2 (en) | Synchronizing database and non-database resources without a commit coordinator | |
US9563521B2 (en) | Data transfers between cluster instances with delayed log file flush | |
CN111858504B (zh) | 基于日志解析同步的操作合并执行方法和数据同步系统 | |
US10572503B2 (en) | Database system, information processing device, method and medium | |
CN108121514B (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: Peng Qingsong Inventor after: Yu Yuanlan Inventor before: Fu Quan Inventor before: Sun Feng Inventor before: Peng Qingsong Inventor before: Yu Yuanlan |
|
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220908 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: 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 |