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 most valuable features of Amazon Redshift are that its fast and efficient. We have lots of TBs of data and it's very fast.""The solution has very competitive pricing.""It's scalable because it's on the cloud.""The initial setup of this solution is straightforward.""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.""The processing of data is very fast.""I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution.""The ability to reload data multiple times at different times."

More Amazon Redshift Pros →

"It is the best solution for OLTP and data warehousing.""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 of Oracle Exadata is the smart scan. We have large TB sessions of approximately 100 per second for each of our three instances. The smart scan allows us the obtain data in time in the enterprise manager.""This product can noticeably enhance performance of contextual Oracle databases.""The most valuable feature is storage offloading.""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.""Exadata is also a very stable environment. Their Smart Scan feature is great for every banking environment and financial institutions willing to implement it.""Exadata with the In-Memory option is several levels about SAP HANA."

More Oracle Exadata Pros →

Cons
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions.""The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs.""Amazon Redshift does not have the capability to dynamically increase the VM file.""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.""When working with third-party services requires additional integrations and configurations, which can sometimes add more cost.""In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic.""The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number.""Improvement could be made in the area of streaming data."

More Amazon Redshift Cons →

"Since the product is an appliance, it is very costly.""It is difficult to evaluate return-on-investment because of the way billing is handled for the product. This should be improved by oracle.""Sometimes it takes too long time to get help with technical 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.""Exadata would be improved with single dashboard visibility.""We had issues with system restoration.""One small area for improvement in Oracle Exadata is integration, particularly at the consolidated application level.""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."

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.