"natural join" meaning in English

See natural join in All languages combined, or Wiktionary

Noun

Forms: natural joins [plural]
Head templates: {{en-noun}} natural join (plural natural joins)
  1. (databases) A join between two tables on a field which has the same name. Categories (topical): Databases Hypernyms: join Related terms: equijoin, inner join Translations (join): luonnollinen liitos (Finnish), jointure naturelle (French), φυσική συνένωση (fysikí synénosi) (Greek), junção natural (Portuguese)

Inflected forms

{
  "forms": [
    {
      "form": "natural joins",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "natural join (plural natural joins)",
      "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": "other",
          "name": "Entries with translation boxes",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with 1 entry",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with entries",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Finnish translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with French translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Greek translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Portuguese translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [
            "Computing",
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        }
      ],
      "glosses": [
        "A join between two tables on a field which has the same name."
      ],
      "hypernyms": [
        {
          "word": "join"
        }
      ],
      "id": "en-natural_join-en-noun-IdadqxmR",
      "links": [
        [
          "database",
          "database"
        ],
        [
          "join",
          "join"
        ]
      ],
      "raw_glosses": [
        "(databases) A join between two tables on a field which has the same name."
      ],
      "related": [
        {
          "word": "equijoin"
        },
        {
          "word": "inner join"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "translations": [
        {
          "code": "fi",
          "lang": "Finnish",
          "sense": "join",
          "word": "luonnollinen liitos"
        },
        {
          "code": "fr",
          "lang": "French",
          "sense": "join",
          "word": "jointure naturelle"
        },
        {
          "code": "el",
          "lang": "Greek",
          "roman": "fysikí synénosi",
          "sense": "join",
          "word": "φυσική συνένωση"
        },
        {
          "code": "pt",
          "lang": "Portuguese",
          "sense": "join",
          "word": "junção natural"
        }
      ]
    }
  ],
  "word": "natural join"
}
{
  "forms": [
    {
      "form": "natural joins",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "natural join (plural natural joins)",
      "name": "en-noun"
    }
  ],
  "hypernyms": [
    {
      "word": "join"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "related": [
    {
      "word": "equijoin"
    },
    {
      "word": "inner join"
    }
  ],
  "senses": [
    {
      "categories": [
        "English countable nouns",
        "English entries with incorrect language header",
        "English lemmas",
        "English multiword terms",
        "English nouns",
        "Entries with translation boxes",
        "Pages with 1 entry",
        "Pages with entries",
        "Terms with Finnish translations",
        "Terms with French translations",
        "Terms with Greek translations",
        "Terms with Portuguese translations",
        "en:Databases"
      ],
      "glosses": [
        "A join between two tables on a field which has the same name."
      ],
      "links": [
        [
          "database",
          "database"
        ],
        [
          "join",
          "join"
        ]
      ],
      "raw_glosses": [
        "(databases) A join between two tables on a field which has the same name."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "translations": [
    {
      "code": "fi",
      "lang": "Finnish",
      "sense": "join",
      "word": "luonnollinen liitos"
    },
    {
      "code": "fr",
      "lang": "French",
      "sense": "join",
      "word": "jointure naturelle"
    },
    {
      "code": "el",
      "lang": "Greek",
      "roman": "fysikí synénosi",
      "sense": "join",
      "word": "φυσική συνένωση"
    },
    {
      "code": "pt",
      "lang": "Portuguese",
      "sense": "join",
      "word": "junção natural"
    }
  ],
  "word": "natural join"
}

Download raw JSONL data for natural join meaning in English (1.4kB)


This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2024-11-06 from the enwiktionary dump dated 2024-10-02 using wiktextract (fbeafe8 and 7f03c9b). 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.