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 MySQL database.

  1. Open your favourite MySQL client (for example MySQL Workbench)
  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).