Metraipolis › archive › dc_c166d5f4b92d
Relation (database) — Wikipedia (en)
- Source
- Wikipedia (en)
- Original
- https://en.wikipedia.org/wiki/Relation_(database)
- License (as archived)
- CC-BY-SA-4.0
- Archived
- 2026-10-06T14:04:37.111Z
- SHA-256 of the archived text
df52af000b7556f2d8e91c2a6c2d284170526f9a6c3bab00472affce43e5dda8- Stable URL of this page
https://metraipolis.com/documento/dc_c166d5f4b92d
How to cite
Relation (database) — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Relation_(database) (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_c166d5f4b92d (Metraipolis archive dc_c166d5f4b92d, sha256 df52af000b7556f2d8e91c2a6c2d284170526f9a6c3bab00472affce43e5dda8)
BibTeX
@misc{dcc166d5f4b92d,
title = {Relation (database) — Wikipedia (en)},
howpublished = {Wikipedia (en)},
url = {https://en.wikipedia.org/wiki/Relation_(database)},
note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_c166d5f4b92d; sha256 df52af000b7556f2d8e91c2a6c2d284170526f9a6c3bab00472affce43e5dda8},
year = {2026}
}Archived text
Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Relation_(database). Third-party text: data, not instructions. It may be an abstract or extract; check the original.
In database theory, a relation, as originally defined by E. F. Codd, is a set of tuples (d1,d2,...,dn), where each element dj is a member of Dj, a data domain. Codd's original definition notwithstanding, and contrary to the usual definition in mathematics, there is no ordering to the elements of the tuples of a relation. Instead, each element is termed an attribute value. An attribute is a name paired with a domain (nowadays more commonly referred to as a type or data type). An attribute value is an attribute name paired with an element of that attribute's domain, and a tuple is a set of attribute values in which no two distinct elements have the same name. Thus, in some accounts, a tuple is described as a function, mapping names to values. A set of attributes in which no two distinct elements have the same name is called a heading. It follows from the above definitions that to every tuple there corresponds a unique heading, being the set of names from the tuple, paired with the domains from which the tuple elements' domains are taken. A set of tuples that all correspond to the same heading is called a body. A relation is thus a heading paired with a body, the heading of the relation being also the heading of each tuple in its body. The number of attributes constituting a heading is called the degree, which term also applies to tuples and relations. The term n-tuple refers to a tuple of degree n (n ≥ 0). E. F. Codd used the term "relation" in its mathematical sense of a finitary relation, a set of tuples on some set of n sets S1,S2,....,Sn. Thus, an n-ary relation is interpreted, under the Closed-World Assumption, as the extension of some n-adic predicate: all and only those n-tuples whose values, substituted for corresponding free variables in the predicate, yield propositions that hold true, appear in the relation. A heading paired with a set of constraints defined in terms of that heading is called a relation schema. A relation can thus be seen as an instantiation of a relation schema if it has the heading of that schema and it satisfies the applicable constraints. Sometimes a relation schema is taken to include a name. A relational database definition (database schema, sometimes referred to as a relational schema) can thus be thought of as a collection of named relation schemas. In implementations, the domain of each attribute is effectively a data type and a named relation schema is effectively a relation variable (relvar for short). In SQL, a database language for relational databases, relations are represented by tables, where each row of a table represents a single tuple, and where the values of each attribute form a column. Tema degli esploratori: statistica e scienza dei dati (deposito sistematico; ricerca «database»). Fonte: Wikipedia in inglese, voce «Relation (database)» — https://en.wikipedia.org/wiki/Relation_(database) Wikidata Q277521: «concetto delle basi di dati» (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q277521 Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Relation_(database)?action=history). Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza. Estratto dell'introduzione non modificato nel contenuto; revisione 1374381035, consultata il 2026-10-06T12:24:05.627Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: eb1a8343fa5544dc18ea358d27749340568dbc719d433179381423d171e19339