←
Sam Arch 🇦🇺17 posts
Sam Arch 🇦🇺 avatar

Sam Arch 🇦🇺

@SamArchDB

PhD Student in Databases @CMUDB with @andy_pavlo, Previously a Compiler Engineer @apple

◷ Joined July 2023▧ 2 Photos and videos
Andy Pavlo (@andypavlo.bsky.social) avatar
⟳ Sam Arch 🇦🇺 retweeted
Andy Pavlo (@andypavlo.bsky.social)@andy_pavlo·6 Dec 2024

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-arch…

PVLDB@pvldb6 Dec 2024

Vol:18 No:1 → The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining vldb.org/pvldb/vol18/p1-arch…

Post attachment
Sam Arch 🇦🇺 avatar
Sam Arch 🇦🇺@SamArchDB·21 Oct 2024

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

Post attachment
Chris Lattner avatar
⟳ Sam Arch 🇦🇺 retweeted
Chris Lattner@clattner_llvm·6 Sep 2024

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!

Ash Lamb@ash_lmb5 Sep 2024

Do what feels like play to you but looks like work to others.

Post attachment
Andy Pavlo (@andypavlo.bsky.social) avatar
⟳ Sam Arch 🇦🇺 retweeted
Andy Pavlo (@andypavlo.bsky.social)@andy_pavlo·5 Sep 2024

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:

PVLDB@pvldb27 Aug 2024

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/p3680-l…

Post attachment
DuckDB avatar
⟳ Sam Arch 🇦🇺 retweeted
DuckDB@duckdb·3 Jun 2024

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 announcement blog post: duckdb.org/2024/06/03/announ…

Post attachment