scispace - formally typeset
Proceedings ArticleDOI

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

Chung-Min Chen, +2 more
- pp 22-29
Reads0
Chats0
TLDR
Some interesting issues related to the design of the data warehouse are reported, including the issues of slow-evolving fact, transaction-oriented fact table, and large dimensions, and the concept of virtual data cubes is proposed and presented.
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.

read more

Citations
More filters
Journal ArticleDOI

Modeling and analysis of occupancy data: a healthcare capacity planning application

Mark W. Isken
- 01 Dec 2002 - 
TL;DR: A case study at a large tertiary care hospital discusses a number of issues that arise in analyzing occupancy data which have implications for design of healthcare operations oriented data warehouses and analysis tools.

Role of Operational System Design in Data Warehouse Implementation: Identifying the Operational System Design Gaps and techniques to handle them

Deepak Asrani, +2 more
TL;DR: This paper has tried to investigate operational system of the organization for identifying limitations and determine role of operational system design in the process of data warehouse design and implementation and proposed techniques to get a quality data warehouse solution under such limitations.
Proceedings Article

Splitting facts using weights

Liga Grundmane, +1 more
TL;DR: Two solutions of splitting facts by using weights are described, one of the possible solutions is to make the proportional weighting accordingly to splitted record set size and the other is to take into account the length of the fact validity time period and the validity time for each splitted fact record.
References
More filters
Journal ArticleDOI

An overview of data warehousing and OLAP technology

Surajit Chaudhuri, +1 more
TL;DR: An overview of data warehousing and OLAP technologies, with an emphasis on their new requirements, is provided, based on a tutorial presented at the VLDB Conference, 1996.
Journal ArticleDOI

Data cube: a relational aggregation operator generalizing GROUP-BY, CROSS-TAB, and SUB-TOTALS

Jim Gray, +3 more
TL;DR: The data cube operator as discussed by the authors generalizes the histogram, cross-tabulation, roll-up, drill-down, and sub-total constructs found in most report writers.
Book

The data warehouse toolkit: practical techniques for building dimensional data warehouses

Ralph Kimball
TL;DR: This definitive guide succinctly explains how to build a data warehouse by using actual case studies of existing data warehouses developed for specific types of business applications such as retail, manufacturing, banking, insurance, subcriptions and airline reservations.
Journal ArticleDOI

DynaMat: a dynamic view management system for data warehouses

Yannis Kotidis, +1 more
TL;DR: DynaMat is presented, a system that dynamically materializes information at multiple levels of granularity in order to match the demand but also takes into account the maintenance restrictions for the warehouse, such as down time to update the views and space availability.
Book ChapterDOI

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

Chungmin Melvin Chen, +1 more
TL;DR: The design and evaluation of the ADMS optimizer are described and the results showed that pointer caching and dynamic cache update strategies substantially speedup query computations and, thus, increase query throughput under situations with fair query correlation and update load.