IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

Reducing the Size of Auxiliary Data Needed to Support Materialized View Maintenance in a Data Warehouse Environment

Reducing the Size of Auxiliary Data Needed to Support Materialized View Maintenance in a Data Warehouse Environment
View Free PDF
Author(s): Lubomir Stanchev (Indiana University – Purdue University Fort Wayne, USA)
Copyright: 2007
Pages: 4
Source title: Managing Worldwide Operations and Communications with Information Technology
Source Editor(s): Mehdi Khosrow-Pour, D.B.A. (Information Resources Management Association, USA)
DOI: 10.4018/978-1-59904-929-8.ch001
ISBN13: 9781599049298
EISBN13: 9781466665378

Abstract

A data warehouse consists of a set of materialized views that contain derived data from several data sources. Materialized views are beneficial because they allow efficient re-trieval of summary data. However, materialized views need to be refreshed periodically in order to avoid staleness. During a materialized view refresh, only changes to the base tables are transmitted from the data sources to the data warehouse, where the data ware-house should contain the data from the base tables that is relevant to the refresh. In this paper we explore how this additional data, which is commonly referred to as auxiliary views, can be reduced in size. Novel algorithms that exploit non-trivial integrity con-straints and that can handle materialized views defined over queries with grouping and aggregation are presented in the paper.

Body Bottom