Replicating DDL changes using streams

• US 7,031,974 B1
• Filed: 12/02/2002
• Issued: 04/18/2006
• Est. Priority Date: 08/01/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Subramaniam, Mahesh
• Primary Examiner(s): MIZRAHI, DIANE D
• Application Number:
  US10/308,851
• Time in Patent Office: 1,233 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-205, 370/389, 713/162
• 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

Techniques are disclosed for sharing information in a wide variety of contexts. An information sharing system is described that allows both an explicit capture process and an implicit capture process to add information items to a staging area. Further, the information sharing system supports both implicit and explicit consumption of information items that are stored in said staging area. A rules engine is provided to allow users to create and register rules that customize the behavior of the capture processes, the consuming processes, and propagation processes that propagate information from the staging areas to designated destinations. Techniques are also described for achieving exactly-once handling of sequence of items, where the items are maintained in volatile memory. Techniques are also provided for recording DDL operations, and for asynchronously performing operations based on the previously-performed DDL operations.

Claims

1. A method for responding to DDL operations associated with a database object, the method comprising the steps of:

in response to execution of a DDL statement associated with a database object, generating a record that indicates changes made by said DDL statement; and

based on said record, performing an action that is asynchronous relative to execution of said DDL statement.

2. The method of claim 1 wherein:

said record includes dependency information;

the method includes the further steps of

using said dependency information to determine which other actions are dependent on said action; and

performing said action concurrently with other actions that are not dependent on said action.

3. The method of claim 1 wherein:

the step of performing an action includes causing a corresponding change to be made; and

said corresponding change is made relative to a replica of said database object.

4. The method of claim 3 wherein the step of causing a corresponding change is performed without quiescing any database involved in replication of the database object.

5. The method of claim 3 wherein the step of causing a corresponding change is performed without restricting user activity in any database involved in replication of the database object.

6. The method of claim 3 wherein the execution of said DDL statement causes creation of said database object, and said corresponding change causes creation of said replica.

7. The method of claim 3 wherein execution of the DDL statement changes how the database object is structured, and said corresponding change to causes an alteration in a structure of said replica.

8. The method of claim 3 wherein the step of generating a record includes storing information in a redo log.

9. The method of claim 8 wherein the step of causing a corresponding

change to be made includes the steps of:

reading the information from the redo log;

based on the information from the redo log, generating change data that indicates how said database object was altered; and

applying said change data to said replica.

10. The method of claim 9 wherein the step of generating the change data is performed asynchronously relative to execution of said DDL statement.

11. The method of claim 8 wherein:

the redo log includes information that identifies changes made to data within said database object; and

the method further includes the steps of changing data contained in said replica based on information from said redo log.

12. The method of claim 9 further comprising the step of storing the change data in a staging area, prior to applying said change data to said replica.

13. The method of claim 12 further comprising the step of reading said change data from said staging area and propagating said change data to a site at which said replica is located.

14. The method of claim 9 wherein the step of generating change data is performed by a capture engine based on a rule set that has been registered by a user.

15. The method of claim 13 wherein the step of propagating said change data is performed by a propagation engine based on a rule set that has been registered by a user.

16. The method of claim 9 wherein the step of applying said change data is performed by an apply engine based on a rule set that has been registered by a user.

17. The method of claim 3 wherein:

the database object is a user object that establishes a new user of a database system;

execution of the DDL statement creates the user object; and

the step of causing a corresponding change to be made includes creating a replica user object in another database system to establish said new user to be a new user of said other database system.

18. The method of claim 3 wherein:

the database object is a set of one or more permissions for a database system;

execution of the DDL statement creates the one or more permissions; and

the step of causing a corresponding change to be made includes creating a replica of said one or more permissions in another database system.

19. The method of claim 3 wherein:

the DDL statement is executed in a first database;

the replica resides in a second database; and

the method further comprises the steps of

in response to execution of a second DDL statement associated with said replica, generating a second record that indicates changes made by said second DDL statement; and

based on said record, causing a second corresponding change to be made, wherein said second corresponding change is made relative to said database object in said first database.

20. The method of claim 3 wherein:

the database object is a type of database object selected from a set that consists of a view, a trigger, a procedure, an index, a sequence, a synonym, a rollback segment, an outline, a database link, a materialized view and a materialized view log;

execution of the DDL statement creates the selected type of database object; and

the step of causing a corresponding change to be made includes creating a replica of said type of database object in another database system.

21. The method of claim 1 wherein:

the DDL statement is executed in a first database system; and

the step of performing an action includes sending a message to a second database system that is different from said first database system.

22. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 1.

23. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 2.

24. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 3.

25. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 4.

26. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 5.

27. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 6.

28. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 7.

29. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 8.

30. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 9.

31. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 10.

32. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 11.

33. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 12.

34. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 13.

35. A computer-readable storage medium storing instructions having stored reon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 14.

36. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 15.

37. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 16.

38. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 17.

39. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 18.

40. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 19.

41. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 20.

42. A computer-readable storage medium storing instructions having stored thereon instructions which, when executed by one or more processors, cause the one or more processors to perform the method recited in claim 21.