Generating multidimensional schemata from relational aggregation queries

Pang, C, Taylor, K, Zhang, X and Cameron, M 2004, 'Generating multidimensional schemata from relational aggregation queries', in X. Zhou et al. (ed.) Web Information Systems - WISE 2004 Fifth International Conference on Web Information Systems Engineering, Brisbane, Australia, 1 November 2004.


Document type: Conference Paper
Collection: Conference Papers

Attached Files
Name Description MIMEType Size
n2004001391.pdf Accepted manuscript application/pdf 165.35KB
Title Generating multidimensional schemata from relational aggregation queries
Author(s) Pang, C
Taylor, K
Zhang, X
Cameron, M
Year 2004
Conference name International Conference on Web Information Systems Engineering
Conference location Brisbane, Australia
Conference dates 1 November 2004
Proceedings title Web Information Systems - WISE 2004 Fifth International Conference on Web Information Systems Engineering
Editor(s) X. Zhou et al.
Publisher Springer
Place of publication Berlin
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.
Subjects Business Information Management (incl. Records, Knowledge and Information Management, and Intelligence)
Keyword(s) database query
multidimensional schema
data warehouse
DOI - identifier 10.1007/b103344
Copyright notice © Springer-Verlag Berlin Heidelberg 2004
Versions
Version Filter Type
Altmetric details:
Access Statistics: 191 Abstract Views, 328 File Downloads  -  Detailed Statistics
Created: Wed, 08 Apr 2009, 09:42:32 EST by Catalyst Administrator
© 2014 RMIT Research Repository • Powered by Fez SoftwareContact us