Azure SQL Data Warehouse

What is it?

A fully-managed, highly-scalable, data warehouse service that allows mix-n-match of OLTP and OLAP data sources.

Data Warehouse (OLAP) versus OLTP

Data Warehouse is essentially a star schema, non-OLTP database. This is to  be distinguished from a pure REPORTING database – which reports off OLTP data (typically, a READ REPLICA is provided of the production OLTP database).

Azure SQL DW – MPP (Oracle RAC like architecture)

Using a MPP (Massively Parallel Processing) design, the Azure DW breaks up larger queries into smaller chunks and distributes them across nodes (much like Oracle RAC does).

Polybase

Polybase allows querying of unstructured data in flat files. The Azure DW supports Polybase.

PaaS versus IaaS versus VDC

Azure DW is PaaS, which means that the resulting service will have a public IP. If a public IP is not acceptable, one is restricted to IaaS – preferably through a VDC. A Virtual Data Center (in Azure) is the equivalent of an AWS VPC.

What is Superdome?

Superdome is Microsoft (and HP’s) answer to Exadata (Oracle Exadata Database Machine (Exadata) is a combined compute and storage system optimized for running Oracle Database software.)

Specializing in high volume web and cloud application architecture, Anuj Varma’s customer base includes Fortune 100 companies (dell.com, British Petroleum, Schlumberger).
Anuj also offers a 1-day ‘technology crash course’ focused on cloud technologies for executives.
For Anuj’s specialized one-on-one executive seminars, visit ExecutiveTechnologySeminars
All content on this site is original and owned by anujvarma.com.

Anuj Varma – who has written posts on Anuj Varma, Technology Architect.


Leave a Reply

Your email address will not be published. Required fields are marked *