CN105574187A - Duplication transaction consistency guaranteeing method and system for heterogeneous databases - Google Patents
Duplication transaction consistency guaranteeing method and system for heterogeneous databases Download PDFInfo
- Publication number
- CN105574187A CN105574187A CN201510976842.5A CN201510976842A CN105574187A CN 105574187 A CN105574187 A CN 105574187A CN 201510976842 A CN201510976842 A CN 201510976842A CN 105574187 A CN105574187 A CN 105574187A
- Authority
- CN
- China
- Prior art keywords
- transaction
- affairs
- destination
- submit
- transaction table
- 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
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/10—File systems; File servers
- G06F16/18—File system types
- G06F16/182—Distributed file systems
- G06F16/184—Distributed file systems implemented as replicated file system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/1734—Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (5)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510976842.5A CN105574187B (en) | 2015-12-23 | 2015-12-23 | A kind of Heterogeneous Database Replication transaction consistency support method and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510976842.5A CN105574187B (en) | 2015-12-23 | 2015-12-23 | A kind of Heterogeneous Database Replication transaction consistency support method and system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN105574187A true CN105574187A (en) | 2016-05-11 |
CN105574187B CN105574187B (en) | 2019-02-19 |
Family
ID=55884318
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510976842.5A Active CN105574187B (en) | 2015-12-23 | 2015-12-23 | A kind of Heterogeneous Database Replication transaction consistency support method and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105574187B (en) |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106777270A (en) * | 2016-12-28 | 2017-05-31 | 中国民航信息网络股份有限公司 | A kind of Heterogeneous Database Replication parallel execution system and method based on submission point time line locking |
CN107016075A (en) * | 2017-03-27 | 2017-08-04 | 聚好看科技股份有限公司 | Company-data synchronous method and device |
CN107391306A (en) * | 2017-07-27 | 2017-11-24 | 国家电网公司 | A kind of isomeric data library backup file access pattern method |
CN109189608A (en) * | 2018-08-13 | 2019-01-11 | 武汉达梦数据库有限公司 | A kind of method guaranteeing duplication transaction consistency and corresponding reproducing unit |
CN109408480A (en) * | 2018-09-29 | 2019-03-01 | 武汉达梦数据库有限公司 | The method and system read based on ORACLE multinode RAC log based on SCN alignment |
CN110300964A (en) * | 2017-05-24 | 2019-10-01 | 北京科蓝软件系统股份有限公司 | Database copy method and database replication system |
CN110457284A (en) * | 2019-06-05 | 2019-11-15 | 黄疆 | More time point data restoration methods and system based on SQLServer database |
CN110851528A (en) * | 2019-10-09 | 2020-02-28 | 网联清算有限公司 | Database synchronization method and device, storage medium and computer equipment |
CN111241094A (en) * | 2019-12-31 | 2020-06-05 | 武汉达梦数据库有限公司 | Database deleted column synchronization method and device based on log analysis |
CN111694800A (en) * | 2020-04-30 | 2020-09-22 | 武汉达梦数据库有限公司 | Method for improving data synchronization performance and data synchronization system |
CN112307118A (en) * | 2020-09-30 | 2021-02-02 | 武汉达梦数据库有限公司 | Method for guaranteeing data consistency based on log analysis synchronization and synchronization system |
CN112966047A (en) * | 2021-03-05 | 2021-06-15 | 浪潮云信息技术股份公司 | Method for realizing table copying function based on distributed database |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1784677A (en) * | 2004-03-31 | 2006-06-07 | 微软公司 | System and method for a consistency check of a database backup |
US20080046480A1 (en) * | 2003-12-15 | 2008-02-21 | At&T Knowledge Ventures, L.P. | Architecture of database application with robust online recoverability |
CN103198159A (en) * | 2013-04-27 | 2013-07-10 | 国家计算机网络与信息安全管理中心 | Transaction-redo-based multi-copy consistency maintaining method for heterogeneous clusters |
CN104216955A (en) * | 2014-08-20 | 2014-12-17 | 百度在线网络技术(北京)有限公司 | Methods and devices for operating data and managing events and distributed system |
-
2015
- 2015-12-23 CN CN201510976842.5A patent/CN105574187B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080046480A1 (en) * | 2003-12-15 | 2008-02-21 | At&T Knowledge Ventures, L.P. | Architecture of database application with robust online recoverability |
CN1784677A (en) * | 2004-03-31 | 2006-06-07 | 微软公司 | System and method for a consistency check of a database backup |
CN103198159A (en) * | 2013-04-27 | 2013-07-10 | 国家计算机网络与信息安全管理中心 | Transaction-redo-based multi-copy consistency maintaining method for heterogeneous clusters |
CN104216955A (en) * | 2014-08-20 | 2014-12-17 | 百度在线网络技术(北京)有限公司 | Methods and devices for operating data and managing events and distributed system |
Cited By (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106777270A (en) * | 2016-12-28 | 2017-05-31 | 中国民航信息网络股份有限公司 | A kind of Heterogeneous Database Replication parallel execution system and method based on submission point time line locking |
CN107016075A (en) * | 2017-03-27 | 2017-08-04 | 聚好看科技股份有限公司 | Company-data synchronous method and device |
CN110300964B (en) * | 2017-05-24 | 2022-11-08 | 北京科蓝软件系统股份有限公司 | Database replication method and database replication system |
CN110300964A (en) * | 2017-05-24 | 2019-10-01 | 北京科蓝软件系统股份有限公司 | Database copy method and database replication system |
CN107391306A (en) * | 2017-07-27 | 2017-11-24 | 国家电网公司 | A kind of isomeric data library backup file access pattern method |
CN109189608A (en) * | 2018-08-13 | 2019-01-11 | 武汉达梦数据库有限公司 | A kind of method guaranteeing duplication transaction consistency and corresponding reproducing unit |
CN109189608B (en) * | 2018-08-13 | 2019-07-26 | 武汉达梦数据库有限公司 | A kind of method guaranteeing duplication transaction consistency and corresponding reproducing unit |
CN110262929A (en) * | 2018-08-13 | 2019-09-20 | 武汉达梦数据库有限公司 | A kind of method guaranteeing duplication transaction consistency and corresponding reproducing unit |
CN110262929B (en) * | 2018-08-13 | 2020-01-07 | 武汉达梦数据库有限公司 | Method for ensuring consistency of copying affairs and corresponding copying device |
CN109408480A (en) * | 2018-09-29 | 2019-03-01 | 武汉达梦数据库有限公司 | The method and system read based on ORACLE multinode RAC log based on SCN alignment |
CN110457284A (en) * | 2019-06-05 | 2019-11-15 | 黄疆 | More time point data restoration methods and system based on SQLServer database |
CN110457284B (en) * | 2019-06-05 | 2022-11-29 | 黄疆 | Multi-time point data recovery method and system based on SQLServer database |
CN110851528A (en) * | 2019-10-09 | 2020-02-28 | 网联清算有限公司 | Database synchronization method and device, storage medium and computer equipment |
CN110851528B (en) * | 2019-10-09 | 2022-09-02 | 网联清算有限公司 | Database synchronization method and device, storage medium and computer equipment |
CN111241094B (en) * | 2019-12-31 | 2021-06-08 | 武汉达梦数据库有限公司 | Database deleted 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 |
CN111694800A (en) * | 2020-04-30 | 2020-09-22 | 武汉达梦数据库有限公司 | Method for improving data synchronization performance and data synchronization system |
CN111694800B (en) * | 2020-04-30 | 2023-03-24 | 武汉达梦数据库股份有限公司 | Method for improving data synchronization performance and data synchronization system |
CN112307118A (en) * | 2020-09-30 | 2021-02-02 | 武汉达梦数据库有限公司 | Method for guaranteeing data consistency based on log analysis synchronization and synchronization system |
CN112307118B (en) * | 2020-09-30 | 2024-03-22 | 武汉达梦数据库股份有限公司 | Method for guaranteeing data consistency based on log analysis synchronization and synchronization system |
CN112966047A (en) * | 2021-03-05 | 2021-06-15 | 浪潮云信息技术股份公司 | Method for realizing table copying function based on distributed database |
Also Published As
Publication number | Publication date |
---|---|
CN105574187B (en) | 2019-02-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105574187A (en) | Duplication transaction consistency guaranteeing method and system for heterogeneous databases | |
US7330859B2 (en) | Database backup system using data and user-defined routines replicators for maintaining a copy of database on a secondary server | |
CN101334797B (en) | Distributed file systems and its data block consistency managing method | |
KR101662212B1 (en) | Database Management System providing partial synchronization and method for partial synchronization thereof | |
CN102891849B (en) | Service data synchronization method, data recovery method, data recovery device and network device | |
US8898112B1 (en) | Write signature command | |
US9515878B2 (en) | Method, medium, and system for configuring a new node in a distributed memory network | |
US20150213100A1 (en) | Data synchronization method and system | |
US9672244B2 (en) | Efficient undo-processing during data redistribution | |
CN109542682B (en) | Data backup method, device, equipment and storage medium | |
CN111078667B (en) | Data migration method and related device | |
JP2012069168A (en) | Geographically distributed cluster | |
CN113239013B (en) | Distributed system and storage medium | |
KR20080102622A (en) | Data replication method and systme for database management system | |
CN101567805A (en) | Method for recovering failed parallel file system | |
CN103197988A (en) | Data backup and recovery method, device and database system | |
CN107229540A (en) | A kind of database restoring method and system based on time point | |
US20230315713A1 (en) | Operation request processing method, apparatus, device, readable storage medium, and system | |
CN102708166B (en) | Data replication method, data recovery method and data recovery device | |
CN110196788B (en) | Data reading method, device and system and storage medium | |
CN104991739A (en) | Method and system for refining primary execution semantics during metadata server failure substitution | |
US8918364B1 (en) | Online mirror state transitioning in databases | |
US20240281546A1 (en) | Continuous Data Protection System and Method for Modern Applications | |
CN114490570A (en) | Production data synchronization method and device, data synchronization system and server | |
CN117171266B (en) | Data synchronization method, device, equipment and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP03 | Change of name, title or address |
Address after: 430073 16-19 / F, building C3, future science and technology building, 999 Gaoxin Avenue, Wuhan East Lake New Technology Development Zone, Wuhan City, Hubei Province Patentee after: Wuhan dream database Co.,Ltd. Address before: 430073 5th floor, building C6, optical valley software park, special 1, Guanshan 1st Road, Donghu Development Zone, Wuhan City, Hubei Province Patentee before: WUHAN DAMENG DATABASE Co.,Ltd. |
|
CP03 | Change of name, title or address | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220905 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: 430073 16-19 / F, building C3, future science and technology building, 999 Gaoxin Avenue, Wuhan East Lake New Technology Development Zone, Wuhan City, Hubei Province Patentee before: Wuhan dream database Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20230731 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 |