Design and selection of materialized views in a data warehousing environment: a case study

Authors:
Goretti K. Y. Chan;Qing Li;Ling Feng
Affiliations:
Rix Pumps Limited, Computer & Information Systems, Tai Po Industrial Estate, N.T., Hong Kong, China;Dept of Computer Science, City University of Hong Kong, Tat Chee Ave, Kowloon, Hong Kong, China;Dept of Computing, Hong Kong Polytechnic University, Hung Hom, Kowloon, Hong Kong, China
Venue:
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Year:
1999

Citing 4
Cited 4

Implementing data cubes efficiently

SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Making views self-maintainable for data warehousing

DIS '96 Proceedings of the fourth international conference on on Parallel and distributed information systems
Algorithms for Materialized View Design in Data Warehousing Environment

VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
A Framework for Designing Materialized Views in Data Warehousing Environment

ICDCS '97 Proceedings of the 17th International Conference on Distributed Computing Systems (ICDCS '97)

An Experimental Performance Evaluation of Incremental Materialized View Maintenance in Object Databases

DaWaK '01 Proceedings of the Third International Conference on Data Warehousing and Knowledge Discovery
A Query-Driven Approach to the Design and Management of Flexible Database Systems

Journal of Management Information Systems
Data mining-based materialized view and index selection in data warehouses

Journal of Intelligent Information Systems
Clustering-based materialized view selection in data warehouses

ADBIS'06 Proceedings of the 10th East European conference on Advances in Databases and Information Systems

Quantified Score

Hi-index	0.03

Visualization

Abstract

In this paper, we describe the design of a data warehousing system for an engineering company 'R'. A cost model was developed for this system to enable the evaluation of the total costs and benefits involved in selecting each materialized view. Using the cost analysis methodology for evaluation, an adapted greedy algorithm has been implemented for the selection of materialized views. The algorithm and cost model were applied to a set of real-life database items extracted from company 'R'. By selecting the most cost effective set of materialized summary views, the total of the maintenance, storage and query costs of the system is optimized, thereby resulting in an efficient data warehousing system.