naa a22 4500 510791166 CHVBK 20180411083320.0 cr unu---uuuuu 180411e20130901xx s 000 0 eng 10.1007/s11334-013-0217-8 doi (NATIONALLICENCE)springer-10.1007/s11334-013-0217-8 A metadata driven approach to performing complex heterogeneous database schema migrations [Elektronische Daten] [Robert Marks, Roy Sterritt] 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. Springer-Verlag London, 2013 Autonomic nationallicence Database nationallicence Upgrades nationallicence Migrations nationallicence Metadata nationallicence Marks Robert IBM United Kingdom Limited, Belfast, Northern Ireland, UK aut Sterritt Roy School of Computing and Mathematics, Faculty of Engineering, University of Ulster, Newtownabbey, Northern Ireland, UK aut Innovations in Systems and Software Engineering Springer London 9/3(2013-09-01), 179-190 1614-5046 9:3<179 2013 9 11334 https://doi.org/10.1007/s11334-013-0217-8 text/html Onlinezugriff via DOI 1 research-article jats NATIONALLICENCE 856 40 https://doi.org/10.1007/s11334-013-0217-8 text/html Onlinezugriff via DOI NATIONALLICENCE 700 1- Marks Robert IBM United Kingdom Limited, Belfast, Northern Ireland, UK aut NATIONALLICENCE 700 1- Sterritt Roy School of Computing and Mathematics, Faculty of Engineering, University of Ulster, Newtownabbey, Northern Ireland, UK aut NATIONALLICENCE 773 0- Innovations in Systems and Software Engineering Springer London 9/3(2013-09-01), 179-190 1614-5046 9:3<179 2013 9 11334 Metadata rights reserved Springer special CC-BY-NC licence nationallicence BK010053 XK010053 XK010000 NATIONALLICENCE NATIONALLICENCE NL-springer