\sˈʌɹəɡˌe͡ɪt kˈiː], \sˈʌɹəɡˌeɪt kˈiː], \s_ˈʌ_ɹ_ə_ɡ_ˌeɪ_t k_ˈiː]\
Definitions of SURROGATE KEY
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
- someone who saves something from danger or violence One who recovers. The demandant in a common recovery, after judgment has been given his favor.