Lyrebird · Realistic synthetic test databases, generated fully offline

Oracle · Human Resources (HR)

COUNTRIES

Source rows
25
Synthetic rows
25
Broken foreign keys
0
Rows equal to a source row
100%

Every synthetic row matches a source row outside its keys. Kept reference data and resampled source values match by design, and columns with few possible values can match by chance: see how each column was generated below. You can review, replace or remove kept values before you publish a profile.

References: REGION_ID → REGIONS

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.

COUNTRY_ID keyCOUNTRY_NAMEREGION_ID
Source database · 12 of 25 rows
ARArgentina20
AUAustralia40
BEBelgium10
BRBrazil20
CACanada20
CHSwitzerland10
CNChina30
DEGermany10
DKDenmark10
EGEgypt50
FRFrance10
GBUnited Kingdom of Great Britain and Northern Ireland10
Synthetic database · 12 of 25 rows
ARArgentina18
AUAustralia26
BEBelgium18
BRBrazil26
CACanada26
CHSwitzerland26
CNChina26
DEGermany10
DKDenmark26
EGEgypt10
FRFrance42
GBUnited Kingdom of Great Britain and Northern Ireland18

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
COUNTRY_IDCHAR(2 BYTE) record key New key values S 0%
Y 0%
S 25
Y 25
S 2 chars avg
Y 2 chars avg
S AR 4% · AU 4% · BE 4% · BR 4% · CA 4% · CH 4%
Y AR 4% · AU 4% · BE 4% · BR 4% · CA 4% · CH 4%
—
COUNTRY_NAMEVARCHAR2(60 BYTE) country name Kept from the source as reference data S 0%
Y 0%
S 25
Y 25
S 9.4 chars avg
Y 9.4 chars avg
S Argentina 4% · Australia 4% · Belgium 4% · Brazil 4% · Canada 4% · Switzerland 4%
Y Argentina 4% · Australia 4% · Belgium 4% · Brazil 4% · Canada 4% · Switzerland 4%
0 TVD
REGION_IDNUMBER record key Foreign key, from the measured relationship S 0%
Y 0%
S 5
Y 5
S 10 → 50
Y 10 → 42
S 10 32% · 30 28% · 20 20% · 50 16% · 40 4%
Y 26 32% · 18 28% · 10 20% · 42 16% · 34 4%
0.28 KS