Amazon Redshift vs Oracle Exadata Express Cloud Service comparison

Amazon Redshift vs. Oracle Exadata Express Cloud Service

Download the complete report

Helped 860,168 peers since 2012

Review summaries and opinions

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

Categories and Ranking

Amazon Redshift

Average Rating

7.8

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Cloud Data Warehouse (6th)

Oracle Exadata Express Clou...

Average Rating

8.0

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Database as a Service (DBaaS) (9th)

Mindshare comparison

Amazon Redshift and Oracle Exadata Express Cloud Service aren’t in the same category and serve different purposes. Amazon Redshift is designed for Cloud Data Warehouse and holds a mindshare of 7.5%, down 8.0% compared to last year.
Oracle Exadata Express Cloud Service, on the other hand, focuses on Database as a Service (DBaaS), holds 0.6% mindshare, up 0.4% since last year.

Cloud Data Warehouse

Database as a Service (DBaaS)

Featured Reviews

Sriram-Natesan

Tech Lead at Impetus

The ability to create a lot of views or materialized views is beneficial

Improvement in the immediate response and the process of getting into a call could be helpful. We have had to wait for at least twenty-four hours to get a call and then wait for a couple more hours for a solution. Improved connectivity to different BI tools and already published connectors for major tools in AWS could enhance the service.

Read full review

Shrikant Navelkar

Director at Clover Infotech

Enhances performance without fine tuning databases

They need to simplify the monitoring of the Exadata services. They have to make it more simple for the users to operate or manage. And one more thing, I would expect that other databases of Oracle, like MySQL Enterprise Edition, if technologically, Oracle makes some advancement and allows MySQL Enterprise Edition to run on Exadata, I think that will improve their market share exponentially. Today, on Exadata, you run Oracle databases, which is given. Apart from that, Oracle also has Oracle MySQL database, open source. If that open-source database also runs on Exadata, I think that will help a lot of customers. In the next release, Oracle can provide a script-level solution to migrate or consolidate cross-platform databases from Unix platform to Oracle Exadata on Linux platform; if they can provide some migration tools, I think that will help.

Read full review

Quotes from Members

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

Pros

"The valuable features are performance, data compression, and scalability."

"We have found Machine Learning use cases are very nice."

"The ability to reload data multiple times at different times."

"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."

"The most valuable features of Amazon Redshift include everything being integrated within Amazon, making it really easy to run queries faster, allowing us to retrieve data as soon as possible compared to other tools."

"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."

"Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down."

"The most valuable feature is its scalability."

More Amazon Redshift pros

"The performance of the tool is valuable."

"I would rate Oracle Exadata Express Cloud Service ten out of ten for its overall solution."

"One of the most valuable parts of the solution is the high availability within the system and the performance enhancement without making any changes or fine-tuning the databases."

"I highly recommend Oracle Exadata Express Cloud Service as a very good solution if you can afford it."

"Having the prediction happen in the modular format allows you to start with a lower version of Exadata and then you can keep on upgrading it as per your requirement."

"In the cloud, Exadata is more scalable. The on-prem version was limited. It wasn't that scalable because it only came in a quarter rack, half rack, and full rack. In the cloud, it scales to what you need."

"The solution is very stable and offers great performance."

"I like that Oracle Exadata Express Cloud Service is easier to use and is a cost-saving solution because you won't need to hire people to run and maintain it."

More Oracle Exadata Express Cloud Service pros

Cons

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

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

"Sometimes, it's difficult to get the metadata from Redshift."

"The initial deployment was complex."

"There might be some limitations from a business intelligence perspective, but nothing we can't find a workaround for."

"It takes a lot of time to ingest and update the data."

"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."

"It is not easy to deal with queries in Amazon Redshift and see the same data."

More Amazon Redshift cons

"The solution's pricing could be improved."

"The customer's default choice is the on-premise version of this solution. Only when Oracle or the partners like us, can explain to customers the cloud value proposition, and if the compliance authorities allow, they can look into this cloud solution. It will take some time for Oracle to change its perception of customers' de-facto standards. Exadata used to be treated as a black box, which is not the case now. The customer is aware of what is happening inside, how the configurations have been made, and what patching has been applied. Oracle needs to market the cloud version better."

"The support must be faster."

"Scaling Oracle Exadata Express Cloud Service can be done, but the process is a little tedious, which could be an area for improvement in the solution."

"Oracle's support could be better."

"The only downside is the difficulty in monitoring, and that's why I would like to implement MySQL database."

"The product's installation process needs improvement. It could be more accessible."

"We use artificial intelligence for deep learning, and it would be a huge benefit to implement this in Oracle Exadata."

More Oracle Exadata Express Cloud Service cons

Pricing and Cost Advice

"I have heard complaints about the solution’s pricing, and thus I rate it as a five."

"If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."

"The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."

"The best part about this solution is the cost."

"The solution is available at a mid-range price compared to other vendors."

"The part that I like best is that you only pay for what you are using."

"Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."

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

More Amazon Redshift pricing and cost advice

"The tool is not cheap, but it is not really expensive."

"The price of this solution is very comparative to others on the market. There is no direct comparison between this solution and with something else because I do not see any other similar product."

"I think Oracle pricing is usually above average market price."

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

860,168 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Educational Organization

35%

Financial Services Firm

12%

Computer Software Company

10%

Manufacturing Company

No data available

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 is your experience regarding pricing and costs for Amazon Redshift?

The pricing of Amazon Redshift is expensive.

What do you like most about Oracle Exadata Express Cloud Service?

The performance of the tool is valuable.

What is your experience regarding pricing and costs for Oracle Exadata Express Cloud Service?

Oracle is quite expensive here in Brazil. Pricing is the primary challenge we face with Oracle.

What needs improvement with Oracle Exadata Express Cloud Service?

I feel there is a need for better integration with Google Maps and Google Earth. This is crucial for me in the geographical facilities of the environment.

Teradata vs Amazon Redshift

Comparisons

Compared 17% of the time

AWS Lake Formation vs Amazon Redshift

Compared 12% of the time

Snowflake vs Amazon Redshift

Compared 11% of the time

Microsoft Azure Synapse Analytics vs Amazon Redshift

Compared 8% of the time

OpenText Analytics Database (Vertica) vs Amazon Redshift

Compared 7% of the time

More Amazon Redshift Competitors

No data available

Product Reports

Amazon Redshift

Download Amazon Redshift product report

Oracle Exadata Express Cloud Service

Download Oracle Exadata Express Cloud Service product report

Oracle Exadata Express Cloud Service report

Overview

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

Amazon Web Services (AWS)

Oracle Database Exadata Express Cloud Service delivers a managed Oracle Database 12c Release 2 Enterprise Edition with options, running on Oracle Exadata engineered systems – all at a highly affordable entry-level price. It is a full Oracle Database experience, compatible with what you get on-premises or in other Oracle Database Cloud Services, provisioned within minutes, and suitable for small to medium sized data.

Oracle

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449

TAFEL LEIPZIG, AS ONE

Amazon Redshift vs. Oracle Exadata Express Cloud Service