IBM Db2 Warehouse vs Oracle Exadata comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
1,047 views|614 comparisons
Oracle Logo
14,470 views|11,088 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Db2 Warehouse and Oracle Exadata based on real PeerSpot user reviews.

Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed IBM Db2 Warehouse vs. Oracle Exadata Report (Updated: November 2022).
654,218 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
"Some of the best features are stored procedures, parallelism, and different indexing strategies.""I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well.""The analytics engine is not bad at forecasting predictions.""It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."

More IBM Db2 Warehouse Pros →

"We have used this solution for a long period of time so it has become easy for us to query any kind of data from Oracle Exadata which has been valuable.""Oracle is known to be the number one in their industry; the help and support, the features they are giving the clients comparing to other databases, the new technology, the provide a good solution.""Exadata's best features are its performance during redo logging and the elasticity of the database handling.""The most valuable feature of Oracle Exadata is the integration with other solutions, such as SAN storage and shared VLAN network.""On-premises Exadata is just as stable as the cloud version. It's a very stable platform.""The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain.""We can use virtualization on Exadata.""The performance on the databases is good."

More Oracle Exadata Pros →

Cons
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting.""The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years.""The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web.""There should be more material available for training and training should be free."

More IBM Db2 Warehouse Cons →

"The customization can sometimes be difficult to achieve.""We have experienced some issues with processing unstructured data on Exadata. This is an important requirement for our AIML based use case. Reactive analytics data can not be prepared easily in Oracle Exadata.""The setup is a little bit complex. We would like to see the installation part get easier.""The initial setup process is very difficult and extremely complex.""Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or six clicks to find metrics, and sometimes it's a waste of time.""A room for improvement in Oracle Exadata is that it's not very easy to use in a microservices environment. It's not easy to split databases, and if this was easier to do in Oracle Exadata, it would make the solution better. What I'd like to see in the next release of Oracle Exadata is for it to become more modular, so you can use it in a context where the data layer is spread between many independent services.""Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly.""In a future release, I would like to see some upgrade analysis advisors to help with a clear roadmap on steps that need to be taken and some of the automated processes."

More Oracle Exadata Cons →

Pricing and Cost Advice
  • "In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
  • More IBM Db2 Warehouse Pricing and Cost Advice →

  • "The licensing can be a bit expensive because you need to have certain tools enabled that require them."
  • "The majority of our customers are in government or big enterprises, and the projects that we sell come out to several million USD. With this amount of money on the table, it's always better to have an experienced team of consultants, who know Exadata very well, handle the implementation."
  • "The price of the solution has been expensive to implement."
  • "The cost of the product could be improved."
  • "There is an annual license to use this solution. The solution is expensive."
  • "You have to pay for the storage and the database in Oracle Exadata. It cost a lot, but it is worth it. It would be a benefit if we could reduce the price for the number of CPUs and extend the memory."
  • "The price of Oracle Exadata is expensive. It is not competitive with other solutions some of the times."
  • "Oracle Exadata is not a cheap solution. Pricing is a problem for Oracle, and every client, not just my company, would like the vendor to improve on the price, or lower the price. My company paid for several years' worth of Oracle Exadata licenses. You need to pay for the technical support and other features separately, on different contracts. In terms of affordability, my rating for Oracle Exadata is two out of five."
  • More Oracle Exadata Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    654,218 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Some of the best features are stored procedures, parallelism, and different indexing strategies.
    Top Answer:In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side.
    Top Answer:The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting.
    Top Answer:The most valuable feature of Oracle Exadata is the smart scan. We have large TB sessions of approximately 100 per second for each of our three instances. The smart scan allows us the obtain data in… more »
    Top Answer:The price of Oracle Exadata is competitive. There are some features that are outside of the initial purchase license, such as some monitoring packages. I rate the price of Oracle Exadata a four out of… more »
    Top Answer:Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or… more »
    Ranking
    13th
    out of 31 in Data Warehouse
    Views
    1,047
    Comparisons
    614
    Reviews
    2
    Average Words per Review
    468
    Rating
    8.0
    2nd
    out of 31 in Data Warehouse
    Views
    14,470
    Comparisons
    11,088
    Reviews
    21
    Average Words per Review
    497
    Rating
    8.5
    Comparisons
    Also Known As
    InfoSphere Warehouse, IBM InfoSphere Warehouse
    Learn More
    Overview
    InfoSphere Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.

    Oracle Exadata allows enterprises to run any Oracle Database workload with the highest performance, scale, availability, and security on fully compatible cloud and on-premises infrastructure. Exadata uses a scale-out design with unique optimizations that include persistent memory, SQL query offload, and built-in resource management to optimize performance for OLTP, analytics, machine learning, and mixed workloads running in consolidated environments. By running hundreds or thousands of optimized Autonomous Database and Exadata Database instances on Exadata Cloud or Cloud@Customer infrastructure, customers are able to minimize their infrastructure, reduce management, improve developer productivity, and lower total costs by up to 40%, as described in Wikibon’s analysis (PDF).

    The main benefit of Exadata is its speed. It hosts operating systems, CPU memory, and hard drives. It runs all types of databases, including online transaction systems, processors, and data warehouses, while remedying the poor performances of older databases.

    Oracle Exadata features a simple and fast database storage system that protects and backs up your critical data. It accelerates data warehouse performance for faster access to business information and data. It is the ideal database solution for companies looking to build up their infrastructure from scratch.

    Oracle Exadata Database Machine Key Benefits

    • Rapid, reliable, and scalable deployment: Exadata is the most cost-efficient and highest performance platform for running Oracle databases. Exadata’s deployment is very straightforward since the database servers, storage servers, and network are pre-configured, pre-tuned and pre-tested by Oracle experts. This ensures that all your components work seamlessly together. Any Oracle Database application can be seamlessly migrated to and from the Exadata Database Machine, with no changes to the original application.

    • Powerful, cutting-edge hardware: Exadata is the most versatile database platform. It uses powerful database servers and a scaled-out, intelligent storage layer.

    • Accelerate database processing: Exadata Storage Server implements a unique, highly efficient database-optimized storage infrastructure that enables Exadata’s unparalleled performance without any of the bottlenecks that traditional storage experiences. Each storage server contains CPU processors that are used to offload database processing. The CPUs in the storage servers do not replace database CPUs, but work alongside them to accelerate database workloads.

    Reviews from Real Users

    Oracle Exadata stands out among its competitors for a number of reasons. Two major ones are its robust performance and its wide variety of database features that make it a comprehensive database solution.

    Adriano S., an IT system integrator at a financial services firm, writes, "Oracle Exadata's performance is one of its best features. We are very satisfied with it. The previous equipment used to make a payment for all the government employees used to take at least two days for some of the transactions. Now, it will take hours to make the same amount of payments. Another thing is the flexibility to organize all our databases. We can use it with new features that come with this version of Oracle 19c, which is the container database. With container databases, we can work with many databases, organized, and segregated, and still access the functions and management, the things that most of the technical people like to have in place."

    Paulo X., a sales manager at LTA-RH Informatica, notes, "Regarding features, there are so many that we can offer to customers. When we sell Exadata Cloud, there are many options to choose from, especially when it comes to enterprise database options. In my experience, the main features that are appreciated are various ones like GPS and the assortment of security options."

    Offer
    Learn more about IBM Db2 Warehouse
    Learn more about Oracle Exadata
    Sample Customers
    Alameda County Social Services Agency, Sui Southern Gas Company Limited
    PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company17%
    Financial Services Firm17%
    Comms Service Provider11%
    Insurance Company8%
    REVIEWERS
    Financial Services Firm28%
    Comms Service Provider17%
    Insurance Company13%
    Retailer8%
    VISITORS READING REVIEWS
    Computer Software Company22%
    Financial Services Firm21%
    Comms Service Provider10%
    Energy/Utilities Company6%
    Company Size
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise11%
    Large Enterprise70%
    REVIEWERS
    Small Business27%
    Midsize Enterprise10%
    Large Enterprise63%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise10%
    Large Enterprise76%
    Buyer's Guide
    IBM Db2 Warehouse vs. Oracle Exadata
    November 2022
    Find out what your peers are saying about IBM Db2 Warehouse vs. Oracle Exadata and other solutions. Updated: November 2022.
    654,218 professionals have used our research since 2012.

    IBM Db2 Warehouse is ranked 13th in Data Warehouse with 4 reviews while Oracle Exadata is ranked 2nd in Data Warehouse with 22 reviews. IBM Db2 Warehouse is rated 7.4, while Oracle Exadata is rated 8.4. The top reviewer of IBM Db2 Warehouse writes "If you have good people designing how the data is stored, this is a marvelous tool". On the other hand, the top reviewer of Oracle Exadata writes "Exadata can significantly improve performance but there's a learning curve in a few key areas". IBM Db2 Warehouse is most compared with Amazon Redshift, Snowflake, Microsoft Azure Synapse Analytics, Oracle Autonomous Data Warehouse and Apache Hadoop, whereas Oracle Exadata is most compared with Teradata, Oracle Database Appliance, Snowflake, Amazon Redshift and SAP BW4HANA. See our IBM Db2 Warehouse vs. Oracle Exadata report.

    See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.

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