Embeddable Database Products

1
Embeddable Database Products

• Mike Olson
• Vice President, Embedded Technologies

2
Oracles Embeddable Databases
Oracles Embeddable Databases span the full range
of customers needs
Mobile Devices Telematics Field Force
Automation Distributed Asset Management
Gateways / Routers Storage Systems
Mgmt Security / Authentication Mobile Services
Software Appliances
Telecom OSS/BSS Core Networking
Systems Securities Trading Call Centers /
CRM Reservations
Healthcare Equipment Industrial
Systems Manufacturing Systems Telco Softswitches
Mobile Applications
Edge Applications
Data CenterApplications
3
Example Deployed Applications

Many Order matching for several large brokerages User personalization for a large SaaS CRM company Prepaid billing for large European mobile operator Authentication and personalization for a large Web property Caching for a large eCommerce Website PDA for truck drivers to capture replenishment information for beverage machines Mobile auditing and sales for large workers compensation insurance carrier PDA for mobile healthcare workers
Manufacturing software system Warehouse management system PLM software Telco softswitches for several major vendors Security and network management Real-time billing/mediation (CDR) for mobile operators and major billing vendors IMS/VoIP/IP PBX systems for several large vendors HLR, VLR, MSC, HSS for major mobile network vendors QoS management system for a major networking vendor Messaging systems (email, MMS, SMS, IM, UM) for several leading vendors Provisioning system for a major broadband vendor Directory storage services for several LDAP vendors Event capture and rules management for a BAM vendor Field service application Medical reference/best practices application Field sales application
Medical imaging systems X-ray security equipment Video-on-Demand systems Document management systems (Printers) Distributed data management product for defense industry Media controller for a North American NEM Configuration and state information for several vendors of routers and gateways Storage systems for several major storage vendors Configuration, rules and event capture for several security appliance vendors Mobile handset for a large Japanese carrier Fleet management sensor data store Cargo tracking sensor data store Point-of-sale devices
Enterprise
ISV
OEM
4
Example Customers


5
ltInsert Picture Heregt
Oracle TimesTen
6
Oracle TimesTen In-Memory DatabaseApplication-tie
r data management for performance-critical
systems When milliseconds matter.
A new database for the application tier,
optimized for blazing-fast response and real-time
caching of Oracle data
7
Oracle TimesTen In-Memory Database

• Key Takeaways
• Everything runs in-memory on the same platform
  - very efficiently
• The data is safe! Local disks are used for
  persistence and recovery
• This is a full read/write, transactional RDBMS
  for shared, multi-user access
• Offers for replication for load balancing,
  fault tolerance and high availability
• All APIs are based on well-known industry
  standards

8
Cache Connect to OracleUsing Oracle TimesTen to
Cache Oracle Data

• Key Takeaways
• Pre-load or load-on-demand the most active data
  from Oracle
• Synchronizes updates in both directions
• Transparent SQL pass-through for non-cached
  data requests
• Works with replication to protect
  application-tier data
• Keeps working even if the connection to Oracle
  is down

9
ltInsert Picture Heregt
Oracle Berkeley DB
10
Berkeley DB Product Family
? Berkeley DB extension providing XQuery-based
access to XML documents
? The original transactional storage engine for
applications developed with C, C, Java, PHP,
Perl, etc.
? Transactional storage engine written in Java
and optimized for Java environments
11
All Berkeley DB Products

• are libraries
• Run in the same address space as the application
• Small footprint on the order of half a megabyte
• No client/server abstraction
• require Oracles partner to write code
• Designed for embedded use in applications an
  devices
• End users generally dont know theres a database
• support transactions, concurrency, recovery
• provide record-based put/get APIs for storage
  and retrieval
• No SQL support anywhere

12
Key Features
Berkeley DB Feature
Partner Benefit
Performance, no translation required
Data stored in application-native format
Performance, flexibility/control
Programmatic API, no SQL
Performance, no IPC required
In process, not client-server
Low cost of ownership
Zero administration
High concurrency
Locking
Reliability, data integrity
ACID transactions and recovery
Ease of integration
Source code availability
13
ltInsert Picture Heregt
Oracle Lite
14
Database Lite - More Than a Database
Mission To extend the enterprise environment
with infrastructure and application services that
enable the delivery and operation of secure,
personalized applications on mobile and embedded
devices.
Mobile Server Repository
Mobile Server
Embedded or Mobile Client
Data and Applications
Sync Layer
Oracle Lite Database
Security Application Provisioning Data
Synchronization Device Management Life Cycle
management
15
Mobile Server

• Complete Life Cycle Management
• Device Management
• Software management
• Remote diagnostics and command execution
• System Management
• Synchronization monitoring and scheduling
• Inspection and corrective action
• Application Management (Provisioning and
  Deployment)
• User (OID), Application and Data Management

16
Mobile Server

• Synchronization
• High performance
• Scalable
• Automatic continuous sync in the background
• Designed for One-to-Many Synchronization
• Transport independent
• Conflict detection and customizable resolution
• Synchronizes everything
• Tables, Index, Sequences, DDL, Constraints
• Robust
• Checkpoint (Resume after transport failure)
• Network resilience with Broadbeam for roaming
  sessions over multiple protocols and networks

17
Oracles Embeddable Databases
Oracles Embeddable Databases span the full range
of customers needs
Mobile Devices Telematics Field Force
Automation Distributed Asset Management
Gateways / Routers Storage Systems
Mgmt Security / Authentication Mobile Services
Software Appliances
Telecom OSS/BSS Core Networking
Systems Securities Trading Call Centers /
CRM Reservations
Healthcare Equipment Industrial
Systems Manufacturing Systems Telco Softswitches
Mobile Applications
Edge Applications
Data CenterApplications