Transcript Expanding The Enterprise To Mobile Devices

Expanding The Enterprise
To Mobile Devices
SQL Server™ 2000
Windows® CE Edition
Kevin Collins
Debra Dove
Program Managers
Microsoft Corporation
8-308
Agenda





Solving problems in mobile environment
Deployment platforms
Example solutions
SSCE expanding the enterprise
Product schedule
Platforms

H/PC – (Jornada 820, NEC Mobile Pro 800)




PocketPC - (Casio E-105, Compaq Aero)



Typically have keyboard
Many have 32mb ROM/RAM
PC Card/USB
No keyboard, low ROM/RAM, no PCCard
Many have 32MB ROM/ROM and CF card support
Embedded – AutoPC, Phone, Set Top
Box, Dreamcast

Varying CPU/RAM/ROM
Extend The Enterprise



Data acquisition in the field
Replace paper
Examples

Package delivery – UPS


Healthcare – Abaton.COM


Hands free delivery tracking
Physician prescriptions
Remote distribution – CSI

Mailroom automation
Data Storage/Access – Today
Inbox
Contacts
eVC 2.0
eVB 2.0
ADO CE v2.0
Replication,
QP
CEDB/PegDB API
Active
Sync
ODBC
Jet
Data Access Q2 00

eVB 3.0
ADO
CE
v3.1
Active
X
Objects
eVC
3.0
eVB/eVC 3.0 separate IDE


ADOCE 3.1

OLEDB CE

SQL Server For CE

QP/Cursor Engine/ES
OLEDB
Storage Engine / Repl
Tracking

Talks to OLEDBCE
ADOX added
OLEDBCE

OLEDB
Improved debugger
Enables OLEDB providers
on device
Capitalizes on Microsoft®
desktop technologies
Architecture




eVC or eVB to develop application
ADOCE 3.1 and/or OLEDBCE to
access SSCE
SSCE is an OLEDB provider
Better than the competition!



Rapid development
Utilize existing data access strategies
Utilize existing staff knowledge
SQL Server 2000
Windows CE Edition!

Upward compatibility with SQL Server



Right footprint size for devices


Same result sets
Compatible data types
~700kb for X86 CPU
OS support

Windows CE 2.11 forward – use today!
SQL Server 2000
Windows CE Edition!

Support all targeted CPUs


P/PC, H/PC, PocketPC
Performance


Better than the competition
Substantially faster than CEDB
Performance Data
SQL Server for CE versus CEDB
6261.32
Time in Seconds
7000
6000
5000
SSCE
4000
CEDB
3000
2000
1000
0
24.244
Create 4 Indexes (smaller is faster)
Jornada 820 SA1100
Performance Data
SQL Server for CE versus CEDB
Time in Seconds
700
615.45
600
543.2
500
400
SSCE
300
CEDB
200
170.28
100
0
19.092
Load 15K
rows
17.804
27.61
113.23
26.888
Seek Update Seek Update Delete 15K
Index
rows
Jornada 820 - smaller is faster
Database Feature Set
Rich functionality for small footprint










Multi-column indexes
Referential integrity
Sub-selects (IN)
Defaults
Inner/outer joins
32 indexes per table
One file database
Null support
Unicode support
Transactions

Data-types







Real, Numeric, NVarChar,
NText, Image, Integer,
DateTime, VarBinary,
UniqueIdentifier, Money
Having/group by
Seek on index
Set functions
Identity attribute
TCO support
Local security - DB
encryption (128bit) and
database password
Data Access Storage Architecture
eVB 3.0
ADO
CE
v3.0
Active
X
Objects
eVC
3.0
OLEDB CE
SQL Server 2000 Windows CE Edition
OLEDB
QP/Cursor Engine/ES
OLEDB
Storage Engine / Repl
Tracking
Client
Agent:
Replication
and
Remote
Data
Access
CLIENT
IIS
HTTP
SERVER
Server
Agent:
Replication
and
Remote
Data
Access
Connectivity - Solving
Today’s Limitations

Three common scenarios




Always connected
Intermittently connected
Rarely connected
Remote connectivity issues

Active sync


Desktop connection required
Limited connectivity options
Connectivity - Solving
Today’s Limitations

Utilize Web technology

HTTP communication


Security via IIS




Internet and Intranet
Authentication (anonymous, basic, NTLM)
Authorization
Encryption for secure transfer (SSL)
Access through firewalls
Connectivity - Solving
Today’s Limitations

Architected for wireless



Compression to reduce transfer time
Recovers from connection failures
Message based communication
reduces round trips
Connectivity - Solving
Today’s Limitations

Connectivity solutions



Exposed via ActiveX® Controls
Replication
Remote data access
Replication - Solving
Today’s Limitations

Common replication scenarios




Replicate, update, synchronize
Data capture and upload
Read only/download
Today’s limitations

Active sync only





Desktop connection required
Desktop tracking database
No support for merge replication
Limited data type support
Limited conflict resolution
Replication - Solving
Today’s Limitations
Central Publisher

Replicate, update,
synchronize


Re-Publishers
Data capture
and upload


Well-connected
Subscribers
Sales force app:
insert new orders
Read only/download

Mobile
Subscribers
Sales force app:
update customer Info
Sales force app:
price lists
Replication

SQL Server 2000 merge replication


Perfect for occasionally connected devices
SQL Server 2000 integration




Compatible merge replication control
Supports data type mapping
Synchronize directly with server
Anonymous pull subscriptions
Replication

SS features crucial for SSCE:




Vertical and horizontal partitioning
Dynamic horizontal filters
Auto ranged identity columns
Standard/custom conflict resolvers
Steps In SSCE Replication







DBA creates SQL publication
Develop and install app
App creates subscription
App updates data
DB tracks changes
App initiates synchronization
Conflicts resolved at publisher
Data Access Storage Architecture
eVB 3.0
ADO
CE
v3.0
Active
X
Objects
eVC
3.0
OLEDB CE
SQL Server 2000 Windows CE Edition
OLEDB
QP/Cursor Engine/ES
OLEDB
Storage Engine / Repl
Tracking
Client
Agent:
Replication
and
Remote
Data
Access
CLIENT
IIS
HTTP
SERVER
Server
Agent:
Replication
and
Remote
Data
Access
Connectivity – Replication
CLIENT
Appl
SSCE
Client
Agent
SSCE
DB
SERVER
SQL Server
Reconciler
SSCE
I
I Server
S Agent
SQL Server
Replication
Provider
SSCE
Replication
Provider
.IN
.OUT
SQL
DB
Demo
Remote Data Access





Eliminate desktop for connectivity
Access to SQL Server 6.5 +
Download to device and disconnect
Disconnected tracking capability
Extremely easy to setup and use
Remote Data
Access - Methods

Pull





Push


Brings data from server to device
Data selected via SQL statement
Creates and populates local table
Allows for tracked and untracked data
Sends modified data to server
Submit SQL

Pass SQL DML statement
Demo
High Level Schedule

SSCE Alpha 1:
SSCE Beta:
SSCE RTW:

Not tied to SQL Server 2000


Q1 00
Q2 00
Q3 00
SSCE Summary

Enables data capture in the field


Enables rapid development


Utilizes existing Microsoft technologies
Enable robust connectivity



Small size, robust functionality
HTTP, IIS, connect anywhere
RDA, Replication
Expand the enterprise

Upwardly compatible with SS
What Would We Like
From You?



Sign up for the Beta NOW!
Send e-mail to
[email protected]
Need to talk to us about features?


[email protected]
[email protected]
Questions?