intelligent key

(redirected from Advanced Key)
Also found in: Wikipedia.

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 ?
- A review of the latest technological developments and market trends (including corporate latches, double-locking, keyless entry, smart keys, car keys, car locks, advanced key fobs, access by phone)
ThreatFabric researchers wrote: "The enhanced overlay attacks also running on the latest Android versions combined with advanced key logging and the potential under-development features will allow MysteryBot to harvest a broad set of personal identifiable information in order to perform fraud."
In point of fact, this is nothing but advanced key word searching, and there is not much science that is going on behind this.
Following the vote, CPC Chairman Carl Weisbrod said in a statement that the decision "advanced key elements of the Administration's strategies to address the City's housing crisis,"--sentiments which one can only hope will be internalized by the City Council before the plan is to be voted on during the final step in the process.
Build out more advanced key performance indicators (KPIs).
Banks and issuing institutions now face various threats such as data security breaches, sophisticated phishing, and advanced key logging which put cardholder security at the front and center as one of the major concerns that banks need to address in this digital age.
Additional features over and above those of the standard S8 include an automatic hands-free boot lid, advanced key, 14-speaker BOSE surround system and advanced parking system with top view camera, privacy glass, power door closure and adaptive cruise control.
Alongside the S sports seat with various leather and trim variants, options include the advanced key, hill hold assist, high-beam assist, the LED interior lighting package and front seat heating.
The entry Premium model features a standard three-spoke multifunction steering wheel, available Advanced Key and Audi connect as part of the Navigation plus package.
"People can still sign up for the standard key online but that will give them limited access, the more private information is only accessed through the advanced key."
Joining the ICC would also expose Palestinian factions to possible prosecution.On Friday, Hamas executed 18 people in Gaza City it accused of collaborating with Israel, a day after three of its top commanders were assassinated in Israeli air strikes.Britain, France and Germany have advanced key points of a new UN Security Council resolution calling for an immediate and sustainable ceasefire, and the lifting of Israel's blockade.Diplomats said the text was aimed at advancing efforts to reach agreement within the 15-member council after a draft resolution from Jordan met with resistance from Israel's US ally.Washington has wielded its veto powers at the Security Council repeatedly in the past on behalf of Israel, although the now 46-day war has strained relations between the allies.

Full browser ?