In-Memory in Oracle
By Bandari Huang on Sep 23, 2013
- Oracle TimesTen In-Memory Database
Oracle TimesTen In-Memory Database, is a memory-optimized, stand-alone relational database that empowers applications with the responsiveness and high throughput required by today's real-time enterprises and industries such as telecommunications, capital markets, and defense. Deployed in the application or middle tier as an embedded database, TimesTen uses standard structured query language (SQL) to operate on databases that fit entirely in physical memory.
- Oracle In-Memory Database Cache
Oracle In-Memory Database Cache is an Oracle Database option that is ideal for caching performance-critical subsets of an Oracle database’s frequently accessed data for improved response time in the application tier. IMDB Cache uses TimesTen as its RDBMS engine. IMDB Cache offers applications the full generality and functionality of a relational database, the transparent maintenance of cache consistency with the Oracle database, and the real-time performance of an in-memory database.
- Oracle In-Memory Parallel Execution
Oracle In-Memory Parallel Execution (In-Memory PX) introduced in Oracle Database 11g Release 2, takes advantage of this large aggregated database buffer cache. By having PX servers access objects via the database buffer cache they can scan data at least 10 X faster than they can on disk.
- Oracle Exalytics In-Memory Machine
Oracle Exalytics In-Memory Machine is the first engineered system specifically designed to deliver high performance analysis, modeling, and planning. Built by using industry-standard hardware, Oracle’s BI software, and in-memory database technology, Oracle Exalytics is an optimized system that delivers answers to all your business questions with unmatched speed, intelligence, simplicity, and manageability.
- Oracle Exadata X3 Database In-Memory Machine
Oracle Exadata X3 Database In-Memory Machine can store up to hundreds of Terabytes of compressed user data in Flash and RAM memory, virtually eliminating the performance overhead of reads and writes to slow disk drives, making Exadata X3 systems the ideal database platforms for the varied and unpredictable workloads of cloud computing.
- Oracle In-Memory Applications
Oracle In-Memory Applications are new set of application tools that provides a bottoms-up approach to maximizing profit margins by enabling near real-time insight. Oracle In-Memory Applications are built ground up to leverage Oracle’s unique hardware and technology capabilities: Exadata’s industry-leading data storage technologies, Exalogic’s middle tier technology, and Exalytics’ in-memory applications, all connected using InfiniBand technology to deliver extreme performance.
- Oracle Database In-Memory Option
Oracle Database In-Memory option is a solution for accelerating database-driven business decision-making to real-time speeds. Unlike specialized approaches that are restricted to particular workloads or applications, the unique approach of Oracle Database In-Memory leverages a new in-memory column store format to speed up analytic, data warehousing, and reporting workloads, while also accelerating transaction processing (OLTP) workloads.