The cloud infrastructure provides Database Management System as a service with scalability and elasticity. Cloud DBMS is a less expensive platform for managing our data resources. Cloud data are replicated for high data availability. Concurrent transactions are done in the cloud database. Database users expect that data should be consistent when two users access to the same data at the same time and can see the same value. Due to replication of data in cloud environment, data inconsistency may occur between different replicated nodes. Hence Effective locking mechanisms are needed to handle such replicated cloud database. This paper proposes a novel algorithm for transaction processing to solve inconsistency and to control concurrency using lock managers and queue supervisor.

Transaction Processing, Consistency, Database Management System, Cloud computing

[1] D. Abadi, “Consistency tradeoffs in modern distributed database system design: Cap is only part of the story,” Computer, Vol No. 2, Feb. 2012.
[2] D. J. Abadi, “Data management in the cloud: Limitations and opportunities,” IEEE Data Eng. Bull., vol. 32, no. 1, pp. 3–12, 2009.
[3] P. S. Almeida, A. Shoker, and C. Baquero, “Efficient State-based Credits by Delta Mutation” in Proceedings of third International Conference Networked Systems (NETYS), 2015.
[4] P. Alvaro, P. Bailis, N. Conway, and J. M. Hellerstein, “Consistency without borders” in Proceedings of the 4th Annual Symposium on Cloud Computing, ser. SOCC’13. New York, NY, USA: ACM, 2013, pp. 23:1–23:10.
[5] R Anandhi, K Chitra, “A challenge in improving the consistency of transactions in cloud databases-scalability”, International Journal of Computer Applications 52 (2), 12-14, 2012.
[6] E. Anderson, X. Li, M. A. Shah, J. Tucek, and J. J. Wylie, “What consistency does your key-value store actually provide?” in Proceedings of the Sixth international conference on Hot topics in system dependability, ser. HotDep’10. Berkeley, CA, USA: USENIX Association, 2010, pp. 1–16.
[7] B Jeevarani, K Chitra, “Improved consistency model in cloud computing databases”, 2014 IEEE Computational Intelligence and Computing Research (ICCIC), 2014.
[8] O. Khan, R. C. Burns, J. S. Plank, W. Pierce, and C. Huang, “Rethinking erasure codes for cloud file systems: minimizing I/O for recovery and degraded reads,” in Proceedings of the 10th USENIX conference on File and Storage Technologies, FAST, San Jose, CA, USA, February 14-17, 2012, p. 20.
[9] A. Khanafer, M. Kodialam, and K. Puttaswamy, “The constrained ski-rental problem and its application to online cloud cost optimization,” in Proceedings of the IEEE INFOCOM, April 2013, pp. 1492–1500., 2014
[10] C. Li, D. Porto, A. Clement, J. Gehrke, N. Preguic¸a, and R. Rodrigues, “Making geo-replicated systems fast as possible, consistent when necessary,” in Proceedings of the 10th USENIX Conference on Operating Systems Design and Implementation, ser. OSDI’12. Berkeley, CA, USA: USENIX Association, 2012, pp. 265–278.
[11] S.L. Mewada, “A Proposed New Approach for Cloud Environment using Cryptic Techniques”, In the Proceedings of the 2016 International Conference on Computer Science and Engineering, India, pp.542-545, 2016.
[12] S. Tamilarasan, P.K. Sharma, “A Survey on Dynamic Resource Allocation in MIMO Heterogeneous Cognitive Radio Networks based on Priority Scheduling”, International Journal of Computer Sciences and Engineering, Vol.5, No.1, pp.53-59, 2017.