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 computing, including a processor; a multidimensional database, for at least one of storage or analysis of data; and wherein the system is configured to process sub-select constructs in a query language, including that an inner sub-select construct specified by an input query, is used by the system to restrict a data space for execution of a main select statement.