AdventureWorks

AdventureWorks

Adventure Works 2014 (OLTP version) is a sample database for Microsoft SQL Server, which has replaced Northwind and Pub sample databases that were shipped earlier. The database is about a fictious, multinational bicycle manufacturer called Adventure Works Cycles.

Original source: msftdbprodsamples.codeplex.com

Versions

  • AdventureWorks2014 (by Jan Motl)

    • ported from MSSQL

Dataset details

Associated task:
Regression
Domain:
Retail
Data types:
Size:
233.8 MB
Count of tables:
71
Count of rows:
754,248
Count of columns:
486
Missing values:
Yes
Compound keys:
Yes
Loops:
Yes
Type:
Synthetic
Instance count:
31,223
Target table:
SalesOrderHeader
Target column:
TotalDue
Target ID:
CustomerID
Target timestamp:
OrderDate

How to download the dataset

The datasets are publicly available directly from MariaDB database.

  1. Open your favourite MariaDB client (MySQL Workbench works, but see FAQ)
  2. Use following credentials:
    • hostname: relational.fit.cvut.cz
    • port: 3306
    • username: guest
    • password: relational
  3. Export "AdventureWorks2014" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).