DB2 Everyplace V7.2.1

DB2 Everyplace V7.2.1 Mobile and Embedded Databaseand Synchronization ArchitectureJoachim StumpfDB2 Technical sales supportAgendaIntroductionReference scenariosComponentsDatabase functions and featuresSync architectureAdministrationApplication developmentInformation sourcesPage 1-2

IBM Mobile solutions-- technical overviewBrowserApplicationDataWebsphere onWebsphere MQ EveryplaceDataCompanyDataDataApplicationDB2 EveryplaceLotus Domino EveryplaceDB2 PE/WE Satellite functionalityThings to think about.Why a relational database versus a flat fileAPI'seasier application developmentReplication of data with backend sourcesrelational capabilitiesPage 3-4

DB2 EvolutionUniversal AccessUniversal ApplicationUniversal ExtensibilityUniversal ScalabilityUniversal ReliabilityUniversal Management7.27625Integrated WarehousingIntegrated OLAPFederated databasesNative OLE DB clientXML extenderSpatial extenderAbstract Data TypesSQL stored proceduresDB2 Everyplace new plattformsHigh Availability enhancementsLINUX coverage and scalabilityVery large memory exploitationWebSphere integrationRelational Connect ImprovementsImproved migration paths fromOracle, SQL Server, and InformixWarehouse and ContentManagement improvementsDB2 for LinuxDB2 Satellite EditionEase of useEase of application developmentPerformanceSMP and MPP parallelismData Links ManagerSQLJInitial OLAP SQLMultiple platformsCapacity and performanceJDBCUDTs, UDFs, LOBsOS/2 and AIX platformLow-end OLTPHostsDB2 UDB forOS/390DB2 for VSE & VMDB2 UDB forAS/400IBM DB2 Family DB2 Palm OSWinCE/PocketPCEPOC R5Symbian OS 6QNX Neutrinoembedded LinuxLinuxWin 32 (9x, NT,2000) Universal AccessUniversal ApplicationUniversal ExtensibilityUniversal ScalabilityUniversal ReliabilityUniversal ManagementDB2 ConnectEnterpriseWorkgrouplliteetSaPersonalOS/2Win 95, XOS/2, WinNT/2000AIX, HP-UX,SolarisLinux, NUMA-QEnterprise ExtendedAIXLinuxWinNT/2000SolarisHP-UXNUMA-QPage 5-6

DB2 Satellite scenarioHelpDesk CorporateSystems Help deskqueries &commandsStep3Replicationdata DB2 nMobile orOccasionallyConnectedSatellite System DB2ControlCenterSatelliteAdministrationCenter SatelliteControlDBTest andModelSatelliteSystemStep1IBM Pervasive Computing VisionAny Content,Application,ServicesAnyDeviceAnyNetwork N otes MailC alendarD irec toryWirelesse-mail, PIMNews, Weather, SportsWiredBanking, Stock Trading,Travel, Retail, Healthcare,Public SectorCRM, SFA, ERP, SCMNavigation, Fleet ManagementMusic, Video, GameThe natural extension ofe-businessPage 7-8

DB2 Everyplace WHY?increase employee productivityincrease customer satisfactionimprove business operations with up to date informationField force automation, insurance, healthcare, retail,financial servicesDB2 Everyplace Sync connection optionsinfrared or cable to cellphonewireless lan integrated cellularserial cable, cradle, or infrared to pc Internetor other NetworkSync Servermodem to POTS lineDataSourcesPage 9-10

Business applicationsBusiness to Employee ProductivityField Force AutomationCustomer and product informationBarcode and part information from scanningdevicesInsurance policy informationAuditing information for quality and safetyapplicationsMonitoring of system informationBusiness applicationsIndustries - Customer Relationship ManagementInsurance - policy information, pricing informationHealthcare - Nurses, healthcare professionalsEducation - student information for teachersDistribution - inventory trackingTelecommunications - auditing of telecommunicationssitesFinance - mobile bankingGovernment - Social Services, Policy enforcementRetail - point-of-sale automation for retail chains, kiosksPage 11-12

ISVs and partnersDB2 Everyplace and Pervasive Computing efforts in DM followthe 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 forPeopleSoft’s mobile applications. With a small footprint and its robustfunctionality, DB2 Everyplace provides a foundation for functionally rich mobileapplications that can be quickly deployed to the end user."“Leveraging DB2 Everyplace as the local data store device with PeopleSoft’spure internet data sync technology will enable mobile professionals to accessand sync data at their convenience,” said Janet Perna, general manager ofIBM Data Management Solutions. “The combination of DB2 Everyplace andPeopleSoft’s new mobile technology will empower PeopleSoft 8 customers withreal-time information in mobile nect/1pla 4.htmlField Force Automation: Gas de FranceIBM Global Services and Gas de France created a mobilegas meter reader applicationDeployed to 700 field engineers using Palm OS devices tomonitor customer gas metersUses the DB2 Everyplace Sync Server to synchronize withexisting DB2 infrastructureIntegrated with their Tivoli management environmentPage 13-14

Healthcare: AsatteHealthcare - Mobile Patient Record Management System used inclinicsPatient Info is downloaded each a.m; updated and supplementedeach day; uploaded to main database each p.m.benefits of reduced input errors, saves staff time entering doctorinformationInformation is generic (weight, bp, etc)and then customized per clinicalspeciality allowing for data collectionand compilationleads to best practiceshelps in study participationAsset Tracking: Essential SystemsAsset Tracking ApplicationDB2E databaseUDB on PalmDB2E sync serveron LinuxDB2on Linux1. Worker A takes tool.2. Worker B scans bar code of tool & worker.3. Information reconciled with corporateaccounting, inventory and employeesystemsBenefits:Tools and Tool status trackedTool use can now be billed per jobPage 15-16

Retail/Sales Force Automation: NetSetGoSales Force Automation Application tied in with retail store point ofsale and Lawson accounting systemDB2E databaseon WinCE/Compaq IPAQDB2E sync serveron WinNT"seconds"1. Salesperson takes order and verifiesPDA;item in stock;76,000 SKUs to choose from.DB2 UDBon AS/400"less than a minute"2. Order forwarded fromimmediate fulfillmentBenefits: Fewer errors, Faster delivery, SalesproductivityRetail/Easy of Use: Penn StatePenn State Center for Advanced Information TechnologyUsed DB2 Everyplace in second year college class students created a 'store' that can be accessed from a Palmdevice to order or check order statusUse DB2 Everyplace on Palm OS; Sync Server on NT"We were amazed that DB2 Everyplace was a full functiondatabase, yet had a small footprint and ran on an handhelddevice.And the Mobile Appplication Builder was fantastic led students through a point and click programming processand automatically created the C code for the Palm."Page 17-18

System Monitoring/Embedded: X-SerwisSolution based on DB2 Everyplace running on embedded x86hardware and QNX NeutrinoX-Serwis created a Weather reporting system based onEuropean Union standards.Required robustness and reliability for continous operation inremote locations.Benefit100% ROI in one yearannual savings of US 1.5 million in road maintenance costsmore cost-effective road maintenance resulting from accurateevaluation of icy road conditionsimproved driving safety“Using IBM DB2 Everyplace databases in 12 remote weathermonitoring stations around the city, the Warsaw Road Maintenanceauthority knows just where to send crews to clear the roads of ice andsnow, and can act quickly.”Jaroslaw LuczakManaging Director,X-SerwisDB2 EveryplaceDB2 Everyplace is a small footprint relational database andsynchronization server for mobile computing and embedded devices.Component NameDescriptionDB2 EveryplaceDatabaseDatabase EngineStores and processes data on mobile andembedded devicesDB2 EveryplaceSync ServerSynchronization ServerSynchronizes data between devices andenterprise data sourcesDB2 EveryplaceMobile Application BuilderApplication Development ToolAllows rapid application development for PalmOS platformPage 19-20

The DB2 Everyplace ta SourceDB2 UDB orJDBC orcustom datasourcesDB2Everyplace(Database engine)Developmove toproductionDB2 Everyplace ArchitectureApplication Programming InterfaceCLI/ODBCJDBCSQL CompilerParser, SemanticsOptimizer, InterpreterDB2System Tables:DB2eSYSTABLESDB2eSYSCOLUMNSDB2eSYSRELSData Manager ServicesIndex Manager, Record ManagerBuffer ManagerDB2User TablesOperating System ServicesPage 21-22

DB2 Everyplace CharacteristicsRDBMS especially made for mobile devices and embedded systemsAPI'sDB2 Call Level Interface (CLI) / ODBC subsetA set of C/C function can be called in programs to access the databaseJDBC and Java application supportDBCS (double byte character set) and NLV supportEncryption (communication) IBM Microdrive and Compact Flash Memory supportDB2 Everyplace SQLSupports a subset of SQLCALL procedureCREATE INDEX (asc/desc) bidirectionalCREATE TABLEDROP TABLE/INDEX !" # "%" &' () !#*"' * ' ') #* ,-' ()EXPLAININSERT with subselects and default valuesDELETEUPDATE (records)SELECT (records) withJOIN ( up to 8 tables)GROUP BYORDER BY (asc/desc)LIMIT (integer) for result set.IN predicatescrollable cursors/01234/50/231650788643Page 23-24

DB2 Everyplace CharacteristicsCREATE TABLEwith following datatypesINTEGERSMALLINTDECIMAL (Big) DATETIMETIMESTAMPand optionsPRIMARY KEY with more than one columnreferential constraintsCHECK constraintsCREATE TABLEcreate table ORDERS(CUSTNO CHAR(6)NOT NULL,ENTRY TIMESTAMP NOT NULL DEFAULT Current Timestamp,ITEMPRICECHAR(15) ,DECIMAL(9,2),Check (Price 100),PRIMARY KEY (CUSTNO,ENTRY))Page 25-26

DB2 Everyplace FunctionsFunctions ion)MAX n)RTRIM(expression)expression can bea literal like *column name , function , special registerSync Server Design Overview PIM adapterAdapter TransportAPIAPIDevicesPalm OS,Win CE,Win32,Pocket PCEPOC, SymbianOSNeutrino, embedded LinuxMobile DevicesAdministration Center ApplicationServerJava servletIBM Sync GUISyncEngine DB2 adapterHTTPAPISyncFile adapterSyncMLEngine WAPAgent adapterBluetooth DB2Family DProp adapter SyncMLSynchronizer Agent adapterusingWBXMLJDBC adapter AdapterAPISynchronizationServerWindows sNB: DB2 UDB is a pre-req forSync Server and is delivered asworkgroup editionPage 27-28

Mobile device administration centerMDAC is the tool to define all these object propertiesDB2 Everyplace Mobile applicationbuilderEnables rapid application prototyping and development on Palm OS withoutwriting a single line of code.Includes DB2 Everyplace sample applications (source code & project file)Page 29-30

Robust Development environmentProgramming interfaces supportedDB2 Call Level Interface (CLI) / ODBC subsetJava DataBase Connectivity (JDBC) driver for Java applicationsVisual Basic Interface for Win32,WinCE/PocketPC applicationdevelopmentIncluded Developer toolsDatabase Import and Export utilitiesCommand Line Processor for all platformsSample applications with full source C/C codeMobile Application Builder for Palm OS available free from websiteCommercial Development toolsMetrowerks CodeWarrior - http://www.metrowerks.com/platforms/Supports Palm OS, JAVA and QNX NeutrinoMicrosoft Visual Studio - http://msdn.microsoft.com/cetools/Supports Windows Embedded Visual Tools 3.0Visual Age MicroEdition from OTI - http://www.embedded.oti.comSupports JAVA on Palm OS, QNX Neutrino, and embedded LinuxRobust Development environmentCommercial Development tools (cont'd)Software Development KitsPalm OS SDKEPOC R5, Symbian 6Lineo Embedix SDK (embedded Linux)Lynuxworks Lynux SDK (embedded Linux)QNX Neutrino 2.0 SDKPage 31-32

References/resourcesDB2 Everyplace lacedeveloper forumhttp://www.developer.ibm.comredbooks (http://www.redbooks.ibm.com)SG24-6217-00 IBM Replication Solutions for Pervasive ComputingDB2 magazinehttp://www.db2mag.com/db area/archives/2001/q4/zikopoulos.shtmlDB2 Everyplace db2everyplace@yahoogroups.comTo subscribe go entationInstallation and User Guide manualApplication Development Guide manualSync server administration guideSchulungKurs 'CG20EDE' http://www.ibm.com/de/learning/The EndPage 33-34