MySQL · Chinook
Artist
- Source rows
- 275
- Synthetic rows
- 275
- Broken foreign keys
- No foreign keys
- Rows equal to a source row
- 0%
Rows
Both databases, first rows by primary key, in one table: scrolling sideways moves them together. Rows at the same position are unrelated, unless the table holds kept reference data. Long values are cut at 60 characters.
| ArtistId key | Name |
|---|---|
| Source database · 12 of 275 rows | |
| 1 | AC/DC |
| 2 | Accept |
| 3 | Aerosmith |
| 4 | Alanis Morissette |
| 5 | Alice In Chains |
| 6 | Antônio Carlos Jobim |
| 7 | Apocalyptica |
| 8 | Audioslave |
| 9 | BackBeat |
| 10 | Billy Cobham |
| 11 | Black Label Society |
| 12 | Black Sabbath |
| Synthetic database · 12 of 275 rows | |
| 1 | John Castillo |
| 2 | Samuel Campbell |
| 3 | Raymond Jordan |
| 4 | Grace Hart |
| 5 | Caleb Jordan |
| 6 | Caleb Thompson |
| 7 | Sarah Fuchs |
| 8 | Luna Woods |
| 9 | Sarah Jackson |
| 10 | Kennedy Davis |
| 11 | Caleb Phillips |
| 12 | Katherine Anderson |
Column by column
Each figure is computed from all rows of both databases in the same way. S is the source, Y the synthetic copy. Difference runs from 0 (same distribution) to 1 (no overlap): Kolmogorov-Smirnov for numbers and times, total variation for columns with few values. Personal columns are meant to differ, so they show how many values also appear in the source instead. Lyrebird draws names from built-in lists, not from the source, so common names can match.
| Column | Model read it as | How it was generated | Empty | Distinct | Range or length | Most common | Difference |
|---|---|---|---|---|---|---|---|
| ArtistIdint | record key | New key values | S 0% Y 0% | S 275 Y 275 | S 1 → 275 Y 1 → 275 | S — Y — | — |
| Namevarchar(120) | person namepersonal | New text in the measured format | S 0% Y 0% | S 275 Y 275 | S 20.6 chars avg Y 12.7 chars avg | S — Y — | 0% in source |