Title :
Adjoined Dimension Column Clustering to Improve Data Warehouse Query Performance
Author :
Chen, Xuedong ; Neil, Patrick O. ; Neil, Elizabeth O.
Author_Institution :
Dept. of Comput. Sci., Univ. of Massachusetts Boston, Boston, MA
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 multidimensional 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.
Keywords :
data warehouses; query processing; data warehouse; dimension column clustering; dimension tables; multidimensional partitioning; query performance; schema database; Acceleration; Computer science; Concatenated codes; Costs; Data warehouses; Filters; Information retrieval; Marketing and sales; Multidimensional systems; Spatial databases;
Conference_Titel :
Data Engineering, 2008. ICDE 2008. IEEE 24th International Conference on
Conference_Location :
Cancun
Print_ISBN :
978-1-4244-1836-7
Electronic_ISBN :
978-1-4244-1837-4
DOI :
10.1109/ICDE.2008.4497572