Columnar Storage
Everything on SkillVeris tagged Columnar Storage — collected across the glossary, study notes, blog, and cheat sheets.
5 resources across 1 library
Interview Questions(5)
Columnar Storage vs Row Storage: What is the Difference?
Row storage writes all columns of a single record contiguously on disk, making it fast to read or write an entire row at once, while columnar storage groups ea…
What is Vectorized Query Execution?
Vectorized query execution processes data in batches of many values at once, using CPU SIMD instructions and cache-friendly columnar layouts, instead of the tr…
What Are Database Compression Techniques and Why Do They Matter?
Database compression techniques shrink the physical size of stored data by removing redundancy — through methods like dictionary encoding, run-length encoding,…
How Does Run-Length Encoding Work in Columnar Compression?
Run-length encoding (RLE) compresses a column by replacing consecutive repeated values with a single stored value plus a count of how many times it repeats in…
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…