Managing event-condition-action rules in a database system

• US 20050222996A1
• Filed: 03/30/2004
• Published: 10/06/2005
• Est. Priority Date: 03/30/2004
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Yalamanchi, Aravind
• Application Number:
  US10/815,220
• Publication Number:
  US 20050222996A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Use of a database-enabled rules engine includes receiving and storing ECA expressions in the database. Such expressions specify (1) an event structure that defines an event that corresponds with the event structure; (2) conditions for evaluation with respect to occurrences of events that correspond with the event structure; and (3) actions for performance in response to events satisfying one or more of the conditions. Such expressions are stored in columns of a database table. Hence, during a database session in which the rules are evaluated with respect to one or more events, an event is detected based on the event'"'"'s compliance with the specified event structure and the conditions are evaluated by determining whether the event satisfies any of the conditions. If the event satisfies a set of one or more conditions that have a corresponding action, then the corresponding action is performed by the database or the database causes the action to be performed outside of the database.

Claims

1. A method for managing expressions in a database system, the method comprising the computer-implemented steps of:

receiving an expression that identifies an event structure, one or more related conditions and one or more related actions, wherein said event structure defines an event that corresponds with said event structure;

storing said expression in a table within said database;

during a database session,

detecting an occurrence of said event by detecting when an event occurs that complies with said event structure, and

determining whether said occurrence of said event satisfies any of said conditions; and

if said occurrence of said event satisfies any set of one or more conditions, of said conditions, that is associated with one or more corresponding actions, then causing performance of said one or more corresponding actions.

2. The method of claim 1, wherein receiving an expression comprises receiving an expression that identifies said event structure defined with a set of attributes that describe features of a corresponding event, and wherein said event structure is represented as an object type in said database.

3. The method of claim 1, wherein receiving an expression comprises receiving an expression that identifies said event structure as a composite event structure having two or more primitive events that are each represented, in said database, as an object type embedded in said composite event structure.

4. The method of claim 3,

wherein detecting comprises detecting an occurrence of a first primitive event of said primitive events by detecting when an event occurs that complies with a first primitive event structure of said composite event structure;

wherein determining comprises determining whether said occurrence of said first primitive event satisfies any of said conditions;

the method further comprising the computer-implemented steps of

persistently storing results of said determining in said database,

detecting an occurrence of a second primitive event of said primitive events by detecting when an event occurs that complies with a second primitive event structure of said composite event structure,

determining whether said occurrence of said second primitive event satisfies any of said conditions,

determining whether any of said conditions are satisfied by both said occurrence of said first primitive event and said occurrence of said second primitive event, and

wherein causing performance comprises, if said occurrence of said first primitive event and said occurrence of said second primitive event satisfy any of said set of one or more conditions that have one or more corresponding actions, then performing said one or more corresponding actions.

5. The method of claim 3, further comprising the computer-implemented steps of:

receiving information that specifies a period for which an occurrence of a first primitive event of said two or more primitive events is valid before an occurrence of a second primitive event of said two or more primitive events occurs; and

wherein determining comprises determining whether said occurrence of said first primitive event and said occurrence of said second primitive event satisfy any of said conditions in accordance with said information.

6. The method of claim 3, further comprising the computer-implemented steps of:

receiving information that specifies an order in which to evaluate said conditions with respect to said primitive events; and

wherein determining comprises determining, in said order according to said information, whether said conditions are satisfied by said primitive events.

7. The method of claim 1, wherein receiving an expression comprises receiving an expression that identifies an event structure derived from structure of tables, in said database, that store data that represent event occurrences.

8. The method of claim 7, wherein detecting an occurrence of said event comprises detecting that said data is changed.

9. The method of claim 1, wherein storing said expression in columns of a table comprises storing one or more conditions as an EXPRESSION data type in an EXPRESSION column of said table.

10. The method of claim 1, wherein receiving an expression comprises receiving an expression that identifies a condition that is represented as a SQL query on said database.

11. The method of claim 1, further comprising the computer-implemented step of:

receiving a modification, in the form of a SQL operation, to said one or more conditions of said expression.

12. The method of claim 1, further comprising the computer-implemented step of:

during a database session, providing access to a database view that comprises

a list of event occurrences that have been determined to satisfy any of said conditions,

a list of conditions that have been satisfied by event occurrences in said list of event occurrences, and

a list of actions that correspond with conditions in said list of conditions.

13. The method of claim 12, further comprising the computer-implemented step of:

in response to a request from a user of said database system, performing an operation on said view.

14. The method of claim 13, wherein performing an operation comprises performing an operation to resolve a conflict among two or more conditions that have been satisfied by event occurrences in said list of event occurrences.

15. The method of claim 13, wherein performing an operation comprises performing an operation that includes scheduling an action for performance outside of said database system.

16. The method of claim 1, further comprising the computer-implemented steps of:

receiving information that specifies that the step of determining is to stop when determining that said occurrence of said event satisfies said set of one or more conditions; and

stopping determining whether said occurrence of said event satisfies any of said conditions when determining that said occurrence of said event satisfies said set of one or more conditions.

17. The method of claim 1,

wherein receiving an expression comprises receiving an expression that identifies a temporal condition;

wherein said temporal condition specifies that an associated action of the one or more actions is to be performed if a second condition from said set of conditions is satisfied by an occurrence of an event, within a particular time after a first condition from set of conditions is satisfied by an occurrence of an event; and

wherein determining comprises determining whether occurrences of events satisfy said first and second conditions in accordance with said temporal condition.

18. The method of claim 1,

wherein receiving an expression comprises receiving an expression that identifies a negation condition;

wherein said negation condition specifies that an associated action of the one or more actions is to be performed if a second condition from said set of conditions is not satisfied by an occurrence of an event within a particular time after a first condition from set of conditions is satisfied by an occurrence of an event; and

wherein determining comprises determining whether occurrences of events satisfy said first and second conditions in accordance with said negation condition.

19. The method of claim 1,

wherein receiving an expression comprises receiving an expression that identifies a group of conditions that, when a particular number of conditions from said group of conditions is satisfied by one or more occurrences of events, triggers performance of said one or more corresponding actions;

wherein said particular number is less than a number of conditions in said group of conditions; and

wherein determining comprises determining whether one or more occurrences of events satisfy said particular number of conditions from said group of conditions.

20. The method of claim 1,

wherein receiving an expression comprises receiving an expression that identifies a group of sequenced conditions;

wherein said group of sequenced conditions specifies that an associated action of the one or more actions is to be performed if said conditions from said group of sequenced conditions are satisfied in a particular sequence by one or more occurrences of events; and

wherein determining comprises determining whether one or more occurrences of events satisfy said conditions from said group of sequenced conditions in said particular sequence.

21. A computer-readable medium carrying 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.

22. A computer-readable medium carrying 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.

23. A computer-readable medium carrying 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 3.

24. A computer-readable medium carrying 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.

25. A computer-readable medium carrying 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.

26. A computer-readable medium carrying 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 6.

27. A computer-readable medium carrying 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 7.

28. A computer-readable medium carrying 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.

29. A computer-readable medium carrying 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 9.

30. A computer-readable medium carrying 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.

31. A computer-readable medium carrying 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 11.

32. A computer-readable medium carrying 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.

33. A computer-readable medium carrying 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 13.

34. A computer-readable medium carrying 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.

35. A computer-readable medium carrying 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.

36. A computer-readable medium carrying 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 16.

37. A computer-readable medium carrying 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 17.

38. A computer-readable medium carrying 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.

39. A computer-readable medium carrying 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 19.

40. A computer-readable medium carrying 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 20.

41. A system comprising:

means for receiving an expression that identifies an event structure, one or more related conditions and one or more related actions, wherein said event structure defines an event that corresponds with said event structure;

means for storing said expression in a table within said database;

means for detecting, during a database session, an occurrence of said event by detecting when an event occurs that complies with said event structure, and

means for determining, during said database session, whether said occurrence of said event satisfies any of said conditions; and

means for causing performance of said one or more corresponding actions if said occurrence of said event satisfies any set of one or more conditions, of said conditions, that is associated with one or more corresponding actions.