Inserisci una parola o una frase in qualsiasi lingua 👆
Lingua:
Traduzione e analisi delle parole tramite l'intelligenza artificiale ChatGPT
In questa pagina puoi ottenere un'analisi dettagliata di una parola o frase, prodotta utilizzando la migliore tecnologia di intelligenza artificiale fino ad oggi:
- come viene usata la parola
- frequenza di utilizzo
- è usato più spesso nel discorso orale o scritto
- opzioni di traduzione delle parole
- esempi di utilizzo (varie frasi con traduzione)
- etimologia
Cosa (chi) è surrogate key - definizione
UNIQUE IDENTIFIER FOR EITHER AN ENTITY IN THE MODELED WORLD OR AN OBJECT IN THE DATABASE
Technical Key; Surrogate Key; Pseudokey
surrogate key
<database> A unique primary key generated by the RDBMS
that is not derived from any data in the database and whose
only significance is to act as the primary key.
A surrogate key is frequently a sequential number (e.g. a
Sybase "identity column") but doesn't have to be. Having
the key independent of all other columns insulates the
database relationships from changes in data values or database
design and guarantees uniqueness.
Some database designers use surrogate keys religiously
regardless of the suitability of other candidate keys.
However, if a good key already exists, the addition of a
surrogate key will merely slow down access, particularly if it
is indexed.
Compare: intelligent key.
(1999-12-07)
Surrogate key
A surrogate key (or synthetic key, pseudokey, entity identifier, factless key, or technical key) in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data, unlike a natural (or business) key.
surrogate
WIKIMEDIA DISAMBIGUATION PAGE
The Surrogate; Surrogate (disambiguation); The Surrogate (disambiguation); The Surrogate (film)
n. 1) a person acting on behalf of another or a substitute, including a woman who gives birth to a baby of a mother who is unable to carry the child. 2) a judge in some states (notably New York) responsible only for probates, estates and adoptions.
Wikipedia
Surrogate key
A surrogate key (or synthetic key, pseudokey, entity identifier, factless key, or technical key) in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data, unlike a natural (or business) key.
