Method of processing and decomposing a multidimensional query against a relational data source

摘要

A multidimensional operation provider is provided for processing a multidimensional query against a relational datasource. The multidimensional operation provider comprises a query interceptor, a query decomposer and a query replacer. The query interceptor detects and intercepts a multidimensional query that is issued against one or more relational data sources. The query decomposer decomposes expressions of the multidimensional query into one multidimensional expression and/or one or more relational expressions. The query replacer replaces the multidimensional query with a stack of operations expressed by the decomposed multidimensional expressions and/or the relational expressions.

主权项

1. A method of processing a multidimensional query against one or more data sources, the method comprising:
detecting and intercepting a multidimensional query that is issued against one or more relational data sources, the multidimensional query involving one or more multidimensional expressions; and decomposing, with a computer system, the multidimensional query, wherein decomposing the multidimensional query comprises:
identifying one or more sub-expressions in the multidimensional query as one or more tabular sub-expressions that are supported by a relational query provider;extracting the one or more tabular sub-expressions into one or more tabular data items;creating one or more cube items in a dynamic cube for the one or more tabular data items, wherein creating the one or more cube items comprises creating a respective cube item in the dynamic cube for each of the one or more tabular data items; andreplacing each of the one or more tabular sub-expressions in the multidimensional query with one or more references to one or more of the one or more cube items to generate a decomposed sub-query.