Clé naturelle

A natural key (also known as business key or domain key) is a type of unique key in a database formed of attributes that exist and are used in the external world outside the database (i.e. in the business domain or domain of discourse). In the relational model of data, a natural key is a superkey and is therefore a functional determinant for all attributes in a relation. A natural key serves two complementary purposes: It provides a means of unique identification for data It imposes a rule, specifically a uniqueness constraint, to ensure that data remains unique within an information system The uniqueness constraint assures uniqueness of data within a certain technical context (e.g. a set of values in a table, file or relation variable) by rejecting input of any data that would otherwise violate the constraint. This means that the user can rely on a guaranteed correspondence between facts identified by key values recorded in a system and the external domain of discourse (a single version of the truth according to Kimball). A natural key differs from a surrogate key which has no meaning outside the database itself and is not based on real-world observation or intended as a statement about the reality being modelled. A natural key therefore provides a certain data quality guarantee whereas a surrogate does not. It is common for elements of data to have several keys, any number of which may be natural or surrogate. The advantages of using a natural key to uniquely identify records in a relation include less disk space usage, the natural key is an attribute that is related to the business or the real world so in most cases, it is already being stored in the relation which saves disk space as compared to creating a new column for storing the surrogate key. Another advantage of using natural keys is that it simplifies enforcement of data quality, and they are easier to relate to real life while designing the database system. They simplify the quality of data as using a natural key that is unique in the real world ensures that there cannot be multiple records with the same primary key.

À propos de ce résultat

Cette page est générée automatiquement et peut contenir des informations qui ne sont pas correctes, complètes, à jour ou pertinentes par rapport à votre recherche. Il en va de même pour toutes les autres pages de ce site. Veillez à vérifier les informations auprès des sources officielles de l'EPFL.

Publications associées (22)

Personnes associées (3)

Unités associées (2)

Concepts associés (3)

Séances de cours associées (2)

Composite key

In database design, a composite key is a candidate key that consists of two or more attributes (table columns) that together uniquely identify an entity occurrence (table row). A compound key is a composite key for which each attribute that makes up the key is a foreign key in its own right. Composite keys have advantages similar to that of a natural key as it is often composed of multiple natural key attributes.

Clé primaire

Dans une base de données relationnelle, une clé primaire est la donnée qui permet d'identifier de manière unique un enregistrement dans une table. Une clé primaire peut être composée d'une ou de plusieurs colonnes de la table. Deux lignes distinctes de la table ne peuvent pas avoir les mêmes valeurs dans les colonnes définies comme clé primaire. Il est possible de définir pour une même table plusieurs contraintes d'unicité, mais au plus une seule clé primaire. Une clé primaire est choisie parmi les clés candidates.

Base de données relationnelle

thumb|upright=1.2|Structure générale d'une base de données relationnelle. En informatique, une base de données relationnelle (en anglais: relational database management system (RDBMS)) est une base de données où l'information est organisée dans des tableaux à deux dimensions appelés des relations ou tables, selon le modèle introduit par Edgar F. Codd en 1960. Selon ce modèle relationnel, une base de données consiste en une ou plusieurs relations. Les lignes de ces relations sont appelées des nuplets ou enregistrements.

Autologous and Allogeneic Cytotherapies for Large Knee (Osteo)Chondral Defects: Manufacturing Process Benchmarking and Parallel Functional Qualification

Corinne Scaletta, Sandra Jaccoud, Philippe Abdel Sayed, Nathalie Hirt-Burri, Robin Martin, Salim Elias Darwiche, Cédric Peneveyre, Annick Jeannerat, Alexis Laurent

Cytotherapies are often necessary for the management of symptomatic large knee (osteo)-chondral defects. While autologous chondrocyte implantation (ACI) has been clinically used for 30 years, allogeneic cells (clinical-grade FE002 primary chondroprogenitor ...

Basel2023

Type 1 piliated uropathogenic Escherichia coli hijack the host immune response by binding to CD14

Kathrin Tomasek

A key attribute of persistent or recurring bacterial infections is the ability of the pathogen to evade the host's immune response. Many Enterobacteriaceae express type 1 pili, a pre-adapted virulence trait, to invade host epithelial cells and establish pe ...

eLIFE SCIENCES PUBL LTD2022

Travel Time and Source Variation Explain the Molecular Transformation of Dissolved Organic Matter in an Alpine Stream Network

Tom Ian Battin, Hannes Markus Peter, Amber Joy Ulseth

Streams and rivers are important components of the carbon cycle as they transport and transform dissolved organic matter (DOM). Using high resolution Fourier transform ion cyclotron resonance mass spectrometry, we studied the spatial distribution of DOM at ...

2020

Introduit le modèle relationnel, SQL, les clés, les contraintes d'intégrité, la traduction ER, les entités faibles, les hiérarchies ISA et SQL vs. noSQL.

Explore les défis liés à la protection de la vie privée, y compris l'anonymat k et les solutions de données synthétiques.