Structured Primary Keys
Summary
The article argues for using structured primary keys that combine foreign keys with additional proxy columns to maintain data integrity and improve performance. It compares structured keys with traditional surrogate keys, discusses space efficiency, per-parent sequencing, and cyclic consistency, and provides practical guidance on when and how to apply this approach in a web-shop schema. It also covers denormalization concerns and highlights trade-offs for real-world database design.