Oracle 23.26.3.0.0
Human Resources (HR)
Employees, departments and locations. Pick a table to see the source and the synthetic copy together.
- Tables
- 7
- Rows, source
- 216
- Rows, synthetic
- 216
- Broken foreign keys
- 0 10 foreign keys checked on the data
The profile
Lyrebird read the source once and wrote this profile. The synthetic database was generated from the profile alone, with no connection to the source.
- Profile file
- 31 KB
- Relationships measured
- 10
- Rules tested / kept
- 128 / 1
- Personal columns found
- 6
- Tables with reference data
- 5
Generate it yourself
This is the same sealed profile that produced the copy on these pages. It holds no connection details, and you need no database to use it.
Download lyrebird-sample-human-resources.lyre- Install Lyrebird Community, open it and go to Generate.
- Choose the downloaded file as the profile, then choose an output folder.
- Generate the SQL files, and load them into an empty Oracle database or let Lyrebird load them into Docker.
Community generates up to 5,000 rows per table and keeps complete reference data as it is. Every table of this sample fits within that limit.
Lyrebird Community 0.4.0
This release on GitHub31 KB · SHA-256 ec41b63ab2ef728b1cd0e1bdf3dc1322d6e40f8e96db48d556c91ed9e415c342
Tables
| Table | Columns | Source rows | Synthetic rows | Equal to a source row |
|---|---|---|---|---|
| COUNTRIES | 3 | 25 | 25 | 100% |
| DEPARTMENTS | 4 | 27 | 27 | 100% |
| EMPLOYEES | 11 | 107 | 107 | 0% |
| JOBS | 4 | 19 | 19 | 100% |
| JOB_HISTORY | 5 | 10 | 10 | 20% |
| LOCATIONS | 6 | 23 | 23 | 0% |
| REGIONS | 2 | 5 | 5 | 100% |
About this data
Oracle Database Sample Schemas (HR), copyright (c) Oracle and/or its affiliates. Source: Human Resources (HR), MIT license. Subsetra is not affiliated with its authors.
Generated with Lyrebird 0.4.0 (af70e35), model v2.3, seed 20261101, at the size of the source. Profile hash: 5b4faf8c49a55ad4.