DBScholar

Back to papers

Photon: A Fast Query Engine for Lakehouse Systems

Summary: Photon is a vectorized Lakehouse query engine, delivering fast queries on raw data lakes and Parquet via Spark API. Design choices (vectorization vs. code generation), memory manager, and SQL/Spark integration enable 10x gains and a 100TB TPC-DS record. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
6492
Venue
SIGMOD
Year
2022
Pagerank
9.6734544e-05
Overall Rank
1,824 | 87.49%
DOI
10.1145/3514221.3526054

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{behm_sigmod22,
        title = {{Photon: A Fast Query Engine for Lakehouse Systems}},
        author = {Behm, Alexander and Palkar, Shoumik and Agarwal, Utkarsh and Armstrong, Timothy and Cashman, David and Dave, Ankur and Greenstein, Todd and Hovsepian, Shant and Johnson, Ryan and Krishnan, Arvind Sai and Leventis, Paul and Luszczak, Ala and Menon, Prashanth and Mokhtar, Mostafa and Pang, Gene and Paranjpye, Sameer and Rahn, Greg and Samwel, Bart and van Bussel, Tom and van Hovell, Herman and Xue, Maryann and Xin, Reynold and Zaharia, Matei},
        series = {{SIGMOD} '22},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3514221.3526054},
        url = {https://dl.acm.org/doi/10.1145/3514221.3526054},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 29 of 29 citing papers.

Rank Citing Paper Year Venue Pagerank
2,788 BtrBlocks: Efficient Columnar Compression for Data Lakes 2023 SIGMOD 8.1205155e-05
3,582 The Composable Data Management System Manifesto 2023 VLDB 7.2869486e-05
3,653 ClickHouse - Lightning Fast Analytics for Everyone 2024 VLDB 7.2241143e-05
4,103 Exploiting Cloud Object Storage for High-Performance Analytics 2023 VLDB 6.8993506e-05
4,457 Analyzing and Comparing Lakehouse Storage Systems 2023 CIDR 6.6913393e-05
4,705 Presto: A Decade of SQL Analytics at Meta 2023 SIGMOD 6.5529421e-05
5,469 Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine 2024 SIGMOD 6.2073056e-05
5,983 Adaptive and Robust Query Execution for Lakehouses at Scale 2024 VLDB 6.0206841e-05
7,139 Selection Pushdown in Column Stores using Bit Manipulation Instructions 2023 SIGMOD 5.6932481e-05
7,287 Is Perfect Hashing Practical for OLAP Systems? 2024 CIDR 5.6544795e-05
7,684 Deep Lake: a Lakehouse for Deep Learning 2023 CIDR 5.5679986e-05
7,959 Terabyte-Scale Analytics in the Blink of an Eye 2026 VLDB 5.5181056e-05
8,368 Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA 2023 VLDB 5.4419148e-05
8,510 Sigma Workbook: A Spreadsheet for Cloud Data Warehouses 2022 VLDB 5.4119882e-05
8,862 Composable Data Management: An Execution Overview 2024 VLDB 5.3554382e-05
10,008 Towards Unifying Query Interpretation and Compilation 2023 CIDR 5.1785299e-05
10,072 Query Compilation Without Regrets 2024 SIGMOD 5.1624689e-05
10,121 End-to-End Declarative Data Analytics: Co-designing Engines, Interfaces, and Cloud Infrastructure 2026 CIDR 5.093636e-05
10,237 Factorized and Vectorized Execution: Optimizing Analytical and Semantic Queries over Relations 2026 SIGMOD 5.093636e-05
10,662 Data Chunk Compaction in Vectorized Execution 2025 SIGMOD 5.093636e-05
10,771 Nested Parquet Is Flat, Why Not Use It? How To Scan Nested Data With On-the-Fly Key Generation and Joins 2025 SIGMOD 5.093636e-05
10,957 Towards Designing Future-Proof Data Processing Systems 2025 VLDB 5.093636e-05
10,997 The HANA Native Query Engine for Lakehouse Systems 2025 VLDB 5.093636e-05
11,006 Magnus: A Holistic Approach to Data Management for Large-Scale Machine Learning Workloads 2025 VLDB 5.093636e-05
11,016 AnalyticDB-PG: A Cloud-native High-performance Data Warehouse in Alibaba Cloud 2025 VLDB 5.093636e-05
11,030 GraphAr: An Efficient Storage Scheme for Graph Data in Data Lakes 2025 VLDB 5.093636e-05
11,078 LiquidCache: Efficient Pushdown Caching for Cloud-Native Data Analytics 2025 VLDB 5.093636e-05
11,296 Simple (yet Efficient) Function Authoring for Vectorized Engines 2024 VLDB 5.093636e-05
11,468 Big Data Analytic Toolkit: A general-purpose, modular, and heterogeneous acceleration toolkit for data analytical engines 2023 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.0006312782
23 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.00054886415
24 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00054865648
29 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.00052093615
66 The Snowflake Elastic Data Warehouse 2016 SIGMOD 0.00038561587
98 Encapsulation of Parallelism in the Volcano Query Processing System 1990 SIGMOD 0.00034510605
186 The Vertica Analytic Database: C-Store 7 Years Later 2012 VLDB 0.00026182534
293 Implementing Database Operations Using SIMD Instructions 2002 SIGMOD 0.00022259273
372 HaLoop: Efficient Iterative Data Processing on Large Clusters 2010 VLDB 0.0001981521
520 Delta Lake: High-Performance ACID Table Storage over Cloud Object Stores 2020 VLDB 0.00017136828
634 Rethinking SIMD Vectorization for In-Memory Databases 2015 SIGMOD 0.00015533814
649 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015320656
941 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013078348
1,138 Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics 2021 CIDR 0.00012023643
1,229 Weld: A Common Runtime for High Performance Data Analytics 2017 CIDR 0.00011578425
1,379 Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last 2018 VLDB 0.00010970894
2,316 Evaluating End-to-End Optimization for Data Analytics Applications in Weld 2018 VLDB 8.7596739e-05
3,195 Micro Adaptivity in Vectorwise 2013 SIGMOD 7.6481177e-05
3,647 Maximizing Persistent Memory Bandwidth Utilization for OLAP Workloads 2021 SIGMOD 7.2271935e-05
Previous Page 1 / 1 Next

Semantically Similar Papers