[go: up one dir, main page]

WO1999008209A1 - Replication de donnees asynchrone et haute performance - Google Patents

Replication de donnees asynchrone et haute performance Download PDF

Info

Publication number
WO1999008209A1
WO1999008209A1 PCT/US1998/015862 US9815862W WO9908209A1 WO 1999008209 A1 WO1999008209 A1 WO 1999008209A1 US 9815862 W US9815862 W US 9815862W WO 9908209 A1 WO9908209 A1 WO 9908209A1
Authority
WO
WIPO (PCT)
Prior art keywords
time
entry
replication
stamp
writing
Prior art date
Application number
PCT/US1998/015862
Other languages
English (en)
Inventor
Munir Cochinwala
Kuo-Chu Lee
Min Tae Yu
Original Assignee
Bell Communications Research, 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 Bell Communications Research, Inc. filed Critical Bell Communications Research, Inc.
Publication of WO1999008209A1 publication Critical patent/WO1999008209A1/fr

Links

Classifications

    • 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

Definitions

  • processor 102 determines whether a replication cycle has expired (step 200). If not, it waits for a predetermined period (step 202) and returns to the initial step 200.
  • the replication cycle preferably corresponds to a preselected time period for writing to the replication table in replication database 104. In a preferred embodiment, this replication cycle is chosen to be ten seconds. However, the replication cycle is configurable and can be selected to be any predetermined time period depending on the application.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Computing Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Une configuration de table et un procédé (figure 1) permettent la réplication efficace de données de table (105). Des information horodatées (108) sont incluses dans une table (106) et chaque modification ou mise à jour d'une entrée de table est accompagnée d'une nouvelle marque de temps. Un procédé de réplication de table (105) consiste à vérifier la marque de temps de chaque entrée de table (106) périodiquement pour l'identification des entrées de table qui ont été modifiées depuis la dernière réplication de la table. Après le marquage de ces entrées de table nécessitant encore une réplication, seules ces entrées de table identifiées sont inscrites dans une table de réplication. Le cycle de réplication (200) peut être sélectionné à n'importe quel intervalle de temps utile en fonction de l'application.
PCT/US1998/015862 1997-08-08 1998-07-30 Replication de donnees asynchrone et haute performance WO1999008209A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US90770597A 1997-08-08 1997-08-08
US08/907,705 1997-08-08

Publications (1)

Publication Number Publication Date
WO1999008209A1 true WO1999008209A1 (fr) 1999-02-18

Family

ID=25424515

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US1998/015862 WO1999008209A1 (fr) 1997-08-08 1998-07-30 Replication de donnees asynchrone et haute performance

Country Status (1)

Country Link
WO (1) WO1999008209A1 (fr)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7519620B2 (en) * 2000-09-27 2009-04-14 Hitachi, Ltd. Replication system, method and program for replicating a plurality of databases into a replica database

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5544353A (en) * 1993-06-14 1996-08-06 International Business Machines Corporation Distributed processing object shared resource control apparatus and method
US5603024A (en) * 1993-10-08 1997-02-11 International Business Machines Corporation Lossless distribution of time series data in a relational data base network
US5737600A (en) * 1994-09-12 1998-04-07 International Business Machines Corporation Method and system for log management in a coupled data processing system
US5758355A (en) * 1996-08-07 1998-05-26 Aurum Software, Inc. Synchronization of server database with client database using distribution tables
US5778225A (en) * 1996-02-09 1998-07-07 Supernaw-Issen; Daniel Aaron Method and apparatus for sharing objects among a plurality of processes

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5544353A (en) * 1993-06-14 1996-08-06 International Business Machines Corporation Distributed processing object shared resource control apparatus and method
US5603024A (en) * 1993-10-08 1997-02-11 International Business Machines Corporation Lossless distribution of time series data in a relational data base network
US5737600A (en) * 1994-09-12 1998-04-07 International Business Machines Corporation Method and system for log management in a coupled data processing system
US5778225A (en) * 1996-02-09 1998-07-07 Supernaw-Issen; Daniel Aaron Method and apparatus for sharing objects among a plurality of processes
US5758355A (en) * 1996-08-07 1998-05-26 Aurum Software, Inc. Synchronization of server database with client database using distribution tables

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
PARK C. S., ET AL.: "A REPLICA CONTROL METHOD FOR IMPROVING AVAILABILITY FOR READ-ONLY TRANSACTIONS.", PROCEEDINGS IDEAS. INTERNATIONAL DATABASE ENGINEERING ANDAPPLICATIONS SYMPOSIUM, XX, XX, 25 August 1997 (1997-08-25) - 27 August 1997 (1997-08-27), XX, pages 104 - 112., XP002913162 *
SIDELL J., ET AL.: "DATA REPLICATION IN MARIPOSA.", DATA ENGINEERING., IEEE, SILVER SPRING, MD., US, 1 February 1996 (1996-02-01), US, pages 485 - 494., XP002913161, ISSN: 1063-6382 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7519620B2 (en) * 2000-09-27 2009-04-14 Hitachi, Ltd. Replication system, method and program for replicating a plurality of databases into a replica database

Similar Documents

Publication Publication Date Title
US9652519B2 (en) Replicating data across multiple copies of a table in a database system
US6604117B2 (en) Method of maintaining a network of partially replicated database system
US6826726B2 (en) Remote document updating system using XML and DOM
US6178425B1 (en) Method of determining the visibility to a remote database client of a plurality of database transactions using simplified visibility rules
US6684438B2 (en) Method of using cache to determine the visibility to a remote database client of a plurality of database transactions
US5758355A (en) Synchronization of server database with client database using distribution tables
US5727202A (en) Method and apparatus for synchronizing information on two different computer systems
US6058401A (en) Method for data replication with conflict detection
US6189011B1 (en) Method of maintaining a network of partially replicated database system
US20010016853A1 (en) Method and apparatus for synchronizing information on two different computer systems
US5724581A (en) Data base management system for recovering from an abnormal condition
US6092083A (en) Database management system which synchronizes an enterprise server and a workgroup user client using a docking agent
US5920857A (en) Efficient optimistic concurrency control and lazy queries for B-trees and other database structures
US20090019093A1 (en) Partially replicated distributed database with multiple levels of remote clients
US7188124B2 (en) Method, system, computer product for recovering dropped database table specifying one or more table spaces, recovering the table space being restored using the dropped table history data structure
US20070143368A1 (en) Conflict resolution in highly available network element
EP1131756B1 (fr) Protocole de synchronisation de processeurs paralleles dans un systeme de communications mobiles
US7051051B1 (en) Recovering from failed operations in a database system
CN116821232A (zh) 一种数据同步方法及相关装置
WO1999008209A1 (fr) Replication de donnees asynchrone et haute performance
JP3769775B2 (ja) 分散リンク情報維持方法
US7035859B2 (en) Method and system for intra-table referential integrity for relational database systems
JPH06266599A (ja) デ−タベ−ス更新情報転送方法
JP3330006B2 (ja) 情報記憶システムを備えるネットワークシステム、該システムの入力システムならびに
JPH1153239A (ja) データベースのロールバック処理方法及び前記ロールバック処理方法の手順を記録した記録媒体

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): CA JP

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE

DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
121 Ep: the epo has been informed by wipo that ep was designated in this application
122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase

Ref country code: CA