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

• US 20030204491A1
• Filed: 04/25/2002
• Published: 10/30/2003
• 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: Yatzkar-Haham, Tali, Botzer, David, Etzion, Opher
• Granted Patent: US 7,010,525 B2
• Time in Patent Office: Days
• US Class Current: 707/3
• 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 method for establishing a situation for use in an event-driven application, said method comprising the steps of:

(a) receiving one or more events,

(b) querying an external database for obtaining auxiliary data defining relevant external knowledge for detecting the situation, and

(c) integrating the event or events with the auxiliary data for generating a composite event defining said situation.

2. The method according to claim 1, wherein step (b) includes using a query language to construct in real time a database query based on the events received in (a).

3. The method according to claim 2, wherein the query language using SQL primitives.

4. The method according to claim 2, 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.

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

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

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

8. A situation manager comprising:

an event unit for receiving one or more input events,

a database engine for querying an external database for obtaining auxiliary data defining relevant external knowledge for detection of the situation, and

an integration unit coupled to the event unit and to the database engine for integrating the input event or events with the auxiliary data for establishing occurrence of a composite event, defining the situation.

9. The situation manager according to claim 8, further comprising:

a situation evaluation unit for evaluating whether the composite event corresponds to said predetermined situation.

10. The situation manager according to claim 8, wherein the database engine uses a query language that is responsive to one or more events received by the event unit for constructing a database query in real time.

11. The situation manager according to claim 10, wherein the query language uses SQL primitives.

12. The situation manager according to claim 10, 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.

13. The situation manager according to claim 12, wherein said logic construct is constructed using SQL primitives.

14. A query language for querying an external database for obtaining auxiliary data defining relevant external knowledge for detecting a situation, said query language being responsive to one or more received events for constructing a database query in real time.

15. The query language according to claim 14 using SQL primitives.

16. The query language according to claim 14, including an operand that operates on one or more database values and returns a logical TRUE or FALSE value according to whether said database values conform to a defined logic construct.

17. The query language according to claim 16, wherein said logic construct is constructed using SQL primitives.

18. The query language according to claim 16, wherein said logic construct is constructed using a shorthand that is expanded to SQL primitives.

19. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform method steps for establishing a situation for use in an event-driven application, said method comprising the steps of:

(a) receiving one or more events,

(b) querying an external database for obtaining auxiliary data defining relevant external knowledge for detecting the situation, and

(c) integrating the event or events with the auxiliary data for generating a composite event defining said situation.

20. A computer program product comprising a computer useable medium having computer readable program code embodied therein for establishing a situation for use in an event-driven application, 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 query an external database for obtaining auxiliary data defining relevant external knowledge for detecting the situation, and

computer readable program code for causing the computer to integrate the event or events with the auxiliary data for generating a composite event defining said situation.