IBM 7.2.1 manual DB2 Everyplace Solution, DB2 Everyplace Architecture

Page 11

The DB2 Everyplace Solution

 

 

 

 

Mid-tier

Data Source

Test

 

Server

 

 

 

Mobile

DB2

 

 

Everyplace

DB2 UDB or

Mobile

DeviceDB2

Sync

JDBC or

Application

Everyplace

Server

custom data

Builder

 

 

 

 

 

sources

DB2

 

 

 

Everyplace

 

 

 

(Database engine)

 

 

 

Develop

 

 

 

 

move to

 

 

 

production

 

 

DB2 Everyplace Architecture

Application Programming Interface

CLI/ODBC JDBC

SQL Compiler

Parser, Semantics

Optimizer, Interpreter

Data Manager Services

Index Manager, Record Manager

Buffer Manager

Operating System Services

DB2

System Tables:

DB2eSYSTABLES

DB2eSYSCOLUMNS

DB2eSYSRELS

DB2

User Tables

Page 21-22

Image 11
Contents Agenda DB2 EveryplaceThings to think about IBM Mobile solutions-- technical overviewIBM DB2 Family IBM Pervasive Computing Vision DB2 Everyplace Sync connection options DB2 Everyplace WHY??Business applications Field Force Automation Gas de France ISVs and partnersUDB on Palm On Linux Healthcare AsatteAsset Tracking Essential Systems Asset Tracking Application DB2E database DB2E sync serverRetail/Easy of Use Penn State Retail/Sales Force Automation NetSetGoDB2 Everyplace System Monitoring/Embedded X-SerwisDB2 Everyplace Architecture DB2 Everyplace SolutionDB2 Everyplace SQL DB2 Everyplace CharacteristicsCHARACTERSmallint VARCHARSmallint BLOBSmallint Create table OrdersExpression can be DB2 Everyplace FunctionsSync Server Design Overview Functions supportedMdac is the tool to define all these object properties Mobile device administration centerCommercial Development tools contd Robust Development environmentReferences/resources EndEnterprise Edition Packaging & Pricing