IBM Db2 Warehouse vs Oracle Database Appliance comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
956 views|510 comparisons
75% willing to recommend
Oracle Logo
2,847 views|2,029 comparisons
87% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Db2 Warehouse and Oracle Database Appliance 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 Database Appliance Report (Updated: May 2024).
772,679 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
"Provides good security and reliability.""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.""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.""The analytics engine is not bad at forecasting predictions.""Some of the best features are stored procedures, parallelism, and different indexing strategies."

More IBM Db2 Warehouse Pros →

"Oracle Database Appliance provides high stability.""We use the solution for our Java applications.""The solution is simple to use and easy to maintain.""The tool is a specific and effective system. I am impressed with its usability.""The performance due to the all-flash of ODA is very nice.""NVM Express (NVMe) solid-state drives: This technology brings outstanding I/O performance for midsize databases. We have tested it by doing POCs on customer sites and the results were quite satisfying.""We value the appliance architecture with its “everything-in-a-box” highly standardized setup.""The solution is stable. The product is scalable. The technical support is very helpful. The initial setup is straightforward. I consider the product a strong solution for our customers."

More Oracle Database Appliance Pros →

Cons
"There should be more material available for training and training should be free.""IBM Db2 Warehouse needs to improve its interface.""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.""The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting.""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.""Lacks sufficient documentation and particularly in Spanish."

More IBM Db2 Warehouse Cons →

"The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface.""I would rate the scalability a seven out of ten. It has some problems. Databases are huge. This leads to needing more and more RAM and capacity resources, making it hard to scale. Because of this, we use Exadata. That's definitely a point for improvement.""Since we don't have the room to scale up, I rate this solution a six out of ten for scalability.""The product is quite complex to set up, initially. It would be ideal if it was simpler.""Oracle's product support is an area of concern where improvements are required.""Oracle could improve its capacity for built-in visualization.""Virtualization features could also be improved. A web-based GUI would be a good start.""Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."

More Oracle Database Appliance 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 →

  • "Get benefit from the capacity-on-demand features. License your cores according to your licenses."
  • "Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE."
  • "In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
  • "The price should be lower."
  • "You must pay for the license."
  • "The price of the solution should be less expensive. However, they will increase the price more."
  • "I don’t know ODA and alternative system prices. But Oracle the database license is quite expensive and a lot of my customers plan to migrate to open source databases like PostgreSQL."
  • "Compared to Oracle Exadata, Oracle Database Appliance is affordable."
  • More Oracle Database Appliance Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    772,679 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.
    Top Answer: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.
    Top Answer:IBM Db2 Warehouse needs to improve its interface.
    Top Answer:Oracle Database Appliance provides high stability.
    Top Answer:On a scale from 1 to 10, where 1 is cheap and 10 is expensive, I rate the solution's pricing 7.5 or 8 out of 10.
    Top Answer:The solution’s pricing could be improved.
    Ranking
    12th
    out of 35 in Data Warehouse
    Views
    956
    Comparisons
    510
    Reviews
    4
    Average Words per Review
    423
    Rating
    7.5
    7th
    out of 35 in Data Warehouse
    Views
    2,847
    Comparisons
    2,029
    Reviews
    12
    Average Words per Review
    347
    Rating
    7.8
    Comparisons
    Also Known As
    InfoSphere Warehouse, IBM InfoSphere Warehouse
    X5-2
    Learn More
    IBM
    Video Not Available
    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 Database Appliance is the easiest and most affordable way for small or medium-size organizations to run Oracle databases and applications and is an ideal platform for remote and edge computing environments. Customers reduce Oracle Database deployment times and management workloads using a prebuilt integrated system with management automation. As demonstrated in IDC’s business value study (PDF), Oracle Database Appliance lets customers grow revenue and control costs, delivering up to a 498% return on investment (ROI) over five years.

    Sample Customers
    Alameda County Social Services Agency, Sui Southern Gas Company Limited
    LifeLock, Incarlopsa, Al Yusur Industrial Contracting
    Top Industries
    VISITORS READING REVIEWS
    Educational Organization52%
    Financial Services Firm9%
    Computer Software Company7%
    Insurance Company5%
    REVIEWERS
    Financial Services Firm32%
    Comms Service Provider21%
    Retailer11%
    Transportation Company5%
    VISITORS READING REVIEWS
    Financial Services Firm29%
    Computer Software Company11%
    Government8%
    Manufacturing Company7%
    Company Size
    REVIEWERS
    Small Business40%
    Midsize Enterprise20%
    Large Enterprise40%
    VISITORS READING REVIEWS
    Small Business8%
    Midsize Enterprise55%
    Large Enterprise37%
    REVIEWERS
    Small Business42%
    Midsize Enterprise21%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    Buyer's Guide
    IBM Db2 Warehouse vs. Oracle Database Appliance
    May 2024
    Find out what your peers are saying about IBM Db2 Warehouse vs. Oracle Database Appliance and other solutions. Updated: May 2024.
    772,679 professionals have used our research since 2012.

    IBM Db2 Warehouse is ranked 12th in Data Warehouse with 9 reviews while Oracle Database Appliance is ranked 7th in Data Warehouse with 40 reviews. IBM Db2 Warehouse is rated 7.8, while Oracle Database Appliance is rated 8.0. The top reviewer of IBM Db2 Warehouse writes "Useful for ETL process and has good documentation ". On the other hand, the top reviewer of Oracle Database Appliance writes "Simplifies database management tasks and provides high availability and disaster recovery". IBM Db2 Warehouse is most compared with Oracle Exadata, Snowflake, Amazon Redshift, IBM Db2 Warehouse on Cloud and Apache Hadoop, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Data Services, Dremio, Actian Ingres and Vertica. See our IBM Db2 Warehouse vs. Oracle Database Appliance report.

    See our list of best 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.