Skip to main content
SpringerLink
Log in

Data Migration Management

  • Reference work entry
  • First Online:
Encyclopedia of Database Systems

  • 64 Accesses

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 via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Recommended Reading

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

    Article  Google Scholar 

  5. Douglis F, Ousterhout J. Transparent process migration: design alternatives and the sprite implementation. Softw Practice Exp. 1991;21(8):757–85.

    Article  Google Scholar 

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

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of Chicago, Chicago, IL, USA

    Aaron J. Elmore

Authors
  1. Aaron J. Elmore
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Aaron J. Elmore .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, GA, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, ON, Canada

    M. Tamer Özsu

Rights and permissions

Reprints and permissions

Copyright information

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

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Elmore, A.J. (2018). Data Migration Management. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_80640

Download citation

Publish with us

Policies and ethics

Search

Navigation