denormalised
Optimized for reading
Denormalised is the British spelling of denormalized.
In database design, a denormalised structure deliberately duplicates data across tables to improve query speed, trading storage efficiency for faster reads.
The term extends to any system where redundancy is introduced for performance: The data warehouse uses a denormalised schema.
Organized digital information collection
- tableHorizontal furniture surface
- queryRequest for information
- schemaOrganized representational structure
- relationalConcerning connections between things
SQL · redundancy · join · entity · record · indexing · storage · retrieval
Exceeding what's needed
- flattenedMade smooth or level
- duplicatedCopied identically
- embeddedSet firmly within something
- nestedContained within another
hierarchical · consolidated · aggregated · precomputed · cached · materialized · snapshot · replicated
database
Organized digital information collection
- tableHorizontal furniture surface
- queryRequest for information
- schemaOrganized representational structure
relational · SQL · redundancy · join · entity · record · indexing · storage · retrieval · optimization
redundant
Exceeding what's needed
- flattenedMade smooth or level
- duplicatedCopied identically
- embeddedSet firmly within something
nested · hierarchical · consolidated · aggregated · precomputed · cached · materialized · snapshot · replicated · merged
denormalisednormalised
Adjusted to standard form
normalized · relational · non-redundant · structured · atomic
denormalisednormalised
Adjusted to standard form
normalized · standardised · standardized · regularised · regularized
denormalize, denormalizing, denormalization, normalise, normalize, normalised, normalized, normalising, normalizing