Advances in Computer and Computational Sciences pp 315-322 | Cite as
An Optimistic Approach of Locking Strategy in Progress Fourth Generation Language
Abstract
While working in the multi-user environment, the records should not be kept in the record buffer for the long duration of time; doing so will prevent the other users from accessing the record. Optimistic Locking is a strategy wherein transactions access the records without actually locking them and making them available for other users. Before committing, each transaction read a record, take note of a database records, and check that the record has not changed before you write the record back to the database. This paper is tailored towards implementing Optimistic Locking Strategy in the Progress Fourth Generation Language (4GL) and explaining various reasons of transaction failure in the Progress 4GL. Lastly our idea is compared with the existing locking strategy in the database management system on the basis of various issues that occurs in the locking mechanisms.
Keywords
Transaction processing Concurrency control Records Database deadlock Record scopeReferences
- 1.G. Lu, J. Y. Lü, “A New Database Transactions Monitoring Approach”, International Conference on Mechatronics and Automation, Harbin, China, 2007.Google Scholar
- 2.A. Kemper, and T. Neumann. “Scaling HTM-Supported Database Transactions to Many Cores”, IEEE Transactions on Knowledge and Data Engineering, Vol. 28, No. 2, February 2016.Google Scholar
- 3.O. Amer, A. Salem, A. al-Qeerm, “Classification of Transaction Models in Mobile Database System”, Web Applications and Networking (WSWAN), 2015 2nd World Symposium on, 978-1-4799-8171-7, March 2015.Google Scholar
- 4.S. A1 Idowu, S. Maitanmi.” Transactions- Distributed Database Systems: Issues and Challenges”, International Journal of Advances in Computer Science and Communication Engineering (IJACSCE) Vol 2 Issue I, March, 2014.Google Scholar
- 5.Z. Li, Z. Zhu and S. Zhang, “A Locking Mechanism for Distributed Database Systems”, Journal of Networks, Vol. 9, No. 8, August 2014.Google Scholar
- 6.Y. Jayanta, Y. Somananda, “Conflicting Management of Transactions in Real Time Database System”, First International Conference on Informatics and Computational Intelligence, 2011, pp. 327-331.Google Scholar
- 7.S. Liu Min, C. Xinyu, C. RuiZhang. “Research Based on Database Transactions”, 3rd International Conference on Communication Software an Networks (ICCSN), IEEE, 2011, pp 550–553.Google Scholar
- 8.A. Waqas, A. Mahessar, N. Mahmood, Z. Bhatti, M. Karbasi and A. Shah, “Transaction Management Techniques and Practices in Current Cloud Computing Environment: A Survey”, Shah International Journal of Database Management Systems (IJDMS) Vol. 7, No. 1, February 2015.Google Scholar
- 9.P. Ozsu, “Principles of Distributed Database Systems”, ISBN 978-1-4419-8834-8 Springer, 2011.Google Scholar
- 10.Progress Programming Handbook, Progress Software Corporation.Google Scholar
- 11.J. Gray and A. Reuter, “Transaction Processing: Concepts and Techniques”, Morgan Kaufmann, Publishers Inc. San Francisco, 1993.Google Scholar
- 12.A. Thomasian, “Two-Phase Locking Performance and its Thrashing Behavior”, ACM Transactions Database Syst, 1993, 18(4): 579–625.Google Scholar
- 13.http://knowledgebase.progress.com “Progress Knowledge Base”.