Data model and datasets
Every provider runs on the same schema and the same generated rows. Seed 20260101.
Data model
| Entity | Table | Mapping |
|---|---|---|
| Category | CATEGORY | plain entity |
| Product | PRODUCT | @ManyToMany categories (join table PRODUCT_CATEGORY), @ElementCollection tags (PRODUCT_TAG) |
| Customer | CUSTOMER | @Embedded Address, @OneToMany(mappedBy) orders |
| PurchaseOrder | ORDERS | @Version, @ManyToOne(LAZY) customer, @Enumerated(STRING) status, @OneToMany(mappedBy, cascade ALL) lines |
| OrderLine | ORDER_LINE | @ManyToOne(LAZY) order, @ManyToOne(LAZY) product |
| StPerson, StEmployee, StContractor | ST_PERSON | abstract root, @Inheritance(SINGLE_TABLE), discriminator PTYPE (EMP, CON) |
| JnPerson, JnEmployee, JnContractor | JN_PERSON, JN_EMPLOYEE, JN_CONTRACTOR | abstract root, @Inheritance(JOINED), discriminator PTYPE (EMP, CON) |
Generation
- DataGenerator draws every value from one SplittableRandom with the seed, in a fixed order.
- Ids are assigned by the application, dense 1..n per table; no IDENTITY, no sequences.
- Schema from bench-data/src/main/resources/ddl/<db>.sql only; providers never generate it.
- Loaded with plain JDBC, then ANALYZE; write benchmarks reset the affected tables before every iteration.
- The checksum is a 64-bit FNV-1a over every generated row (an order includes its lines).
- products = 500 x scale, customers = 1000 x scale, orders = 5 per customer
- 1-5 lines per order, 1-3 categories and 0-4 tags per product, 25 categories
- persons = 1000 x scale per inheritance hierarchy, 70% employees, 30% contractors
- orders dated 2024-01-01 + 0..729 days; status NEW 10%, PAID 15%, SHIPPED 15%, DELIVERED 55%, CANCELLED 5%
Sizes
| Table | S (×1) | M (×10) | L (×50) |
|---|---|---|---|
CATEGORY | 25 | 25 | 25 |
PRODUCT | 500 | 5,000 | 25,000 |
PRODUCT_CATEGORY | 990 | 9,946 | 49,751 |
PRODUCT_TAG | 973 | 9,986 | 49,657 |
CUSTOMER | 1,000 | 10,000 | 50,000 |
ORDERS | 5,000 | 50,000 | 250,000 |
ORDER_LINE | 14,922 | 150,083 | 749,408 |
ST_PERSON | 1,000 | 10,000 | 50,000 |
JN_PERSON | 1,000 | 10,000 | 50,000 |
JN_EMPLOYEE | 712 | 7,066 | 35,004 |
JN_CONTRACTOR | 288 | 2,934 | 14,996 |
| generated records | 8,525 | 85,025 | 425,025 |
| checksum | 17f556d4e3d90c3d | f9af4488decbf21d | e0c1eeb56b6b09ca |
Generated records count an order with its lines as one record. Every run logs the checksum of the data it loaded; a run page flags data that differs from this table.
Datasets per run
| Run | Datasets |
|---|---|
| 2026-11-15-macbook-pro-m5-max-rzo1 | S |