Get documents about "Embedded Database Overview Part 2
Document Sample
<Insert Picture Here>
Embedded Database Overview Part 2
Program Agenda
• Review of Part 1 <Insert Picture Here>
• Oracle TimesTen Product Overview
• Oracle TimesTen Cache Connect to Oracle
Where are They Deployed?
Oracle’s Embeddable Databases span the full range of customers’ needs
Mobile Devices
Telematics
Gateways / Routers Field Force Automation
Telecom Billing Storage & Systems Mgmt Point-of-Sale Devices
IP Multimedia Systems Security / Authentication Distrib Asset Mgmt
Healthcare Equipment
Core Networking Systems Mobile Services Software
Industrial Systems
Telco Softswitches Appliances
Manufacturing Systems
Call Centers / CRM
Semiconductor Equipment
Communications Systems
Mobile
Applications
Edge Applications
Data Center
Applications
In reality, these zones are not black and white. Each product has a “sweet spot” target market, but also
serves adjacent areas.
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
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
Finance
Automated trading
Manufacturing & risk mgmt Travel
“Just-in-time” Exploding “look-
& RFID to-book” ratios
Real-Time Business
• Real-time operations
• Real-time CRM
• Real-time BI
Retail • Real-time optimization Customer Portal
Stock optimization Personalization,
& pricing Cross-sell / upsell
Telecom
Next-gen services
& billing
Oracle TimesTen In-Memory Database
Memory-optimized RDBMS for real-time applications
Telco Services CRM, Portal, SaaS, Real-Time
Financial Services Customer-facing BAM & BI
Applications
• Application-tier relational
database
• Delivers instant responsiveness
and very high throughput
• Operates as database of record
or as a read/write cache for Application Application Application
Oracle Database
• Provides replication for high
availability and scalability
“When milliseconds matter”
When You Think “Database…”
Application SQL
RDBMS
Results
Application
RDBMS + client/server connectivity
• Data accessed by client application via the network
• Not fast enough for some applications
RDBMS with Home-Grown Cache
Application SQL
RDBMS
Results
Application
For very demanding applications:
• Build a home grown, application-specific, in-memory
“cache”
One Product: Database + Cache
Application SQL
RDBMS
Results
Application
• Full capabilities of relational • Optimized for embedded
database architecture
• Standalone or with Oracle • Persistent, recoverable, highly
• Memory-optimized speed & available
latency
Oracle TimesTen Products
Product Oracle TimesTen In-Memory Database
Option Replication: TimesTen to TimesTen
Option Cache Connect to Oracle
Oracle TimesTen In-Memory Database
• In-memory RDBMS
Network • Entire database in memory
Application • Standard access ODBC/JDBC, SQL 92
TimesTen
Client lib
Application
Application • Compatible with Oracle Database
Application
TimesTen
TimesTen
Client-
Libraries
TimesTen
Libraries
Libraries
• Exceptional performance
Server • Instantaneous response time
Direct-linked
• High throughput
• Embeddable
In-Memory Database • Persistence and durability
• Database persists to disk
Transaction Logs • Transactions with ACID properties
Checkpoint files
• Real-time services
• On-line, non-blocking operations
• Real-time database change notification
• Near-zero administration
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)
Oracle TimesTen Delivers Lightning
Fast Response
Oracle TimesTen 6.0
4-CPU, 3 GHz x86 Xeon, 32-bit RHLinux
30 28
microseconds (millionths of a second)
25
20
15
9
10
5
0
update select
Oracle TimesTen Offers Outstanding
Platform Efficiency
Oracle TimesTen 6.0
4-CPU, 3 GHz x86 Xeon, 32-bit RHLinux
300,000
4 CPUs
250,550
250,000
transactions per second
200,000 2 CPUs
169,437
150,000
1 CPU
98,568
100,000 4 CPUs
2 CPUs 70,111
1 CPU 53,361
50,000 32,663
0
update select
Replication – TimesTen to TimesTen
• Real-time transactional replication
Network
• Between TimesTen databases
Application Application • Flexible configuration
Application Application
Application
TimesTen
TimesTen
Application
TimesTen
TimesTen • Active-standby, Active-active,
Libraries
TimesTen Libraries
TimesTen
Libraries
Libraries
Libraries
Libraries N-way
• High performance
• Asynchronous replication
In-Memory In-Memory
Database Database • Synchronous replication
• Robust and reliable
Replication • Auto recovery, master catch-up
TimesTen to TimesTen
• Conflict detection and resolution
• Support online upgrade
• No downtime, cross version
replication
Oracle Database 10g and TimesTen
Complementary Database Strengths
Database Oracle TimesTen
Oracle Database 10g
Characteristic In-Memory Database
Data Model Relational – SQL Relational – SQL
Target Applications All OLTP, some DSS
Optimization Disk-centric Memory-centric
Typical Deployment Database Tier Application Tier
Architecture Client / Server Direct Data Access
Response Time Milliseconds Microseconds
Data Capacity Tens of Terabytes Tens of Gigabytes
Scalability Unlimited SMP/Cluster Good SMP
Cache Connect to Oracle
Application
• Improves application response
TimesTen
Network Client lib time
Application
TimesTen Client- • Cache tables from Oracle
Libraries Server
database
Direct-linked
• Cache individual tables and related
tables
• Cache all or subset of rows & cols
Cache Tables
Tx Logs
• Automatic data synchronization
Cache
Checkpoints • TimesTen to Oracle
Agent
• Oracle to TimesTen
• Access cache tables like regular
database tables using SQL
• Joins/search, insert/update/delete
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
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
Cross-Tier High Availability
Integration 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
Oracle TimesTen + Oracle Database
End-to-End Data Management
1. Instantly Responsive
2. Tightly Integrated
3. Highly Scalable
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:
BERKELEY DB • 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
• Synchronization to Oracle Database is required
• Small footprint is required
• SQL is required
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 Developer’s Center - Free Developer Downloads, white
papers, technical articles, podcasts, discussion forums regarding
embedded database products
• http://www.oracle.com/technology/tech/embedded/index.html
• Oracle is the #1 Embedded Database in the world – IDC report
• http://www.oracle.com/corporate/press/2007_dec/embedded-vendorshare-idc.html
• http://www.oracle.com/corporate/analyst/reports/infrastructure/dbms/idc-209653.pdf
• Independent Software Vendor (ISV) Getting Started Page
• http://www.oracle.com/technology/isv/index.html
Questions,
Comments ?
Dan Outcalt – 858.509.8125 – dan.outcalt@oracle.com
Gabe Stanek – gabe.stanek@oracle.com
Related docs
