tailieunhanh - Analysis of two way waiting algorithm in databases

This work is done to prevent the occurrence of deadlock and also improves system performance by diminish the number of restarts transaction which also saves the time and cost for performing the transaction in the system. So, it improves the efficiency of the distributed system. | ISSN:2249-5789 Sunil Ahuja et al, International Journal of Computer Science & Communication Networks,Vol 2(2), 214-217 Analysis of Two Way Waiting Algorithm in Databases Sunil Ahuja Department of Computer Science & Engineering Doon Valley Institute of Engineering & Technology Karnal, India E-mail: ahujaksunil@ Abstract—Database is the well-organized collection of data in a meaningful way that user can perform the transaction. Transaction is a sequence of many actions considered to be atomic. The throughput of the transactions can be increased by performing the transactions in parallel. Transactions are performed in parallel without infringing the data integrity. When the transactions are executing in parallel then this will lead to concurrency in database and deadlock of the transaction. This work is done to prevent the occurrence of deadlock and also improves system performance by diminish the number of restarts transaction which also saves the time and cost for performing the transaction in the system. So, it improves the efficiency of the distributed system. Keywords- concurrency; transaction; timestamp; lock; serialization; consistency;deadlock;direction. I. D INTRODUCTION atabase is a gathering of information and structured of data in such a way that it can be accessed, updated and managed by the user in a very simple way. A database is the collection of information, which is stored in such a way that it can be accessible to each and every user for their purposes. Database should contain the update information so that the user can access up-to-date data. A database should not contain any duplicate data; if there is such a case then it should be abolished or minimized. When there is a collection of data and this data is accessed, updated then this concept is known as Database Management System (DBMS). The Main purpose of database system is to retrieve information; perform some work on the information and storing complete information back to the .