The Features Of Oracle9ilite 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.

In Day to Day life use of laptops, mobiles and PDAs are increasing and demand of mobile database applications are also increasing. So selecting best mobile database tool for your application won't be that much easy.

Mohanty (2008,p.2)said' Research analysts predict that by 2006, there will be over one billion mobile devices in use worldwide' . But it is difficult to tell which tool will be the most popular.

Depending on the Os platform, Usability, Security Provisions protect data, Memory Footprint & connection protocols we can select the mobile different databases.

But important of the mobile database application will depend on the ability to download information from the server & operate that information even when mobile device is "out of range" or disconnected.

And that will be the main purpose of mobile database tools. Because it helps to overcome issues such as dropped connection, low bandwidth & high latency that are appears on wireless networks.

So by looking at the current mobile database market we can classify mobile database tools in to two categories.

Open source mobile database Software tools

Commercial mobile database Software tools.

OPEN Source mobile database Tools

In mobile database market there are some tools distributed under a Free and Open Source license like GPL (General Public License). If you are going to develop mobile application as a developer using mobile databases & if you need lot of flexibility for that, then going for open source mobile database tools will be best choice. Because using open source database tools, you can have total control over all changes.

In my Survey I found out 4 open source database tools


Sleepy cats Berkeley DB ( having dual model license)


Mobile Databases 1.25


As stated in 'J2MEMicroDB' (2010), J2MEMicroDB is the name of the Open source project that has been started in the UPC ( Universitat Politecnica de Catalunya ) in order to develop a J2ME solution to extend the functions of the J2ME persistent API, and allow access from mobile applications to remote & local databases.

Architecture OF J2MEMICRODB

Layer Architecture of the J2MEMicroDB (Source: As stated in 'J2MEMicroDB' (2010))

According to the layer Architecture Lower layer (RMS Layer) is provided by J2ME. As stated in 'J2MEMicroDB' (2010), J2ME is the development platform for mobile devices with larger support and availability in the market right now. This J2ME having API function & one of the most important issue is its persistent storage capability.

Actually there is only one package used for storing & retrieving information from mobile devices. It's called " javax.microedition.rms ".As stated in 'J2MEMicroDB' (2010), This package is based on Record stores . A Record store is the equivalent of a simple file. A Record Store Stores a set of records in binary format.

Although this package allows developers to store and retrieve information from files & to files on mobile devices, it has some limitations.

It is not possible to directly store objects in a Record store objects in a Record store. Data is stored in a Record Store as a sequence of bytes. That is an important limitation for java developers because they usually need to manage objects in their applications.

Very limited search capabilities in the Record store. Each Record stored in a Record Store has an identifier (called recorded). The searches of data are bases on this Id.

( 'J2MEMicroDB' (2010))

To overcome above issues there is another layer on top of the RMS layer. It called Object Oriented (OO) storage layer. That layer simply provides 4 types of files

Direct Access

Sequenced Access

Key Value Access

Key Value Sequenced Access

These files types Store objects in a Record Store and improve access and search of data among the objects. And the most important benefit of this layer is it's having possibility of object serialization.

In order to translate the objects and labels to real data stored in the RMS file, OO Storage Layer used two indexing mechanisms.

Index Table

Index Table consists of a table, which stores the physical position of a record in the

RMS file related to a label.


BTree used to improve the performance of the file in search processes & it stores physical position of records and their related labels. ( 'J2MEMicroDB' (2010))

Above OO Storage Layer a Relational database layer was built & it allows developers to create a database on a mobile device and manage data stored on relational tables.

Finally the fourth layer (SQL Layer) gives a limited SQL interpreter to query the local database as well as methods to access remote database.


This database is very lightweight

This is very important feature because most of mobile devices are having limited storage capabilities.

Very Efficient

'Mobile databases must provide quick response to user actions. So J2MEMicroDB reduced time to access the information user requested'

This Implements a relational database on a mobile device.

Implements a persistence engine to easily store and retrieve Objects.

Accesses a remote DBMS host through a web service and stores remote information on materialized vies on the mobile device

( 'J2MEMicroDB' (2010))

Sleepy cats Berkeley DB

Since 1996 to 2006 Berkeley DB packages maintained & gave free Software license by the Sleepycat Software,inc Company . But after Oracle acquired Sleepycat in 2006 February its having dual model license.

David Mitchell (2006, p.2 ) says Berkeley DB is ' Open source license allows Berkeley DB to be freely embedded in other open source projects , while the commercial license allows the embedded to protect the confidentiality of their code and to have contractual warranties and indemnities provided by Oracle '

Features OF Sleepy cats Berkeley DB

To work with Berkeley DB developers don't need any management utilities.

The Database is not depending on the existing operating system.

Perform maintenance tasks such



Perform Tuning

Routine maintenance.


db4o (database for objects) is an embeddable open source object database & this can use both java and .NET developers.

As stated in Versant Corp(2010)' Versant provides dual - licensed for db4o. They give to choice free or commercial license'. But if db4o going to embed in a commercial products or user need any commercial support then it is required to have commercial license.

Features OF db4o

Data Management

Data management in db4o it is provide special support for large collections of data by having BigSet class based on BTrees.

Having it's own cache of persistent objects.

Store data db4o having a single database file

This DB4o is easy to set up databases.

One line of code to open the database is sufficient.

If database does not exist it will be created.

( Roberto V.Zicari (2010))


This is not supporting SQL Queries.

But it having four different querying mechanisms

Query - By - Example


Native Queries

LINQ (.NET only )

( Roberto V.Zicari (2010)

Support Operating Systems

Db4o is developed using Java & .NET. There for all operating systems that support java & .NET will also run db4o. ( Roberto V.Zicari (2010))

Mobile Databases 1.25

This is a free ware & developed by Mobile Hall.

Commercial mobile database Tools

According to my Survey I found out several commercial mobile database tools.


Sybase Inc.'s SQL Anywhere


Borland's JDataStore

IBM DB2 Everyplace (DB2e)


Microsoft's Mobile Databases

Pocket Access 2002

Microsoft SQL Server Compact


Architecture OF ORACLE9iLITE

Oracle 9i Lite Architecture (Source: Beeshmoy Kumar (2008,p.15))

Features Of ORACLE9iLITE

Very Powerful

Supports 100% Java development.

Can work with any development tool which supports ODBC.

Eg : Visual Baisc , C++ , Delphi

Maximum Database Size will be 4GB

It includes support for Win32, Windows CE, Palm Os and EPOC database clients with Oracle's advanced Queuing (AQ) mechanism.

Includes a mobile server control.

Oracle9iLite having a good server side management mechanism.

Use B+ Tree as Indexing mechanism

Having Extremely Large Footprint.

( Guimaraes p.18 of 2)

Sybase Inc.'s SQL Anywhere

According to Mohanty(2008,p.13), 'Sybase Inc.'s SQL Anywhere having the 68% of the mobile database market' .

Features OF SQL Anywhere

Database files are not depending on the operating system.

Whether it is Windows, Windows CE , Mac Os X or UNIX platforms such as Linux , AIX and Solaris can use this very easily.

Provide ODBC, JDBC and ADO.NET interfaces

Supports stored procedures & user functions using Watcom SQL , T-SQL , Java or C/C++

Can use as database files or client -server communication.

Can Synchronize Data to Database of different Vendors ( not tied to Sybase's Enterprise Edition)


This having small footprint. There for this mobile database is suitable for small mobile devices such like PDS s & Smart Phones.

Features OF Ultralite

Developer don't have to learn 2 different DB

Only include Database Engine what is needed

Has power of Server

Faster Access Plans are already compiled.

( Beeshmoy Kumar ,2008,p.14)

Borland's JDataStore

Borland's JDataStore is very fast & very versatile portable embedded java database.

Features OF Borland's JDataStore

Having very small footprint

Requires practically zero maintenance

Delivers the performance


Synchronization capabilities of a full-power database.


IBM DB2 Everyplace (DB2e)

DB2e is work as relation database & enterprise synchronization sever which extends enterprise application to mobile devices.

Features OF DB2e

It can store, Retrieves, organize & manage data in to better way .

Available for Plam Os , EPOC , Neutrino , Windows CE and embedded Linux .

DB2e is capable of synchronized data on handheld device to a sever using relational database management system.


Features OF Pointbase

Like Oracle Lite this is also Java Based.

Can use on wide variety of platforms ( more than Oracle Lite)

(Guimaraes p.27)

Microsoft's Mobile Databases

Pocket Access 2002 (Features)

ADOCE database Access classes

For smaller database applications that need to operate on a small number of tables

These database files are stores under .cdb extension & populated by one or more tables from a desktop access database.

Replication /Synchronization is very simple , through ActiveSync

(Guimaraes p.25)

Microsoft SQL Server Compact (Features)

This having small footprint embedded database.

Developed for Microsoft Windows Mobile users only.


It is difficult to select the best mobile database out of those. Because it depends on the Os platform, availability of data, Memory footprint & management Utilities which are needed for you a application.