Home  >  Article  >  Database  >  Surrogate keys in RDBMS

Surrogate keys in RDBMS

WBOY
WBOYforward
2023-09-05 09:49:021191browse

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!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete