Netezza Review

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

Valuable Features

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

Improvements to My Organization

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

Room for 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.

Use of Solution

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

Deployment Issues

Some minor SPU communication issues with IP protocol.

Stability Issues

No issues encountered.

Scalability Issues

No issues encountered.

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.

Previous Solutions

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.

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.

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.

Other Solutions Considered

We also looked at Teradata.

Other Advice

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
Sign Up with Email