An Efficient Concurrency Control Technique for Mobile Database Environment

An Efficient Concurrency Control Technique for Mobile Database Environment

Dr. Md. Anisur Rahman

Contact

Dhaka University of Engineering & Technology

An Efficient Concurrency Control Technique for Mobile Database Environment

Article Fingerprint

ReserarchID

CSTSDES2L7Y

An Efficient Concurrency Control Technique for Mobile Database Environment Banner

AI TAKEAWAY

Connecting with the Eternal Ground

Abstract

Day by day, wireless networking technology and mobile computing devices are becoming more popular for their mobility as well as great functionality. Now it is an extremely growing demand to process mobile transactions in mobile databases that allow mobile users to access and operate data anytime and anywhere, irrespective of their physical positions. Information is shared among multiple clients and can be modified by each client independently. However, for the assurance of timely access and correct results in concurrent mobile transactions, concurrency control techniques (CCT) happen to be very difficult. Due to the properties of Mobile databases e.g. inadequate bandwidth, small processing capability, unreliable communication, mobility etc. existing mobile database CCTs cannot employ effectively. With the client-server model, applying common classic pessimistic techniques of concurrency control (like 2PL) in mobile database leads to long duration Blocking and increasing waiting time of transactions. Because of high rate of aborting transactions, optimistic techniques aren`t appropriate in mobile database as well. This paper discusses the issues that need to be addressed when designing a CCT technique for Mobile databases, analyses the existing scheme of CCT and justify their performance limitations. A modified optimistic concurrency control scheme is proposed which is based on the number of data items cached, amount of execution time and current load of the database server. Experimental results show performance benefits, such as increase in average response time and decrease in waiting time of the transactions.

References

21 Cites in Article

Reference Format

C Joe,E Chan,K Lam,H Leung An Adaptive AVI-based Cache Invalidation Scheme for Mobile Computing Systems.
Jin Ho,Byeong-Soo Choi,Jeong (2006). A Timestamp-Based Optimistic Concurrency Control for Handling Mobile Transactions.
K Ali,B Ahmad (2011). A Concurrency Control Method Based on Commitment Ordering in Mobile Databases.
Minsoo Lee,Sumi Helal (2002). HiCoMo: High Commit Mobile Transactions.
Mohammed Khaja Nizamuddin,Abdul Syed,Sattar (2010). Adaptive Valid Period Based Concurrency Control In: Recent Without Locking in Mobile Environments.
Nadia Nouali,Anne Doucet,Habiba Drias (2005). A Two-Phase Commit Protocol for Mobile Wireless the Australasian Database Environment.
Patricia Serrano-Alvarado,Claudia Roncancio,Michel Adiba (2004). A Survey of Mobile Transactions.
Salman Abdul Moiz,Dr Rajamani (2007). An Algorithmic approach for achieving Concurrency in Mobile Environment.
Vijay (2002). TCOT -A Timeout-Based Mobile Transaction Commitment Protocol.
S Moiz,L Rajamani (2007). Single Lock Manager Approach for Achieving Concurrency Control in Mobile Environments.
M,Salman Abdul (2009). Concurrency Control Strategy to Reduce Frequent Rollbacks in Mobile Environments.
S Moiz,M Nizamuddin (2008). Concurrency Control without Locking in Mobile Environments.
D Salman,Abdul Moiz (2010). A Real Time Optimistic Strategy to achieve Concurrency control in Mobile Environments using ondemand multicasting.
Sanjay Madria,M Baseer,Vijay Kumar,Sourav Bhowmick (2007). A transaction model and multiversion concurrency control for mobile database systems.
S Madria,M Baseer,S Bhowmick (2002). A Multi-version Transaction Model to Improve Data Availability in Mobile Computing.
C Ho,L Jongmin,H Chong-Sun,L Wongyu (1997). Hybrid concurrency control for mobile computing.
A Carmine Cesarano,Vincenzo Moscato,Antonio Picariello,Antonio Acierno (2007). A Hybrid Approach for Improving Concurrency of Frequently Disconnecting Transactions.
A Chianese,A Acierno,V Moscato,A Picariello (2008). Pre-serialization of long running transactions to improve concurrency in mobile environments.
C Lee,K.-W Lam,S Son (2002). Concurrency Control Using Timestamp Ordering in Broadcast Environments.
C Lee,K Lam,T.-W Kuo (2004). Efficient validation of mobile transactions in wireless environments.
Salman Abdul Moiz,Dr Rajamani (2009). Concurrency Control Strategy to Reduce Frequent Rollbacks in Mobile Environments.

Download References

Funding

No external funding was declared for this work.

Conflict of Interest

The authors declare no conflict of interest.

Ethical Approval

No ethics committee approval was required for this article type.

Data Availability

Not applicable for this article.

How to Cite This Article

Dr. Md. Anisur Rahman. 2013. \u201cAn Efficient Concurrency Control Technique for Mobile Database Environment\u201d. Global Journal of Computer Science and Technology - C: Software & Data Engineering GJCST-C Volume 13 (GJCST Volume 13 Issue C2).

More Citation Formats

Select Citation Style:

Download Citation

GJCST Volume 13 Issue C2

Explore Journals Explore Volume Read This Issue

Journal Specifications

Crossref Journal DOI 10.17406/gjcst

Print ISSN 0975-4350

e-ISSN 0975-4172

Keywords

base station client-server fixed host mobile database mobile host optimistic concurrency control

Submission ReceivedDecember 6, 2012
Peer Review Double Blind
Handling Editor
Accepted January 2, 2013
Published January 15, 2013

Version of record

v1.2

Issue date

February 28, 2013

Language

Experiance in AR

Explore published articles in an immersive Augmented Reality environment. Our platform converts research papers into interactive 3D books, allowing readers to view and interact with content using AR and VR compatible devices.

View in VR

Read in 3D

Your published article is automatically converted into a realistic 3D book. Flip through pages and read research papers in a more engaging and interactive format.

View in 3D

Article Matrices

Total Score: 106

Country: Bangladesh

Subject: Global Journal of Computer Science and Technology - C: Software & Data Engineering

Authors: Dr. Md. Anisur Rahman (PhD/Dr. count: 1)

View Count (all-time): 259

Total Views (Real + Logic): 9668

Total Downloads (simulated): 2619

Publish Date: 2013 02, Thu

Monthly Totals (Real + Logic):

Month 1: 64 views
Month 2: 19 views
Month 3: 35 views
Month 4: 50 views
Month 5: 29 views
Month 6: 47 views
Month 7: 23 views
Month 8: 39 views
Month 9: 36 views
Month 10: 30 views
Month 11: 53 views
Month 12: 30 views
Month 13: 27 views
Month 14: 29 views
Month 15: 27 views
Month 16: 31 views
Month 17: 44 views
Month 18: 42 views
Month 19: 33 views
Month 20: 31 views
Month 21: 32 views
Month 22: 31 views
Month 23: 25 views
Month 24: 35 views
Month 25: 36 views
Month 26: 12 views
Month 27: 41 views
Month 28: 22 views
Month 29: 48 views
Month 30: 28 views
Month 31: 30 views
Month 32: 26 views
Month 33: 13 views
Month 34: 35 views
Month 35: 20 views
Month 36: 25 views
Month 37: 32 views
Month 38: 30 views
Month 39: 35 views
Month 40: 26 views
Month 41: 21 views
Month 42: 22 views
Month 43: 21 views
Month 44: 41 views
Month 45: 30 views
Month 46: 12 views
Month 47: 17 views
Month 48: 40 views
Month 49: 22 views
Month 50: 33 views
Month 51: 45 views
Month 52: 45 views
Month 53: 31 views
Month 54: 19 views
Month 55: 41 views
Month 56: 50 views
Month 57: 29 views
Month 58: 47 views
Month 59: 34 views
Month 60: 40 views
Month 61: 38 views
Month 62: 21 views
Month 63: 27 views
Month 64: 33 views
Month 65: 22 views
Month 66: 19 views
Month 67: 26 views
Month 68: 38 views
Month 69: 26 views
Month 70: 17 views
Month 71: 24 views
Month 72: 40 views
Month 73: 31 views
Month 74: 43 views
Month 75: 29 views
Month 76: 31 views
Month 77: 44 views
Month 78: 13 views
Month 79: 35 views
Month 80: 16 views
Month 81: 26 views
Month 82: 48 views
Month 83: 41 views
Month 84: 39 views
Month 85: 25 views
Month 86: 42 views
Month 87: 38 views
Month 88: 35 views
Month 89: 27 views
Month 90: 19 views
Month 91: 33 views
Month 92: 29 views
Month 93: 37 views
Month 94: 35 views
Month 95: 29 views
Month 96: 32 views
Month 97: 39 views
Month 98: 20 views
Month 99: 31 views
Month 100: 41 views
Month 101: 29 views
Month 102: 30 views
Month 103: 37 views
Month 104: 23 views
Month 105: 20 views
Month 106: 16 views
Month 107: 30 views
Month 108: 44 views
Month 109: 24 views
Month 110: 33 views
Month 111: 31 views
Month 112: 36 views
Month 113: 36 views
Month 114: 25 views
Month 115: 43 views
Month 116: 27 views
Month 117: 34 views
Month 118: 38 views
Month 119: 46 views
Month 120: 29 views
Month 121: 34 views
Month 122: 38 views
Month 123: 23 views
Month 124: 25 views
Month 125: 22 views
Month 126: 28 views
Month 127: 27 views
Month 128: 19 views
Month 129: 27 views
Month 130: 38 views
Month 131: 39 views
Month 132: 19 views
Month 133: 27 views
Month 134: 34 views
Month 135: 25 views
Month 136: 21 views
Month 137: 33 views
Month 138: 29 views
Month 139: 20 views
Month 140: 41 views
Month 141: 24 views
Month 142: 18 views
Month 143: 21 views
Month 144: 25 views
Month 145: 36 views
Month 146: 18 views
Month 147: 34 views
Month 148: 35 views
Month 149: 19 views
Month 150: 25 views
Month 151: 45 views
Month 152: 39 views
Month 153: 32 views
Month 154: 26 views
Month 155: 34 views
Month 156: 20 views
Month 157: 52 views
Month 158: 35 views
Month 159: 42 views

Total Views: 9668

Total Downloads: 2619

2026 Trends

Our website is actively being updated, and changes may occur frequently. Please clear your browser cache if needed. For feedback or error reporting, please email [email protected]