"natural key" meaning in English

See natural key in All languages combined, or Wiktionary

Noun

Forms: natural keys [plural]
Head templates: {{en-noun}} natural key (plural natural keys)
  1. (databases) A unique key formed from attributes that relate to the external world being modelled, rather than being an internally generated surrogate key. Wikipedia link: natural key Categories (topical): Databases Synonyms: business key

Inflected forms

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

{
  "forms": [
    {
      "form": "natural keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "natural key (plural natural 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"
        }
      ],
      "glosses": [
        "A unique key formed from attributes that relate to the external world being modelled, rather than being an internally generated surrogate key."
      ],
      "id": "en-natural_key-en-noun-jP2dZwrb",
      "links": [
        [
          "database",
          "database"
        ],
        [
          "unique",
          "unique"
        ],
        [
          "key",
          "key"
        ],
        [
          "attribute",
          "attribute"
        ],
        [
          "external",
          "external"
        ],
        [
          "world",
          "world"
        ],
        [
          "surrogate key",
          "surrogate key"
        ]
      ],
      "raw_glosses": [
        "(databases) A unique key formed from attributes that relate to the external world being modelled, rather than being an internally generated surrogate key."
      ],
      "synonyms": [
        {
          "word": "business key"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "natural key"
      ]
    }
  ],
  "word": "natural key"
}
{
  "forms": [
    {
      "form": "natural keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "natural key (plural natural 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"
      ],
      "glosses": [
        "A unique key formed from attributes that relate to the external world being modelled, rather than being an internally generated surrogate key."
      ],
      "links": [
        [
          "database",
          "database"
        ],
        [
          "unique",
          "unique"
        ],
        [
          "key",
          "key"
        ],
        [
          "attribute",
          "attribute"
        ],
        [
          "external",
          "external"
        ],
        [
          "world",
          "world"
        ],
        [
          "surrogate key",
          "surrogate key"
        ]
      ],
      "raw_glosses": [
        "(databases) A unique key formed from attributes that relate to the external world being modelled, rather than being an internally generated surrogate key."
      ],
      "synonyms": [
        {
          "word": "business key"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "natural key"
      ]
    }
  ],
  "word": "natural 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.