What s New in Oracle Times Ten In-Memory Database

What’s New in Oracle Times. Ten In-Memory Database 11 g and Oracle In-Memory Database Cache 11 g Marie-Anne Neimat Vice President, Development

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Real-Time Data Management Enabling the Real-Time World Instant Responsiveness Uninterrupted Service Even during peak periods • Competitive advantage • Ensures customer satisfaction • Reduces operations cost • • High availability across all components Real-Time Systems and Applications (BAM, CRM, Fraud Detection, RT billing, Personalization, Portals, Telco Services, Financial Services) Speed of Deployment Controlled expenses Ease of implementation • Ease of administration • Integration in data management stack • • Leverage inexpensive middle-tier hardware • More transactions per IT dollars • Incremental scalability

Agenda • Quick Overview – Oracle Times. Ten In-Memory Database and – Oracle In-Memory Database Cache • What’s new in 11 g • Customer use cases

Oracle Times. Ten In-Memory Database Memory-Optimized Standalone Database Telco Services Financial Services CRM, Portal, Intelligence, Saa. S, Defense, Real. Customer-facing Time Applications BAM & BI • Persistent, memory-optimized relational database • Delivers extreme performance for real-time applications • Highly available • Deployed in the middle tier, Application close to the application • Operates as a standalone database • Or …

Oracle In-Memory Database Cache Low-Cost Extreme Performance in the Middle-tier Business Applications Cached tables • Accelerates Oracle Database applications • Utilizes middle-tier resources • Data cached in Oracle Times. Ten -Memory Database Business Applications Cached tables In In-Memory Database Cache – Database tables – Subsets of rows and columns • Fast, consistent response times Real Application Cluster – High transaction throughput • Standard SQL interface – Synchronized with Oracle Database Automatic Storage Management

Lightning Fast Response Time 4 14 Millionths of a second Oracle Times. Ten In-Memory Database 11 g Intel Xeon 3. 0 Ghz 64 -bit Oracle Enterprise Linux

Linear Throughput Scaling Scale Up on Multi-Processor / Multi-Core Hardware Oracle Times. Ten In-Memory Database 11 g AMD 64 Dual-Core 1. 8 GHz, 4 Processors, 16 GB RAM; OEL 4. 0

Linear Throughput Scaling Scale Up on Multi-Processor / Multi-Core Hardware Out of CPU resources 8 th process competes with log flusher for CPU resource Oracle Times. Ten In-Memory Database 11 g AMD 64 Dual-Core 1. 8 GHz, 4 Processors, 16 GB RAM; OEL 4. 0

Oracle Times. Ten In-Memory Database Optimized In-Memory Database Technology • In-memory RDBMS – Entire database in memory – Persistent database – Optimized memory layout and algorithms • Exceptional performance – Instantaneous response time – High throughput – Embeddable • Persistent and durable – Transactions with ACID properties – Flexible options for data persistence to disk • Standard SQL and PL/SQL with – JDBC, OCI, Pro*C – Data types compatible with Oracle Database Client-Server Application Times. Ten Client Lib Client/ Server Directly-Linked Application Times. Ten Libraries JDBC / OCI / Pro*c Fast data access Checkpoint Files Log Files Memory-Resident Database

Transactional Replication High Availability and Instantaneous Failover Active Standby Pair Topology • Real-time transactional replication • High performance – Asynchronous replication – Synchronous replication • Multiple topologies, including – Active Standby Pair – Active • Robust and reliable – Supports both LAN and WAN configuration – Data compression • Support online upgrade – No downtime, cross version replication Application Transactions Application Reads on Hot Standby Active Standby Times. Ten IMDB Read-Only Subscribers Application Reads Times. Ten Subscriber Times. Ten IMDB Active Topology Application Transactions Active Times. Ten IMDB Split Workload

Oracle In-Memory Database Cache Accelerator for Oracle Database Applications • Reduced response time and increased throughput for Oracle Database applications • Oracle Database tables cached in the application-tier – Groups of related tables – All or subset of rows and columns • Read-only and updatable caches – Cached tables accessed like regular SQL database tables – Joins/search, insert/update/delete • Automatic data synchronization – Times. Ten to Oracle – Oracle to Times. Ten Client-Server Application Times. Ten Client Lib Client/ Server Directly-Linked Application Times. Ten Libraries JDBC / OCI / Pro*C Checkpoint Files Log Files Mid-Tier Server Automatic Synchronization

Read-Only Cached Tables • Content of cached tables pre-loaded or dynamically loaded – Dynamic loading coupled with automatic aging • Automatic transactional synchronization • Frequency of refreshes controlled by application Example: Call Center App • Agent profiles pre-loaded in all grid members • Updates to agent profiles applied to Oracle Database Reads Application In-Memory Database Cache Grid Member Automatic Synchronization Updates

Updatable Cached Tables • Content of cached tables pre -loaded or dynamically loaded Updates – Dynamic loading coupled with automatic aging • Automatic transactional synchronization – Synchronous – Asynchronous Example: Call Center App • Customer profiles loaded dynamically when needed • Customer profiles updated in IMDB Cache & propagated automatically to Oracle DB • Customer profiles aged out automatically when not used Updates Application In-Memory Database Cache Automatic Synchronization

Mixed Caches • Read-only cached tables and updatable cached tables in the same In-Memory Database Cache • Cached tables may be preloaded or dynamically loaded – Dynamic loading coupled with automatic aging • Automatic transactional synchronization Example: Call Center App • Read-only, pre-loaded agent profiles co-exist with updatable, dynamically loaded customer profiles Application In-Memory Database Cache Automatic Synchronization Updates

Highly Available Caches Highly-Available Cross-Tier Data Management Stack Active • Active/Standby pair replication • Synchronous or asynchronous • Available with read-only and updatable cached tables • Resilient to failure of any component – – IMDB Cache active IMDB Cache standby RAC instance Oracle Database cluster Standby Replication Application In-Memory Database In-Memory Cache Database Cache Application In-Memory Database In-Memory Cache Database Cache Read-Only Subscribers Data Guard

Agenda • Quick Overview – Oracle Times. Ten In-Memory Database and – Oracle In-Memory Database Cache • What’s new in 11 g • Customer use cases

Oracle Times. Ten and IMDB Cache What’s New in 11 g Release • Reduce the cost of adoption and the cost of operation • Globally shared caches – Incremental scalability on low cost hardware • PL/SQL, OCI, Pro*C support – Minimal application changes • Automated cross-tier high availability – Zero downtime Coupled with extreme performance

Incremental Scalability

Globally Shared Caches New Horizontal Scaling on Low-Cost Hardware • Location transparency – Content of all cache nodes available at each node • On-demand loading of cached data and redistribution based on usage • Transactional consistency • Peer-to-peer communication • Automatic synchronization with Oracle Database Application In-Memory Database Cache Automatic Synchronization Updates

Horizontal Scaling with In-Memory Database Cache Scale Out on Low Cost Hardware Sun 5240 Servers – 2 Sockets, 8 cores/socket, 8 hdwr threads/core

Online Addition/Removal of Cache Nodes New Incremental Scalability • On-demand addition/ removal of cache nodes to match – Memory capacity needs – Computation capacity needs Application In-Memory Database Cache Application In-Memory Database Cache

Minimal Application Changes

Application Development ODBC tt. Classes OCI, Pro*C C/C++ SQL PL/SQL Languages J 2 EE App Servers OR Mapping IMDB CACHE New in 11 g release • Oracle Call Interface (OCI) and Pro*C Support • PL/SQL – ability to invoke PL/SQL code from all supported APIs

Minimal Application Changes PL/SQL, OCI, and Pro*C in Times. Ten Database • PL/SQL support – PL/SQL engine implemented inside Times. Ten database – Same Oracle PL/SQL language – Subset of packages • OCI Support – Identical API signatures as used for the Oracle Database – Subset of functions • Pro*C/C++ support – Built using the same Oracle Pro*C/C++ precompiler • Minimal application changes – Extremely fast response time and high throughput New

Order Matching Application • Three different types of ation Present transactions: – Place market order – Place limit order – Process quote • Business logic implemented in PL/SQL stored procedures • Application written in Java • Execute 1000 times in one thread – Place an order – Process a quote Trading Application In-Memory Database Cache PL/SQL Executed on Oracle DB PL/SQL Executed in IMDB Cache

Accelerate Order Matching Application Lower Response Time and Higher Throughput

Zero Downtime

Integration with Oracle Clusterware New Automated Management, Monitoring and Failover Oracle Clusterware • Manages Times. Ten / IMDB Cache processes • Monitors and detects failure of – Nodes – Times. Ten / IMDB Cache processes – Applications • Manages automatic failover and assignment of new roles • Recovers automatically, including provisioning of spare nodes Read-Only Subscribers Active Standby Application In-Memory Database Cache In-Memory Database In-Memory Cache Database Cache In-Memory Database Cache Spare Nodes Shared Storage

Integration with Oracle Data Guard Oracle Maximum Availability Architecture • Support Data Guard synchronous standby – Failover and switchover Application In-Memory Database In-Memory Cache Database Cache – Rolling upgrades Data Guard Primary DB Physical / Logical Standby DB

Integration with Oracle Data Guard New Oracle Maximum Availability Architecture • Switchover / failover to standby Data Guard Application In-Memory Database In-Memory Cache Database Cache – Zero downtime – No data loss Primary DB Physical / Logical Standby DB

Automatic Client Connection Failover Application • Available for Client / Server connections • Configurable by the application IMDB Cache Client Library Active Standby In-Memory Database Cache

Automatic Client Connection Failover New Application • Connection failover is automatic upon Times. Ten/IMDB Cache server failover to the Standby server – Automatic re-connect to the new Active server – Connection handle is preserved • Applications may subscribe to connection failover notification (like TAF) IMDB Cache Client Library Active In-Memory Database Cache

Tools

SQL Developer and Enterprise Manager Plug-In Same Tools for the Oracle Stack Application In-Memory Database Cache SQL Developer Oracle Enterprise Manager

Customer Use Cases

Proven in Real-Time Deployments Deployed by Thousands of Companies

Smart Metering Operations IMDB Cache Reduces Hardware Expenses Smart meters • Complete meter, data & xact management at national level • Half-hourly data collection from every meter (47 M) • Daily feedback • Requirement: Process – 463 msg/sec at supplier level – 2167 msg/sec at national level Oracle DB + IMDB Cache 200 Msgs / sec Application In-Memory Database In-Memory Cache Database Cache 1 Server at supplier lvl 12 Servers at national lvl Application In-Memory Database In-Memory Cache Database Cache 1, 555 Msgs / sec 3 Servers at supplier lvl Msg queue 2 Servers at national lvl Server: HP Proliant server with 4 dual core AMD Opteron CPUs and 16 GB of RAM

Airline Ticket Fare Search and Reservation System Times. Ten and IMDB Cache Accelerate Least Fare Searches • No 3 Airline co in the world Fare Queries • New fare system for domestic flights • Provide customers ability to – Query fares (80 SQL stmts/xact) – Request least fare (600 SQL stmts/xact) • Guarantee low response time and high throughput • Solution – Oracle Times. Ten – Oracle IMDB Cache – Oracle Database RAC Least Fare Search Application Times. Ten In-Memory Database Application In-Memory Database Cache Times. Ten In-Memory Database Monthly Fare Update Flight Schedules Seat Assignments

Reduce Call Connection Time Performance + Site Availability + Geo Redundancy New VOIP Application Server Database Requirements • • Data access latency < 10 ms Ease of administration Geo-redundancy High Availability Solution EAST RAC WEST RAC • IMDB Cache for real time queries, local and central administration • Data Guard for Geo-Redundancy • RAC for high availability Results • Exceeds Site latency requirement • Site query time ~2. 2 ms • WAN to RAC query time ~150 ms Primary connections to IMDB Cache Backup connections to IMDB Cache Oracle Data Guard

Site Availability Low Latency + Local Redundancy Site Requirements • Fast data access • High Availability Solution • Application connects to local data source for fast response time • Active and Standby for HA • 2 read-only subscribers for additional data capacity and site redundancy Site Configuration App IMDB Cache Active Standby IMDB Cache Subscriber

For More Information Oracle Times. Ten Product Center on OTN: http: //oracle. com/technology/products/timesten • Technology white papers • Quick Start Guide and Tutorials • Discussion Forum • And more …

Other Times. Ten and IMDB Cache Sessions Title Date/Time Venue/Room What’s New in Oracle Times. Ten In-Memory Database and Oracle In-Memory Database Cache 11 g Wed 11: 45 Moscone South Room 306 Using Oracle Times. Ten In-Memory Database to Deploy Low-Latency Applications in Remote Sites - Comcast Wed 13: 45 Moscone South Room 102 High Speed and High Availability with Oracle In-Memory Database Cache 11 g Wed 17: 00 Moscone South Room 307 Visit us at the Demo. Ground! Moscone West, booths W-033 and W-036

Q & A