- Titel
- Processing reporting function views in a data warehouse environment
- Zitierfähige Url:
- https://nbn-resolving.org/urn:nbn:de:bsz:14-qucosa2-787803
- Konferenz
- 18th International Conference on Data Engineering. San Jose, CA, 26.02-01.03.2002
- Quellenangabe
- Proceedings 18th International Conference on Data Engineering
Erscheinungsort: New York, NY
Verlag: Institute of Electrical and Electronics Engineers incorporated (IEEE)
Erscheinungsjahr: 2002
Seiten: 176-185
ISBN: 0-7695-1531-2 - Erstveröffentlichung
- 2002
- Abstract (EN)
- 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.
- Andere Ausgabe
- Link zum Artikel, der zuerst in der IEEE Xplore Digital Library erschienen ist:
DOI: 10.1109/ICDE.2002.994707 - Freie Schlagwörter (DE)
- Data Warehouse-Systeme, Datenbank-Systeme, Datentechnik, Mustererkennung, Leistungsbewertung, Globale Kommunikation, Sortierung, Suchmaschinen, Kostenfunktion, Partitionierungsalgorithmen
- Freie Schlagwörter (EN)
- Data warehouses, Database systems, Data engineering, Pattern recognition, Performance evaluation, Global communication, Sorting, Engines, Cost function, Partitioning algorithms
- Klassifikation (DDC)
- 004
- Verlag
- IEEE, New York, NY
- Version / Begutachtungsstatus
- angenommene Version / Postprint / Autorenversion
- URN Qucosa
- urn:nbn:de:bsz:14-qucosa2-787803
- Veröffentlichungsdatum Qucosa
- 02.06.2022
- Dokumenttyp
- Konferenzbeitrag
- Sprache des Dokumentes
- Englisch
- Lizenz / Rechtehinweis
