Authors:
Lesley Wevers
;
Matthijs Hofstra
;
Menno Tammens
;
Marieke Huisman
and
Maurice van Keulen
Affiliation:
University of Twente, Netherlands
Keyword(s):
Online Schema Transformations, Database Transactions, Benchmark.
Related
Ontology
Subjects/Areas/Topics:
Data Engineering
;
Data Integrity
;
Database Architecture and Performance
;
Databases and Data Security
;
Databases and Information Systems Integration
;
Enterprise Information Systems
;
Information and Systems Security
;
Large Scale Databases
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-blocki
ng schema transformations, but also to challenge the database
community to find solutions that allow more complex transactional schema transformations.
(More)