Amazon Redshift
This action still needs to be done manually by a DBA.
What is tuning the data warehouse?
Azure's SQL DW requires a lot of this action from an experienced DBA.
What is manual tuning?
Google's BigQuery run's on this platform.
What is Google Cloud?
Snowflake is a fully managed DWaaS running on this infrastructure.
What is AWS?
For conversations regarding data warehousing, we should lead with this topic.
What is analytics?
This is the average cost of a market research workload running on Redshift (8 nodes), compared to ADW's $0.02.
What is $0.27?
In order to do this action with Azure SQL DW, you must do massive redistributions of data.
What is scaling?
BigQuery can run this many queries concurrently, where as ADW can run a limitless number.
What is 50?
Snowflake was founded in this year.
What is 2015?
Oracle is the only vendor to offer this data warehousing feature.
What is autonomous?
In Redshift, this thing cannot be scaled independent of storage, but can with ADW.
What is compute?
Azure's downtime SLA is this much per year on average, as opposed to ADW's <30 min per year.
What is >8 hrs 45 min/year?
This is BigQuery's availability SLA, compared to Oracle's 99.995%.
What is 99.9%?
Snowflake does not have very extensive tools when it comes to these 2 actions, which creates the need to use a 3rd party.
What is charting and reporting?
Oracle beat out this competitor in our win with Great-West Financial due to better enterprise scale and performance.
What is AWS?
This is Redshift's annual downtime SLA, excluding unplanned downtime, compared to ADW's <30 min/year.
What is >4 hours/year?
Azure SQL DW allows up to this many concurrent queries (max), while ADW has no limit.
What is 32?
Gartner ranked Google's BigQuery the lowest of its competitors for this use case.
What is traditional DW?
Gartner ranked Snowflake the lowest of its competitors for this use case.
What is logical DW?
Oracle is more elastic and easier to scale than its competitors because of these reasons (name 2 of 3).
1. OCPUs and storage not constrained by fixed blocks.
2. Compute and storage can be scaled independently.
3. Idle compute can be shut off.
This metric is severely limited with Redshift, making it unsuitable for large data warehouses.
What are concurrency levels?
Gartner ranked Azure SQL DW the lowest of its competitors for this use case.
What is real-time DW?
BigQuery launched in this year.
What is 2012?
This is Snowflake's availability SLA, compared to Oracle's 99.995%.
What is 99.9%?
These internal assets were provided at the end of the powerpoint.
What are compete guides?