Wide World Importers Documentation

Wide World Importers is the new sample database for SQL Server 2016 and Azure SQL Database. It illustrates the core capabilities of SQL Server 2016 and Azure SQL Database, for transaction processing (OLTP), data warehousing and analytics (OLAP) workloads, as well as hybrid transaction and analytics processing (HTAP) workloads.

About this sample

Wide World Importers is a comprehensive database sample that both illustrates database design, and illustrates how SQL Server features can be leveraged in an application.

Note that the sample is meant to be representative of a typical database. It does not include every feature of SQL Server. The design of the database follows one common set of standards, but there are many ways one might build a database.

Latest release: wide-world-importers-release

Source code for the sample: wide-world-importers.

Feedback: please send to sqlserversamples@microsoft.com.

The documentation for the sample is organized as follows:

Overview

Overview of the sample company Wide World Importers, and the workflows addressed by the sample.

Main OLTP Database WideWorldImporters

Instructions for the installation and configuration of the core database WideWorldImporters that is used for transaction processing (OLTP - OnLine Transaction Processing) and operational analytics (HTAP - Hybrid Transactional/Analytical Processing).

Description of the schemas and tables used in the WideWorldImporters database.

Describes how WideWorldImporters leverages core SQL Server features.

Sample queries for the WideWorldImporters database.

Data Warehousing and Analytics Database WideWorldImportersDW

Instructions for the installation and configuration of the OLAP database WideWorldImportersDW.

Description of the schemas and tables used in the WideWorldImportersDW database, which is the sample database for data warehousing and analytics processing (OLAP).

Workflow for the ETL (Extract, Transform, Load) process that migrates data from the transactional database WideWorldImporters to the data warehouse WideWorldImportersDW.

Describes how the WideWorldImportersDW leverages SQL Server features for analytics processing.

Sample analytics queries leveraging the WideWorldImportersDW database.

Data generation

Describes how additional data can be generated in the sample database, for example inserting sales and purchase data up to the current date.