Lightnews — Scholar-powered news

Andi Zimmerer

@andizimmerer.bsky.social

54 followers 82 following 28 posts

PhD at University of Technology Nuremberg, researching on Database Systems. Formerly engineer at Snowflake Inc. on query acceleration; spent some academic time at MIT 🇺🇸, TUM 🇩🇪 and NTU 🇸🇬. 🎯 Berlin https://www.andi-zimmerer.com

www.andi-zimmerer.com

Posts Media Videos Starter Packs

Andi Zimmerer @andizimmerer.bsky.social · May 7

This is hilarious. I wonder if the chocolate windmill still sits somewhere on a shelf or if it had been devoured in the process of trying to prove it

Reposted by Andi Zimmerer

Emily Tucker @emilyltucker.bsky.social · May 6

I love older papers.

Lenstra and Kan, 1979 "Computational Complexity of Discrete Optimization Problems" Annals of Discrete Mathematics

#orms

"we shall be happy to award a chocolate windmill to the first person..."

1 10 31

Andi Zimmerer @andizimmerer.bsky.social · May 5

"The fastest way of processing data is to not process it."

Our SIGMOD 2025 paper shows how Snowflake skips 99.4% of data with new pruning techniques for LIMIT, top-k, and JOIN queries.

Blog: snowflakepruning.github.io
Paper: arxiv.org/abs/2504.11540

@sigmod2025.bsky.social

Andi Zimmerer | Pruning in Snowflake: Working Smarter, Not Harder

Modern cloud-based data analytics systems must efficiently process petabytes of data residing on cloud storage. A key optimization technique in state-of-the-art systems like Snowflake is partition pru...

snowflakepruning.github.io

1 5

Andi Zimmerer @andizimmerer.bsky.social · Apr 30

Paper clickbait

Andi Zimmerer @andizimmerer.bsky.social · Apr 8

Camera-ready version of the paper submitted => 115 tabs in Chrome closed.

a woman is sitting at a table with a dart board in the background and says `` i 'm done '' .

ALT: a woman is sitting at a table with a dart board in the background and says `` i 'm done '' .

media.tenor.com

Reposted by Andi Zimmerer

Andreas Kipf @andreaskipf.bsky.social · Mar 25

We just released Redbench, a new benchmark that contains 30 analytical SQL workloads that can be used to benchmark workload-driven optimizations. Go check it out!

GitHub: github.com/utndatasyste...

GitHub - utndatasystems/redbench: Redbench is a set of 30 analytical SQL workloads that can be used to benchmark workload-driven optimizations.

Redbench is a set of 30 analytical SQL workloads that can be used to benchmark workload-driven optimizations. - utndatasystems/redbench

github.com

1 5

Andi Zimmerer @andizimmerer.bsky.social · Mar 20

This.

Andi Zimmerer @andizimmerer.bsky.social · Mar 4

The first day of the BTW Conference in Bamberg is coming to an end.

Some personal favorites:
- Ismail's talk on Pruning in Snowflake
- @stefan-grafberger.com's talk on what-if analysis in ML pipelines and automatically patching ML pipelines in the background
- Observe Inc's presentation

1 5

Reposted by Andi Zimmerer

Stefan Grafberger @stefan-grafberger.com · Feb 7

Please help spread the word by reposting!

We've just created the official DEEM Workshop account: @deem-workshop.bsky.social

DEEM Workshop @ SIGMOD @deem-workshop.bsky.social · Feb 7

The Data Management for End-to-End Machine Learning workshop (@deem-workshop.bsky.social) will be back at #SIGMOD2025! ✨

🔗 Check out the CfP: deem-workshop.github.io
📝 Submission deadline: March 21
📢 Notifications: April 25

Join us for the 9th edition in Berlin!

#DEEM2025

SIGMOD/PODS 2025 @sigmod2025.bsky.social · Jan 30

DEEM - The 9th Workshop on End-to-End Data Management is also co-located with SIGMOD/PODS 2025. The deadline for papers is March 21st. For more details checkout the website
deem-workshop.github.io

5 6

Andi Zimmerer @andizimmerer.bsky.social · Feb 26

The review comment I'm most proud of: "The paper is [...] a pleasure to read". Thanks anonymous reviewer 🙏😊

Andi Zimmerer @andizimmerer.bsky.social · Feb 26

My very first paper got accepted to @sigmod2025.bsky.social! Yay! Means I'll be playing a home game in Berlin

1 1 1

Andi Zimmerer @andizimmerer.bsky.social · Feb 14

Strong agree. It's just that the "normal" model starts to cause pain on high velocity teams only

Andi Zimmerer @andizimmerer.bsky.social · Feb 10

I agree that something has to improve, following the points you outlined. But I also see that c++ has a large path dependency, so change has to be done carefully. I still prefer Rust, but I like the overall discussion around the future of C++

Andi Zimmerer @andizimmerer.bsky.social · Feb 10

Thanks for sharing, that was an interesting read!

Andi Zimmerer @andizimmerer.bsky.social · Feb 10

Currently reading through your post.
Nit: typo in "falls in the “contacts” and “profiles” camps of Steve’s list above."

Andi Zimmerer @andizimmerer.bsky.social · Feb 10

Valid points! I'm still curious what the next decade of C++ will look like

Andi Zimmerer @andizimmerer.bsky.social · Feb 10

Reading cacm.acm.org/blogcacm/21s... makes me think that Rust was just a giant research project and valuable findings are now being streamed back into C++, making them usable to a broader audience.

21st Century C++ – Communications of the ACM

cacm.acm.org

Andi Zimmerer @andizimmerer.bsky.social · Feb 7

Agreed. Buddy C++ goes undefined behavior if it's not a strict weak ordering and I've seen it crashing a couple of times as well.

Andi Zimmerer @andizimmerer.bsky.social · Feb 6

47 *is* really good! It very much depends on age, gender and body weight - I am just fortunate enough to be in a lucky group

Andi Zimmerer @andizimmerer.bsky.social · Feb 4

My professor jokingly threatened me that I would get fired if my VO2 Max is too low. After a run with him it's at 58 now. I guess I can continue my PhD 😋

2 1

Andi Zimmerer @andizimmerer.bsky.social · Jan 31

Happy for everyone in that room who got the chance to listen to Ismail. He's smart, pragmatic, and inspiring

Andi Zimmerer @andizimmerer.bsky.social · Jan 29

And it took only a tiny amount of month-long convincing given that the other platform is completely broken.

Andi Zimmerer @andizimmerer.bsky.social · Jan 29

The Nuremberg Data Systems Lab is now on Bluesky 🙌 @utndatasystems.bsky.social

1 1

Andi Zimmerer @andizimmerer.bsky.social · Jan 15

In academia, everyone always has a Colleague Working On Exactly This Problem. I still have to find one. Applications open.

Reposted by Andi Zimmerer

Kostas Stefanidis @tokost.bsky.social · Jan 14

Exciting News! 🎉
#Tampere will host EDBT/ICDT 2026! ✨
Even before the 2025 edition, the important dates are already out:
📅 Round 1 starts on:
February 5 for EDBT Papers
March 13 for ICDT Papers
edbticdt2026.github.io

We can’t wait to see your great submissions and welcome you to Tampere! 🙌

EDBT/ICDT 2026 Joint Conference - 24th March - 27th March, 2026 - Tampere, Finland

edbticdt2026.github.io

1 1 4