CN101176090B - 用于识别在冗余数据存储中的异步数据并且将其重新同步的装置和方法 - Google Patents

用于识别在冗余数据存储中的异步数据并且将其重新同步的装置和方法 Download PDF

Info

Publication number
CN101176090B
CN101176090B CN2006800088181A CN200680008818A CN101176090B CN 101176090 B CN101176090 B CN 101176090B CN 2006800088181 A CN2006800088181 A CN 2006800088181A CN 200680008818 A CN200680008818 A CN 200680008818A CN 101176090 B CN101176090 B CN 101176090B
Authority
CN
China
Prior art keywords
database
data
row
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.)
Expired - Lifetime
Application number
CN2006800088181A
Other languages
English (en)
Chinese (zh)
Other versions
CN101176090A (zh
Inventor
埃里克·伊恩·菲什
斯科特·罗杰·科尔宾
乔尔·谢泼德
乔治·艾伦·皮尔逊
蒂莫西·李·拉思本
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
GoldenGate Software Inc
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 GoldenGate Software Inc filed Critical GoldenGate Software Inc
Publication of CN101176090A publication Critical patent/CN101176090A/zh
Application granted granted Critical
Publication of CN101176090B publication Critical patent/CN101176090B/zh
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

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)
  • Quality & Reliability (AREA)
  • Databases & Information Systems (AREA)
  • Computing Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Hardware Redundancy (AREA)
CN2006800088181A 2005-03-18 2006-02-21 用于识别在冗余数据存储中的异步数据并且将其重新同步的装置和方法 Expired - Lifetime CN101176090B (zh)

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
CN101176090A CN101176090A (zh) 2008-05-07
CN101176090B true CN101176090B (zh) 2010-09-01

Family

ID=37011611

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2006800088181A Expired - Lifetime CN101176090B (zh) 2005-03-18 2006-02-21 用于识别在冗余数据存储中的异步数据并且将其重新同步的装置和方法

Country Status (7)

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

Families Citing this family (66)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7627776B2 (en) * 2004-11-16 2009-12-01 Petruzzo Stephen E Data backup method
US7822715B2 (en) * 2004-11-16 2010-10-26 Petruzzo Stephen E Data mirroring 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
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
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
US20080191896A1 (en) * 2007-02-09 2008-08-14 Jain Rohit Rocky Electronic device and method of adding parties to a calendar event
US20080195455A1 (en) * 2007-02-09 2008-08-14 Research In Motion Limited Electronic device and method of scheduling calendar events
US20080195619A1 (en) * 2007-02-09 2008-08-14 Jain Rohit Rocky Electronic device and method of sharing calendar-event information
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 監査証跡ファイル作成方法及びその実施装置
US8429444B2 (en) * 2008-12-18 2013-04-23 Scality, S.A. 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
US10148530B2 (en) 2012-09-07 2018-12-04 Oracle International Corporation Rule based subscription cloning
US10521746B2 (en) 2012-09-07 2019-12-31 Oracle International Corporation Recovery workflow for processing subscription orders in a computing infrastructure system
US9621435B2 (en) 2012-09-07 2017-04-11 Oracle International Corporation Declarative and extensible model for provisioning of cloud based services
US9253113B2 (en) 2012-09-07 2016-02-02 Oracle International Corporation Customizable model for throttling and prioritizing orders in a cloud environment
US9667470B2 (en) 2012-09-07 2017-05-30 Oracle International Corporation Failure handling in the execution flow of provisioning operations in a cloud environment
US9219749B2 (en) * 2012-09-07 2015-12-22 Oracle International Corporation Role-driven notification system including support for collapsing combinations
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
US10091249B2 (en) * 2013-11-22 2018-10-02 Telefonaktiebolaget Lm 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 阿里巴巴集团控股有限公司 异构数据源之间的数据同步方法和装置
US11023492B2 (en) * 2015-05-20 2021-06-01 Guidewire Software, Inc. Deferred synchronization for work unit-related data
US9727243B2 (en) 2015-06-30 2017-08-08 International Business Machines Corporation Using inactive copy relationships to resynchronize data between storages
US9921764B2 (en) 2015-06-30 2018-03-20 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
US10922296B2 (en) * 2017-03-01 2021-02-16 Sap Se In-memory row storage durability
CN106997378B (zh) * 2017-03-13 2020-05-15 上海摩库数据技术有限公司 基于Redis的数据库数据聚合同步的方法
US11907187B1 (en) 2017-04-28 2024-02-20 Verato, Inc. Methods and systems for facilitating data stewardship tasks
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
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
US5884325A (en) * 1996-10-09 1999-03-16 Oracle Corporation System for synchronizing shared data between computers
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
WO2002017134A1 (en) * 2000-08-25 2002-02-28 Telefonaktiebolaget Lm Ericsson (Publ) Non-time dependent synchronization of databases
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
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
US6304882B1 (en) 1998-05-05 2001-10-16 Informix Software, Inc. Data replication system and method
EP1158409B1 (en) * 2000-05-25 2008-05-28 Hitachi, Ltd. Storage system making possible data synchronisation confirmation at time of asynchronous remote copy
US20020059299A1 (en) * 2000-07-14 2002-05-16 Frederic Spaey System and method for synchronizing 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
CA2933790C (en) * 2005-10-28 2019-04-30 Oracle International Corporation Apparatus and method for creating a real time database replica
US7831574B2 (en) * 2006-05-12 2010-11-09 Oracle International Corporation Apparatus and method for forming a homogenous transaction data store from heterogeneous sources
WO2007134251A2 (en) * 2006-05-12 2007-11-22 Goldengate Software, Inc. 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 (4)

* 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
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
WO2002017134A1 (en) * 2000-08-25 2002-02-28 Telefonaktiebolaget Lm Ericsson (Publ) Non-time dependent synchronization of databases

Also Published As

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

Similar Documents

Publication Publication Date Title
CN101176090B (zh) 用于识别在冗余数据存储中的异步数据并且将其重新同步的装置和方法
US20230267131A1 (en) Managing database failover based on transaction request time
US12475104B2 (en) Data processing method, distributed database system, electronic device and storage medium
US9146934B2 (en) Reduced disk space standby
EP3602341B1 (en) Data replication system
US9589041B2 (en) Client and server integration for replicating data
US6714943B1 (en) Method and mechanism for tracking dependencies for referential integrity constrained tables
US6615223B1 (en) Method and system for data replication
US6728719B1 (en) Method and mechanism for dependency tracking for unique constraints
US9411866B2 (en) Replication mechanisms for database environments
US8484162B2 (en) De-duplication systems and methods for application-specific data
US11768807B2 (en) Destination namespace and file copying
KR20040086580A (ko) 데이터 복제를 용이하게 하기 위한 시스템 및 방법과 상기시스템을 포함하는 컴퓨터 및 네트워크
US20180101589A1 (en) High-performance database replication systems and methods
US11630816B2 (en) Continuous data protection using retroactive backup snapshots
CN116628024A (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
HK40062659A (en) Data processing method, distributed database system, electronic equipment and storage medium
CN121658476A (zh) 处理数据的方法及装置、电子设备、计算机程序产品
HK40090464A (en) Blockchain data indexing method, and blockchain data storage method

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
ASS Succession or assignment of patent right

Owner name: ORACLE INT CORP

Free format text: FORMER OWNER: GOLDENGATE SOFTWARE INC.

Effective date: 20111231

C41 Transfer of patent application or patent right or utility model
TR01 Transfer of patent right

Effective date of registration: 20111231

Address after: American California

Patentee after: ORACLE INTERNATIONAL Corp.

Address before: American California

Patentee before: GOLDENGATE SOFTWARE, Inc.

CX01 Expiry of patent term

Granted publication date: 20100901

CX01 Expiry of patent term