US20030135523A1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method of using cache to determine the visibility to a remote database client of a plurality of database transactions
Assignee: Individual
•
Filing: 2002-07-25
•
Granted: —
•
Expires: 2022-07-25
Abstract
Abstract Updates made to a central database ( 3 ) or to another partially replicated database ( 23 - 1 ) are selectively propagated to a partially replicated database ( 23 - 2 ) if the owner of the partially replicated database ( 23 - 2 ) is deemed to have visibility to the data being updated. Visibility is determined by use of predetermined rules stored in a rules database. Stored rules are assessed against data content of various tables that make up a logical entity, known as a docking object that is being updated. The stored rules are assessed against data content of various tables that make up a docking object, not necessarily being the docking object that is being updated. The visibility rules of these related docking objects are recursively determined. Changes in visibility are determined to enable the central computer to direct the nodes to insert the docking object into its partially replicated database. The predetermined rules are in a declarative form and specify visibility of data based upon structure of the data without reference to data content. Database objects and transactions have an associated visibility strength used to determine the visibility of a transaction to an object.
Inventors
- 👤 Robert Brodersen
- 👤 Peter Lim
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-06 05:24
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; G06F16/278; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99936; Y10S707/99941; Y10S707/99942; Y10S707/99951; Y10S707/99952
Claims Analysis
Total Claims: 6
Claim 1
Independent Claim
180 words
1 . A method of managing a database, said database including a central database and separate partially replicated databases ( 23 a , 23 b , 23 c ), said separate partially replicated databases ( 23 a , 23 b , 23 c ) having separate users ( 33 a , 33 b , 33 c ), comprising determining the visibility of a user ( 33 a , 33 b , 33 c ) of a partially replicated database ( 23 a , 23 b , 23 c ) to data being propagated, storing in cache memory the visibility of the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ), and propagating said data to the partially replicated database ( 23 a , 23 b , 23 c ) only if the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) has visibility to the data.
Claim 2
Dependent Claim
180 words
1 . A method of managing a database, said database including a central database and separate partially replicated databases ( 23 a , 23 b , 23 c ), said separate partially replicated databases ( 23 a , 23 b , 23 c ) having separate users ( 33 a , 33 b , 33 c ), comprising determining the visibility of a user ( 33 a , 33 b , 33 c ) of a partially replicated database ( 23 a , 23 b , 23 c ) to data being propagated, storing in cache memory the visibility of the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ), and propagating said data to the partially replicated database ( 23 a , 23 b , 23 c ) only if the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) has visibility to the data.
Claim 3
Dependent Claim
324 words
2 . An article of manufacture comprising a computer usable medium having computer usable program code embodied therein for managing a partially replicated database ( 23 a , 23 b , 23 c ) by determining the visibility of a user ( 33 a , 33 b , 33 c ) of a partially replicated database ( 23 a , 23 b , 23 c ) to data being propagated, storing in cache memory the visibility of the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ), and propagating said data to a partially replicated database ( 23 a , 23 b , 23 c ) only if the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) has visibility to the data, the computer readable program means in said article of manufacture comprising: computer readable program code means for causing a computer to effect determining the visibility of a user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) to data being propagated; and computer readable program code means for causing the computer to effect storing in cache memory the visibility of the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ); and computer readable program code means for causing a computer to effect propagating said data to the partially replicated database ( 23 a , 23 b , 23 c ) only if the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) has visibility to the data.
Claim 4
Dependent Claim
324 words
2 . An article of manufacture comprising a computer usable medium having computer usable program code embodied therein for managing a partially replicated database ( 23 a , 23 b , 23 c ) by determining the visibility of a user ( 33 a , 33 b , 33 c ) of a partially replicated database ( 23 a , 23 b , 23 c ) to data being propagated, storing in cache memory the visibility of the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ), and propagating said data to a partially replicated database ( 23 a , 23 b , 23 c ) only if the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) has visibility to the data, the computer readable program means in said article of manufacture comprising: computer readable program code means for causing a computer to effect determining the visibility of a user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) to data being propagated; and computer readable program code means for causing the computer to effect storing in cache memory the visibility of the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ); and computer readable program code means for causing a computer to effect propagating said data to the partially replicated database ( 23 a , 23 b , 23 c ) only if the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) has visibility to the data.
Claim 5
Dependent Claim
154 words
3 . A program storage device readable by a machine, tangibly embodying a program of instructions executable by a machine to perform method steps for managing a database, said method steps comprising determining the visibility of a user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) to data being propagated, storing in cache memory the visibility of the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ), and propagating said data to the partially replicated database ( 23 a , 23 b , 23 c ) only if the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) has visibility to the data.
Claim 6
Dependent Claim
154 words
3 . A program storage device readable by a machine, tangibly embodying a program of instructions executable by a machine to perform method steps for managing a database, said method steps comprising determining the visibility of a user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) to data being propagated, storing in cache memory the visibility of the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ), and propagating said data to the partially replicated database ( 23 a , 23 b , 23 c ) only if the user ( 33 a , 33 b , 33 c ) of the partially replicated database ( 23 a , 23 b , 23 c ) has visibility to the data.
References Cited (Backward Citations)
No citation records indexed.
USPTO Annuity & Maintenance Windows
Maintenance schedule is calculated for granted US utility patents.