Development and evaluation of a transactional benchmark driver for a scalable SQL database (Master thesis)

Sotiriou, Michail

The process of benchmarking transactional database systems has a long history and provides important insight into the efficiency and scalability of such systems. Recent advances in scalable transactional databases have motivated the adaptation of traditional transactional benchmarks, such as TPC-C, to a variety of new database architectures. However, a challenge with the proliferation of database architectures today is the need to develop and evaluate new database drivers (ports of the benchmarkdatabase interface to a new database architecture) for a wide range of systems. In this thesis, we develop and evaluate a driver for the Py-TPCC benchmark targeting the CockroachDB scalable SQL database. The driver lowers complexity by leveraging the psycopg2 PostgreSQL adapter for the Python programming language. We evaluate the Py-TPCC benchmark for CockroachDB and compare to an existing TPC-C benchmark implementation for CockroachDB written in Go, using the pq PostgreSQL adapter. Our results indicate that the use of a SQL interface (when offered by the scalable database) simplifies the development of TPC-C benchmark drivers. Despite similarities in the two implementations of the TPC-C benchmark, we observe performance differences that can be attributed to the variable efficiencies of use of CockroachDB resources across implementations of the PostgreSQL adapter.
Institution and School/Department of submitter: Πανεπιστήμιο Ιωαννίνων. Πολυτεχνική Σχολή. Τμήμα Μηχανικών Ηλεκτρονικών Υπολογιστών και Πληροφορικής
Subject classification: Benchmarking
Keywords: Τransactional driver,Benchmarking,Scalable SQL database
Appears in Collections:Διατριβές Μεταπτυχιακής Έρευνας (Masters)

Files in This Item:
File Description SizeFormat 
M.E. SOTIRIOU MICHAIL 2019.pdf2.08 MBAdobe PDFView/Open

 Please use this identifier to cite or link to this item:
  This item is a favorite for 0 people.

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.