Amazon Redshift vs Oracle Exadata comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo
7,544 views|5,537 comparisons
87% willing to recommend
Oracle Logo
8,274 views|6,055 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary
Updated on Sep 11, 2022

We compared Amazon Redshift and Oracle Exadata based on our users’ reviews in four categories. After reading the collected data, you can find our conclusion below.

  • Ease of Deployment: Users of Amazon Redshift feel that it is relatively easy to deploy. Reviewers of Oracle Exadata find its deployment process to be complex.
  • Features: Users of both products feel that they are stable and scalable.

    Users of Amazon Redshift like its ease of use but feel its data streaming capabilities could be improved.

    Users of Oracle Exadata like its security options. However, they feel these security features should come included in the product’s initial purchase.

  • Pricing: Most users of Amazon Redshift feel that its cost is reasonable. Users of Oracle Exadata find its cost to be expensive.
  • Service and Support: Users of both products find their technical support to be pretty effective.

Comparison of Results: Based on the parameters we compared, Amazon Redshift seems to be the superior solution. Our reviewers feel that Oracle Exadata’s complexity of deployment and its expensive price tag make Amazon Redshift the better investment.

To learn more, read our detailed Amazon Redshift vs. Oracle Exadata 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
"The product is relatively easy to use because there is no indexing and no partitions.""It allows you write complex queries and perform row by row processes.""The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing.""The product offers good support for the data lake.""The most valuable feature of Amazon Redshift is its ability to handle really large sets of data.""Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly.""I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing.""Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."

More Amazon Redshift Pros →

"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 performs well with a large database.""The most valuable feature is storage offloading.""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.""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.""What I like most about Oracle Exadata is its smart scan feature. I also like that it supports higher capacities and it's high-performing, so my company can use Oracle Exadata for massive databases.""The product is flexible.""The most valuable feature of Oracle Exadata is the storage available."

More Oracle Exadata Pros →

Cons
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues.""The refreshment rate of data reaching Redshift from other sources should be faster.""Sometimes, it's difficult to get the metadata from Redshift.""For people who struggle with IAM or role-based management, the setup isn't easy.""Amazon Redshift is a little more expensive than other products.""The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs.""There are too many limitations with respect to concurrency.""The product must become a bit more serverless."

More Amazon Redshift Cons →

"The solution's pricing is very high.""The technical support is in need of improvement.""Checking the Smart Scan issues is complicated.""The solution lacks a visualized console.""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.""We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components.""I have found Oracle Exadata to be scalable. However, you have to purchase more hardware, such as memory.""We used the support from Oracle Exadata to complete the implementation."

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 →

  • "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 Data Warehouse solutions are best for your needs.
    772,679 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 straightforward. This solution can merge and integrate well with many different… more »
    Top Answer:The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
    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 the product.
    Top Answer:Patching must be simplified. We have various levels of patching in the solution. Most of them are online, split into various components. A single way of patching would be better.
    Ranking
    4th
    Views
    7,544
    Comparisons
    5,537
    Reviews
    24
    Average Words per Review
    504
    Rating
    7.8
    2nd
    out of 35 in Data Warehouse
    Views
    8,274
    Comparisons
    6,055
    Reviews
    20
    Average Words per Review
    501
    Rating
    8.7
    Comparisons
    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

    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
    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 Company34%
    Comms Service Provider14%
    Retailer10%
    Manufacturing Company10%
    VISITORS READING REVIEWS
    Educational Organization51%
    Financial Services Firm9%
    Computer Software Company7%
    Manufacturing Company4%
    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 Business38%
    Midsize Enterprise25%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business10%
    Midsize Enterprise55%
    Large Enterprise35%
    REVIEWERS
    Small Business30%
    Midsize Enterprise9%
    Large Enterprise61%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    Buyer's Guide
    Amazon Redshift vs. Oracle Exadata
    May 2024
    Find out what your peers are saying about Amazon Redshift vs. Oracle Exadata and other solutions. Updated: May 2024.
    772,679 professionals have used our research since 2012.

    Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Oracle Exadata is ranked 2nd in Data Warehouse with 125 reviews. Amazon Redshift is rated 7.8, while Oracle Exadata is rated 8.4. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of Oracle Exadata writes "Offers a variety of valuable features". Amazon Redshift is most compared with Teradata, Vertica, Snowflake, Microsoft Azure Synapse Analytics and Azure Data Factory, whereas Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Oracle Autonomous Data Warehouse, Snowflake and VMware Tanzu Data Services. See our Amazon Redshift vs. Oracle Exadata report.

    See our list of best Data Warehouse vendors and best Cloud 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.