Registration of solved cubes within a relational database management system
First Claim
1. A method for performing an operation based on multidimensional data managed by a relational database management system, wherein the multidimensional data that is stored in the relational database includes a plurality of dimensions and at least one dimension of the plurality of dimensions includes a hierarchy having two or more levels of granularity, the method comprising the computer-implemented steps of:
- registering, with said relational database management system, metadata that defines a cube, wherein said metadata includes data that identifies that said cube is a solved cube; and
data that indicates how to handle requests that involve said solved cube;
receiving a request for an operation on said solved cube; and
in response to said request, performing the steps of determining, based on said metadata, one or more operations to perform to fulfill said request, and performing said one or more operations.
2 Assignments
0 Petitions
Accused Products
Abstract
Performing operations on multidimensional data managed by a relational database system is facilitated by registration of solved cubes with a RDBMS. A solved cube is an abstract construct likened to a view or a table on relational data and contains not only base data, but also aggregated measure data that is base data that has been processed across multiple levels of a hierarchical dimension. In an embodiment, a solved cube may provide all the pre-computed aggregated data for a particular context that the solved cube represents. In another embodiment, a solved cube may not provide any pre-computed data, but may provide several procedures, operations and/or instructions that can be executed to compute aggregated data for a particular context that the solved cube represents. A solved cube is registered with a RDBMS by providing metadata that defines a given solved cube. Therefore, a database server is able interpret the metadata, and to perform operations on the given solved cube based on the metadata.
142 Citations
37 Claims
-
1. A method for performing an operation based on multidimensional data managed by a relational database management system, wherein the multidimensional data that is stored in the relational database includes a plurality of dimensions and at least one dimension of the plurality of dimensions includes a hierarchy having two or more levels of granularity, the method comprising the computer-implemented steps of:
-
registering, with said relational database management system, metadata that defines a cube, wherein said metadata includes data that identifies that said cube is a solved cube; and
data that indicates how to handle requests that involve said solved cube;
receiving a request for an operation on said solved cube; and
in response to said request, performing the steps of determining, based on said metadata, one or more operations to perform to fulfill said request, and performing said one or more operations. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36)
-
-
37. An apparatus for performing an operation based on multidimensional data managed by a relational database management system, wherein the multidimensional data that is stored in the relational database includes a plurality of dimensions and at least one dimension of the plurality of dimensions includes a hierarchy having two or more levels of granularity, the apparatus comprising:
-
means for registering, with said relational database management system, metadata that defines a cube, wherein said metadata includes data that identifies that said cube is a solved cube; and
data that indicates how to handle requests that involve said solved cube;
means for receiving a request for an operation on said solved cube; and
means for determining, based on said metadata, one or more operations to perform to fulfill said request, and means for performing said one or more operations.
-
Specification