Oracle International Corporation

Edwin Meijer

Xiaolan Shen

Robert Paul

Aravindan Vijayan

Joseph Zheng

Sangeeta Dattawadkar

An inherited dimension comprises one or more base dimension objects and one or more specialized dimension objects that are stored in a non-transitory volatile or non-volatile computer-readable storage. Each base dimension object of the one or more base dimension objects has a first set of dimension attributes that are common across the plurality of multidimensional datasets. The one or more specialized dimension objects include a specialized dimension object that has a second set of dimension attributes for a particular multidimensional dataset from the plurality of multidimensional datasets. In response to receiving a query that references the dimension and targets the particular multidimensional dataset, a base dimension object and the specialized dimension object are accessed to generate a query result.

Inherited dimensions

Techniques are described for prefetching analytic results across multiple levels of a dimension in a multidimensional dataset. In some embodiments, an application layer sends a request to view a summary of a multidimensional dataset, where the request targets a first level of a particular dimension of the multidimensional dataset. In response to receiving the request, a pre-fetch range is determined. The pre-fetch range identifies how many levels to analyze along the particular dimension of the multidimensional dataset. At least one analytical operation is performed for the first level of the particular dimension and one or more levels that are within the pre-fetch range of the first level. A first analytic result for the first level is returned to the application layer. For each respective level of the one or more levels within the pre-fetch range, a respective analytic result is stored in a cache.

Growing community of inventors

Redwood City, CA, United States of America

Edwin Meijer