Lightnews — Scholar-powered news

Andreas Kipf @andreaskipf.bsky.social · Aug 31

Looking forward to great discussions and catching up with everyone at VLDB!

Andreas Kipf @andreaskipf.bsky.social · Aug 31

Tuesday, 1:45 PM:
🪂 Parachute: Single-Pass Bi-Directional Information Passing
by Mihail Stoian (Research 8 — Westminster, 4F)
PDF: www.vldb.org/pvldb/vol18/...
Code: github.com/utndatasyste...

1

Andreas Kipf @andreaskipf.bsky.social · Aug 31

Monday, 11:45 AM:
🍫 Instance-Optimized String Fingerprints
by Mihail Stoian (AIDB Workshop — Westminster, 4F)
PDF: arxiv.org/pdf/2507.10391
Code: github.com/utndatasyste...

1

Andreas Kipf @andreaskipf.bsky.social · Aug 31

Our lab is excited to be presenting two papers at VLDB 2025 in London this week! 🇬🇧

1 1 1

Andreas Kipf @andreaskipf.bsky.social · Jul 5

🔗 Learn more about our research and team: utndatasystems.github.io

Data Systems Lab | Home

utndatasystems.github.io

Andreas Kipf @andreaskipf.bsky.social · Jul 5

🛠️ The position requires strong programming skills in C++ and Python.

We've already published early results in this space:
- Virtual, TRL @ NeurIPS'24: arxiv.org/pdf/2410.140...
- Virtual, EDBT'25 (Best Demo): openproceedings.org/2025/conf/ed...

1

Andreas Kipf @andreaskipf.bsky.social · Jul 5

📍 Based in Nuremberg, a vibrant and historic city in the heart of Bavaria, our lab offers a stimulating research environment and an excellent quality of life.

1 1

Andreas Kipf @andreaskipf.bsky.social · Jul 5

This fully funded position (100% E13 salary) is part of an exciting collaboration with the Machine Learning Lab, focusing on systems-oriented research at the intersection of databases and machine learning.

1

Andreas Kipf @andreaskipf.bsky.social · Jul 5

The Data Systems Lab is seeking a motivated PhD candidate to join our team and work on foundation models for data compression.

1 3 2

Andreas Kipf @andreaskipf.bsky.social · Jun 22

Off to SIGMOD 2025 in Berlin! 🚄

Here’s our schedule:

Today, 4:20 PM:
💡 Redbench: A Benchmark Reflecting Real Workloads (aiDM)

Wed, 2:00 PM:
🏆 DPconv: Super-Polynomially Faster Join Ordering

Thu, 2:30 PM:
❄️ Pruning in Snowflake: Working Smarter, Not Harder

Come say hi! 👋

1 3

Andreas Kipf @andreaskipf.bsky.social · May 5

Excited to share our latest paper in collaboration with Snowflake! Congratulations to my PhD student, @andizimmerer.bsky.social, on his first SIGMOD publication, and many thanks to Snowflake for their support—both in providing essential statistics and championing the work.

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

4

Andreas Kipf @andreaskipf.bsky.social · Apr 11

Fantastic news 🎖️

@mihailstoian.bsky.social will present DPconv at SIGMOD in Berlin this June.

Mihail Stoian @mihailstoian.bsky.social · Apr 10

DPconv just won a SIGMOD'25 Honorable Mention! 🥁

I was quite impressed, given this year's high-quality papers. Let's see who won the big prize.

My list of candidates in the thread below 🧵.

Paper: dl.acm.org/doi/10.1145/...
Slides: stoianmihail.github.io/assets/dpcon...

1 2

Andreas Kipf @andreaskipf.bsky.social · Mar 28

Thrilled to share that we've received the Best Demonstration Award 🏆 at EDBT 2025!

Congratulations to my students @mihailstoian.bsky.social and Ping-Lin Kuo for their excellent work and dedication over the past few weeks—well deserved!

Paper: openproceedings.org/2025/conf/ed...

1 4

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

Andreas Kipf @andreaskipf.bsky.social · Mar 4

A huge thank you to our speakers and everyone who contributed to the great discussions at today’s workshop!

A big shout-out to Manisha Luthra and @matthiasboehm7.bsky.social for co-organizing—always a pleasure working together! 😊

1 5

Andreas Kipf @andreaskipf.bsky.social · Feb 26

We just announced the program. Hope to see you in Bamberg on Tuesday!

luthramanisha.github.io/ML4Sys-and-S...

2

Andreas Kipf @andreaskipf.bsky.social · Feb 5

Chapeau!

2

Andreas Kipf @andreaskipf.bsky.social · Feb 5

During their time with us, they gained insights into our research projects, particularly DataLoom and Virtual. Moreover, they had the chance to enjoy the modern furniture in our seminar rooms.

DataLoom: dl.acm.org/doi/pdf/10.1...
Virtual: arxiv.org/pdf/2410.14066

2

Andreas Kipf @andreaskipf.bsky.social · Feb 5

It was a pleasure to host six students from the Software Engineering Elite Graduate Master's Program (University of Augsburg, @tum.de, and @lmumuenchen.bsky.social) for a brief visit to UTN.

1 1 4

Andreas Kipf @andreaskipf.bsky.social · Jan 29

In addition to the 30 students in the program, researchers from UTN's AI labs joined us, keen to explore how AI could further enhance Firebolt's caching system.

1

Andreas Kipf @andreaskipf.bsky.social · Jan 29

Alex showcased how Firebolt caches results from arbitrary operators using a cost-benefit-based replacement policy. He also introduced Firebolt's hash join, which features a compact hash table design minimizing its memory footprint.

1 1

Andreas Kipf @andreaskipf.bsky.social · Jan 29

This week, in the Data Engineering course of the AI & Robotics Master's program at UTN, we had the pleasure of hosting Alex Hall from @firebolthq.bsky.social for an insightful talk on optimizing SQL query performance through caching and reusing subresults in repetitive workloads.

1 1 4

Reposted by Andreas Kipf

Mihail Stoian @mihailstoian.bsky.social · Dec 14

Are you a fan of Parquet and at #NeurIPS2024 tomorrow? Let's meet at our poster at @trl-research.bsky.social to see how you can reduce your Parquet file sizes by up to 40%.

Virtual compresses tables via functions while ensuring fast column scans.

⏰ 2.30pm
📍East Meeting Room 11 & 12

1 3 5

Andreas Kipf @andreaskipf.bsky.social · Dec 4

Come join us in Bamberg in March. The submission process is very lightweight, you just need to complete a Google Form.

Matthias Boehm @matthiasboehm7.bsky.social · Dec 4

We now extended the deadline of the ML4Sys/Sys4ML@BTW workshop to Dec 15
luthramanisha.github.io/ML4Sys-and-S...

Second Workshop on ML4Sys and Sys4ML

luthramanisha.github.io

1

Reposted by Andreas Kipf

PVLDB @pvldb.bsky.social · Dec 2

Vol:17 No:12 → DataLoom: Simplifying Data Loading with LLMs
👥 Authors: Alexander Van Renen, Mihail Stoian, Andreas Kipf
📄 PDF: https://www.vldb.org/pvldb/vol17/p4449-renen.pdf

Thumbnail: DataLoom: Simplifying Data Loading with LLMs

2 3