Word:

intelligent key

(database)intelligent key - A relational database key which depends wholely on one or more other columns in the same table. An intelligent key might be identified for implementation convenience, where there is no good candidate key.

For example, if the three-letter initials of a group of people are known to be unique but only their full names are recorded, a three letter acronym for their names (e.g. John Doe Smith -> JDS) would be an intelligent key.

Intelligent keys are a Bad Thing because it is hard to guarantee uniqueness, and if the value on which an intelligent key depends changes then the key must either stay the same, creating an inconsistency within the containing table, or change, requiring changes to all other tables in which it appears as a foreign key. The correct solution is to use a surrogate key.
Browse
Intelligence Community
intelligence information
Intelligence office
intelligence officer
intelligence operation
intelligence quotient
intelligence service
intelligence test
Intelligencer
Intelligencing
Intelligency
Intelligent
intelligent backtracking
intelligent database
Intelligent I/O
Intelligent Input/Output
-- intelligent key --
intelligent terminal
Intelligential
Intelligentiary
Intelligently
intelligentsia
Intelligibility
Intelligible
Intelligibleness
Intelligibly
IntelliMouse
Intelnet
Intelsat
Intemerate
Intemerateness
Intemperament
Intemperance
Index: # A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

About this site and copyright information - Online Dictionary Home