DBScholar

Back to papers

Factorized and Vectorized Execution: Optimizing Analytical and Semantic Queries over Relations

Summary: FFX combines arbitrary factorization with fully vectorized, pipelined execution via packed factorized vectors, avoiding join-result explosion without sacrificing cache locality. It also compacts factorized intermediates into LLM prompts, reducing token and inference costs. (summarized by gpt-5.6-luna on Jul 26 2026)

Paper ID
h240b848706474701
Venue
SIGMOD
Year
2026
Pagerank
4.9769913e-05
Overall Rank
10,463 | 29.68%
DOI
10.1145/3802055
PDF
Download (CC BY 4.0)

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

BibTeX Citation

@inproceedings{yasser_sigmod26,
        title = {{Factorized and Vectorized Execution: Optimizing Analytical and Semantic Queries over Relations}},
        author = {Yasser, Sunny and Dorbani, Anas and Mhedhbi, Amine},
        series = {{SIGMOD} '26},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3802055},
        url = {https://dl.acm.org/doi/10.1145/3802055},
        year = {2026}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank Citing Paper Year Venue Pagerank
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 29 of 29 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.00064013679
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061067652
71 DuckDB: an Embeddable Analytical Database 2019 SIGMOD 0.00037724477
163 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027480091
208 EmptyHeaded: A Relational Engine for Graph Processing 2016 SIGMOD 0.00024899872
239 The Ubiquity of Large Graphs and Surprising Challenges of Graph Processing 2018 VLDB 0.00023499655
605 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015640305
713 Optimizing Subgraph Queries by Combining Binary and Worst-Case Optimal Joins 2019 VLDB 0.00014571507
717 Palimpzest: Optimizing AI-Powered Analytics with Declarative Query Processing 2025 CIDR 0.00014528323
779 To Join or Not to Join? Thinking Twice about Joins before Feature Selection 2016 SIGMOD 0.00014048128
849 Aggregation and Ordering in Factorised Databases 2013 VLDB 0.00013498306
1,046 Graphflow: An Active Graph Database 2017 SIGMOD 0.00012316579
1,424 Velox: Meta's Unified Execution Engine 2022 VLDB 0.00010714183
1,487 Photon: A Fast Query Engine for Lakehouse Systems 2022 SIGMOD 0.00010516813
1,753 Kuzu* Graph Database Management System 2023 CIDR 9.7244117e-05
2,293 FDB: A Query Engine for Factorised Relational Databases 2012 VLDB 8.685044e-05
2,295 ThalamusDB: Approximate Query Processing on Multi-Modal Data 2024 SIGMOD 8.6822982e-05
2,592 Text2SQL is Not Enough: Unifying AI and Databases with TAG 2025 CIDR 8.243678e-05
3,154 Robust Join Processing with Diamond Hardened Joins 2024 VLDB 7.5849549e-05
3,206 Columnar Storage and List-based Processing for Graph Database Management Systems 2021 VLDB 7.5365348e-05
3,717 Logical and Physical Optimizations for SQL Query Execution over Large Language Models 2025 SIGMOD 7.0712441e-05
4,074 Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine 2024 SIGMOD 6.8175757e-05
4,371 Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries 2024 CIDR 6.6284915e-05
4,945 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.3418058e-05
5,244 DuckPGQ: Bringing SQL/PGQ to DuckDB 2023 VLDB 6.2127936e-05
5,636 LMFAO: An Engine for Batches of Group-By Aggregates 2020 VLDB 6.0549222e-05
6,552 JoinBoost: Grow Trees Over Normalized Data Using Only SQL 2023 VLDB 5.7475822e-05
7,080 DuckPGQ: Efficient Property Graph Queries in an analytical RDBMS 2023 CIDR 5.6026544e-05
7,810 Parachute: Single-Pass Bi-Directional Information Passing 2025 VLDB 5.4477354e-05
Previous Page 1 / 1 Next

Semantically Similar Papers