A Metadata Driven Approach to Performing Complex Heterogeneous Database Schema Migrations

Robert M. Marks, Roy Sterritt

Research output: Contribution to journalArticle

Abstract

Enterprise software is evolving at a faster rate than ever before with customer's expecting upgrades to occur regularly. These upgrades not only have complex consequences for legacy software but the database upgrade also. This paper discusses the challenges associated with relational database schema migrations which commonly occur with major upgrade releases of enterprise software. The most prevalent method of performing a schema migration is to execute SQL script files before or after the software upgrade. This approach performs poorly with large or complex database migrations and also requires separate script files for each supported database vendor. A tool was developed for a complex database upgrade of an enterprise product which uses XML in a metadata driven approach. The key advantages include the ability to abstract complexity, provide multi-database vendor support and make the database migration more manageable between software releases. This marks an evolutionary step towards autonomic self-migrations.
LanguageEnglish
Pages179-190
JournalNASA Innovations in Systems and Software Engineering
Volume9
Issue number3
DOIs
Publication statusPublished - Sep 2013

Fingerprint

Metadata
Enterprise software
XML
Industry

Cite this

@article{e13f2bc7bd0d4104849320e7fc619030,
title = "A Metadata Driven Approach to Performing Complex Heterogeneous Database Schema Migrations",
abstract = "Enterprise software is evolving at a faster rate than ever before with customer's expecting upgrades to occur regularly. These upgrades not only have complex consequences for legacy software but the database upgrade also. This paper discusses the challenges associated with relational database schema migrations which commonly occur with major upgrade releases of enterprise software. The most prevalent method of performing a schema migration is to execute SQL script files before or after the software upgrade. This approach performs poorly with large or complex database migrations and also requires separate script files for each supported database vendor. A tool was developed for a complex database upgrade of an enterprise product which uses XML in a metadata driven approach. The key advantages include the ability to abstract complexity, provide multi-database vendor support and make the database migration more manageable between software releases. This marks an evolutionary step towards autonomic self-migrations.",
author = "Marks, {Robert M.} and Roy Sterritt",
year = "2013",
month = "9",
doi = "10.1007/s11334-013-0217-8",
language = "English",
volume = "9",
pages = "179--190",
journal = "Innovations in Systems and Software Engineering",
issn = "1614-5046",
number = "3",

}

A Metadata Driven Approach to Performing Complex Heterogeneous Database Schema Migrations. / Marks, Robert M.; Sterritt, Roy.

In: NASA Innovations in Systems and Software Engineering, Vol. 9, No. 3, 09.2013, p. 179-190.

Research output: Contribution to journalArticle

TY - JOUR

T1 - A Metadata Driven Approach to Performing Complex Heterogeneous Database Schema Migrations

AU - Marks, Robert M.

AU - Sterritt, Roy

PY - 2013/9

Y1 - 2013/9

N2 - Enterprise software is evolving at a faster rate than ever before with customer's expecting upgrades to occur regularly. These upgrades not only have complex consequences for legacy software but the database upgrade also. This paper discusses the challenges associated with relational database schema migrations which commonly occur with major upgrade releases of enterprise software. The most prevalent method of performing a schema migration is to execute SQL script files before or after the software upgrade. This approach performs poorly with large or complex database migrations and also requires separate script files for each supported database vendor. A tool was developed for a complex database upgrade of an enterprise product which uses XML in a metadata driven approach. The key advantages include the ability to abstract complexity, provide multi-database vendor support and make the database migration more manageable between software releases. This marks an evolutionary step towards autonomic self-migrations.

AB - Enterprise software is evolving at a faster rate than ever before with customer's expecting upgrades to occur regularly. These upgrades not only have complex consequences for legacy software but the database upgrade also. This paper discusses the challenges associated with relational database schema migrations which commonly occur with major upgrade releases of enterprise software. The most prevalent method of performing a schema migration is to execute SQL script files before or after the software upgrade. This approach performs poorly with large or complex database migrations and also requires separate script files for each supported database vendor. A tool was developed for a complex database upgrade of an enterprise product which uses XML in a metadata driven approach. The key advantages include the ability to abstract complexity, provide multi-database vendor support and make the database migration more manageable between software releases. This marks an evolutionary step towards autonomic self-migrations.

U2 - 10.1007/s11334-013-0217-8

DO - 10.1007/s11334-013-0217-8

M3 - Article

VL - 9

SP - 179

EP - 190

JO - Innovations in Systems and Software Engineering

T2 - Innovations in Systems and Software Engineering

JF - Innovations in Systems and Software Engineering

SN - 1614-5046

IS - 3

ER -