Scientific and Statistical Database Management, International Conference on (2006)
July 3, 2006 to July 5, 2006
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/SSDBM.2006.32
Dirk Habich , Dresden University of Technology, Germany
Michael Just , Dresden University of Technology, Germany
Wolfgang Lehner , Dresden University of Technology, Germany
Materialized views are a well-known optimization strategy with the potential for massive improvements in query processing time, especially for aggregation queries over large tables. To realize this potential, the query optimizer has to know how and when to exploit materialized views. Reporting functions represent a novel technique to formulate sequence-oriented queries in SQL. They provide a column-wise ordering, partitioning, and windowing mechanism for aggregation functions and therefore extend the well-known way of grouping and applying simple aggregation functions. Up to now, current work has not considered the frequently used reporting functions in data warehouse environments. In this paper, we introduce materialized reporting function views and show how to rewrite queries with reporting functions as well as aggregation queries to this new kind of materialized views. We demonstrate the efficiency of our approach with a large number of experiments.
Dirk Habich, Michael Just, Wolfgang Lehner, "Materialized Views in the Presence of Reporting Functions", Scientific and Statistical Database Management, International Conference on, vol. 00, no. , pp. 159-168, 2006, doi:10.1109/SSDBM.2006.32