Method and system for ensuring system awareness with data base connection on demand

• US 7,010,525 B2
• Filed: 04/25/2002
• Issued: 03/07/2006
• Est. Priority Date: 04/25/2002
• Status: Active Grant

• Current Assignee: Huawei Technologies Co., Ltd. (Huawei Investment & Holding Co., Ltd.)
• Original Assignee: International Business Machines Corporation
• Inventors: Botzer, David, Etzion, Opher, Yatzkar-Haham, Tali
• Primary Examiner(s): LE, UYEN T
• Application Number:
  US10/131,232
• Publication Number:
  US 20030204491A1
• Time in Patent Office: 1,412 Days
• Field of Search: 707/3, 707/4, 707/104.1, 719/318, 706/46, 706/59, 717/136
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24565 Triggers; Constraints
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A method and system for establishing a situation for use in an event-driven application receives one or more events, and queries an external database for obtaining auxiliary data defining relevant external knowledge for detecting the situation. The event or events are integrated with the auxiliary data for generating a composite event defining the situation. The database query is constructed in real time based on the received events with a query language using SQL primitives.

Claims

1. A computer configured as a situation manager for use in an event-driven application for establishing a situation having at least one external constraint associated therewith, the situation manager comprising:

an event unit for receiving one or more input events,

a processor for processing said events for generating a composite event relating to said situation,

a database engine for executing a database query for obtaining auxiliary data related to the at least one external constraint,

a situation evaluation unit coupled to the database engine for evaluating the situation using the auxiliary data and the composite event so as to limit a scope of the composite event to specific instances that match the database query, and

an output port configured for coupling to an external device that is responsive to said situation being detected for feeding thereto data representative of the composite event.

2. The computer according to claim 1, wherein the database engine is configured to use a query language that is responsive to one or more events received by the event unit for constructing a database query in real time.

3. The computer according to claim 2, wherein the query language uses SQL primitives.

4. The computer according to claim 2, wherein the query language includes an operand that operates on one or more database values and returns a logic TRUE or FALSE value according to whether said database values conform to a defined logic construct.

5. The computer according to claim 4, wherein said logic construct is constructed using SQL primitives.

11. The method according to claim 1, further including executing a database query for obtaining auxiliary data related to the situation for evaluating whether the composite event corresponds to said situation so as to limit a scope of the composite event to specific instances that match the database query.

6. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform method steps for use in an event-driven application for establishing a situation having at least one external constraint associated therewith, said method comprising:

(a) receiving one or more events,

(b) processing said events for generating a composite event relating to said situation;

(c) executing a database query for obtaining auxiliary data related to the at least one external constraint;

(d) evaluating the situation using the auxiliary data and the composite event so as to limit a scope of the composite event to specific instances that match the database query; and

(e) feeding data representative of the situation to an external device that is responsive to said situation being detected.

7. A computer program product comprising a computer useable medium having computer readable program code embodied therein for use in an event-driven application for establishing a situation having at least one external constraint associated therewith, said computer program product comprising:

computer readable program code for causing the computer to receive one or more events,

computer readable program code for causing the computer to process said events for generating a composite event relating to said situation;

computer readable program code for causing the computer to execute a database query for obtaining auxiliary data related to the at least one external constraint

computer readable program code for causing the computer to evaluate the situation using the auxiliary data and the composite event so as to limit a scope of the composite event to specific instances that match the database query; and

computer readable program code for causing the computer to feed data representative of the situation to an external device that is responsive to said situation being detected.

8. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform method steps for establishing in an event-driven application a situation that depends on one or more constituent events that include at least one conditional event having external conditions associated therewith, said method comprising:

(a) receiving said one or more constituent events;

(b) in respect of each of said conditional events, querying an external database for obtaining auxiliary data defining whether the conditional event is relevant to the situation;

(c) integrating said constituent events for generating a composite event relating to said situation only if all the conditional events are determined to be relevant to the situation; and

(d) feeding data representative of the composite event to an external device that is responsive to said situation being detected.

9. A computer program product comprising a computer useable medium having computer readable program code embodied therein for use in an event-driven application for establishing a situation that depends on one or more constituent events that include at least one conditional event having external conditions associated therewith, said computer program product comprising:

computer readable program code for causing the computer to receive said one or more constituent events,

computer readable program code for causing the computer to query an external database for obtaining auxiliary data defining whether the conditional events are relevant to the situation,

computer readable program code for causing the computer to integrate the constituent events for generating a composite event relating to said situation only if all the conditional events are determined to be relevant to the situation, and

computer readable program code for causing the computer to feed data representative of the composite event to an external device that is responsive to said situation being detected.

10. A computer implemented method for use in an event-driven application for establishing a situation that depends on one or more constituent events that include at least one conditional event having external conditions associated therewith, said method comprising:

(a) receiving the one or more constituent events,

(b) in respect of each of said conditional events, querying an external database for obtaining auxiliary data defining whether the conditional event is relevant to the situation;

(c) integrating said constituent events for generating a composite event relating to said situation only if all the conditional events are determined to be relevant to the situation; and

(d) feeding data representative of the composite event to an external device that is responsive to said situation being detected.

12. The method according to claim 10, wherein querying the external database includes using a query language to construct in real time a database query based on the events received.

13. The method according to claim 12, wherein the query language using SQL primitives.

14. The method according to claim 12, wherein the query language include an operand that operates on one or more database values and returns a logic TRUE or FALSE value according to whether said database values conform to a defined logic construct.

15. The method according to claim 14, wherein said logic construct is constructed using SQL primitives.

16. The method according to claim 12, wherein the database query is a static query using constant query parameters.

17. The method according to claim 12, wherein the database query is a dynamic query using query parameters that change during run time.

18. A computer configured as a situation manager for use in an event-driven application for establishing a situation that depends on one or more constituent events that include at least one conditional event having external conditions associated therewith, the situation manager comprising:

an event unit for receiving the one or more constituent events,

a database engine for querying an external database for obtaining auxiliary data defining whether the conditional events are relevant to the situation,

an integration unit coupled to the event unit and to the database engine for integrating said constituent events for generating a composite event relating to the situation only if all the conditional events are determined to be relevant to the situation, and

an output port configured for coupling to an external device that is responsive to said situation being detected for feeding thereto data representative of the composite event.

19. The computer according to claim 18, wherein the situation manager further comprises:

a situation evaluation unit for querying the database for obtaining auxiliary data related to the situation for evaluating whether the composite event corresponds to said situation.

20. The computer according to claim 18, wherein the database engine is configured to use a query language that is responsive to one or more events received by the event unit for constructing a database query in real time.

21. The computer according to claim 20, wherein the query language uses SQL primitives.

22. The computer according to claim 20, wherein the query language includes an operand that operates on one or more database values and returns a logic TRUE or FALSE value according to whether said database values conform to a defined logic construct.

23. The computer according to claim 22, wherein said logic construct is constructed using SQL primitives.

24. A computer implemented method for use in an event-driven application for establishing a situation having at least one external constraint associated therewith, said method comprising:

(a) receiving one or more events,

(b) processing said events for generating a composite event relating to said situation;

(c) executing a database query for obtaining auxiliary data related to the at least one external constraint;

(d) evaluating the situation using the auxiliary data and the composite event so as to limit a scope of the composite event to specific instances that match the database query; and

(e) feeding data representative of the situation to an external device that is responsive to said situation being detected.

25. The method according to claim 24, wherein querying the external database includes using a query language to construct in real time a database query based on the composite event.

26. The method according to claim 25, wherein the query language uses SQL primitives.

27. The method according to claim 25, wherein the database query is a static query using constant query parameters.

28. The method according to claim 25, wherein the database query is a dynamic query using query parameters that change during run time.

29. The method according to claim 25, wherein the query language includes an operand that operates on one or more database values and returns a logic TRUE or FALSE value according to whether said database values conform to a defined logic construct.

30. The method according to claim 29, wherein said logic construct is constructed using SQL primitives.