Skip to main content

Accuracy of Atomic Transaction Scenario for Heterogeneous Distributed Column-Oriented Databases

  • Conference paper

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 243))

Abstract

As Internet usage is rapidly growing, e-commerce, e-business and corporate world revenue also increases. These areas not only require scalable and consistent databases but also require inter-database transaction support as well. In this paper, we present a scalable architecture along with a distributed algorithm to support atomic transactions across heterogeneous distributed column-oriented databases. Our methodology does not compromise on any assumption on the accuracy of failure territories. Hence, it reveals suited for a class of heterogeneous distributed systems. To achieve such a target, our architectural model exploits an innovative methodology for distributed atomic transactions. Here, we analyse this methodology between different site or node transactions by the analytical performance to make the protocol sufficient.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   259.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

References

  1. Chang, F., Dean, J., Ghemawat, S., Hsieh, W.C.: Bigtable: a distributed storage system for structured data. ACM Trans. Comp. Syst. (TOCS), 26(2) (2008)

    Google Scholar 

  2. Chang, F., Dean, J., Ghemawat, S., Hsieh, W.C., Wallach, D.A., Burrows, M., Chandra, T., Fikes, A., Gruber, R.: Bigtable: a distributed storage system for structured data. In: OSDI, 205–218. USENIX Association, (2006)

    Google Scholar 

  3. Vora, M.N.: Hadoop-HBase for large-scale data. In: Computer Science and Network Technology (ICCSNT), 2011 International Conference, Dec 2011

    Google Scholar 

  4. Romano, P., Quaglia, F.: Providing e-transaction guarantees in asynchronous systems with no assumptions on the accuracy of failure detection. IEEE Trans. Dependable Secure Comput. 8(1), 104–121 (2011)

    Article  Google Scholar 

  5. Frolund, S., Guerraoui, R.: Implementing e-transactions with asynchronous replication. IEEE Trans Parallel Distrib. Syst. 12(2), 133–146 (2001)

    Article  Google Scholar 

  6. Frolund, S., Guerraoui, R.: e-Transactions: end-to-end reliability for three-tier architectures. IEEE Trans. Software Eng. 28(4), 378–395 (2002)

    Article  Google Scholar 

  7. Zhang, C., De Sterck, H.: Supporting multi-row distributed transactions with global snapshot isolation using bare-bones Hbase. In: Grid Computing (GRID), 11th IEEE/ACM International Conference on Communication, Networking & Broadcasting; Computing & Processing, pp. 177–184 (2010)

    Google Scholar 

  8. Padhye, V., Tripathi, A.: Scalable transaction management with snapshot isolation on cloud data management systems. In: Cloud Computing (CLOUD), 2012 IEEE 5th International Conference on Communication, Networking & Broadcasting; Components, Circuits, Devices & Systems; Computing & Processing, pp. 542–559, June 2012

    Google Scholar 

  9. Cahill, M.J., Röhm, U., Fekete, A.D.: Serializable isolation for snapshot databases. In: SIGMOD, pp. 729–738 (2008)

    Google Scholar 

  10. Fekete, A., O’Neil, E., O’Neil, P.: A read-only transaction anomaly under snapshot isolation. ACM SIGMOD Rec. 33(3), 12–14 (2004)

    Article  Google Scholar 

  11. Fekete, A., Liarokapis, D., O’Neil, E., O’Neil, P., Shasha, D.: Making snapshot isolation serializable. ACM Trans. Database Syst. 30(2), 492–528 (2005)

    Article  Google Scholar 

  12. Revilak, S., O’Neil, P., O’Neil, E.: Precisely serializable snapshot isolation (PSSI). In: ICDE, pp. 482–493 (2011)

    Google Scholar 

  13. Ramesh, D., Kumar, A., Kumar, C.: Implementation of atomicity and snapshot isolation for multi-row transactions on column oriented distributed databases using RDBMS. In: IEEE Conference on Communications, Devices and Intelligent Systems, pp. 298–301, 28–29 Dec 2012

    Google Scholar 

  14. George, L.: Client API: the basics. In: HBASE the Definitive Guide by O’reilly publishers, Sept 2011

    Google Scholar 

  15. Boutros, B.S.: A two-phase commit protocol and its performance. In: IEEE 7th International Conference and Workshop on Database and Expert Systems, 9–10 Sept 1996

    Google Scholar 

  16. Ramesh, D., Kumar, K.C., Ramji, B.: Design of a transaction recovery instance based on bi-directional ring election algorithm for crashed coordinator in distributed database systems. In: IEEE World Congress on Information and Communication Technologies, pp. 721–726, 30 Oct–2 Nov 2012

    Google Scholar 

Download references

Acknowledgments

An earlier version of this paper [13] appeared in the Proceedings of the IEEE-2012 International Conference on Communications, Devices and Intelligent Systems (CODIS), 2012.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Ramesh Dharavath .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Springer India

About this paper

Cite this paper

Dharavath, R., Jain, A.K., Kumar, C., Kumar, V. (2014). Accuracy of Atomic Transaction Scenario for Heterogeneous Distributed Column-Oriented Databases. In: Mohapatra, D.P., Patnaik, S. (eds) Intelligent Computing, Networking, and Informatics. Advances in Intelligent Systems and Computing, vol 243. Springer, New Delhi. https://doi.org/10.1007/978-81-322-1665-0_47

Download citation

  • DOI: https://doi.org/10.1007/978-81-322-1665-0_47

  • Publisher Name: Springer, New Delhi

  • Print ISBN: 978-81-322-1664-3

  • Online ISBN: 978-81-322-1665-0

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics