English
Vladimir Ozerov
801 posts
Vladimir Ozerov
@devozerov
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 Tham gia Şubat 2015
302 Đang theo dõi390 Người theo dõi
Today was my last day at Google. It's time to create something new. In the next few months, I intend to evolve the @morel_lang language, realize the SQL semantic layer, improve @ApacheCalcite, and play more Beethoven piano sonatas!
Read the blog post: blog.hydromatic.net/2025/03/03/int…
English
@duckdb Why not an independent foundation like ASF or Linux Foundation?
English
We strive to ensure that the DuckDB project stays open-source in the long term. That's why we set up the DuckDB Foundation, an Amsterdam-based non-profit organization, in 2021. The Foundation owns the intellectual property of the DuckDB project and enshrines the availability of DuckDB as open-source in its notarized statutes.
In the interest of transparency, we have now published the (English translation of the) Foundation's statutes. Read them at duckdb.org/pdf/deed-of-in…
English
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/composabl…
Querify Labs@QuerifyLabs
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/composabl…
English
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…
Jason Nochlin@jasonnochlin
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!
English
Very true, but also very difficult to achieve 🙂
Peter Yang@petergyang
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."
English
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!
Querify Labs@QuerifyLabs
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-f…
English
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!
English
@ClickHouseDB Hey folks. How do you generate that image? We have a similar problem - many concurrent tasks with some unfortunate blocking, and we would like to build a similar visualization from stats data.
English
One query is fast. Another has to be optimized. Here is what the difference looks like:
English
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.
Querify Labs@QuerifyLabs
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/distinct-…
English
Vladimir Ozerov đã retweet
Vladimir Ozerov đã retweet
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.
English
Vladimir Ozerov đã retweet
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.
English
Vladimir Ozerov đã retweet
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.
English
Vladimir Ozerov đã retweet
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."
English
Vladimir Ozerov đã retweet
i have thought about this hacker news comment nearly every day since november ninth twenty seventeen
English
Vladimir Ozerov đã retweet
The (sub)thread I've been waiting for: how to get started with SIMD
news.ycombinator.com/item?id=316236…
English
Чем больше вы хотите успевать, тем более эффективны вы должны быть в единицу времени. Открытие этого года для меня - информационная гигиена. Удалить ненужные приложения, отписаться от негатива, заблокировать мудаков. Очень жалею, что дорос до этого только сейчас.
Русский