The Community for Technology Leaders
2008 IEEE 24th International Conference on Data Engineering (2008)
Cancun, Mexico
Apr. 7, 2008 to Apr. 12, 2008
ISBN: 978-1-4244-1836-7
pp: 1409-1411
Xuedong Chen , Computer Science Department, University of Massachusetts Boston, 100 Morrissey Boulevard, Boston, MA 02125, U.S.A. xuedchen@cs.umb.edu
Patrick O'Neil , Computer Science Department, University of Massachusetts Boston, 100 Morrissey Boulevard, Boston, MA 02125, U.S.A. poneil@cs.umb.edu
Elizabeth O'Neil , Computer Science Department, University of Massachusetts Boston, 100 Morrissey Boulevard, Boston, MA 02125, U.S.A. eoneil@cs.umb.edu
ABSTRACT
Columns of dimension tables that are frequently restricted in queries on a star schema database are materialized into the fact table by various means, depending on database product features. This makes it possible to create a multi-dimensional partitioning on the fact table, so that many queries restricting columns in hierarchies of the columns materialized will retrieve only a small number of cells of a rectangular subset of the partitioning. We believe this approach to be a previously undiscovered, though seemingly obvious, method to accelerate query performance.
INDEX TERMS
CITATION

X. Chen, P. O'Neil and E. O'Neil, "Adjoined Dimension Column Clustering to Improve Data Warehouse Query Performance," 2008 IEEE 24th International Conference on Data Engineering(ICDE), Cancun, Mexico, 2008, pp. 1409-1411.
doi:10.1109/ICDE.2008.4497572
89 ms
(Ver 3.3 (11022016))