About Me

I am an Assistant Professor of Computer Science at Northwestern University. I was previously a postdoctoral researcher at Carnegie Mellon University and Brown University. I received my Ph.D. in Computer Science from Brown in 2019.

Publications

• Wan Shen Lim, Matthew Butrovich, William Zhang, Andrew Crotty, Lin Ma, Peijing Xu, Johannes Gehrke, Andrew Pavlo. Database Gyms. CIDR (2023)
• Andrew Crotty, Viktor Leis, Andrew Pavlo. Are You Sure You Want to Use MMAP in Your Database Management System? CIDR (2022) [talk]
• Franco Solleza, Andrew Crotty, Suman Karumuri, Nesime Tatbul, Stan Zdonik. Mach: A Pluggable Metrics Storage Engine for the Age of Observability. CIDR (2022)
• Jiwon Choe, Andrew Crotty, Tali Moreshet, Maurice Herlihy, R. Iris Bahar. HybriDS: Cache-Conscious Concurrent Data Structures for Near-Memory Processing Architectures. SPAA (2022)
• Andrew Crotty. Hist-Tree: Those Who Ignore It Are Doomed to Learn. CIDR (2021) [talk]
• Andrew Crotty, Alex Galakatos, Connor Luckett, Ugur Cetintemel. The Case for In-Memory OLAP on "Wimpy" Nodes. ICDE (2021)
• Connor Luckett, Andrew Crotty, Alex Galakatos, Ugur Cetintemel. Odlaw: A Tool for Retroactive GDPR Compliance. ICDE (2021)
• Andrew Crotty, Alex Galakatos, Tim Kraska. Getting Swole: Generating Access-Aware Code with Predicate Pullups. ICDE (2020) [talk]
• Amir Ilkhechi, Andrew Crotty, Alex Galakatos, Yicong Mao, Grace Fan, Xiran Shi, Ugur Cetintemel. DeepSqueeze: Deep Semantic Compression for Tabular Data. SIGMOD (2020)
• Nathaniel Weir, Prasetya Utama, Alex Galakatos, Andrew Crotty, Amir Ilkhechi, Shekar Ramaswamy, Rohin Bhushan, Nadja Geisler, Benjamin Hattasch, Steffen Eger, Ugur Cetintemel, Carsten Binnig. DBPal: A Fully Pluggable NL2SQL Training Pipeline. SIGMOD (2020)
• Andrew Crotty. NullDB: Instantaneously Answering Any OLAP Query. CIDR (2019)
• Nathaniel Weir, Andrew Crotty, Alex Galakatos, Amir Ilkhechi, Shekar Ramaswamy, Rohin Bhushan, Ugur Cetintemel, Prasetya Utama, Nadja Geisler, Benjamin Hattasch, Steffen Eger, Carsten Binnig. DBPal: Weak Supervision for Learning a Natural Language Interface to Databases. CAST@VLDB (2019)
• Alex Galakatos, Andrew Crotty, Tim Kraska. Distributed Machine Learning. EDBS (2018)
• Alex Galakatos, Andrew Crotty, Emanuel Zgraggen, Carsten Binnig, Tim Kraska. Revisiting Reuse for Approximate Query Processing. VLDB (2017)
• Emanuel Zgraggen, Alex Galakatos, Andrew Crotty, Jean-Daniel Fekete, Tim Kraska. How Progressive Visualizations Affect Exploratory Analysis. TVCG (2017)
• Carsten Binnig, Fuat Basik, Benedetto Buratti, Ugur Cetintemel, Yeounoh Chung, Andrew Crotty, Cyrus Cousins, Dylan Ebert, Philipp Eichmann, Alex Galakatos, Benjamin Hattasch, Amir Ilkhechi, Tim Kraska, Zeyuan Shang, Isabella Tromba, Arif Usta, Prasetya Utama, Eli Upfal, Linnan Wang, Nathaniel Weir, Robert C. Zeleznik, Emanuel Zgraggen. Towards Interactive Data Exploration. BIRTE@VLDB (2017)
• Philipp Eichmann, Andrew Crotty, Alex Galakatos, Emanuel Zgraggen. Discrete Time Specifications in Temporal Queries. CHI LBW (2017)
• Carsten Binnig, Andrew Crotty, Alex Galakatos, Tim Kraska, Erfan Zamanian. The End of Slow Networks: It's Time for a Redesign. VLDB (2016)
• Andrew Crotty, Alex Galakatos, Emanuel Zgraggen, Carsten Binnig, Tim Kraska. The Case for Interactive Data Exploration Accelerators (IDEAs). HILDA@SIGMOD (2016)
• Andrew Crotty, Alex Galakatos, Kayhan Dursun, Tim Kraska, Carsten Binnig, Ugur Cetintemel, Stan Zdonik. An Architecture for Compiling UDF-centric Workflows. VLDB (2015)
• Andrew Crotty, Alex Galakatos, Emanuel Zgraggen, Carsten Binnig, Tim Kraska. Vizdom: Interactive Analytics through Pen and Touch. VLDB (2015) – Best Demo Award
• Andrew Crotty, Alex Galakatos, Kayhan Dursun, Tim Kraska, Ugur Cetintemel, Stanley B. Zdonik. Tupleware: "Big" Data, Big Analytics, Small Clusters. CIDR (2015)
• Carsten Binnig, Ugur Cetintemel, Tim Kraska, Stan Zdonik, Erfan Zamanian, Andrew Crotty. I-Store: Data Management for Fast Networks. NEDB (2015)
• Andrew Crotty, Alex Galakatos, Tim Kraska. Tupleware: Distributed Machine Learning on Small Clusters. IEEE Data Eng. Bull. (2014)

Teaching

• CS496: Special Topics in Data Systems – Northwestern University: Fall 2022 (Instructor)
• 15-445/645: Database Systems – Carnegie Mellon University: Fall 2021 (Co-Instructor)
• CSCI 1270: Database Management Systems – Brown University: Fall 2014 (Grad TA)
• CSCI 2257: Database Systems and Applications – Boston College: Spring 2011 (TA), Spring 2012 (TA)

Awards & Service

• Google PhD Fellowship (2016–2018)
• VLDB Best Demo Award (2015)
• Brown CS Application Feedback Program for Underrepresented Applicants (2020)
• Brown CS PhD Admissions (2016, 2019)
• Research PC: SIGMOD '24, VLDB '23, SIGMOD '23, CIDR '23, VLDB '20
• Demo PC: VLDB '23, VLDB '22
• Reviewer: SIGMOD '18, IEEE Data Eng. Bull. '17, OSDI '16, ICDE '16, SIGMOD '15, HotCloud '14, SIGMOD '14, ICDE '14, SOCC '13