Dealing with slow-evolving fact: a case study on inventory data warehousing

Authors:
Chung-Min Chen;Munir Cochinwala;Elsa Yueh
Affiliations:
Telcordia Technologies (formerly Bellcore), Morristown, NJ;Telcordia Technologies (formerly Bellcore), Morristown, NJ;Telcordia Technologies (formerly Bellcore), Morristown, NJ
Venue:
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Year:
1999

Citing 5
Cited 0

The implementation and performance evaluation of the ADMS query optimizer: integrating query result caching and matching

EDBT '94 Proceedings of the 4th international conference on extending database technology: Advances in database technology
The data warehouse toolkit: practical techniques for building dimensional data warehouses

The data warehouse toolkit: practical techniques for building dimensional data warehouses
An overview of data warehousing and OLAP technology

ACM SIGMOD Record
DynaMat: a dynamic view management system for data warehouses

SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total

ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

Data Warehousing for INventory management (DWIN) is a production project at Telcordia aimed at providing telecommunications service providers with decision support functions for inventory control and monitoring. In this paper, we report some interesting issues related to the design of the data warehouse. Specifically, we will discuss the issues of slow-evolving fact, transaction-oriented fact table, and large dimensions. We also propose the concept of virtual data cubes and show its usefulness. We address these issues through a data mart case study and present benchmarking results. Finally, based on the experiences learned, we discuss potential research issues that may benefit the data warehousing and OLAP practice.