materialized view

Source board

This definition comes from the board below. Open it to see the term in context.

Storage ExtrasData Systems

More terms from this board

• concatenated indexseveral fields glued into one key (prefix queries only)
• data cubeprecomputed aggregate grid
• edit distance# of edits between two strings (fuzzy match)
• fact/dimension tableevent row / its descriptors
• full-text indexsearch by words
• Lucenethe search library behind Elasticsearch/Solr
• multi-dimensional indexquery several ranges at once (R-tree)
• projectiona copy of column data in a specific sort order
• R-treegeospatial index structure
• star vs snowflake schemaflat dimensions vs normalized dimensions