Utilizing rules in a distributed information sharing system

• US 7,613,741 B2
• Filed: 05/30/2003
• Issued: 11/03/2009
• Est. Priority Date: 08/01/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Bhatt, Neerja, Wang, Wei, Wong, Lik, Stamos, James, Lu, Edwina, Kaluskar, Sanjay
• Primary Examiner(s): Robinson; Greta L
• Application Number:
  US10/449,873
• Publication Number:
  US 20040034618A1
• Time in Patent Office: 2,349 Days
• Field of Search: 707/205, 707/206, 707/8, 707/10, 707200-204, 707/2, 707/3, 707/4, 707/5, 707/101, 707/102, 709/248, 709/216, 709204-207, 709/201, 709/203, 709/208, 706/45, 706/46, 706/47, 706/48, 705/1
• 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/99953 Recoverability

Abstract

Described herein are various approaches that allow rules to be used to specify actions, that alleviate the complexity and burden of developing and maintaining rules in a rules-based messaging system, and that provide more efficient ways of evaluating rules. The approaches allow rules to specify user-defined transformation functions for transforming messages, to specify when and how to perform row migration, and to specify other types of actions. Rules are grouped into rule sets. Several types of rule sets, referred to as positive and negative rule sets, allow users to use rules that are less complex to develop and maintain. Rule sets are evaluated more efficiently by attempting to evaluate the rule set with less information than is needed to evaluate all the rules in the rule set. Also, the results of rules evaluations that are based on a set of values are cached for later retrieval.

Claims

1. A method for controlling a capture process running on a source database server, the method comprising the steps of:

said capture process propagating messages between said source database server and a destination database server;

said capture process scanning one or more records from a redo log that records changes made at said source database server;

said capture process generating a particular message that includes data from said one or more records;

said capture process calling a rules engine to make an evaluation of a set of rules based on said data from said one or more records, wherein each rule of said set of rules is associated with a condition and first data that identifies an action;

for a particular rule of said set of rules whose corresponding condition is satisfied based on said evaluation, said rules engine returning said first data for said particular rule; and

said capture process performing the action identified by the first data returned by said rules engine.

2. The method of claim 1,

wherein the particular message describes an update to a row in a table at the source database server;

and

wherein the action identified is an insertion or deletion of a row in a table at the destination database server.

3. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 2.

4. The method of claim 1, wherein the action is an invocation of a function.

5. The method of claim 4, wherein the function is registered by a user with a database server.

6. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 5.

7. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 4.

8. The method of claim 1, wherein the action is to propagate the particular message to a message queue.

9. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 8.

10. The method of claim 1, wherein the action is a procedure to invoke in conjunction with discarding said particular message.

11. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 10.

12. The method of claim 1, wherein the capture process performs a particular action for said particular message only if said set of rules evaluates to FALSE.

13. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 12.

14. The method claim 1, wherein the capture process performs a particular action for said particular message only if said set of rules evaluates to FALSE and a second set of rules evaluates to TRUE.

15. The method of claim 14, wherein the second set of rules is not evaluated if said set of rules evaluates to TRUE.

16. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 15.

17. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 14.

18. The method of claim 1, wherein:

said set of rules includes multiple rule sets;

said capture process receives evaluation results for each rule set of said multiple rule sets; and

said capture process determines whether to perform a particular action based on a boolean combination of said multiple rule sets.

19. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 18.

20. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 1.