Artwork

محتوای ارائه شده توسط Kostas Pardalis, Nitay Joffe. تمام محتوای پادکست شامل قسمت‌ها، گرافیک‌ها و توضیحات پادکست مستقیماً توسط Kostas Pardalis, Nitay Joffe یا شریک پلتفرم پادکست آن‌ها آپلود و ارائه می‌شوند. اگر فکر می‌کنید شخصی بدون اجازه شما از اثر دارای حق نسخه‌برداری شما استفاده می‌کند، می‌توانید روندی که در اینجا شرح داده شده است را دنبال کنید.https://fa.player.fm/legal
Player FM - برنامه پادکست
با برنامه Player FM !

Incremental Materialization: Reinventing Database Views with Gilad Kleinman of Epsio

52:19
 
اشتراک گذاری
 

Fetch error

Hmmm there seems to be a problem fetching this series right now. Last successful fetch was on September 08, 2025 15:55 (2M ago)

What now? This series will be checked again in the next day. If you believe it should be working, please verify the publisher's feed link below is valid and includes actual episode links. You can contact support to request the feed be immediately fetched.

Manage episode 478796308 series 3594857
محتوای ارائه شده توسط Kostas Pardalis, Nitay Joffe. تمام محتوای پادکست شامل قسمت‌ها، گرافیک‌ها و توضیحات پادکست مستقیماً توسط Kostas Pardalis, Nitay Joffe یا شریک پلتفرم پادکست آن‌ها آپلود و ارائه می‌شوند. اگر فکر می‌کنید شخصی بدون اجازه شما از اثر دارای حق نسخه‌برداری شما استفاده می‌کند، می‌توانید روندی که در اینجا شرح داده شده است را دنبال کنید.https://fa.player.fm/legal

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

  continue reading

22 قسمت

Artwork
iconاشتراک گذاری
 

Fetch error

Hmmm there seems to be a problem fetching this series right now. Last successful fetch was on September 08, 2025 15:55 (2M ago)

What now? This series will be checked again in the next day. If you believe it should be working, please verify the publisher's feed link below is valid and includes actual episode links. You can contact support to request the feed be immediately fetched.

Manage episode 478796308 series 3594857
محتوای ارائه شده توسط Kostas Pardalis, Nitay Joffe. تمام محتوای پادکست شامل قسمت‌ها، گرافیک‌ها و توضیحات پادکست مستقیماً توسط Kostas Pardalis, Nitay Joffe یا شریک پلتفرم پادکست آن‌ها آپلود و ارائه می‌شوند. اگر فکر می‌کنید شخصی بدون اجازه شما از اثر دارای حق نسخه‌برداری شما استفاده می‌کند، می‌توانید روندی که در اینجا شرح داده شده است را دنبال کنید.https://fa.player.fm/legal

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

  continue reading

22 قسمت

همه قسمت ها

×
 
Loading …

به Player FM خوش آمدید!

Player FM در سراسر وب را برای یافتن پادکست های با کیفیت اسکن می کند تا همین الان لذت ببرید. این بهترین برنامه ی پادکست است که در اندروید، آیفون و وب کار می کند. ثبت نام کنید تا اشتراک های شما در بین دستگاه های مختلف همگام سازی شود.

 

راهنمای مرجع سریع

در حین کاوش به این نمایش گوش دهید
پخش