AU2006227918B2 - 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
AU2006227918B2
AU2006227918B2 AU2006227918A AU2006227918A AU2006227918B2 AU 2006227918 B2 AU2006227918 B2 AU 2006227918B2 AU 2006227918 A AU2006227918 A AU 2006227918A AU 2006227918 A AU2006227918 A AU 2006227918A AU 2006227918 B2 AU2006227918 B2 AU 2006227918B2
Authority
AU
Australia
Prior art keywords
database
row
identified
rows
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
AU2006227918A
Other languages
English (en)
Other versions
AU2006227918A1 (en
Inventor
Scott Roger Corbin
Eric Ian Fish
George Allen Pearson
Timothy Lee Rathbun
Joel Shepherd
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 AU2006227918A1 publication Critical patent/AU2006227918A1/en
Application granted granted Critical
Publication of AU2006227918B2 publication Critical patent/AU2006227918B2/en
Assigned to ORACLE INTERNATIONAL CORPORATION reassignment ORACLE INTERNATIONAL CORPORATION Request for Assignment Assignors: GOLDENGATE SOFTWARE, INC.
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)
AU2006227918A 2005-03-18 2006-02-21 Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same Active AU2006227918B2 (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
AU2006227918A1 AU2006227918A1 (en) 2006-09-28
AU2006227918B2 true AU2006227918B2 (en) 2011-04-28

Family

ID=37011611

Family Applications (1)

Application Number Title Priority Date Filing Date
AU2006227918A Active AU2006227918B2 (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

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
US20020059299A1 (en) * 2000-07-14 2002-05-16 Frederic Spaey System and method for synchronizing databases

Family Cites Families (19)

* 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
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
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 (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
US20020059299A1 (en) * 2000-07-14 2002-05-16 Frederic Spaey System and method for synchronizing databases

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

Similar Documents

Publication Publication Date Title
AU2006227918B2 (en) Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same
JP7090744B2 (ja) 分散データベースクラスタシステム、及びデータ同期方法
EP2147437B1 (en) Seeding replication
US8346778B2 (en) Organizing portions of a cascading index on disk
US9589041B2 (en) Client and server integration for replicating data
US9501367B2 (en) Systems and methods for minimizing network bandwidth for replication/back up
EP3828724B1 (en) Delta version clustering and re-anchoring
US7797358B1 (en) Methods and apparatus for continuous data protection system having journal compression
US9773042B1 (en) Method and system for accelerating data movement using change information concerning difference between current and previous data movements
KR20200100173A (ko) 데이터베이스 시스템 내의 데이터 복제 및 데이터 장애 조치
US20060235905A1 (en) Method and system for preserving real-time access to a system in case of a disaster
US20100125555A1 (en) Efficient undo-processing during data redistribution
US11010256B1 (en) Method and system for implementing current, consistent, and complete backup copy by rolling a change log backwards against a storage device
CN113656384A (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
KR20120090320A (ko) 분산 파일 시스템에서 효율적인 자료 복구 방법
US20080320259A1 (en) Method for Providing Fault Tolerance to Multiple Servers
CN100409196C (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
HK40062659B (en) Data processing method, distributed database system, electronic equipment and storage medium

Legal Events

Date Code Title Description
PC1 Assignment before grant (sect. 113)

Owner name: ORACLE INTERNATIONAL CORPORATION

Free format text: FORMER APPLICANT(S): GOLDENGATE SOFTWARE, INC.

FGA Letters patent sealed or granted (standard patent)