Schema vs Denormalize - What's the difference?

schema | denormalize |


As a noun schema

is schema, diagram.

As a verb denormalize is

(computing) to add redundancy to (a database schema), the opposite of normalization, typically in order to optimize its performance.

schema

English

Noun

(en-noun)
  • An outline or image universally applicable to a general conception, under which it is likely to be presented to the mind (for example, a ).
  • (databases) A formal description of the structure of a database: the names of the tables, the names of the columns of each table, and the data type and other attributes of each column.
  • (markup languages) A formal description of data, data types, and data file structures, such as for XML files.
  • (logic) A formula in the language of an axiomatic system, in which one or more schematic variables appear, which stand for any term or subformula of the system, which may or may not be required to satisfy certain conditions.
  • Synonyms

    * (universally-applicable image or outline) schemat * (databases) schemat * (logic) axiom schema, schemat

    Derived terms

    * conceptual schema * logical schema * physical schema

    Anagrams

    * *

    References

    * “ schema]” listed in the [[w:Oxford English Dictionary, Oxford English Dictionary] , second edition (1989) English nouns with irregular plurals ----

    denormalize

    English

    Verb

    (denormaliz)
  • (computing) To add redundancy to (a database schema), the opposite of normalization, typically in order to optimize its performance.