DESIGN AND IMPLEMENTATION OF A CONCURRENCY CONTROL ALGORITHM FOR JOIN CORE

• 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

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.