Method of maintaining a network of partially replicated database system

• US 6,604,117 B2
• Filed: 01/09/2001
• Issued: 08/05/2003
• Est. Priority Date: 03/19/1996
• Status: Expired due to Term

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Broderson, Robert, Lim, Peter S.
• Primary Examiner(s): JUNG, DAVID YIUK
• Application Number:
  US09/756,174
• Publication Number:
  US 20010051944A1
• Time in Patent Office: 938 Days
• Field of Search: 707/1-206, 709/100-332
• US Class Current: 1/1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/278 Data partitioning, e.g. horizontal or vertical partitioning
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method of maintaining a database. The database is a partially replicated database having a central database and a plurality of individual partially replicated databases. Updates made to the central database or to one of the individual, partially replicated databases are selectively propagated to one or more recipient partially replicated databases if the owner of the recipient partially replicated database has visibility to the data being selectively transmitted. This is accomplished by first replicating a group or records as a single logical docking object. A single set of visibility rules is applied to the data content of the entire logical docking unit. The docking object is then applied to the recipient individual partially replicated database if the owner thereof has visibility to the data being transmitted in the single logical docking object. Also disclosed are methods of controlling and logging the propagation of docking objects.

Claims

1. A method of maintaining a database having a central database and a plurality of individual partially replicated databases, wherein updates made to the central database or to one of the individual, partially replicated databases are selectively propagated to a recipient partially replicated database if the owner of the recipient partially replicated database has visibility to the data being selectively transmitted, said method comprising:

(a) replicating a group of records as a logical docking object which is composed of one or more database tables;

(b) applying a set of visibility rules to the data content of the entire logical docking unit; and

(c) propagating the docking object to the recipient individual partially replicated database if the owner thereof has visibility to the data being transmitted in the logical docking object.

2. The method of claim 1 comprising propagating the docking object to the recipient individual partially replicated database if the owner thereof has visibility to the data being transmitted in the logical docking object and the records in the docking object do not exist on the said recipient individual partially replicated database.

3. The method of claim 2 comprising propagating the docking object to the recipient individual partially replicated database if the owner thereof has visibility to the data being transmitted in the logical docking object and the records in the docking object did not originate at the said recipient individual partially replicated database.

4. The method of claim 1 comprising downloading or removing a docking object upon the occurrence of a visibility event.

5. A method of maintaining database having a central database and a plurality of individual partially replicated databases at individual nodes, wherein updates made to the central database or to one of the individual, partially replicated databases at one of the individual nodes are selectively propagated to a recipient partially replicated database at an individual node if the owner of the recipient partially replicated database has visibility to the data being selectively transmitted, said method comprising:

(a) entering a new transaction from an individual partially replicated database onto a node received log;

(b) searching for unprocessed transactions logged onto node received logs;

(c) selecting an unprocessed transaction from a node received log;

(d) updating the central database therefrom;

(e) journalling the update to the central database to a transaction log;

(f) determining if any unprocessed transactions remain; and

(g) repeating steps (a) through (f) if any unprocessed transactions remain.

6. A method of maintaining a database having a central database and a plurality of individual partially replicated databases at individual nodes, wherein updates made to the central database or to one of the individual, partially replicated databases at one of the individual nodes are selectively propagated to a recipient partially replicated database at an individual node if the owner of the recipient partially replicated database has visibility to the data being selectively transmitted, said method comprising:

(a) finding an unprocessed transaction for an individual partially replicated database whose partial transaction is being processed;

(b) determining if any additional unprocessed transaction transactions remain at said individual partially replicated database;

(c) returning to step (a) if any additional unprocessed transactions remain at said individual partially replicated database;

(d) otherwise selecting a transaction for processing;

(e) writing a record for the transaction to a partial transaction log for the individual partially replicated database; and

(f) updating a last record extracted log.

7. A program storage device readable by a machine, tangibly embodying a program of instructions executable by a machine to perform method steps for maintaining a database having a central database and a plurality of individual partially replicated databases, wherein updates made to the central database or to one of the individual, partially replicated databases are selectively propagated to a recipient partially replicated database if the owner of the recipient partially replicated database has visibility to the data being selectively transmitted, the said method steps comprising:

replicating a group or records as a single logical docking object;

applying a single set of visibility rules to the data content of the entire logical docking unit; and

propagating the docking object to the recipient individual partially replicated database if the owner thereof has visibility to the data being transmitted in the single logical docking object.

8. A program storage device readable by a machine, tangibly embodying a program of instructions executable by a machine to perform method steps for maintaining a database having a central database and a plurality of individual partially replicated databases at individual nodes, wherein updates made to the central database or to one of the individual, partially replicated databases at one of the individual nodes are selectively propagated to a recipient partially replicated database at an individual node if the owner of the recipient partially replicated database has visibility to the data being selectively transmitted, said method steps comprising:

(a) finding an unprocessed transaction for an individual partially replicated database whose partial transaction is being processed;

(b) determining if any additional unprocessed transaction transactions remain at said individual partially replicated database;

(c) returning to step (a) if any additional unprocessed transactions remain at said individual partially replicated database;

(d) otherwise selecting a transaction for processing;

(e) writing a record for the transaction to a partial transaction log for the individual partially replicated database; and

(f) updating a last record extracted log.

9. A method of maintaining a database having a central database and a plurality of individual partially replicated database, comprising the steps of:

(a) updating at least one of a group of database records;

(b) replicating the group of database records as a logical docking object;

(c) applying visibility rules to data content of the logical docking unit;

(d) determining whether an owner of a potential recipient partially replicated database has visibility to the data content of the logical docking object; and

(e) propagating the logical docking object to the recipient individual partially replicated database if the determination of step (d) is affirmative.