Data Warehousing
Everything on SkillVeris tagged Data Warehousing — collected across the glossary, study notes, blog, and cheat sheets.
3 resources across 1 library
Interview Questions(3)
What is a Materialized View?
A materialized view is a database object that stores the physical result of a query on disk, unlike a regular view which recomputes its result every time it is…
Star Schema vs Snowflake Schema: What is the Difference?
A star schema keeps each dimension table fully denormalized in one flat table around a central fact table, while a snowflake schema further normalizes those di…
Columnar vs Row Storage: Which Should You Choose?
Row storage keeps all fields of one record physically together on disk, making it fast to read or write a whole record at once, while columnar storage groups t…