System and method for supporting large queries in a multidimensional database environment
AssigneeOracle International Corporation
InventorAlexey Roytman
Life of this patent
Estimating the term…
Abstract
In accordance with an embodiment, the system provides support for large queries in a multidimensional database computing environment. A kernel-based data structure, referred to herein as an odometer retriever, or odometer, that manages pointers to data blocks, contains control information, or otherwise operates as an array of arrays of pointers to stored members. When used with a dynamic flow, the approach enables the system to be used, for example to handle grid queries, Multidimensional Expressions (MDX) queries, or other types of queries in which the potential size of the query can be up to 264 bits.
Claims20
A system for supporting large queries in a multidimensional database environment, comprising:
- a computer, including a processor;
- and
- a multidimensional database environment executing on the processor, including a multidimensional database for at least one of storage or analysis of data, the multidimensional database including a kernel-based data structure that manages pointers to data blocks, contains control information, and comprises an array of key values,
- wherein the multidimensional database is configured to process a query using the kernel-based data structure to maintain references to cells of the multidimensional database,
- wherein each key value in the array of key values is a reference to a cell of the multidimensional database, and
- wherein the kernel-based data structure provides a transformation for key values to fully-specified references to cells of the multidimensional database.
A method for supporting large queries in a multidimensional database environment, comprising:
- providing, at a computer system including a processor, a multidimensional database environment, including a multidimensional database for at least one of storage or analysis of data, the multidimensional database includes a kernel-based data structure that manages pointers to data blocks, contains control information, and comprises an array of key values;
- and
- processing, by the system, an input query using the kernel-based data structure to maintain references to cells of the multidimensional database,
- wherein each key value in the array of key values is a reference to a cell of the multidimensional database, and
- wherein the kernel-based data structure provides a transformation for key values to fully-specified references to cells of the multidimensional database.
A non-transitory computer readable storage medium, including instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform the method comprising:
- providing, at a computer system including a processor, a multidimensional database environment, including a multidimensional database for at least one of storage or analysis of data, the multidimensional database includes a kernel-based data structure that manages pointers to data blocks, contains control information, and comprises an array of keys values;
- and
- processing, by the multidimensional database environment, a query using the kernel-based data structure to maintain references to cells of the multidimensional database,
- wherein each key value in the array of key values is a reference to a cell of the multidimensional database, and
- wherein the kernel-based data structure provides a transformation for key values to fully-specified references to cells of the multidimensional database.
Dependencies are inferred from the claim text.