Implementation of atomicity and snapshot isolation for multi-row transactions on column oriented distributed databases using RDBMS

As traditional relational database have limitation of scalability in the respect of data as well as number of clients. Column oriented databases overcome this problem with the cost of lacking transaction features as compared to relational database. Column oriented databases only assure single row atomic transaction and does not support Snapshot Isolation. In this paper we show how atomicity in multi-row transaction and snapshot isolation can be achieved for column oriented database using RDMBS.

[1]  Patrick E. O'Neil,et al.  Precisely Serializable Snapshot Isolation (PSSI) , 2011, 2011 IEEE 27th International Conference on Data Engineering.

[2]  Patrick E. O'Neil,et al.  A read-only transaction anomaly under snapshot isolation , 2004, SGMD.

[3]  Wilson C. Hsieh,et al.  Bigtable: A Distributed Storage System for Structured Data , 2006, TOCS.

[4]  Hans De Sterck,et al.  Supporting multi-row distributed transactions with global snapshot isolation using bare-bones HBase , 2010, 2010 11th IEEE/ACM International Conference on Grid Computing.

[5]  Anand R. Tripathi,et al.  Scalable Transaction Management with Snapshot Isolation on Cloud Data Management Systems , 2012, 2012 IEEE Fifth International Conference on Cloud Computing.

[6]  Dennis Shasha,et al.  Making snapshot isolation serializable , 2005, TODS.

[7]  Alan Fekete,et al.  Serializable isolation for snapshot databases , 2008, SIGMOD Conference.

[8]  M. N. Vora,et al.  Hadoop-HBase for large-scale data , 2011, Proceedings of 2011 International Conference on Computer Science and Network Technology.

[9]  Simson L. Garfinkel,et al.  An Evaluation of Amazon's Grid Computing Services: EC2, S3, and SQS , 2007 .