Adjoined Dimension Column Clustering to Improve Data Warehouse Query Performance | IEEE Conference Publication | IEEE Xplore

Adjoined Dimension Column Clustering to Improve Data Warehouse Query Performance


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 databa...Show More

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.
Date of Conference: 07-12 April 2008
Date Added to IEEE Xplore: 25 April 2008
ISBN Information:

ISSN Information:

Conference Location: Cancun, Mexico

Contact IEEE to Subscribe

References

References is not available for this document.