System and method for online analytical processing

• US 6,684,207 B1
• Filed: 08/01/2001
• Issued: 01/27/2004
• Est. Priority Date: 08/01/2000
• Status: Active Grant

• 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): Mizrahi, Diane D.
• Assistant Examiner(s): MOFIZ, APU M
• Application Number:
  US09/918,712
• Time in Patent Office: 909 Days
• Field of Search: 707/2, 707/3, 707/4, 707/5, 707/6, 707/10, 707/104.1, 707/102, 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 model close to the business model the OLAP application was designed to support. A data server is provided to translated between the object-oriented representation and the native database query format. In one embodiment, a multidimensional virtual cursor is implementation to further simplify the logic of the OLAP application.

Claims

1. A system for analyzing data, comprising:

a data warehouse configured for storing and retrieving data in response to textual queries;

a platform configured for executing an analytical processing application; and

a data server configured for receiving calls from the analytical processing application to construct a query object, translating the query object into a textual query for submission to the data warehouse, and providing at least some of the data retrieved from the data warehouse in response the textual query.

2. The system of claim 1, wherein the data server is further configured for receiving a specification of an extent of a multidimensional cursor from the analytical processing application and providing only the data that fits in the multidimensional cursor to the analytical processing application.

3. The system of claim 1, wherein the data server is further configured for receiving a refinement of the query object from the analytical processing application and initiating a subtransaction to handle processing a query that corresponds to the refinement of the query obejct.