Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Data Migration Management

  • Aaron J. Elmore
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_80640

Synonyms

Data migration; Database migration; Live database migration

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...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Barker SK, Chi Y, Moon HJ, Hacigümüs H, Prashant J. Shenoy: cut me some slack: latency-aware live migration for databases. In: Proceedings of the 15th International Conference on Extending Database Technology; 2012. p. 432–43.Google Scholar
  2. 2.
    Bradford R, Kotsovinos E, Feldmann A, Schiöberg H. Live wide-area migration of virtual machines including local persistent state. In: Proceedings of the 3rd International Conference on Virtual Execution Environments; 2007. p. 169–79.Google Scholar
  3. 3.
    Clark C, Fraser K, Hand S, Hansen JG, Jul E, Limpach C, Pratt I, Warfield A. Live migration of virtual machines. In: Proceedings of the 2nd USENIX Symposium on Networked Systems Design & Implementation; 2005. p. 273–86.Google Scholar
  4. 4.
    Das S, Nishimura S, Agrawal D, El Abbadi A. Albatross: lightweight elasticity in shared storage databases for the cloud using live data migration. Proc VLDB Endow. 2011;4(8):494–505.CrossRefGoogle Scholar
  5. 5.
    Douglis F, Ousterhout J. Transparent process migration: design alternatives and the sprite implementation. Softw Practice Exp. 1991;21(8):757–85.CrossRefGoogle Scholar
  6. 6.
    Elmore AJ, Das S, Agrawal D, El Abbadi A. Zephyr: live migration in shared nothing databases for elastic cloud platforms. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2011. p. 301–12.Google Scholar
  7. 7.
    Schiller O, Cipriani N, Mitschang B. ProRea: live database migration for multi-tenant RDBMS with snapshot isolation. In: Proceedings of the 16th International Conference on Extending Database Technology; 2013. p. 53–64.Google Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Computer ScienceUniversity of ChicagoChicagoUSA