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 proceedingConference 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 languageEnglish (US)
    Title of host publicationProceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999
    PublisherAssociation for Computing Machinery
    Pages22-29
    Number of pages8
    ISBN (Electronic)1581132204, 9781581132205
    DOIs
    StatePublished - Nov 6 1999
    Event2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999 - Kansas City, United States
    Duration: Nov 2 1999Nov 6 1999

    Publication series

    NameDOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP
    VolumePart F129191

    Other

    Other2nd ACM International Workshop on Data Warehousing and OLAP, DOLAP 1999
    CountryUnited States
    CityKansas City
    Period11/2/9911/6/99

    All Science Journal Classification (ASJC) codes

    • Computer Science(all)

    Fingerprint Dive into the research topics of 'Dealing with slow-evolving fact: A case study on inventory data warehousing'. Together they form a unique fingerprint.

    Cite this