US5799306A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for facilitating data replication using object groups
Assignee: Oracle International Corp
•
Filing: 1996-06-21
•
Granted: 1998-08-25
•
Expires: 2016-06-21
Abstract
Abstract A method and apparatus for replicating data in a computer system having a plurality of sites is provided. Data stored at a first site is organized as one or more sets of formatted data. A mapping is created between subsets of data within the sets of formatted data and one or more object groups. These logical mappings to object groups allow distribution of the subsets of data at a finer level of granularity than previously provided and allow the subsets of data to potentially span multiple sets of formatted data. For each of the object groups, a replica of each subset of data that is mapped to the object group is created at one or more replication sites. When a data modification is detected to a subset of data that has been mapped to one of the one or more object groups, the data modification is propagated to the corresponding replication sites.
Inventors
- 👤 Harry Sun
- 👤 Benny Souder
- 👤 Peter Lim
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-01 23:30
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/27; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 25
Claim 1
Independent Claim
167 words
In a computer system comprising a plurality of sites, a method of replicating data that is stored at a first site of said plurality of sites, said data belonging to one or more schemas, said method comprising the computer-implemented steps of: creating a mapping between subsets of data within said one or more schemas and one or more object groups; specifying one or more replication sites for each of said one or more object groups; for each of said one or more object groups, creating at the one or more replication sites for said object group a replica of each subset of data that is mapped to said object group; detecting at said first site a data modification to a particular subset of data within said one or more schemas; and if said particular subset of data has been mapped to an object group of said one or more object groups, then propagating said data modification to the one or more replication sites of said object group.
Claim 2
Dependent Claim
167 words
In a computer system comprising a plurality of sites, a method of replicating data that is stored at a first site of said plurality of sites, said data belonging to one or more schemas, said method comprising the computer-implemented steps of: creating a mapping between subsets of data within said one or more schemas and one or more object groups; specifying one or more replication sites for each of said one or more object groups; for each of said one or more object groups, creating at the one or more replication sites for said object group a replica of each subset of data that is mapped to said object group; detecting at said first site a data modification to a particular subset of data within said one or more schemas; and if said particular subset of data has been mapped to an object group of said one or more object groups, then propagating said data modification to the one or more replication sites of said object group.
Claim 3
Dependent Claim
73 words
The method of claim 1 wherein: said one or more schemas includes a first schema and a second schema; and the step of creating a mapping includes the steps of mapping said first subset of data to a first object group, said first subset of data residing in said first schema, and mapping a second subset of data to said first object group, said second subset of data residing in said second schema.
Claim 4
Dependent Claim
24 words
The method of claim 1 wherein said step of creating a mapping includes: maintaining an object groups table, and maintaining a replicated objects table.
Claim 5
Dependent Claim
67 words
The method of claim 3 further comprising the steps of: receiving a first input that identifies an object group; adding an object group record to said object groups table, said object group record identifying said object group; receiving a second input that identifies a subset of data; and adding a replicated object record to said replicated objects table, said replicated object record identifying said subset of data.
Claim 6
Dependent Claim
29 words
The method of claim 1 further comprising the step of generating one or more replication support objects for at least one of said one or more subsets of data.
Claim 7
Dependent Claim
20 words
The method of claim 5, wherein the step of generating one or more replication support objects includes generating a trigger.
Claim 8
Dependent Claim
85 words
The method of claim 1 further comprising the steps of: designating a first replication site as a master site to receive propagated data modifications corresponding to replicas stored at said first replication site immediately upon detection of said data modifications or at predetermined time-based intervals; and designating a second replication site as a snapshot site to receive propagated data modifications corresponding to replicas stored at said second replication site, said propagated data modifications sent from said master site at predetermined time-based intervals or on demand.
Claim 9
Dependent Claim
162 words
A machine-readable medium that has stored thereon one or more sequences of instructions, the one or more sequences of instructions including instructions which, when executed by a processor, cause said processor to perform the steps of: creating a mapping between subsets of data within said one or more schemas and one or more object groups; specifying one or more replication sites for each of said one or more object groups; for each of said one or more object groups, creating at the one or more replication sites for said object group a replica of each subset of data that is mapped to said object group; detecting at said first site a data modification to a particular subset of data within said one or more schemas; and if said particular subset of data has been mapped to an object group of said one or more object groups, then propagating said data modification to the one or more replication sites of said object group.
Claim 10
Dependent Claim
162 words
A machine-readable medium that has stored thereon one or more sequences of instructions, the one or more sequences of instructions including instructions which, when executed by a processor, cause said processor to perform the steps of: creating a mapping between subsets of data within said one or more schemas and one or more object groups; specifying one or more replication sites for each of said one or more object groups; for each of said one or more object groups, creating at the one or more replication sites for said object group a replica of each subset of data that is mapped to said object group; detecting at said first site a data modification to a particular subset of data within said one or more schemas; and if said particular subset of data has been mapped to an object group of said one or more object groups, then propagating said data modification to the one or more replication sites of said object group.
Claim 11
Dependent Claim
74 words
The machine-readable medium of claim 8 wherein: said one or more schemas includes a first schema and a second schema; and the step of creating a mapping includes: the steps of mapping said first subset of data to a first object group, said first subset of data residing in said first schema, and mapping a second subset of data to said first object group, said second subset of data residing in said second schema.
Claim 12
Dependent Claim
25 words
The machine-readable medium of claim 9 wherein said step of creating a mapping includes: maintaining an object groups table, and maintaining a replicated objects table.
Claim 13
Dependent Claim
69 words
The machine-readable medium of claim 10, further including sequences of instructions for: receiving a first input that identifies an object group; adding an object group record to said object groups table, said object group record identifying said object group; receiving a second input that identifies a subset of data; and adding a replicated object record to said replicated objects table, said replicated object record identifying said subset of data.
Claim 14
Dependent Claim
78 words
The machine-readable medium of claim 8 further comprising the steps of: designating a first replication site as a master site to receive propagated data modifications corresponding to replicas stored at said first replication site immediately upon detection of said data modifications; and designating a second replication site as a snapshot site to receive propagated data modifications corresponding to replicas stored at said second replication site, said propagated data modifications sent from said master site at predetermined time-based intervals.
Claim 15
Dependent Claim
31 words
The machine-readable medium of claim 8, further including sequences of instructions for generating one or more replication support objects for at least one of said one or more subsets of data.
Claim 16
Dependent Claim
21 words
The machine-readable medium of claim 13, wherein the step of generating one or more replication support objects includes generating a trigger.
Claim 17
Dependent Claim
81 words
A machine-readable medium that has stored thereon one or more sequences of instructions, the one or more sequences of instructions including instructions which, when executed by a processor, cause said processor to perform the steps of: mapping a subset of data that resides in a particular schema to an object group; mapping said object group to one or more sites of said plurality of sites; and creating replicas of said subset of data at each of said one or more sites.
Claim 18
Dependent Claim
81 words
A machine-readable medium that has stored thereon one or more sequences of instructions, the one or more sequences of instructions including instructions which, when executed by a processor, cause said processor to perform the steps of: mapping a subset of data that resides in a particular schema to an object group; mapping said object group to one or more sites of said plurality of sites; and creating replicas of said subset of data at each of said one or more sites.
Claim 19
Dependent Claim
56 words
The machine-readable medium of claim 15 further including instructions for performing the step of mapping at least two subsets of data to said object group, the first of said at least two subsets of data corresponding to a first schema and the second of said at least two subsets of data corresponding to a second schema.
Claim 20
Dependent Claim
134 words
In a computer system comprising a plurality of sites, a method of configuring an environment for providing data replication, said method comprising the computer-implemented steps of: creating one or more replicated object groups at a first site; maintaining a set of replicated object groups, said set of replicated object groups including said one or more replicated object groups; maintaining a set of replicated objects for each of said one or more replicated object groups; maintaining one or more groups of formatted data; adding one or more replicated objects to said one or more replicated object groups to register said one or more replicated objects for replication, said one or more replicated objects corresponding to data from one or more schemas; and creating replicas of said one or more replicated objects at a second site.
Claim 21
Dependent Claim
134 words
In a computer system comprising a plurality of sites, a method of configuring an environment for providing data replication, said method comprising the computer-implemented steps of: creating one or more replicated object groups at a first site; maintaining a set of replicated object groups, said set of replicated object groups including said one or more replicated object groups; maintaining a set of replicated objects for each of said one or more replicated object groups; maintaining one or more groups of formatted data; adding one or more replicated objects to said one or more replicated object groups to register said one or more replicated objects for replication, said one or more replicated objects corresponding to data from one or more schemas; and creating replicas of said one or more replicated objects at a second site.
Claim 22
Dependent Claim
55 words
The method of claim 17 further comprising the step of: adding at least two replicated objects to one of said one or more replicated object groups, the first of said at least two replicated objects corresponding to a first schema and the second of said at least two replicated objects corresponding to a second schema.
Claim 23
Dependent Claim
32 words
The method of claim 17 further comprising the step of: maintaining a set of generated objects for each of said one or more replicated objects, said generated objects for supporting data replication.
Claim 24
Dependent Claim
27 words
The method of claim 17 further comprising the step of: maintaining a set of destinations to which each of said one or more replicated objects is replicated.
Claim 25
Dependent Claim
56 words
The method of claim 17 wherein: said step of maintaining a set of replicated object groups includes maintaining an object groups table in a data dictionary; and said step of maintaining a set of replicated objects for each of said one or more replicated object groups includes maintaining a replicated objects table in said data dictionary.
References Cited (Backward Citations)
US5129082A
Cited
US5291583A
Cited
US5559991A
Cited
US5615364A
Cited
US5596744A
Cited
US5560005A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-08-24 | 2002-02-23 | 2002-08-25 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-08-24 | 2006-02-23 | 2006-08-25 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-08-24 | 2010-02-23 | 2010-08-25 | $7700.00 | Window Closed / Lapsed |