System and method for online analytical processing
AssigneeOracle International Corporation
InventorsDavid Greenfield, Geof Fred Lyon, Ron Vogl, Scott Feinstein
Life of this patent
Estimating the term…
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.
Claims10
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.
Dependencies are inferred from the claim text.