 Building PDA Databases for Wireless and Mobile Development
ISBN: 978-0-471-21645-2
Paperback
336 pages
October 2002
US $45.00
 Add to Cart
This price is valid for United States. Change location to view local pricing and availability. |
Instructors may request an evaluation copy for this title.
|
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.
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.
