IBM 7.2.1 Manual do Utilizador Página 1

DB2 Everyplace V7.2.1 -Mobile and Embedded Databaseand Synchronization ArchitectureJoachim StumpfDB2 Technical sales supportAgendaIntroductionReferenc

System Monitoring/Embedded: X-SerwisSolution based on DB2 Everyplace running on embedded x86hardware and QNX NeutrinoX-Serwis created a Weather report

The DB2 Everyplace Solutionmove toproductionMobileApplicationBuilderDB2Everyplace(Database engine)DevelopTestDB2EveryplaceSyncServerDB2 UDB orJDBC orc

DB2 Everyplace CharacteristicsRDBMS especially made for mobile devices and embedded systemsAPI'sDB2 Call Level Interface (CLI) / ODBC subsetA set

DB2 Everyplace CharacteristicsCREATE TABLEwith following datatypesINTEGER |SMALLINTDECIMAL (Big)CHARACTER(Smallint)VARCHAR(Smallint)BLOB(Smallint)DATE

DB2 Everyplace FunctionsFunctions supportedAVG(expression)SUM(expression)MIN(expression)MAX(expression)COUNT(expression)CONCAT(expression,expression)M

Mobile device administration centerMDAC is the tool to define all these object propertiesDB2 Everyplace Mobile applicationbuilderEnablesrapid applicat

Robust Development environmentProgramming interfaces supportedDB2 Call Level Interface (CLI) / ODBC subsetJava DataBase Connectivity (JDBC) driver for

References/resourcesDB2 Everyplace websitehttp://www.ibm.com/software/data/db2/everyplacedeveloper forumhttp://www.developer.ibm.comredbooks (http://w

Package ComponentsIncludedPriceDB2 EveryplaceDatabase EditionDatabase 63 (US) per registereduserDB2 EveryplaceEnterprise EditionDatabaseSync Server12,

DeviceCompanyIBM Mobile solutions-- technical overviewApplicationMessageMessageApplicationDataWebsphere MQ EveryplaceDB2 EveryplaceLotus Domino Everyp

OS/2 and AIX platformLow-end OLTPMultiple platformsCapacity and performanceJDBCUDTs, UDFs, LOBsSMP and MPP parallelismData Links ManagerSQLJInitial OL

Mobile orOccasionallyConnectedSatellite SystemStep1ReplicationControlInformationCorporateSystemsReplicationdataStep3Help deskqueries &commandsHelp

DB2 Everyplace __ WHY??increase employee productivityimprove business operations with up to date informationField force automation, insurance, healthc

Business applicationsBusiness to Employee ProductivityField Force AutomationCustomer and product informationBarcode and part information from scanning

ISVs and partnersDB2 Everyplace and Pervasive Computing efforts in DM followthe overall DM ISV strategy.Current partners:- Siebel 7 Sales Handheld for

Healthcare: AsatteHealthcare - Mobile Patient Record Management System used inclinicsPatient Info is downloaded each a.m; updated and supplementedeach

Sales Force Automation Application tied in with retail store point ofsale and Lawson accounting systemDB2E database DB2E sync server DB2 UDBon WinCE/