DB2 Everyplace V7.2.1 -

Mobile and Embedded Database

and Synchronization Architecture

Joachim Stumpf

DB2 Technical sales support

Agenda

Introduction

Reference scenarios

Components

Database functions and features

Sync architecture

Administration

Application development Information sources

Page 1-2

Business applications

Business to Employee Productivity

Field Force Automation

Customer and product information

Barcode and part information from scanning devices

Insurance policy information

Auditing information for quality and safety applications

Monitoring of system information

Business applications

Industries - Customer Relationship Management

Insurance - policy information, pricing information

Healthcare - Nurses, healthcare professionals

Education - student information for teachers

Distribution - inventory tracking

Telecommunications - auditing of telecommunications sites

Finance - mobile banking

Government - Social Services, Policy enforcement Retail - point-of-sale automation for retail chains, kiosks

Page 11-12

ISVs and partners

DB2 Everyplace and Pervasive Computing efforts in DM follow the overall DM ISV strategy.

Current partners:

- Siebel 7 Sales Handheld for Palm OS

- RiverRun creates integrated PvC solutions

"PeopleSoft will leverage DB2 Everyplace as the local data store for PeopleSoft???s mobile applications. With a small footprint and its robust functionality, DB2 Everyplace provides a foundation for functionally rich mobile applications that can be quickly deployed to the end user."

???Leveraging DB2 Everyplace as the local data store device with PeopleSoft???s pure internet data sync technology will enable mobile professionals to access and sync data at their convenience,??? said Janet Perna, general manager of IBM Data Management Solutions. ???The combination of DB2 Everyplace and PeopleSoft???s new mobile technology will empower PeopleSoft 8 customers with

real-time information in mobile environments.???

http://www.peoplesoft.com/conf/connect/1pla_4.html

Field Force Automation: Gas de France

IBM Global Services and Gas de France created a mobile gas meter reader application

Deployed to 700 field engineers using Palm OS devices to monitor customer gas meters

Uses the DB2 Everyplace Sync Server to synchronize with existing DB2 infrastructure

Integrated with their Tivoli management environment

Page 13-14

Retail/Sales Force Automation: NetSetGo

Sales Force Automation Application tied in with retail store point of sale and Lawson accounting system

Benefits: Fewer errors, Faster delivery, Sales productivity

Retail/Easy of Use: Penn State

Penn State Center for Advanced Information Technology

Used DB2 Everyplace in second year college class - students created a 'store' that can be accessed from a Palm device to order or check order status

Use DB2 Everyplace on Palm OS; Sync Server on NT

"We were amazed that DB2 Everyplace was a full function database, yet had a small footprint and ran on an handheld device...And the Mobile Appplication Builder was fantastic - led students through a point and click programming process and automatically created the C code for the Palm..."

Page 17-18

System Monitoring/Embedded: X-Serwis

Solution based on DB2 Everyplace running on embedded x86 hardware and QNX Neutrino

X-Serwis created a Weather reporting system based on European Union standards.

Required robustness and reliability for continous operation in remote locations.

Benefit

100% ROI in one year

annual savings of US$1.5 million in road maintenance costs

more cost-effective road maintenance resulting from accurate evaluation of icy road conditions

improved driving safety

???Using IBM DB2 Everyplace databases in 12 remote weather monitoring stations around the city, the Warsaw Road Maintenance authority knows just where to send crews to clear the roads of ice and snow, and can act quickly.???

Jaroslaw Luczak

Managing Director,X-Serwis

DB2 Everyplace

DB2 Everyplace is a small footprint relational database and synchronization server for mobile computing and embedded devices.

Page 19-20

DB2 Everyplace Characteristics

RDBMS especially made for mobile devices and embedded systems API's

DB2 Call Level Interface (CLI) / ODBC subset

A set of C/C++ function can be called in programs to access the database JDBC and Java application support

DBCS (double byte character set) and NLV support Encryption (communication)

???
      
            

IBM Microdrive and Compact Flash Memory support

DB2 Everyplace SQL

Supports a subset of SQL

CALL procedure

CREATE INDEX (asc/desc) bidirectional

CREATE TABLE

EXPLAIN

INSERT with subselects and default values

DELETE

UPDATE (records)

SELECT (records) with

JOIN ( up to 8 tables)

GROUP BY

ORDER BY (asc/desc)

LIMIT (integer) for result set

IN predicate

scrollable cursors

. / 0 1 2 3 4 / 5 0 / 2 3 16 5 0 7 8 8 6 4 3

Page 23-24

DB2 Everyplace Characteristics

CHARACTER(Smallint)

VARCHAR(Smallint)

BLOB(Smallint)

DATE

TIME

TIMESTAMP and options

PRIMARY KEY with more than one column referential constraints

CHECK constraints

Check (Price < 100),

PRIMARY KEY (CUSTNO,ENTRY))

Page 25-26

DB2 Everyplace Functions

Functions supported

AVG(expression)

SUM(expression)

MIN(expression)

MAX (expression)

COUNT(expression)

CONCAT(expression,expression)

MOD(expression,expression)

LENGTH(expression)

RTRIM(expression)

expression can be

a literal like *

column name , function , special register

Sync Server Design Overview

Page 27-28

Mobile device administration center

MDAC is the tool to define all these object properties

DB2 Everyplace Mobile application builder

Enables rapid application prototyping and development on Palm OS without writing a single line of code.

Includes DB2 Everyplace sample applications (source code & project file)

Page 29-30

Robust Development environment

Programming interfaces supported

DB2 Call Level Interface (CLI) / ODBC subset

Java DataBase Connectivity (JDBC) driver for Java applications Visual Basic Interface for Win32,WinCE/PocketPC application development

Included Developer tools

Database Import and Export utilities

Command Line Processor for all platforms

Sample applications with full source C/C++ code

Mobile Application Builder for Palm OS available free from website

Commercial Development tools

Metrowerks CodeWarrior - http://www.metrowerks.com/platforms/ Supports Palm OS, JAVA and QNX Neutrino

Microsoft Visual Studio - http://msdn.microsoft.com/cetools/ Supports Windows Embedded Visual Tools 3.0

Visual Age MicroEdition from OTI - http://www.embedded.oti.com Supports JAVA on Palm OS, QNX Neutrino, and embedded Linux

Robust Development environment

Commercial Development tools (cont'd)

Software Development Kits

Palm OS SDK

EPOC R5, Symbian 6

Lineo Embedix SDK (embedded Linux)

Lynuxworks Lynux SDK (embedded Linux)

QNX Neutrino 2.0 SDK

Page 31-32

References/resources

DB2 Everyplace website

http://www.ibm.com/software/data/db2/everyplace

developer forum

http://www.developer.ibm.com redbooks (http://www.redbooks.ibm.com)

SG24-6217-00 IBM Replication Solutions for Pervasive Computing

DB2 magazine

http://www.db2mag.com/db_area/archives/2001/q4/zikopoulos.shtml

DB2 Everyplace db2everyplace@yahoogroups.com To subscribe go to

http://groups.yahoo.com/group/db2everyplace

Documentation

Installation and User Guide manual

Application Development Guide manual

Sync server administration guide

Schulung

Kurs 'CG20EDE' http://www.ibm.com/de/learning/

The End

Page 33-34

Packaging & Pricing - 7.2.1

Preise Staffel A 1 Jahr Maintenance passport advantage

Page 35-36