Generating Multidimensional Schemata from Relational Aggregation Queries
Authors: C. Pang, K. Taylor, X. Zhang, M. Cameron
Date: November 2004
Abstract:
Queries on operational databases can be viewed as a form of business rules on data warehouse schema design. We propose to use such queries to automatically generate measures, dimensions and dimension hierarchies and their representation in a star schema. The schema produced with our approach has good properties such as non-redundant dimensional attributes and orthogonality among dimensions and can answer many more queries than just those it was generated from.
Publisher: © Springer-Verlag Berlin Heidelberg 2004. Web Information Systems Engineering (WISE 2004), Brisbane, Australia, 22 - 24 November 2004
Download the paper (PDF: 166KB)