Employee

Employee

The employees test database: small, fake database of employees.

Original source: dev.mysql.com

Versions

  • Employee (by Jan Motl)

Dataset details

Associated task:
Regression
Domain:
Retail
Data types:
Size:
197.4 MB
Count of tables:
6
Count of rows:
3,911,392
Count of columns:
24
Missing values:
No
Compound keys:
No
Loops:
Yes
Type:
Synthetic
Instance count:
2,838,426
Target table:
salaries
Target column:
salary
Target ID:
emp_no
Target timestamp:
from_date

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: db.relational-data.org
    • port: 3306
    • username: guest
    • password: relational
  3. Export "employee" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).