Fatih Yavuz

Database Internals Crashcasts

Technology EN ↓ 28 episodes

Welcome to Crashcasts, the podcast for tech enthusiasts! Whether you're a seasoned engineer or just starting out, this podcast will teach something to you about Database Internals .Join host Sheila and Victor as they dive deep into essential topics. Each episode is presented with gradually increasing in complexity to cover everything from basic concepts to advanced edge cases. Whether you're preparing for a phone screen or brushing up on your skills, this podcast offers invaluable insights, tips, and common pitfalls to avoid. With a focus on various technologies and best practices, you'll gain...

Author

Fatih Yavuz

Episodes

Mastering Query Optimization: Boosting Database Performance 31.08.2024 15:01

Dive into the world of query optimization and unlock the secrets to boosting database performance in this informative episode of Database Internals Crashcasts. In this episode, we explore: The fascinating evolution of query optimization from its 1970s origins to modern techniques How query plans are generated and the crucial role of join order optimization Common challenges in query optimization a...

Column-Oriented Databases: Revolutionizing Data Storage and Analysis 31.08.2024 20:13

Dive into the world of column-oriented databases and discover how they're revolutionizing data storage and analysis for big data analytics. In this episode, we explore: The unique structure and historical evolution of column-oriented databases How these databases optimize analytical queries through compression and late materialization Real-world implementations like Apache Cassandra and Google Big...

Demystifying Query Processing and Execution: How Databases Handle Your Requests 31.08.2024 11:00

Uncover the hidden complexity behind your database queries in this enlightening episode on query processing and execution. In this episode, we explore: The evolution of query processing: From simple table scans to sophisticated distributed systems The magic behind query optimization: How databases transform your SQL into efficient execution plans Real-world query processing: Comparing popular DBMS...