Netezza Analytics Room for Improvement

SK
Project Manager at MAF Retail

This product is being discontinued from IBM, and I would like to have some kind of upgrade available.

Scalability of this solution is not possible.

I would like to see a better graphical user interface for database management.

View full review »
RB
Manager-Projects,Data Analyst & DBA at a tech services company with 10,001+ employees

Administration of this product is too tough. It's very complex because of the tools which it's missing. We would require better tools for doing administration. For example, if I need to get a permission of a user on a particular object, it is so complex. It's not straightforward. It would not give me a display of that particular element. Basically auditing is tough to do on it. If I don't have a graphical tool, the auditor will ask me thousands of questions.

View full review »
it_user371382 - PeerSpot reviewer
Senior Analytics Specialist - BI Enterprise Design + Development at a retailer with 1,001-5,000 employees

We are using an older version. Some improvements are already implemented, such as the addition of neural networks. Other improvement would be to make the existing algorithms even faster, e.g. kmeans can actually be parallelized. If this reworking of the algorithm is done, it should leverage the MPP architecture of Netzza and run much faster.

Also, some algorithms are faster than almost any other method or system e.g. NZA.ARULES() function. Whereas others are not as fast and could probably be optimized for an MPP architecture like kmeans function.

View full review »
Buyer's Guide
Netezza Analytics
April 2024
Learn what your peers think about Netezza Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.
Asish Govind - PeerSpot reviewer
Principal Solution Architect at Tech Mahindra Limited

I'm not sure if Netezza offers a cloud version of the solution or not, but if they don't they should. Most companies are focused on moving towards the cloud. If it was on a cloud it would offer certain scalability and performance aspects it can't offer as a physical appliance.

I'm not sure of IBM's roadmap currently, as the solution is coming up on its end of life.

View full review »
it_user743016 - PeerSpot reviewer
Senior Enterprise Architect at a retailer with 10,001+ employees

Community support. There was none, or very little, especially when using add-on software (e.g. building functions, MapReduce, R, Lua, etc.).

Driver support for windows based applications.

Disaster recovery support. Because it was an appliance, and if you wanted to support disaster recovery, you needed to buy two.

Data center moves. The TwinFin was cool to look at, but moving was a huge orchestration. I would definitely go cloud if I was to choose something with this type of processing power.

View full review »
it_user265830 - PeerSpot reviewer
Senior Hadoop Engineer with 1,001-5,000 employees
  • Matching up with big data.
  • Netezza has been built only for OLAP and structured data, and I think IBM must do something to match it to Hadoop scalability.
View full review »
RS
Senior Consultant at a tech services company with 51-200 employees

Concurrency was an issue. If you run small querries it runs well, and the performance is good. However, when you run multiple long querries or multiple joins, it has some concurrency issues, except for some date covers and some configuration requirements.

Scalability can be improved. When I say that I can add new nodes to the system, compared to other systems, you have to come up with a new box, and not everybody likes that.

In the next release, I would like to see the scalability and concurrency issues resolved. Also, the joining rate features against the swap phase issues need to be addressed.

In regards to the swap phase, if you have less cred then your swaps go down, and your system gets restarted every time, which affects the query files. It should not get restarted. Swap memory issues should be improved.

The Analytics feature should be simplified. Everyone is talking about machine learning aspects and people go for the data mart appliance. The portfolio is built for the data storage and the data is accessed frequently. People would like it to be easier.

View full review »
AM
System Administrator at a tech services company with 1,001-5,000 employees

I'm not an administrator, so I can't speak to the solution on a deeper level. For me, everything works well.

The solution could implement more reporting tools and networking utilities.

View full review »
it_user743820 - PeerSpot reviewer
Project Manager

In-DB processing with SAS Analytics, since this is supposed to be an analytics server so the expectation is there.

View full review »
it_user256923 - PeerSpot reviewer
Senior Information Management Consultant at a retailer with 51-200 employees

It needs a better in-house development tool.

View full review »
it_user1187964 - PeerSpot reviewer
Senior Consultant at a tech services company with 51-200 employees

The hardware has a risk of failure. They need to improve this. It also needs a system re-index.

They should improve their Schema and base it on Snowflake Schema features.

The solution should offer backup and restore options on some features.

View full review »
Buyer's Guide
Netezza Analytics
April 2024
Learn what your peers think about Netezza Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.