Surrogate keys in RDBMS

#The only purpose of a surrogate key is to become a unique identifier in the database, such as a delta key, GUID, etc.

The surrogate key has no actual meaning and is used to represent existence. It exists only for data analysis.

Example

##Price##505_92##1666 table in .

##Key	Product ID
##1987	200	698_56
1256	170	304_57
1898	250	458_66
##110		Above, the surrogate key is the Key

Other examples

Some other examples of surrogate keys -

Counters can also appear as surrogate keys.

System Date/Time Stamp

Random alphanumeric string.

The above is the detailed content of Surrogate keys in RDBMS. For more information, please follow other related articles on the PHP Chinese website!