Skip to main content
SpringerLink
Log in

Analysis of the Blocking Behaviour of Schema Transformations in Relational Database Systems

  • Conference paper
  • First Online:
Advances in Databases and Information Systems (ADBIS 2015)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 9282))

Abstract

In earlier work we have extended the TPC-C benchmark with basic and complex schema transformations. This paper uses this benchmark to investigate the blocking behaviour of online schema transformations in PostgreSQL, MySQL and Oracle 11g. First we discuss experiments using the data definition language of the DBMSs, which show that all complex operations are blocking, while we have mixed results for basic transformations. Second, we look at a technique for online schema transformations by Ronström, based on triggers. Our experiments show that pt-online-schema-change for MySQL and DBMS_REDEFINITION for Oracle can perform basic transformations without blocking, however, support for complex transformations is missing. To conclude, we provide a solution outline for complex non-blocking transformations.

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 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight 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

Notes

  1. 1.

    http://dev.mysql.com/doc/refman/5.6/en/innodb-online-ddl.html.

  2. 2.

    http://www.percona.com/doc/percona-toolkit/2.1/pt-online-schema-change.html.

  3. 3.

    http://openarkkit.googlecode.com/svn/trunk/openarkkit/doc/html/oak-online-alter-table.html.

  4. 4.

    https://www.facebook.com/notes/mysql-at-facebook/online-schema-change-for-mysql/430801045932.

  5. 5.

    http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_redefi.htm.

  6. 6.

    http://www.tpc.org/tpcc/spec/tpcc_current.pdf.

  7. 7.

    http://wwwhome.ewi.utwente.nl/~weversl2/?page=ost.

  8. 8.

    http://hammerora.sourceforge.net/.

  9. 9.

    http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_editions.htm.

  10. 10.

    http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_parallel_ex.htm.

References

  1. Ferrandina, F., Meyer, T., Zicari, R.: Implementing lazy database updates for an object database system. In: VLDB 1994, pp. 261–272 (1994)

    Google Scholar 

  2. Garcia-Molina, H., Salem, K.: Sagas. In: SIGMOD 1987. pp. 249–259. ACM (1987)

    Google Scholar 

  3. Løland, J., Hvasshovd, S.-O.: Online, non-blocking relational schema changes. In: Ioannidis, Y., Scholl, M.H., Schmidt, J.W., Matthes, F., Hatzopoulos, M., Böhm, K., Kemper, A., Grust, T., Böhm, C. (eds.) EDBT 2006. LNCS, vol. 3896, pp. 405–422. Springer, Heidelberg (2006)

    Chapter  Google Scholar 

  4. Neamtiu, I., Bardin, J., Uddin, M.R., Lin, D.Y., Bhattacharya, P.: Improving cloud availability with on-the-fly schema updates. In: COMAD 2013, pp. 24–34. Computer Society of India (2013)

    Google Scholar 

  5. Neamtiu, I., Dumitras, T.: Cloud software upgrades: challenges and opportunities. In: MESOCA 2011, pp. 1–10. IEEE (2011)

    Google Scholar 

  6. Ronström, M.: On-line schema update for a telecom database. In: ICDE 2000, pp. 329–338. IEEE (2000)

    Google Scholar 

  7. Sockut, G.H., Iyer, B.R.: Online reorganization of databases. ACM Comput. Surv. 41(3), 14:1–14:136 (2009)

    Article  Google Scholar 

  8. Wevers, L., Hofstra, M., Tammens, M., Huisman, M., van Keulen, M.: A benchmark for online non-blocking schema transformations. In: DATA 2015 (2015)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. University of Twente, Enschede, The Netherlands

    Lesley Wevers, Matthijs Hofstra, Menno Tammens, Marieke Huisman & Maurice van Keulen

Authors
  1. Lesley Wevers
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Matthijs Hofstra
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Menno Tammens
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Marieke Huisman
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Maurice van Keulen
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Lesley Wevers .

Editor information

Editors and Affiliations

  1. Poznan University of Technology, Poznán, Poland

    Morzy Tadeusz

  2. INRIA, Montpellier, France

    Patrick Valduriez

  3. Teleport 2, LIAS/ISAE-ENSMA, Poitiers, France

    Ladjel Bellatreche

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Wevers, L., Hofstra, M., Tammens, M., Huisman, M., van Keulen, M. (2015). Analysis of the Blocking Behaviour of Schema Transformations in Relational Database Systems. In: Tadeusz, M., Valduriez, P., Bellatreche, L. (eds) Advances in Databases and Information Systems. ADBIS 2015. Lecture Notes in Computer Science(), vol 9282. Springer, Cham. https://doi.org/10.1007/978-3-319-23135-8_12

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-23135-8_12

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-23134-1

  • Online ISBN: 978-3-319-23135-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation