IT Central Station is now PeerSpot: Here's why

Amazon Redshift vs Oracle Exadata comparison

Cancel
You must select at least 2 products to compare!
Amazon Logo
12,653 views|10,184 comparisons
Oracle Logo
14,535 views|11,122 comparisons
Featured Review
Buyer's Guide
Cloud Data Warehouse
June 2022
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon and others in Cloud Data Warehouse. Updated: June 2022.
609,272 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It's scalable because it's on the cloud.""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 most valuable feature is its scalability.""Amazon Redshift is very fast. It has really good response times. It's very user-friendly.""The initial setup is easy.""I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing.""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.""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."

More Amazon Redshift Pros →

"Oracle is known to be the number one in their industry; the help and support, the features they are giving the clients comparing to other databases, the new technology, the provide a good solution.""Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement.""A very stable solution, which we have hardly any problems with.""The performance on the databases is good.""The most valuable feature is the time to 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.""The business intelligence is very good.""Oracle Exadata's performance is one of its best features. We very satisfied with it."

More Oracle Exadata Pros →

Cons
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure.""There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity.""This solution lacks integration with non-AWS sources.""I would like to improve the pricing and the simplicity of using this solution.""Improvement could be made in the area of streaming data.""Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics.""The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number.""There are too many limitations with respect to concurrency."

More Amazon Redshift Cons →

"The integration with third-party applications regarding access management security could be better.""I have found Oracle Exadata to be scalable. However, you have to purchase more hardware, such as memory.""In a future release, I would like to see some upgrade analysis advisors to help with a clear roadmap on steps that need to be taken and some of the automated processes.""Tech support sometimes takes some time to identify and rectify issues.""We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components.""The customization can sometimes be difficult to achieve.""Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up.""The setup is a little bit complex. We would like to see the installation part get easier."

More Oracle Exadata Cons →

Pricing and Cost Advice
  • "My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD."
  • "At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
  • "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."
  • "This solution implements the pay-as-you-use model, so no license. Pricing could be cheaper."
  • "The price of Amazon Redshift is reasonable because it depends on the usage that you use and for DWH for the long term."
  • "Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."
  • "It's pay per use. You can have multiple models."
  • More Amazon Redshift Pricing and Cost Advice →

  • "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."
  • "I did note that Oracle does tend to internally oversize things especially if they want to fill up a budget, and hence third-party oversight is essential."
  • "The licensing can be a bit expensive because you need to have certain tools enabled that require them."
  • "The majority of our customers are in government or big enterprises, and the projects that we sell come out to several million USD. With this amount of money on the table, it's always better to have an experienced team of consultants, who know Exadata very well, handle the implementation."
  • "The price of the solution has been expensive to implement."
  • "The cost of the product could be improved."
  • 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.
    609,272 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: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.
    Top Answer:The price of Amazon Redshift is reasonable because it depends on the usage that you use and for DWH for the long term.
    Top Answer:The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain.
    Top Answer:There is an annual license to use this solution. The solution is expensive. I rate the price of Oracle Exadata a three out of five.
    Top Answer:Oracle Exadata could improve the platform performance tuning should be easier, automated, and user-friendly. In a future release, I would like to have new analytical capabilities.
    Ranking
    4th
    Views
    12,653
    Comparisons
    10,184
    Reviews
    15
    Average Words per Review
    464
    Rating
    7.6
    2nd
    out of 30 in Data Warehouse
    Views
    14,535
    Comparisons
    11,122
    Reviews
    22
    Average Words per Review
    583
    Rating
    8.8
    Comparisons
    Learn More
    Overview

    Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Customers can start small for just $0.25 per hour with no commitments or upfront costs and scale to a petabyte or more for $1,000 per terabyte per year, less than a tenth of most other data warehousing solutions.

    Traditional data warehouses require significant time and resource to administer, especially for large datasets. In addition, the financial cost associated with building, maintaining, and growing self-managed, on-premise data warehouses is very high. Amazon Redshift not only significantly lowers the cost of a data warehouse, but also makes it easy to analyze large amounts of data very quickly.

    Amazon Redshift gives you fast querying capabilities over structured data using familiar SQL-based clients and business intelligence (BI) tools using standard ODBC and JDBC connections. Queries are distributed and parallelized across multiple physical resources. You can easily scale an Amazon Redshift data warehouse up or down with a few clicks in the AWS Management Console or with a single API call. Amazon Redshift automatically patches and backs up your data warehouse, storing the backups for a user-defined retention period. Amazon Redshift uses replication and continuous backups to enhance availability and improve data durability and can automatically recover from component and node failures. In addition, Amazon Redshift supports Amazon Virtual Private Cloud (Amazon VPC), SSL, AES-256 encryption and Hardware Security Modules (HSMs) to protect your data in transit and at rest.

    As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use. Amazon Redshift lets you pay as you go. You can even try Amazon Redshift for free.

    Oracle Exadata Database Machine is a modern framework, engineered to run databases and to scale database servers. Oracle Exadata Database Machine can be run on the cloud or on premises.

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

    Offer
    Learn more about Amazon Redshift
    Learn more about Oracle Exadata
    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
    Comms Service Provider25%
    Computer Software Company25%
    Retailer19%
    Logistics Company13%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider12%
    Financial Services Firm9%
    Media Company8%
    REVIEWERS
    Financial Services Firm27%
    Comms Service Provider14%
    Insurance Company14%
    Retailer9%
    VISITORS READING REVIEWS
    Computer Software Company34%
    Financial Services Firm15%
    Comms Service Provider13%
    Government5%
    Company Size
    REVIEWERS
    Small Business32%
    Midsize Enterprise34%
    Large Enterprise34%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise12%
    Large Enterprise73%
    REVIEWERS
    Small Business28%
    Midsize Enterprise12%
    Large Enterprise61%
    VISITORS READING REVIEWS
    Small Business11%
    Midsize Enterprise11%
    Large Enterprise78%
    Buyer's Guide
    Cloud Data Warehouse
    June 2022
    Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon and others in Cloud Data Warehouse. Updated: June 2022.
    609,272 professionals have used our research since 2012.

    Amazon Redshift is ranked 4th in Cloud Data Warehouse with 15 reviews while Oracle Exadata is ranked 2nd in Data Warehouse with 22 reviews. Amazon Redshift is rated 7.6, while Oracle Exadata is rated 8.8. The top reviewer of Amazon Redshift writes "Quick to deploy, easy to use, and performs well, but ingesting data in realtime should be improved". On the other hand, the top reviewer of Oracle Exadata writes "High performing and reliable work environment". Amazon Redshift is most compared with Snowflake, Microsoft Azure Synapse Analytics, Vertica, Teradata and Oracle Autonomous Data Warehouse, whereas Oracle Exadata is most compared with Teradata, Oracle Database Appliance, Snowflake, Oracle Autonomous Data Warehouse and IBM Netezza Performance Server.

    We monitor all Cloud 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.