The issues related to mobile network like disconnection, failure of mobile host etc. needs to have reliable method of execution for transactions along with recovery of database into consistent state. The most widely used technique for database recovery is Log based recovery. During failure / crash to recover data values prior to modification and the new value after modification can be accessed with the transaction log. To maintain atomicity, the operations of committed transactions are redone whereas operations of uncommitted or aborted transactions are undone. Checkpoints are used to reduce the number of log records that the system must scan when recovering from a crash.   In this paper we provide a transaction execution model with two alternative possible execution strategies for mobile transactions I.e. execution at MH & Execution at FH. The performance of the our system is compared with the 2PC in terms of message complexity, force writes etc.  The proposal is also been made to have reliable execution of mobile transactions by maintaining logged information using flash memory at MH & BS and also using recovery algorithm, with which we can have durability in transactions.

1. C. Bobineau, P. Pucheral, and M. Abdallah. A Unilateral Commit Protocol for Mobile and Disconnected Computing. In PDCS, USA, 2000.

2. A. Kawaguchi, S. Nishioka, and H. Motoda, “A Flash-Memory Based File System," USENIX Technical Conference on UNIX and Advanced Computing Systems, 1995.

3. V. Kumar, N. Prabhu, M. H. Dunham, and A. Y. Seydim. “TCOT- A Timeout-Based Mobile Transaction Commitment Protocol.” IEEE Transactions on Computers, 51(10), 2002.

4. P. Serrano-Alvarado, C. L. Roncancio, M. Adiba, and Labbe. “Adaptable mobile transactions and environment awareness.” In JourneesBases de Donnees Avancees,France,2003.

5. Z. Ding, X. Meng, and S. Wang   “,O2PC-MT: A Novel Optimistic Two-Phase Commit Protocol “  H.C. Mayr et al. (Eds.): DEXA 2001, LNCS 2113,  2001.© Springer-Verlag Berlin Heidelberg 2001

6. Christophe Bobineau, Cyril Labb´e, Claudia Roncancio, Patricia Serrano-Alvarado ‘Comparing transaction commit protocols for mobile environments’, in Proceedings of the 15th International Workshop on Database and Expert Systems Applications (DEXA’04) 1529-4188/04 IEEE

7. Joos-Hendrik Bose, Stefan Bottcher, Le Gruenwald “An integrated commit protocol for mobile network databases” in the proceedings of 9th international Database Engineering & Application symposium (IDEAS’05) 2005 IEEE

8. M. M. Goreyand R. K. Ghosh “Recovery of Mobile Transactions” Proceedings of the 11thInternational Workshop on Database and Expert Systems Applications (DEXA’00)0-7695-0680-1/00 © 2000 IEEE.

9. patrica Serrano ,Claudia roncancico,Michel adiba ‘A Survey of mobile transactions’Distributed and parallel databases 16,193-230,2004.