Oracle International Corporation

Scott Feinstein

Raghuram Venkatasubramanian

David Greenfield

James Hartsing

Anne Murphy

Geof Fred Lyon

Ron Vogl

Ekrem S C Soylemez

Bei Yu

Steven Mesropian

Herein are techniques for automatically leveraging metadata of an analytic view to accelerate a relational query. In an embodiment, a computer stores model metadata that defines an analytic view that contains a join operation that is based on a dimension column of a dimension table and a join column of a fact table. The analytic view also contains a measure that is based on an aggregation operation and a measure column of the fact table. Also stored is denormalization metadata that defines a transparency view that is based on the analytic view. In operation, a query that references the transparency view is received. The query does not reference the analytic view. The query that references the transparency view is executed based on: a) the denormalization metadata that defines the transparency view, b) the model metadata that defines the analytic view, and c) the measure that is based on the aggregation operation and the measure column of the fact table.

Method for generating views based on a semantic model, that allows for autonomous performance improvements and complex calculations

Herein, a computer stores metadata that defines an analytic view that is based on organizing operation(s) that respectively specify organizing column(s) of organizing table(s), including a join operation that specifies a dimension column of a dimension table and a join column of a fact table. An original query is received that does not reference the analytic view. The original query specifies at least one organizing operation that is identical, somewhat similar, or compatible to an organizing operation on which the analytic view is based. Based on that at least one organizing operation that the original query specifies and the metadata that defines the particular analytic view, the original query is determined to satisfy rewrite criterion(s). In response to determining that the original query satisfies the rewrite criteria, a rewritten query that references the analytic view is generated based on the original query that does not reference the analytic view.

Method for using a sematic model to transform SQL against a relational table to enable performance improvements

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.

System and method for online analytical processing

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.

Growing community of inventors

Peabody, MA, United States of America

Scott Feinstein