Database Reference
In-Depth Information
design that simply scales from a few hundred gigabytes to tens of petabytes of
user data
that can be queried
. In fact, the system has been designed to be highly
adaptable, and to serve the needs of different segments of the data warehouse
and analytics market. The use of open blade-based components enables the
disk-processor-memory ratio to be easily modified in configurations that cater
to performance or storage-centric requirements. This same architecture also
supports memory-based systems that provide extremely fast, real-time analytics
for mission-critical applications. In the remainder of this chapter, we'll delve
into just how these design principles translate into practice.
What's in the Box? The Netezza Appliance
Architecture Overview
Netezza architecture is based on an asymmetric massively parallel process-
ing (AMPP) methodology that combines the best elements of symmetric mul-
tiprocessing (SMP) and MPP to create a purpose-built appliance for running
blazingly fast analytics on petabytes of data.
Slice of User Data
Swap and Mirror Partitions
High-Speed Data Streaming
Disk Enclosures
SQL, Query Plan,
Optimize, Admin
SMP Hosts
Processor & Streaming DB logic
Snippet Blades
(S-Blades)
High-performance database
engine, streaming joins,
aggregations, sorts, etc....
Figure 4-1
The IBM Netezza appliance (now known as the IBM PureData System for
Analytics)
