The Community for Technology Leaders
Scientific and Statistical Database Management, International Conference on (2006)
Vienna, Austria
July 3, 2006 to July 5, 2006
ISSN: 1551-6393
ISBN: 0-7695-2590-3
pp: 159-168
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 view. We demonstrate the efficiency of our approach with a large number of experiments
Query processing, Data warehouses, Database systems, Runtime, Sorting, Marine vehicles, Conference management
"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
282 ms
(Ver 3.3 (11022016))