Jump to content

Persistent object identifier

From Wikipedia, the free encyclopedia
This is the current revision of this page, as edited by Citation bot (talk | contribs) at 18:53, 28 April 2024 (Added s2cid. Removed URL that duplicated identifier. Removed access-date with no URL. Removed parameters. | Use this bot. Report bugs. | Suggested by Jay8g | #UCB_toolbar). The present address (URL) is a permanent link to this version.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

In database design, a persistent object identifier (POID) is a unique identifier of a record on a table, used as the primary key. Important characteristics of a POID are that it does not carry business information and are not generally exported or otherwise made visible to data users; as such a POID has many of the characteristics of a surrogate key. The only purpose of the POID is to act as the primary key on the table where it is defined and to be referenced as the foreign key by other tables. Because POIDs, like surrogate keys, do not carry business information, they are immune to changes in the form or meaning of business data. It can therefore make it easier to maintain relations between objects and make queries simpler.[1]

See also

[edit]

References

[edit]
  1. ^ . S2CID 64459959. {{cite web}}: Missing or empty |title= (help); Missing or empty |url= (help)
[edit]