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

Chung Min Chen; Munir Cochinwala; Elsa Yueh

doi:10.1145/319757.319783

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

Chung Min Chen, Munir Cochinwala, Elsa Yueh

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

2 Scopus citations

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.

Original language	English (US)
Title of host publication	Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999
Publisher	Association for Computing Machinery
Pages	22-29
Number of pages	8
ISBN (Electronic)	1581132204, 9781581132205
DOIs	https://doi.org/10.1145/319757.319783
State	Published - Nov 6 1999
Event	2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999 - Kansas City, United States Duration: Nov 2 1999 → Nov 6 1999

Publication series

Name	DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP
Volume	Part F129191

Other

Other	2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999
Country/Territory	United States
City	Kansas City
Period	11/2/99 → 11/6/99

All Science Journal Classification (ASJC) codes

General Computer Science

Access to Document

10.1145/319757.319783

Cite this

Chen, C. M., Cochinwala, M., & Yueh, E. (1999). Dealing with slow-evolving fact: A case study on inventory data warehousing. In Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999 (pp. 22-29). (DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP; Vol. Part F129191). Association for Computing Machinery. https://doi.org/10.1145/319757.319783

@inproceedings{b4a5cef71b83438a89c01af8131616f6,

title = "Dealing with slow-evolving fact: A case study on inventory data warehousing",

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.",

author = "Chen, {Chung Min} and Munir Cochinwala and Elsa Yueh",

note = "Publisher Copyright: {\textcopyright} 1999 Telcordia Technologies, Inc. All rights reserved. Copyright ACM 1999.; 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999 ; Conference date: 02-11-1999 Through 06-11-1999",

year = "1999",

month = nov,

day = "6",

doi = "10.1145/319757.319783",

language = "English (US)",

series = "DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP",

publisher = "Association for Computing Machinery",

pages = "22--29",

booktitle = "Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999",

}

Chen, CM, Cochinwala, M & Yueh, E 1999, Dealing with slow-evolving fact: A case study on inventory data warehousing. in Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999. DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP, vol. Part F129191, Association for Computing Machinery, pp. 22-29, 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999, Kansas City, United States, 11/2/99. https://doi.org/10.1145/319757.319783

Dealing with slow-evolving fact: A case study on inventory data warehousing. / Chen, Chung Min; Cochinwala, Munir; Yueh, Elsa.
Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999. Association for Computing Machinery, 1999. p. 22-29 (DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP; Vol. Part F129191).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

TY - GEN

T1 - Dealing with slow-evolving fact

T2 - 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999

AU - Chen, Chung Min

AU - Cochinwala, Munir

AU - Yueh, Elsa

PY - 1999/11/6

Y1 - 1999/11/6

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=77953907039&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=77953907039&partnerID=8YFLogxK

U2 - 10.1145/319757.319783

DO - 10.1145/319757.319783

M3 - Conference contribution

AN - SCOPUS:77953907039

T3 - DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP

SP - 22

EP - 29

BT - Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999

PB - Association for Computing Machinery

Y2 - 2 November 1999 through 6 November 1999

ER -

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

Abstract

Publication series

Other

All Science Journal Classification (ASJC) codes

Access to Document

Other files and links

Fingerprint

Cite this