"star schema" meaning in English

See star schema in All languages combined, or Wiktionary

Noun

Forms: star schemas [plural]
Etymology: From the resemblance to a star shape with a fact table at its center. Head templates: {{en-noun}} star schema (plural star schemas)
  1. (databases, data warehousing) A denormalized database schema consisting of one or more fact tables referencing any number of dimension tables. Categories (topical): Databases

Inflected forms

Download JSON data for star schema meaning in English (1.3kB)

{
  "etymology_text": "From the resemblance to a star shape with a fact table at its center.",
  "forms": [
    {
      "form": "star schemas",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "star schema (plural star schemas)",
      "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 denormalized database schema consisting of one or more fact tables referencing any number of dimension tables."
      ],
      "id": "en-star_schema-en-noun-RpbZsotg",
      "links": [
        [
          "database",
          "database"
        ],
        [
          "data warehousing",
          "data warehouse"
        ],
        [
          "denormalized",
          "denormalized"
        ],
        [
          "schema",
          "schema"
        ],
        [
          "fact table",
          "fact table"
        ]
      ],
      "qualifier": "data warehousing",
      "raw_glosses": [
        "(databases, data warehousing) A denormalized database schema consisting of one or more fact tables referencing any number of dimension tables."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "word": "star schema"
}
{
  "etymology_text": "From the resemblance to a star shape with a fact table at its center.",
  "forms": [
    {
      "form": "star schemas",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "star schema (plural star schemas)",
      "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 denormalized database schema consisting of one or more fact tables referencing any number of dimension tables."
      ],
      "links": [
        [
          "database",
          "database"
        ],
        [
          "data warehousing",
          "data warehouse"
        ],
        [
          "denormalized",
          "denormalized"
        ],
        [
          "schema",
          "schema"
        ],
        [
          "fact table",
          "fact table"
        ]
      ],
      "qualifier": "data warehousing",
      "raw_glosses": [
        "(databases, data warehousing) A denormalized database schema consisting of one or more fact tables referencing any number of dimension tables."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "word": "star schema"
}

This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2024-04-30 from the enwiktionary dump dated 2024-04-21 using wiktextract (210104c and c9440ce). 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.