Credit

Credit

A bit more complex artificial database with loops.

Original source: www.sqlskills.com

Versions

  • Credit (by Jan Motl)

    • remove user defined data types

Dataset details

Associated task:
Classification
Domain:
Retail
Data types:
Size:
317.9 MB
Count of tables:
9
Count of rows:
1,640,796
Count of columns:
75
Missing values:
Yes
Compound keys:
No
Loops:
Yes
Type:
Synthetic
Instance count:
9,861
Target table:
member
Target column:
region_no
Target ID:
member_no
Target timestamp:
issue_dt

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 "Credit" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).