123: A New Database from Oracle: TimesTen
David Tipple , Statistics Canada    Biography

Objectives: You will learn some technical differences and similarities between TimesTen and Oracle databases
You will learn several alternative architectures to implement a TimesTen database
You will learn the basic operating concepts of the TimesTen in-memory database
Abstract: Even as databases grow larger, we face increasing pressure to reduce response time. Adding hardware is often considered the first step. However, this approach often has scalability issues. On the other hand, Oracle's new TimesTen database may be the solution. This database exists entirely in memory and so response time is both very fast and perfectly scalable. This presentation shows several implementation options for TimesTen. The focus is on caching an Oracle database, either fully or partially. We also show various ways to load the cache and where each would be appropriate. After the cache is loaded, we show TimesTen's cache aging strategies to manage the cache. Looking at the application architecture, we show how to design the application for maximum performance or maximum flexibility. This presentation will show you the potential of this new in-memory database from Oracle.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Architecture
Date: Wednesday, April 16, 2008
Time: 4:30 PM - 5:30 PM