Benny leads development on Dremio’s SQL query acceleration technology which is based on materialized views and algorithms for relational query tree matching and cost based optimization. He has over 20 years of experience developing business intelligence software including business analytics, data analytics and data integration technologies.
A modern data lakehouse query engine can securely access enterprise data directly from an object store without intermediary copies or proprietary data marts. The query engine has to scan, filter, join and aggregate object store data in open formats while meeting strict latency requirements to power BI dashboard workloads and ad-hoc user queries. Fundamentally, these […]
Dremio maintains physically optimized representations of source data known as Data Reflections. It can be thought of as a hybrid between materialized views and indexes. This way, Dremio’s query optimizer can accelerate a query by utilizing one or more reflections to partially or entirely satisfy a query, rather than processing the raw data in the […]
