Database application evolution: a transformational approach

Jean-Marc Hick, Jean-Luc Hainaut

Research output: Contribution to journalArticle

Abstract

Abstract. While recent data management technologies, such as object oriented techniques, address the problem of database schema evolution, standard information systems currently in use raise challenging evolution problems. This paper examines database evolution from the developer point of view. It shows how requirements changes are propagated to database schemas, to data and to programs through a general strategy. This strategy requires the documentation of database design. When absent, such documentation has to be rebuilt through reverse engineering techniques. Our approach, called DB-MAIN, relies on a generic database model and on transformational paradigm that states that database engineering processes can be modeled by schema transformations. Indeed, a transformation provides both structural and instance mappings that formally define how to modify database structures and contents. We describe both the complete and a simplified approaches, and compare their merits and drawbacks. We then analyze the problem of program modification and describe a CASE tool that can assist developers in their task of system evolution. We illustrate our approach with Biomaze, a biochemical knowledge-based the database of which is rapidly evolving.
Original languageEnglish
Pages (from-to)534-558
Number of pages25
JournalData & Knowledge Engineering
Volume59
Issue number3
Publication statusPublished - 2006

Fingerprint

Reverse engineering
Information management
Information systems

Keywords

  • History
  • CASE tools
  • Schema transformation
  • Reverse engineering
  • Evolution
  • Database conversion

Cite this

@article{3e5006caca7d4524a55c75d722fa81ad,
title = "Database application evolution: a transformational approach",
abstract = "Abstract. While recent data management technologies, such as object oriented techniques, address the problem of database schema evolution, standard information systems currently in use raise challenging evolution problems. This paper examines database evolution from the developer point of view. It shows how requirements changes are propagated to database schemas, to data and to programs through a general strategy. This strategy requires the documentation of database design. When absent, such documentation has to be rebuilt through reverse engineering techniques. Our approach, called DB-MAIN, relies on a generic database model and on transformational paradigm that states that database engineering processes can be modeled by schema transformations. Indeed, a transformation provides both structural and instance mappings that formally define how to modify database structures and contents. We describe both the complete and a simplified approaches, and compare their merits and drawbacks. We then analyze the problem of program modification and describe a CASE tool that can assist developers in their task of system evolution. We illustrate our approach with Biomaze, a biochemical knowledge-based the database of which is rapidly evolving.",
keywords = "History, CASE tools, Schema transformation, Reverse engineering, Evolution, Database conversion",
author = "Jean-Marc Hick and Jean-Luc Hainaut",
year = "2006",
language = "English",
volume = "59",
pages = "534--558",
journal = "Data & Knowledge Engineering",
number = "3",

}

Database application evolution: a transformational approach. / Hick, Jean-Marc; Hainaut, Jean-Luc.

In: Data & Knowledge Engineering, Vol. 59, No. 3, 2006, p. 534-558.

Research output: Contribution to journalArticle

TY - JOUR

T1 - Database application evolution: a transformational approach

AU - Hick, Jean-Marc

AU - Hainaut, Jean-Luc

PY - 2006

Y1 - 2006

N2 - Abstract. While recent data management technologies, such as object oriented techniques, address the problem of database schema evolution, standard information systems currently in use raise challenging evolution problems. This paper examines database evolution from the developer point of view. It shows how requirements changes are propagated to database schemas, to data and to programs through a general strategy. This strategy requires the documentation of database design. When absent, such documentation has to be rebuilt through reverse engineering techniques. Our approach, called DB-MAIN, relies on a generic database model and on transformational paradigm that states that database engineering processes can be modeled by schema transformations. Indeed, a transformation provides both structural and instance mappings that formally define how to modify database structures and contents. We describe both the complete and a simplified approaches, and compare their merits and drawbacks. We then analyze the problem of program modification and describe a CASE tool that can assist developers in their task of system evolution. We illustrate our approach with Biomaze, a biochemical knowledge-based the database of which is rapidly evolving.

AB - Abstract. While recent data management technologies, such as object oriented techniques, address the problem of database schema evolution, standard information systems currently in use raise challenging evolution problems. This paper examines database evolution from the developer point of view. It shows how requirements changes are propagated to database schemas, to data and to programs through a general strategy. This strategy requires the documentation of database design. When absent, such documentation has to be rebuilt through reverse engineering techniques. Our approach, called DB-MAIN, relies on a generic database model and on transformational paradigm that states that database engineering processes can be modeled by schema transformations. Indeed, a transformation provides both structural and instance mappings that formally define how to modify database structures and contents. We describe both the complete and a simplified approaches, and compare their merits and drawbacks. We then analyze the problem of program modification and describe a CASE tool that can assist developers in their task of system evolution. We illustrate our approach with Biomaze, a biochemical knowledge-based the database of which is rapidly evolving.

KW - History

KW - CASE tools

KW - Schema transformation

KW - Reverse engineering

KW - Evolution

KW - Database conversion

M3 - Article

VL - 59

SP - 534

EP - 558

JO - Data & Knowledge Engineering

JF - Data & Knowledge Engineering

IS - 3

ER -