Search CTRL + K

Candidate Key

#CS/Database

在 关系型数据库 中，当某个 超键 不包含无关列，也就是说“最小”了，就被成为 候选键。

一个 表 中可能会有多个 候选键。

Database System Concepts

We are often interested in superkeys for which no proper subset is a superkey. Such minimal superkeys are called candidate keys.[1]

  1. Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, Database System Concepts, Seventh edition (New York, NY: McGraw-Hill, 2020). P44 ↩︎