Title: Presentation to the
1Presentation to the North Central Oracle
Applications Users Group February 13th, 2002
2Managing Databases In a Wireless World
Presentation by Ari Kaplan CEO and Co-Founder
Expand Beyond Corporation www.XB.com
3Agenda
Introduction A DBAs life Handheld
Overview Todays Business Environment Wireless
Technology Options Wireless Architecture Wire
less Benefits Wireless and Database
Resources Conclusion
4Introduction to Ari Kaplan
5Introduction to Ari Kaplan
6Introduction to Ari Kaplan
7A DBAs Life
Traits of a DBA Tenacity Self
starter Detail oriented Curiosity Self
confidence
8A DBAs Life
- 100,000 Oracle DBAs in United States
- More than one million professionals (DBAs,
developers, etc.) worldwide - Oracle global installed base 200,000 companies,
more than 1 million databases - Oracle revenue 10.8 billion in 2001, 10.0
billion 2000
9A DBAs Life
DBA workload demands are increasing
According to the Meta Group, the average DBA
works more than 50 hours, including six hours on
the weekends
10A DBAs Life
11A DBAs Life
- Difficult environment for workers
- Dawn of the IT sweatshop says the Meta Group
- Long hours
- High burnout rate / job hopping (most last yrs)
12Handheld Overview
Who are these Business Executives?
Michael D. Capellas Ben
Waldman Eric Benhamou Kouji Ohboshi
Chairman and CEO VP Mobile Devices
Chairman of the Board, President
Compaq Computer Corp. Division, Microsoft
CEO (Interim) Palm, Inc.
NTT DoCoMo
13Handheld Overview
How many of you have handhelds? How many of you
have wireless handhelds? How many of your
companies bought the handhelds for you?
14Handheld Overview
Handheld Sales 2001, 13.5 million PDAs were
sold, increasing more than 30 annually By
2004, everyone from executives to
hairdressers will buy some 33 million PDAs
15Handheld Overview
Evolution Once clunky, overpriced Only stored
phone numbers and addresses Rebirth as sleek
wireless accessories PDA is now cell phone,
electronic wallet and personal entertainment
system all rolled up in one
16Handheld Overview
Evolution Movement to enterprise sales, where
corporations order thousands of devices PDAs
given to workers like a tool, much like
a training manual
17Handheld Overview
Number as of Q201
32
26
Palm Compaq
All Others Hi Tech Wealth RIM HP Handspring
4
4
7
16
11
18Mobilizing Who?Selecting Employees
Top 5 Types of Employees Provided with Handhelds
N 1154
19Number of Handhelds Supported in Organizations
of Respondents Companies
20Handheld Overview
Microsoft PocketPC 2002 launched October 4th with
support from 22 hardware vendors including Compaq
(iPAQ) and HP (Jornada).
hp Jornada 449 to 599All color, MP3 Player
Compaq iPAQ 499 to 649All color
Hp Jornada 560 Series
Hp Jornada 540 Series
PocketPC H3700 Series
PocketPC H3800 Series
21Handheld Overview
Samsung Smartphone SPH I300 Mobile phone,
color, Web clipping, speaker phone. Palm
OS 500.00 plus monthly service. The PDA that is
also a cell phone.
Sony CLIE PEG N760C Palm OS, MP3 Player,
Color, Hi Res Screen, Remote Control Headphones,
Memory Stick Media Slot 499.99 Wireless
connectivity available with new Mylo service.
22Handheld Overview
Handspring has two new PDA/mobile phones hitting
the marketing in 2002. Handspring Treo 180 and
Treo 270 Palm OS 399 and 599, respectively
23Todays Business Environment
- 88 of the Global 3500 have plans to implement
mobile data solutions (Forrester) - 802.11b (Wi-Fi) is the single greatest advance
in 2001 (48 of InfoWorlds CTO Source survey) - Wireless PDAs will be the key corporate device
for 2002. IT workers are second only to corporate
executives in their likelihood to receive a
corporate-issued handheld device in 2002. (IDC
Oct 2001) - Global wireless enterprise spending will be
more than 28B with 39.4M connected workers by
2006 (Ovum)
24Todays Business Environment
Need for monitoring, managing, and development
of databases wirelessly Huge business
inefficiencies Staff currently must conduct
work on fixed-line computers Lost business
when staff is not onsite Businesses are always
open all day, all night, across time zone
25Todays Business Environment
Six Costly Database Challenges
26Todays Business Environment
Six Costly Database Challenges Summary DBA 24
x 7 Access DBA Response Time DBA
Productivity DBA Retention DBA Replacement
Database Availability
27Todays Business Environment
1. The Challenge of DBA Remote Access Businesse
s are always open Need for continual
monitoring, managing development of databases
But. . .DBAs are restricted by the wired
technology of the last century
28Todays Business Environment
1. The Challenge of DBA Remote Access DBAs are
often unavailable to dial in during Commutes
Trade Shows Training Lunch Little
League Games Traffic
29Todays Business Environment
1. The Challenge of DBA Remote Access DBAs are
often unavailable to dial in during Brownouts
Weather Illness Vacations Recitals
Personal Life Meetings
30Todays Business Environment
2. The Challenge of DBA Response Time The need
for quick DBA responses are increasing User
expectations Customer demands Competitive
pressures Management requirements Service
level agreements Mission-critical
systems High availability needs
31Todays Business Environment
3. DBA productivity 4. DBA retention
32Todays Business Environment
5. The Challenge of DBA Replacement DBAs are
costly to replace Average cost to hire one
person in I.T. 25,000 to 35,000 Does not
include Salary Cost to bring candidates
in Lost unbilled hours of time spent in
process. CEO of I.T.
Recruitment Firm
33Todays Business Environment
6. Database Availability Unscheduled Downtime is
Costly Average Cost per Minute of Application
Downtime at Peak Load Data Warehouse 6300 SCM
6600 eCommerce 7800 ERP 7900 Standish
Group International Inc., 1999
34Wireless Architecture Web Clipping
35Wireless Architecture - DMZ
36Wireless ArchitectureSecurity
- Should incorporate or support
- Automatic session timeout
- No proprietary data or passwords reside on PDA
- Elliptical curve encryption SSL (HTTPS
128-bit Secure Socket Layer) - Server-side audit logging
37Wireless ArchitectureSecurity
Should incorporate or support Mandatory
password authentication Oracle roles to limit
access to specific users or areas of
database Read-only permission
option Encryption maintained on proxy
server no data caching
38Wireless Benefits
- IT Departments
- Speed up remote access and emergency troubleshoot
ing - Increase productivity by enabling more
proactive monitoring - Decrease costs by decreasing unplanned downtime
- Mobile Workforce
- Immediate access to data retrieval
- Immediate data entry availability
39Wireless Benefits
Provide inexpensive 24x7 insurance against
DBA or system administrator unavailability Red
uce staff turnover by improving job
satisfaction Gain fuller control over
mission-critical systems
40Major Wireless Standards
802.11 Allows for wireless connectivity over
LANs 802.11 is an extension of Ethernet to
wireless communication The client requires
hardwareusually a PC Card or PCI card
41Major Wireless Standards
Bluetooth Short-range radio link designed to
replace the cables connecting portable and/or
fixed electronic devices Not a wireless
network per se Operates via a radio unit
42Major Wireless Standards
WAP Would like to be the de facto standard for
providing internet communications and advanced
telephony services on mobile phones and pagers.
WAP has NOT been widely adopted.
43Wireless Transmission Speed/Rate
- 2.5G and 3G are being deployed in major markets
across the U.S. Dont expect 3G wireless to be
available in all of the primary U.S. markets
until mid-2003! - To users, 2.5G and 3G will mean a 4-fold increase
in transmission speed and a larger pipeline to
transmit security encryption and data
simultaneously.
44Wireless and database resources
Oracle Discussion Newsgroups comp.databases.oracl
e.server comp.databases.oracle.tools comp.database
s.oracle.misc These can be accessed through a
newsgroupprogram or www.deja.com
45Wireless and database resources
Other good Oracle sites with links
www.arikaplan.com 400 tips this
presentation www.ioug.org www.orafaq.org www.orafa
ns.com www.orasearch.com www.revealnet.com www.laz
ydba.com www.dbdomain.com
46Wireless and database resources
Wireless News www.wirelessweek.com www.mobileins
ights.com www.mobileinfo.com www.pdabuzz.com www.p
lanetit.com Wireless Development www.wirelessdevn
et.com www.wapforum.org www.80211-planet.com
47Wireless and database resources
Handheld Discussion Newsgroups comp.sys.handhelds
.palmpilot comp.sys.palmtops comp.handheld These
can be accessed through a newsgroupprogram or
www.deja.com
48PocketDBA / PocketAdmin
49Questions and Answers