European Business Intelligence Summer School

eBISS 2015: Business Intelligence pp 1-31

Schema Evolution for Databases and Data Warehouses

  • Petros Manousis
  • Panos Vassiliadis
  • Apostolos Zarras
  • George Papastefanatos
Conference paper

DOI: 10.1007/978-3-319-39243-1_1

Volume 253 of the book series Lecture Notes in Business Information Processing (LNBIP)
Cite this paper as:
Manousis P., Vassiliadis P., Zarras A., Papastefanatos G. (2016) Schema Evolution for Databases and Data Warehouses. In: Zimányi E., Abelló A. (eds) Business Intelligence. eBISS 2015. Lecture Notes in Business Information Processing, vol 253. Springer, Cham

Abstract

Like all software systems, databases are subject to evolution as time passes. The impact of this evolution is tremendous as every change to the schema of a database affects the syntactic correctness and the semantic validity of all the surrounding applications and de facto necessitates their maintenance in order to remove errors from their source code. This survey provides a walk-through on different approaches to the problem of handling database and data warehouse schema evolution. The areas covered include (a) published case studies with statistical information on database evolution, (b) techniques for managing schema and view evolution, (c) techniques pertaining to the area of data warehouses, and, (d) prospects for future research.

Copyright information

© Springer International Publishing Switzerland 2016

Authors and Affiliations

  • Petros Manousis
    • 1
  • Panos Vassiliadis
    • 1
  • Apostolos Zarras
    • 1
  • George Papastefanatos
    • 2
  1. 1.Department of Computer ScienceUniversity of Ioannina (Ioannina, Hellas)IoanninaGreece
  2. 2.Athena Research Center (Athens, Hellas)AthensGreece