Natural versus Surrogate Keys. Performance and Usability

Choosing the primary key for a table proves to be one of the most important steps in database design. But what happens when we have to pick between a natural or a surrogate key? Is there any performance issue that we must have in mind? Does the literature have a preferred pick? Is usability a concern? We’ll have a look at the advantages and disadvantages of both natural and surrogate keys and the performance and usability issues they address.

MoreLess

Year of publication:	2011
Authors:	POP, Dragos-Paul
Published in:	Database Systems Journal. - Academia de Studii Economice din Bucureşti, ISSN 2069-3230. - Vol. 2.2011, 2, p. 55-63
Publisher:	Academia de Studii Economice din Bucureşti
Subject:	primary keys \| natural keys \| surrogate keys \| superkey \| candidate key \| unique key \| performance \| usability

freely available

Full text |

More access options

Check Google Scholar

In libraries world-wide (WorldCat)

In German libraries (KVK)

subito order

I need help

More details

Extent:	application/pdf
Type of publication:	Article
Source:	RePEc - Research Papers in Economics

Persistent link: https://www.econbiz.de/10010819193