Amazon EMR vs Oracle Autonomous Data Warehouse comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo
2,388 views|2,059 comparisons
85% willing to recommend
Oracle Logo
3,427 views|2,255 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Amazon EMR and Oracle Autonomous Data Warehouse based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Amazon EMR vs. Oracle Autonomous Data Warehouse Report (Updated: March 2024).
768,924 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
"It allows users to access the data through a web interface.""Amazon EMR's most valuable features are processing speed and data storage capacity.""The project management is very streamlined.""The initial setup is pretty straightforward.""The solution helps us manage huge volumes of data.""The solution is pretty simple to set up.""The ability to resize the cluster is what really makes it stand out over other Hadoop and big data solutions.""In Amazon EMR it is easy to rebuild anything, easy to upgrade and has good fault tolerance."

More Amazon EMR Pros →

"A very good integration feature that restricts access to unauthorized people.""It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions.""It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues.""The product is easy to use.""The analytics have been very good. We've found them to be quite useful.""It is a stable and scalable solution.""Self-patching and runs machine-learning across its logs all the time""It is a very stable tool...It is an extremely scalable tool."

More Oracle Autonomous Data Warehouse Pros →

Cons
"The problem for us is it starts very slow.""We don't have much control. If we have multiple users, if they want to scale up, the cost will go and increase and we don't know how we can restrict that price part.""The most complicated thing is configuring to the cluster and ensure it's running correctly.""There is no need to pay extra for third-party software.""The initial setup was time-consuming.""The dashboard management could be better. Right now, it's lacking a bit.""Amazon EMR can improve by adding some features, such as megastore services and HiveServer2. Additionally, the user interface could be better, similar to what Apache service provides, cross-platform services.""There is room for improvement in pricing."

More Amazon EMR Cons →

"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment.""The initial setup was pretty complex. It was not easy.""Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable.""Ease of connectivity could be improved.""The solution lacks visibility options.""The installation process is complex. Oracle can make the installation process better.""One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace.""I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."

More Oracle Autonomous Data Warehouse Cons →

Pricing and Cost Advice
  • "You don't need to pay for licensing on a yearly or monthly basis, you only pay for what you use, in terms of underlying instances."
  • "The cost of Amazon EMR is very high."
  • "The price of the solution is expensive."
  • "Amazon EMR's price is reasonable."
  • "There is a small fee for the EMR system, but major cost components are the underlying infrastructure resources which we actually use."
  • "There is no need to pay extra for third-party software."
  • "Amazon EMR is not very expensive."
  • "The product is not cheap, but it is not expensive."
  • More Amazon EMR Pricing and Cost Advice →

  • "The cost is perfect with Oracle Universal credit."
  • "ROI is high."
  • "You pay as you go, and you don't pay for services that you don't use."
  • "Cloud solutions are cheaper, but in the long run, they may not be much cheaper. They certainly have a lower initial cost. The licensing is yearly, and it is based on the size of the hardware and the number of users."
  • "The solution's cost is reasonable."
  • "On a scale from one to ten, where one is a low price and ten is a high price, I rate the pricing an eight."
  • "The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
  • "The price depends on the configuration we choose."
  • More Oracle Autonomous Data Warehouse Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    768,924 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Amazon EMR is a good solution that can be used to manage big data.
    Top Answer:As people are shifting from legacy solutions to other technologies, Amazon EMR needs to add more features that give more flexibility in managing user data.
    Top Answer:With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main… more »
    Top Answer:Cost-wise, it's a solid seven out of ten. A bit costly, but it is a good tool.
    Top Answer:My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on… more »
    Ranking
    9th
    Views
    2,388
    Comparisons
    2,059
    Reviews
    12
    Average Words per Review
    346
    Rating
    7.8
    10th
    Views
    3,427
    Comparisons
    2,255
    Reviews
    7
    Average Words per Review
    556
    Rating
    8.1
    Comparisons
    Also Known As
    Amazon Elastic MapReduce
    Learn More
    Overview
    Amazon Elastic MapReduce (Amazon EMR) is a web service that makes it easy to quickly and cost-effectively process vast amounts of data. Amazon EMR simplifies big data processing, providing a managed Hadoop framework that makes it easy, fast, and cost-effective for you to distribute and process vast amounts of your data across dynamically scalable Amazon EC2 instances.

    Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and, according to an IDC report (PDF), lowers operational costs by an average of 63%.


    Autonomous Database provides the foundation for a data lakehouse—a modern, open architecture that enables you to store, analyze, and understand all your data. The data lakehouse combines the power and richness of data warehouses with the breadth, flexibility, and low cost of popular open source data lake technologies. Access your data lakehouse through Autonomous Database using the world's most powerful and open SQL processing engine.

    Sample Customers
    Yelp
    Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
    Top Industries
    REVIEWERS
    Computer Software Company27%
    Media Company18%
    Wholesaler/Distributor18%
    Comms Service Provider9%
    VISITORS READING REVIEWS
    Financial Services Firm23%
    Computer Software Company13%
    Manufacturing Company8%
    Educational Organization6%
    REVIEWERS
    Computer Software Company27%
    Manufacturing Company18%
    Financial Services Firm18%
    Individual & Family Service9%
    VISITORS READING REVIEWS
    Educational Organization43%
    Financial Services Firm9%
    Computer Software Company8%
    Manufacturing Company4%
    Company Size
    REVIEWERS
    Small Business26%
    Midsize Enterprise26%
    Large Enterprise47%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise72%
    REVIEWERS
    Small Business38%
    Midsize Enterprise6%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise48%
    Large Enterprise39%
    Buyer's Guide
    Amazon EMR vs. Oracle Autonomous Data Warehouse
    March 2024
    Find out what your peers are saying about Amazon EMR vs. Oracle Autonomous Data Warehouse and other solutions. Updated: March 2024.
    768,924 professionals have used our research since 2012.

    Amazon EMR is ranked 9th in Cloud Data Warehouse with 20 reviews while Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews. Amazon EMR is rated 7.8, while Oracle Autonomous Data Warehouse is rated 8.6. The top reviewer of Amazon EMR writes "Provides efficient data processing features and has good scalability ". On the other hand, the top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". Amazon EMR is most compared with Snowflake, Cloudera Distribution for Hadoop, Azure Data Factory, Amazon Redshift and Apache Spark, whereas Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Amazon Redshift. See our Amazon EMR vs. Oracle Autonomous Data Warehouse report.

    See our list of best Cloud Data Warehouse vendors.

    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.