Please share with the community what you think needs improvement with Netezza Analytics.
What are its weaknesses? What would you like to see changed in a future version?
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.
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.
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.
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.
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.