SQL Server 2016 sample database - Wide World Importers - 下載範例資料庫

Wide World Importers 是 SQL Server 2016 的新範例資料庫和 Azure SQL Database。

Wide World Importers 用於示範 SQL Server 2016 和 Azure SQL Database 的核心功能 ，包含：交易處理 (OLTP)、 資料倉儲和分析 (OLAP) 工作負載，以及混合式交易與分析處理 (HTAP) 工作負載。

OLTP	OnLine Transaction Processing，線上交易處理
Data Warehousing	資料倉儲
OLAP	Online analytical processing，線上分析
HTAP	Hybrid Transactional / Analytical Processing，混合式交易與分析處理

GitHub - sql-server-samples
Microsoft 已經範例資料庫：WideWorldImporters、AdventureWorks 各個版本、Contoso Retail Data Warehouse 等，放置於 GitHub 上。

---

下載 Wide World Importers 資料庫

GitHub 直接下載 bak

WideWorldImporters-Full.bak
https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/WideWorldImporters-Full.bak
適用於 OLTP(線上交易處理) 與 作業分析 HTAP(Hybrid Transactional/Analytical Processing，混合式交易式/分析處理) 的範例資料庫。

WideWorldImportersDW-Full.bak
https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/WideWorldImportersDW-Full.bak
適用於 資料倉儲(data warehousing) 和 分析處理 OLAP(Online analytical processing) 的範例資料庫。

到 GitHub 下載 Wide World Importers
https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

---

還原資料庫: Restore database

-- WideWorldImporters
USE [master]
RESTORE DATABASE [WideWorldImporters] 
FROM  DISK = N'C:\SQLBCK\WideWorldImporters-Full.bak' 
WITH  FILE = 1,  
 MOVE N'WWI_Primary' TO N'C:\TSQLDB\WideWorldImporters.mdf',  
 MOVE N'WWI_UserData' TO N'C:\TSQLDB\WideWorldImporters_UserData.ndf',  
 MOVE N'WWI_Log' TO N'C:\TSQLDB\WideWorldImporters.ldf',  
 MOVE N'WWI_InMemory_Data_1' TO N'C:\TSQLDB\WideWorldImporters_InMemory_Data_1',  
 NOUNLOAD,  STATS = 5
GO

-- WideWorldImportersDW
USE [master]
RESTORE DATABASE [WideWorldImportersDW] 
FROM  DISK = N'C:\SQLBCK\WideWorldImportersDW-Full.bak' 
WITH  FILE = 1,  
 MOVE N'WWI_Primary' TO N'C:\TSQLDB\WideWorldImportersDW.mdf',  
 MOVE N'WWI_UserData' TO N'C:\TSQLDB\WideWorldImportersDW_UserData.ndf',  
 MOVE N'WWI_Log' TO N'C:\TSQLDB\WideWorldImportersDW.ldf',  
 MOVE N'WWIDW_InMemory_Data_1' TO N'C:\TSQLDB\WideWorldImportersDW_InMemory_Data_1',  
 NOUNLOAD,  STATS = 5
GO

---

範例程式

sample-scripts.zip
https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/sample-scripts.zip

使用 WideWorldImporters、WideWorldImportersDW 資料庫的範例程式：

1. Always Encrypted
2. Dynamic Data Masking
3. Performance with In-Memory OLTP
4. Performance with Operational Analytics
5. Querying of External Data Source in WideWorldImportersDW
6. Row-Level Security

workload-drivers.zip
https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/workload-drivers.zip

Simple apps that simulate workloads for the WideWorldImporters sample database.

---

-- 100_Github-下載範例資料

-- 200_DB_Size

WideWorldImporters  約：3.3 GB
WideWorldImportersDW 約：4.2 GB

-- 201_已安裝的DB

-- 211_WideWorldImporters

-- 212_WideWorldImporters_檔案群組_記憶體最佳化資料

-- 213_WideWorldImporters_查詢存放區

-- 214_WideWorldImporters_由系統控制版本

---

參考資料

Wide World Importers 文件
https://docs.microsoft.com/zh-tw/sql/sample/world-wide-importers/wide-world-importers-documentation

Wide World Importers OLTP 資料庫
https://docs.microsoft.com/zh-tw/sql/sample/world-wide-importers/wide-world-importers-oltp-database

Wide World Importers 資料倉儲和分析資料庫
https://docs.microsoft.com/zh-tw/sql/sample/world-wide-importers/wide-world-importers-olap-database

WideWorldImporters 資料產生
https://docs.microsoft.com/zh-tw/sql/sample/world-wide-importers/data-generation

WideWorldImportersDW ETL 工作流程
https://docs.microsoft.com/zh-tw/sql/sample/world-wide-importers/etl-workflow

適用於 SQL Server 的教學課程
https://docs.microsoft.com/zh-tw/sql/sql-server/tutorials-for-sql-server-2016

Microsoft SQL Server Samples
https://docs.microsoft.com/en-us/sql/sample/microsoft-sql-server-samples

Wide World Importers Overview
https://docs.microsoft.com/en-us/sql/sample/world-wide-importers/overview

--

GitHub - sql-server-samples
https://github.com/Microsoft/sql-server-samples

GitHub - Wide World Importers sample database v1.0
https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

WideWorldImporters: The new SQL Server sample database
https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/09/wideworldimporters-the-new-sql-server-sample-database/

下載 Northwind 和 pubs 範例資料庫
http://sharedderrick.blogspot.tw/2012/03/northwind-pubs.html