"surrogate key" meaning in English

See surrogate key in All languages combined, or Wiktionary

Noun

Forms: surrogate keys [plural]
Head templates: {{en-noun}} surrogate key (plural surrogate keys)
  1. (databases) A unique identifier for an entity or object, not derived from application data. Wikipedia link: surrogate key Categories (topical): Databases
    Sense id: en-surrogate_key-en-noun-V9tvPeTx Categories (other): English entries with incorrect language header Topics: computing, databases, engineering, mathematics, natural-sciences, physical-sciences, sciences

Inflected forms

Alternative forms

Download JSON data for surrogate key meaning in English (1.3kB)

{
  "forms": [
    {
      "form": "surrogate keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "surrogate key (plural surrogate keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        {
          "kind": "other",
          "name": "English entries with incorrect language header",
          "parents": [
            "Entries with incorrect language header",
            "Entry maintenance"
          ],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [
            "Computing",
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        }
      ],
      "examples": [
        {
          "text": "We weren't sure which columns in the table would have unique values, so we used a separate surrogate key as the primary key."
        }
      ],
      "glosses": [
        "A unique identifier for an entity or object, not derived from application data."
      ],
      "id": "en-surrogate_key-en-noun-V9tvPeTx",
      "links": [
        [
          "database",
          "database"
        ],
        [
          "unique identifier",
          "unique identifier"
        ],
        [
          "entity",
          "entity"
        ],
        [
          "object",
          "object"
        ],
        [
          "application",
          "application"
        ],
        [
          "data",
          "data"
        ]
      ],
      "raw_glosses": [
        "(databases) A unique identifier for an entity or object, not derived from application data."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "surrogate key"
      ]
    }
  ],
  "word": "surrogate key"
}
{
  "forms": [
    {
      "form": "surrogate keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "surrogate key (plural surrogate keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        "English countable nouns",
        "English entries with incorrect language header",
        "English lemmas",
        "English multiword terms",
        "English nouns",
        "en:Databases"
      ],
      "examples": [
        {
          "text": "We weren't sure which columns in the table would have unique values, so we used a separate surrogate key as the primary key."
        }
      ],
      "glosses": [
        "A unique identifier for an entity or object, not derived from application data."
      ],
      "links": [
        [
          "database",
          "database"
        ],
        [
          "unique identifier",
          "unique identifier"
        ],
        [
          "entity",
          "entity"
        ],
        [
          "object",
          "object"
        ],
        [
          "application",
          "application"
        ],
        [
          "data",
          "data"
        ]
      ],
      "raw_glosses": [
        "(databases) A unique identifier for an entity or object, not derived from application data."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "surrogate key"
      ]
    }
  ],
  "word": "surrogate key"
}

This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2024-04-26 from the enwiktionary dump dated 2024-04-21 using wiktextract (93a6c53 and 21a9316). The data shown on this site has been post-processed and various details (e.g., extra categories) removed, some information disambiguated, and additional data merged from other sources. See the raw data download page for the unprocessed wiktextract data.

If you use this data in academic research, please cite Tatu Ylonen: Wiktextract: Wiktionary as Machine-Readable Structured Data, Proceedings of the 13th Conference on Language Resources and Evaluation (LREC), pp. 1317-1325, Marseille, 20-25 June 2022. Linking to the relevant page(s) under https://kaikki.org would also be greatly appreciated.