BigQuery vs IBM Netezza Performance Server comparison

Cancel
You must select at least 2 products to compare!
Google Logo
3,568 views|2,604 comparisons
100% 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 BigQuery and IBM Netezza Performance Server based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed BigQuery vs. IBM Netezza Performance Server Report (Updated: March 2024).
768,857 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
"The product is serverless. We only need to write SQL queries to analyze the data. We need to pay based on the number of queries. The retrieval time is very less. Even if you write large queries, the tool is able to bring back data in a few seconds.""As a cloud solution, it's easy to set up.""BigQuery is a powerful tool for managing and analyzing large datasets. The versatility of BigQuery extends to its compatibility with external data visualization tools like Power BI and Tableau. This means you not only get query results but can also seamlessly integrate and visualize your data for better insights.""The most valuable features of this solution, in my opinion, are speed and performance, as well as cost-effectiveness.""We basically used it to store server data and generate reports for enterprise architects. It was a valuable tool for our enterprise design architect.""One of the most significant advantages lies in the decoupling of storage and compute which allows to independently scale storage and compute resources, with the added benefit of extremely cost-effective storage akin to object storage solutions.""It stands out in efficiently handling internal actions without the need for manual intervention in tasks like building cubes and defining final dimensions.""We like the machine learning features and the high-performance database engine."

More BigQuery Pros →

"The performance is most important to me, and it helps our ability to make business decisions quickly.""The most valuable feature would be the fact that it has been running for awhile in an appliance format.""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.""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.""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.""IBM Netezza Performance Server is a cost-effective solution.""The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."

More IBM Netezza Performance Server Pros →

Cons
"The main challenges are in the areas of performance and cost optimizations.""We'd like to see more local data residency.""It would be helpful if they could provide some dashboards where you can easily view charts and information.""Some of the queries are complex and difficult to understand.""When it comes to queries or the code being executed in the data warehouse, the management of this code, like integration with the GitHub repository or the GitLab repository, is kind of complicated, and it's not so direct.""An area for improvement in BigQuery is its UI because it's not working very well. Pricing for the solution is also very high.""There are some limitations in the query latency compared to what it was three years ago.""It would be beneficial to integrate additional tools, particularly from a business intelligence perspective."

More BigQuery Cons →

"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.""The scalability is not as expected. The capacity in the black box is not enough.""LIke Teradata, we can’t add a node/SPU to the existing appliance.""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.""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.""IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available.""Concurrency limit needs to be increased somewhat.""The only issue is that it's not expandable."

More IBM Netezza Performance Server Cons →

Pricing and Cost Advice
  • "I have tried my own setup using my Gmail ID, and I think it had a $300 limit for free for a new user. That's what Google is offering, and we can register and create a project."
  • "BigQuery is inexpensive."
  • "One terabyte of data costs $20 to $22 per month for storage on BigQuery and $25 on Snowflake. Snowflake is costlier for one terabyte, but BigQuery charges based on how much data is inserted into the tables. BigQuery charges you based on the amount of data that you handle and not the time in which you handle it. This is why the pricing models are different and it becomes a key consideration in the decision of which platform to use."
  • "The price is a bit high but the technology is worth it."
  • "The price could be better. Usually, you need to buy the license for a year. Whenever you want more, you can subscribe to it, and you can use it. Otherwise, you can terminate the license. You can use it daily or monthly, and we use it based on a project's requirements."
  • "The solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."
  • "BigQuery pricing can increase quickly. It's a high-priced solution."
  • "The pricing is good and there are no additional costs involved."
  • More BigQuery 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 Cloud Data Warehouse solutions are best for your needs.
    768,857 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:The initial setup process is easy.
    Top Answer:They could enhance the platform's user accessibility. Currently, the structure of BigQuery leans more towards catering to hard-code developers, making it less user-friendly for data analysts or… 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
    5th
    Views
    3,568
    Comparisons
    2,604
    Reviews
    31
    Average Words per Review
    502
    Rating
    8.1
    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
    Netezza Performance Server, Netezza
    Learn More
    Overview

    BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google's infrastructure. ... You can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data.

    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
    Information Not Available
    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
    Financial Services Firm11%
    Comms Service Provider11%
    Computer Software Company11%
    Wellness & Fitness Company6%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Financial Services Firm13%
    Manufacturing Company11%
    Retailer7%
    REVIEWERS
    Financial Services Firm37%
    Retailer16%
    Comms Service Provider11%
    Insurance Company11%
    VISITORS READING REVIEWS
    Educational Organization65%
    Financial Services Firm8%
    Computer Software Company5%
    Insurance Company3%
    Company Size
    REVIEWERS
    Small Business31%
    Midsize Enterprise21%
    Large Enterprise48%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise13%
    Large Enterprise67%
    REVIEWERS
    Small Business18%
    Midsize Enterprise9%
    Large Enterprise74%
    VISITORS READING REVIEWS
    Small Business5%
    Midsize Enterprise69%
    Large Enterprise26%
    Buyer's Guide
    BigQuery vs. IBM Netezza Performance Server
    March 2024
    Find out what your peers are saying about BigQuery vs. IBM Netezza Performance Server and other solutions. Updated: March 2024.
    768,857 professionals have used our research since 2012.

    BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews while IBM Netezza Performance Server is ranked 10th in Data Warehouse with 33 reviews. BigQuery is rated 8.2, while IBM Netezza Performance Server is rated 8.0. The top reviewer of BigQuery writes "Expandable and easy to set up but needs more local data residency". 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". BigQuery is most compared with Snowflake, Teradata, Oracle Autonomous Data Warehouse and Vertica, whereas IBM Netezza Performance Server is most compared with Oracle Exadata, Oracle Database, Snowflake, Teradata and SQL Server. See our BigQuery vs. IBM Netezza Performance Server report.

    See our list of best Cloud Data Warehouse vendors.

    We monitor all Cloud Data Warehouse 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.