Aggregation everywhere: data reduction and transformation in the Phoenix data warehouse

  • Authors:

  • Steven Tolkin

  • Affiliations:

  • Fidelity Investments, 82 Devonshire St., Boston, MA

  • Venue:
  • Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

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 complex SQL query, and post-processing an Excel pivot table.