loading...
Processing Reporting Function Views in a Data Warehouse Environment
San Jose, California February 26-March 01
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2002.99470718th International Conference on Data ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
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.
Citation:
Wolfgang Lehner, Wolfgang Hümmer, Lutz Schlesinger, "Processing Reporting Function Views in a Data Warehouse Environment," icde, pp.0176, 18th International Conference on Data Engineering (ICDE'02), 2002
Usage of this product signifies your acceptance of the Terms of Use.