It focused on how to generate unique consequent values for the surrogate key 文中主要讨论了如何为代理键生成惟一的序列值。
When you create a table , you can add an extra column to be the surrogate key 当创建一个表时,可以添加一个额外的列作为代理键。
This article described three approaches to implementing a surrogate key as primary key 本文描述了实现作为主键的代理键的三种方法。
Third , write the keymanger class to maintain the surrogate keys for each registered table 第三,编写keymanger类来维护每个已注册表的代理键。
The identity function is a good solution for a surrogate key function in most cases Identity函数在大多数情况下是代理键函数的一个好的解决方案。
First , you need to create the table keys to remember the current surrogate key values for each table 首先,需要创建表keys来记录每个表的当前代理键值。
You can add a surrogate key column , serialnumber , and designate it as the primary key column 那么可以添加一个代理键列serialnumber ,并将其指定为主键列。
Many large applications use the key manager method to maintain the surrogate keys for all tables 很多大型的应用程序使用键管理器方法维护所有表的代理键。
The reason to use a surrogate key solution is to find an efficient way to generate unique sequential numbers 使用代理键解决方案是为了发现一种生成惟一序列号的有效方法。
Surrogate keys are artificial keys that link dimension and fact tables and that are used to ensure uniqueness and to improve performance 代理键是链接维度表和事实数据表的假键,用于确保唯一性并提高性能。