Azure SQL中的“群集列存储索引"表与Azure数据仓库中的表有什么区别? [英] What is the difference between a Clustered Columnstore Index table in Azure SQL and a table in Azure Data Warehouse?

问题描述

常规SQL Azure SQL中的群集的列存储索引"表和有什么区别?和Azure数据仓库中的表?

What is the difference between a Clustered Columnstore Index table in Regular SQL Azure SQL,  and a table in Azure Data Warehouse?

它们都有柱状存储，没有外键，没有主键，等等.

They both have columnar storage,  no foreign keys, no primary keys , etc.

从结构上看，它们是相同的.那么有什么区别呢?

Seems structurally they are the same. So what would be the difference?

推荐答案

在它们的根源上，它们实际上是相同的.实际上，Azure SQL数据仓库在Azure SQL数据库的多个副本上运行，因此(从根本上)它是相同的技术.但是，关键是数据仓库有60个不同的副本 它下面的SQL数据库的功能，将计算能力分布在所有这些不同的数据库中.主要区别在于并行处理.这两种技术不能达到相同的目的.您需要Azure SQL数据仓库 当您需要处理海量数据负载，并且想在不设置基础架构来支持此类任务的情况下将大量服务器投入该问题时.在需要数据库时，需要Azure SQL数据库.

At the root of them both, they're effectively the same. In fact, Azure SQL Data Warehouse is running on multiple copies of Azure SQL Database, so it's identical technology (at the root). However, the key is that the Data Warehouse has 60 different copies of the SQL Database underneath it, distributing the computing power across all those different databases. It's that parallel processing that is the major differentiator. These two technologies don't serve the same purpose. You need Azure SQL Data Warehouse when you need to process massive data loads and want to throw lots of servers at the problem without having to set up the infrastructure to support such an undertaking. You want Azure SQL Database when... you need a database. 

这篇关于Azure SQL中的“群集列存储索引"表与Azure数据仓库中的表有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！