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.
|Title of host publication||Proceedings of 4th International Conference on Data Management Technologies and Applications, DATA 2015|
|Number of pages||11|
|Publication status||Published - 20 Jul 2015|
- Online schema transformations
- Database transactions
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. https://doi.org/10.5220/0005500202880298