Netezza Review

It's an easy-to-use data warehouse appliance, but it doesn't support correlated queries.


What is most valuable?

  • Zonemap features
  • AMPP (SMP+MPP ) architecture
  • High availability
  • Field-Programmable Gate Arrays (FPGAs)

How has it helped my organization?

The Netezza deployment is easy, and there is less administration and coding than in other databases.

What needs improvement?

  • Correlated queries are not supported.
  • Concurrency - the performance dips with number of concurrent queries; for example, if more than 48 queries are run concurrently, it queues up.
  • Scalability - if the data increases, you need to go for a bigger appliance as you cannot add to Netezza incrementally.

For how long have I used the solution?

I've used it for two-and-a-half years.

What was my experience with deployment of the solution?

Some minor SPU communication issues with IP protocol.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

They deliver the products to customers faster and with greater accuracy, i.e. within the agreed-upon due date.

Technical Support:

Netezza already had a excellent customer satisfaction and the rating would be 8/10.

Which solution did I use previously and why did I switch?

We previously used Oracle then migrated to Netezza because its deployment is easy, and there is less administration and coding when compared to Oracle. Also, the query performance is excellent in Netezza.

How was the initial setup?

It is very straightforward because Netezza's initial setup took less than two days and the entire data set was loaded onto the Netezza appliance to which users had full access to the system.

What's my experience with pricing, setup cost, and licensing?

Netezza is an easy-to-use data warehouse appliance. It's extremely fast with a low cost and the customers run their BI and advanced analytics in a very flexible manner.

Which other solutions did I evaluate?

We also looked at Teradata.

What other advice do I have?

Netezza should have enough advantages with implementation, i.e time to deployment, price, performance, and the ability to integrate with the existing environment.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest