A powerful and SQL-compatible data model and query language for OLAP

Authors:
Dennis Pedersen;Karsten Riis;Torben Bach Pedersen
Affiliations:
Aalborg University, Fredrik Bajers Vej 7E, 9220 Aalborg Ø, Denmark;Aalborg University, Fredrik Bajers Vej 7E, 9220 Aalborg Ø, Denmark;Aalborg University, Fredrik Bajers Vej 7E, 9220 Aalborg Ø, Denmark
Venue:
ADC '02 Proceedings of the 13th Australasian database conference - Volume 5
Year:
2002

Citing 21
Cited 8

STORM: a statistical object representation model

SSDBM V Proceedings of the fifth international conference on Statistical and scientific database management
A data model for supporting on-line analytical processing

CIKM '96 Proceedings of the fifth international conference on Information and knowledge management
OLAP and statistical databases: similarities and differences

PODS '97 Proceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
OLAP solutions: building multidimensional information systems

OLAP solutions: building multidimensional information systems
SQL: 1999, formerly known as SQL3

ACM SIGMOD Record
Microsoft OLAP solutions

Microsoft OLAP solutions
Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions

Journal of the ACM (JACM)
A foundation for capturing and querying complex multidimensional data

Information Systems - Data warehousing
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals

Data Mining and Knowledge Discovery
Modelling Large Scale OLAP Scenarios

EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
Modeling Multidimensional Databases

ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Extending Practical Pre-Aggregation in On-Line Analytical Processing

VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Datawarehousing Has More Colours Than Just Black & White

VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
What can Hierarchies do for Data Warehouses?

VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Aggregate-Query Processing in Data Warehousing Environments

VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
A Foundation for Multi-dimensional Databases

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Summarizability in OLAP and Statistical Data Bases

SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
Modeling Multidimensional Databases, Cubes and Cube Operations

SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
Querying Multidimensional Databases

DBLP-6 Proceedings of the 6th International Workshop on Database Programming Languages
Multidimensional Data Modeling for Complex Data

ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Proposal of a logical model for statistical data base

SSDBM'83 Proceedings of the 2nd international workshop on Proceedings of the Second International Workshop on Statistical Database Management

Query optimization for OLAP-XML federations

Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
An open source and web based framework for geographic and multidimensional processing

Proceedings of the 2006 ACM symposium on Applied computing
Integrating XML data in the TARGIT OLAP system

International Journal of Web Engineering and Technology
Modelling and querying geographical data warehouses

Information Systems
Design and semantics of a query language for multidimensional data

ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
Analysing multi-dimensional data across autonomous data warehouses

DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Integrating different grain levels in a medical data warehouse federation

DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
On-demand multidimensional data integration: toward a semantic foundation for cloud intelligence

The Journal of Supercomputing

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.