Processing reporting function views in a data warehouse environment
| Autor: | Lutz Schlesinger, Wolfgang Lehner, Wolfgang Hümmer |
|---|---|
| Rok vydání: | 2003 |
| Předmět: |
SQL
Information retrieval Computer science media_common.quotation_subject computer.software_genre Column (database) Data warehouse Ranking (information retrieval) Information engineering Data warehouses Database systems Data engineering Pattern recognition Performance evaluation Global communication Sorting Engines Cost function Partitioning algorithms Data Warehouse-Systeme Datenbank-Systeme Datentechnik Mustererkennung Leistungsbewertung Globale Kommunikation Sortierung Suchmaschinen Kostenfunktion Partitionierungsalgorithmen Data mining ddc:004 Function (engineering) computer computer.programming_language media_common |
| Zdroj: | ICDE |
| DOI: | 10.1109/icde.2002.994707 |
| Popis: | 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. 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. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|