Understanding database schema evolution: A case study

Anthony Cleve, Loup Meurice, Maxime Gobert, Jerome Maes, Jens Weber

Research output: Contribution to journalArticle

426 Downloads (Pure)

Abstract

Database reverse engineering (DRE) has traditionally been carried out by considering three main information sources: (1) the database schema, (2) the stored data, and (3) the application programs. Not all of these information sources are always available, or of sufficient quality to inform the DRE process. For example, getting access to real-world data is often extremely problematic for information systems that maintain private data. In recent years, the analysis of the evolution history of software programs have gained an increasing role in reverse engineering in general, but comparatively little such research has been carried out in the context of database reverse engineering. The goal of this paper is to contribute to narrowing this gap and exploring the use of the database evolution history as an additional information source to aid database schema reverse engineering. We present a tool-supported method for analyzing the evolution history of legacy databases, and we report on a large-scale case study of reverse engineering a complex information system and curate it as a benchmark for future research efforts within the community.

Original languageEnglish
Pages (from-to)113-121
Number of pages9
JournalScience of Computer Programming
Volume97
Issue numberP1
Early online date22 Nov 2013
DOIs
Publication statusPublished - 2015

Keywords

  • Database understanding
  • Schema evolution
  • Software repository mining

Fingerprint Dive into the research topics of 'Understanding database schema evolution: A case study'. Together they form a unique fingerprint.

  • Projects

    Student Theses

    Analyzing, Understanding and Supporting the Evolution of Dynamic and Heterogeneous Data-Intensive Software Systems

    Author: Meurice, L., 22 Jun 2017

    Supervisor: Cleve, A. (Supervisor), Englebert, V. (President), Lanza, M. (External person) (Jury), Mens, T. (External person) (Jury), Frenay, B. (Jury) & Vanhoof, W. (Jury)

    Student thesis: Doc typesDoctor of Sciences

    File

    Cite this