ORACLE DATABASE In-MEMORY

Overview

Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with virtually any existing Oracle Database compatible application is as easy as flipping a switch--no application changes are required. It is fully integrated with Oracle Database's scale-up, scale-out, storage tiering, availability and security technologies making it the most industrial-strength offering in the industry.

Oracle Database In-Memory accelerate database performance by orders of magnitude for analytics, data warehousing, and reporting while also speeding up online transaction processing (OLTP). Allow any existing Oracle Database-compatible application to automatically and transparently take advantage of columnar in-memory processing, without additional programming or application changes.

With Oracle Database In-Memory is possible fast ad-hoc analytics without the need to pre-create indexes, completely transparent to existing applications, faster mixed workload OLTP, no database size limit, industrial strength availability and security and robustness and maturity of Oracle Database 12c.

Oracle Database In-Memory's ability to easily perform real-time data analysis together with real-time transaction processing enables organizations to become Real-Time Enterprises: Enterprises that quickly make data-driven decisions, respond instantly to customer demands, and continuously optimize all key business processes to maximize profitability.

The most important content of the book is as follows:

ORACLE DATA BASE IN-MEMORY. ESSENTIAL CARACTERISTICS
ORACLE DATABASE 12C IN-MEMORY ARCHITECTURE
HANA AND ORACLE DATABASE 12C
ORACLE DATABASE IN-MEMORY OPTION
ROW FORMAT VS. COLUMN FORMAT
THE IN-MEMORY COLUMN STORE
POPULATING THE IN-MEMORY COLUMN STORE
RESTRICTIONS
IN-MEMORY COMPRESSION
IN-MEMORY SCANS
IN-MEMORY JOINS
IN-MEMORY AGGREGATION
DML AND THE IN-MEMORY COLUMN STORE
PARTITION EXCHANGE LOADS
TRANSACTION PROCESSING
THE IN-MEMORY COLUMN STORE ON RAC
IN-MEMORY FAULT TOLERANCE
THE IN-MEMORY COLUMN STORE IN A MULTITENANT ENVIRONMENT
CONTROLLING THE USE OF ORACLE DATABASE IN-MEMORY
OPTIMIZER HINTS
IN-MEMORY SCAN
IN-MEMORY JOINS
IN-MEMORY AGGREGATION
MONITORING AND MANAGING ORACLE DATABASE IN-MEMORY
IN-MEMORY COLUMN STORE. EXAMPLES
MANAGING TABLES
MANAGING COLUMNS
MANAGING MATERIALIZED VIEWS
MANAGING TABLESPACES
VIEWS
WORKING WITH ORACLE DATABASE IN-MEMORY SOFTWARE
ORACLE DATABASE IN-MEMORY. EXAMPLES
ORACLE DATABASE SOFTWARE INTRODUCTION AND INSTALLATION

Read More