Amazon Redshift vs Oracle Exadata comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Sep 11, 2022
 

Categories and Ranking

Amazon Redshift
Average Rating
7.8
Number of Reviews
61
Ranking in other categories
Cloud Data Warehouse (4th)
Oracle Exadata
Average Rating
8.4
Number of Reviews
125
Ranking in other categories
Data Warehouse (2nd)
 

Market share comparison

As of June 2024, in the Data Warehouse category, the market share of Amazon Redshift is 14.5% and it increased by 2.7% 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:
Cloud Data Warehouse
6.6%
No other categories found
 

Featured Reviews

Venkata Maniteja Alapati - PeerSpot reviewer
Apr 4, 2024
Operates as a reliable Amazon service and has the capability to gather data from various Amazon sources and can be easily integrated with some maintenance configuration and code
For me, the most valuable feature of Redshift is the way it operates as a reliable Amazon service. It has the capability to gather data from various Amazon sources and can be easily integrated with some maintenance configuration and code; Lambda functions are required for this. It can be used in multiple places. It all depends on the use cases, how we can actually ship the data, and how we can use the data from multiple sources. It is a typical reliable software and works very efficiently with Amazon. For Amazon Connect combined with Redshift, the integration is mostly straightforward. Using Redshift always depends on the use cases, as there are other methods Amazon Connect can use to achieve its goals. As for Redshift itself, it can be used to build pipelines.
Robin Saikat Chatterjee - PeerSpot reviewer
May 10, 2023
The solution is the perfectsystem having all delivery models
Customer Service: We have had great customer service. We had almost no issues with the machine as such except for some predictive hard disk failures and the machine never had a problem due to the redundancy, so there was zero downtime for any of the hard disk faults. Technical Support: Majority of the cases we have had good support. We had a few small hiccups with ASR Auto Update as it twice lost configuration. However, we have since disabled that function and do the ASR updating manually after taking a backup. As this feature is not essential to the actual running of the machine, it never caused us any major issues.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"Amazon Redshift is a really powerful database system for reporting and data warehousing."
"The product offers good support for the data lake."
"It is very easy to dump data into the tool."
"It allows you write complex queries and perform row by row processes."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"Redshift Spectrum is the most valuable feature."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain."
"It offers a significant advantage for accommodating a large number of users."
"It is a highly relevant option with extreme performance."
"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."
"Exadata with the In-Memory option is several levels about SAP HANA."
"The storage capacity and the performance of Oracle Exadata are good. When comparing the performance to other technologies it is very good. I am satisfied with the management of the solution."
"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."
"It is a scalable solution."
 

Cons

"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"There are too many limitations with respect to concurrency."
"The explain panel in the Redshift database could be better."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"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."
"There is one aspect to Exadata that I dislike, and that's the inconsistency with other databases. When you try to get Exadata to function with another type of database like SQL, or others, there should be reliable and consistent operation. When this is improved on, we should start to see more applications growing the market."
"The cost of the solution is high and can be improved."
"The improvement could be made on the hardware level as the habit in the industry is to go better and faster and larger with every iteration."
"The handling of temp space has room for improvement."
"There is a feature for security, but it is not included in the first purchase of this solution. That means if you need to increase the security, you need to buy the security feature which doesn't come by default on these solutions."
"We used the support from Oracle Exadata to complete the implementation."
"Sometimes it takes too long time to get help with technical issues."
 

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."
"The product is cheap considering what it provides; I rate it five out of five for affordability."
"It's not very pricey compared to other tools. I would rate the price as 5 out of 10."
"The solution has very competitive pricing."
"In comparison to the price of similar solutions, Redshift's cost is the lowest."
"The product is quite expensive."
"This solution implements the pay-as-you-use model, so no license. Pricing could be cheaper."
"The best part about this solution is the cost."
"Oracle is always costly but it's fine."
"Our customers are always looking to reduce the license's cost."
"The price of the solution has been expensive to implement."
"We pay for an annual license and it is expensive."
"Exadata is an expensive tool, but, considering the ROI, it's worth going for the solution."
"It is quite expensive."
"It is an expensive product and you pay more for certain performance enhancements."
"The licensing can be a bit expensive because you need to have certain tools enabled that require them."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
787,104 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
52%
Financial Services Firm
9%
Computer Software Company
7%
Manufacturing Company
4%
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

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
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 dat...
What do you like most about Amazon Redshift?
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.
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...
 

Overview

 

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.
Find out what your peers are saying about Amazon Redshift vs. Oracle Exadata and other solutions. Updated: May 2024.
787,104 professionals have used our research since 2012.