The Vertica Analytic Database: C-Store 7 Years Later . - Andrew Lamb; Matt Fuller; Ramakrishna Varadarajan; Nga Tran 001; Ben Vandiver; Lyric Doshi; Chuck Bear (Proc. VLDB Endow., 2012)

The Vertica Query Optimizer: The case for specialized query optimizers. - Nga Tran 001; Andrew Lamb; Lakshmikant Shrinivas; Sreenath Bodagala; Jaimin Dave (ICDE, 2014)

Portrait of an Indexer - Computing Pointers Into Instructional Videos. - Andrew Lamb; Jose Hernandez; Jeffrey D. Ullman; Andreas Paepcke (EDM, 2016)

LevelHeaded: Making Worst-Case Optimal Joins Work in the Common Case. - Christopher R. Aberger; Andrew Lamb; Kunle Olukotun; Christopher Ré (CoRR, 2017)

Mind the Gap: Bridging Multi-Domain Query Workloads with EmptyHeaded. - Christopher R. Aberger; Andrew Lamb; Kunle Olukotun; Christopher Ré (Proc. VLDB Endow., 2017)

EmptyHeaded: A Relational Engine for Graph Processing. - Christopher R. Aberger; Andrew Lamb; Susan Tu; Andres Nötzli; Kunle Olukotun; Christopher Ré (ACM Trans. Database Syst., 2017)

LevelHeaded: A Unified Engine for Business Intelligence and Linear Algebra Querying. - Christopher R. Aberger; Andrew Lamb; Kunle Olukotun; Christopher Ré (ICDE, 2018)

Estimating Residential Solar Potential Using Aerial Data. - Ross Goroshin; Alex Wilson; Andrew Lamb; Betty Peng; Brandon Ewonus; Cornelius Ratsch; Jordan Raisher; Marisa Leung; Max Burq; Thomas Colthurst; William Rucklidge; Carl Elkin (CoRR, 2023)

Open Know-How and an Open Source Hardware Registry as a Unifying Discoverability Mechanism for Open Source Hardware Humanitarian Engineering Projects. - Robert L. Read; Christina A. Cole; Victoria Jaqua; Andrew Lamb (GHTC, 2024)

Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine. - Andrew Lamb; Yijie Shen; Daniël Heres; Jayjeet Chakraborty; Mehmet Ozan Kabak; Liang-Chi Hsieh; Chao Sun (SIGMOD Conference Companion, 2024)

POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance. - David Justen; Daniel Ritter 001; Campbell Fraser; Andrew Lamb; Nga Tran 001; Allison Lee; Thomas Bodner 001; Mhd Yamen Haddad; Steffen Zeuch; Volker Markl; Matthias Boehm 001 (Proc. VLDB Endow., 2024)

Preliminary Assessment of Strap-down Operation of a Gravity Gradient Quantum Sensor in Maritime Contexts. - Adam Seedat; Andrew Hinton; Farzad Hayati; Jonathan Winch; Andrew Lamb; Sanaz Roshanmanesh; Sha Luo; Thomas King; Nicole Metje; Kevin Ridley; Michael Holynski (PLANS, 2025)