Reverse engineering of relational databases: extraction of an EER model from a relational database
Data & Knowledge Engineering
Migrating legacy systems: gateways, interfaces & the incremental approach
Migrating legacy systems: gateways, interfaces & the incremental approach
Database Reorganization—Principles and Practice
ACM Computing Surveys (CSUR)
Data-driven understanding and refinement of schema mappings
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Providing Database Migration Tools - A Practicioner's Approach
VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering
ER '94 Proceedings of the13th International Conference on the Entity-Relationship Approach
Benefits and Quality of Data Modelling - Results of an Empirical Analysis
ER '96 Proceedings of the 15th International Conference on Conceptual Modeling
The Schema Evolution and Data Migration Framework of the Environmental Mass Database IMIS
SSDBM '04 Proceedings of the 16th International Conference on Scientific and Statistical Database Management
Component-driven engineering of database applications
APCCM '06 Proceedings of the 3rd Asia-Pacific conference on Conceptual modelling - Volume 53
Relational Database Migration: A Perspective
DEXA '08 Proceedings of the 19th international conference on Database and Expert Systems Applications
The PRISM Workwench: Database Schema Evolution without Tears
ICDE '09 Proceedings of the 2009 IEEE International Conference on Data Engineering
ICDEW '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering Workshop
SARD: A statistical approach for ranking database tuning parameters
ICDEW '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering Workshop
Probabilistic adaptive load balancing for parallel queries
ICDEW '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering Workshop
A Metadata Driven Approach to Performing Multi-vendor Database Schema Upgrades
ECBS '12 Proceedings of the 2012 IEEE 19th International Conference and Workshops on Engineering of Computer-Based Systems
| Hi-index | 0.00 |
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.