Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in AI and Deep Learning by (17.6k points)

Are there any differences among a Surrogate Key, Synthetic Key, and an Artificial Key?

I'm not clear on the exact difference.

1 Answer

0 votes
by (41.4k points)
The Surrogate Key, Synthetic Key, and Artificial Key are synonyms. They all together mean that "primitive key that does not have a business meaning". They are different from natural or business keys that have a purpose behind the system at hand.

For example, consider the SO user account. We are recognized by two keys. We use the natural key as the identifier to login to this site, such as our OpenID name. However, because these things are large clumsy strings (and because SO grants us a choice of several login options) the database identifies us by a User ID that is a generated number. That UserID is a synthetic/surrogate/artifical key.

Browse Categories

...