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 single logical docking object which is composed of one or more physical database tables; (b) applying a single 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 single 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 single 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 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 single 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. The method of claim 4 wherein the visibility event is chosen from the group consisting of
(a) the publication of a record contained in the docking object; (b) the publication of a record associated with a record contained in the docking object; and (c) the record being inserted into a distribution table including the said recipient individual partially replicated database.
- 6. The method of claim 4 wherein the visibility event is automatically detected by a log manager.
- 7. 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) 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 (g) if any unprocessed transactions remain.
- 8. The method of claim 6 wherein said node received logs are resident at the individual replicated databases.
- 9. The method of claim 6 wherein said node received logs are resident at the central database.
- 10. 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 nodeif 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.
- 11. An article of manufacture comprising:
a computer usable medium having program code causing a computer to effect 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 computer readable program code in said article of manufacture comprising:
computer readable program code for causing a computer to effect replicating a group or records as a single logical docking object; computer readable program code for causing a computer to effect applying a single set of visibility rules to the data content of the entire logical docking unit, and computer readable program code for causing a computer to effect 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.
- 12. 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.
- 13. An article of manufacture comprising: a computer usable medium having program code causing a computer to effect 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 computer readable program code in said article of manufacture comprising:
(a) computer readable program code for causing a computer to effect entering a new transaction from an individual partially replicated database onto a node received log; (b) computer readable program code for causing a computer to effect searching for unprocessed transaction logged onto node received logs; (c) computer readable program code for causing a computer to effect selecting an unprocessed transaction from a node received log; (d) computer readable program code for causing a computer to effect updating the central database therefrom; (e) computer readable program code for causing a computer to effect journalling the update to the central database to a transaction log; (f) computer readable program code for causing a computer to effect determining if any unprocessed transactions remain; and (g) computer readable program code for causing a computer to effect repeating steps (a) through (g) if any unprocessed transactions remain.
- 14. 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) computer readable program code for causing a computer to effect entering a new transaction from an individual partially replicated database onto a node received log; (b) computer readable program code for causing a computer to effect searching for unprocessed transaction logged onto node received logs; (c) computer readable program code for causing a computer to effect selecting an unprocessed transaction from a node received log; (d) computer readable program code for causing a computer to effect updating the central database therefrom; (e) computer readable program code for causing a computer to effect journalling the update to the central database to a transaction log; (f) computer readable program code for causing a computer to effect determining if any unprocessed transactions remain; and (g) computer readable program code for causing a computer to effect repeating steps (a) through (g) if any unprocessed transactions remain.
- 15. An article of manufacture comprising:
a computer usable medium having program code causing a computer to effect 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, the computer readable program in said article of manufacture comprising:
(a) computer readable program code for causing a computer to effect finding an unprocessed transaction for an individual partially replicated database whose partial transaction is being processed; (b) computer readable program code for causing a computer to effect determining if any additional unprocessed transaction transactions remain at said individual partially replicated database; (c) computer readable program code for causing a computer to effect returning to step (a) if any additional unprocessed transactions remain at said individual partially replicated database; (d) computer readable program code for causing a computer to effect otherwise selecting a transaction for processing; (e) computer readable program code for causing a computer to effect writing a record for the transaction to a partial transaction log for the individual partially replicated database; and (f) computer readable program code for causing a computer to effect updating a last record extracted log.
- 16. 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.
CROSS REFERENCE TO RELATED APPLICATIONS
[0001] This is a continuation-in-part of commonly assigned, copending, U.S. patent application, Ser. No. 08/947,371, filed Oct. 8, 1997, for METHOD OF MAINTAINING A NETWORK OF PARTIALLY REPLICATED DATABASE SYSTEM, which is a continuation-in-part of commonly assigned, U.S. patent application PCT/US97/04320, filed Mar. 19, 1997, for METHOD OF MAINTAINING A NETWORK OF PARTIALLY REPLICATED DATABASE SYSTEM, which, in turn, claimed priority from Provisional patent application, Ser. No. 60/013,677, filed Mar. 19, 1996, for METHOD OF MAINTAINING A NETWORK OF PARTIALLY REPLICATED DATABASE SYSTEM. This is also a continuation-in-part of commonly assigned, copending U.S. patent application PCT/US97/04320, filed Mar. 19, 1997, for METHOD OF MAINTAINING A NETWORK OF PARTIALLY REPLICATED DATABASE SYSTEM, which, in turn, claimed priority from Provisional patent application, Ser. No. 60/013,677, filed Mar. 19, 1996, for METHOD OF MAINTAINING A NETWORK OF PARTIALLY REPLICATED DATABASE SYSTEM.
Provisional Applications (1)
|
Number |
Date |
Country |
|
60013677 |
Mar 1996 |
US |
Continuations (2)
|
Number |
Date |
Country |
Parent |
09220990 |
Dec 1998 |
US |
Child |
09756174 |
Jan 2001 |
US |
Parent |
08947371 |
Oct 1997 |
US |
Child |
09220990 |
Dec 1998 |
US |
Continuation in Parts (1)
|
Number |
Date |
Country |
Parent |
PCT/US97/04320 |
Mar 1997 |
US |
Child |
08947371 |
Oct 1997 |
US |