Vladimir Ozerov (@devozerov) header
Vladimir Ozerov (@devozerov) profile picture

Founder and CEO of Querify Labs. I tweet about query engines, distributed systems, and concurrency. Ex-Hazelcast. Ex-Gridgain. Views are my own.

Russia, Saint-Petersburg
Joined February 2015
Photo by Vladimir Ozerov (@devozerov)Photo by Vladimir Ozerov (@devozerov)Photo by Vladimir Ozerov (@devozerov)Photo by Vladimir Ozerov (@devozerov)Photo by Vladimir Ozerov (@devozerov)Photo by Vladimir Ozerov (@devozerov)Photo by Vladimir Ozerov (@devozerov)Photo by Vladimir Ozerov (@devozerov)Photo by Vladimir Ozerov (@devozerov)
Ever wondered why Apache Calcite is so popular among database folks? Because it combines great community and balanced technological decisions. We discuss the mechanics of Apache Calcite success in our new blog post: querifylabs.com/blog/composa…
Apache Calcite is the most popular query optimization framework and a prominent member of the "composable data systems" movement. Our new blog post analyzes the drivers of Calcite's success and how we can use this knowledge to push innovation further. querifylabs.com/blog/composa…
1
1
5
1,067
Subquery unnesting is absolutely critical for distributed query engines, since they usually doesn’t support nested-loop joins. But what is more interesting, is that it generic unnesting may offer some new features, such as efficient UDFs, as described in db.cs.cmu.edu/papers/2024/p1…
Surprised to learn that there is a general solution for unnesting SQL subqueries — any SQL query that has subqueries can be automatically rewritten by an optimizer into a query w/o subqueries to improve performance. Amazing finding and seems like this should have a big impact on databases!
1
348
Very true, but also very difficult to achieve 🙂
Love this clip from Jensen Huang (Nvidia CEO) on why innovation requires failure. "Unless you have a tolerance for failure, you will never experiment. If you don't experiment you won't innovate, and if you don't innovate you won't succeed."
158
To scan or not to scan, that is the question. Especially when reading large data sets. Our new article is about dynamic filtering — a critical optimization in analytical engines that allows you to read less data when doing joins. Enjoy!
How to avoid the full scan when joining a large fact table without predicates with a small dimension? Read our new blog post about dynamic filtering, a must-have optimization that skyrockets your analytical engine performance. We use Trino as an example. querifylabs.com/blog/dynamic…
2
308
Today I learned that in most office apps you can add a dash by typing two hyphens. Before that, I used to open the "Dash" Wikipedia article and copy-paste the dash character from there. What a productivity boost!
1
182
Hey folks. Have you ever wondered how the DISTINCT keyword is actually processed by query engines? Our new blog post explores how Apache Calcite and Trino optimizers rewrite distinct aggregations. TLDR: Calcite rewrites them joins, and Trino rewrites them to window functions.
Aggregation is one of the most frequently encountered operations in analytics. Our new blog post discusses how Apache Calcite and Trino optimizers deal with distinct aggregations and why you may need joins and window functions here. querifylabs.com/blog/distinc…
3
5
831
One data architecture I expect we'll see more in 2023 is #SQLite/#DuckDB deployed as caches at the edge, updated via change feeds from system-of-record: stellar read performance due to close local proximity to users and fully queryable data models tailored for specific use cases.
12
29
3
225
52,832
Vladimir Ozerov retweeted
There have been several calls to build applications with transformed data from the warehouse. I think this is directionally correct: data is not impactful until it's activated and I genuinely believe that the creative use of data/models will unlock better user experiences.
8
11
5
103
Vladimir Ozerov retweeted
Top free writing tools I use: 1. Grammarly— Correct mistakes. 2. Hemingway App—Make your writing bold and clear. 3. Quillbot— Rewrite and enhance any sentence. 4. Coschedule Headline Analyzer—Sharpen headlines to drive maximum traffic. Get 10X writing help.
80
1,629
28
5,844
Vladimir Ozerov retweeted
A job title I am seeing more and more often: Product (Software) Engineer / Product Developer Startups especially are starting to use it more, to indicate that software engineers are directly impacting the product, and look for (and empower) product-minded engineers.
42
102
24
1,292
Vladimir Ozerov retweeted
Listened to 5 bootstrapped B2C tech startups with 10-30 engineers each sharing details on how their business evolved. Common themes: 1. Infra costs. A huge focus. Almost all use @Cloudflare to reduce bills. 2. "We use pragmatic, proven tech, and are cautious with new stuff."
18
89
9
850
Vladimir Ozerov retweeted
i have thought about this hacker news comment nearly every day since november ninth twenty seventeen
463
27,347
1,342
132,963
Vladimir Ozerov retweeted
The (sub)thread I've been waiting for: how to get started with SIMD news.ycombinator.com/item?id…
4
14
Чем больше вы хотите успевать, тем более эффективны вы должны быть в единицу времени. Открытие этого года для меня - информационная гигиена. Удалить ненужные приложения, отписаться от негатива, заблокировать мудаков. Очень жалею, что дорос до этого только сейчас.
1
2
Very true!
One somewhat unfortunate thing about blogging culture is that (unlike journals) there's no strong norm of explaining where your work sits with respect to existing human understanding. This is an enormous advantage journals have in pushing forward understanding.
After >10 years in Java, I’ve just started using String.format on a regular basis instead of “+”. Pretty convenient. And now I see this 🙂
This Post is from an account that no longer exists. Learn more
2
1
Vladimir Ozerov retweeted
Fascinating HN comment from someone who's company built a custom distributed data warehouse using compressed SQLite DB files in S3 that were queried using Lambda functions orchestrated by PostgreSQL running a custom foreign data wrapper news.ycombinator.com/item?id…
22
199
48
1,326
Vladimir Ozerov retweeted
YC's message to founders:
175
1,602
656
8,476