intelligent key definition of intelligent key in the Free Online Encyclopedia.

(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.

Mentioned in	?		References in periodicals archive	?		Encyclopedia browser	?		Full browser	?
No references found	With more than a trillion possible code combinations, it's an intelligent key system and a secure identification system that's copy and tamper proof. Dialock locking systems by Doors and Hardware The music box can store up to 300 CDs and the electric, leather front seats have a memory function linking the driver's seat position to the car's Intelligent Key. Infiniti and beyond by Daily Post (Liverpool, England) Nissan Armada is equipped with Navigation and DVD entertainment systems, intelligent key, rear-view camera, Bose audio, automatic air-conditioning, power-folding third-row seats, front and rear parking sensors, individual tyre-pressure monitors, 20-inch alloy wheels and blue tooth. Great range of SUVs from Nissan by Gulf Weekly	Intel x86 Intel-based Mac Intel-based system IntelDX4 Intellect intellectual disability Intellectual Property Intellifont intelligence intelligence quotient Intelligence Quotient IQ Intelligence Service intelligence test intelligent intelligent agent intelligent backtracking intelligent building intelligent cable intelligent controller intelligent database intelligent design intelligent form intelligent hub Intelligent I/O Intelligent Input/Output intelligent key intelligent machine intelligent manufacturing Intelligent Messaging intelligent modem intelligent network intelligent paper intelligent robot intelligent sensor intelligent terminal Intelligent Transportation System intelligent transportation systems intelligent vehicle highway systems intelligent work station Intelligentsia intelligibility Intelligible intelligible crosstalk IntelliMirror IntelliMouse IntelliSense Intellistation Intelsat intendant Intendants intended audience	intelligent information management Intelligent Information Network Intelligent Information Processing Intelligent Information Processing and Web Mining Intelligent Information Retrieval Intelligent Information Systems Group Intelligent Information Systems Institute 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 Exploration Workbench intelligent knowledge-based system Intelligent Laboratory Information System Intelligent Language Tutoring System Intelligent Laser Diode Driver Intelligent Laser Ranging and Imaging System Intelligent Learning with Symbolic Computation Intelligent Library System Intelligent Life Elsewhere Intelligent Lift Interlock System Intelligent Line Interface Intelligent Line Manager Intelligent Link Interface Intelligent Linking and Directed Assistance Intelligent Lithium Ion Battery Management 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

Mentioned in

References in periodicals archive

Encyclopedia browser

Full browser

No references found

With more than a trillion possible code combinations, it's an intelligent key system and a secure identification system that's copy and tamper proof.

Dialock locking systems by Doors and Hardware

The music box can store up to 300 CDs and the electric, leather front seats have a memory function linking the driver's seat position to the car's Intelligent Key.

Infiniti and beyond by Daily Post (Liverpool, England)

Nissan Armada is equipped with Navigation and DVD entertainment systems, intelligent key, rear-view camera, Bose audio, automatic air-conditioning, power-folding third-row seats, front and rear parking sensors, individual tyre-pressure monitors, 20-inch alloy wheels and blue tooth.

Great range of SUVs from Nissan by Gulf Weekly

intellectual disability

Intellectual Property

Intellifont

intelligence

intelligence quotient

Intelligence Quotient IQ