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 ?
Options include NissanConnect, Nissan Intelligent Key, Lane Departure Warning, Blind Spot Warning, heated seats and a Bose sound system.
Together with other technological highlights and intelligent key technologies from Continental, the new solid tire portfolio and tire pressure management system for pneumatic tires will be on display in Hall 5, Stand E18 from April 23 to 27.
6 SV CVT P26 Includes S features, plus * Steering SW- Audio, Hands Free Bluetooth & Drive Computer * Intelligent Key with Push Engine Starter * 4 Speakers * Audio with USB / i-Pod Connectivity * Navigation with 5.
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.
The first generation of Audience's Advanced Voice software, targeted at x86 PCs, tablets and all-in-ones, delivers improved VoIP capability with intelligent key click removal, improved speech recognition performance, and innovative new features like 360deg Voice.
Acenta Premium models start from PS20,995 and include the likes of parking sensors, panoramic glass roof and a rear view camera while flagship Tekna variants, from PS23,145, add more stuff like heated seats, Intelligent key with engine start button, Around View monitor and smartphone connectivity.
The range-topping Tekna model starts at PS15,950 and features 16-inch alloy wheels, part-leather seats, Around View Monitor and the three Nissan Safety Shield technologies as standard, along with Intelligent Key with start/stop button, leather steering wheel and automatic air conditioning.
Central to the system is an advanced, intelligent key which the company calls the i-Key.
An electric tilt and slide panoramic sunroof, plus Intelligent Key for keyless entry and start complete the equipment list, in addition to climate control, cruise c ontrol, auto headlights, rain-sensing wipers and rear privacy glass.
Standard features include intelligent key & Push engine start, rear passenger air vents, fitment of soft interior trims, and a wide range of safety equipment including dual airbags, ABS (anti-lock braking system), EBD (electronic brake-force distribution), and BA (brake assist).

Full browser ?