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.
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