DB2 for z/OS

DATE: 2010-5-13 (02:45 PM - 03:45 PM)
SPEAKERS: Guy Lohman (IBM)

The IBM Smart Analytics Optimizer for DB2 for z/OS, V1.1 is a revolutionary special-purpose, main-memory database engine that was invented by IBM Research for accelerating Business Intelligence queries to a portion of a data warehouse on DB2 for z/OS. Come find out how the IBM Smart Analytics Optimizer exploits disruptive industry trends such as multi-core architectures and inexpensive main memories in often counter-intuitive ways, enabling massive parallelism and significantly speeding Business Intelligence SQL queries without any need for the usual tuning of a "performance layer" (indexes and materialized views) or even a query optimizer!

EXP. LEVEL: Intermediate

OBJECTIVES:

What and Why IBM Smart Analytics Optimizer is, and what its target market is (BI)

Architecture of the IBM Smart Analytics Optimizer

What is so disruptive about the technology used in the IBM Smart Analytics Optimizer

A basic understanding of how the IBM Smart Analytics Optimizer exploits industry trends such as multi-core processors and large main memories, and proprietary compression, to speed queries by 10x - 100x.

Startling performance results!