Incremental Materialization: Reinventing Database Views with Gilad Kleinman of Epsio

https://is1-ssl.mzstatic.com/image/thumb/Podcasts221/v4/7e/9c/9d/7e9c9d21-a625-1f92-9760-b047487d2483/mza_13551922647548641787.jpg/600x600bb.jpg

Tech on the Rocks

Kostas, Nitay

22 episodes

2 months ago

Join Kostas and Nitay as they speak with amazingly smart people who are building the next generation of technology, from hardware to cloud compute. Tech on the Rocks is for people who are curious about the foundations of the tech industry. Recorded primarily from our offices and homes, but one day we hope to record in a bar somewhere. Cheers!

Technology

RSS

All content for Tech on the Rocks is the property of Kostas, Nitay and is served directly from their servers with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.

Technology

Incremental Materialization: Reinventing Database Views with Gilad Kleinman of Epsio

Tech on the Rocks

52 minutes

6 months ago

Incremental Materialization: Reinventing Database Views with Gilad Kleinman of Epsio

Summary

In this episode, Gilad Kleinman, co-founder of Epsio, shares his unique journey from PHP development to low-level kernel programming and how that evolution led him to build an innovative incremental views engine.

Gilad explains that Epsio tackles a common challenge in databases: making heavy, complex queries faster and more efficient through incremental materialization. He describes how traditional materialized views fall short—often requiring full refreshes—and how Epsio seamlessly integrates with existing databases by consuming replication streams (CDC) and writing back to result tables without disrupting the core transactional system.

The conversation dives into the technical trade-offs and optimizations involved, such as handling stateful versus stateless operators (like group-by and window functions), using Rust for performance, and the challenges of ensuring consistency.

Gilad also contrasts Epsio’s approach with streaming systems like Flink, emphasizing that by maintaining tight integration with the native database, Epsio can offer immediate, up-to-date query results while minimizing disruption.

Finally, he outlines his vision for the future of incremental stream processing and materialized views as a means to reduce compute costs and enhance overall system performance.

Chapters

00:00 From PHP to Kernel Development: A Journey
07:30 Introducing Epsio: The Incremental Views Engine
10:56 The Importance of Materialized Views
15:07 Understanding Incremental Materialization
19:21 Optimizing Query Performance with Epsio
24:53 Integrating Epsio with Existing Databases
27:02 The Shift from Theory to Practice in Data Processing
29:42 Seamless Integration with Existing Databases
32:02 Understanding Epsio Incremental Processing Mechanism
34:46 Challenges and Limitations of Incremental Views
36:49 The Complexity of Implementing Operators
39:56 Trade-offs in Incremental Computation
41:21 User Interaction with Epsio
43:01 Comparing EPSIO with Streaming Systems
45:09 Architectural Guarantees of Epsio
50:33 The Future of Incremental Data Processing