Oracle · Human Resources (HR)
LOCATIONS
- Source rows
- 23
- Synthetic rows
- 23
- Broken foreign keys
- 0
- Rows equal to a source row
- 0%
References: COUNTRY_ID → COUNTRIES
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.
| LOCATION_ID key | STREET_ADDRESS | POSTAL_CODE | CITY | STATE_PROVINCE | COUNTRY_ID |
|---|---|---|---|---|---|
| Source database · 12 of 23 rows | |||||
| 1000 | 1297 Via Cola di Rie | 00989 | Roma | NULL | IT |
| 1100 | 93091 Calle della Testa | 10934 | Venice | NULL | IT |
| 1200 | 2017 Shinjuku-ku | 1689 | Tokyo | Tokyo Prefecture | JP |
| 1300 | 9450 Kamiya-cho | 6823 | Hiroshima | NULL | JP |
| 1400 | 2014 Jabberwocky Rd | 26192 | Southlake | Texas | US |
| 1500 | 2011 Interiors Blvd | 99236 | South San Francisco | California | US |
| 1600 | 2007 Zagora St | 50090 | South Brunswick | New Jersey | US |
| 1700 | 2004 Charade Rd | 98199 | Seattle | Washington | US |
| 1800 | 147 Spadina Ave | M5V 2L7 | Toronto | Ontario | CA |
| 1900 | 6092 Boxwood St | YSW 9T2 | Whitehorse | Yukon | CA |
| 2000 | 40-5-12 Laogianggen | 190518 | Beijing | NULL | CN |
| 2100 | 1298 Vileparle (E) | 490231 | Bombay | Maharashtra | IN |
| Synthetic database · 12 of 23 rows | |||||
| 1000 | Roma | 00010 | Roma | NULL | IT |
| 1095 | 85 King Central, Loop, Venice | 58345 | Venice | NULL | IT |
| 1190 | 109 King Central, Barton Hills, Tokyo | 1926MB | Tokyo | Tokyo Prefecture | JP |
| 1285 | 87 High Hillcrest, Hyde Park, Hiroshima | 27429 | Hiroshima | NULL | JP |
| 1380 | 1 High Central, Camden, Southlake | 2829 | Southlake | Texas | US |
| 1475 | 58 Bridge Oakwood, Surry Hills, Sydney | NULL | South San Francisco | California | US |
| 1570 | 29 Church Parkside, Didsbury, Manchester | 55680 | South Brunswick | New Jersey | US |
| 1665 | 78 Church West End, Ancoats, Seattle | 52111 | Seattle | Washington | US |
| 1760 | High, Toronto | 518 | Toronto | Ontario | CA |
| 1855 | 118 Park Oakwood, Downtown, Whitehorse | 22425-437 | Whitehorse | Yukon | CA |
| 1950 | 155 Park Parkside, Manly, Beijing | 963732 | Beijing | NULL | CN |
| 2045 | 123 King Hillcrest, Hackney, Bombay | 9390HW | Bombay | Maharashtra | IN |
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 |
|---|---|---|---|---|---|---|---|
| LOCATION_IDNUMBER(4,0) | record key | New key values | S 0% Y 0% | S 23 Y 23 | S 1000 → 3200 Y 1000 → 3090 | S 1000 4.3% · 1100 4.3% · 1200 4.3% · 1300 4.3% · 1400 4.3% · 1500 4.3% Y 1000 4.3% · 1095 4.3% · 1190 4.3% · 1285 4.3% · 1380 4.3% · 1475 4.3% | — |
| STREET_ADDRESSVARCHAR2(40 BYTE) | postal addresspersonal | New text in the measured format | S 0% Y 0% | S 23 Y 23 | S 19.4 chars avg Y 31.9 chars avg | S 1297 Via Cola di Rie 4.3% · 93091 Calle della Testa 4.3% · 2017 Shinjuku-ku 4.3% · 9450 Kamiya-cho 4.3% · 2014 Jabberwocky Rd 4.3% · 2011 Interiors Blvd 4.3% Y Roma 4.3% · 85 King Central, Loop, Venice 4.3% · 109 King Central, Barton Hills, Tokyo 4.3% · 87 High Hillcrest, Hyde Park, Hiroshima 4.3% · 1 High Central, Camden, Southlake 4.3% · 58 Bridge Oakwood, Surry Hills, Sydney 4.3% | 0% in source |
| POSTAL_CODEVARCHAR2(12 BYTE) | postal codepersonal | New text in the measured format | S 4.35% Y 4.35% | S 22 Y 22 | S 5.7 chars avg Y 5.5 chars avg | S 00989 4.5% · 10934 4.5% · 1689 4.5% · 6823 4.5% · 26192 4.5% · 99236 4.5% Y 00010 4.5% · 58345 4.5% · 1926MB 4.5% · 27429 4.5% · 2829 4.5% · 55680 4.5% | 0% in source |
| CITYVARCHAR2(30 BYTE) | city | Kept from the source as reference data | S 0% Y 0% | S 23 Y 23 | S 8 chars avg Y 8 chars avg | S Roma 4.3% · Venice 4.3% · Tokyo 4.3% · Hiroshima 4.3% · Southlake 4.3% · South San Francisco 4.3% Y Roma 4.3% · Venice 4.3% · Tokyo 4.3% · Hiroshima 4.3% · Southlake 4.3% · South San Francisco 4.3% | 0 TVD |
| STATE_PROVINCEVARCHAR2(25 BYTE) | region | Kept from the source as reference data | S 26.09% Y 26.09% | S 17 Y 17 | S 8.9 chars avg Y 8.9 chars avg | S Tokyo Prefecture 5.9% · Texas 5.9% · California 5.9% · New Jersey 5.9% · Washington 5.9% · Ontario 5.9% Y Tokyo Prefecture 5.9% · Texas 5.9% · California 5.9% · New Jersey 5.9% · Washington 5.9% · Ontario 5.9% | 0 TVD |
| COUNTRY_IDCHAR(2 BYTE) | country code | Foreign key, from the measured relationship | S 0% Y 0% | S 14 Y 14 | S 2 chars avg Y 2 chars avg | S US 17.4% · GB 13% · IT 8.7% · JP 8.7% · CA 8.7% · CH 8.7% Y US 17.4% · GB 13% · IT 8.7% · JP 8.7% · CA 8.7% · CH 8.7% | 0 TVD |