Aggregation Everywhere: Data Reduction and Transformation in the Phoenix Data Warehouse.
Steven Tolkin:
Aggregation Everywhere: Data Reduction and Transformation in the Phoenix Data Warehouse.
DOLAP 1999: 79-86@inproceedings{DBLP:conf/dolap/Tolkin99,
author = {Steven Tolkin},
title = {Aggregation Everywhere: Data Reduction and Transformation in
the Phoenix Data Warehouse},
booktitle = {DOLAP '99, ACM Second International Workshop on Data Warehousing
and OLAP, November 6, 1999, Kansas City, Missouri, USA, Proceedings},
publisher = {ACM},
year = {1999},
pages = {79-86},
ee = {db/conf/dolap/Tolkin99.html, http://doi.acm.org/10.1145/319757.319795},
crossref = {DBLP:conf/dolap/99},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
This paper describes the Phoenix system, which loads a data warehouse and then reports against it.
Between the raw atomic data of the source system and the business measures presented to users there are many computing environments.
Aggregation occurs everywhere: initial bucketing by the natural keys on the mainframe, loading the fact table using a mapping table, maintaining aggregate tables and reporting tables in the data base, in the GUI, in SQL queries issued on behalf of client tools by the web server, and inside the client tools themselves.
Producing the desired business measures required writing a comptex SQL query, and post-processing an Excel pivot table.
Copyright © 1999 by the ACM,
Inc., used by permission. Permission to make
digital or hard copies is granted provided that
copies are not made or distributed for profit or
direct commercial advantage, and that copies show
this notice on the first page or initial screen of
a display along with the full citation.
CDROM Version: Load the CDROM "Volume 2 Issue 4, CIKM, DOLAP, GIS, SIGFIDET, ..." and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
DOLAP '99, ACM Second International Workshop on Data Warehousing and OLAP, November 6, 1999, Kansas City, Missouri, USA, Proceedings.
ACM 1999
Contents BibTeX
Online Edition
Citation Page
BibTeX
References
- [1]
- ...
- [2]
- Ralph Kimball:
The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses.
John Wiley 1996, ISBN 0-471-15337-0
BibTeX
- [3]
- ...
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
DOLAP 1999 Proceedings, ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:07:21 2009