If you are performing PoC to choose between the Netezza and Redshift, then the common question arises which one is better compared to other. In this article, we will check Netezza and Redshift Comparison – Netezza vs Redshift.
These two data warehouse appliances have their own advantages and disadvantages. We will try to compare the features and difference between Netezza and Redshift.
Read: Hadoop and Netezza Comparison – Netezza vs Hadoop
Netezza Data Warehouse Appliance Features
Read: Netezza TwinFin Architecture
Following are some of the feature on Netezza data warehouse appliance:
- IBM Netezza is a data warehouse appliance that is built on MPP technology.
- IBM Netezza is a traditional data warehouse appliance that supports traditional SQL statements such as DML, DDL statements. i.e. Inserts, updates, ACID properties.
- Netezza is based on the MPP technology and is a gigabyte scale data warehousing appliance.
- Make use of the proprietary FPGA tool to filter out unwanted data while reading from disk.
- Depending on the number of SPUs or S-blades, Netezza can handle gigabytes of data and process it at super fast speed.
- Netezza supports distribution on column(s) or randomly. The data is distributed on multiple SPUs and they all work together to achieve the high speed data processing.
- Netezza System Administration overhead is very less compared to other RDBMS such as oracle, DB2 etc.
- IBM provides the Emulator to learn and study the Netezza data warehouse appliance.
- Netezza is mainly used to analytics purpose that involves the structured data.
- Netezza will not work best with semi-structured or un-structured data.
Amazon Redshift Data Warehouse Appliance
Read: Amazon Redshift Architecture
Following are some of the feature on Redshift data warehouse appliance:
- Amazon Redshift is petabyte scale data warehouse appliance. As per your requirement you can scale the environment.
- Redshift is a columnar storage database.
- Just like Netezza, Redshift is also traditional data warehousing and SQLs supported based on postgreSQL.
- Redshift is also built on the MPP environment just like Netezza. It can handle volume even greater than Netezza.
- Amazon Redshift is on the cloud and minimal administration required. Amazon monitors the system administration.
- Based on your needs, you can easily scale the nodes (computing power ) and space can be added with some mouse clicks.
- Amazon charges based on the number of nodes and space utilized.
- Easy to create data snapshots and bring the redshift cluster up and down as and when required.
- There is no emulator available as of now.
- Sometimes it may faces security issues to get data out of your local network.
I while working across Netezza to Redshift migration project came across one significant difference . I was able to see that Redshift wasn’t able to use the values of previously derived columns though we can do it very easily in Netezza . Hence as a work around we build CTE in Redshift to handle the issue .
Ravi, can you please let me know your findings on converting from Netezza to Redshift? I want to propose that solution to my team as well but I just want to do my homework first. Thank you
Hi,
Derived columns are columns that are derived from previously calculated columns. Below example will give you clear idea.
select col1,
col2*10 as col2_1,
Col2_1*100 as col3_1
from some_table;
You can see in above example col3_1 uses previously derived column col2_1 for the calculations. This type of calculation is not supported in Redshift.
Thanks