DB2 Everyplace V7.2.
IBM Mobile solutions-- technical overview Browser Application Data Websphere Everyplace Device Message Message Application Application Websphere MQ Everyplace Data Company Data Data Application DB2 Everyplace Lotus Domino Everyplace DB2 PE/WE Satellite functionality Things to think about....
DB2 Evolution Universal Access Universal Application Universal Extensibility Universal Scalability Universal Reliability Universal Management 7.
DB2 Satellite scenario Help Desk Corporate Systems Help desk queries & commands Step3 Replication data DB2 Control Center Others Step2 DB2 Control Server Administration Control Information Replication Control Information Mobile or Occasionally Connected Satellite System DB2 Control Center Satellite Administration Center Satellite Control DB Test and Model Satellite System Step1 IBM Pervasive Computing Vision Any Content, Application, Se
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 serial cable, cradle, or infrared to pc Internet o
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 - inv
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.
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.
Retail/Sales Force Automation: NetSetGo Sales Force Automation Application tied in with retail store point of sale and Lawson accounting system DB2E database on WinCE/ Compaq IPAQ DB2E sync server on WinNT "seconds" 1. Salesperson takes order and verifies PDA; item in stock; 76,000 SKUs to choose from. DB2 UDB on AS/400 "less than a minute" 2.
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.
The DB2 Everyplace Solution Mid-tier Server Test Mobile Application Builder Mobile DB2 Device Everyplace DB2 Everyplace Sync Server Data Source DB2 UDB or JDBC or custom data sources DB2 Everyplace (Database engine) Develop move to production DB2 Everyplace Architecture Application Programming Interface CLI/ODBC JDBC SQL Compiler Parser, Semantics Optimizer, Interpreter DB2 System Tables: DB2eSYSTABLES DB2eSYSCOLUMNS DB2eSYSRELS Data Manager Services Index Manager, Record Manager Buffer Manag
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 (as
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 PRICE CHAR(15) , DECIMAL(9,2), 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
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.
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 CodeWarrio
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.
Packaging & Pricing - 7.2.
