JP4880668B2 - 冗長データストアにおける非同期データを識別するための、およびそれを再同期させるための装置および方法 - Google Patents

冗長データストアにおける非同期データを識別するための、およびそれを再同期させるための装置および方法 Download PDF

Info

Publication number
JP4880668B2
JP4880668B2 JP2008501889A JP2008501889A JP4880668B2 JP 4880668 B2 JP4880668 B2 JP 4880668B2 JP 2008501889 A JP2008501889 A JP 2008501889A JP 2008501889 A JP2008501889 A JP 2008501889A JP 4880668 B2 JP4880668 B2 JP 4880668B2
Authority
JP
Japan
Prior art keywords
database
row
data
identified
hash
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
Application number
JP2008501889A
Other languages
English (en)
Japanese (ja)
Other versions
JP2008533612A (ja
JP2008533612A5 (enExample
Inventor
フィッシュ，エリック，イアン
コルビン，スコット，ロジャー
シェパード，ジョエル
ピアソン，ジョージ，アレン
ラスバン，ティモシー，リー
Original Assignee
オラクル・インターナショナル・コーポレイション
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by オラクル・インターナショナル・コーポレイション filed Critical オラクル・インターナショナル・コーポレイション
Publication of JP2008533612A publication Critical patent/JP2008533612A/ja
Publication of JP2008533612A5 publication Critical patent/JP2008533612A5/ja
Application granted granted Critical
Publication of JP4880668B2 publication Critical patent/JP4880668B2/ja
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16—Error detection or correction of the data by redundancy in hardware
    • G06F11/20—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
    • G06F11/2097—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements maintaining the standby controller/processing unit updated
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16—Error detection or correction of the data by redundancy in hardware
    • G06F11/1658—Data re-synchronization of a redundant component, or initial sync of replacement, additional or spare unit
    • G06F11/1662—Data re-synchronization of a redundant component, or initial sync of replacement, additional or spare unit the resynchronized component or unit being a persistent storage device
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/273—Asynchronous replication or reconciliation

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Quality & Reliability (AREA)
  • Computing Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Hardware Redundancy (AREA)
JP2008501889A 2005-03-18 2006-02-21 冗長データストアにおける非同期データを識別するための、およびそれを再同期させるための装置および方法 Active JP4880668B2 (ja)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US11/084,855 2005-03-18
US11/084,855 US7788225B2 (en) 2005-03-18 2005-03-18 Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same
PCT/US2006/005702 WO2006101633A2 (en) 2005-03-18 2006-02-21 Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same

Publications (3)

Publication Number Publication Date
JP2008533612A JP2008533612A (ja) 2008-08-21
JP2008533612A5 JP2008533612A5 (enExample) 2010-04-22
JP4880668B2 true JP4880668B2 (ja) 2012-02-22

Family

ID=37011611

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2008501889A Active JP4880668B2 (ja) 2005-03-18 2006-02-21 冗長データストアにおける非同期データを識別するための、およびそれを再同期させるための装置および方法

Country Status (7)

Country Link
US (1) US7788225B2 (enExample)
EP (1) EP1859363B1 (enExample)
JP (1) JP4880668B2 (enExample)
CN (1) CN101176090B (enExample)
AU (1) AU2006227918B2 (enExample)
CA (1) CA2598584C (enExample)
WO (1) WO2006101633A2 (enExample)

Families Citing this family (65)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7822715B2 (en) * 2004-11-16 2010-10-26 Petruzzo Stephen E Data mirroring method
US7627776B2 (en) * 2004-11-16 2009-12-01 Petruzzo Stephen E Data backup method
US7814052B2 (en) * 2006-11-03 2010-10-12 Salesforce.Com, Inc. Implementing formulas for custom fields in an on-demand database
US7805403B2 (en) 2007-01-07 2010-09-28 Apple Inc. Synchronization methods and systems
US9552571B2 (en) 2007-02-02 2017-01-24 Blackberry Limited Electronic device and method of meeting notification
US20080186807A1 (en) * 2007-02-02 2008-08-07 Research In Motion Limited Electronic device and method of controlling an electronic device for calendar event updates
US20080191896A1 (en) * 2007-02-09 2008-08-14 Jain Rohit Rocky Electronic device and method of adding parties to a calendar event
EP1956499A1 (en) 2007-02-09 2008-08-13 Research In Motion Limited System and method for managing databases associated with respective personal information manager service accounts
US20080195619A1 (en) * 2007-02-09 2008-08-14 Jain Rohit Rocky Electronic device and method of sharing calendar-event information
US7849056B2 (en) 2007-02-09 2010-12-07 Research In Motion Limited System and method for managing databases associated with respective personal information manager service accounts
US20080195455A1 (en) * 2007-02-09 2008-08-14 Research In Motion Limited Electronic device and method of scheduling calendar events
US8615798B2 (en) * 2007-06-29 2013-12-24 International Business Machines Corporation Optimizing a data deduplication system using client authentication information
JP2009282772A (ja) * 2008-05-22 2009-12-03 Hitachi Ltd 監査証跡ファイル作成方法及びその実施装置
EP2377294B1 (en) * 2008-12-18 2017-05-17 Scality, SA Multipurpose storage system based upon a distributed hashing mechanism with transactional support and failover capability
US8224933B2 (en) * 2009-02-26 2012-07-17 Telefonaktiebolaget Lm Ericsson (Publ) Method and apparatus for case-based service composition
US8082235B1 (en) 2009-04-09 2011-12-20 Google Inc. Self healing system for inaccurate metadata
US8843440B2 (en) 2011-01-21 2014-09-23 Microsoft Corporation Synchronizing database projects with partner projects
US8510267B2 (en) * 2011-03-08 2013-08-13 Rackspace Us, Inc. Synchronization of structured information repositories
US9396242B2 (en) * 2011-04-11 2016-07-19 Salesforce.Com, Inc. Multi-master data replication in a distributed multi-tenant system
US9600513B2 (en) 2011-06-09 2017-03-21 International Business Machines Corporation Database table comparison
US8903831B2 (en) * 2011-09-29 2014-12-02 International Business Machines Corporation Rejecting rows when scanning a collision chain
US9020976B2 (en) * 2012-01-31 2015-04-28 Bank Of America Corporation System and method for processing data in diverse storage systems
US9286162B2 (en) * 2012-02-02 2016-03-15 Netapp, Inc. System and method for guaranteeing consistent data synchronization from a volatile data source
US9053153B2 (en) * 2012-06-18 2015-06-09 Sap Se Inter-query parallelization of constraint checking
WO2014000825A1 (en) * 2012-06-29 2014-01-03 Data2Knowledge Gmbh A method for maintaining one or more table values for a number of tables in a database system
US9621435B2 (en) 2012-09-07 2017-04-11 Oracle International Corporation Declarative and extensible model for provisioning of cloud based services
US9219749B2 (en) * 2012-09-07 2015-12-22 Oracle International Corporation Role-driven notification system including support for collapsing combinations
US10148530B2 (en) 2012-09-07 2018-12-04 Oracle International Corporation Rule based subscription cloning
US9667470B2 (en) 2012-09-07 2017-05-30 Oracle International Corporation Failure handling in the execution flow of provisioning operations in a cloud environment
US9253113B2 (en) 2012-09-07 2016-02-02 Oracle International Corporation Customizable model for throttling and prioritizing orders in a cloud environment
US10521746B2 (en) 2012-09-07 2019-12-31 Oracle International Corporation Recovery workflow for processing subscription orders in a computing infrastructure system
CN103929763A (zh) * 2013-01-11 2014-07-16 阿尔卡特朗讯 一种用于比较和重构地理冗余的数据库的方法
US9749408B2 (en) * 2013-07-30 2017-08-29 Dropbox, Inc. Techniques for managing unsynchronized content items at unlinked devices
WO2015076715A1 (en) * 2013-11-22 2015-05-28 Telefonaktiebolaget L M Ericsson (Publ) Method and system for synchronization of two databases in a lawful interception network by comparing checksum values
TWI514811B (zh) * 2013-11-28 2015-12-21 Synology Inc 網路系統的操作方法
US10831528B2 (en) * 2013-12-19 2020-11-10 International Business Machines Corporation Replication of batch jobs of computing systems
US9514013B2 (en) 2014-06-27 2016-12-06 International Business Machines Corporation Maintaining inactive copy relationships for secondary storages of active copy relationships having a common primary storage for use in case of a failure of the common primary storage
US10164901B2 (en) 2014-08-22 2018-12-25 Oracle International Corporation Intelligent data center selection
US20160063050A1 (en) * 2014-08-28 2016-03-03 Joerg Schoen Database Migration Consistency Checker
KR101960339B1 (ko) * 2014-10-21 2019-03-20 삼성에스디에스 주식회사 파일 동기화 방법
US9928281B2 (en) 2015-03-20 2018-03-27 International Business Machines Corporation Lightweight table comparison
US9397985B1 (en) 2015-04-14 2016-07-19 Manifold Technology, Inc. System and method for providing a cryptographic platform for exchanging information
CN106156165A (zh) 2015-04-16 2016-11-23 阿里巴巴集团控股有限公司 异构数据源之间的数据同步方法和装置
US9921764B2 (en) 2015-06-30 2018-03-20 International Business Machines Corporation Using inactive copy relationships to resynchronize data between storages
US9727243B2 (en) 2015-06-30 2017-08-08 International Business Machines Corporation Using inactive copy relationships to resynchronize data between storages
WO2017069874A1 (en) * 2015-10-21 2017-04-27 Manifold Technology, Inc. Event synchronization systems and methods
US10949309B2 (en) 2015-12-28 2021-03-16 Netapp Inc. Snapshot creation with synchronous replication
CN107291710B (zh) * 2016-03-30 2020-07-03 杭州海康威视数字技术股份有限公司 一种用于分布式数据库系统的更新数据的方法及装置
US10382544B2 (en) 2016-04-08 2019-08-13 International Business Machines Corporation Establishing reverse paths between servers in a copy environment
US10262053B2 (en) * 2016-12-22 2019-04-16 Palantir Technologies Inc. Systems and methods for data replication synchronization
US10430437B2 (en) 2017-02-08 2019-10-01 Bank Of America Corporation Automated archival partitioning and synchronization on heterogeneous data systems
US10664462B2 (en) * 2017-03-01 2020-05-26 Sap Se In-memory row storage architecture
CN106997378B (zh) * 2017-03-13 2020-05-15 上海摩库数据技术有限公司 基于Redis的数据库数据聚合同步的方法
US11899632B1 (en) 2017-04-28 2024-02-13 Verato, Inc. System and method for secure linking and matching of data elements across independent data systems
US11907187B1 (en) 2017-04-28 2024-02-20 Verato, Inc. Methods and systems for facilitating data stewardship tasks
GB201812375D0 (en) * 2018-07-30 2018-09-12 Ibm Updating a table using incremental and batch updates
US11132339B2 (en) * 2018-11-13 2021-09-28 Netapp Inc. Synchronous replication for synchronous mirror copy guarantee
US10776038B2 (en) 2018-11-26 2020-09-15 Bank Of America Corporation Systems and methods for defining replication of data
US11379498B2 (en) 2020-03-06 2022-07-05 Dropbox, Inc. Live data conversion and migration for distributed data object systems
US11907260B2 (en) * 2020-04-19 2024-02-20 International Business Machines Corporation Compare processing using replication log-injected compare records in a replication environment
US11372885B2 (en) * 2020-05-13 2022-06-28 Sap Se Replication of complex augmented views
US11829334B2 (en) 2020-06-12 2023-11-28 International Business Machines Corporation Per row database resynchronization
US12353381B2 (en) * 2021-08-30 2025-07-08 International Business Machines Corporation Large object data type support for column-based database system
US11526491B1 (en) * 2022-02-21 2022-12-13 Clari Inc. Method and system for collecting data from data sources with commit lag to maintain data consistency in a data store
US20250328526A1 (en) * 2024-04-18 2025-10-23 Oracle International Corporation Optimized Query Of Table With No Index For Table Comparison In Heterogeneous Source And Target Databases

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH07302218A (ja) * 1994-04-20 1995-11-14 Microsoft Corp レプリケーションの検証
US5765172A (en) * 1996-01-23 1998-06-09 Dsc Communications Corporation System and method for verifying integrity of replicated databases
US6321236B1 (en) * 1997-05-27 2001-11-20 Arkona, Inc. Distributing database differences corresponding to database change events made to a database table located on a server computer
US6449622B1 (en) * 1999-03-08 2002-09-10 Starfish Software, Inc. System and methods for synchronizing datasets when dataset changes may be received out of order

Family Cites Families (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5884325A (en) * 1996-10-09 1999-03-16 Oracle Corporation System for synchronizing shared data between computers
US6304882B1 (en) * 1998-05-05 2001-10-16 Informix Software, Inc. Data replication system and method
DE60039033D1 (de) * 2000-05-25 2008-07-10 Hitachi Ltd Speichersystem zur Bestätigung der Datensynchronisierung während des asynchronen Fernkopierens
US20020059299A1 (en) * 2000-07-14 2002-05-16 Frederic Spaey System and method for synchronizing databases
US6718348B1 (en) * 2000-08-25 2004-04-06 Telefonaktiebolaget Lm Ericsson (Publ) Non-time dependent synchronization of databases
US20020055939A1 (en) * 2000-11-06 2002-05-09 Joseph Nardone System for a configurable open database connectivity conduit
US7929562B2 (en) 2000-11-08 2011-04-19 Genesis Telecommunications Laboratories, Inc. Method and apparatus for optimizing response time to events in queue
US6745209B2 (en) * 2001-08-15 2004-06-01 Iti, Inc. Synchronization of plural databases in a database replication system
US7162596B2 (en) * 2002-01-11 2007-01-09 Hewlett-Packard Development Company, L.P. Remote mirrored disk pair resynchronization monitor
US7024528B2 (en) * 2002-08-21 2006-04-04 Emc Corporation Storage automated replication processing
US7415467B2 (en) * 2003-03-06 2008-08-19 Ixion, Inc. Database replication system
US7363431B1 (en) * 2003-09-19 2008-04-22 Emc Corporation Message-based distributed synchronization in a storage system
US7478112B2 (en) * 2004-12-16 2009-01-13 International Business Machines Corporation Method and apparatus for initializing data propagation execution for large database replication
US8037056B2 (en) * 2005-02-18 2011-10-11 International Business Machines Corporation Online repair of a replicated table
CA2626227C (en) 2005-10-28 2016-07-05 Goldengate Software, Inc. Apparatus and method for creating a real time database replica
WO2007134250A2 (en) 2006-05-12 2007-11-22 Goldengate Software, Inc. Method for forming homogeneous from heterogeneous data
US8296269B2 (en) 2006-05-12 2012-10-23 Oracle International Corporation Apparatus and method for read consistency in a log mining system
US8650155B2 (en) 2008-02-26 2014-02-11 Oracle International Corporation Apparatus and method for log based replication of distributed transactions using globally acknowledged commits

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH07302218A (ja) * 1994-04-20 1995-11-14 Microsoft Corp レプリケーションの検証
US5613079A (en) * 1994-04-20 1997-03-18 Microsoft Corporation System for verifying the proper operation of a replication facility
US5765172A (en) * 1996-01-23 1998-06-09 Dsc Communications Corporation System and method for verifying integrity of replicated databases
US6321236B1 (en) * 1997-05-27 2001-11-20 Arkona, Inc. Distributing database differences corresponding to database change events made to a database table located on a server computer
US6449622B1 (en) * 1999-03-08 2002-09-10 Starfish Software, Inc. System and methods for synchronizing datasets when dataset changes may be received out of order

Also Published As

Publication number Publication date
CA2598584C (en) 2015-05-12
US7788225B2 (en) 2010-08-31
WO2006101633A3 (en) 2008-01-17
CA2598584A1 (en) 2006-09-28
AU2006227918A1 (en) 2006-09-28
CN101176090A (zh) 2008-05-07
US20060212465A1 (en) 2006-09-21
EP1859363A2 (en) 2007-11-28
JP2008533612A (ja) 2008-08-21
WO2006101633A2 (en) 2006-09-28
EP1859363A4 (en) 2010-09-01
CN101176090B (zh) 2010-09-01
AU2006227918B2 (en) 2011-04-28
EP1859363B1 (en) 2017-08-02

Similar Documents

Publication Publication Date Title
JP4880668B2 (ja) 冗長データストアにおける非同期データを識別するための、およびそれを再同期させるための装置および方法
US6615223B1 (en) Method and system for data replication
US20220019575A1 (en) System And Method For Augmenting Database Applications With Blockchain Technology
US7383293B2 (en) Database backup system using data and user-defined routines replicators for maintaining a copy of database on a secondary server
US10642696B2 (en) Copying compressed pages without uncompressing the compressed pages
WO2020029932A1 (zh) 数据存储方法及系统、设备和存储介质
CN113656384B (zh) 数据处理方法、分布式数据库系统、电子设备及存储介质
KR20200100173A (ko) 데이터베이스 시스템 내의 데이터 복제 및 데이터 장애 조치
EP2746971A2 (en) Replication mechanisms for database environments
CN110651265A (zh) 数据复制系统
US20100125555A1 (en) Efficient undo-processing during data redistribution
CN109710388A (zh) 数据读取方法、装置、电子设备以及存储介质
CN106933703A (zh) 一种数据库数据备份的方法、装置及电子设备
CN113868028A (zh) 一种在数据节点上回放日志的方法、数据节点及系统
US12271367B1 (en) Method and apparatus for comparing rows of subsets of two database tables without regard to an original order of rows in either database table
US7945538B2 (en) Method and arrangements for node recovery
CN116089359A (zh) 数据库快照的生成方法、装置、电子设备和介质
JP2001034518A (ja) 分散データベースシステムにおける主従関係情報同期方式
CN111858635A (zh) 数据表切换方法、装置、设备及存储介质
US12373419B1 (en) Method for comparing rows of subsets of two database tables without regard to an original order of rows and columns in either database table
JP2004302919A (ja) レプリケーションシステム及びレプリケーションシステム用プログラム
US20070067664A1 (en) Failure transparency for update applications under single-master configuration
HK40062659B (en) Data processing method, distributed database system, electronic equipment and storage medium
HK40062659A (en) Data processing method, distributed database system, electronic equipment and storage medium
CN118069430A (zh) 一种分布式数据库数据自动恢复方法

Legal Events

Date Code Title Description
A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20090219

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20100302

A711 Notification of change in applicant

Free format text: JAPANESE INTERMEDIATE CODE: A711

Effective date: 20110720

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20110726

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A821

Effective date: 20110720

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20111026

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20111122

A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20111201

R150 Certificate of patent or registration of utility model

Ref document number: 4880668

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

Free format text: JAPANESE INTERMEDIATE CODE: R150

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20141209

Year of fee payment: 3

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250