Identification - raisercostin/software-wiki GitHub Wiki

Surrogate vs Natural Keys
- https://en.wikipedia.org/wiki/Surrogate_key
- https://en.wikipedia.org/wiki/Natural_key
  - A natural key differs from a surrogate key which has no meaning outside the database itself and is not based on real-world observation or intended as a statement about the reality being modelled. A natural key therefore provides a certain data quality guarantee whereas a surrogate does not. It is common for elements of data to have several keys, any number of which may be natural or surrogate.
- https://www.reddit.com/r/compsci/comments/18gvkl/surrogate_vs_natural_keys_database_theory/
- https://blog.jooq.org/faster-sql-through-occasionally-choosing-natural-keys-over-surrogate-keys/
- https://www.mssqltips.com/sqlservertip/5431/surrogate-key-vs-natural-key-differences-and-when-to-use-in-sql-server/