IBM Informix vs IBM Netezza Performance Server comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
100 views|61 comparisons
85% willing to recommend
IBM Logo
2,651 views|1,497 comparisons
93% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Informix and IBM Netezza Performance Server based on real PeerSpot user reviews.

Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database.
To learn more, read our detailed Embedded Database Report (Updated: March 2024).
767,847 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"For IoT business cases, having Informix Enterprise Edition work on edge computers, like Raspberry Pi and using Informix replication, makes complex situations simple to build and maintain.""The solution's stability, performance, enhanced functionality, and replication are all great features.""IBM Informix benefits users with high availability and good integration capabilities.""It supports in-house-built applications in .NET and VB6""Replication, all levels of replication, query charting, and the MongoDB embedded are the most valuable features of this solution.""The stability is incredible. I have customers with uptimes of several years.""Every version is faster than the previous.""It supports multiple applications and business intelligence tools."

More IBM Informix Pros →

"The underlying hardware that IBM provides with this appliance is made for a specific purpose, to serve performance on a large amount of data, and to do analytics as well. It is faster, when you compare it to any other product.""The benefit is really because of the additional speed that we have and, truth be told, the more updated ETL processes and the revamped scheduler in general.""The performance is most important to me, and it helps our ability to make business decisions quickly.""The data governance prospect... from what I've seen, that is a really powerful tool as well, to help with data lineage and keeping track of that.""The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance.""The most valuable feature would be the fact that it has been running for awhile in an appliance format.""Distribution concurrency control.""We are able to execute very complex queries. Over 90 percent of our query executions are one second or less. We do millions of queries everyday."

More IBM Netezza Performance Server Pros →

Cons
"In my opinion, the packages could be improved. The version I use doesn't allow for packages. I can do some general procedures, but no packages like in Oracle. So, develop separate modules in SQL language. This would be most beneficial for me.""This product could be made easier to use for beginners.""I would like to see backups from secondary servers.""The technical support services need substantial improvement.""There should be more intelligence surrounding discovering data to be able to automatically create indexes.""The solution lacks some functionality.""I experienced poor input/output (IO) performance.""This solution is in need of more current tools."

More IBM Informix Cons →

"We are not able to scale. The only way to scale is to get another appliance, but we have a customers who would need us to hydrate the data between the two appliances, and Netezza does not do that.""Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server.""Our main problem with it is concurrency. When there are too many users running Netezza at the same time, this is when we have the most complaints.""LIke Teradata, we can’t add a node/SPU to the existing appliance.""The scalability is not as expected. The capacity in the black box is not enough.""IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available.""In terms of features that I would like to see, one is the ability to actually scale out an architecture. Right now, if you buy one, it's fixed. There is no scale-up availability at all.""Concurrency limit needs to be increased somewhat."

More IBM Netezza Performance Server Cons →

Pricing and Cost Advice
  • "The free edition can be enough to handle moderate-size implementations, but you may want a pay for edition to benefit from more functionality, such as replication."
  • "I am not aware of the licensing costs or terms."
  • "For me, it's always too expensive."
  • "The product has reasonable pricing. We purchase its yearly license."
  • More IBM Informix Pricing and Cost Advice →

  • "Netezza is a costly solution. It does serve a specific purpose but it's costlier than what's available in the market, if you go to the cloud."
  • "The pricing is very expensive. It has a lot CPUs with a lot of components in it. It also has built-in redundancy for resiliency reasons."
  • "The solution has a yearly licensing fee, and users have to pay extra for support."
  • More IBM Netezza Performance Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
    767,847 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:It supports multiple applications and business intelligence tools.
    Top Answer:The product has reasonable pricing. We purchase its yearly license.
    Top Answer:The key areas for improvement revolve around understanding the current customer trends and demands, particularly in software and database requirements. The product's performance could be better… more »
    Top Answer:IBM Netezza Performance Server is a cost-effective solution.
    Top Answer:The solution has a yearly licensing fee, and users have to pay extra for support.
    Top Answer:Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server.
    Ranking
    6th
    out of 14 in Embedded Database
    Views
    100
    Comparisons
    61
    Reviews
    5
    Average Words per Review
    394
    Rating
    7.0
    10th
    out of 34 in Data Warehouse
    Views
    2,651
    Comparisons
    1,497
    Reviews
    2
    Average Words per Review
    334
    Rating
    7.0
    Comparisons
    Also Known As
    Informix
    Netezza Performance Server, Netezza
    Learn More
    IBM
    Video Not Available
    Overview

    IBM Informix is a widely used and scalable relational database management system designed to handle large amounts of data and high transaction volumes. It is known to provide exceptional performance, thanks to its Parallel Data Query Engine (PDQ) that enables parallel processing of queries and operations, significantly reducing response times for complex queries and large data sets. Additionally, Informix supports online operations like backup, restore, index maintenance, and table reorganization, minimizing downtime and ensuring continuous availability.

    Informix provides robust high availability and replication features, including shared-disk clustering, remote data replication, and high-availability data replication (HDR). These features ensure data redundancy, failover protection, and disaster recovery capabilities, making it a reliable choice for mission-critical applications. Furthermore, Informix offers specialized features for data warehousing and analytics, such as in-database analytics, data compression, and parallel load capabilities, making it suitable for business intelligence (BI) and data analysis applications.

    Informix can be deployed as an embedded database, allowing it to be tightly integrated with applications and systems, reducing overhead and simplifying deployment. It includes workload management capabilities, enabling organizations to prioritize and manage different types of workloads, such as online transaction processing (OLTP) and analytical queries, ensuring efficient resource utilization and meeting service-level agreements (SLAs). Informix also provides robust security features, including role-based access control, data encryption, auditing, and compliance with industry standards like FIPS 140-2 and Common Criteria.

    IBM Netezza appliances are now part of IBM PureSystems - expert integrated systems with built in expertise, integration by design and a simplified user experience. Part of the PureData family, the Netezza appliance is now known as the PureData System for Analytics. It has the same key design tenets of simplicity, speed, scalability and analytics power that was fundamental to Netezza appliances.
    Sample Customers
    Shaspa, Hildebrand, Kaifa, Ranhill Powertron, Federaci‹ Farmacutica (FedeFarma), Camden Council, The German Aerospace Center (DLR), Myers, Votorantim Group, Doosan Infracore, GreenIvory
    Seattle Childrens Hospital, Carphone Warehouse, Vanderbilt University School of Medicine, Battelle, Start Today Co. Ltd., Kelley Blue Book, Trident Marketing, Elisa Corporation, Catalina Marketing, iBasis, Barnes & Noble, Qualcomm, MediaMath, Acxiom, iBasis, Foxwoods
    Top Industries
    REVIEWERS
    Energy/Utilities Company22%
    Logistics Company11%
    Outsourcing Company11%
    Transportation Company11%
    VISITORS READING REVIEWS
    Educational Organization53%
    Financial Services Firm5%
    Retailer5%
    Computer Software Company5%
    REVIEWERS
    Financial Services Firm37%
    Retailer16%
    Comms Service Provider11%
    Insurance Company11%
    VISITORS READING REVIEWS
    Educational Organization65%
    Financial Services Firm9%
    Computer Software Company5%
    Insurance Company3%
    Company Size
    REVIEWERS
    Small Business53%
    Midsize Enterprise12%
    Large Enterprise35%
    VISITORS READING REVIEWS
    Small Business9%
    Midsize Enterprise59%
    Large Enterprise31%
    REVIEWERS
    Small Business18%
    Midsize Enterprise9%
    Large Enterprise74%
    VISITORS READING REVIEWS
    Small Business5%
    Midsize Enterprise68%
    Large Enterprise26%
    Buyer's Guide
    Embedded Database
    March 2024
    Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database. Updated: March 2024.
    767,847 professionals have used our research since 2012.

    IBM Informix is ranked 6th in Embedded Database with 16 reviews while IBM Netezza Performance Server is ranked 10th in Data Warehouse with 33 reviews. IBM Informix is rated 8.6, while IBM Netezza Performance Server is rated 8.0. The top reviewer of IBM Informix writes "Quite stable and flexible but not very innovative". On the other hand, the top reviewer of IBM Netezza Performance Server writes "A cost-effective data warehousing tool, but security features like TDE encryption are missing". IBM Informix is most compared with Oracle Database, SQL Server, IBM Db2 Database, MySQL and MariaDB, whereas IBM Netezza Performance Server is most compared with Oracle Exadata, Snowflake, Oracle Database, Teradata and SQL Server.

    We monitor all Embedded Database reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.