Printer Friendly
Dictionary, Encyclopedia and Thesaurus - The Free Dictionary
1,824,801,178 visitors served.
forum mailing list For webmasters
?
New: Language forums
Dictionary/
thesaurus
Medical
dictionary
Legal
dictionary
Financial
dictionary
Acronyms
 
Idioms
Encyclopedia
Wikipedia
encyclopedia
?

intelligent key
(redirected from Advanced Key)

    Also found in: Wikipedia 0.01 sec.
(database)intelligent key - A relational database key which depends wholly 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.


How to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit webmaster's page for free fun content.
?Page tools
Printer friendly
Cite / link
 Email
Feedback
? Mentioned in ? References in periodicals archive
 
In this context, we have aligned our company's organizational leadership against our target consumers and have advanced key actions, including the licensing of our Timberland North America apparel business, to maximize our brand's potential.
Timberland Reports Fourth-Quarter Results by Business Wire
It employs advanced key management techniques to protect, compartmentalize, and control access to data stored on disk and tape.
Kasten Chase Signs Reseller Agreement with Softchoice by Business Wire
It employs advanced key management techniques to protect, compartmentalize, and control access to data stored on disk and tape.
Kasten Chase Launches Storage Security Compliance Auditing Service by Business Wire
More results
 
Encyclopedia browser? ? Full browser
 
 
Encyclopedia
?

Disclaimer | Privacy policy | Feedback | Copyright © 2010 Farlex, Inc.
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional. Terms of Use.