CA2598584C - Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same - Google Patents

Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same Download PDF

Info

Publication number
CA2598584C
CA2598584C CA2598584A CA2598584A CA2598584C CA 2598584 C CA2598584 C CA 2598584C CA 2598584 A CA2598584 A CA 2598584A CA 2598584 A CA2598584 A CA 2598584A CA 2598584 C CA2598584 C CA 2598584C
Authority
CA
Canada
Prior art keywords
database
row
processor
executable instructions
rows
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
CA2598584A
Other languages
English (en)
French (fr)
Other versions
CA2598584A1 (en
Inventor
Eric Ian Fish
Scott Roger Corbin
Joel Shepherd
George Allen Pearson
Timothy Lee Rathbun
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Oracle International Corp
Original Assignee
Oracle International Corp
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 Oracle International Corp filed Critical Oracle International Corp
Publication of CA2598584A1 publication Critical patent/CA2598584A1/en
Application granted granted Critical
Publication of CA2598584C publication Critical patent/CA2598584C/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

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)
CA2598584A 2005-03-18 2006-02-21 Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same Active CA2598584C (en)

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 (2)

Publication Number Publication Date
CA2598584A1 CA2598584A1 (en) 2006-09-28
CA2598584C true CA2598584C (en) 2015-05-12

Family

ID=37011611

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2598584A Active CA2598584C (en) 2005-03-18 2006-02-21 Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same

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

Family Cites Families (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0678812A1 (en) * 1994-04-20 1995-10-25 Microsoft Corporation Replication verification
US5765172A (en) * 1996-01-23 1998-06-09 Dsc Communications Corporation System and method for verifying integrity of replicated databases
US5884325A (en) * 1996-10-09 1999-03-16 Oracle Corporation System for synchronizing shared data between computers
US5999947A (en) * 1997-05-27 1999-12-07 Arkona, Llc Distributing database differences corresponding to database change events made to a database table located on a server computer
US6304882B1 (en) * 1998-05-05 2001-10-16 Informix Software, Inc. Data replication system and method
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
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

Also Published As

Publication number Publication date
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
JP4880668B2 (ja) 2012-02-22
EP1859363B1 (en) 2017-08-02

Similar Documents

Publication Publication Date Title
CA2598584C (en) Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same
US20230267131A1 (en) Managing database failover based on transaction request time
JP7090744B2 (ja) 分散データベースクラスタシステム、及びデータ同期方法
EP3602341B1 (en) Data replication system
US20110173619A1 (en) Apparatus and method for optimized application of batched data to a database
US8346778B2 (en) Organizing portions of a cascading index on disk
EP2147437B1 (en) Seeding replication
US9589041B2 (en) Client and server integration for replicating data
CA2906522C (en) Log record management
US8060889B2 (en) Method and system for real-time event journaling to provide enterprise data services
US9411866B2 (en) Replication mechanisms for database environments
US7949640B2 (en) Referential integrity, consistency, and completeness loading of databases
US20060235905A1 (en) Method and system for preserving real-time access to a system in case of a disaster
CN113656384B (zh) 数据处理方法、分布式数据库系统、电子设备及存储介质
US20090319585A1 (en) Application-aware and remote single instance data management
US20100125555A1 (en) Efficient undo-processing during data redistribution
US20220035786A1 (en) Distributed database management system with dynamically split b-tree indexes
US11010256B1 (en) Method and system for implementing current, consistent, and complete backup copy by rolling a change log backwards against a storage device
US20230393958A1 (en) Systems and methods for synchronizing between a source database cluster and a destination database cluster
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
CA2531714C (en) A method and system for preserving access to a system in case of a disaster

Legal Events

Date Code Title Description
EEER Examination request