Oracle Corporation
METHOD FOR GENERATING VIEWS BASED ON A SEMANTIC MODEL, THAT ALLOWS FOR AUTONOMOUS PERFORMANCE IMPROVEMENTS AND COMPLEX CALCULATIONS

Abstract:

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.