Summary of the content on the page No. 1
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
Summary of the content on the page No. 2
IBM Mobile solutions-- technical overview Browser Application Data Websphere Everyplace Message Message Company Device Application Application Websphere MQ Everyplace Data Data Data Application DB2 Everyplace Lotus Domino Everyplace DB2 PE/WE Satellite functionality Things to think about.... Why a relational database versus a flat file API's easier application development Replication of data with backend sources relational capabilities Page 3-4
Summary of the content on the page No. 3
DB2 Evolution DB2 Everyplace new plattforms Universal Access High Availability enhancements Universal Application LINUX coverage and scalability Universal Extensibility Very large memory exploitation Universal Scalability WebSphere integration Universal Reliability Relational Connect Improvements 7.2 Universal Management Improved migration paths from Integrated Warehousing Oracle, SQL Server, and Informix Integrated OLAP Warehouse and Content Federated databases Native OLE DB client Management i
Summary of the content on the page No. 4
DB2 Satellite scenario Help Desk DB2 Control Center Others Corporate Systems Help desk DB2 queries & Control commands Step3 Step2 Center Satellite Administration Center Replication DB2 data Control Satellite Server Control Administration DB Control Information Mobile or Replication Test and Occasionally Model Control Connected Satellite Information Satellite System System Step1 IBM Pervasive Computing Vision A An ny y C Co on nt te en nt t,, A An
Summary of the content on the page No. 5
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 c
Summary of the content on the page No. 6
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 Distrib
Summary of the content on the page No. 7
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
Summary of the content on the page No. 8
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 Tr
Summary of the content on the page No. 9
Retail/Sales Force Automation: NetSetGo Sales Force Automation Application tied in with retail store point of sale and Lawson accounting system DB2E database DB2E sync server DB2 UDB on WinCE/ on WinNT on AS/400 Compaq IPAQ "seconds" "less than a minute" 1. Salesperson takes order and verifies 2. Order forwarded from PDA; item in stock; immediate fulfillment 76,000 SKUs to choose from. Benefits: Fewer errors, Faster delivery, Sales productivity Retail/Easy of Use: Penn State Penn State Center fo
Summary of the content on the page No. 10
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 DB
Summary of the content on the page No. 11
The DB2 Everyplace Solution Mid-tier Data Source Server Test DB2 Mobile Everyplace DB2 UDB or De D vB ic2 e Mobile 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 DB2 SQL Compiler Parser, Semantics System Tables: Optimizer, Interpreter DB2eSYSTABLES DB2eSYSCOLUMNS DB2eSYSRELS Data Manager Services Index Manager, Record Manager Buffer Manag
Summary of the content on the page No. 12
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 IND
Summary of the content on the page No. 13
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
Summary of the content on the page No. 14
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 IBM Sync GUI Mobile Devices DB2
Summary of the content on the page No. 15
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
Summary of the content on the page No. 16
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 Metrowerk
Summary of the content on the page No. 17
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 Gui
Summary of the content on the page No. 18
Packaging & Pricing - 7.2.1 Package Components Price Included DB2 Everyplace Database 63 (US) per registered Database Edition user DB2 Everyplace Database 12,608 per server Enterprise Edition Sync Server processor + 94 per registered user DB2 Everyplace Mobile Application Free Download off the Mobile Application Builder Web Builder Preise Staffel A 1 Jahr Maintenance passport advantage Page 35-36
