Analysis of the blocking behaviour of schema transformations in relational database systems

L. Wevers, Matthijs Hofstra, Menno Tammens, Marieke Huisman, Maurice van Keulen

Research output: Chapter in Book/Report/Conference proceedingConference contribution

  • 1 Citations

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.
LanguageUndefined
Title of host publicationProceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015
Place of PublicationBerlin
PublisherSpringer Verlag
Pages169-183
Number of pages15
ISBN (Print)978-3-319-23134-1
DOIs
StatePublished - Sep 2015
Event19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015 - Poitiers, France
Duration: 8 Sep 201511 Sep 2015
Conference number: 19

Publication series

NameLecture Notes in Computer Science
PublisherSpringer Verlag
Volume9282
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Conference

Conference19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015
Abbreviated titleADBIS
CountryFrance
CityPoitiers
Period8/09/1511/09/15

Keywords

  • EWI-26212
  • METIS-314939
  • IR-98042
  • CR-H.2.7

Cite this

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 Proceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015 (pp. 169-183). (Lecture Notes in Computer Science; Vol. 9282). Berlin: Springer Verlag. DOI: 10.1007/978-3-319-23135-8_12
Wevers, L. ; Hofstra, Matthijs ; Tammens, Menno ; Huisman, Marieke ; van Keulen, Maurice. / Analysis of the blocking behaviour of schema transformations in relational database systems. Proceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015. Berlin : Springer Verlag, 2015. pp. 169-183 (Lecture Notes in Computer Science).
@inproceedings{c8746b7d2f9e4ec0a4efbd8ad2bf9259,
title = "Analysis of the blocking behaviour of schema transformations in relational database systems",
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{\"o}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.",
keywords = "EWI-26212, METIS-314939, IR-98042, CR-H.2.7",
author = "L. Wevers and Matthijs Hofstra and Menno Tammens and Marieke Huisman and {van Keulen}, Maurice",
note = "eemcs-eprint-26212",
year = "2015",
month = "9",
doi = "10.1007/978-3-319-23135-8_12",
language = "Undefined",
isbn = "978-3-319-23134-1",
series = "Lecture Notes in Computer Science",
publisher = "Springer Verlag",
pages = "169--183",
booktitle = "Proceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015",
address = "Germany",

}

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 Proceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015. Lecture Notes in Computer Science, vol. 9282, Springer Verlag, Berlin, pp. 169-183, 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015, Poitiers, France, 8/09/15. DOI: 10.1007/978-3-319-23135-8_12

Analysis of the blocking behaviour of schema transformations in relational database systems. / Wevers, L.; Hofstra, Matthijs; Tammens, Menno; Huisman, Marieke; van Keulen, Maurice.

Proceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015. Berlin : Springer Verlag, 2015. p. 169-183 (Lecture Notes in Computer Science; Vol. 9282).

Research output: Chapter in Book/Report/Conference proceedingConference contribution

TY - GEN

T1 - Analysis of the blocking behaviour of schema transformations in relational database systems

AU - Wevers,L.

AU - Hofstra,Matthijs

AU - Tammens,Menno

AU - Huisman,Marieke

AU - van Keulen,Maurice

N1 - eemcs-eprint-26212

PY - 2015/9

Y1 - 2015/9

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

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

KW - EWI-26212

KW - METIS-314939

KW - IR-98042

KW - CR-H.2.7

U2 - 10.1007/978-3-319-23135-8_12

DO - 10.1007/978-3-319-23135-8_12

M3 - Conference contribution

SN - 978-3-319-23134-1

T3 - Lecture Notes in Computer Science

SP - 169

EP - 183

BT - Proceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015

PB - Springer Verlag

CY - Berlin

ER -

Wevers L, Hofstra M, Tammens M, Huisman M, van Keulen M. Analysis of the blocking behaviour of schema transformations in relational database systems. In Proceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015. Berlin: Springer Verlag. 2015. p. 169-183. (Lecture Notes in Computer Science). Available from, DOI: 10.1007/978-3-319-23135-8_12