Comparing Data Warehouse CloudsAWS Redshift vs Oracle Autonomous Data Warehouse Cloud
Amazon vs Oracle: Data Warehouse Services, How do They Compare?
Emerging information technology trends in the Cloud have the power to transform organizations. In the data management and analytics space, two key Cloud service offerings have arrived that touch on this theme; Amazon’s Redshift and Oracle’s Autonomous Data Warehouse Cloud (ADW).
Amazon’s Redshift is a data warehouse based on PostgresSQL and runs on general purpose hardware.
Oracle’s Autonomous Data Warehouse Cloud (ADW) is a data warehouse based on Oracle Database and runs on Oracle Exadata, an Engineered System designed for high performance Oracle Database workloads.
Both services simplify the provisioning, maintenance, and optimizations for data warehouse workloads in the Cloud, and both promote “no database administrators are required” and “load and pull” approaches to data analytics. In other words, users just start the service, define tables, load data, and then run their queries.
In this paper, Viscosity North America (Viscosity) shares their findings from a series of benchmarks comparing the performance of Redshift and Autonomous Data Warehouse Cloud (ADW).
*This paper does not cover Cloud configuration, manageability or on-going supportability. This will be included in a follow-up document.
As both Redshift and ADW services are fully managed and autonomous (e.g. no manual intervention is required to tune analytic queries), the goal of this exercise was to quantify “out of the box” response times for data loading, query performance, and query throughput, on similarly sized configurations.
What tests did Viscosity perform?
A Data Load test to determine overall database ingest time.
Serial Query Execution testing
Query Throughput tests, including a more complex query to determine of volume of executions per hour.
“Well, which one is cheaper?” This is the most popular question to ask and the hardest to answer.
This paper includes a brief price performance comparison, and Viscosity plans to come out with a more in-depth paper on pricing alone.
Because it is not the same answer for everyone, it is highly recommended that you have a third party vendor do an analysis of your environment, budget, and priority needs to determine the most cost effective path for you.
Email email@example.com for a good starting place.
To learn more about Viscosity’s findings, see our official statement here.
Chief Technology Officer, Viscosity
Nitin Vengurlekar is the co-founder and CTO of Viscosity North America. At Viscosity, Nitin is responsible for Service delivery, Partner relationship and end-2-end solution architecture. Nitin’s main emphasis has been on virtualization, Oracle Engineered Systems, Hyper-Converged Systems, and Public/Private Database Cloud implementations.
Nitin is a well-known Oracle technologist and speaker in the areas of Oracle Storage, high availability, Oracle RAC, and private database cloud. He is the author of Database Cloud Storage, Oracle Automatic Storage Management, and the Data Guard Handbook. He has also written many papers on storage, database internals, database tuning, and served as a contributor to Oracle documentation as well as Oracle education material.
Chief Innovation Officer, Viscosity
Rich Niemiec is the current Chief Innovation Officer of Viscosity North America. Rich is an Oracle Ace Director, a world renowned IT Expert, and was a co-founder and the CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions started in 1988. Rich has served as President of Rolta TUSC and Rolta EICT.
Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). Rich has architected and tuned many Fortune 500 systems over the past 25 years.
His experience in data processing ranges from teaching to consulting, with emphasis in database administration, performance tuning, project management and technical education. Rich is one of six originally honored worldwide Oracle Certified Masters and advised Oracle development from time to time. In 2017, he authored the Oracle “Oracle12c Performance Tuning Tips & Techniques,” an update of his previous 4 Oracle best sellers on Oracle8i, 9i, 10g, and 11i Performance Tuning. Rich was inducted into the Entrepreneurship Hall of Fame in 1998.