Creating an In-Memory Cache Database on Windows
This tutorial will go through the process of setting up Oracle In-Memory Database Cache, which is a TimesTen in-memory database used as a cache to an Oracle database. This tutorial only covers how to set up Oracle In-Memory Database Cache for Windows.
Time to Complete
Approximately 30 minutes.
Oracle In-Memory Database Cache is a TimesTen in-memory database used as a cache to an Oracle database. Oracle In-Memory Database Cache improves application response time by caching a performance-critical subset of tables and table fragments from an Oracle database into a TimesTen in-memory database running in the application tier.
Oracle TimesTen In-Memory Database (TimesTen) is a memory-optimized relational database that provides applications with the instant responsiveness and very high throughput required by today’s real-time enterprises in a wide range of industries. A TimesTen database resides entirely in memory at run time and is persisted to disk storage for the ability to recover and restart. Applications access the TimesTen database using the JDBC, ODBC, OCI, ODP.NET and/or Pro*C/C++ interfaces. TimesTen is fully transactional, persistent, and highly available with transactional replication. TimesTen is typically deployed in the middle-tier with the applications; it can be run as a stand-alone database or as an in-memory cache database for an Oracle database. Using TimesTen as an in-memory cache database provides applications the power of SQL, the speed of RAM and the reliability of a proven product with automatic data synchronization between the in-memory cache tables and the backend Oracle database.
This tutorial will go through the process of creating an in-memory cache database on Windows.