Try our new research platform with insights from 80,000+ expert users

IBM Db2 Warehouse vs Oracle Exadata comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024
 

Categories and Ranking

IBM Db2 Warehouse
Ranking in Data Warehouse
13th
Average Rating
7.8
Reviews Sentiment
6.4
Number of Reviews
10
Ranking in other categories
No ranking in other categories
Oracle Exadata
Ranking in Data Warehouse
2nd
Average Rating
8.6
Reviews Sentiment
6.8
Number of Reviews
126
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2024, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 1.9%, up from 1.6% compared to the previous year. The mindshare of Oracle Exadata is 19.3%, up from 18.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

Josef Kraus - PeerSpot reviewer
Useful for ETL process and has good documentation
The tool's most beneficial feature for our data management tasks has been the ETL process. Additionally, we utilized Windows and Linux. IBM Db2 Warehouse's scalability has significantly impacted our data storage capabilities. We needed to order new disks for storage every week within this hosting environment. Additionally, we implemented protection measures for production use. The tools are readily available, and if you're willing to invest in them, you can access a good data warehouse without any issues.
Guruprasad Gonjare - PeerSpot reviewer
Offers a variety of valuable features
The deployment depends on the Exadata options. There are primarily three options which include, Exadata, Exadata Cloud@Customer, and Exadata Cloud Service. Out of these, Cloud Service requires the minimum effort. The deployment takes around two to three weeks to complete. For the deployment purpose, we need information on the user base where the access is going to happen. We would also require around four to five engineers and admins for the solution’s deployment and maintenance. This estimation is based on the workflow.

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."
"Provides good security and reliability."
"The analytics engine is not bad at forecasting predictions."
"The solution is stable."
"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"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."
"It can scale effectively as long as resources are available."
"Oracle Exadata has very good hardware."
"The most valuable feature of Oracle Exadata is the integration with other solutions, such as SAN storage and shared VLAN network."
"The most valuable feature is that you have the same familiar environment of an Oracle database but with the additional performance you get from this architecture."
"Exadata is a fantastic machine. Two features stand out. The first is the resource input/output management tool that allows you to manage the resources to the neck on the Exadata box."
"Oracle Exadata's performance is one of its best features. We very satisfied with it."
"Oracle Exadata is stable."
"What I found most valuable in Oracle Exadata is its newer technology that gives better performance. It has more recent hardware and significant changes in the architecture, so it's better than older solutions."
"The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain."
 

Cons

"There should be more material available for training and training should be free."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."
"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."
"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"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."
"Lacks sufficient documentation and particularly in Spanish."
"There is one aspect to Exadata that I dislike, and that's the inconsistency with other databases. When you try to get Exadata to function with another type of database like SQL, or others, there should be reliable and consistent operation. When this is improved on, we should start to see more applications growing the market."
"Oracle Exadata compatibility with the analytics could be better and the OBIEE could improve. Oracle BI to Exadata needs to be improved. Even if the full analytics practice for Oracle should be improved and when compared with other solutions it is weak."
"The solution takes a lot of time to clone the environment. I would like to see some improvement in the cloning support or the time it takes on the storage side."
"License or upgrade management can be difficult and time consuming because it requires login to a separate console."
"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."
"The scalability can be improved as it is not a parallel execution."
"The performance could be improved."
"Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly."
 

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
"All things considered, the price of this product is fairly high, as is always the case with Oracle."
"Oracle Exadata is costly. Its licensing should also be more versatile. Smaller companies would benefit if Oracle Exadata had lower pricing."
"The solution takes a lot of time to clone the environment. I would like to see some improvement in the cloning support or the time it takes on the storage side."
"I think it's free."
"The cost of the product could be improved."
"It is quite expensive."
"In the sizing phase, you can also decide whether to license all cores, or reduce the number cores using capacity-on-demand features of Exadata, as well. This has a direct impact on licensing."
"I would rate the tool's pricing a nine out of ten."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
824,053 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
60%
Financial Services Firm
9%
Computer Software Company
5%
Insurance Company
4%
Financial Services Firm
29%
Computer Software Company
13%
Manufacturing Company
6%
Government
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM Db2 Warehouse?
The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.
What is your experience regarding pricing and costs for IBM Db2 Warehouse?
Db2 Warehouse or IBM products are pretty expensive. There are cheaper tools on the market. However, if the client is satisfied with paying for the Db2 Warehouse license, especially for cloud-based ...
What needs improvement with IBM Db2 Warehouse?
Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues. The technical support quality is good, but the response time needs improvement.
What do you like most about Oracle Exadata?
It is the best solution for OLTP and data warehousing.
What is your experience regarding pricing and costs for Oracle Exadata?
The pricing of Exadata is high. It is more expensive than usual, making it suitable only for big enterprises or businesses that can afford it.
What needs improvement with Oracle Exadata?
I would like to add some features to run applications or microservices-based applications on Exadata.
 

Also Known As

InfoSphere Warehouse, IBM InfoSphere Warehouse
No data available
 

Learn More

Video not available
 

Overview

 

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.
Find out what your peers are saying about IBM Db2 Warehouse vs. Oracle Exadata and other solutions. Updated: November 2024.
824,053 professionals have used our research since 2012.