Skip to main content

Building PDA Databases for Wireless and Mobile Development

Building PDA Databases for Wireless and Mobile Development

Robert Laberge, Srdjan Vujosevic

ISBN: 978-0-471-21645-2

Oct 2002

336 pages

Select type: Paperback

Product not available for purchase

Description

  • Introduces the mobile databases (their architecture and features) and how they operate and handle the essential task of synchronization.
  • Explains how the enterprise work force can move to a handheld device and still have easy access to corporate databases.
  • Web site contains all source code for working examples of applications showing mobile databases in use.
  • Foreword and endorsement by Bill Inmon, the "Father of Data Warehousing."
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.

Companion Site

Visit the Companion Site.