Oracle · Human Resources (HR)
EMPLOYEES
- Source rows
- 107
- Synthetic rows
- 107
- Broken foreign keys
- 0
- Rows equal to a source row
- 0%
References: DEPARTMENT_ID → DEPARTMENTSJOB_ID → JOBSMANAGER_ID → EMPLOYEES
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.
| EMPLOYEE_ID key | FIRST_NAME | LAST_NAME | PHONE_NUMBER | HIRE_DATE | JOB_ID | SALARY | COMMISSION_PCT | MANAGER_ID | DEPARTMENT_ID | |
|---|---|---|---|---|---|---|---|---|---|---|
| Source database · 12 of 107 rows | ||||||||||
| 100 | Steven | King | SKING | 1.515.555.0100 | 2013-06-17 00:00:00 | AD_PRES | 24000 | NULL | NULL | 90 |
| 101 | Neena | Yang | NYANG | 1.515.555.0101 | 2015-09-21 00:00:00 | AD_VP | 17000 | NULL | 100 | 90 |
| 102 | Lex | Garcia | LGARCIA | 1.515.555.0102 | 2011-01-13 00:00:00 | AD_VP | 17000 | NULL | 100 | 90 |
| 103 | Alexander | James | AJAMES | 1.590.555.0103 | 2016-01-03 00:00:00 | IT_PROG | 9000 | NULL | 102 | 60 |
| 104 | Bruce | Miller | BMILLER | 1.590.555.0104 | 2017-05-21 00:00:00 | IT_PROG | 6000 | NULL | 103 | 60 |
| 105 | David | Williams | DWILLIAMS | 1.590.555.0105 | 2015-06-25 00:00:00 | IT_PROG | 4800 | NULL | 103 | 60 |
| 106 | Valli | Jackson | VJACKSON | 1.590.555.0106 | 2016-02-05 00:00:00 | IT_PROG | 4800 | NULL | 103 | 60 |
| 107 | Diana | Nguyen | DNGUYEN | 1.590.555.0107 | 2017-02-07 00:00:00 | IT_PROG | 4200 | NULL | 103 | 60 |
| 108 | Nancy | Gruenberg | NGRUENBE | 1.515.555.0108 | 2012-08-17 00:00:00 | FI_MGR | 12008 | NULL | 101 | 100 |
| 109 | Daniel | Faviet | DFAVIET | 1.515.555.0109 | 2012-08-16 00:00:00 | FI_ACCOUNT | 9000 | NULL | 108 | 100 |
| 110 | John | Chen | JCHEN | 1.515.555.0110 | 2015-09-28 00:00:00 | FI_ACCOUNT | 8200 | NULL | 108 | 100 |
| 111 | Ismael | Sciarra | ISCIARRA | 1.515.555.0111 | 2015-09-30 00:00:00 | FI_ACCOUNT | 7700 | NULL | 108 | 100 |
| Synthetic database · 12 of 107 rows | ||||||||||
| 100 | Evelyn | Ja | OIHYVP | 1.210.736.7491 | 2015-04-11 12:17:13 | SA_REP | 3200 | NULL | NULL | 244 |
| 101 | Scott | Anderson | GSXAHQ | 1.888.717.9708 | 2014-01-16 21:42:45 | SH_CLERK | 19850 | NULL | 100 | 163 |
| 102 | Ethan Emma | Anderson | VMHXRLSW | 1.870.315.2882 | 2015-03-04 17:11:47 | SA_REP | 4672 | NULL | 100 | 163 |
| 103 | Ash | Turner | EFSAVJ | 1.513.496.1797 | 2015-02-27 18:39:39 | ST_CLERK | 8426 | NULL | 100 | 163 |
| 104 | Brooklyn | Adams | PVAOUGFZ | 1.567.849.4374 | 2014-11-03 23:53:32 | ST_CLERK | 2884 | NULL | 100 | 244 |
| 105 | Mason Liam | Moreno | HYMIJ | 1.773.443.5188 | 2018-03-14 22:07:04 | HR_REP | 2564 | NULL | 100 | 244 |
| 106 | Ariana | Edwards | HGYEGL | 1.758.725.2382 | 2015-08-23 22:27:53 | ST_CLERK | 3232 | NULL | 100 | 244 |
| 107 | Mason | Fox | NTUCESZ | 1.506.828.0310 | 2012-10-25 00:37:43 | SH_CLERK | 2932 | NULL | 100 | 163 |
| 108 | Brooklyn | Coleman | VWMPECVZ | 1.762.231.4749 | 2015-06-02 12:36:51 | SH_CLERK | 7792 | NULL | 100 | 244 |
| 109 | Liam Liam | Evans | JUPNCTK | 1.843.799.1171 | 2012-06-07 00:00:00 | SA_REP | 6536 | 0.15 | 100 | 244 |
| 110 | Isaac Emma | Washington | WTFOJVII | 1.640.346.0045 | 2018-02-12 00:33:26 | SH_CLERK | 3154 | 0.2 | 100 | 163 |
| 111 | Zoey | Cooper | IOPYYSFD | 1.905.318.4758 | 2018-02-08 23:49:01 | SH_CLERK | 2554 | NULL | 100 | 163 |
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 |
|---|---|---|---|---|---|---|---|
| EMPLOYEE_IDNUMBER(6,0) | record key | New key values | S 0% Y 0% | S 107 Y 107 | S 100 → 206 Y 100 → 206 | S — Y — | — |
| FIRST_NAMEVARCHAR2(20 BYTE) | first namepersonal | New text in the measured format | S 0% Y 0% | S 92 Y 77 | S 5.8 chars avg Y 5.4 chars avg | S David 2.8% · John 2.8% · Steven 1.9% · Alexander 1.9% · Karen 1.9% · Kevin 1.9% Y Liam 4.7% · Mason 2.8% · William 2.8% · Em 2.8% · Hannah 2.8% · Evelyn 1.9% | 9.3% in source |
| LAST_NAMEVARCHAR2(25 BYTE) | last namepersonal | New text in the measured format | S 0% Y 0% | S 102 Y 73 | S 5.9 chars avg Y 5.8 chars avg | S — Y Anderson 9.3% · Adams 2.8% · Powell 2.8% · Peterson 2.8% · James 2.8% · Bailey 2.8% | 13.1% in source |
| EMAILVARCHAR2(25 BYTE) | emailpersonal | New key values | S 0% Y 0% | S 107 Y 107 | S 6.6 chars avg Y 6.6 chars avg | S — Y — | 0% in source |
| PHONE_NUMBERVARCHAR2(20 BYTE) | phone numberpersonal | New text in the measured format | S 0% Y 0% | S 107 Y 107 | S 14 chars avg Y 14 chars avg | S — Y — | 0% in source |
| HIRE_DATEDATE | lifecycle timestamp | Times from the measured distribution | S 0% Y 0% | S 98 Y 105 | S 2011-01-13 00:00:00 → 2018-04-21 00:00:00 Y 2011-04-24 03:24:08 → 2018-04-21 00:00:00 | S 2012-06-07 00:00:00 3.7% · 2017-02-07 00:00:00 1.9% · 2015-08-20 00:00:00 1.9% · 2015-03-10 00:00:00 1.9% · 2018-04-21 00:00:00 1.9% · 2016-01-24 00:00:00 1.9% Y — | 0.093 KS |
| JOB_IDVARCHAR2(10 BYTE) | record key | Foreign key, from the measured relationship | S 0% Y 0% | S 19 Y 19 | S 7.1 chars avg Y 7.1 chars avg | S SA_REP 28% · ST_CLERK 18.7% · SH_CLERK 18.7% · IT_PROG 4.7% · FI_ACCOUNT 4.7% · PU_CLERK 4.7% Y SA_REP 28% · SH_CLERK 18.7% · ST_CLERK 18.7% · PU_CLERK 4.7% · FI_ACCOUNT 4.7% · SA_MAN 4.7% | 0 TVD |
| SALARYNUMBER(8,2) | monetary amount | Numbers from the measured histogram | S 0% Y 0% | S 58 Y 103 | S 2100 → 24000 Y 2122 → 19850 | S 2500.0 5.6% · 9000.0 3.7% · 3100.0 3.7% · 2800.0 3.7% · 2600.0 3.7% · 3200.0 3.7% Y — | 0.084 KS |
| COMMISSION_PCTNUMBER(2,2) | percentage | Source values, at measured frequencies | S 67.29% Y 67.29% | S 7 Y 7 | S 0.1 → 0.4 Y 0.1 → 0.4 | S 0.3 20% · 0.2 20% · 0.25 17.1% · 0.1 17.1% · 0.15 14.3% · 0.35 8.6% Y 0.3 20% · 0.25 20% · 0.2 17.1% · 0.15 14.3% · 0.1 14.3% · 0.35 11.4% | 0.057 KS |
| MANAGER_IDNUMBER(6,0) | record key | Foreign key, from the measured relationship | S 0.93% Y 0.93% | S 18 Y 18 | S 100 → 205 Y 100 → 117 | S 100 13.2% · 120 7.5% · 121 7.5% · 122 7.5% · 123 7.5% · 124 7.5% Y 100 13.2% · 101 7.5% · 102 7.5% · 103 7.5% · 104 7.5% · 105 7.5% | 0.679 KS |
| DEPARTMENT_IDNUMBER(4,0) | record key | Foreign key, from the measured relationship | S 0.93% Y 0.93% | S 11 Y 11 | S 10 → 110 Y 10 → 244 | S 50 42.5% · 80 32.1% · 100 5.7% · 30 5.7% · 60 4.7% · 90 2.8% Y 244 42.5% · 163 32.1% · 100 5.7% · 208 5.7% · 55 4.7% · 10 2.8% | 0.858 KS |