Merick

Yeah, interestingly StarRocks was originally a fork from Doris, but these days it tends to outperform in most of the use cases I’ve read up on.

Curious, you mention Doris. I wonder if you've tried looking into StarRocks?

Good stuff, always happy to see StarRocks get some recognition. Always surprised when I talk to folks who haven't heard of them.

YES!! Normalization was the BEST PRACTICE since DBMS was invented in like the 70s, and somehow, we just totally forgot about it the past 10 years ago for OLAP. 10x more expensive storage, impossible schema evolution because of data backfilling, the extra pipelines you have to build and maintain, and the cost scales with the data size and your business growth. I was just talking with a buddy of mine about this and how to run JOINs on the fly without denormalization pipelines using StarRocks in this case.

I'll always remember Rockset for their ridiculous comparison page: https://rockset.com/real-time-analytics-comparison/

Maybe they should rename it to their migration options page. Or maybe I'll just ask ChatGPT what the best alternative is...

Still, pretty useful stuff, but it also feels like Rockset had been moving a little too slowly in recent years, but congrats to them on finding a new home.

Seconding the StarRocks project, best performance out there and the community is great. Tons of support.

StarRocks, it’s a Linux Foundation project now, but a lot of the initial team and community behind it came from China.

https://github.com/StarRocks/starrocks

Funny that I hadn’t heard of them in the database space till they showed up at the top of ClickBench. Makes me wonder what other interesting projects I’m missing out on in China.

Apache Kylin was actually China’s very first top-level Apache project. It did come out of eBay, but the work all originated in China. It’s a really cool solution to query acceleration.

You can learn about it on the community page here: http://kylin.apache.org/

It’s pretty popular across China, and I’ve seen it come up a bunch in Europe/South America, but in the U.S. it’s pretty new to a lot of folks.

Very cool to see this! Kylin has been a super fun project to b a part of. A unique approach to OLAP/query acceleration that's pretty much the best way to deal with huge volumes of data.

It's great to see them collaborating with Women Who Code to get the word out and grow our open source family. If anyone is interested in learning more about the project, check us out here: http://kylin.apache.org/

Thanks for sharing this! Apache Kylin is an awesome project. It has been around for a few years and has been getting a lot of attention in Europe and Asia, but still seems to be relatively unknown by a lot of folks I talk to in the US.

If people are interested in getting involved with the community, or just want to check Kylin out, you can find the page for the project here: http://kylin.apache.org/

Kylin is a really cool project, and how it's using OLAP for faster analytics on large datasets/big data is interesting - especially given how old the technology is. The Kylin community has found some creative ways of breathing new life into OLAP. If you'd like to join the project you can learn more here: http://kylin.apache.org/

Kylin is a super cool community. Very supportive and doing some neat stuff with OLAP. If anyone is curious and wants to join us, you can read more about the project here: http://kylin.apache.org/

Very cool, thank you for sharing. I've been a part of the Kylin community for over a year now and it has been a great experience. The project is really pretty cool. I know some people think of it as just another OLAP engine - but it is way more than that.

If you're part of a team working with huge datasets, take a look at it, and if you're looking for a great open source project to get involved with, join us!

+1 for Apache Kylin, it's a great project and awesome open source community. If anyone is curious about what modern OLAP is capable of, check it out.

If you want an alternative take on where OLAP is today and what it is capable of, I usually recommend this article: https://kyligence.io/blog/olap-analytics-is-dead-really/