词条 | Natural key |
释义 |
A natural key (also known as business key[1]) is a type of unique key, found in relational model database design, that is formed of attributes that already exist in the real world. It is used in business-related columns.[2] In other words, a natural key is a candidate key that has a logical relationship to the attributes within that row. A natural key is sometimes called domain key.[3] The main advantage of a natural key over a surrogate key (which has no meaning outside the database environment) is that a natural key already exists, so there is no need to add a new, artificial column to the schema. Using a natural key (when one can be identified) also simplifies data quality: It ensures that there can only be one row for a key; this single version of the truth can be verified because the natural key is based on a real-world observation. References1. ^On Kinds of Keys 2. ^Intelligent Versus Surrogate Keys 3. ^Auto Keys Versus Domain Keys 1 : Data modeling |
随便看 |
|
开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。