Patent US6178425B1 successfully refreshed from Google Patents.
US6178425B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method of determining the visibility to a remote database client of a plurality of database transactions using simplified visibility rules
Assignee: Oracle America Inc
•
Filing: 1999-08-18
•
Granted: 2001-01-23
•
Expires: 2019-08-18
Abstract
Abstract Database management method and system, for a database having a central database and a plurality of partially replicated databases. The database management method and system determine the visibility of a user of a separate replicated database to the central database from a set of visibility rules stored at a central location.
Inventors
- 👤 Robert S. Brodersen
- 👤 Peter S. Lim
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 15:09
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99942; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 30
Claim 1
Independent Claim
208 words
A method of managing a database, said database including: a) a central database ( 3 ) residing on a server ( 1 ) and b) separate partially replicated databases ( 23 a, 23 b, 23 c ), said separate partially replicated databases residing on separate clients ( 21 a, 21 b, 21 c ) and having separate users ( 33 a, 33 b, 33 c ), said method comprising i) determining from a set of visibility rules stored at a central location, the visibility of a user ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) at a separate client ( 21 a, 21 b, 21 c ) to data being propagated from the server ( 1 ), and ii) propagating said data from the server ( 1 ) to a partially replicated database ( 23 a, 23 b, 23 c ) on the separate client ( 21 a, 21 b, 21 c ) only if the user ( 33 a, 33 b, 33 c ) of the partially replicated database ( 23 a, 23 b, 23 c ) on the separate client ( 21 a, 21 b, 21 c ) has visibility to the data.
Claim 2
Independent Claim
208 words
A method of managing a database, said database including: a) a central database ( 3 ) residing on a server ( 1 ) and b) separate partially replicated databases ( 23 a, 23 b, 23 c ), said separate partially replicated databases residing on separate clients ( 21 a, 21 b, 21 c ) and having separate users ( 33 a, 33 b, 33 c ), said method comprising i) determining from a set of visibility rules stored at a central location, the visibility of a user ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) at a separate client ( 21 a, 21 b, 21 c ) to data being propagated from the server ( 1 ), and ii) propagating said data from the server ( 1 ) to a partially replicated database ( 23 a, 23 b, 23 c ) on the separate client ( 21 a, 21 b, 21 c ) only if the user ( 33 a, 33 b, 33 c ) of the partially replicated database ( 23 a, 23 b, 23 c ) on the separate client ( 21 a, 21 b, 21 c ) has visibility to the data.
Claim 3
Dependent Claim
17 words
The method of claim 1 where the set of visibility rules is stored at a single location.
Claim 4
Dependent Claim
38 words
The method of claim 2 comprising recursively determining the visibility of a user ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) that is being updated.
Claim 5
Dependent Claim
59 words
The method of claim 1 comprising determining the visibility of a user ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) that is not being updated but that is related to a partially replicated database ( 23 a, 23 b, 23 c ) that is being updated.
Claim 6
Dependent Claim
36 words
The method of claim 1 wherein the visibility of a node ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) is in declarative form.
Claim 7
Dependent Claim
40 words
The method of claim 1 comprising storing in cache memory the visibility of a node ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) to data being propagated.
Claim 8
Dependent Claim
38 words
The method of claim 1 wherein the said nodes ( 33 a, 33 b, 33 c ) of the partially replicated databases ( 23 a, 23 b, 23 c ) have a visibility strength to data being propagated.
Claim 9
Dependent Claim
18 words
The method of claim 1 comprising storing at least one set of visibility rules in a single location.
Claim 10
Dependent Claim
38 words
The method of claim 1 comprising storing the visibility rules against the data content of a related docking object that is not to be updated to determine the visibility of a docking object that is to be updated.
Claim 11
Dependent Claim
16 words
The method of claim 9 comprising using a graphical user interface to change the visibility rules.
Claim 12
Dependent Claim
33 words
The method of claim 1 comprising storing visibility rules by storing them in a central dictionary, to allow the nodes ( 33 a, 33 b, 33 c ) to change the visibility rules.
Claim 13
Dependent Claim
16 words
The method of claim 1 comprising using a graphical user interface to change the visibility rules.
Claim 14
Dependent Claim
113 words
An article of manufacture comprising computer usable media having computer usable program code embodied therein for managing a database including a central database residing on a server ( 1 ) and one or more partially replicated databases ( 23 a, 23 b, 23 c ) residing on one or more clients ( 21 a, 21 b, 21 c ) by determining the visibility of a user of the partially replicated database at a client ( 21 a, 21 b, 21 c ) to data in the database on the server ( 1 ) from a set of visibility rules stored at a single location and propagating visibility of the data in accordance therewith.
Claim 15
Dependent Claim
113 words
An article of manufacture comprising computer usable media having computer usable program code embodied therein for managing a database including a central database residing on a server ( 1 ) and one or more partially replicated databases ( 23 a, 23 b, 23 c ) residing on one or more clients ( 21 a, 21 b, 21 c ) by determining the visibility of a user of the partially replicated database at a client ( 21 a, 21 b, 21 c ) to data in the database on the server ( 1 ) from a set of visibility rules stored at a single location and propagating visibility of the data in accordance therewith.
Claim 16
Dependent Claim
176 words
A plurality of program storage devices readable by a machine, tangibly embodying a program of instructions executable by a machine to perform method steps for managing a database residing at a server ( 1 ) and including one or more replicated databases residing at separate clients ( 21 a, 21 b, 21 c ), said method steps comprising: a) determining from the set of visibility rules, stored at a single location, the visibility of the user ( 33 a, 33 b, 33 c ) of the partially replicated database ( 23 a, 23 b, 23 c ) at a separate client ( 21 a, 21 b, 21 c ) to data being propagated at the server, and b) 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 ) at the separate client ( 21 a, 21 b, 21 c ) has visibility to the data.
Claim 17
Dependent Claim
176 words
A plurality of program storage devices readable by a machine, tangibly embodying a program of instructions executable by a machine to perform method steps for managing a database residing at a server ( 1 ) and including one or more replicated databases residing at separate clients ( 21 a, 21 b, 21 c ), said method steps comprising: a) determining from the set of visibility rules, stored at a single location, the visibility of the user ( 33 a, 33 b, 33 c ) of the partially replicated database ( 23 a, 23 b, 23 c ) at a separate client ( 21 a, 21 b, 21 c ) to data being propagated at the server, and b) 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 ) at the separate client ( 21 a, 21 b, 21 c ) has visibility to the data.
Claim 18
Independent Claim
209 words
A system for managing a database, said database including; a) a central database ( 3 ) residing on a server ( 1 ) and b) separate partially replicated databases ( 23 a, 23 b, 23 c ), said separate partially replicated databases residing on separate clients ( 21 a, 21 b, 21 c ) and having separate users ( 33 a, 33 b, 33 c ), said system configured to: i) determine from a set of visibility rules stored at a central location, the visibility of a user ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) at a separate client ( 21 a, 21 b, 21 c ) to data being propagated from the server ( 1 ), and ii) propagate said data from the server ( 1 ) to a partially replicated database ( 23 a, 23 b, 23 c ) on the separate client ( 21 a, 21 b, 21 c ) only if the user ( 33 a, 33 b, 33 c ) of the partially replicated database ( 23 a, 23 b, 23 c ) on the separate client ( 21 a, 21 b, 21 c ) has visibility to the data.
Claim 19
Independent Claim
209 words
A system for managing a database, said database including; a) a central database ( 3 ) residing on a server ( 1 ) and b) separate partially replicated databases ( 23 a, 23 b, 23 c ), said separate partially replicated databases residing on separate clients ( 21 a, 21 b, 21 c ) and having separate users ( 33 a, 33 b, 33 c ), said system configured to: i) determine from a set of visibility rules stored at a central location, the visibility of a user ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) at a separate client ( 21 a, 21 b, 21 c ) to data being propagated from the server ( 1 ), and ii) propagate said data from the server ( 1 ) to a partially replicated database ( 23 a, 23 b, 23 c ) on the separate client ( 21 a, 21 b, 21 c ) only if the user ( 33 a, 33 b, 33 c ) of the partially replicated database ( 23 a, 23 b, 23 c ) on the separate client ( 21 a, 21 b, 21 c ) has visibility to the data.
Claim 20
Dependent Claim
17 words
The system of claim 15 wherein the set of visibility rules is stored at a single location.
Claim 21
Dependent Claim
44 words
The system of claim 16 wherein the system is further configured to recursively determine the visibility of a user ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) that is being updated.
Claim 22
Dependent Claim
65 words
The system of claim 15 wherein the system is further configured to determine the visibility of a user ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) that is not being updated but that is related to a partially replicated database ( 23 a, 23 b, 23 c ) that is being updated.
Claim 23
Dependent Claim
36 words
The system of claim 15 wherein the visibility of a node ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) is in declarative form.
Claim 24
Dependent Claim
46 words
The system of claim 15 wherein the system is further configured to store in cache memory the visibility of a node ( 33 a, 33 b, 33 c ) of a partially replicated database ( 23 a, 23 b, 23 c ) to data being propagated.
Claim 25
Dependent Claim
37 words
The system of claim 15 wherein the nodes ( 33 a, 33 b, 33 c ) of the partially replicated databases ( 23 a, 23 b, 23 c ) have a visibility strength to data being propagated.
Claim 26
Dependent Claim
24 words
The system of claim 15 wherein the system is further configured to store at least one set of visibility rules in a single location.
Claim 27
Dependent Claim
44 words
The system of claim 15 wherein the system is further configured to store the visibility rules against the data content of a related docking object that is not to be updated to determine the visibility of a docking object that is to be updated.
Claim 28
Dependent Claim
22 words
The system of claim 23 wherein the system is further configured to use a graphical user interface to change the visibility rules.
Claim 29
Dependent Claim
36 words
The system of claim 15 wherein the system is further configured to store visibility rules in a central dictionary, and allow the nodes ( 33 a, 33 b, 33 c ) to change the visibility rules.
Claim 30
Dependent Claim
22 words
The system of claim 15 wherein the system is further configured to use a graphical user interface to change the visibility rules.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2004-01-23 | 2004-07-24 | 2005-01-23 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2008-01-23 | 2008-07-24 | 2009-01-23 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2012-01-23 | 2012-07-24 | 2013-01-23 | $7700.00 | Window Closed / Lapsed |