Encyclopedia

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.
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

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.
Copyright © 1981-2025 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
Mentioned in
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 #.
* 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.
Copyright © 2003-2025 Farlex, Inc Disclaimer
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.