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