Present and future directions in data warehousing

  • Authors:
  • Paul Gray;Hugh J. Watson

  • Affiliations:
  • Claremont Graduate University;The University of Georgia

  • Venue:
  • ACM SIGMIS Database
  • Year:
  • 1998

Quantified Score

Hi-index 0.01

Visualization

Abstract

Many large organizations have developed data warehouses to support decision making. The data in a warehouse are subject oriented, integrated, time variant, and nonvolatile. A data warehouse contains five types of data: current detail data, older detail data, lightly summarized data, highly summarized data, and metadata. The architecture of a data warehouse includes a backend process (the extraction of data from source systems), the warehouse, and the front-end use (the accessing of data from the warehouse). A data mart is a smaller version of a data warehouse that supports the narrower set of requirements of a single business unit. Data marts should be developed in an integrated manner in order to avoid repeating the "silos of information" problem.An operational data store is a database for transaction processing systems that uses the data warehouse approach to provide clean data. Data warehousing is constantly changing, with the associated opportunities for practice and research, such as the potential for knowledge management using the warehouse.