21CTO

Sep 27, 2015 · Databases

Using Physical Primary Keys as Foreign Keys and Implementing Optimistic Locks

This article explains two key relational database design techniques: using auto‑increment or UUID physical primary keys for foreign key relationships, and employing optimistic locking with a version column to safely handle concurrent updates, while also covering when locks can be omitted.