A Benchmark for Online Non-Blocking Schema Transformations

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

  • 1 Citations

Abstract

This paper presents a benchmark for measuring the blocking behavior of schema transformations in relational database systems. As a basis for our benchmark, we have developed criteria for the functionality and performance of schema transformation mechanisms based on the characteristics of state of the art approaches. To address limitations of existing approaches, we assert that schema transformations must be composable while satisfying the ACID guarantees like regular database transactions. Additionally, we have identified important classes of basic and complex relational schema transformations that a schema transformation mechanism should be able to perform. Based on these transformations and our criteria, we have developed a benchmark that extends the standard TPC-C benchmark with schema transformations, which can be used to analyze the blocking behavior of schema transformations in database systems. The goal of the benchmark is not only to evaluate existing solutions for non-blocking schema transformations, but also to challenge the database community to find solutions that allow more complex transactional schema transformations.
Original languageUndefined
Title of host publicationProceedings of 4th International Conference on Data Management Technologies and Applications, DATA 2015
PublisherSCITEPRESS
Pages288-298
Number of pages11
ISBN (Print)978-989-758-103-8
DOIs
StatePublished - 20 Jul 2015

Publication series

Name
PublisherSciTePress

Fingerprint

Relational database systems

Keywords

  • CR-H.2.7
  • EWI-26142
  • Online schema transformations
  • IR-98040
  • Database transactions
  • METIS-314919
  • Benchmark

Cite this

Wevers, L., Hofstra, M., Tammens, M., Huisman, M., & van Keulen, M. (2015). A Benchmark for Online Non-Blocking Schema Transformations. In Proceedings of 4th International Conference on Data Management Technologies and Applications, DATA 2015 (pp. 288-298). SCITEPRESS. DOI: 10.5220/0005500202880298

Wevers, L.; Hofstra, Matthijs; Tammens, Menno; Huisman, Marieke; van Keulen, Maurice / A Benchmark for Online Non-Blocking Schema Transformations.

Proceedings of 4th International Conference on Data Management Technologies and Applications, DATA 2015. SCITEPRESS, 2015. p. 288-298.

Research output: Scientific - peer-reviewConference contribution

@inbook{1d70aff3f1a8455eb7fabe511242b927,
title = "A Benchmark for Online Non-Blocking Schema Transformations",
abstract = "This paper presents a benchmark for measuring the blocking behavior of schema transformations in relational database systems. As a basis for our benchmark, we have developed criteria for the functionality and performance of schema transformation mechanisms based on the characteristics of state of the art approaches. To address limitations of existing approaches, we assert that schema transformations must be composable while satisfying the ACID guarantees like regular database transactions. Additionally, we have identified important classes of basic and complex relational schema transformations that a schema transformation mechanism should be able to perform. Based on these transformations and our criteria, we have developed a benchmark that extends the standard TPC-C benchmark with schema transformations, which can be used to analyze the blocking behavior of schema transformations in database systems. The goal of the benchmark is not only to evaluate existing solutions for non-blocking schema transformations, but also to challenge the database community to find solutions that allow more complex transactional schema transformations.",
keywords = "CR-H.2.7, EWI-26142, Online schema transformations, IR-98040, Database transactions, METIS-314919, Benchmark",
author = "L. Wevers and Matthijs Hofstra and Menno Tammens and Marieke Huisman and {van Keulen}, Maurice",
note = "eemcs-eprint-26142",
year = "2015",
month = "7",
doi = "10.5220/0005500202880298",
isbn = "978-989-758-103-8",
publisher = "SCITEPRESS",
pages = "288--298",
booktitle = "Proceedings of 4th International Conference on Data Management Technologies and Applications, DATA 2015",

}

Wevers, L, Hofstra, M, Tammens, M, Huisman, M & van Keulen, M 2015, A Benchmark for Online Non-Blocking Schema Transformations. in Proceedings of 4th International Conference on Data Management Technologies and Applications, DATA 2015. SCITEPRESS, pp. 288-298. DOI: 10.5220/0005500202880298

A Benchmark for Online Non-Blocking Schema Transformations. / Wevers, L.; Hofstra, Matthijs; Tammens, Menno; Huisman, Marieke; van Keulen, Maurice.

Proceedings of 4th International Conference on Data Management Technologies and Applications, DATA 2015. SCITEPRESS, 2015. p. 288-298.

Research output: Scientific - peer-reviewConference contribution

TY - CHAP

T1 - A Benchmark for Online Non-Blocking Schema Transformations

AU - Wevers,L.

AU - Hofstra,Matthijs

AU - Tammens,Menno

AU - Huisman,Marieke

AU - van Keulen,Maurice

N1 - eemcs-eprint-26142

PY - 2015/7/20

Y1 - 2015/7/20

N2 - This paper presents a benchmark for measuring the blocking behavior of schema transformations in relational database systems. As a basis for our benchmark, we have developed criteria for the functionality and performance of schema transformation mechanisms based on the characteristics of state of the art approaches. To address limitations of existing approaches, we assert that schema transformations must be composable while satisfying the ACID guarantees like regular database transactions. Additionally, we have identified important classes of basic and complex relational schema transformations that a schema transformation mechanism should be able to perform. Based on these transformations and our criteria, we have developed a benchmark that extends the standard TPC-C benchmark with schema transformations, which can be used to analyze the blocking behavior of schema transformations in database systems. The goal of the benchmark is not only to evaluate existing solutions for non-blocking schema transformations, but also to challenge the database community to find solutions that allow more complex transactional schema transformations.

AB - This paper presents a benchmark for measuring the blocking behavior of schema transformations in relational database systems. As a basis for our benchmark, we have developed criteria for the functionality and performance of schema transformation mechanisms based on the characteristics of state of the art approaches. To address limitations of existing approaches, we assert that schema transformations must be composable while satisfying the ACID guarantees like regular database transactions. Additionally, we have identified important classes of basic and complex relational schema transformations that a schema transformation mechanism should be able to perform. Based on these transformations and our criteria, we have developed a benchmark that extends the standard TPC-C benchmark with schema transformations, which can be used to analyze the blocking behavior of schema transformations in database systems. The goal of the benchmark is not only to evaluate existing solutions for non-blocking schema transformations, but also to challenge the database community to find solutions that allow more complex transactional schema transformations.

KW - CR-H.2.7

KW - EWI-26142

KW - Online schema transformations

KW - IR-98040

KW - Database transactions

KW - METIS-314919

KW - Benchmark

U2 - 10.5220/0005500202880298

DO - 10.5220/0005500202880298

M3 - Conference contribution

SN - 978-989-758-103-8

SP - 288

EP - 298

BT - Proceedings of 4th International Conference on Data Management Technologies and Applications, DATA 2015

PB - SCITEPRESS

ER -

Wevers L, Hofstra M, Tammens M, Huisman M, van Keulen M. A Benchmark for Online Non-Blocking Schema Transformations. In Proceedings of 4th International Conference on Data Management Technologies and Applications, DATA 2015. SCITEPRESS. 2015. p. 288-298. Available from, DOI: 10.5220/0005500202880298