DMCA
Automating the database schema evolution process (2013)
| Citations: | 9 - 0 self |
BibTeX
@MISC{Curino13automatingthe,
author = {Carlo Curino and Hyun Jin Moon and Alin Deutsch and Carlo Zaniolo},
title = { Automating the database schema evolution process},
year = {2013}
}
Share
 |
 |
 |
 |
||
OpenURL
Abstract
Supporting database schema evolution represents a long-standing challenge of practical and theoretical importance for modern information systems. In this paper, we describe techniques and systems for automating the critical tasks of migrating the database and rewriting the legacy applications. In addition to labor saving, the benefits delivered by these advances are many and include reliable prediction of outcome, minimization of downtime, system-produced documentation, and support for archiving, historical queries, and provenance. The PRISM/PRISM++ system delivers these benefits, by solving the difficult problem of automating the migration of databases and the rewriting of queries and updates. In this paper, we present the PRISM/PRISM++ system and the novel technology that made it possible. In particular, we focus on the difficult and previously unsolved problem of supporting legacy queries and updates under schema and integrity constraints evolution. The PRISM/PRISM++ approach consists in providing the users with a set of SQL-based Schema Modification Opera-tors (SMOs), which describe how the tables in the old schema are modified into those in the new schema. In order to sup-port updates, SMOs are extended with integrity constraints
Keyphrases
database schema evolution process s00778-012-0302-x special issue paper automating prism prism system long-standing challenge integrity constraint evolution modern information system new schema integrity constraint reliable prediction critical task difficult prob-lem legacy application system-produced documentation legacy query historical query sql-based schema modification opera-tors novel technology old schema sup-port update theoretical importance labor saving prism prism approach
