Chapter 3. Data Warehousing

  1. Carlo Vercellis

Published Online: 17 MAR 2009

DOI: 10.1002/9780470753866.ch3

Business Intelligence: Data Mining and Optimization for Decision Making

Business Intelligence: Data Mining and Optimization for Decision Making

How to Cite

Vercellis, C. (2009) Data Warehousing, in Business Intelligence: Data Mining and Optimization for Decision Making, John Wiley & Sons, Ltd, Chichester, UK. doi: 10.1002/9780470753866.ch3

Author Information

  1. Politecnico di Milano, Italy

Publication History

  1. Published Online: 17 MAR 2009
  2. Published Print: 20 MAR 2009

ISBN Information

Print ISBN: 9780470511381

Online ISBN: 9780470753866

SEARCH

Keywords:

  • data warehouses and data marts;
  • definition of data warehouse - internal data, external data and personal data;
  • differences between OLTP and OLAP systems;
  • data warehouses and data marts;
  • data integrity - problems, causes and remedies;
  • data warehouse architecture;
  • ETL functions - extraction, transformation and loading;
  • cubes and multidimensional analysis;
  • structured query language (SQL)

Summary

This chapter contains sections titled:

  • Definition of data warehouse

  • Data warehouse architecture

  • Cubes and multidimensional analysis

  • Notes and readings