Sam Arch 🇦🇺 retweeted
🧵Congrats to the #VLDB2025 award winners at @VLDBconf (London)! 🏆
• Best research papers: “Diva” (@niv_dayan @UofT + @KTHuniversity) & “AnyBlox” (@JanaGiceva @tum_db)
• Runner-up: “The Key to Effective UDF Optimization” by @CMUDB @andy_pavlo @pateljm
1
4
12
1,991
Sam Arch 🇦🇺 retweeted
The latest paper from the #1 CMU-DB PhD student @SamArchDB's is wild compilation DB magic! He automatically makes UDFs run 300x faster on @SQLServer and 1.3x faster on @duckdb.

Code: github.com/SamArch27/PRISM
Paper: vldb.org/pvldb/vol18/p1…
Vol:18 No:1 → The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining vldb.org/pvldb/vol18/p1…
2
29
221
20,608
Sam Arch 🇦🇺 retweeted
Vol:18 No:1 → The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining vldb.org/pvldb/vol18/p1…
1
14
57
25,358
The UDF world tour continues. This week, I'm stopping at UW Madison, Microsoft's Gray Systems Lab, and The University of Washington. See you all there.

10/24 @wiscdb
10/25 @GraySystemsLab
10/25 @uw_db
I am flying to the Bay Area to give talks about my new VLDB 2025 paper on UDFs with @andy_pavlo and @pateljm. With our new technique (UDF outlining), queries run up to 1000× faster than FROID. The paper will drop soon.

9/10 @databricks
9/11  @UCBerkeley
9/12 #HTAPSummit2024
2
2
32
6,801
I am flying to the Bay Area to give talks about my new VLDB 2025 paper on UDFs with @andy_pavlo and @pateljm. With our new technique (UDF outlining), queries run up to 1000× faster than FROID. The paper will drop soon.

9/10 @databricks
9/11  @UCBerkeley
9/12 #HTAPSummit2024
2
10
105
29,551
Sam Arch 🇦🇺 retweeted
This speaks to me: it’s the essence of building hard things that take time to have impact, but then matter in a big way - you have to love the process, not just the outcome!
Do what feels like play to you but looks like work to others.
11
55
468
45,345
Sam Arch 🇦🇺 retweeted
VLDB'24 Paper #1: Collecting training data for ML models with DBs is $$$/slow. @wanshenl's Boot framework uses @PostgreSQL extensions to cutoff redundant queries. Offline training goes from weeks to hours!
• Code: github.com/lmwnshn/boot
• Paper: x.com/pvldb/status/1…
Vol:17 No:11 → Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems vldb.org/pvldb/vol17/p3…
1
10
68
8,693
Sam Arch 🇦🇺 retweeted
Video of @SamArchDB 's talk from NYC Systems August 2024 is now up!

Dear UDFs, I Broke Up With You, But Now I'm Ready To Give You A Second Chance. Will You Take Me Back? Sincerely, SQL

youtube.com/watch?v=XMIEkn…
1
8
99
7,377
Sam Arch 🇦🇺 retweeted
🇦🇺s incoming
The next NYC Systems talks are Thursday August 15th. Very pleased to have @jonobelotti_IO of @modal_labs speaking about serverless cold starts, and @SamArchDB of @CMUDB speaking about SQL UDFs!

nycsystems.xyz/august-2024.ht…
0
1
8
1,795
Sam Arch 🇦🇺 retweeted
Replying to @_TylerHillery
We have three more bombs dropping this month from @lmwnshn + @SamArchDB + William Zhang. @abigale_kim just submitted her VLDB paper last week too. It's going to be a blow out year.
2
7
66
3,204
Sam Arch 🇦🇺 retweeted
It took three years to finish, but our follow-up to the 2006 "What Goes Around Comes Around" is finally out! Stonebraker and I examine the last 20 years in databases and discuss why relational databases + SQL will continue to remain on top.

📄PDF: db.cs.cmu.edu/papers/2024/wh…
23
332
1,253
173,189
Sam Arch 🇦🇺 retweeted
We are proud to release the first major version of DuckDB, v1.0.0, codenamed "Snow Duck".

This version is a culmination of almost six years of research and development. Today we are shipping an innovative database system with a backwards-compatible storage format.

Check out our duckdb.org/2024/06/03/ann…
25
267
978
123,529
Sam Arch 🇦🇺 retweeted
Here is a short video from my recent interview with @SCSatCMU's media team on the one year anniversary of the infamous @Jeopardy "matrix" scandal: instagram.com/reel/C6Y5SCPrF…
1
4
7
3,289
Sam Arch 🇦🇺 retweeted
I am excited to announce that I will start my PhD in database systems at @wiscdb and work with @xiangyao_yu beginning Fall 2024! I'm super grateful to everyone who has supported me along the way :)
9
3
147
22,060
Sam Arch 🇦🇺 retweeted
My #1 PhD student @Butro successfully completed his PhD defense. Thanks to the committee (@pateljm @justinesherry @samrmadden). Matt's thesis is on accelerating databases with eBPF (telemetry, proxies, OLTP stores).

You have 60 days to hire him. Expect fierce competition.
3
9
253
30,979