什么是 Azure SQL 数据仓库?What is Azure SQL Data Warehouse?

SQL 数据仓库是基于云的企业数据仓库 (EDW),可利用大规模并行处理 (MPP) 对数 PB 的数据快速运行复杂的查询。SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that uses Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. 将 SQL 数据仓库用作大数据解决方案的关键组件。Use SQL Data Warehouse as a key component of a big data solution. 使用简单的 PolyBase T-SQL 查询将大数据导入 SQL 数据仓库,然后利用 MPP 运行高性能分析。Import big data into SQL Data Warehouse with simple PolyBase T-SQL queries, and then use the power of MPP to run high-performance analytics. 进行集成和分析时,数据仓库是企业获取见解能够依赖的唯一事实来源。As you integrate and analyze, the data warehouse will become the single version of truth your business can count on for insights.

大数据解决方案的关键组件Key component of big data solution

SQL 数据仓库是云中端到端大数据解决方案的关键组件。SQL Data Warehouse is a key component of an end-to-end big data solution in the Cloud.

数据仓库解决方案

在云数据解决方案中,可从各种源将数据引入大数据存储中。In a cloud data solution, data is ingested into big data stores from a variety of sources. 将数据置于大数据存储中以后,Hadoop、Spark 和机器学习算法就可以准备和训练数据。Once in a big data store, Hadoop, Spark, and machine learning algorithms prepare and train the data. 当数据准备就绪,可以进行复杂的分析时,SQL 数据仓库就会使用 PolyBase 来查询大数据存储。When the data is ready for complex analysis, SQL Data Warehouse uses PolyBase to query the big data stores. PolyBase 使用标准 T-SQL 查询将数据引入 SQL 数据仓库中。PolyBase uses standard T-SQL queries to bring the data into SQL Data Warehouse.

SQL 数据仓库通过列存储将数据存储到关系表中。SQL Data Warehouse stores data into relational tables with columnar storage. 此格式可显著降低数据存储费用,改进查询性能。This format significantly reduces the data storage costs, and improves query performance. 将数据存储到 SQL 数据仓库以后,即可大规模地运行分析。Once data is stored in SQL Data Warehouse, you can run analytics at massive scale. 与传统数据库系统相比,数分钟的分析查询只需数秒即可完成,数天的查询只需数小时。Compared to traditional database systems, analysis queries finish in seconds instead of minutes, or hours instead of days.

分析结果可以传输到世界各地的报告数据库或应用程序。The analysis results can go to worldwide reporting databases or applications. 然后即可通过业务分析获得进行明智的业务决策所需的见解。Business analysts can then gain insights to make well-informed business decisions.

后续步骤Next steps