SURROGATE KEY
\sˈʌɹəɡˌe͡ɪt kˈiː], \sˈʌɹəɡˌeɪt kˈiː], \s_ˈʌ_ɹ_ə_ɡ_ˌeɪ_t k_ˈiː]\
Sort: Oldest first
-
A unique primary key generated by the RDBMSthat is not derived from any data in the database and whoseonly significance is to act as the primary key.A surrogate key is frequently a sequential number (e.g. aSybase "identity column") but doesn't have to be. Havingthe key independent of all other columns insulates thedatabase relationships from changes in data values or databasedesign and guarantees uniqueness.Some database designers use surrogate keys religiouslyregardless of the suitability of other candidate keys.However, if a good key already exists, the addition of asurrogate key will merely slow down access, particularly if itis indexed.Compare: intelligent key.
By Denis Howe
Word of the day
tinctura quininae ammoniata
- A preparation made by dissolving quinin sulphate in alcohol [Br. Ph.].