Definition
Database migration can refer to one of several concepts. The first being the migration of data either between database management systems (i.e., moving data from DBMS X to DBMS Y ) or between versions of the same database management system (i.e., moving from DBMS X version 8.1 to version 8.3). Second, database migration can refer to a change in schema, typically the result of an application change. Third, and the focus of this article, refers to the migration of data between two database servers, typically for the purposes of load balancing or server maintenance. Migrating a database with no observable unavailability (downtime) and minimal performance degradation is referred to as live database migration.
Historical Background
The earliest migration techniques were developed for process migration in prototype operating systems, such as V-System and Sprite [5]. These techniques focus on migrating a running...
Recommended Reading
Barker SK, Chi Y, Moon HJ, Hacigümüs H, Prashant J. Shenoy: cut me some slack: latency-aware live migration for databases. EDBT. 2012;432–43.
Bradford R, Kotsovinos E, Feldmann A, Schiöberg H. Live wide-area migration of virtual machines including local persistent state. VEE. 2007;169–79.
Clark C, Fraser K, Hand S, Hansen JG, Jul E, Limpach C, Pratt I, Warfield A. Live migration of virtual machines. NSDI. 2005;2:273–86.
Das S, Nishimura S, Agrawal D, El Abbadi A. Albatross: lightweight elasticity in shared storage databases for the cloud using live data migration. PVLDB. 2011;4(8):494–505.
Douglis F, Ousterhout J. Transparent process migration: design alternatives and the sprite implementation. Softw Practice Exp. 1991;21:757–85.
Elmore AJ, Das S, Agrawal D, El Abbadi A. Zephyr: live migration in shared nothing databases for elastic cloud platforms. SIGMOD. 2011;301–12.
Schiller O, Cipriani N, Mitschang B. ProRea: live database migration for multi-tenant RDBMS with snapshot isolation. EDBT. 2013;53–64.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2017 Springer Science+Business Media LLC
About this entry
Cite this entry
Elmore, A.J. (2017). Data Migration Management. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_80640-1
Download citation
DOI: https://doi.org/10.1007/978-1-4899-7993-3_80640-1
Received:
Accepted:
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4899-7993-3
Online ISBN: 978-1-4899-7993-3
eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering