Data currency quality satisfaction in the design of a data warehouse

Dimitri Theodoratos, Mokrane Bouzeghoub

Research output: Contribution to journalArticlepeer-review

13 Scopus citations

Abstract

A Data Warehouse (DW) is a large collection of data integrated from multiple distributed autonomous databases and other information sources. A DW can be seen as a set of materialized views defined over the remote source data. Until now research work on DW design is restricted to quantitatively selecting view sets for materialization. However, quality issues in the DW design are neglected. In this paper we suggest a novel statement of the DW design problem that takes into account quality factors. We design a DW system architecture that supports performance and data consistency quality goals. In this framework we present a high level approach that allows to check whether a view selection guaranteeing a data completeness quality goal also satisfies a data currency quality goal. This approach is based on an AND/OR dag representation for multiple queries and views. It also allows determining the minimal change propagation frequencies that satisfy the data currency quality goal along with the optimal query evaluation and change propagation plans. Our results can be directly used for a quality driven design of a DW.

Original languageEnglish (US)
Pages (from-to)299-326
Number of pages28
JournalInternational Journal of Cooperative Information Systems
Volume10
Issue number3
DOIs
StatePublished - Sep 1 2001
Externally publishedYes

All Science Journal Classification (ASJC) codes

  • Information Systems
  • Computer Science Applications

Keywords

  • Currency constraints
  • Data warehouse design
  • Data warehousing
  • Materialized views
  • Quality goals

Fingerprint Dive into the research topics of 'Data currency quality satisfaction in the design of a data warehouse'. Together they form a unique fingerprint.

Cite this