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
DB2 Evolution
DB2 Everyplace new plattforms
High Availability enhancements
LINUX coverage and scalability
Very large memory exploitation
WebSphere integration
Relational Connect Improvements
Improved migration paths from
Oracle, SQL Server, and Informix
Warehouse and Content
Universal Access
Universal Application
Universal Extensibility
Universal Scalability
Universal Reliability
Universal Management
7.2
Integrated Warehousing
Integrated OLAP
Federated databases
Native OLE DB client
XML extender
Management improvements
7
Spatial extender
Abstract Data Types
SQL stored procedures
DB2 for Linux
DB2 Satellite Edition
Ease of use
Ease of application development
Performance
6
Multiple platforms
Capacity and performance
JDBC
SMP and MPP parallelism
Data Links Manager
SQLJ
Initial OLAP SQL
5
UDTs, UDFs, LOBs
2
OS/2 and AIX platform
Low-end OLTP
Hosts
DB2 UDB for
OS/390
DB2 for VSE & VM
DB2 UDB for
AS/400
IBM DB2 Family
Universal Access
Universal Application
Universal Extensibility
Universal Scalability
Universal Reliability
Universal Management
DB2
DB2 Connect
Enterprise
Palm OS
Win
CE/PocketPC
EPOC R5
Symbian OS 6
QNX Neutrino
embedded Linux
Linux
OS/2, Win
NT/2000
AIX, HP-UX,
Solaris
Linux, NUMA-Q
Workgroup
Linux
Win
NT/2000
OS/2
Enterprise -
Extended
AIX
Linux
Win
NT/2000
Solaris
HP-UX
Win 32 (9x, NT,
2000)
AIX
Solaris
HP-UX
Personal
OS/2
Win 95, 98
Win
NT/2000
NUMA-Q
Linux
Page 5-6
DB2 Satellite scenario
Help
Desk
DB2 Control
Center
Others
Corporate
Systems
Help desk
DB2
Control
Center
queries &
commands
Step2
Step3
Satellite
Administration
Center
Replication
data
DB2
Control
Server
Saellite
Control
DB
Administration
Control
Information
Mobile or
Occasionally
Connected
Satellite System
Test and
Model
Satellite
System
Replication
Control
Information
Step1
IBM Pervasive Computing Vision
Any Content,
Any
Any
Device
Application,
Network
Services
N
C
D
ote
al
ire
s
M
a
i
l
e
n
d
ar
c
tory
Wireless
e-mail, PIM
Wired
News, Weather, Sports
Banking, Stock Trading,
Travel, Retail, Healthcare,
Public Sector
CRM, SFA, ERP, SCM
Navigation, Fleet Management
Music, Video, Game
The natural extension of
e-business
Page 7-8
DB2 Everyplace __ WHY??
increase employee productivity
increase customer satisfaction
improve business operations with up to date information
Field force automation, insurance, healthcare, retail,
financial services
DB2 Everyplace Sync connection options
infrared or cable to cellphone
wireless lan
integrated cellular
Internet
or other Network
serial cable, cradle, or infrared to pc
Sync Server
Data
modem to POTS line
Sources
Page 9-10
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.”
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
Healthcare: Asatte
Healthcare - Mobile Patient Record Management System used in
clinics
Patient Info is downloaded each a.m; updated and supplemented
each day; uploaded to main database each p.m.
benefits of reduced input errors, saves staff time entering doctor
information
Information is generic (weight, bp, etc)
and then customized per clinical
speciality allowing for data collection
and compilation
leads to best practices
helps in study participation
Asset Tracking: Essential Systems
Asset Tracking Application
DB2E database
UDB on Palm
DB2E sync server
on Linux
DB2
on Linux
1. Worker A takes tool.
2. Worker B scans bar code of tool & worker.
3. Information reconciled with corporate
accounting, inventory and employee
systems
Benefits:
Tools and Tool status tracked
Tool use can now be billed per job
Page 15-16
Retail/Sales Force Automation: NetSet
Sales Force Automation Application tied in with retail store point of
sale and Lawson accounting system
DB2E database
on WinCE/
DB2E sync server
on WinNT
DB2 UDB
on AS/400
Compaq IPAQ
"seconds"
"less than a minute"
1. Salesperson takes order and verifies
PDA;
2. Order forwarded from
immediate fulfillment
item in stock;
76,000 SKUs to choose from.
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-Serw
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.
Component Name
Description
Database Engine
Stores and processes data on mobile and
embedded devices
DB2 Everyplace
Database
Synchronization Server
Synchronizes data between devices and
enterprise data sources
DB2 Everyplace
Sync Server
DB2 Everyplace
Mobile Application Builder
Application Development Tool
Allows rapid application development for Palm
OS platform
Page 19-20
ryplac
Mid-tier
Server
Data Source
Test
DB2
Everyplace
Sync
DB2
DB2 UDB or
JDBC or
custom data
sources
Mobile
Application
Builder
Everyplace
Server
DB2
Everyplace
(Database engine)
Develop
mov
productio
DB2 Everyplace Architecture
Application Programming Interface
CLI/ODBC
JDBC
DB2
SQL Compiler
Parser, Semantics
Optimizer, Interpreter
System Tables:
DB2eSYSTABLES
DB2eSYSCOLUMNS
DB2eSYSRELS
Data Manager Services
Index Manager, Record Manager
Buffer Manager
DB2
User Tables
Operating System Services
Page 21-22
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
DROP TABLE/INDEX
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
Page 23-24
DB2 Everyplace Characteristics
CREATE TABLE
with following datatypes
INTEGER
|
SMALLINT
DECIMAL (Big)
CHARACTER(Smallint)
VARCHAR(Smallint)
BLOB(Smallint)
DATE
TIME
TIMESTAMP
and options
PRIMARY KEY with more than one column
referential constraints
CHECK constraints
CREATE TABLE
create table ORDERS
(CUSTNO CHAR(6)
NOT NULL,
ENTRY TIMESTAMP NOT NULL DEFAULT Current Timestamp,
ITEM CHAR(15) ,
PRICE DECIMAL(9,2),
Check (Price < 100),
PRIMARY KEY (CUSTNO,ENTRY))
Page 25-26
DB2 Everyplace Functions
Functions supported
AVG
(expression)
(expression)
(expression)
SUM
MIN
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
IBM Sync GUI
Mobile Devices
Administration Center
DB2
Family
Sync
Engine
API
DB2 adapter
File adapter
HTTP
Sync
Engine
DProp adapter
SyncML
WAP
SyncML
Agent adapter
Synchronizer
using
WBXML
Agent adapter
JDBC adapter
Bluetooth
Informix
PIM adapter
Adapter
API
Transport
API
DB
Server
Adapter
API
Devices
Palm OS,
Synchronization
Server
Data
Sources
Windows NT/2000
AIX,Linux,Solaris
NB: DB2 UDB is a pre-req for
Sync Server and is delivered as
workgroup edition
Win CE,Win32,Pocket PC
EPOC, SymbianOS
Neutrino, embedded Linux
Page 27-28
Mobile device administration center
MDAC is the tool to define all these object properties
DB2 Everyplace Mobile application
builder
rapid application prototyping
Enables
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
Supports Palm OS, JAVA and QNX Neutrino
Supports Windows Embedded Visual Tools 3.0
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
developer forum
redbooks (http://www.redbooks.ibm.com)
SG24-6217-00
IBM Replication Solutions for Pervasive Computing
DB2 magazine
To subscribe go to
Documentation
Installation and User Guide manual
Application Development Guide manual
Sync server administration guide
Schulung
The End
Page 33-34
Packaging & Pricing - 7.2.1
Package
Components
Included
Database
Price
DB2 Everyplace
63 (US) per registered
user
Database Edition
DB2 Everyplace
Database
Sync Server
12,608 per server
processor
Enterprise Edition
+
94 per registered
user
DB2 Everyplace
Mobile Application
Builder
Free Download off the
Web
Mobile Application
Builder
Preise Staffel A 1 Jahr Maintenance passport advantage
Page 35-36
|