Mobile Databases for Health InformaticsWeb Conference 2003.ppt

Mobile Databases for Health InformaticsWeb Conference 2003 Dr. Stanley G. Aungst Assistant Professor of IST, Penn State University Karen E. Fleagle Senior, School of IST, Penn State University Mobile Database Management System IBM’s DB2 Everyplace An Introduction to DB2e Basic Components Environments Security Handheld Form Factors Palm OS Emulator (POSE) Palm m500 Future Form Factors (Palm Tungsten, Smartphones, etc.) Practical Applications for DB2e Virtual Coconuts Project Hershey Medical Center - Pain Management Database Project Pennsylvania Governor’s School for Information Technology Acknowledgements – Steve Kellogg and the AIT Group An IntroductionIBM’s DB2e DB2e stores, retrieves, organizes and manages data on a handheld device The data on the handheld device is synchronized to a server-based relational database management system (RDMS) DB2e is currently available for Palm OS, EPOC, Neutrino, Windows CE and embedded Linux An IntroductionIBM’s DB2e Limitations of today’s small form factor technology System memory Power consumption Processor speed DB2e accommodates for this limitations DB2e is a “thumbprint” DBMS ( ~ 180k ) Sync small amounts of data to server database DB2e was first introduced in August 1999 Could be downloaded from IBM’s website in 1999 (version 7.0) Presently, must join Advanced Developers Group of IBM Silicon Valley Initially only available on Palm OS and Windows CE Current version: 8.1.1 Basic ComponentsIBM’s DB2e DB2e on the handheld device Database Engine IBM Sync Query By Example (QBE) Synchronization Server Allows synchronization between DB2e and server database Mobile Device Administration Center (MDAC) Table encryption for version 8.1.1 J2 MicroEdition (J2ME) Sync Client for cell phones and pagers Mobile Application Builder (MAB) CASE Tool Creates custom applications for the handheld device DB2 Universal Database (UDB2) Server database EnvironmentsIBM’s DB2e Two-tie