Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database In-Memory Guide
-
Part I Oracle Database In-Memory Concepts
-
1
Introduction to Oracle Database In-Memory
- 1.1 Challenges for Analytic Applications
- 1.2 The Single-Format Approach
- 1.3 The Oracle Database In-Memory Solution
- 1.4 Prerequisites for Database In-Memory
- 1.5 Principal Tasks for Database In-Memory
- 1.6 Tools for the IM Column Store
- 2 In-Memory Column Store Architecture
-
1
Introduction to Oracle Database In-Memory
-
Part II Configuring the IM Column Store
- 3 Enabling and Sizing the IM Column Store
-
4
Enabling Objects for In-Memory Population
- 4.1 About In-Memory Population
- 4.2 Enabling and Disabling Tables for the IM Column Store
- 4.3 Enabling and Disabling Columns for In-Memory Tables
- 4.4 Enabling and Disabling Tablespaces for the IM Column Store
- 4.5 Enabling and Disabling Materialized Views for the IM Column Store
- 4.6 Forcing Initial Population of an In-Memory Object: Tutorial
- 4.7 Enabling ADO for the IM Column Store
-
Part III Optimizing In-Memory Queries
- 5 Optimizing Queries with In-Memory Expressions
- 6 Optimizing Joins with Join Groups
-
7
Optimizing Joins with In-Memory Aggregation
- 7.1 About IM Aggregation
- 7.2 Purpose of IM Aggregation
-
7.3
How IM Aggregation Works
- 7.3.1 When the Optimizer Chooses IM Aggregation
- 7.3.2 Key Vector
- 7.3.3 Two Phases of IM Aggregation
-
7.3.4
IM Aggregation: Scenario
- 7.3.4.1 Sample Analytic Query of a Star Schema
- 7.3.4.2 Step 1: Key Vector and Temporary Table Creation for geography Dimension
- 7.3.4.3 Step 2: Key Vector and Temporary Table Creation for products Dimension
- 7.3.4.4 Step 3: Key Vector Query Transformation
- 7.3.4.5 Step 4: Row Filtering from Fact Table
- 7.3.4.6 Step 5: Aggregation Using an Array
- 7.3.4.7 Step 6: Join Back to Temporary Tables
- 7.4 Controls for IM Aggregation
- 7.5 In-Memory Aggregation: Example
- 8 Optimizing Repopulation of the IM Column Store
-
Part IV High Availability and the IM Column Store
- 9 Managing IM FastStart for the IM Column Store
-
10
Deploying IM Column Stores in Oracle RAC
- 10.1 Overview of Database In-Memory and Oracle RAC
- 10.2 Configuring In-Memory Services in Oracle RAC
- 11 Deploying an IM Column Store with Oracle Active Data Guard
- Part V Database In-Memory Reference
-
A
Using IM Column Store In Cloud Control
- A.1 Meeting Prerequisites for Using IM Column Store in Cloud Control
- A.2 Using the In-Memory Column Store Central Home Page to Monitor In-Memory Support for Database Objects
- A.3 Specifying In-Memory Details When Creating a Table or Partition
- A.4 Viewing or Editing IM Column Store Details of a Table
- A.5 Viewing or Editing IM Column Store Details of a Partition
- A.6 Specifying IM Column Store Details During Tablespace Creation
- A.7 Viewing and Editing IM Column Store Details of a Tablespace
- A.8 Specifying IM Column Store Details During Materialized View Creation
- A.9 Viewing or Editing IM Column Store Details of a Materialized View
- Glossary
- Index