Amazon Redshift vs IBM Db2 Warehouse on Cloud vs Oracle Exadata comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo
8,203 views|6,066 comparisons
87% willing to recommend
IBM Logo
327 views|295 comparisons
83% willing to recommend
Oracle Logo
9,011 views|6,546 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary

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

Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse.
To learn more, read our detailed Cloud Data Warehouse Report (Updated: March 2024).
768,415 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
"The processing of data is very fast.""The ability to reload data multiple times at different times.""The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing.""You can copy JSON to the column and have it analyzed using simple functions.""The most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast.""We have found Machine Learning use cases are very nice.""The most valuable feature of Amazon Redshift is its ability to handle really large sets of data.""Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."

More Amazon Redshift Pros →

"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger.​""The performance is okay as long as the volume of queries is not too high.""It will be MPP, so performance should improve."

More IBM Db2 Warehouse on Cloud Pros →

"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 most valuable feature is storage offloading.""The product is flexible.""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.""Compression is a great feature, where one can really save a lot of storage.""The ease of setup is an eight out of ten.""What I like best about Oracle Exadata is its good performance. It's also a very fast solution.""On-premises Exadata is just as stable as the cloud version. It's a very stable platform."

More Oracle Exadata Pros →

Cons
"The solution could improve in handling more data formats and more native support for RDF.""The OLAP slide and dice features need to be improved.""The speed of the solution and its portability needs improvement.""Migrating data from other data sources can be challenging when you are working with multibyte character sets.""There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments.""The technical support should be better in terms of their knowledge, and they should be more customer-friendly.""The initial deployment was complex.""Planting is the primary key enforcement that should be improved."

More Amazon Redshift Cons →

"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues.""Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue.""Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.""Tech support for dashDB is awful. We usually have tickets open for three to four weeks."

More IBM Db2 Warehouse on Cloud Cons →

"The scalability can be improved as it is not a parallel execution.""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.""I have found Oracle Exadata to be scalable. However, you have to purchase more hardware, such as memory.""Tech support sometimes takes some time to identify and rectify issues.""The initial setup process is very difficult and extremely complex.""The management monitoring tools are quite important and an area that needs some improvement.""The handling of temp space has room for improvement.""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."

More Oracle Exadata Cons →

Pricing and Cost Advice
  • "Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other products."
  • "If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."
  • "BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge."
  • "One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
  • "Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
  • "It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20."
  • "The best part about this solution is the cost."
  • "The part that I like best is that you only pay for what you are using."
  • More Amazon Redshift Pricing and Cost Advice →

  • "If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."
  • More IBM Db2 Warehouse on Cloud Pricing and Cost Advice →

  • "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."
  • "The Initial investment price could use improvement"
  • "I think it's free."
  • "The price is very high."
  • "Exadata is an expensive tool, but, considering the ROI, it's worth going for the solution."
  • "Oracle is always costly but it's fine."
  • "It is an expensive product and you pay more for certain performance enhancements."
  • "All things considered, the price of this product is fairly high, as is always the case with Oracle."
  • More Oracle Exadata Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    768,415 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very… more »
    Top Answer:Redshift Spectrum is the most valuable feature.
    Top Answer:Organizations of all sizes, especially those who are in need of powerful and elastic cloud data warehouse solutions that… more »
    Top Answer:It is the best solution for OLTP and data warehousing.
    Top Answer:The solution’s cost is a little bit more than the traditional databases. Less cost would enable most customers to choose… more »
    Top Answer:Patching must be simplified. We have various levels of patching in the solution. Most of them are online, split into… more »
    Ranking
    4th
    Views
    8,203
    Comparisons
    6,066
    Reviews
    23
    Average Words per Review
    480
    Rating
    7.7
    15th
    Views
    327
    Comparisons
    295
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    2nd
    out of 34 in Data Warehouse
    Views
    9,011
    Comparisons
    6,546
    Reviews
    21
    Average Words per Review
    494
    Rating
    8.7
    Comparisons
    Also Known As
    IBM dashDB
    Learn More
    Overview

    What is Amazon Redshift?

    Amazon Redshift is a fully administered, petabyte-scale cloud-based data warehouse service. Users are able to begin with a minimal amount of gigabytes of data and can easily scale up to a petabyte or more as needed. This will enable them to utilize their own data to develop new intuitions on how to improve business processes and client relations.

    Initially, users start to develop a data warehouse by initiating what is called an Amazon Redshift cluster or a set of nodes. Once the cluster has been provisioned, users can seamlessly upload data sets, and then begin to perform data analysis queries. Amazon Redshift delivers super-fast query performance, regardless of size, utilizing the exact SQL-based tools and BI applications that most users are already working with today.

    The Amazon Redshift service performs all of the work of setting up, operating, and scaling a data warehouse. These tasks include provisioning capacity, monitoring and backing up the cluster, and applying patches and upgrades to the Amazon Redshift engine.

    Amazon Redshift Functionalities

    Amazon Redshift has many valuable key functionalities. Some of its most useful functionalities include:

    • Cluster administration: The Amazon Redshift cluster is a group of nodes that contains a leader node and one (or more) compute node(s). The compute nodes needed are dependent on the data size, amount of queries needed, and the query execution functionality desired.
    • Cluster snapshots: Snapshots are backups of a cluster from an exact point in time. Amazon Redshift offers two types of snapshots: manual and automated. Amazon will store these snapshots internally in the Amazon Simple Storage Service (Amazon S3) utilizing an SSL connection. Whenever a Snapshot restore is needed, Amazon Redshift will create a new cluster and will import data from the snapshot as directed. 
    • Cluster access: Amazon Redshift provides several intuitive features to help define connectivity rules, encrypt data and connections, and control the overall access of your cluster.
    • IAM credentials and AWS accounts: The Amazon Redshift cluster is only accessible by the AWS account that created the cluster. This automatically secures the cluster and keeps it safe. Inside the AWS account, users access the AWS Identity and IAM protocol to create additional user accounts and manage permissions, granting specified users the desired access needed to control cluster performance.
    • Encryption: Users have the option to choose to encrypt the clusters for additional added security once the cluster is provisioned. When encryption is enabled, Amazon Redshift will store all the data in user-created tables in a secure encrypted format. To manage Amazon Redshift encryption keys, users will access AWS Key Management Service (AWS KMS).

    Reviews from Real Users

    Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there.” - Kundan A., Senior Consultant at Dynamic Elements AS

    “With the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features. They have enriched and elaborate documentation that is helpful.”- Aishwarya K., Solution Architect at Capgemini

    IBM dashDB family offers private and public cloud database solutions for transactional and analytic workloads, with IBM fully managed or client managed options with a Common SQL engine across all deployment options.

    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."

    Sample Customers
    Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
    Copenhagen Business School, BPM Northwest, GameStop
    PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
    Top Industries
    REVIEWERS
    Computer Software Company32%
    Comms Service Provider14%
    Manufacturing Company11%
    Retailer11%
    VISITORS READING REVIEWS
    Educational Organization50%
    Financial Services Firm9%
    Computer Software Company7%
    Manufacturing Company4%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Manufacturing Company10%
    University10%
    Computer Software Company9%
    REVIEWERS
    Financial Services Firm24%
    Comms Service Provider17%
    Insurance Company16%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Financial Services Firm28%
    Computer Software Company13%
    Manufacturing Company6%
    Energy/Utilities Company5%
    Company Size
    REVIEWERS
    Small Business40%
    Midsize Enterprise24%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business10%
    Midsize Enterprise54%
    Large Enterprise36%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise10%
    Large Enterprise76%
    REVIEWERS
    Small Business30%
    Midsize Enterprise9%
    Large Enterprise61%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    Buyer's Guide
    Cloud Data Warehouse
    March 2024
    Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse. Updated: March 2024.
    768,415 professionals have used our research since 2012.