Method and apparatus for facilitating data replication using object groups

• US 5,799,306 A
• Filed: 06/21/1996
• Issued: 08/25/1998
• Est. Priority Date: 06/21/1996
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Lim, Peter, Souder, Benny, Sun, Harry
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Mizrahi, Diane D.
• Application Number:
  US08/667,677
• Time in Patent Office: 795 Days
• Field of Search: 395/614, 395/611, 395/701-10, 395/580, 395/610, 395/617, 364/228.1, 707/10, 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

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.

Claims

1. 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.

2. 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.

3. The method of claim 1 wherein said step of creating a mapping includes:

maintaining an object groups table, and

maintaining a replicated objects table.

4. 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.

5. 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.

6. The method of claim 5, wherein the step of generating one or more replication support objects includes generating a trigger.

7. 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.

8. 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.

9. 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.

10. 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.

11. 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.

12. 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.

13. 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.

14. The machine-readable medium of claim 13, wherein the step of generating one or more replication support objects includes generating a trigger.

15. 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.

16. 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.

17. 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.

18. 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.

19. 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.

20. 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.

21. 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.