A Powerful and SQL-Compatible Data Model and Query Language for OLAP

Pedersen, D., Riis, K. and Pedersen, T.B.

    In this paper we present the SQLM OLAP data model, formal algebra, and query language that, unlike current OLAP data models and languages, are both powerful, meaning that they support irregular dimension hierarchies, automatic aggregation of data, and correct aggregation of data, and SQL-compatible, allowing seamless integration with relational technology. We also consider the requirements to the data model posed by integration of OLAP data with external XML data. The concepts are illustrated with a real-world case study from the Business-to- Business electronic commerce (B2B) domain.
Cite as: Pedersen, D., Riis, K. and Pedersen, T.B. (2002). A Powerful and SQL-Compatible Data Model and Query Language for OLAP. In Proc. Thirteenth Australasian Database Conference (ADC2002), Melbourne, Australia. CRPIT, 5. Zhou, X., Ed. ACS. 121-130.
pdf (from crpit.com) pdf (local if available) BibTeX EndNote GS