System and method for supporting queries having sub-select constructs in a multidimensional database environment
In accordance with an embodiment, described herein is a system and method for supporting queries having sub-select constructs in a multidimensional database computing environment. The system enables a sub-select construct to be provided as part of an input query, for example using a Multidimensional Expressions (MDX), or other type of query. The inner sub-select, specified by the input query, is not executed by the system before the main query, but is used to restrict the data space for execution of the main select. The approach to processing the sub-select enables support for security-sensitive or other types of aggregation use cases.
1. A system for use with a multidimensional database, for support for security-sensitive aggregation and other functional use cases, comprising:
a computer, including a processor;
a multidimensional database, executing on the computer, for at least one of storage or analysis of data;
a main select fetching component executing on the computer; and
a sub-select fetching component executing on the computer;
wherein the system operates to
receive an input query for processing against the multidimensional database, wherein the input query comprises a main select construct and a sub-select construct,
determine a partial aggregation of a cube by
scanning the main select construct with the main select fetching component and simultaneously scanning the sub-select construct with the sub-select fetching component,
filtering each point scanned by the sub-select fetching component according to the sub-select construct;
determining the partial aggregation of the cube according to the filtered points.
2. The system of claim 1 , wherein the query language is a Multidimensional Expressions (MDX) query language.
3. The system of claim 1 , wherein the scanning the sub-select construct is performed at a kernel layer.
4. The system of claim 1 , wherein the scanning the main select construct is performed at a kernel layer.
5. The system of claim 1 , wherein the sub-select construct is used by the system to provide security-sensitive aggregation.
6. A method for use with a multidimensional database computing environment, for support for security-sensitive aggregation and other functional use cases, comprising:
providing, at a computer system including a processor, a multidimensional database for at least one of storage or analysis of data, a main select fetching component, and a sub-select fetching component executing on the computer;
receiving an input query for processing against the multidimensional database, wherein the input query comprises a main select construct and a sub-select construct,
determining a partial aggregation of a cube including
scanning the main select construct with the main select fetching component and simultaneously scanning the sub-select construct with the sub-select fetching component,
filtering each point scanned by the sub-select fetching component according to the sub-select construct; and
determining the partial aggregation of the cube according to the filtered points.
7. The method of claim 6 , wherein the query language is a Multidimensional Expressions (MDX) query language.
8. The method of claim 6 , wherein the scanning the sub-select construct is performed at a kernel layer.
9. The method of claim 6 , wherein the scanning the main select construct is performed at a kernel layer.
10. The method of claim 6 , wherein the sub-select construct is used by the system to provide security-sensitive aggregation.
11. 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 steps comprising:
providing a multidimensional database for at least one of storage or analysis of data, a main select fetching component, and a sub-select fetching component executing on the computer;
receiving an input query for processing against the multidimensional database, wherein the input query comprises a main select construct and a sub-select construct,
determining a partial aggregation of a cube including
scanning the main select construct with the main select fetching component and simultaneously scanning the sub-select construct with the sub-select fetching component,
filtering each point scanned by the sub-select fetching component according to the sub-select construct; and
determining the partial aggregation of the cube according to the filtered points.
12. The non-transitory computer readable storage medium of claim 11 , wherein the query language is a Multidimensional Expressions (MDX) query language.
13. The non-transitory computer readable storage medium of claim 11 , wherein the scanning the sub-select construct is performed at a kernel layer.
14. The non-transitory computer readable storage medium of claim 11 , wherein the scanning the main select construct is performed at a kernel layer.
15. The non-transitory computer readable storage medium of claim 11 , wherein the sub-select construct is used by the system to provide security-sensitive aggregation.