Laracon DB
Laracon DB
Talks for "analytics"
Analyzing Analytical Databases

Jess Archer presents a detailed comparison between traditional OLTP databases like MySQL and analytical (OLAP) databases, focusing on ClickHouse. She demonstrates performance differences using a Stack Overflow dataset of 60M rows, showing how analytical databases excel at aggregation queries while traditional databases are better for row-level operations. The talk includes live demonstrations of query performance and explains internal workings of column-oriented vs row-oriented database storage.