Collateral evolution of applications and databases

Dien Yen Lin, Iulian Neamtiu

Research output: Chapter in Book/Report/Conference proceedingConference contribution

30 Scopus citations

Abstract

Separating the evolution of an application from the evolution of its persistent data, or from the evolution of the database system used to store the data can have collateral effects, such as data loss, program failure, or decreased performance. In this paper, we use empirical evidence to identify challenges and solutions associated with the collateral evolution of application programs and databases. We first perform an evolution study that identifies changes to database schemas in two popular open source applications. Next, we study the evolution of database file formats for three widely-used database management systems. We then investigate how application programs and database management systems cope with these changes, and point out how collateral evolution can lead to potential problems. Finally, we sketch solutions for facilitating and ensuring the safety of application and database evolution, hence minimizing collateral effects.

Original languageEnglish (US)
Title of host publicationIWPSE-Evol'09 - Proceedings of the Joint International and Annual ERCIM Workshops on Principles of Software Evolution and Software Evolution
Pages31-40
Number of pages10
DOIs
StatePublished - 2009
Externally publishedYes
EventJoint International and Annual ERCIM Workshops on Principles of Software Evolution and Software Evolution, IWPSE-Evol'09 - Amsterdam, Netherlands
Duration: Aug 24 2009Aug 25 2009

Publication series

NameInternational Workshop on Principles of Software Evolution (IWPSE)

Other

OtherJoint International and Annual ERCIM Workshops on Principles of Software Evolution and Software Evolution, IWPSE-Evol'09
Country/TerritoryNetherlands
CityAmsterdam
Period8/24/098/25/09

All Science Journal Classification (ASJC) codes

  • Software
  • Theoretical Computer Science
  • Modeling and Simulation
  • Computational Theory and Mathematics

Keywords

  • Collateral evolution
  • Coupled software transformation
  • Empirical study
  • Mozilla
  • Schema evolution
  • Schema migration
  • Software evolution
  • Sqlite

Fingerprint

Dive into the research topics of 'Collateral evolution of applications and databases'. Together they form a unique fingerprint.

Cite this