loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
18th International Conference on Data Engineering (ICDE'02)
Processing Reporting Function Views in a Data Warehouse Environment
San Jose, California
February 26-March 01
ISBN: 0-7695-1531-2
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.