Friday 4 November 2011

About Netezza

If you say Netezza is a Data Warehousing database, stop a minute...

Netezza designs and markets high-performance data warehouse appliances and advanced analytics applications for uses including enterprise data warehousing, business intelligence, predictive analytics and business continuity planning.

Netezza is widely credited for either inventing or bringing renewed attention to the data warehouse appliance category, depending upon whether one regards long-time data warehouse technology vendor Teradata as having been in the data warehouse appliance category all along.

To know about Netezza, we first need to know the architecture of Netezza. There is a major change in architecture from Version 4.5 to 5.0. Lets have a look of how Netezza 5.0 architecture looks like:
As the picture describes P12 box has 2 storage array, 2 SMP hosts and 2 S-Blade Chassis. Now when we look into each part we get the internal structure.
Each storage array has 4 disk enclosure, each disk enclosure has 12 disk of 1TB each, so total 48(12*4=48), among which 2 are spare.
Each S-Blade chassis has 6 S-Blade. Each S-Blade has 8 CPU core, 8 FPGA Engines, 4 SAS 3GB connection to 8 disk drive, 4 1GB Ethernet links and 16 GB RAM.
So 6 S-Blade has 48 CPU core, 48 FPGA connected to 48 Disk drives (1:1:1 correspondance).

I will be keep posting about the architecture but from later posting I will mostly concentrate on Netezza SQL, PL/SQL and administrative part.

No comments:

Post a Comment