Publication

Lazy State Determination for SQL databases

View document

Bibliographic Details
Summary:Transactional systems have seen various efforts to increase their throughput, mainly by making use of parallelism and efficient Concurrency Control techniques. Most approaches optimize the systems’ behaviour when under high contention. In this work, we strive towards reducing the system’s overall contention through Lazy State Determination (LSD). LSD is a new transactional API that leverages on futures to delay the accesses to the Database as much as possible, reducing the amount of time that transactions require to operate under isolation and, thus, reducing the contention window. LSD was shown to be a promising solution for Key-Value Stores. Now, our focus turns to Relational Database Management Systems, as we attempt to implement and evaluate LSD in this new setting. This implementation was done through a custom JDBC driver to minimize required modifications to any external platform. Results show that the reduction of the contention window effectively improves the success rate of transactional applications. However, our current implementation exhibits some performance issues that must be further investigated and addressed.
Main Authors:Subtil, Eduardo Bezerra
Subject:Concurrency Control On-Line Transaction Processing Relational Systems Lazy State Determination High Contention Environments Java Database Connectivity
Year:2021
Country:Portugal
Document type:master thesis
Access type:open access
Associated institution:Universidade Nova de Lisboa
Language:English
Origin:Repositório Institucional da UNL

Similar Items

Similar Items