Oracle International Corporation

Lev Margulis

Ekrem Soylemez

James E Carey

Gregory Dorman

Caleb Welton

Matthew Dombroski

Albert A Hopeman, Iv

Christopher Kearney

In processing a query on multidimensional data in a multidimensional schema, a multidimensional database server performs various processes to limit the amount of data that is extracted from the database and presented to a relational database server in response to the request. A subset of data is identified to extract from the multidimensional data, based on the query. In various embodiments, cell-filtering, measure-filtering, and column-filtering criteria identified from the query are used to filter the subset of data, in order to return a minimized set of multidimensional data values from the subset of data. Therefore, computational resources are conserved with respect to further processing by the relational database server in response to the query.

Efficient SQL access to multidimensional data

Growing community of inventors

Needham, MA, United States of America

Lev Margulis