Proceedings 18th International Conference on Data Engineering (2002)
San Jose, California
Feb. 26, 2002 to Mar. 1, 2002
Wolfgang Lehner , University of Erlangen-Nuremberg
Wolfgang Hümmer , University of Erlangen-Nuremberg
Lutz Schlesinger , University of Erlangen-Nuremberg
Reporting functions reflect a novel technique to formulate sequence-oriented queries in SQL. They extend the classical way of grouping and applying aggregation functions by additionally providing a column-based ordering, partitioning, and windowing mechanism. The application area of reporting functions ranges from simple ranking queries (TOP(n)-analyses) over cumulative (Year-To-Date- analyses) to sliding window queries. In this paper we discuss the problem of deriving reporting function queries from materialized reporting function views, which is one of the most important issues in efficiently processing queries in a data warehouse environment. Two different derivation algorithms including their relational mappings are introduced and compared in a test scenario.
Wolfgang Lehner, Wolfgang Hümmer, Lutz Schlesinger, "Processing Reporting Function Views in a Data Warehouse Environment", Proceedings 18th International Conference on Data Engineering, vol. 00, no. , pp. 0176, 2002, doi:10.1109/ICDE.2002.994707