System and method for online analytical processing

• US 7,010,523 B2
• Filed: 12/17/2003
• Issued: 03/07/2006
• Est. Priority Date: 08/01/2000
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Greenfield, David, Feinstein, Scott, Lyon, Geof Fred, Vogl, Ron
• Primary Examiner(s): Mofiz, Apu M.
• Application Number:
  US10/738,789
• Publication Number:
  US 20040133552A1
• Time in Patent Office: 811 Days
• Field of Search: 707/2, 707/3, 707/4, 707/5, 707/6, 707/10, 707/102, 707/104.1, 709/200, 709/217, 715/501.1, 171/104
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2438 Embedded query languages
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A system and method for analyzing data is described, in which an application programming interface (API) is provided to permit an online analytical processing (OLAP) application to manipulate data and queries in a model close to the business model the OLAP application was designed to support. A data server is provided to translate between the object-oriented representation and the native database query format. In one embodiment, a multidimensional virtual cursor is implemented to further simplify the logic of the OLAP application.

Claims

1. A computer-implemented method for analyzing data comprising the steps of:

receiving a call from an analytical processing application;

constructing a query object based on the call;

translating the query object into a textual query for submission to a data warehouse;

retrieving data from the data warehouse in response to the submission of the textual query; and

providing at least some of the data retrieved from the data warehouse in response to the textual query;

wherein said providing at least some of the data retrieved includes;

receiving a specification of an extent of a multidimensional cursor from the analytical processing application; and

determining said at least some of the data based on the specification.

2. A computer-readable medium bearing instructions for analyzing data, said instructions being arranged, upon execution, to cause one or more processors to perform the steps of a method according to claim 1.

3. The method of claim 1, further comprising refining the query object by sub-transactions of transactions performed on a database.

4. The method of claim 3, wherein said refining the query object includes:

generating a template of a source object based on metadata indicating a description of database data and database objects included in the data warehouse; and

modifying the template based on a user input.

5. The method of claim 1, further comprising:

receiving a refinement of the query object from the analytical processing application; and

initiating a sub-transaction to process a refined query that corresponds to the refinement of the query object.

6. The method of claim 1, wherein said constructing the query object based on the call includes:

generating a source object; and

generating a cursor object,

wherein the source object includes a specification for the query,

wherein the cursor object includes a result of the query.

7. The method of claim 1, wherein said translating the query object into the textual query includes:

matching an input with an output; and

generating a source object including a specification for a result of a query,

wherein the input includes a key having an unspecified value, and

wherein the output includes a key having a specified value.

8. The method of claim 7, wherein said matching the input with the output includes determining whether the input is equal to the output.

9. The method of claim 1, wherein said determining at least some of the data includes:

navigating to a database cell based on a position on an edge of a multidimensional result set; and

fetching an amount of data based on the extent, wherein the fetched data corresponds to a portion of a response to the textual query.

10. The method of claim 1, further comprising:

selectively rolling back at least one portion of a query associated with the query object.