Embedded Database Overview Part 2

1
Embedded Database Overview Part 2
2
Program Agenda
ltInsert Picture Heregt

• Review of Part 1
• Oracle TimesTen Product Overview
• Oracle TimesTen Cache Connect to Oracle

3
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.
4
Review of Part 1

• Described the model for Embedded Database
• Embedding Oracle at Mobile BIS
• Oracle Lite
• Client Database
• Sync Server
• Full Application Lifecycle Management
• Berkeley DB
• Berkeley DB
• Berkeley DB XML
• Berkeley DB Java Edition

5
The Drive to Real-time

• Across a wide range of industries and
  applications, the volume of information and
  transactions is exploding while pressure builds
  for real-time, up-to-the-minute information
  processing

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 Database

• In-memory RDBMS
• Entire database in memory
• Standard access ODBC/JDBC, SQL 92
• Compatible with Oracle Database
• Exceptional performance
• Instantaneous response time
• High throughput
• Embeddable
• Persistence and durability
• Database persists to disk
• Transactions with ACID properties
• Real-time services
• On-line, non-blocking operations
• Real-time database change notification
• Near-zero administration

12
Why Is TimesTen So Fast?

• In-Memory Database
• Entire database is always in memory
• Designed and optimized for memory layout
• No buffer cache management overhead
• Shorter code path faster performance
• Fewer CPU instructions fewer processors
  required
• Direct-link to the database
• Application can link TimesTen directly into its
  address space
• Eliminate network and inter-process communication
  overhead
• Very low response time (like calling a procedure)

13
Oracle TimesTen Delivers Lightning Fast Response
14
Oracle TimesTen Offers Outstanding Platform
Efficiency
15
Replication TimesTen to TimesTen

• Real-time transactional replication
• Between TimesTen databases
• Flexible configuration
• Active-standby, Active-active, N-way
• High performance
• Asynchronous replication
• Synchronous replication
• Robust and reliable
• Auto recovery, master catch-up
• Conflict detection and resolution
• Support online upgrade
• No downtime, cross version replication

16
Oracle Database 10g and TimesTenComplementary
Database Strengths
17
Cache Connect to Oracle

• Improves application response time
• Cache tables from Oracle database
• Cache individual tables and related tables
• Cache all or subset of rows cols
• Automatic data synchronization
• TimesTen to Oracle
• Oracle to TimesTen
• Access cache tables like regular database tables
  using SQL
• Joins/search, insert/update/delete

18
Types of TimesTen Caches

• Read-only Cache
• Updates in Oracle Database propagated
  automatically to TimesTen
• Updatable Cache
• Asynchronous write-through transactions
  batch-committed in Oracle Database
• Synchronous write-through transactions available
  optionally
• Static Cache
• Entire content of cache is pre-loaded prior to
  doing any work
• Dynamic Cache
• Data loaded transparently from Oracle Database if
  not found in TimesTen
• Automatic data aging from TimesTen LRU and
  timestamp based

19
Benefits of Caching in TimesTen

• Reduced application response time
• Read and Write transactions are completed more
  quickly in TimesTen
• Very high throughput
• Multiple caches provide horizontal scaling
• Reduced workload on the Oracle Database
• More computing resources are available for other
  workloads on the database tier
• Run on commodity hardware
• TimesTen is available on 20 popular platforms

20
Cross-Tier High AvailabilityIntegration with
Oracle Database RAC

• Automatic recovery from Oracle Database RAC node
  failures using TAF and FAN
• Automatic reconnection to the cluster
• Automatic resumption of updates from Oracle to
  TimesTen
• Automatic rollback of in-transit update
  transactions from TimesTen to Oracle and their
  resubmission
• No loss of transactions

21
Oracle TimesTen Oracle DatabaseEnd-to-End Data
Management
1. Instantly Responsive
2. Tightly Integrated
3. Highly Scalable
22
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

23
Where to go... What to do...

• Embedding Oracle Within Your Product Main page
  for information on embedding Oracle Products
• http//www.oracle.com/technologies/embedded/index.
  html
• Embedded Developers Center - Free Developer
  Downloads, white papers, technical articles,
  podcasts, discussion forums regarding embedded
  database products
• 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
• Independent Software Vendor (ISV) Getting Started
  Page
• http//www.oracle.com/technology/isv/index.html

24
Questions, Comments ?
Dan Outcalt 858.509.8125 dan.outcalt_at_oracle.co
m Gabe Stanek gabe.stanek_at_oracle.com