Mobile Transaction Supports for DBMS

National audienceIn recent years data management in mobile environments has generated a great interest. Several proposals concerning mobile transactions have been done. However, it is very difficult to have an overview of all these approaches. In this paper we analyze and compare several contributions on mobile transactions and introduce our ongoing research: the design and implementation of a Mobile Transaction Service. The focus of our study is on execution models, the manner ACID properties are provided and the way geographical movements of hosts (during transaction executions) is supported

Adaptable Mobile Transactions and Environment Awareness

National audienceMobile environments are characterized by high variability (e.g. variable bandwidth, disconnections, different communication prices) as well as by limited mobile host resources. Such characteristics lead to high rates of transaction failures and unpredictable execution costs. This paper introduces an Adaptable Mobile Transaction model (AMT) that allows defining transactions with several execution alternatives associated to a particular context. The principal goal is to adapt transaction execution to context variations. An analytical study shows that using AMTs increases commit probabilities and that it is possible to choose the way transactions will be executed according to their costs. In addition, the middleware TransMobi is proposed. It manages environment awareness and implements the AMT model with suitable protocols.Les environnements mobiles sont caractérisés par une grande variabilité (bande passante variable, déconnexions, prix de communication différents, etc.) ainsi que par des uni-tés mobiles à ressources limitées. Ces caractéristiques entraînent un nombre important de défaillances transactionnels et des coûts d'exécution imprévus. Cet article introduit un modèle de transactions mobiles adaptables (AMT) permettant de définir des transactions avec plusieurs alternatives d'exécution. Le principal objectif est d'adapter l'exécution des transactions aux variations du contexte. Une étude analytique montre que les AMT augmentent la probabilité de validation et qu'il est possible de choisir le type d'exécution en fonction de son coût. Nous proposons également l'intergiciel TransMobi gérant la perception de l'environnement et implantant le modèle AMT à l'aide de protocoles appropriés

Review of Some Transaction Models used in Mobile Databases

Mobile computing is presently experiencing a period of unprecedented growth with the convergence of communication and computing capabilities of mobile phones and personal digital assistant. However, mobile computing presents many inherent problems that lead to poor network connectivity. To overcome poor connectivity and reduce cost, mobile clients are forced to operate in disconnected and partially connected modes. One of the main goals of mobile data access is to reach the ubiquity inherent to the mobile systems: to access information regardless of time and place. Due to mobile systems restrictions such as, for instance, limited memory and narrow bandwidth, it is only natural that researchers expend efforts to soothe such issues. This work approaches the issues regarding the cache management in mobile databases, with emphasis in techniques to reduce cache faults while the mobile device is either connected, or with a narrow bandwidth, or disconnected at all. Thus, it is expected improve data availability while a disconnection. Here in the paper, we try to describe various mobile transaction models, focusing on versatile data sharing mechanisms in volatile mobile environments

Review of Some Transaction Models used in Mobile Databases

Mobile computing is presently experiencing a period of unprecedented growth with the convergence of communication and computing capabilities of mobile phones and personal digital assistant. However, mobile computing presents many inherent problems that lead to poor network connectivity. To overcome poor connectivity and reduce cost, mobile clients are forced to operate in disconnected and partially connected modes. One of the main goals of mobile data access is to reach the ubiquity inherent to the mobile systems: to access information regardless of time and place. Due to mobile systems restrictions such as, for instance, limited memory and narrow bandwidth, it is only natural that researchers expend efforts to soothe such issues. This work approaches the issues regarding the cache management in mobile databases, with emphasis in techniques to reduce cache faults while the mobile device is either connected, or with a narrow bandwidth, or disconnected at all. Thus, it is expected improve data availability while a disconnection. Here in the paper, we try to describe various mobile transaction models, focusing on versatile data sharing mechanisms in volatile mobile environments

Adaptation Mechanisms For Transactions In Mobile Computing Environments [mecanismos De Adaptação Para Transações Em Ambientes De Computação Móvel]

Advances in wireless communication technologies and portable computers have turned mobile computing into a reality. These environments are characterized by a high dynamism that can hamper the execution of applications. This paper presents a set of adaptation mechanisms that can be used within a transaction context to overcome the high dynamism and resource restrictions of the mobile environment. Three adaptation mechanisms were proposed: isolation level, operation mode and transaction mobility. © Copyright 2010 IEEE - All rights reserved.58631637Forman, G.H., Zahorjan, J., The Challenges of Mobile Computing (1994) IEEE Computer, 27. , AprilImielinski, T., Badrinath, B.R., Mobile Wireless Computing: Challenges in Data Management (1994) Communications of ACM, 37 (10). , OctoberVenkatraman, S., Mobile Computing Models - Are they Meeting the Mobile Computing Challenges? (2005) Association for Computing Machinery New Zealand Bulletin, 1 (1)Villate, Y., Illarramendi, A., Pitoura, E., Keep Your Data Safe and Available while Roaming (2002) Mobile Networks and Applications, 7Rouvoy, R., Serrano-Alvarado, P., Merle, P., Towards Context- Aware Transaction Services Proceedings of 6th International Conference on Distributed Applications and Interoperable Systems (DAIS), Bologna, Italy, June 2006Satyanarayanan, M., The Evolution of Coda (2002) ACM Transactions on Computer Systems, 20 (2). , MayArntsen, A., Karlsen, R., Dynamic Transaction Service Composition IADIS International Conference Applied Computing, February, 2007Noble, B., System Support for Mobile Adaptive Applications (2000) IEEE Personal Communications, 7 (1). , FebruaryChrysanthis, P.K., Transaction Processing in a Mobile Computing Environment (1993) Workshop on Advances in Parallel and Distributed Systems, pp. 77-82Dunham, M.H., Helal, A., A Mobile Transaction Model that Captures Both the Data and the Movement Behavior (1997) ACM-Baltzer Journal on Special Topics in Mobile Networks and Applications, 2, pp. 149-162Ku, K., Kim, Y., Moflex Transaction Model for Mobile Heterogeneous Multidatabase Systems (2000) Proceedings of the 10th International Workshop on Research Issues in Data Engineering, p. 39Arntsen, A., Karlsen, R., ReflecTS: A flexible transaction service framework Proceedings of the 4th Workshop on Reflective and Adaptive Middleware Systems, Grenoble, France, December, 2005Serrano-Alvarado, P., Roncancio, C., Adiba, M., Labbé, C., Adaptable Mobile Transactions Proceedings of the 29th VLDB Conference, Berlin, Germany, 2003Gray, J., Reuter, A., (1992) Transaction Processing Concepts and Techniques, , Morgan KaufmannBernstein, P.A., Hadzilacos, V., Goodman, N., (1987) Concurrency Control and Recovery in Database Systems, , Addison Wesley(1992) American National Standard for Information Systems - Database Languages - SQL, , ANSI X3.135-1992 NovemberConcurrency Control, Transaction Isolation and Serializability in SQL92 and Oracle7 (1995) Oracle Write Paper, (PART NO. A33745). , Oracle Corporation. JulyAdya, A., Liskov, B., O.Neil, P., Generalized Isolation Level Definitions Proceedings of the IEEE International Conference on Data Engineering, San Diego, CA, 2000Rocha, T., Toledo, M.B.F., (2007) Um Controle de Concorrência Híbrido para Adaptação de Transações Em Ambientes Móveis: Provas de Corretude, , Instituto de Computação - Unicamp, Relatório Técnico, IC- 07-008, MarçoRocha, T., (2004) Um Sistema de Transações Adaptável para O Ambiente de Comunicação Sem Fio, , Tese de Mestrado, Instituto de Computação- UNICAMPRocha, T., Toledo, M.B.F., A System of Adaptable Transactions for the Mobile Computing Environment Proceedings of ACM/IFIP/USENIX International Middleware Conference, Rio de Janeiro, Brasil, 2003(1997) ABNF - Augmented BNF for Syntax Specifications, , http://www.rfc-archive.org/getrfc.php?rfc=2234Chen, G., Kotz, D., (2000) A Survey of Context-Aware Mobile Computing Research, , Technical Report. UMI Order Number: TR2000-381., Dartmouth CollegeRocha, T., Toledo, M.B.F., (2005) Estudo de Modelos de Transação para O Ambiente de Computação Móvel, , Instituto de Computação, Unicamp, Relatório Técnico IC-05-25, Setembro deSerrano-Alvarado, P., Roncancio, C.L., Adiba, M., Labbé, C., An Adaptable Mobile Transaction Model for Mobile Environments (2005) International Journal of Computer Systems Science and Engineering (IJCSSE), Special Issue on Mobile Databases, 20 (3). , AprilLee, M., Helal, S., HiCoMo: High commit mobile transactions (2002) Distributed and Parallel Databases, 11 (1), pp. 73-92. , DOI 10.1023/A:1013381624108Le, H., Nygård, M., Mobile Transaction System for Supporting Mobile Work Proceedings of the 16th IEEE International Workshop on Databases and Expert Systems Applications, 200