intelligent key

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

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 ?
The T950 is the only enterprise-class library available with integrated AES-256 bit BlueScale[R] Encryption capabilities, which allows users to backup, encrypt and compress data with advanced key management, all in a single unit.
Mosaic's alliance with iS3 will enhance the Postilion platform with the inclusion of advanced key management and remote key download capabilities, and the addition of the highest possible levels of user security and user administration for key management.
With this announcement Spectra Logic has taken a leadership position as it now offers an advanced key management functionally in an encryption solution.
A new feature to North America is Audi's optional advanced key system, which acts as an electronic access and authorization system.
But with the advanced key management capabilities of Smartphone Security V7.
As head of European marketing and consultant relations for the past nine years, Lakhani has advanced key relationships with the consultant community and has led a winning sales team that has grown mandates at a significant pace over the past decade.
Data privacy solutions which provides strong encryption technology and advanced key management to reinforce ASE's defenses.
It employs advanced key management techniques to protect, compartmentalize, and control access to data stored on disk and tape.
13 /PRNewswire/ -- Advanced key opinion leader development programs staff between 100 and 200 medical liaisons to manage thought leader activities, according to a new study by pharmaceutical intelligence leader Cutting Edge Information.
nFast/CA combines these functions along with advanced key management capabilities, accessed by standard e-commerce and certificate authority applications via the PKCS#11 standard interface.
Using advanced key management, high data throughput and a distributed, scalable architecture, Assurency SecureData provides fully transparent data encryption and data compartmentalization for CAS systems.

Full browser ?