An Efficient Deadlock Handling Model Based on Neutrosophic Logic: Case Study on Real Time Healthcare Database Systems
The adoption of electronic patient records in hospitals will provide numerous benefits, but it will also present new issues. One of these is the creation of deadlocks, which causes delays in conducting tasks such as obtaining patient information. If the underlying system is distributed, the deadlock...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
IEEE
2022-01-01
|
| Series: | IEEE Access |
| Subjects: | |
| Online Access: | https://ieeexplore.ieee.org/document/9832868/ |
| _version_ | 1828189464706416640 |
|---|---|
| author | Marwan H. Hassan Saad M. Darwish Saleh M. Elkaffas |
| author_facet | Marwan H. Hassan Saad M. Darwish Saleh M. Elkaffas |
| author_sort | Marwan H. Hassan |
| collection | DOAJ |
| description | The adoption of electronic patient records in hospitals will provide numerous benefits, but it will also present new issues. One of these is the creation of deadlocks, which causes delays in conducting tasks such as obtaining patient information. If the underlying system is distributed, the deadlock situation gets even more problematic. The strategy for preventing deadlock requires basic information from the transaction structure and requested resources. However, in most circumstances, this information is either unavailable or ambiguous. Because the cost of processing and storing sophisticated structures (e.g., wait-for graphs) is so high for a system in comparison to an array of structures, most discovery and resolved-deadlock protocols use them. Due to imprecise knowledge in specifying the transactions’ attributes, distributed deadlock resolution methods present a new problem in dealing with uncertainty. To address this problem, a variety of fuzzy logic-based techniques have been proposed. However, very little attention has been paid to dealing with ambiguous, vague, incomplete, and inconsistent information about transaction attributes in a single framework. In this paper, we used neutrosophic logic, a generalization of fuzzy logic, to solve the problem of uncertainty in distributed real-time deadlock-resolving systems. The proposed method is structured to reflect multiple types of knowledge and relations among all features and tripartitions the transactions’ features include validation factor degree, slackness degree, degree of deadline-missed transaction based on the degree of membership of truthiness, degree of membership of indeterminacy, and degree of membership of falsity. We developed a tool set and conducted experiments using benchmark datasets. There is an increase in detection rate and a large drop in rollback rate when this new strategy is used. Our technology resolved all database deadlocks and significantly increased database performance by up to three orders of magnitude. |
| first_indexed | 2024-04-12T08:06:08Z |
| format | Article |
| id | doaj.art-e201c2ce4d524386873af4d4c8bbbab4 |
| institution | Directory Open Access Journal |
| issn | 2169-3536 |
| language | English |
| last_indexed | 2024-04-12T08:06:08Z |
| publishDate | 2022-01-01 |
| publisher | IEEE |
| record_format | Article |
| series | IEEE Access |
| spelling | doaj.art-e201c2ce4d524386873af4d4c8bbbab42022-12-22T03:41:10ZengIEEEIEEE Access2169-35362022-01-0110766077662110.1109/ACCESS.2022.31924149832868An Efficient Deadlock Handling Model Based on Neutrosophic Logic: Case Study on Real Time Healthcare Database SystemsMarwan H. Hassan0https://orcid.org/0000-0001-6370-5532Saad M. Darwish1https://orcid.org/0000-0003-2723-1549Saleh M. Elkaffas2https://orcid.org/0000-0002-1865-2627Department of Advocacy and Public Speaking, Imam Al-Adham University College, Anbar, IraqDepartment of Information Technology, Institute of Graduate Studies and Research, Alexandria University, Alexandria, EgyptCollege of Computing and Information Technology, Arab Academy for Science, Technology and Maritime Transport, Alexandria, EgyptThe adoption of electronic patient records in hospitals will provide numerous benefits, but it will also present new issues. One of these is the creation of deadlocks, which causes delays in conducting tasks such as obtaining patient information. If the underlying system is distributed, the deadlock situation gets even more problematic. The strategy for preventing deadlock requires basic information from the transaction structure and requested resources. However, in most circumstances, this information is either unavailable or ambiguous. Because the cost of processing and storing sophisticated structures (e.g., wait-for graphs) is so high for a system in comparison to an array of structures, most discovery and resolved-deadlock protocols use them. Due to imprecise knowledge in specifying the transactions’ attributes, distributed deadlock resolution methods present a new problem in dealing with uncertainty. To address this problem, a variety of fuzzy logic-based techniques have been proposed. However, very little attention has been paid to dealing with ambiguous, vague, incomplete, and inconsistent information about transaction attributes in a single framework. In this paper, we used neutrosophic logic, a generalization of fuzzy logic, to solve the problem of uncertainty in distributed real-time deadlock-resolving systems. The proposed method is structured to reflect multiple types of knowledge and relations among all features and tripartitions the transactions’ features include validation factor degree, slackness degree, degree of deadline-missed transaction based on the degree of membership of truthiness, degree of membership of indeterminacy, and degree of membership of falsity. We developed a tool set and conducted experiments using benchmark datasets. There is an increase in detection rate and a large drop in rollback rate when this new strategy is used. Our technology resolved all database deadlocks and significantly increased database performance by up to three orders of magnitude.https://ieeexplore.ieee.org/document/9832868/Deadlock recoveryneutrosophic sethealthcare databasesdistributed deadlock detection |
| spellingShingle | Marwan H. Hassan Saad M. Darwish Saleh M. Elkaffas An Efficient Deadlock Handling Model Based on Neutrosophic Logic: Case Study on Real Time Healthcare Database Systems IEEE Access Deadlock recovery neutrosophic set healthcare databases distributed deadlock detection |
| title | An Efficient Deadlock Handling Model Based on Neutrosophic Logic: Case Study on Real Time Healthcare Database Systems |
| title_full | An Efficient Deadlock Handling Model Based on Neutrosophic Logic: Case Study on Real Time Healthcare Database Systems |
| title_fullStr | An Efficient Deadlock Handling Model Based on Neutrosophic Logic: Case Study on Real Time Healthcare Database Systems |
| title_full_unstemmed | An Efficient Deadlock Handling Model Based on Neutrosophic Logic: Case Study on Real Time Healthcare Database Systems |
| title_short | An Efficient Deadlock Handling Model Based on Neutrosophic Logic: Case Study on Real Time Healthcare Database Systems |
| title_sort | efficient deadlock handling model based on neutrosophic logic case study on real time healthcare database systems |
| topic | Deadlock recovery neutrosophic set healthcare databases distributed deadlock detection |
| url | https://ieeexplore.ieee.org/document/9832868/ |
| work_keys_str_mv | AT marwanhhassan anefficientdeadlockhandlingmodelbasedonneutrosophiclogiccasestudyonrealtimehealthcaredatabasesystems AT saadmdarwish anefficientdeadlockhandlingmodelbasedonneutrosophiclogiccasestudyonrealtimehealthcaredatabasesystems AT salehmelkaffas anefficientdeadlockhandlingmodelbasedonneutrosophiclogiccasestudyonrealtimehealthcaredatabasesystems AT marwanhhassan efficientdeadlockhandlingmodelbasedonneutrosophiclogiccasestudyonrealtimehealthcaredatabasesystems AT saadmdarwish efficientdeadlockhandlingmodelbasedonneutrosophiclogiccasestudyonrealtimehealthcaredatabasesystems AT salehmelkaffas efficientdeadlockhandlingmodelbasedonneutrosophiclogiccasestudyonrealtimehealthcaredatabasesystems |