CN101681383A - 用于数据库管理系统的数据复制方法及系统 - Google Patents
用于数据库管理系统的数据复制方法及系统 Download PDFInfo
- Publication number
- CN101681383A CN101681383A CN200880015777A CN200880015777A CN101681383A CN 101681383 A CN101681383 A CN 101681383A CN 200880015777 A CN200880015777 A CN 200880015777A CN 200880015777 A CN200880015777 A CN 200880015777A CN 101681383 A CN101681383 A CN 101681383A
- Authority
- CN
- China
- Prior art keywords
- replication
- log
- main frame
- master
- data base
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/40—Data acquisition and logging
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Computer Hardware Design (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (22)
Applications Claiming Priority (4)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
KR1020070049289 | 2007-05-21 | ||
KR10-2007-0049289 | 2007-05-21 | ||
KR1020070049289A KR100926880B1 (ko) | 2007-05-21 | 2007-05-21 | Dbms에서의 데이터 복제 방법 및 시스템 |
PCT/KR2008/002421 WO2008143408A1 (en) | 2007-05-21 | 2008-04-29 | Data replication method and system for database management system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN101681383A true CN101681383A (zh) | 2010-03-24 |
CN101681383B CN101681383B (zh) | 2013-02-20 |
Family
ID=40032072
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2008800157778A Active CN101681383B (zh) | 2007-05-21 | 2008-04-29 | 用于数据库管理系统的数据复制方法及系统 |
Country Status (6)
Country | Link |
---|---|
US (1) | US8874512B2 (zh) |
EP (1) | EP2150910A4 (zh) |
JP (1) | JP5178822B2 (zh) |
KR (1) | KR100926880B1 (zh) |
CN (1) | CN101681383B (zh) |
WO (1) | WO2008143408A1 (zh) |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102402585A (zh) * | 2011-10-21 | 2012-04-04 | 苏州阔地网络科技有限公司 | 一种信息传输方法、系统及移动终端 |
CN103180848A (zh) * | 2010-09-09 | 2013-06-26 | 优质生活联合服务有限公司 | 一种用于复制数据的系统和方法 |
CN103678718A (zh) * | 2013-12-31 | 2014-03-26 | 金蝶软件(中国)有限公司 | 数据库同步方法及系统 |
CN105260486A (zh) * | 2015-11-23 | 2016-01-20 | 郑州悉知信息科技股份有限公司 | 一种数据处理方法、装置及系统 |
CN106897288A (zh) * | 2015-12-18 | 2017-06-27 | 阿里巴巴集团控股有限公司 | 数据库的服务提供方法和系统 |
CN110019500A (zh) * | 2017-08-21 | 2019-07-16 | 东软集团股份有限公司 | 一种复制组状态监控方法、装置、设备及存储介质 |
CN111656340A (zh) * | 2018-07-06 | 2020-09-11 | 斯诺弗雷克公司 | 在数据库系统中的数据复制和数据故障转移 |
Families Citing this family (40)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP2261801B1 (de) * | 2009-06-12 | 2014-12-31 | Siemens Schweiz AG | Verfahren zum unterbrechungsfreien Update einer Master-Datenbank und der zugehörigen Slave-Datenbanken |
EP2323047B1 (en) * | 2009-10-09 | 2020-02-19 | Software AG | Primary database system, replication database system and method for replicating data of a primary database system |
US9558256B2 (en) * | 2010-11-16 | 2017-01-31 | Linkedin Corporation | Middleware data log system |
US9710344B1 (en) | 2010-12-13 | 2017-07-18 | Amazon Technologies, Inc. | Locality based quorum eligibility |
US8473775B1 (en) | 2010-12-14 | 2013-06-25 | Amazon Technologies, Inc. | Locality based quorums |
US8554762B1 (en) | 2010-12-28 | 2013-10-08 | Amazon Technologies, Inc. | Data replication framework |
US9449065B1 (en) * | 2010-12-28 | 2016-09-20 | Amazon Technologies, Inc. | Data replication framework |
US8468132B1 (en) | 2010-12-28 | 2013-06-18 | Amazon Technologies, Inc. | Data replication framework |
US10198492B1 (en) | 2010-12-28 | 2019-02-05 | Amazon Technologies, Inc. | Data replication framework |
KR101596559B1 (ko) * | 2011-06-03 | 2016-02-22 | 애플 인크. | 클라우드 저장소 |
US8977591B1 (en) | 2011-06-07 | 2015-03-10 | Cellco Partnership | Transitive database replication |
EP2824575A4 (en) * | 2012-08-23 | 2015-12-02 | Wingarc1St Inc | DISTRIBUTED DATABASE SYSTEM |
KR20140047230A (ko) * | 2012-10-10 | 2014-04-22 | (주)티베로 | 분산 시스템에서 분산 트랜잭션의 최적화를 위한 방법 및 트랜잭션을 최적화한 분산 시스템 |
EP2937788A4 (en) * | 2012-12-21 | 2016-06-22 | Murakumo Corp | INFORMATION PROCESSING METHOD, INFORMATION PROCESSING DEVICE, AND PROGRAM |
JP2014229088A (ja) * | 2013-05-23 | 2014-12-08 | ソニー株式会社 | データ処理システム、データ処理装置および記憶媒体 |
US9589041B2 (en) * | 2013-07-25 | 2017-03-07 | Oracle International Corporation | Client and server integration for replicating data |
US10191932B2 (en) | 2014-03-21 | 2019-01-29 | Oracle International Corporation | Dependency-aware transaction batching for data replication |
EP3125121A4 (en) | 2014-03-25 | 2017-12-06 | Murakumo Corporation | Database system, information processing device, method, and program |
EP3125123A4 (en) | 2014-03-25 | 2017-11-22 | Murakumo Corporation | Database system, information processing device, method, and program |
KR101713537B1 (ko) * | 2014-08-05 | 2017-03-09 | 네이버 주식회사 | 데이터의 일관성을 보장하는 상태기기 기반의 복제 및 체크포인트데이터와 복제로그를 이용한 분산 복구를 처리하는 데이터 복제 방법 및 데이터 저장 시스템 |
CN105843702B (zh) | 2015-01-14 | 2019-04-12 | 阿里巴巴集团控股有限公司 | 一种用于数据备份的方法以及装置 |
US9990224B2 (en) * | 2015-02-23 | 2018-06-05 | International Business Machines Corporation | Relaxing transaction serializability with statement-based data replication |
US9619210B2 (en) | 2015-05-14 | 2017-04-11 | Walleye Software, LLC | Parsing and compiling data system queries |
KR101786865B1 (ko) | 2016-05-25 | 2017-10-19 | (주)알투비솔루션 | Dbms별로 생성되는 아카이브 로그 통합 관리 시스템 |
CN106899648B (zh) * | 2016-06-20 | 2020-02-14 | 阿里巴巴集团控股有限公司 | 一种数据处理方法和设备 |
US10216582B2 (en) | 2016-08-15 | 2019-02-26 | International Business Machines Corporation | Recovery log analytics with a big data management platform |
KR101981310B1 (ko) * | 2016-12-27 | 2019-05-22 | 주식회사 씨에스리 | 데이터베이스 시스템의 이상을 탐지하는 장치 및 방법 |
KR101904786B1 (ko) | 2017-03-06 | 2018-10-08 | 주식회사 데이터스트림즈 | 소스 데이터베이스 관리시스템에서 변경되는 데이터를 실시간으로 목표 데이터베이스 관리시스템에 복제하는 장치 및 그 방법 |
US10565228B2 (en) * | 2017-03-06 | 2020-02-18 | Sap Se | Testing database replication with multi-container system architecture |
US10198469B1 (en) | 2017-08-24 | 2019-02-05 | Deephaven Data Labs Llc | Computer data system data source refreshing using an update propagation graph having a merged join listener |
KR101859094B1 (ko) * | 2017-10-11 | 2018-05-18 | (주)데이타뱅크시스템즈 | 복제 방식의 변경을 고려한 통합 복제 시스템 |
KR101826827B1 (ko) * | 2017-10-11 | 2018-02-09 | (주)데이타뱅크시스템 | 데이터베이스 간의 실시간 통합 복제 시스템 |
KR102089291B1 (ko) * | 2018-06-19 | 2020-03-16 | 주식회사 티맥스데이터 | 데이터 익스텐트 이동 방법 |
CN110209734B (zh) | 2019-05-05 | 2022-11-18 | 深圳市腾讯计算机系统有限公司 | 数据复制方法、装置、计算机设备及存储介质 |
US11544232B2 (en) | 2019-12-11 | 2023-01-03 | Western Digital Technologies, Inc. | Efficient transaction log and database processing |
US11651005B2 (en) * | 2020-05-04 | 2023-05-16 | EMC IP Holding Company LLC | Intelligent datastore determination for microservice |
CN112286892B (zh) * | 2020-07-01 | 2024-04-05 | 上海柯林布瑞信息技术有限公司 | 后关系型数据库的数据实时同步方法及装置、存储介质、终端 |
KR102336813B1 (ko) * | 2020-09-18 | 2021-12-08 | 주식회사 아미크 | 사업분할에 따라 조직 데이터를 선별적으로 분리하는 방법 및 시스템 |
KR102351220B1 (ko) * | 2021-10-08 | 2022-01-14 | 주식회사 이글루시큐리티 | 대용량 데이터 처리 시 효율적인 서버 부하 분산을 위한 db 이중화 방법 및 이를 지원하는 장치 |
US11875060B2 (en) * | 2022-04-18 | 2024-01-16 | Dell Products L.P. | Replication techniques using a replication log |
Family Cites Families (27)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5280611A (en) * | 1991-11-08 | 1994-01-18 | International Business Machines Corporation | Method for managing database recovery from failure of a shared store in a system including a plurality of transaction-based systems of the write-ahead logging type |
US5530855A (en) * | 1992-10-13 | 1996-06-25 | International Business Machines Corporation | Replicating a database by the sequential application of hierarchically sorted log records |
US5434994A (en) * | 1994-05-23 | 1995-07-18 | International Business Machines Corporation | System and method for maintaining replicated data coherency in a data processing system |
US6044381A (en) * | 1997-09-11 | 2000-03-28 | Puma Technology, Inc. | Using distributed history files in synchronizing databases |
US6202067B1 (en) | 1998-04-07 | 2001-03-13 | Lucent Technologies, Inc. | Method and apparatus for correct and complete transactions in a fault tolerant distributed database system |
JP2941779B1 (ja) * | 1998-05-07 | 1999-08-30 | 三菱電機株式会社 | 複数計算機間のデータベースレプリケーション制御方法 |
US20020073082A1 (en) * | 2000-12-12 | 2002-06-13 | Edouard Duvillier | System modification processing technique implemented on an information storage and retrieval system |
US6691139B2 (en) * | 2001-01-31 | 2004-02-10 | Hewlett-Packard Development Co., Ltd. | Recreation of archives at a disaster recovery site |
JP2002318718A (ja) | 2001-04-20 | 2002-10-31 | Nippon Telegr & Teleph Corp <Ntt> | データベースレプリケーション方法、そのプログラム及び記録媒体 |
JP2003006011A (ja) | 2001-06-22 | 2003-01-10 | Hitachi Ltd | ジャーナルマージ引継ぎ方法 |
US7647354B2 (en) | 2002-05-24 | 2010-01-12 | Oracle International Corporation | High-performance change capture for data warehousing |
US8121978B2 (en) * | 2002-11-15 | 2012-02-21 | Sybase, Inc. | Database system providing improved methods for data replication |
US7177886B2 (en) * | 2003-02-07 | 2007-02-13 | International Business Machines Corporation | Apparatus and method for coordinating logical data replication with highly available data replication |
US20040199552A1 (en) * | 2003-04-01 | 2004-10-07 | Microsoft Corporation | Transactionally consistent change tracking for databases |
US7200620B2 (en) * | 2003-09-29 | 2007-04-03 | International Business Machines Corporation | High availability data replication of smart large objects |
US7103809B2 (en) * | 2003-10-24 | 2006-09-05 | Motorola, Inc. | Server selection method |
KR100561229B1 (ko) * | 2003-12-23 | 2006-03-15 | 한국전자통신연구원 | 데이터베이스 이중화 장치 및 그 방법 |
US7600087B2 (en) * | 2004-01-15 | 2009-10-06 | Hitachi, Ltd. | Distributed remote copy system |
US7996363B2 (en) * | 2004-05-19 | 2011-08-09 | Oracle International Corporation | Real-time apply mechanism in standby database environments |
US7502796B2 (en) * | 2004-06-16 | 2009-03-10 | Solid Information Technology Oy | Arrangement and method for optimizing performance and data safety in a highly available database system |
US7529783B2 (en) * | 2004-12-22 | 2009-05-05 | International Business Machines Corporation | Log shipping data replication with parallel log writing and log shipping at the primary site |
JP4731975B2 (ja) * | 2005-04-20 | 2011-07-27 | 株式会社日立製作所 | データベース管理方法、およびストレージシステム |
US7636743B2 (en) * | 2005-12-19 | 2009-12-22 | Commvault Systems, Inc. | Pathname translation in a data replication system |
US20070174315A1 (en) * | 2006-01-18 | 2007-07-26 | Avraham Leff | Compressing state in database replication |
JP2007318277A (ja) * | 2006-05-24 | 2007-12-06 | Fujifilm Corp | データ管理システムにおけるデータバックアップ方法及び装置 |
US7624134B2 (en) * | 2006-06-12 | 2009-11-24 | International Business Machines Corporation | Enabling access to remote storage for use with a backup program |
US7870398B2 (en) * | 2007-01-25 | 2011-01-11 | International Business Machines Corporation | Integrity assurance of query result from database service provider |
-
2007
- 2007-05-21 KR KR1020070049289A patent/KR100926880B1/ko active IP Right Grant
-
2008
- 2008-04-29 EP EP08753225A patent/EP2150910A4/en not_active Withdrawn
- 2008-04-29 WO PCT/KR2008/002421 patent/WO2008143408A1/en active Application Filing
- 2008-04-29 CN CN2008800157778A patent/CN101681383B/zh active Active
- 2008-04-29 JP JP2010508289A patent/JP5178822B2/ja active Active
- 2008-04-29 US US12/600,205 patent/US8874512B2/en active Active
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103180848A (zh) * | 2010-09-09 | 2013-06-26 | 优质生活联合服务有限公司 | 一种用于复制数据的系统和方法 |
CN103180848B (zh) * | 2010-09-09 | 2017-05-17 | 优质生活联合服务有限公司 | 一种用于复制数据的系统和方法 |
CN102402585A (zh) * | 2011-10-21 | 2012-04-04 | 苏州阔地网络科技有限公司 | 一种信息传输方法、系统及移动终端 |
CN102402585B (zh) * | 2011-10-21 | 2013-04-03 | 苏州阔地网络科技有限公司 | 一种信息传输方法、系统及移动终端 |
CN103678718A (zh) * | 2013-12-31 | 2014-03-26 | 金蝶软件(中国)有限公司 | 数据库同步方法及系统 |
CN105260486A (zh) * | 2015-11-23 | 2016-01-20 | 郑州悉知信息科技股份有限公司 | 一种数据处理方法、装置及系统 |
CN106897288A (zh) * | 2015-12-18 | 2017-06-27 | 阿里巴巴集团控股有限公司 | 数据库的服务提供方法和系统 |
CN106897288B (zh) * | 2015-12-18 | 2021-01-08 | 阿里巴巴集团控股有限公司 | 数据库的服务提供方法和系统 |
CN110019500A (zh) * | 2017-08-21 | 2019-07-16 | 东软集团股份有限公司 | 一种复制组状态监控方法、装置、设备及存储介质 |
CN111656340A (zh) * | 2018-07-06 | 2020-09-11 | 斯诺弗雷克公司 | 在数据库系统中的数据复制和数据故障转移 |
CN111656340B (zh) * | 2018-07-06 | 2023-07-18 | 斯诺弗雷克公司 | 在数据库系统中的数据复制和数据故障转移 |
Also Published As
Publication number | Publication date |
---|---|
JP5178822B2 (ja) | 2013-04-10 |
EP2150910A4 (en) | 2011-01-19 |
EP2150910A1 (en) | 2010-02-10 |
US8874512B2 (en) | 2014-10-28 |
KR100926880B1 (ko) | 2009-11-16 |
JP2010527087A (ja) | 2010-08-05 |
WO2008143408A1 (en) | 2008-11-27 |
CN101681383B (zh) | 2013-02-20 |
KR20080102622A (ko) | 2008-11-26 |
US20100250491A1 (en) | 2010-09-30 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101681383B (zh) | 用于数据库管理系统的数据复制方法及系统 | |
KR102307371B1 (ko) | 데이터베이스 시스템 내의 데이터 복제 및 데이터 장애 조치 | |
CN111143389B (zh) | 事务执行方法、装置、计算机设备及存储介质 | |
CN108932282B (zh) | 一种数据库迁移方法、装置和存储介质 | |
US10817536B2 (en) | Transferring connections in a multiple deployment database | |
CN105339939B (zh) | 对在线热备份数据库的复制 | |
CN100461123C (zh) | 用于形成一致性组的方法和系统 | |
US7433903B1 (en) | Method for reading audit data from a remote mirrored disk for application to remote database backup copy | |
CN113396407A (zh) | 用于利用区块链技术扩充数据库应用的系统和方法 | |
US20130110873A1 (en) | Method and system for data storage and management | |
US20020198899A1 (en) | Method and system of database management for replica database | |
US20100257138A1 (en) | Data change ordering in multi-log based replication | |
EP3391244B1 (en) | Replication control among redundant data centers | |
CN110019251A (zh) | 一种数据处理系统、方法及设备 | |
US11263236B2 (en) | Real-time cross-system database replication for hybrid-cloud elastic scaling and high-performance data virtualization | |
CN101187888A (zh) | 一种异构环境中复制数据库数据的方法 | |
US20090193059A1 (en) | Data consistency control method and software for a distributed replicated database system | |
US20110055151A1 (en) | Processing Database Operation Requests | |
CN102270155A (zh) | 应用程序实例和查询存储 | |
JP2023541298A (ja) | トランザクション処理方法、システム、装置、機器、及びプログラム | |
US7194486B2 (en) | Method and system for data processing with data replication for the same | |
Correia et al. | Group-based replication of on-line transaction processing servers | |
CA2618938C (en) | Data consistency control method and software for a distributed replicated database system | |
WO2023125241A1 (zh) | 数据库表的复制方法、装置、电子设备及存储介质 | |
Vanstechelman | The SAP HANA Deployment Guide |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C41 | Transfer of patent application or patent right or utility model | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20110909 Address after: Gyeonggi Do city of South Korea Applicant after: NHN Corp. Address before: Gyeonggi Do, South Korea Applicant before: NHN Corp. |
|
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
ASS | Succession or assignment of patent right |
Owner name: NABAO CO., LTD. Free format text: FORMER OWNER: NHN CORP. Effective date: 20141117 |
|
C41 | Transfer of patent application or patent right or utility model | ||
TR01 | Transfer of patent right |
Effective date of registration: 20141117 Address after: Gyeonggi Do city of South Korea Patentee after: NAVER CORP. Address before: Gyeonggi Do city of South Korea Patentee before: NHN Corp. |