Surrogate key
database
A unique primary key generated by the RDBMS that is not derived from any data in the database and whose only significance is to act as the primary key.
A surrogate key is frequently a sequential number (e.g. a Sybase “identity column”) but doesn’t have to be. Having the key independent of all other columns insulates the database relationships from changes in data values or database design and guarantees uniqueness.
Some database designers use surrogate keys religiously regardless of the suitability of other candidate keys. However, if a good key already exists, the addition of a surrogate key will merely slow down access, particularly if it is indexed.
Compare: intelligent key.
(1999-12-07)
Read Also:
- Surrogate-mother
noun 1. a person who acts in the place of another person’s biological mother. 2. an animal that is given another’s offspring to raise. 3. Medicine/Medical. a woman who helps a couple to have a child by carrying to term an embryo conceived by the couple and transferred to her uterus, or by being inseminated […]
- Surrogation
noun 1. a person appointed to act for another; deputy. 2. (in some states) a judicial officer having jurisdiction over the probate of wills, the administration of estates, etc. 3. the deputy of an ecclesiastical judge, especially of a bishop or a bishop’s chancellor. 4. a substitute. 5. a surrogate mother. adjective 6. regarded or […]
- Surround
verb (used with object) 1. to enclose on all sides; encompass: She was surrounded by reporters. 2. to form an enclosure round; encircle: A stone wall surrounds the estate. 3. to enclose (a body of troops, a fort or town, etc.) so as to cut off communication or retreat. noun 4. something that surrounds, as […]
- Surrounded
verb (used with object) 1. to enclose on all sides; encompass: She was surrounded by reporters. 2. to form an enclosure round; encircle: A stone wall surrounds the estate. 3. to enclose (a body of troops, a fort or town, etc.) so as to cut off communication or retreat. noun 4. something that surrounds, as […]
- Surrounding
noun 1. something that surrounds. 2. surroundings, environing things, circumstances, conditions, etc.; environment: He was too sick to be aware of his surroundings. 3. the act of encircling or enclosing. adjective 4. enclosing or encircling. 5. being the environment or adjacent area. verb (used with object) 1. to enclose on all sides; encompass: She was […]