APPARATUS AND METHOD FOR FACILITATING CONTINUOUS QUERYING OF MULTI-DIMENSIONAL DATA STREAMS

• US 20090327257A1
• Filed: 06/27/2008
• Published: 12/31/2009
• Est. Priority Date: 06/27/2008
• Status: Active Grant

• Current Assignee: SAP France SA (SAP SE)
• Original Assignee: Business Objects SA (SAP SE)
• Inventors: Abouzeid, Azza Mohamed Nagib Mohamed, Slonim, Jacob, McAllister, Michael Joseph
• Granted Patent: US 8,316,012 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A computer readable storage medium comprises executable instructions to provide a query interface for formulating continuous queries of multi-dimensional data streams. The query interface is populated to generate a plurality of continuous queries. The plurality of continuous queries are executed. The plurality of continuous queries are modified at run-time.

Claims

1. A computer readable storage medium, comprising executable instructions to:

provide a query interface for formulating continuous queries of multi-dimensional data streams;

populate the query interface to generate a plurality of continuous queries;

execute the plurality of continuous queries; and

modify the plurality of continuous queries at run-time.

2. The computer readable storage medium of claim 1, wherein the executable instructions to provide a query interface comprise executable instructions to provide a plurality of query frames.

3. The computer readable storage medium of claim 2, wherein each query frame comprises a plurality of meta-sections with descriptive textual information about the query frame.

4. The computer readable storage medium of claim 2, wherein each query frame comprises a query section for specifying a continuous query.

5. The computer readable storage medium of claim 4, wherein the query section comprises gaps to be populated by a user.

6. The computer readable storage medium of claim 5, wherein the executable instructions to populate the query interface comprise executable instructions to populate the plurality of query frames.

7. The computer readable storage medium of claim 5, wherein the plurality of query frames are selected from the group comprising dimension query frames, source query frames, filter query frames, function query frames, and composite query frames.

8. The computer readable storage medium of claim 7, wherein the gaps in the dimension query frames comprise gaps for dimensions and abstraction levels for an aggregation query.

9. The computer readable storage medium of claim 7, wherein the gaps in the source query frames comprise gaps for a data source and fields within a multi-dimensional data stream stored in the data source.

10. The computer readable storage medium of claim 7, wherein the gaps in the filter query frames comprise gaps for criteria to filter out one or more tuples of a multi-dimensional data stream.

11. The computer readable storage medium of claim 7, wherein the gaps in the function query frames specify the operation to be performed in the query.

12. The computer readable storage medium of claim 1, wherein a query frame comprises an empty query frame, a partially filled query frame, and a complete query.

13. The computer readable storage medium of claim 6, wherein the executable instructions to populate the plurality of query frames comprise executable instructions to display a menu of choices for populating the gaps in the plurality of query frames.

14. The computer readable storage medium of claim 2, further comprising executable instructions to associate each query frame with metadata.

15. The computer readable storage medium of claim 14, further comprising executable instructions to search for query frames with associated metadata.

16. The computer readable storage medium of claim 1, further comprising executable instructions to convert the continuous queries formulated in the plurality of query frames into a plurality of query plans.

17. A computer readable storage medium, comprising executable instructions to:

provide a plurality of query frames for generating continuous queries;

store the plurality of query frames in a query catalog;

search for query frames in the query catalog matching search criteria;

populate the query frames matching the search criteria to generate populated query frames; and

convert the populated query frames into continuous queries.

18. The computer readable storage medium of claim 17, wherein the search criteria are selected from the group comprising keyword search, query type search, query frame search, and user profile search.

19. The computer readable storage medium of claim 17, further comprising executable instructions to associate each query frame with metadata.

20. The computer readable storage medium of claim 19, wherein the metadata is selected from the group comprising query frame metadata, user profile metadata, and data source metadata.

21. The computer readable storage medium of claim 17, further comprising executable instructions to modify the continuous queries at run-time.

22. A method for facilitating the formulation of continuous queries, the method comprising:

providing a plurality of query frames for formulating continuous queries;

providing a graphical user interface for populating one or more of the plurality of query frames to generate populated query frames;

storing the populated query frames in a query catalog;

converting the populated query frames into continuous queries; and

executing the continuous queries.

23. The method of claim 22, further comprising searching for query frames in the query catalog matching a search criteria.

24. The method of claim 22, further comprising modifying the continuous queries at run-time.

25. The method of claim 22, further comprising displaying the executing continuous queries to a user.