Netezza Review

It has the capacity to handle terabytes of data with query response times that are very low. Setup is complex.


Valuable Features

Personally, I like the Compression and Partitioning features.

Improvements to My Organization

It has the capacity to handle terabytes of data with query response times that are very low. This has helped us a lot.

Room for Improvement

It’s a good product for analytical processing, but they need to conduct more seminars and hands-on training and events. They need to be showcasing the product and features to create awareness among businesses.

Use of Solution

I have been working on it for the last two-and-a-half years and now we are in process of a tech refresh. We’re moving from the old Netezza to the newer IBM Pure Data Analytics, using a quarter of the rack for Pure Data.

Deployment Issues

No issues encountered with deployment.

Stability Issues

No issues encountered with stability.

Scalability Issues

No issues encountered with scalability.

Customer Service and Technical Support

They're very good, helpful, and knowledgeable.

Previous Solutions

It’s a complex setup.

Initial Setup

It was handled by the vendor as it's proprietary.

Other Advice

It's fit for the purpose it's designed for. It's an analytical/hierarchical database, now in great demand, that can store plenty of data and return the results in no time for complex queries.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 Comment
Business Unit technical Lead at a tech services company with 1,001-5,000 employeesReal User

If you are talking about when IBM comes in initially and does the setup I can see your point it is complex. If you are talking about the upgrade of the os and the dbos (database operating system) that can be fairly complex especially when you have HA (high availability) option on your server. There is a lot of things the IBM tech has to go through usually both os upgrade and then the dbos. Typically IBM will do a fail over doing the upgrade. I have watched them (through webex) during these upgrades and there are a lot of things they have to go through.

Database and table setup Netezza is about as easy as they come. There are classes that IBM offers around basic database and server care. Also a class on interpreting explain plans. There are other vendors that offer classes as well on these topics. There is plenty of material on the internet that offers some advice and help on some of these topics. There is a forum available at IBM that is available just search it up on google. The forum will occasionally offer "Enzee" (free) around Netezza and there are tons of blogs available around care and maintenance.

The biggest event that IBM Insight is available and there are many presentations and certification can be done during the conference.

Good luck

18 December 15
Guest
Sign Up with Email