Columnar vs. Row-based Data Structures in OLTP and OLAP Systems
By
Alex Merced
2y ago
Source
datalakehousehub.comColumnar vs. Row-based Data Structures in OLTP and OLAP Systemsdatalakehousehub.com[Follow my Data Youtube Channel]( The decision between using columnar and row-based data structures can signi...
You might also wanna read
Columnar Storage as Database Normalization: Understanding the Relational Foundation
The article explains that columnar storage in databases is essentially a form of normalization within the relational model, not a completely
buttondown.com·2mo ago
Row vs. Column: How Storage Layout Shapes Everything
iceberglakehouse.com·2mo ago

Data Modeling for Analytics: Optimize for Queries, Not Transactions
iceberglakehouse.com·4mo ago

Data Modeling for the Lakehouse: What Changes
iceberglakehouse.com·4mo ago
Exploring Data Operations with PySpark, Pandas, DuckDB, Polars, and DataFusion in a Python Notebook
iceberglakehouse.com·1y ago
Understanding B-Trees: The Data Structure That Powers Database Performance on Disk
The article explains why B-Trees are the fundamental data structure used in databases for disk-based storage. Through a personal narrative o

Comments
Sign in to join the conversation.
No comments yet. Be the first.