DESIGN AND IMPLEMENTATION OF A CONCURRENCY CONTROL ALGORITHM FOR JOIN CORE

The increased demand for database systems with high-throughput query processing has led to the emergence of Join Core technology. With the presence of Join Core in the database system, and in order to preserve the data consistency between relational database and Join Core data structure, the changes...

Full description

Bibliographic Details
Main Author: Alswedani, Sarah
Format: Others
Published: OpenSIUC 2017
Online Access:https://opensiuc.lib.siu.edu/theses/2082
https://opensiuc.lib.siu.edu/cgi/viewcontent.cgi?article=3096&context=theses
Description
Summary:The increased demand for database systems with high-throughput query processing has led to the emergence of Join Core technology. With the presence of Join Core in the database system, and in order to preserve the data consistency between relational database and Join Core data structure, the changes that occurred in the underlying database have to be reflected in the Join Core. This paper proposes a new concurrency control algorithm for the Join Core environment. The algorithm is designed and implemented to satisfy the following requirements. First, it maintains the same order of transactions that are completed in the relational database. Second, it assures that every transaction is re-executed successfully, and none of the transactions is aborted. As for evaluating the performance of the proposed algorithm, extensive simulation experiments have been conducted with various data and resource contentions.