US5873096A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method of maintaining a network of partially replicated database system
Assignee: Oracle America Inc
•
Filing: 1997-10-08
•
Granted: 1999-02-16
•
Expires: 2017-10-08
Abstract
Abstract A partially replicated database is maintained so that updates made to a central database, or to another partially replicated database, are selectively propagated to the partially replicated database. Updates are propagated to a partially replicated database if the owner of the partially replicated database has "visibility" to the data being updated. Visibility is determined by using predetermined rules stored in a rules database. Typically, the stored rules are assessed against data content of a plurality of tables making up a single logical entity, known as a docking object, that is being updated.
Inventors
- 👤 Peter S. Lim
- 👤 Robert Broderson
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-01 08:14
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99935; Y10S707/99941; Y10S707/99942; Y10S707/99943; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 33
Claim 1
Independent Claim
181 words
A method of selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having partially replicated databases, comprising the steps of: (a) encoding the transaction in a docking object representing the transaction and including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the docking object is visible to a particular node, said visibility rule including either: (1) a set of statements that are evaluated to determine if any data meeting criteria specified in the statements exists in the docking object, or (2) a pointer to another docking object containing a set of statements to be evaluated as in (1)(a); (b) selecting a node; (c) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (d) selectively transmitting the transaction to the selected node depending on whether the particular instance of the docking object is visible to the selected node.
Claim 2
Independent Claim
181 words
A method of selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having partially replicated databases, comprising the steps of: (a) encoding the transaction in a docking object representing the transaction and including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the docking object is visible to a particular node, said visibility rule including either: (1) a set of statements that are evaluated to determine if any data meeting criteria specified in the statements exists in the docking object, or (2) a pointer to another docking object containing a set of statements to be evaluated as in (1)(a); (b) selecting a node; (c) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (d) selectively transmitting the transaction to the selected node depending on whether the particular instance of the docking object is visible to the selected node.
Claim 3
Dependent Claim
22 words
The method of claim 1 in which the visibility rule is a set of one or more Structured Query Language (SQL) statements.
Claim 4
Dependent Claim
15 words
The method of claim 1 in which the partially replicated database is a relational database.
Claim 5
Dependent Claim
18 words
The method of claim 1 in which the selected node is intermittently in communication with the central database.
Claim 6
Independent Claim
155 words
A method of selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having partially replicated databases, comprising the steps of: (a) encoding the transaction in a primary docking object, said primary docking object representing the transaction and indicative of at least one related docking object, said related docking object including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the primary docking object is visible to a particular node; (b) selecting the related docking object; (c) selecting a node; (d) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (e) selectively transmitting the transaction to the selected node if the particular instance of the docking object is visible to the selected node.
Claim 7
Independent Claim
155 words
A method of selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having partially replicated databases, comprising the steps of: (a) encoding the transaction in a primary docking object, said primary docking object representing the transaction and indicative of at least one related docking object, said related docking object including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the primary docking object is visible to a particular node; (b) selecting the related docking object; (c) selecting a node; (d) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (e) selectively transmitting the transaction to the selected node if the particular instance of the docking object is visible to the selected node.
Claim 8
Dependent Claim
19 words
The method of claim 5 in which the visibility rule is a set of one or more SQL statements.
Claim 9
Dependent Claim
15 words
The method of claim 5 in which the partially replicated database is a relational database.
Claim 10
Dependent Claim
18 words
The method of claim 5 in which the selected node is intermittently in communication with the central database.
Claim 11
Dependent Claim
33 words
The method of claim 5 in which said related docking object is indicative of an additional related docking object and steps (a) through (d) are recursively performed for said additional related docking object.
Claim 12
Dependent Claim
195 words
A computer program product for selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having partially replicated databases, comprising a computer usable medium having machine readable code embodied therein for performing the steps of: (a) encoding the transaction in a docking object representing the transaction and including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the docking object is visible to a particular node, said visibility rule including either: (1) a set of statements that are evaluated to determine if any data meeting criteria specified in the statements exists in the docking object, or (2) a pointer to another docking object containing a set of statements to be evaluated as in (1)(a); (b) selecting a node; (c) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (d) selectively transmitting the transaction to the selected node depending on whether the particular instance of the docking object is visible to the selected node.
Claim 13
Dependent Claim
195 words
A computer program product for selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having partially replicated databases, comprising a computer usable medium having machine readable code embodied therein for performing the steps of: (a) encoding the transaction in a docking object representing the transaction and including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the docking object is visible to a particular node, said visibility rule including either: (1) a set of statements that are evaluated to determine if any data meeting criteria specified in the statements exists in the docking object, or (2) a pointer to another docking object containing a set of statements to be evaluated as in (1)(a); (b) selecting a node; (c) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (d) selectively transmitting the transaction to the selected node depending on whether the particular instance of the docking object is visible to the selected node.
Claim 14
Dependent Claim
21 words
The computer program product of claim 10 in which the visibility rule is a set of one or more SQL statements.
Claim 15
Dependent Claim
17 words
The computer program product of claim 10 in which the partially replicated database is a relational database.
Claim 16
Dependent Claim
20 words
The computer program product of claim 10 in which the selected node is intermittently in communication with the central database.
Claim 17
Dependent Claim
195 words
A computer program product for selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having partially replicated databases, comprising a computer usable medium having machine readable code embodied therein for performing the steps of: (a) encoding the transaction in a docking object representing the transaction and including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the docking object is visible to a particular node, said visibility rule including either: (1) a set of statements that are evaluated to determine if any data meeting criteria specified in the statements exists in the docking object, or (2) a pointer to another docking object containing a set of statements to be evaluated as in (1)(a); (b) selecting a node; (c) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (d) selectively transmitting the transaction to the selected node depending on whether the particular instance of the docking object is visible to the selected node.
Claim 18
Dependent Claim
195 words
A computer program product for selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having partially replicated databases, comprising a computer usable medium having machine readable code embodied therein for performing the steps of: (a) encoding the transaction in a docking object representing the transaction and including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the docking object is visible to a particular node, said visibility rule including either: (1) a set of statements that are evaluated to determine if any data meeting criteria specified in the statements exists in the docking object, or (2) a pointer to another docking object containing a set of statements to be evaluated as in (1)(a); (b) selecting a node; (c) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (d) selectively transmitting the transaction to the selected node depending on whether the particular instance of the docking object is visible to the selected node.
Claim 19
Dependent Claim
21 words
The computer program product of claim 14 in which the visibility rule is a set of one or more SQL statements.
Claim 20
Dependent Claim
17 words
The computer program product of claim 14 in which the partially replicated database is a relational database.
Claim 21
Dependent Claim
20 words
The computer program product of claim 14 in which the selected node is intermittently in communication with the central database.
Claim 22
Dependent Claim
35 words
The computer program product of claim 14 in which said related docking object is indicative of an additional related docking object and steps (a) through (d) are recursively performed for said additional related docking object.
Claim 23
Independent Claim
149 words
An apparatus for selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having partially replicated databases, comprising: (a) a processor; and (b) a memory in communication with the processor, wherein the processor is configured to perform the steps of: (i) encoding the transaction in a docking object representing the transaction and including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the docking object is visible to the node; (ii) selecting a node; (iii) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (iv) selectively transmitting the transaction to the selected node if the particular instance of the docking object is visible to the selected node.
Claim 24
Independent Claim
149 words
An apparatus for selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having partially replicated databases, comprising: (a) a processor; and (b) a memory in communication with the processor, wherein the processor is configured to perform the steps of: (i) encoding the transaction in a docking object representing the transaction and including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the docking object is visible to the node; (ii) selecting a node; (iii) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (iv) selectively transmitting the transaction to the selected node if the particular instance of the docking object is visible to the selected node.
Claim 25
Dependent Claim
19 words
The apparatus of claim 19 in which the visibility rule is a set of one or more SQL statements.
Claim 26
Dependent Claim
15 words
The apparatus of claim 19 in which the partially replicated database is a relational database.
Claim 27
Dependent Claim
18 words
The apparatus of claim 19 in which the selected node is intermittently in communication with the central database.
Claim 28
Independent Claim
165 words
An apparatus for selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having replicated databases, comprising: (a) a processor; and (b) a memory in communication with the processor, wherein the processor is configured to perform the steps of: (i) encoding the transaction in a primary docking object, said primary docking object representing the transaction and indicative of at least one related docking object, said related docking object including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the docking object is visible to the node; (ii) selecting a node; (iii) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (iv) selectively transmitting the transaction to the selected node if the particular instance of the docking object is visible to the selected node.
Claim 29
Independent Claim
165 words
An apparatus for selectively transmitting a transaction from a central database to at least one node having a partially replicated database out of a plurality of nodes having replicated databases, comprising: (a) a processor; and (b) a memory in communication with the processor, wherein the processor is configured to perform the steps of: (i) encoding the transaction in a primary docking object, said primary docking object representing the transaction and indicative of at least one related docking object, said related docking object including at least two tables from the central database, one of the tables containing visibility rules controlling whether a particular instance of the docking object is visible to the node; (ii) selecting a node; (iii) executing the visibility rule against the selected node to determine whether the particular instance of the docking object is visible to the selected node; and (iv) selectively transmitting the transaction to the selected node if the particular instance of the docking object is visible to the selected node.
Claim 30
Dependent Claim
13 words
The apparatus of claim 23 in which the rule is an SQL rule.
Claim 31
Dependent Claim
15 words
The apparatus of claim 23 in which the partially replicated database is a relational database.
Claim 32
Dependent Claim
18 words
The apparatus of claim 23 in which the selected node is intermittently in communication with the central database.
Claim 33
Dependent Claim
33 words
The apparatus of claim 23 in which said related docking object is indicative of an additional related docking object and steps (i) through (iv) are recursively performed for said additional related docking object.
References Cited (Backward Citations)
US5291594A
Cited
US5263156A
Cited
US5632031A
Cited
US5317742A
Cited
US5446885A
Cited
US5630127A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-02-15 | 2002-08-17 | 2003-02-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-02-15 | 2006-08-17 | 2007-02-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-02-15 | 2010-08-17 | 2011-02-16 | $7700.00 | Window Closed / Lapsed |