Optimize Oracle BI with Oracle 12c in-memory Database option

26 Pages·2015·1.94 MB·English

by  Kat Seiffert

Optimize Oracle Business Intelligence Analytics
with Oracle 12c In-Memory Database option

Prepared by:
Kai Yu
Senior Principal Architect,
Dell Oracle Solutions Engineering
REMINDER
@ky_austin Check in on the
COLLABORATE mobile app
About Author
Kai Yu, Senior Principal Architect, Dell Database Engineering
 20 years Oracle DBA/Apps DBAS and Solutions Engineering
 Specializing in Oracle RAC, Oracle VM and Oracle EBS
 Oracle ACE Director, Oracle papers author/presenter
 2011 OAUG Innovator of Year, 2012 Oracle Excellence
Award: Technologist of the Year: Cloud Architect by Oracle
Magazine
 My Oracle Blog: http://kyuoracleblog.wordpress.com/
 Co-author Apress Book “Expert Oracle RAC 12c”
My Work
:Dell Integrated Systems for Oracle Business Analytics
-Ready Infrastructure Solution
U42 42 42
U41 41 Force10 750W 0 1 750W 41 2 x S6000 40GbE TOR
0 1
U40 40 Force10 750W 0 1 750W 40 Switches (Public & Private)
0 1
U39 39 39 1 x S60 Management Switch
U38 38 38 Management Server (R320)
U37 37 37 OBIEE Server (R730)
U36 36 36
U35 35 35
U34 34 34
U33 33 33
U32 32 32
U31 31 31
U30 30 30
21U
U29 29 29
U28 28 28
U27 27 27
U26 26 26
U25 25 25
U24 24 24 Database Server (R920)
U23 23 45 89 1123 23
U22 22 6 10 14 22
U21 21 KMM FPM185 21 KMM
U20 20 20
U19 19 19
Database Server (R920)
U18 18 45 89 1123 18
U17 17 6 10 14 17
U16 16 16 2 x Brocade 6510 16Gbps FC
U15 15 15 Switches
U14 14 14
U13 13 13 2 x Dell Acceleration
U12 12 12 Appliances for Databases (HA)
U11 11 11
U10 10 10
U09 09 09
U08 08 08
U07 07 07
U06 06 06
U05 05 05
U04 04 04
U03 03 03
U02 02 02
U01 01 01
Agenda
■ Oracle 12c Database In-Memory Option
■ Oracle Business Intelligence Enterprise Edition 11g
■ Oracle Exalytics In-Memory vs 12c In-Memory Database
■ Oracle OBIEE with Oracle 12c In-Memory Database
■ Questions
Oracle 12c In-Memory Option
This is a subtitle or bulleted list
Oracle 12c In Memory Option
■ Oracle 12c Database Introduced Database In-Memory option:
• Accelerates analytics by orders of magnitude .
• Speeding up mixed-workload OLTP.
• Transparent to applications.
■ Dual-Format of Architecture in Oracle 12
▪ Oracle traditional row based :
– Row format data stored in storage
– Row format data stored in buffer cache in SGA
– Good for OLTP (insert/update/delete) operations
▪ Oracle 12c introduced In-memory option
– Introduced with Oracle 12.1.0.2
– Column format In-Memory column storage in SGA
– A New component of Oracle Database SGA.
– Coexist with database buffer cache (row format)
– Good for OLAP applications
Oracle 12c In-Memory Option
■ The Dual Format Architecture can be illustrated as

■ The In-Memory Column Store:
▪ A new component called In-Memory Area in SGA
;
SQL> alter system set inmemory_size = 100G scope=spfile

Alter SYSTEM SET INMEMORY_QUERY=DISABLE
Alter SYSTEM SET INMEMORY_QUERY=ENABLE
Oracle 12c In-Memory Option
■ Select contents to populate the In-Memory column store:
▪ Tableaspace level: alter tablespace data MEMORY;
▪ Table level: alter table sales INMEMORY PRIORITY CRITIAL;
alter table sales INMEMORY NO INMEMORY(prod_id)
▪ background process to populate in-memory store:

■ Features to accelerate query execution: In-Memory Scan, In-Memory Storage Index,
SIMD Vector Processing, In-Memory Joins, in Memory Aggregation
■ In Memory Option: Application transparent, no need to modify application .
■ How to determine if In-Memory option takes effect. Look the INMEMORY key work in
query plan such as :
Oracle Business Intelligence
Enterprise edition 11g

This is a subtitle or bulleted list
Oracle Business Intelligence Enterprise edition 11g

■ Oracle OBIEE: Business intelligence and Analytics Platform and common infrastructure
for reports, scorecards, dashboards, ad-hoc analysis, OLAP analysis
▪ OBIEE 11g Interactive Dashboards solution for Interactive Dashboards
▪ Ad hoc Analysis and Interactive Reporting
▪ Oracle BI Mobile for Mobile Analytics
▪ Oracle Business Intelligence Publisher for Enterprise Reporting.