Queries on Dates: Fast Yet Not Blind

Data warehouses are repositories of electronically stored data which are designed to support reporting and analysis. The analysis of historical data often involves aggregation over time. Thus, time is critical in the design of a data warehouse. The authors describe novel techniques for storing date information and optimization of queries that reference the date dimension. They show how to embed intelligence into the date key and how to exploit monotonic dependencies. They present the value of these techniques for the improvement of performance when combined with partitioning and indexes.

Provided by: Association for Computing Machinery Topic: Big Data Date Added: Mar 2011 Format: PDF

Find By Topic