intelligent key

intelligent key

(database)
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 ?
From Bose Personal Edition grade, the Juke comes with the NissanConnect infotainment system, Bose Personal sounds system, rear parking camera, Nissan Intelligent Key with push-button start, electrically folding door mirrors, part-leather seats and automatic headlights.
Impressing users, Infiniti QX80's small but powerful device called the Intelligent Key and Infiniti QX60's Motion Activated Liftgate lend a higher level of convenience and ease of use.
Tenders are invited for the Provision of Intelligent Key Electronic Locking Devices
For starters, it comes equipped with a small Intelligent Key but will require the driver to push the button on either front door handle to unlock.
The model is also equipped with a remote engine starter, a cruise control function, intelligent key entry system with push engine starter, power windows, a central door lock, full auto air conditioning, a power back door function with auto close, a rear window defroster with timer, and the Patrol's signature cool box.
From Bose Personal Edition grade, the Juke comes with the NissanConnect infotainment system, Bose Personal sounds system, rear parking camera, Nissan Intelligent Key with pushbutton start, electrically folding door mirrors, partleather seats and automatic headlights.
A push-button ignition and Nissan's intelligent key mean the fob never has to come out of your pocket.
The US-spec Kicks also gets certain features that Nissan can easily offer in the Indian version, like LED headlamps, touchscreen infotainment system with Apple CarPlay and Android Auto, climate control, push button start, tilt- and telescopic-adjustable steering, Nissan Intelligent Key, remote engine start and tyre pressure monitoring system.
PEPS System is also called keyless start system, which allows the user to lock/unlock vehicle doors and trunk, or start the engine without the user operating the intelligent key directly.
A public organization such as the City of Greater Sudbury that takes the encryption of data across a high volume of endpoints seriously, further proves a massive global industry shift towards the adoption of intelligent key management and better data security, said Mark Hickman, Chief Operating Officer, WinMagic.
The Acenta models gain 16in alloy wheels and chrome exterior trim, plus the Nissan Intelligent Key system with engine start/stop button and a 5in HD full colour screen.
The vehicle is enhanced by features like intelligent key push start button, ABS, EBD, BA, Vehicle Dynamic Control with Traction Control System and xenon lights.

Full browser ?