Scribd
Upload
11 views36 pages

Netezza Architecture and Best Practices

The document discusses Netezza architecture and data distribution. It covers topics like S-Blade architecture, data slicing, query optimization techniques including data distribution, join types, statistics, zone maps, clustered tables and materialized views. It provides best practices for setting distribution keys, managing statistics, and using GROOM for disk space management in Netezza.

Uploaded by

Smitha Reddy
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views36 pages

Netezza Architecture and Best Practices

The document discusses Netezza architecture and data distribution. It covers topics like S-Blade architecture, data slicing, query optimization techniques including data distribution, join types, statistics, zone maps, clustered tables and materialized views. It provides best practices for setting distribution keys, managing statistics, and using GROOM for disk space management in Netezza.

Uploaded by

Smitha Reddy
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Netezza

Presented By Aslam Husain, Aviana Global

Architecture in a Nutshell

S-Blade Nothing Shared Architecture

Snippet Processing

Twin Fin Processing

Data Slice

Data Slice Data Distribution

Query Optimization

A. Data Distribution B. Statistics C. Zone Map D. Cluster Based Table E. Materialized Views F. Groom

Data Distribution: Overview

Data Distribution: Performance

Boolean Distribution

Distribution and Processing Skew

Collocated Join

Single Redistribute

Double Redistribute

Broadcast

Distribution Key: Data Type

Multi-Column Distribution

Random Distribution

Distribution Scenarios: Using Emulator

Distribution Practices:

A.

Rule of Thumb: Default the distribution key to the primary key


for a dimension table, and for a fact table the foreign key of the largest dimension it joins to.

B.

Bad Practices:

Statistics: Automatic

Statistics: Practices

Query Performance Analysis

Bad Performance Reason

Zone Maps and Extent

Zone Maps: Avoid IO

Zone Maps: Data Types

Zone Maps: Update

Clustered Based Table

Materialized Views

Materialized Views: Restrictions

GROOM

Netezza: Disk Space Management

GROOM Usages Practices

References:

IBM Partners Resources IBM Netezza Emulator [Link]

You might also like