The Cube-Query-Language (CQL) for Multidimensional statistical and scientific database systems

摘要

The "Cube-Query-Language" (CQL) is a new query language for flexible access to Multidimensional Data-base Systems. CQL provides a high level user interface for specifying queries in the context of multidimensional data analysis. The multidimensional view is widely accepted for typical decision support requirements like "Online Analytical Processing". CQL directly supports this view and circumvents the problems of formulating multiple groupby's and equijoins in a typical SQL-notation. Furthermore, in comparison to currently available OLAP-solutions, CQL provides a SQL like query interface, making it easy for an experienced SQL-programmer, to formulate decision support queries efficiently.