Credit
A bit more complex artificial database with loops.
Original source: www.sqlskills.com
Versions
Credit (by Jan Motl)
- Removed 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.
- Open your favourite MariaDB client (MySQL Workbench works, but see FAQ)
- Use following credentials:
- hostname: relational.fel.cvut.cz
- port: 3306
- username: guest
- password: ctu-relational
- Export "Credit" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).