Building PDA Databases for Wireless and Mobile Development

Скачать в pdf «Building PDA Databases for Wireless and Mobile Development»




©WILEY


Timely, practical, reliable.

Building PDA Databases for


Wireless and Mobile Development


IntroductionAn Introduction to Wireless and Mobile Applications……………………………………………………..4


About This Book;……………………………………………………………………………………………………………………5


Is This Book for You?…………………………………………………………………………………………………………….6


Covered Material……………………………………………………………………………………………………………………6


Chapter 1: Introduction to PDAs………………………………………………………………………………………………………8


The Basics;…………………………………………………………………………………………………………………………….8


Portable Wireless Evolution…………………………………………………………………………………………………….9


What Is WAP?…………………………………………………………………………………………………………………9


WAP Evolution………………………………………………………………………………………………………………..9


PDA Evolution……………………………………………………………………………………………………………….11


PDA Environment;………………………………………………………………………………………………………………..12


Devices………………………………………………………………………………………………………………………….12


Connectivity…………………………………………………………………………………………………………………..14


Final Thoughts……………………………………………………………………………………………………………………..17


The Relational Database and Its Components…………………………………………………………………………..17


Tables……………………………………………………………………………………………………………………………18


Primary Keys;…………………………………………………………………………………………………………………19


Indexes………………………………………………………………………………………………………………………….20


Referential Integrity (Foreign Keys)………………………………………………………………………………….21


Joins……………………………………………………………………………………………………………………………..22


Cursors………………………………………………………………………………………………………………………….23


SQL………………………………………………………………………………………………………………………………23


Security;…………………………………………………………………………………………………………………………24


Database Administration……………………………………………………………………………………………………….25


Backups…………………………………………………………………………………………………………………………26


PDA Database Considerations………………………………………………………………………………………….26


Final Thoughts……………………………………………………………………………………………………………………..27


Chapter 3: Client-Server Architecture……………………………………………………………………………………………28


Client-Server History;…………………………………………………………………………………………………………..28


What Is Client-Server?…………………………………………………………………………………………………………29


Fat versus Thin…………………………………………………………………………………………………………………….31


Tiers……………………………………………………………………………………………………………………………………32


Front End…………………………………………………………………………………………………………………………….34


Security……………………………………………………………………………………………………………………………….35


PDA Units;…………………………………………………………………………………………………………………………..35


Final Thoughts……………………………………………………………………………………………………………………..36


Chapter 4: Data Warehousing…………………………………………………………………………………………………………37


What Is a Data Warehouse?……………………………………………………………………………………………………37


Granularity;…………………………………………………………………………………………………………………….38


Organized Structures……………………………………………………………………………………………………….38


Architecture…………………………………………………………………………………………………………………………39


Source……………………………………………………………………………………………………………………………39


ETL………………………………………………………………………………………………………………………………40


Repository……………………………………………………………………………………………………………………..40


Data Marts……………………………………………………………………………………………………………………..41


Chapter 4: Data Warehousing


PDA Data Warehousing………………………………………………………………………………………………………..42


Data Stores…………………………………………………………………………………………………………………….42


PDA Source;…………………………………………………………………………………………………………………..43


PDA Empowerment;……………………………………………………………………………………………………………..44


Final Thoughts……………………………………………………………………………………………………………………..44


Chapter 5: Palm……………………………………………………………………………………………………………………………..45


Overview;…………………………………………………………………………………………………………………………….45


History………………………………………………………………………………………………………………………………..45


Overview;…………………………………………………………………………………………………………………………….47


Physical Units………………………………………………………………………………………………………………………49


Devices………………………………………………………………………………………………………………………….49


Cradles………………………………………………………………………………………………………………………….49


M500 Unit Specs…………………………………………………………………………………………………………….49


Graffiti………………………………………………………………………………………………………………………………..51


Palm Desktop……………………………………………………………………………………………………………………….53


HotSync………………………………………………………………………………………………………………………………56


Beaming………………………………………………………………………………………………………………………………58


Palm Emulator……………………………………………………………………………………………………………………..58


Final Thoughts……………………………………………………………………………………………………………………..60


Chapter 6: Pocket PC……………………………………………………………………………………………………………………..61


Overview;…………………………………………………………………………………………………………………………….61


Physical Units………………………………………………………………………………………………………………………62


Device Comparison…………………………………………………………………………………………………………65


Special Units………………………………………………………………………………………………………………….65


Compaq iPAQ H3870 Unit Specs……………………………………………………………………………………..65


Software………………………………………………………………………………………………………………………………67

Скачать в pdf «Building PDA Databases for Wireless and Mobile Development»