candidate key


Also found in: Wikipedia.

candidate key

(database)
One of several possible attributes or combinations of attributes which can be used to uniquely identify a body of information (a "record"). The chosen candidate key is called the primary key.

candidate key

One or more columns (fields) in a relational database that can uniquely identify a row in the table. If there are two or more candidate keys, only one is selected as the "primary." See primary key.
References in periodicals archive ?
1: Clear DeltaKey3 2: while (DeltaKey3 is not full) 3: ([[bar.T].sup.1], ...,[[bar.T].sup.8]) [left arrow] PreparePowerTraces () 4: DeltaKey1 [left arrow] DetectCollision ([[bar.T].sup.1] , ...,[[bar.T].sup.8]) 5: DeltaKey2 [left arrow] DetectError (DeltaKeyl) 6: DeltaKey3 [left arrow] Accumulate (DeltaKey2, DeltaKey3) 7 end 8: for every candidate key K compatible to DeltaKey3 9: if (TestKey (K)) return (K) 10: end In the DetectError step, as described in Algorithm 2, we use (3) to check every elements of DeltaKeyl.
The adversary finds a candidate key in the following key testing step by computing the only 1 byte of intermediate variable V:
* An attribute A is a key attribute in a relation R, if A is part of some candidate key. Otherwise it is a non-key attribute in R, i.e., A is not a component of any candidate key.
Key phrase extraction from a body of text relies on an evaluation of the importance of each candidate key phrase [4].
Such an attribute, or combination of attributes, is called a candidate key. One of the candidate keys is chosen as a primary key and used as identifier for the table.
Most candidate key and foreign-key attributes ended with the character #.
In the last session of the attack, the adversary verifies the rest candidate key by the equality of [??] and [??] for all i, j [member of] [{0, 1}.sup.8] in each group exhaustively, until the right key is discovered.
PRIMARY KEYS come from candidate keys. Each candidate key consists of the attribute or attributes used to label a distinct row in a table.
* Any form field matching a common candidate key suffix such as NAME, NO, NUMBER, or # may represent an entity (e.g., WORK ORDER NO representing the entity WORK-ORDER).
Figure 6 lists candidate keys. A candidate key is a set of attributes that uniquely identify each row.
[P.sub.candidates] denotes the proportion of the number of candidate keys to the number of all possible keys, which is approximate to the proportion of the number of covered faults to the number of all possible faults.

Full browser ?