IBM Db2 Warehouse vs Oracle Exadata comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Db2 Warehouse
Ranking in Data Warehouse
12th
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
 

Market share comparison

As of June 2024, in the Data Warehouse category, the market share of IBM Db2 Warehouse is 3.4% and it increased by 80.2% compared to the previous year. The market share of Oracle Exadata is 15.2% and it decreased by 28.5% 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

"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."
"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."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"The solution is stable."
"Provides good security and reliability."
"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"The analytics engine is not bad at forecasting predictions."
"Oracle has reliable solutions and this one is no different."
"The product is flexible."
"The business intelligence is very good."
"The most valuable feature of Oracle Exadata is the storage available."
"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."
"It is a scalable solution."
"Oracle is easy to use for peripheral things, such as the data vault and the data firewall, data sync, and partitions. These are the features that give an edge to other databases."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
 

Cons

"IBM Db2 Warehouse needs to improve its interface."
"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."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"Lacks sufficient documentation and particularly in Spanish."
"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."
"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 areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"We used the support from Oracle Exadata to complete the implementation."
"Tech support sometimes takes some time to identify and rectify issues."
"Oracle Exadata has room for improvement in pricing, especially for smaller companies. The solution is okay for bigger companies, but for smaller companies, it isn't."
"The analytics features must be improved."
"The solution could always be more stable and more reliable."
"We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"License or upgrade management can be difficult and time consuming because it requires login to a separate console."
 

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
"The cost of the solution is high."
"The licensing can be a bit expensive because you need to have certain tools enabled that require them."
"The price of Oracle Exadata is expensive. It is not competitive with other solutions some of the times."
"Oracle is always costly but it's fine."
"The solution is expensive."
"It is an expensive product and you pay more for certain performance enhancements."
"The price is very high."
"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."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
787,061 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
53%
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: May 2024.
787,061 professionals have used our research since 2012.