Printer Friendly
Dictionary, Encyclopedia and Thesaurus - The Free Dictionary
1,820,342,025 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

   Also found in: Wikipedia 0.02 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
 
0-inch color display and RearView Monitor (all models except S-V6), new center stack design, 2nd row reclining seat (center portion), revised cupholder design, new illuminated switchgear (all models except S), new fabrics and materials, heated steering wheel (LE models), Intelligent Key with twist start, Bluetooth([R]) hands-free phone system (available on LE models only) and new Russet interior color (leather-appointed only).
Nissan Previews 2008 Titan Long Wheelbase, Pathfinder V8 and Enhanced ... by Business Wire
The Altima Hybrid features a high level of standard equipment, including 16-inch alloy wheels, Intelligent Key with Push Button Ignition, power windows/door locks, 6-speaker AM/FM/CD system with auxiliary audio input jack, Anti-lock Braking System (ABS), Vehicle Dynamic Control (VDC), Traction Control System (TCS) and dual-zone automatic temperature control that includes an Altima Hybrid-specific electrically powered A/C that continues to provide cooling when the gasoline engine is stopped.
Nissan Announces Pricing on 2007 Altima Hybrid by Business Wire
Opening the door to any 2007 Nissan vehicle, drivers will be pleased to see each vehicle is loaded with the latest available technology, including Xtronic CVT shiftless transmission, Bluetooth hands-free phone system, Intelligent Key for keyless entry push-button ignition and an audio system that allows you to plug in an iPod or other media player for a more personalized music selection.
SHIFT_2Nissan Tour Returns to the Road in 2007 by Business Wire
More results
 
Encyclopedia browser? ? Full browser
 
Intelligent Information Hiding and Multimedia Signal Processing
intelligent information management
Intelligent Information Network
Intelligent Information Processing
Intelligent Information Processing and Web Mining
Intelligent Information Retrieval
Intelligent Information Systems Technology
Intelligent Information Technology Application
Intelligent Inhabited Environments Group
Intelligent Input/Output
Intelligent Input/Output
Intelligent Inquiry Educational Society
Intelligent Installation Systems
Intelligent Integrated Communications System
Intelligent Integrated User Interface
Intelligent Integrated. Network Management
Intelligent Integration of Information
Intelligent Interactive Distributed Systems
Intelligent Interactive Multimedia Systems and Services
Intelligent Interface Controller
Intelligent Interface Processor
Intelligent Internet Protocol
Intelligent Internet Strategies
Intelligent Investor
intelligent key
Intelligent Knowledge Based System
intelligent knowledge-based system
Intelligent Laser Diode Driver
Intelligent Laser Ranging and Imaging System
Intelligent Learning with Symbolic Computation
Intelligent Library System
Intelligent life
Intelligent Life Elsewhere
Intelligent light
Intelligent lighting
Intelligent Line Interface
Intelligent Line Manager
Intelligent Link Interface
Intelligent Linking and Directed Assistance
Intelligent Load-Handling System
Intelligent Local OPeration
Intelligent Logistics for Innovative Product Technologies
Intelligent Long Range
Intelligent Loop Detection Application
Intelligent Loop Detector Application
Intelligent machine
Intelligent Machine Post
Intelligent Machines and Special Robotics Institute
Intelligent Machines Design Laboratory
 
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.