Advertisement

Surrogate Keys: Paving the Way for Graph / NoSQL Data Models

Click to learn more about video blogger Thomas Frisendal. Since the mid-seventies many SQL-databases have been modeled using the concept of surrogate keys: Non-information bearing primary keys Used for join purposes (inter-table relationships) System generated (integer) values Not to be shown to end-users The advantage of using surrogate keys is guaranteed persistence, even across changes in […]