|Oracle® Database Lite Getting Started Guide
Part Number E12080-02
A common misconception of Oracle Database Lite is that it is a simplified, small-scale database designed to run on laptops, handhelds, cell phones, and so on. While you can use it in this manner, this is only one model for using the product. In addition, Oracle Database Lite provides a complete mobile infrastructure designed to run enterprise database applications within a world constantly on the go. Oracle Database Lite provides the infrastructure that makes the enterprise application and data store available even when communications to the enterprise itself are not available or reliable. Oracle Database Lite brings the applications that were once limited to the base office and deploys these applications out into the world where they are most needed.
The following sections describe how you can use Oracle Database Lite to streamline your operations in the field:
The mobile architecture completes the enterprise system by merging the enterprise infrastructure with every remote aspect of the organization. Previously, the remote location was missing from the enterprise design. A mobile architecture contains the remote application, the remote data store, and the remote rules of the business. The Oracle Database Lite mobile infrastructure is responsible for connecting and synchronizing applications, associated data, and business rules with the applications, data store, and business rules of the enterprise.
There are several ways you can use and implement Oracle Database Lite. See Section 1.3, "Execution Models for Applications that Use the Oracle Lite Database" in the Oracle Database Lite Client Guide for more details.
A mobile architecture with the proper design, security components, and implementation saves money. Oracle Database Lite can remove some of the manual processes performed out in the field. In the past, you may have manually written down the information in the field and then manually entered the data in the enterprise database once you returned to the corporate environment. With Oracle Database Lite, you can capture the data once in the field by entering the data into a client device. Then, this data is synchronized up to the enterprise without returning to the office to manually enter data. This removes a loss of productivity due to manual processes and sends the data immediately to the enterprise where it belongs. In addition, data can flow bi-directionally. If you need information at the remote site that has been updated at the office, this data is brought down to the client device during synchronization.
You can use the mobile architecture in several types of application environments, as follows:
Mobile option—An application is created, where the user enters data on a client device, known as the Mobile client. The Mobile client can use either the SQLite database client or the Oracle Lite database as the client database. The data on either Mobile client is synchronized with a back-end Oracle database. For example, if you have a sales force, each sales person retrieves only his/her data on the client device. Any modifications made on either the Mobile client by the sales person in regards to his/her accounts or modified on the server by the office can be synchronized.
Embedded option—An application may need an independent small database to exist solely for the application's use. No synchronization of data with a back-end database is necessary. For example, if you have an individual accounting application, it may need a small embedded database to store the data for the individual accounting data. The embedded option is only supported by using the Oracle Database Lite client.
Alternatively, the software that supports hardware may need an embedded database to facilitate gathering information, which is then synchronized with a back-end database for the office to evaluate its state.
For example, a vending machine can use the Oracle Database Lite infrastructure to maintain inventory, control the dispatching of technicians and restock personnel, gather marketing statistics, and so on.
Another example is a system included in an automobile that tracks and communicates maintenance needs for the automobile. When maintenance needs are proactively found, the customer saves on repair costs, towing and expensive part replacement that may otherwise have occurred.
The Mobile repository resides in the back-end enterprise database, which links the enterprise data with the mobile data.
The Mobile Server is a Web-based tier that integrates with OracleAS and the Oracle WebLogic Server. Support exists for previous versions that use Oracle Containers for J2EE (OC4J).
This accesses remote locations through different types of wireless or wired connectivity. It facilitates the major functions for the Mobile option, such as synchronization, application management, device management, and so on.
The Mobile client uses a client database, which can be either a SQLite database or Oracle Lite database, and the means for deploying applications developed using the most popular languages. The Mobile client database stores the relational data in one or more data files on the file system on the client. While the SQLite database is already installed on many client devices, you can install the Oracle Lite database on most any device from a cell phone, to a personal digital assistant (PDA), Tablet PC, Laptop, and so on from the Mobile Manager.
The Mobile Server is a compilation of two products: the Mobile Server and the Mobile client database.
In an enterprise system, the Mobile Server facilitates the synchronization of data between multiple Mobile client databases and Oracle databases.
SQLite client database: If you are using the SQLite database as the Mobile client database, you must install this independently. If it is not already installed, refer to
http://www.sqlite.org/ for more information on installation, configuration and usage. After installing the SQLite database, install the SQLite Mobile client, which includes the Sync Engine for managing synchronization between the SQLite database and the back-end Oracle database. SQLite libraries are installed on Android and Blackberry; SQLite libraries are provided for Win32, WinCE, and Linux platforms. For details, see Chapter 2, "Installing the SQLite Mobile Client" in the Oracle Database Lite SQLite Mobile Client Guide.
Oracle Lite database: In a mobile environment, each Oracle Lite database must be installed from the Mobile Server to be enabled for synchronization. To properly install, develop and administer all components in the Mobile Server, first follow instructions in the Mobile Server books.
The instructions for installing the Oracle Lite database in a Mobile Server environment for synchronization support is in the Oracle Database Lite Client Guide.
You can embed the Oracle Lite database within an application and use it independently of the Mobile Server. To understand the Oracle Lite database, see the Oracle Database Lite Client Guide.
The following sections provide a roadmap for where to find the information to design, develop and manage the Mobile Server:
When you design a Mobile application that provides synchronization of data from several users on multiple devices to one or more Oracle databases, you must carefully consider a balance between application functionality and minimizing the data being synchronized before you start to develop your application. Synchronization from multiple users and devices can cause performance issues. Thus, the design has an impact on how performant is the data synchronization.
To streamline your development, we have provided several sections guiding you through design decisions before developing a Mobile application. For full details, see Chapter 1, "Overview for Designing Mobile Applications" in the Oracle Database Lite Developer's Guide.
The following sections describe each Mobile client database type from which you can use to synchronize data to the back-end Oracle database:
The SQLite database is a small, compact, and self-contained database available on multiple platforms and available to the public. It has a small footprint and is easy to install and administer. In addition, many devices already have the SQLite database installed, including Android and Blackberry devices.
If you want to use a SQLite database on any device and synchronize the data entered in the SQLite database to a back-end Oracle database, install the SQLite Mobile client, which includes the Sync Engine that supports synchronization. For Win32, WinCE and Linux platforms, both automatic and manual synchronization is supported. On Android and Blackberry devices, only manual synchronization is supported. For more details, see Chapter 2, "Installing the SQLite Mobile Client" in the Oracle Database Lite SQLite Mobile Client Guide.
The Oracle Lite database is a small database specifically designed for a client device, it has a small footprint and is easy to administer. The Mobile Server uses the Oracle Lite database to gather and synchronize data from multiple mobile devices from several users.
The Oracle Lite database is its own product and is described completely in the Oracle Database Lite Client Guide. It can be used with the Mobile Server for synchronizing data to a back-end Oracle database or an Oracle RAC database. In this case, always consult the Mobile Server books first before consulting the Client guide, as the Oracle Lite database used within the Mobile Server environment has slight modifications in how you install, configure, and develop to enable the Oracle Lite database for synchronization.
The Mobile Manager is a GUI tool that enables you to configure and manage the Mobile Server. Some of the functions you can perform through the Mobile Manager are as follows:
Determine performance of your SQL queries.
Resolve errors, including conflict errors.
Configuration and management of the Mobile Server are described in the Oracle Database Lite Administration and Deployment Guide.
Mobile devices do not have the processing power and memory that standard enterprise systems maintain. If the mobile applications and infrastructure are not tuned appropriately they really are of little benefit to the organization.
The most important performance concepts for a mobile infrastructure are as follows:
The time it takes to enter and retrieve data.
The time it takes to synchronize data with the enterprise data store.
See Oracle Database Lite Troubleshooting and Tuning Guide for techniques to enhance your performance for Oracle Database Lite.