Building PDA Databases for Wireless and Mobile Development
1st Edition
Published on 31. October 2002
Book
Paperback/Softback
336 pages
978-0-471-21645-2 (ISBN)
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."
* 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."
More details
Edition
1., Auflage
Language
English
Place of publication
New York
United States
Publishing group
John Wiley and Sons Ltd
Target group
College/higher education
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.9 cm
Width: 19 cm
Thickness: 20 mm
Weight
567 gr
ISBN-13
978-0-471-21645-2 (9780471216452)
Schweitzer Classification
Other editions
Additional editions
Robert Laberge | Srdjan Vujosevic
Building PDA Databases for Wireless and Mobile Development
E-Book
11/2004
Wiley
€41.00
Available for download
Persons
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).
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).
Content
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.