Title: Preserving atomicity and isolation for multi-row transactions in column-oriented heterogeneous distributed databases

Authors: Dharavath Ramesh; Chiranjeev Kumar; Amit Kumar Jain

Addresses: Department of Computer Science and Engineering, Indian School of Mines, Dhanbad – 826004, Jharkhand, India ' Department of Computer Science and Engineering, Indian School of Mines, Dhanbad – 826004, Jharkhand, India ' Department of Computer Science and Engineering, Indian School of Mines, Dhanbad – 826004, Jharkhand, India

Abstract: Traditional databases have limitation of scalability with respect to data as well as number of clients. Column-oriented databases have overcome this feature by minimising the cost. Column-oriented databases only ensure single row atomic transaction and does not support snapshot isolation. This paper presents about strong snapshot isolation (SI) and atomicity for multi-row distributed transactions in HBase. This HBase snapshot isolation uses a novel approach and handles distributed transactions at the end of individual clients. This is also designed to be scalable across large distributed databases in terms of data distribution. Some experiments have been performed extensively to preserve atomicity for distributed transactions in various environments. Experimental results show that the proposed methodology can serve better to preserve atomicity and snapshot isolation in column-oriented HDDBs for multi-row transactions.

Keywords: column oriented databases; multi-row transactions; heterogeneous distributed databases; RDBMS; HBase; snapshot isolation; atomicity; relational DBMS; database management systems.

DOI: 10.1504/IJICT.2017.081007

International Journal of Information and Communication Technology, 2017 Vol.10 No.1, pp.96 - 118

Received: 15 Jan 2014
Accepted: 03 Oct 2014

Published online: 23 Nov 2016 *

Full-text access for editors Access for subscribers Purchase this article Comment on this article