Multi-dimensional aggregation on event streams

• US 20070150585A1
• Filed: 12/28/2005
• Published: 06/28/2007
• Est. Priority Date: 12/28/2005
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Chkodrov, Gueorgui
• Application Number:
  US11/320,349
• Publication Number:
  US 20070150585A1
• Time in Patent Office: Days
• US Class Current: 709/224
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Multi-dimensional aggregation on event streams for generating reports based on metadata about what events are available. An aggregation definition tool receives the event stream and, responsive to user input, identifies events of interest and specifies a correlation pattern for defining activities from the events. A user interface permits a user to define a desired dimensional structure of the reports and a mapping between data items in the events and the dimensional structure.

Claims

1. A computerized method of generating a report from an event stream, said event stream comprising a plurality of events, said method comprising:

identifying one or more events of interest in the event stream;

retrieving metadata associated with the events of interest;

correlating the events of interest based on the metadata retrieved therefrom;

defining a dimensional structure for the report; and

mapping the correlated events to the dimensional structure to generate the report.

2. The method of claim 1, further comprising presenting, to a user, information representative of the mapping.

3. The method of claim 2, wherein presenting information representative of the mapping comprises generating a graphical report.

4. The method of claim 3, wherein said graphical report comprises at least one of the following:

a bar chart, a pie chart, and a table.

5. The method of claim 1, wherein identifying the events of interest comprises receiving user input defining one or more activities, said activities each including a plurality of instances of at least one of the events in the event stream.

6. The method of claim 5, further comprising defining a starting event and an ending event for each of the defined activities.

7. The method of claim 1, wherein identifying the events of interest comprises displaying, to a user, an event schema, said event schema displaying the events in the event stream and the metadata associated therewith.

8. The method of claim 1, wherein one or more computer-readable media have computer-executable instructions for performing the method recited in claim 1.

9. In a computer system having a display, said display having a user interface rendered thereon, said user interface comprising:

an event component for displaying a plurality of available events in an event stream;

a metadata component for displaying metadata associated with the available events;

a selection component responsive to user input for selecting one or more events of interest from the event component based on the displayed metadata associated therewith; and

a structure component responsive to user input for defining a correlation key and dimensional structure for organizing the selected events of interest.

10. The user interface of claim 9, further comprising a report component for displaying the dimensional structure having the selected events of interest mapped to the dimensional structure according to the correlation key.

11. The user interface of claim 10, wherein the report component comprises a graphical report.

12. The user interface of claim 11, wherein said graphical report comprises at least one of the following:

a bar chart, a pie chart, and a table.

13. The user interface of claim 9, wherein the correlation key specifies one or more activities, said activities each including a plurality of instances of at least one of the events of interest.

14. The user interface of claim 13, wherein the selection component is responsive to user input for defining a starting event and an ending event for each of the specified activities.

15. The user interface of claim 9, wherein the structure component is responsive to user input for defining one or more of the events of interest as a dimension.

16. The user interface of claim 9, wherein the structure component is responsive to user input for defining one or more of the events of interest as a measure.

17. At least one computer-readable medium having computer-executable instructions for generating a report from an event stream, said computer-readable medium comprising:

an event schema describing available events in the event stream and metadata associated therewith;

an aggregation definition tool receiving and responsive to user input for identifying one or more events of interest in the event stream and correlating the events of interest based on the metadata described in the event schema; and

a business activity monitor for producing one or more activity definitions according to the correlated events of interest and for producing a data warehouse of the activity definitions.

18. The computer-readable medium of claim 17, further comprising an interception configuration for defining a mapping between the correlated events of interest and the activity definitions in the data warehouse.

19. The computer-readable medium of claim 18, further comprising a view component responsive to user input for generating a graphical user interface displaying selected activity definitions from the data warehouse.

20. The computer-readable medium of claim 17, wherein the aggregation definition tool is responsive to user input for specifying a dimensional structure of the correlated events of interest.