Building PDA Databases for Wireless and Mobile Development

ROBERT LABERGE is cofounder and President of WaveDev.com, a wireless Internet WAP-based portal. Laberge has twenty-one years of experience in IT as a database administrator, data warehouse architect/administrator, systems integrator, and wireless application developer. In addition, Laberge is a frequent contributor to technical publications on the subjects of wireless and database technologies. He is also the lead author of WAP Integration: Professional Developer's Guide (Wiley). SRDJAN VUJOSEVIC is Senior Systems Architect with Toronto-based BDP Business Data Services. In addition, he is cofounder of WaveDev.com and designed the code and implementation for the WAP portal. Vujosevic has seventeen years of experience as an engineer, database administrator, programmer, and application developer. Vujosevic is coauthor of WAP Integration: Professional Developer's Guide (Wiley).

About the Authors. Introduction. Chapter 1. Introduction to PDAs. The Basics. Portable Wireless Evolution. What Is WAP? WAP Evolution. PDA Evolution. PDA Environment. Devices. Connectivity. Final Thoughts. Chapter 2. Database Architecture. Database Basics. The Relational Database and Its Components. Tables. Primary Keys. Indexes. Referential Integrity (Foreign Keys). Joins. Cursors. SQL. Security. Database Administration. Backups. PDA Database Considerations. Final Thoughts. Chapter 3. Client-Server Architecture. Client-Server History. What Is Client-Server? Fat versus Thin. Tiers. Front End. Security. PDA Units. Final Thoughts. Chapter 4. Data Warehousing. What Is a Data Warehouse? Granularity. Organized Structures. Architecture. Source. ETL. Repository. Data Marts. PDA Data Warehousing. Data Stores. PDA Source. PDA Empowerment. Final Thoughts. Chapter 5. Palm. History. Overview. Physical Units. Devices. Cradles. M500 Unit Specs. Graffiti. Palm Desktop. HotSync. Beaming. Palm Emulator. Final Thoughts. Chapter 6. Pocket PC. Overview. Physical Units. Device Comparison. Special Units. Compaq iPAQ H3870 Unit Specs. Software. Microsoft ActiveSync. Beaming. Final Thoughts. Chapter 7. Mobile Application Development Tools. Microsoft eMbedded Visual Basic. AppForge 2.1.1. IBM Everyplace Mobile Application Builder 7.2.1. CASL IDE. PenRight! MobileBuilder. DBArtisan. Final Thoughts. Chapter 8. Palm's Database. PDB Example: Fugitive Application. PDB Database Components. AppForge 2.1 Setup and Installation. PDB Example: Fugitive Application. Final Thoughts. Chapter 9. Microsoft. SQL Server 2000 CE Edition. Installing Windows SQL 2000 CE Edition. File Locations. Development System. Internet Information Services System. ActiveSync System. Windows CE Device. Replication. Sample Application-Surveys. Create the Survey Database. Replication Setup. Creating the Survey Application. Final Thoughts. Chapter 10. Sybase. Overview. SQL Anywhere Studio. Relational Database Components. Data Synchronization and Replication. Database Administration Tools. Embedded Database Architecture. Client-Server Architecture. Adaptive Server Anywhere. Overview. DBMS Specifics. UltraLite. Overview. UltraLite Architecture. UltraLite Features. MobiLink. Overview. Consolidated Database. Central Database Subset. MobiLink Synchronization Server. MobiLink Synchronization Process. Mobile Synchronization System. MobiLink Quick Start. Vineyards Application. Flow Chart. ASA Database and Tables. AppForge Conduit. The Application. Final Thoughts. Chapter 11: IBM. Overview. System Tables. Limitations. Installation on the Windows Workstation. Installation on Mobile Device. Development Tools. Airplane Tester Application. Create Testers Tables. Main Application. Data Synchronization and Replication. Final Thoughts. Appendix A: Palm Conduits. Appendix B: Microsoft Publication Wizard Script. Appendix C: DB2 CLI/ODBC Functions. Appendix D: Sybase Glossary. Acronyms. Index.