IBM Db2 Warehouse vs Oracle Exadata comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Db2 Warehouse
Ranking in Data Warehouse
11th
Average Rating
7.8
Number of Reviews
9
Ranking in other categories
No ranking in other categories
Oracle Exadata
Ranking in Data Warehouse
2nd
Average Rating
8.4
Number of Reviews
125
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2024, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 2.0%, down from 2.1% compared to the previous year. The mindshare of Oracle Exadata is 17.2%, down from 18.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
Unique Categories:
No other categories found
No other categories found
 

Featured Reviews

FF
Apr 29, 2024
A data warehouse solution for data analysis and storing various datasets
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. We are in the process of upgrading hardware, improving memory, and upgrading Db2. Our higher management has decided to invest more in this endeavor, doubling our capacity. They believe this investment will benefit our business. Consequently, we are purchasing additional products and moving towards further upgrades involving our technical team and data warehouse specialists. As we heavily invest in this project, it's crucial to mention that our banking company is making substantial investments. We are purchasing additional hardware and software recommended by IBM and have on-site technical support collaborating with us in Pakistan. However, there seems to be a gap in training from IBM's side. Our technical personnel must receive training on the products and tools we are implementing. This training would enable us to fully understand and leverage the latest technologies to meet our requirements effectively. Therefore, I recommend training customers and technical personnel to ensure successful implementation and utilization of the newest technology. Overall, I rate the solution an eight out of ten.
it_user419178 - PeerSpot reviewer
Apr 6, 2016
The High Availability and rolling upgrade features are the most important for us.
The High Availability and rolling upgrade features are the most important for us. They help us achieve zero downtime and increased performance The biggest advantage to our implementation of Exadata is that because it's an Oracle-engineered system, our database administrations don't have to worry…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"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."
"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."
"The analytics engine is not bad at forecasting predictions."
"The solution is stable."
"Provides good security and reliability."
"On-premises Exadata is just as stable as the cloud version. It's a very stable platform."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"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."
"The tool's performance is good."
"It is a scalable solution."
"Oracle has reliable solutions and this one is no different."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"It offers a significant advantage for accommodating a large number of users."
 

Cons

"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."
"Lacks sufficient documentation and particularly in Spanish."
"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."
"There should be more material available for training and training should be free."
"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."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"IBM Db2 Warehouse needs to improve its interface."
"I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination."
"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."
"The solution lacks a visualized console."
"I would like to see more database features and maybe more archiving features, because we need to do data archiving."
"The integration with third-party applications regarding access management security could be better."
"Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly."
"Patching must be simplified."
"Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up."
 

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
"I did note that Oracle does tend to internally oversize things especially if they want to fill up a budget, and hence third-party oversight is essential."
"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."
"The licensing can be a bit expensive because you need to have certain tools enabled that require them."
"Oracle is always costly but it's fine."
"I think it's free."
"The solution’s cost is a little bit more than the traditional databases."
"I would rate the tool's pricing a nine out of ten."
"Our customers are always looking to reduce the license's cost."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
792,694 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
54%
Financial Services Firm
10%
Computer Software Company
7%
Insurance Company
5%
Financial Services Firm
28%
Computer Software Company
13%
Manufacturing Company
6%
Energy/Utilities Company
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 is a very expensive database. In comparison to Oracle, for example, where the cost depends on the size of the implementation. For an enterprise database, the cost is mid-range.
What needs improvement with IBM Db2 Warehouse?
IBM Db2 Warehouse needs to improve its interface.
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?
I rate the tool’s pricing a three out of ten. The solution is expensive.
What needs improvement with Oracle Exadata?
The product must make more investments in object storage technologies. Six to seven years ago, the product had an SQL-based analytics feature that did not work well. The vendor must consider invest...
 

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: July 2024.
792,694 professionals have used our research since 2012.