MOBILE DATABASE
By Champa. S. Bopegama
PG/IT/09/097
What is a mobile database?
A mobile database is a database that can be connected to with a mobile computer device through a mobile network.
What is a mobile database?
The client and server have wireless connections. Users can exchange mission-critical data remotely without worrying about time or distance from their mobile phones or PDAs with mobile databases.
The Mobile Database Application
Mobile applications can be categorized in two ways. 1. Vertical Applications 2. Horizontal applications.
Vertical application
In a vertical applications users access data within a specific cell, and access is denied to users outside of that cell. E.g.- users can obtain information on the location of doctors or emergency centers within a cell or parking availability data at an airport cell.
Horizontal Application
In horizontal applications users cooperate on accomplishing a task, and they can handle data distributed throughout the system.
Types of data in Mobile Applications
Data can be classified into three categories 1. Private data 2. Public data 3. Shared data
Private data
A single user owns this data and manage it. No other user may access it.
Public data
This data can be used by anyone who can read it. Only one source updates it. E.g. Weather bulletins or stock prices. Primarily managed by vertical applications.
Shared data
This data is accessed both in read and write modes by group of users. E.g.- Inventory data for products in a company.
Shared data is used by horizontal applications.
Motivation
In a mobile database application a part or a replica of the database is locally installed on the mobile device. This is a significant difference compared to a con-ventional clientserver application where all data is centrally stored in a database server.
Mobile database system architecture
Users are not attached to a fixed geographical location Mobile computing devices: low-power, low-cost, portable Wireless networks Mobile computing constraints
Three parties involving in Mobile data base
Mobile Data Base
Fixed hosts
Mobile units
Base stations
Fixed hosts
Perform the transaction and data management functions with the help of database servers.
Mobile units
portable computers move around a geographical region includes the cellular network (or "cells") these units are used to communicate with base stations. these networks do not need to be cellular telephone networks
Base stations
Two-way radio installations in fixed locations communicates with the mobile units to and from the fixed hosts. typically low-power devices such as mobile phones, portable phones, or wireless routers.
A general architecture of a mobile platform
A Mobile database system
Characteristics of Mobile Database Environments
Residence latency.
users are mobile and randomly enter and exit from cells.The average duration of the user stay in cell is referred as residence latency. Intermittent connectivity. Limited battery life. Changing client location.
Mobile database tools
Oracle Database Lite 10g provides mobile workers the experience of continuous access to data unconstrained by network bandwidth and coverage. It extends the grid environment to mobile devices, allowing mobile workers to access enterprise data even in the absence of a network connection.
Architecture diagram of Oracle Database Lite 10g
Data Management Issues
From a data management standpoint, mobile computing may be considered as a variation of distributed computing.
Data Management Issues
Mobile databases can be distributed under two possible scenarios: 1. The entire database is distributed mainly among the wired components, possibly with full or partial replication. A base station or fixed host manages its own database with a DBMSlike functionality, with additional functionality for locating mobile units and additional query and transaction management features to meet the requirements of mobile environments.
Data Management Issues
2. The database is distributed among wired and wireless components. Data management responsibility is shared among base stations or fixed hosts and mobile units
Data Management Issues
Data management issues as it is applied to mobile databases: Data distribution and replication Transactions models Query processing Recovery and fault tolerance Mobile database design Location-based service Division of labor Security
References
Fundamentals of database systems Elmasri & Nawathe http://www.wikiepedia/Mobile database systems
Thank you!