A synthetic key is a database key that holds no business meaning and is used exclusively for identifying a record within the database. It is typically an automatically generated identifier or number that does not refer to any specific entity other than being unique for each record in a given table. Synthetic keys are frequently employed in databases to ensure data uniqueness and consistency, but they lack semantic or business significance, meaning they do not relate to specific information or relationships within an organization.
Słownik