Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Tuesday, 31 May 2016

New Sample Database: Wide World Importers



Microsoft have replaced the the Adventure Works Sample Databases. There was Pubs, then Adventures Works and now Wide World Importers. Wide World Importers is a sample database that both illustrates database design, and how SQL Server and Azure SQL Database features can be leveraged in an application.

The sample database represents a typical database. The Wide World Importers database can be used for  transaction processing (OLTP - Online Transaction Processing) and operational analytics (HTAP - Hybrid Transaction and Analytics Processing). There are sample queries, processes for ETL (Extract, Transform, Load) that migrates data from the transactional database WideWorldImporters to the data warehouse WideWorldImportersDW and descriptions that show how to leverage SQL Server features for analytics processing.

Applies to: SQL Server 2016 (or higher), Azure SQL Database
Features including: Core database features, PolyBase, nonclustered columnstore index, Row-Level Security
Workload types: OLTP, OLAP, IoT, Analytics, Operational Analytics
Programming Language: T-SQL, C#

No comments:

Post a Comment

Note: only a member of this blog may post a comment.