Oracle In-Memory Database Cache
Oracle TimesTen In-Memory Database
Agenda
• What’s New?
• Products overview
– Oracle TimesTen In-Memory Database
– Oracle In-Memory Database Cache
• Pricing and Licensing examples
• Perspective from the Field
• How to identify opportunities
• Q&A
What’s New?
Price-list changes as of March 20, 2008
• A new Oracle Database Enterprise Edition option
– Oracle In-Memory Database Cache
• Removal of previous TimesTen database size pricing
– Customer now has two choices
• Oracle TimesTen In-Memory Database
– Stand alone TimesTen product
– Includes TimesTen In-Memory Database and Replication
• Oracle In-Memory Database Cache
– Oracle Database Enterprise Edition option
– Includes TimesTen In-Memory Database, Replication, and
Cache Connect to Oracle
Motivation
• Promote Oracle in-memory database caching solutions
• Simplify the pricing and license model
• More revenue for you
Agenda
• What’s New?
• Products overview
– Oracle TimesTen In-Memory Database
– Oracle In-Memory Database Cache
• Pricing and Licensing examples
• Perspective from the Field
• How to identify opportunities
• Q&A
Oracle TimesTen In-Memory Database
Memory-Optimized RDBMS for Real-Time Applications
Telco Services CRM, Portal, Real-Time
Financial Services SaaS, BAM & BI
Customer-facing
Applications
• Delivers real-time
responsiveness and very
high throughput
• Deployed in the middle
Application Application Application
tier, as
– Standalone in-memory
database – OR-
– In-memory database
cache for Oracle
Database
Oracle TimesTen In-Memory Database
• In-memory RDBMS
Client/server – Entire database in memory
Applications
Server B
– Standard ODBC/JDBC, SQL 92
Server A
– Compatible with Oracle Database
Client/ Direct-linked Direct-linked
Server Applications Applications – Accessed via direct-linked or via
client/server connections
In-Memory In-Memory
Database Database
• Exceptional performance
– Very low response time high
Tx Logs
Checkpoints
Tx Logs throughput
Checkpoints
• Persistence and recoverability
TimesTen
Replication
– Database persists to disk
– Transactions with ACID properties
• High Availability via transactional
data replication
Oracle In-Memory Database Cache
• Improves application response
Client/server
Applications time
Server A Server B • Cache tables, subset of rows and
Client/
Server
Direct-linked
Applications
Direct-linked
Applications
columns
In-Memory In-Memory
– Unlimited reads and writes
REP Cache
Cache
tables tables • Automatic data synchronization
– Updates in cache are propagated to
Cache Oracle database
Write-
Tx Logs Cache
through
Tx Logs – Updates in Oracle database are
Checkpoints refresh Checkpoints
refreshed to in-memory cache tables
• Applications access in-memory
cache tables like regular
database tables using SQL
– Joins/search, insert/update/delete
Types of In-Memory Caches
• Read-only Cache
– Oracle Database updates automatically refreshed to in-memory
cache tables
• Updatable Cache
– Transactions committed in the cache and write-through to Oracle
Database
– Asynchronous and synchronous write-through options
• 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
the cache
– Automatic data aging: LRU and timestamp-based aging
Benefits of In-Memory Database Cache
• Reduced application response time
– Read and Write transactions on cached tables are completed
with less time
• Very high throughput
– Low latency yields high throughput
• Reduced workload on the Oracle Database
– More computing resources available for other workloads
• Run on commodity hardware
– Available on 20 popular platforms
Agenda
• What’s New?
• Products overview
– Oracle TimesTen In-Memory Database
– Oracle In-Memory Database Cache
• Pricing and Licensing examples
• Perspective from the Field
• How to identify opportunities
• Q&A
Old TimesTen Pricing –
Product Options plus In-Memory Database Size
Database
Database Products Named User Plus Processor Licence
Size
≤ 2 GB – $12,000
≤ 10 GB – $18,000
TimesTen In-Memory Database ≤ 100 GB – $24,000
≤ 1TB – $48,000
> 1 TB – $96,000
≤ 2 GB – $6,000
≤ 10 GB – $9,000
Replication Option ≤ 100 GB – $12,000
≤ 1TB – $24,000
> 1 TB – $48,000
≤ 2 GB – $6,000
≤ 10 GB – $9,000
Cache Connect to Oracle
≤ 100 GB – $12,000
Option
≤ 1TB – $24,000
> 1 TB – $48,000
Licenses based on processors on which TimesTen software was installed and/or running
New Pricing Model
As of March 20, 2008
Named
Processor
Database Products User
License
Plus
In-Memory Database Cache
– USD 36,000
(Oracle Database Enterprise Edition option)
Oracle TimesTen In-Memory Database – USD 36,000
Amendment to the Processor Definition
For the purposes of licensing Oracle In-Memory Database Cache, only the
processors on which the TimesTen In-Memory Database component of the
In-Memory Database Cache software is installed and/or running are counted
for the purpose of determining the number of licenses required
License Example 1
App 1 App 2 App 3
2 2 2 2 4 4
In-Memory Database Cache:
CPUs CPUs CPUs CPUs CPUs CPUs
4 nodes with 2 CPUs each
2 nodes with 4 CPUs each
= total 16 licenses
Oracle Real Application Clusters
3 nodes, 8 CPUs each
= total 24 licenses
License Example 2
App 1 App 2
In-Memory Database Cache: 4 4 2 2
2 nodes with 4 CPUs each CPUs CPUs CPUs CPUs
2 nodes with 2 CPUs each
= total 12 licenses
Oracle Database Enterprise Edition
Single server 8 CPUs
= total 8 licenses
License Example 3
App 1 App 2 App 3
TimesTen In-Memory 4 4 2 2 4 4
Database (no DB caching): CPUs CPUs CPUs CPUs CPUs CPUs
4 nodes with 4 CPUs each
2 nodes with 2 CPUs each
= total 20 licenses
License Migration
From existing TimesTen Licenses
• To use the new product licenses, existing customers
must go through license migration
– List-to-List 10% minimum
– Restrictions on existing licenses
• See License Migration Program for details
– http://esource.us.oracle.com License Migrations
Product Migration Listings Oracle
• Questions on license migration, contact
infoPrice@oracle.com
Software Downloads and Distribution
• TimesTen software will continue to be available for
download from eDelivery and OTN
– Same software for both products
– Only licenses are different
– Current TimesTen release is 7.0.4
• Oracle Database 11g and 10g media packs include
– In-Memory Database Cache media pack
– Starting with TimesTen 7.0.5 release
Product Development and Support
• Same TimesTen development team is responsible for the
product development and releases of the In-Memory
Database Cache option and the stand alone TimesTen
In-Memory Database product
• Technical Support for the In-Memory Database Cache
option will be from the same technical support team
handling the Oracle TimesTen product today
• Same product code (1870) for use with Metalink and
BugDB
Agenda
• What’s New?
• Products overview
– Oracle TimesTen In-Memory Database
– Oracle In-Memory Database Cache
• Pricing and Licensing examples
• Perspective from the Field
• How to identify opportunities
• Q&A
NYFIX Background
• NYFIX is a trusted provider of innovative solutions to
optimize trading efficiency.
• NYFIX uses the TimesTen product to:
– Match trades for institutional customers (exchange)
– Maximize trade execution quality
– Real time matching algorithms
– Improve liquidity (matching orders) compared to NBBO standards
• Oracle TimesTen products purchased
– TimesTen In-Memory Database
– Replication
– Cache Connect to Oracle
Oracle Confidential and For Internal Use Only
NYFIX Millennium
• Millennium uses the In-Memory Database Cache to
achieve:
– High volume transactions via TimesTen In-Memory Database
– Highly available trade processing system (via TimesTen
Replication)
– Trade orders are processed in the TimesTen in-memory
cache and propagated to an Oracle Database 10g using
Cache Connect to Oracle
• Customer Satisfaction & New Projects
– Citigroup and CSFB first customers
– Tier-1 financials on the Millennium advisory board
– European Millennium went live on March 17th, 2008
– Customer is happy with the support from the Oracle team
Oracle Confidential and For Internal Use Only
Agenda
• What’s New?
• Products overview
– Oracle TimesTen In-Memory Database
– Oracle In-Memory Database Cache
• Pricing and Licensing examples
• Perspective from the Field
• How to identify opportunities
• Q&A
How to Identify Opportunities?
• Look for database-intensive applications where
– Application response time is below user expectation
• Look for performance challenges where
– Response time SLA not met, and
– Transaction rate is below business requirement
• Look for
– Home-grown caching solutions can’t keep up with business
growth and in-house maintenance cost too high
– New project initiatives or application architecture redesigns where
performance improvement is a key driver
For More Information
http://search.oracle.com
In memory database cache
or
oracle.com/database
infoPrice@oracle.com
timesten-help_ww@oracle.com