代理密钥，合成密钥和人工密钥之间有区别吗? [英] Is there a difference between Surrogate key, Synthetic Key, and Artificial Key?

问题描述

代理键，合成键和人工键之间是否有区别?

Are there any differences among a Surrogate Key, Synthetic Key, and an Artificial Key?

我不清楚确切的区别.

推荐答案

代理密钥，合成密钥和人工密钥是同义词.技术关键是另一个.它们都表示没有业务意义的主键".它们与自然或业务密钥不同，后者在手边的系统中没有意义.

Surrogate key, synthetic key and artificial key are synonyms. Technical key is another one. They all mean "primary key which doesn't have a business meaning". They are distinct from natural or business keys which have a meaning beyond the system at hand.

例如，考虑SO用户帐户.我们通过两个键来识别.自然键是我们用来登录该站点的标识符，例如我们的OpenID名称.但是由于这些东西都是长而笨拙的字符串(并且因为SO允许我们选择不同的登录选项)，所以数据库通过用户ID(即生成的数字)来标识我们.该UserID是合成/代理/人工密钥.

For instance, consider the SO user account. We are identified by two keys. The natural key is the identifier we use to login in to this site, such as our OpenID name. But because these things are long unwieldy strings (and because SO allows us a choice of different login options) the database identifies us by a User ID which is a generated number. That UserID is a synthetic/surrogate/artifical key.

这篇关于代理密钥，合成密钥和人工密钥之间有区别吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！