Collateral evolution of applications and databases

Authors:
Dien-Yen Lin;Iulian Neamtiu
Affiliations:
University of California, Riverside, Riverside, CA, USA;University of California, Riverside, Riverside, CA, USA
Venue:
Proceedings of the joint international and annual ERCIM workshops on Principles of software evolution (IWPSE) and software evolution (Evol) workshops
Year:
2009

Citing 15
Cited 2

An architecture for automatic relational database sytem conversion

ACM Transactions on Database Systems (TODS)
A model for compound type changes encountered in schema evolution

ACM Transactions on Database Systems (TODS)
Foundations of Databases: The Logical Level

Foundations of Databases: The Logical Level
Schema and Database Evolution in the O2 Object Database System

VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
A survey of approaches to automatic schema matching

The VLDB Journal — The International Journal on Very Large Data Bases
Ontology mapping: the state of the art

The Knowledge Engineering Review
Practical dynamic software updating for C

Proceedings of the 2006 ACM SIGPLAN conference on Programming language design and implementation
Relational lenses: a language for updatable views

Proceedings of the twenty-fifth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Implementing mapping composition

VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Understanding collateral evolution in Linux device drivers

Proceedings of the 1st ACM SIGOPS/EuroSys European Conference on Computer Systems 2006
No more HotDependencies: toward dependency-agnostic online upgrades in distributed systems

HotDep'07 Proceedings of the 3rd workshop on on Hot Topics in System Dependability
Boomerang: resourceful lenses for string data

Proceedings of the 35th annual ACM SIGPLAN-SIGACT symposium on Principles of programming languages
Coupled Transformation of Schemas, Documents, Queries, and Constraints

Electronic Notes in Theoretical Computer Science (ENTCS)
Graceful database schema evolution: the PRISM workbench

Proceedings of the VLDB Endowment
Co-transformations in database applications evolution

GTTSE'05 Proceedings of the 2005 international conference on Generative and Transformational Techniques in Software Engineering

Dynamic updates for web and cloud applications

APLWACA '10 Proceedings of the 2010 Workshop on Analysis and Programming Languages for Web Applications and Cloud Applications
An empirical analysis of the co-evolution of schema and code in database applications

Proceedings of the 2013 9th Joint Meeting on Foundations of Software Engineering

Quantified Score

Hi-index	0.00

Visualization

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.