Monday Oct 13, 2014

Getting started with Oracle Database In-Memory Part IV - Joins In The IM Column Store

It's been a while since I've had an opportunity to share a technical blog post but now that OpenWorld has wrapped up for another year it's time to get back to the techie details of Oracle Database In-Memory.

Up until now, we've focused on queries that scan only one table. Let’s broaden the scope of our investigation to include joins and parallel execution. In this post I'll show a series of queries that begin with a single join between a fact table, LINEORDER, and a dimension table DATE_DIM and work up to a multi-table join.

[Read More]

Sunday Aug 17, 2014

Getting started with Oracle Database In-Memory Part III - Querying The IM Column Store

In my previous blog posts, I described how to install, enable, and populate the In-Memory column store (IM column store). This week's post focuses on how data is accessed within the IM column store.

Let’s take a simple query “What is the most expensive air-mail order we have received to date?”

SELECT Max(lo_ordtotalprice) most_expensive_order
FROM lineorder

WHERE
lo_shipmode = 5;

[Read More]

Monday Aug 04, 2014

Getting started with Oracle Database In-Memory Part II - In-Memory Population

In part two of this series on getting started with Oracle Database In-Memory I’ll explain how and when objects are populated into the In-Memory column store (IM column store) and exactly how you can control it.

Which objects are populated into the IM column store?

As I mention last week, only objects with the INMEMORY attribute are populated into the IM column store. The INMEMORY attribute can be specified on a tablespace, table, (sub)partition, or materialized view. In this example the INMEMORY attribute is specified on the CUSTOMERS.

[Read More]

Monday Jul 28, 2014

Getting started with Oracle Database In-Memory Part I - Installing & Enabling

Now that Oracle Database 12.1.0.2 has been officially released, I can finally start sharing more technical details on how Oracle Database In-Memory (Database In-Memory) works.

I thought we should start this series of posts right at the very beginning by answering the question, how and when is Database In-Memory installed and enabled.

Let’s start by doing a clean install of 12.1.0.2 and allowing the installer to create a typical single instance database.

[Read More]
About

The Oracle Database In-Memory blog is written by the Oracle product management team and sheds light on all things In-Memory.

Search

Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
10
11
12
13
14
15
16
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today