METHOD FOR PROVIDING A REAL TIME VIEW OF HETEROGENEOUS ENTERPRISE DATA

• US 20140039952A1
• Filed: 08/08/2013
• Published: 02/06/2014
• Est. Priority Date: 05/27/2003
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Nesamoney, Diaz H., Yan, Weipeng Paul, Martin, Jameison Bear, Radalj, Maurice Mate, Younas, Fayyaz Ahmad
• Granted Patent: US 9,177,275 B2
• Time in Patent Office: Days
• US Class Current: 705/7.11
• CPC Class Codes: G06F 16/2458 Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database

Abstract

A method for providing a real time view of heterogeneous enterprise data of operational systems includes capturing streams of operational events in real time, combining the events with contextual data, and materializing a resulting view. The resulting view includes a dynamically defined view of the stream of events and provides visibility into a current state of the operational system. A view snapshot is continuously incrementally updated by a view maintenance engine as a stream of rows. The views are used to evaluate a business rule. An alert is fired when a business rule holds true. To enable the view in a view engine, a SQL string characterising the view is parsed into a parse tree, which is normalized to form a query graph. The query graph is then optimized to obtain a query plan, which is compiled into an operator graph. Queries are executed based upon the operator graph.

Claims

1-21. -21. (canceled)

22. In a view engine comprising a business activity monitoring system performing a method for providing a real time view of heterogeneous enterprise data of operational systems comprising capturing a stream of operational events in real time, materializing a resulting view wherein said resulting view comprises a dynamically defined view of said stream of events and wherein said resulting view provides visibility into a current state of said operational systems, and applying a business rule to said resulting view, a method for implementing a rule, comprising:

generating a hidden rule from said resulting view wherein said hidden rule is selected from the group consisting essentially of Fire, Raise, and Lower; and

asynchronously sending said hidden rule to a rule engine.

23. The method as recited in claim 22 further comprising generating a subsequent business view by joining an event comprising said stream of events with a context.

24. The method as recited in claim 23 further comprising:

generating a hidden reportlet view from said subsequent business view; and

asynchronously sending said reportlet view to a reportlet engine.

25. The method as recited in claim 23 further comprising:

formulating a reportlet query from said subsequent business view; and

synchronously sending said reportlet query to a reportlet engine.

26. The method as recited in claim 22 wherein a user defines said business rule from said resulting view online and wherein said rule engine defines said hidden view for evaluating said business rule.

27. The method as recited in claim 26 wherein, for a business view in the form of when a specified Boolean expression occurs, fire an alert, said Boolean expression is evaluated for each row of a plurality of rows comprising said business view and said alert is fired once for each row of said plurality of rows wherein said <

Boolean expression>

evaluates to true.

28. The method as recited in claim 26 wherein, for a business view in the form of when a specified Boolean expression occurs, fire a consolidated alert wherein a corresponding hidden view comprises a table containing one row, said Boolean expression is evaluated for each row of a plurality of rows comprising said business view and said alert is fired once where said Boolean expression evaluates to true for any row comprising said plurality of rows.

29. The method as recited in claim 26 wherein, for a rule on a business view in the form of when a specified Boolean expression occurs raise an alert, said Boolean expression is evaluated for each row of a plurality of rows comprising said business view and said alert is raised by a fixed amount.

30. The method as recited in claim 26 wherein, for a rule on a business view in the form of when a specified Boolean expression occurs, lower an alert, said Boolean expression is evaluated for each row of a plurality of rows comprising said business view and said alert is lowered by a fixed amount.

31. The method as recited in claim 26 wherein, for a rule on a business view in the form of when a specified Boolean expression holds for a specified duration, raise an alert, wherein a corresponding hidden view comprises a current time stamp function, said current time stamp function returning a timestamp corresponding to the current time, said Boolean expression is evaluated for each row of a plurality of rows comprising said business view and said alert is raised by a fixed amount when said Boolean expression persists for said specified duration.

32. The method as recited in claim 26 wherein, for a rule on a business view in the form of when a specified Boolean expression holds for a specified duration, lower an alert, wherein a corresponding hidden view comprises a current time stamp function, said current time stamp function returning a timestamp corresponding to the current time, said Boolean expression is evaluated for each row of a plurality of rows comprising said business view and said alert is lowered by a fixed amount when said Boolean expression persists for said specified duration.

33. The method as recited in claim 26 wherein, for a rule on a business view in the form of when a specified Boolean expression holds for a specified duration, raise an alert, for a specific column of a column list, wherein a corresponding hidden view comprises a current time stamp function, said current time stamp function returning a timestamp corresponding to the current time, said Boolean expression is evaluated for each row of a plurality of rows comprising said business view and said alert is raised by a fixed amount when said Boolean expression persists for said specified duration for said specific column.

34. The method as recited in claim 26 wherein, for a rule on a business view in the form of when a specified Boolean expression holds for a specified duration, lower an alert, for a specific column of a column list, wherein a corresponding hidden view comprises a current time stamp function, said current time stamp function returning a timestamp corresponding to the current time, said Boolean expression is evaluated for each row of a plurality of rows comprising said business view and said alert is lowered by a fixed amount when said Boolean expression persists for said specified duration for said specific column.

35-52. -52. (canceled)

53. A computer usable medium having computer readable program code embodied therein that causes a computer system to:

provide a real time view of heterogeneous enterprise data of operational systems comprising capturing a stream of operational events in real time;

materialize a resulting view wherein said resulting view comprises a dynamically defined view of said stream of events and wherein said resulting view provides visibility into a current state of said operational systems;

apply a business rule to said resulting view;

generate a hidden rule from said resulting view wherein said hidden rule is selected from the group consisting essentially of Fire, Raise, and Lower; and

asynchronously send said hidden rule to a rule engine.

54. The computer usable medium of claim 53 having computer readable program code embodied therein that causes the computer system to:

generate a subsequent business view by joining an event comprising said stream of events with a context.

55. The computer usable medium of claim 53 having computer readable program code embodied therein that causes the computer system to:

generate a hidden reportlet view from said subsequent business view; and

asynchronously send said reportlet view to a reportlet engine.

56. The computer usable medium of claim 53 having computer readable program code embodied therein that causes the computer system to:

formulate a reportlet query from said subsequent business view; and

synchronously send said reportlet query to a reportlet engine.

57. A computer system comprising at least one processor, wherein the at least one processor is operable to:

provide a real time view of heterogeneous enterprise data of operational systems comprising capturing a stream of operational events in real time;

materialize a resulting view wherein said resulting view comprises a dynamically defined view of said stream of events and wherein said resulting view provides visibility into a current state of said operational systems;

apply a business rule to said resulting view;

generate a hidden rule from said resulting view wherein said hidden rule is selected from the group consisting essentially of Fire, Raise, and Lower; and

asynchronously send said hidden rule to a rule engine.

58. The computer system of claim 57 wherein the at least one processor is configured to:

generate a hidden reportlet view from said subsequent business view; and

asynchronously send said reportlet view to a reportlet engine.

59. The computer system of claim 57 wherein the at least one processor is configured to:

formulate a reportlet query from said subsequent business view; and

synchronously send said reportlet query to a reportlet engine.