Embedded Database Overview

1
Embedded Database Overview

• Dan Outcalt
• eISV Technology Sales Manager

Gabe Stanek Sr. Sales Consultant
2
Program Agenda
ltInsert Picture Heregt

• Oracle Embedded Overview
• Oracle TimesTen Product Overview
• Oracle Berkeley DB Product Overview
• Oracle Database Lite Product Overview

3
When you think of Oracle...

• You may not think of embedded but
• Oracle has 23.2 of the embedded market, next
  closest is 14.1
• Oracle embedded solutions are lights out no
  DBA required
• Oracle has light database products 1 mb or
  less footprint
• Oracle has aggressive pricing models for embedded
  solutions
• Partner takes support calls, we pass on the
  savings.
• Do you need an embedded database?
• Need for persistence
• Blazingly fast performance
• Reliability a concern (vs. home grown systems)?
• Fault tolerance important.?
• Oracle embedded solutions address these issues
  head on.

4
Where are They Deployed?
Oracles Embeddable Databases span the full range
of customers needs
Mobile Devices Telematics Field Force
Automation Point-of-Sale Devices Distrib Asset
Mgmt
Gateways / Routers Storage Systems
Mgmt Security / Authentication Mobile Services
Software Appliances
Telecom Billing IP Multimedia Systems Core
Networking Systems Telco Softswitches Call
Centers / CRM
Healthcare Equipment Industrial
Systems Manufacturing Systems Semiconductor
Equipment Communications Systems
Mobile Applications
Edge Applications
Data CenterApplications
In reality, these zones are not black and white.
Each product has a sweet spot target market,
but also serves adjacent areas.
dan.outcalt_at_oracle.com.
5
Program Agenda
ltInsert Picture Heregt

• Oracle Embedded Overview
• Oracle TimesTen Product Overview
• Oracle Berkeley DB Product Overview
• Oracle Database Lite Product Overview

6
Oracle TimesTen In-Memory Database
Memory-optimized RDBMS for real-time applications
Telco ServicesFinancial Services
CRM, Portal, SaaS,Customer-facing Applications
Real-TimeBAM BI

• Application-tier relational database
• Delivers instant responsiveness and very high
  throughput
• Operates as database of record or as a read/write
  cache for Oracle Database
• Provides replication for high availability and
  scalability

Application
Application
Application
When milliseconds matter
7
When You Think Database
Application
SQL
RDBMS
Application
Results

• RDBMS client/server connectivity
• Data accessed by client application via the
  network
• Not fast enough for some applications

8
RDBMS with Home-Grown Cache
Application
SQL
RDBMS
Application
Results

• For very demanding applications
• Build a home grown, application-specific,
  in-memory cache

9
One Product Database Cache
Application
SQL
RDBMS
Application
Results

• Full capabilities of relational database
• Standalone or with Oracle
• Memory-optimized speed latency

• Optimized for embedded architecture
• Persistent, recoverable, highly available

10
Oracle TimesTen Products
11
Oracle TimesTen In-Memory DatabaseThe Base
Product

• Everything runs in-memory on the same platform -
  very efficient
• The data is safe - local disks used for
  persistence and recovery
• A full read/write, transactional RDBMS for
  shared, multi-user access
• All APIs are based on well-known industry
  standards

12
Replication TimesTen to TimesTenHigh-Availabilit
y for Application Tier Data

• Most often used by server pairs for hot-standby
• Majority of deployments use this option
• Multi-master, n-way replication also supported
• Scalable load balancing
• Very fast and highly configurable
• Works for stand-alone in-memory databases and
  Oracle caches

13
Cache Connect to OracleUsing Oracle TimesTen to
Cache Oracle Data

• 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

14
Oracle Database 10g and TimesTenComplementary
Database Strengths
15
Improved Customer SatisfactionHosted CRM System
Dynamic Personalization

• User preferences are loaded from Oracle RAC into
  Oracle TimesTen upon login
• Preference information is now looked up in Oracle
  TimesTen
• HA through replication
• One API for both databases (JDBC)
• Fast response time means a better user experience
• Users now see personalized pages suited to their
  needs
• User experience is now noticeably better than
  their competitors

Worldwide Corporate Subscribers
NA Application Servers
EMEA / APAC Application Servers
JDBC
Load Balancer
Load Balancer
Active
Standby
Standby
Active
4-CPU Servers, Linux, 2 GB databases
Master Database
Master Database
Oracle
16
Program Agenda
ltInsert Picture Heregt

• Oracle Embedded Overview
• Oracle TimesTen Product Overview
• Oracle Berkeley DB Product Overview
• Oracle Database Lite Product Overview

17
Oracle Berkeley DB Overview

• Most widely deployed open source, embeddable
  database in the world
• High performance database engine
• Runs directly in applications address space
• Application-native data storage
• No SQL layer overhead
• Low total cost of ownership
• High performance with less hardware
• Embedded administration
• Lower development cost cheaper to buy vs. build

18
Berkeley DB Product Family

• All three Berkeley DB Products
• Libraries linked to your application
• Simple, direct, indexed data storage
• Key-value pairs with simple, get-put style API
• getDocument/putDocument for DB XML
• Operate in memory, on disk or both
• Programmatic administration API
• Low latency high throughput
• ACID transactions and recovery
• Open source

19
Berkeley DBHigh Performance, Transactional
Database

• Fast indexed and sequential retrieval (Btree,
  Queue, Recno, Hash)
• High availability via single master replication
• XA standard for distributed transactions
• Optional AES encryption on disk
• Footprint as small as 400KB
• Languages C, C, Java, and several scripting
  languages
• Platforms UNIX, Linux, MacOS X, Windows,
  VxWorks, QNX, and others (POSIX-complaint)

20
Berkeley DB Java EditionHigh Performance, Pure
Java Database

• 100 pure Java for portability and ease of
  development
• Single JAR file easy to install, runs in same
  JVM as application
• Fast, indexed retrieval (Btree)
• Optimized for highly concurrent access
• Additional object-based storage APIs
• Small footprint 820KB
• Supports J2SE J2EE JVMs
• JCA, JTA and JMX in J2EE environments

21
Berkeley DB XMLXML Database Built on Top of
Berkeley DB

• Native XML support via XQuery 1.0 and XPath 2.0
• Flexible storage control nodes or whole
  document
• XML and non-XML data in the same database
• Query optimization via cost-based query engine
• Partial document updates
• XML Schema support, including validation
• Document streaming from URI, memory or file
• DOM-like navigation of documents and result sets
• Languages C, Java, Perl, Python, PHP and
  several other scripting languages

22
Oracle Berkeley DB Summary

• Consider the Berkeley DB products when you need
• Blazingly fast performance
• Simple, direct, indexed data storage SQL adds
  unnecessary complexity
• Local, in-process storage, not client/server
• High availability and fault tolerance
• Lights out administration
• Embedded XML document management (DB XML)

23
Amazon.com Delivers Superior User Experience with
Berkeley DB

• Requirement Amazon.coms website needed to be
  highly responsive, massively scalable, and
  always-on in order to give customers a highly
  personalized shopping experience.
• Solution Amazon.com selected Berkeley DB to
  serve as a high speed cache in front of their
  massive products and offerings database built on
  Oracle Database. When customers view
  Amazon.coms pages, all the product information,
  pricing, recommendations, user reviews, etc. are
  retrieved from Berkeley DB running as a cache in
  front of an Oracle Database backend.

24
Program Agenda
ltInsert Picture Heregt

• Oracle Embedded Overview
• Oracle TimesTen Product Overview
• Oracle Berkeley DB Product Overview
• Oracle Database Lite Product Overview

25
Mobile Applications

• A persistent connection for mobile users is not
  always

• Possible
• Field force is in a remote environment that has
  no wireless coverage.
• Practical
• There is no business case for a real-time
  connection always-on connection ignores the cost
  of communication.
• Desirable
• Wireless connection compromises security.

Oracle Lite provides mobile developers an
infrastructure with application services that
enables the development, delivery and operation
of secure, personalized applications on mobile
devices.
26
Oracle Database Lite Architecture
Mobile Server Repository
Mobile Server
Embedded or Mobile Client
Secure Data and Applications
Sync Layer
Oracle Lite Database
Data Synchronization Application
Provisioning Device Management Life Cycle
Management
Windows, Windows Mobile, Symbian, Linux,
Embedded Linux, etc.
27
Data Synchronization

• Very fast
• Data compression, fast refresh
• Designed for one-to-many synchronization
• Very scalable, asynchronous
• Conflict detection and resolution
• Client wins, server wins or customizable
• Synchronizes all database objects
• tables, indexes, sequences, constraints
• Efficient transport
• Checkpoints allow Synchronization to resume where
  it left off.
• Protocol independent

28
Automatic Synchronization

• Synchronization may be triggered by satisfying
  conditions and events
• Supports continuous client synchronization while
  user continues to work
• Supports server initiated synchronization
• Rules Based Synchronization
• Conditions All must be true
• Events Only one must be true

29
Synchronization Process

• Sync moves updated rows from the client to the In
  Queue and from the Out Queue to the client.
• Message Generator Process applies the changes
  from the In Queue to the base tables, and
  composes the Out Queue from the base tables.

Mobile Sync Server
Device
MGP
Upload
Apply
Native App
IN Queue
Olite DB
Sync Client
Download
Compose
OUT Queue
30
Mobile Server Complete Life-Cycle Management

• Application Management
• Application Provisioning Deployment
• Application Management
• User Administration
• System Management
• Device Management
• Remote Diagnostics
• Command Execution

31
Oracle Database LiteKey Advantages

• Extends your enterprise data
• Extends the grid environment to mobile and
  embedded devices
• Provides continuous data availability for
  embedded and mobile applications
• Oracle Database Lite has direct business impact
• Connection is often
• Not possible
• Not practical
• Not desirable
• Oracle provides complete infrastructure
• High impact solutions
• Rapidly implemented solutions
• Comprehensive life cycle management

32
Oracle Database Lite Enables Remote Transactions
United Sates Coast Guard

• Procurement
• Ship personnel can perform inventory transactions
  remotely
• Extension of an existing system Large Unit
  Financial System (LUFS)
• On demand access to financial desktop
  applications on ships
• No onboard system admin or Oracle DBA
• Ships synchronize data with LUFS once docked

• Benefits
• Reduction in delays of data entry into LUFS
• Improved productivity of personnel maintaining
  financial data at sea
• Reduce cost with consolidation of four regional
  databases

33
Which Embeddable Database?

• Choose Oracle Database when
• Advanced features (spatial, triggers, stored
  procedures) are required
• Clustering via RAC or integration with Fusion
  Middleware is required
• Footprint is not a constraint
• Choose TimesTen when
• Low latency and high throughput required
• Oracle caching is needed
• SQL is required
• Database fits into memory
• Choose Berkeley DB when
• Low latency and high throughput required
• Data access is predictable
• XML/XQuery is required
• Choose Oracle Lite when
• Devices may be occasionally disconnected from the
  network

34
Where to go... What to do...

• Free Developer Downloads, white papers, technical
  articles, podcasts, discussion forums
• http//www.oracle.com/technology/tech/embedded/ind
  ex.html
• Oracle is the 1 Embedded Database in the world
  IDC report
• http//www.oracle.com/corporate/press/2007_dec/emb
  edded-vendorshare-idc.html
• http//www.oracle.com/corporate/analyst/reports/in
  frastructure/dbms/idc-209653.pdf

35
Questions, Comments ?