Tuesday, 16 July 2013

Oracle Exalytics Architecture

What is unique about Exalytics? Why Exalytics can offer performance improvements which other machine can’t? Architecture? Software? Or Hardware?  There are many questions regarding Exalytics which require simple explanations.  
In my view the performance improvements to Exalytics are attributed to
  • Massive hardware resources and memory for processes
  • Huge in-memory result cache
  • In-memory query processing
  • In-memory columnar compression
  • Aggregations
In short there are various aspects of Exalytics which are contributing to overall result. This blog is an attempt to explain Oracle Exalytics Architecture is a simplified manner to start with, I am planning to cover the details in future blogs.
Exalytics Architecture
The architecture for the Exalytics Machine is shown below. The Exalytics Machine includes software for the Oracle TimesTen In-Memory Database, Oracle Business Intelligence, and the Administration Server and Managed Server for Oracle Web Logic Server. The Exalytics Machine is connected to a client computer on which the Oracle BI Administration Tool runs, including the Summary Advisor wizard. Another computer holds the database on which schemas that are created with the Repository Creation Utility reside, including usage tracking summary statistics.

 The following software features are licensed with Oracle Exalytics In-Memory Analytics.

Features
Product
Description
Summary Advisor
Oracle Business Intelligence Administrator
Summary Advisor monitors Business Intelligence usage patterns, analyzes them and recommends the optimal data mart for best overall performance improvement.
Aggregate Persistence (CREATE AGGREGATES, and DELETE AGGREGATES commands) when run against the TimesTen In-Memory Database for Exalytics
Oracle Business Intelligence Server
The Aggregate Persistence feature enables automated creation of data marts by using Business Intelligence server commands.
Exalytics-specific optimizations enabled by "Oracle Hardware acceleration" flags
Oracle Business Intelligence Server
Optimizations to match system architecture resulting in higher query throughput, lower latencies in query processing. Enhanced memory usage for cache.
Enhanced Bursting
Oracle Business Intelligence Publisher
Enables piped document generation. Enabled by setting OPTIMIZE_BURST flag in xmlp-server-config.xml file
Exalytics-specific optimizations enabled by "Oracle Hardware acceleration" flags
Oracle Business Intelligence Presentation Server
Optimized default configuration to use large footprint memory to speed up page rendering and caching.
Exalytics-specific optimizations enabled by "Oracle Hardware acceleration" flags
Oracle Essbase
Memory usage optimizations for loading entire data into memory, concurrency improvements to match Exalytics architecture enabling efficient distribution of processing.

The latest release for Exalytics Hardware and Software details are as follows.
X3-4 - Exalytics Hardware
Memory - 2 TB RAM, 1033 MHz
Compute - 4 Intel® Xeon® E7-4870, 40 cores total
Networking - 40 Gbps InfiniBand – 2 ports/10 Gbps Ethernet – 2 ports /1 Gbps Ethernet – 4 ports
Storage - 5.4 TB HDD Capacity

X3-4 - Exalytics Software & Features
  • Base Image – 1.0.0.5
    •  Flash support
  • OBI Foundation Suite for Exalytics (11.1.1.7)
    • Visualizations, Mobile
    •  Measure Subsets – smaller aggregates.
    •  Model Checker enhancements
    •  BI Publisher – Bursting optimizations
  •  TimesTen (11.2.2.5)
    •  Star Join Optimizations
    •  Native data loader from Oracle
    •  Faster compressed loads
    •  Hash indexes on non-primary key
  •  EPM 11.1.2.3 certification
  •  Endeca 3.0 Certification
  •  Manageability
    • EM Target for Exalytics
Welcome to world of Exalytics…  

No comments:

Post a Comment