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

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

doi:10.1007/978-3-319-23135-8_12

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

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

Databases (Former)

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › Academic › peer-review

2 Citations (Scopus)

289 Downloads (Pure)

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.

Original language	English
Title of host publication	Proceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015
Place of Publication	Berlin
Publisher	Springer
Pages	169-183
Number of pages	15
ISBN (Print)	978-3-319-23134-1
DOIs	https://doi.org/10.1007/978-3-319-23135-8_12
Publication status	Published - Sept 2015
Event	19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015 - Poitiers, France Duration: 8 Sept 2015 → 11 Sept 2015 Conference number: 19

Publication series

Name	Lecture Notes in Computer Science
Publisher	Springer Verlag
Volume	9282
ISSN (Print)	0302-9743
ISSN (Electronic)	1611-3349

Conference

Conference	19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015
Abbreviated title	ADBIS
Country/Territory	France
City	Poitiers
Period	8/09/15 → 11/09/15

Keywords

CR-H.2.7
Chunk size
Schema transformation
Basic transformation
Solution outline
Original table

Access to Document

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

Wevers2015analysisAccepted author version, 487 KB

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). Springer. https://doi.org/10.1007/978-3-319-23135-8_12

@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 = "CR-H.2.7, Chunk size, Schema transformation, Basic transformation, Solution outline, Original table",

author = "L. Wevers and Matthijs Hofstra and Menno Tammens and Marieke Huisman and {van Keulen}, Maurice",

year = "2015",

month = sep,

doi = "10.1007/978-3-319-23135-8_12",

language = "English",

isbn = "978-3-319-23134-1",

series = "Lecture Notes in Computer Science",

publisher = "Springer",

pages = "169--183",

booktitle = "Proceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015",

address = "Germany",

note = "19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015, ADBIS ; Conference date: 08-09-2015 Through 11-09-2015",

}

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, Berlin, pp. 169-183, 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015, Poitiers, France, 8/09/15. https://doi.org/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 et al.
Proceedings of the 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015. Berlin: Springer, 2015. p. 169-183 (Lecture Notes in Computer Science; Vol. 9282).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › Academic › peer-review

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 - Conference code: 19

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 - CR-H.2.7

KW - Chunk size

KW - Schema transformation

KW - Basic transformation

KW - Solution outline

KW - Original table

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

CY - Berlin

T2 - 19th East European Conference on Advances in Databases and Information Systems, ADBIS 2015

Y2 - 8 September 2015 through 11 September 2015

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. 2015. p. 169-183. (Lecture Notes in Computer Science). doi: 10.1007/978-3-319-23135-8_12

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

Abstract

Publication series

Conference

Keywords

Access to Document

Fingerprint

Cite this