Study On The Mobile Database Architecture Computer Science Essay

Published: Last Edited:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Nowadays the use of mobile devices such as smart phones, PDAs and laptops increased drastically. Because of this improved usage of the mobile devices, the hardware and software technologies related to mobile computing developed remarkably.

Among these developing mobile software technologies mobile databases and mobile database management systems have a dominant place.

Mobile database is also the same as a normal database but the difference is that it can be connected to by a mobile computing device over a mobile network. In here client and server have a wireless connection. And also a kind of a caching mechanism is maintained to hold frequently accessed data and transactions so that they are not lost due to connection failure.

One of the major features expected in this mobile database related applications is that the ability to download information from information repository and operated on that information locally even when the mobile devices are disconnected or out of service area of the mobile network.

These mobile database applications are mostly used among mobile workforces such as sales and marketing teams, field technicians. Types of access and workload generation of these types of applications are entirely different from traditional client - server systems. Users or mobile workforce can interchange critical data without being worrying about time and distance. They let to enter data by on the fly and the synchronization with serve database can be done in later time.

1.1 Mobile database architecture

Mobile database architecture consists several components.

Fixed Hosts

Mobile Units

Base Stations

Fixed Hosts

Fixed hosts interact with the database servers and commit transactions and perform data management activities.

Mobile Units

Portable devices or computers that are taken around the geographical areas that includes cellular networks (Cells)

Base stations

Base stations are installed in fixed locations. Base stations pass communications with the mobile units to and from the fixed hosts.

1.1.1 Pictorial Representation of a Mobile database Architecture (Fig 1.0)

Mobile Units



Ethernet cell

Base Station


Radio cell

Wireless LAN cell

Base Station

Base Station

High Speed Wired Network

When a mobile unit travels from one location to the other the particular base station of that area automatically hands over the communication link to the mobile unit to the base station of the new area.

2.1 Mobile Database Tools

Currently in the mobile database industry there are lots of mobile database management systems products which cater the user requirements with several similar and distinct features

Among these mobile database tools Sybase Inc's SQL Anywhere has the highest proportion of the field of around 68% of the mobile database market. IBM's DB2 Everyplace also a tool which provides synchronized mobile database facility. Oracle Database Lite 10 g and SQL Server Compact are also playing major roles as reliable mobile DBMS tools in the industry.

And also there are some lesser known mobile DBMS tools like SQL Base, HanDBase, Fla and Database Viewer Plus.

2.2 Features of mobile database tools

2.2.1 Sysbase Inc's SQL Anywhere

SQL Anywhere is a relational DBMS which runs in servers, clients or in mobile devices. SQL Anywhere is compatible with operating systems like Windows, Windows CE, Mac OSx, Linux, AIX and Solaris. One of the features of SQL Anywhere is the non-dependability of database files from operating system files. And it also provides standard interfaces like ODBC, JDBC and ADO.NET. SQL Anywhere also supports stored procedures, triggers, referential integrity, row-level locking, replication, proxy tables and event scheduling. And also SQL Anywhere uses a strong encryption method for client - server communication.

2.2.2 DB2 Everyplace (DB2e)

DB2e provides full synchronization that allows integrating mobile information from any location or any source at any time. It provides open standards which easily integrate DB2e with enterprise applications.

One remarkable feature of DB2e is that the advance conflict detection and resolution when syncing with JDBC compliant databases such as Db2, IDS, Oracle or Microsoft SQL Server.

DB2e basically consists of two components

DB2 Every Place Sync Server

DB2 Every Place Sync Client

DB2 Every Place Sync Server

DB2e sync server provides features to the users as a normal database server. It allows users to download data and manipulate on that data while synchronizing the changed data back to the server. Conflict resolution is also one of the major features of DB2e sync server.

Key factors of DB2e Sync server

Conflict resolution and data partitioning

Highly compression features with encryption facilities to fast and secure data synchronization

Provides features like on demand downloading of files and applications

DB2 Every Place Sync Client

Db2 Everyplace sync client is running on mobile devices allows to execute stored procedures stored on DB2 UDB database. And also it allows synchronize personal information such as E-mail and address books with enterprise messaging server.

2.2.3 SQL Server Compact

SQL Server compact database can be deployed on smart devices and computers.SQL Server Compact can be deployed on smart devices by manually or through Microsoft Visual Studio. SQL server management studio is the tool from which users can access the SQL Server Compact stored in smart devices.

Features of SQL Server Compact


Allows multi uers support