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
7428
Venue
SIGMOD
Year
2026
Pagerank
5.093636e-05
Overall Rank
10,237 | 29.77%
DOI
10.1145/3802055

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.0006312782
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
103 DuckDB: an Embeddable Analytical Database 2019 SIGMOD 0.00034161428
165 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027693424
211 EmptyHeaded: A Relational Engine for Graph Processing 2016 SIGMOD 0.00024797217
264 The Ubiquity of Large Graphs and Surprising Challenges of Graph Processing 2018 VLDB 0.00022980015
649 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015320656
764 To Join or Not to Join? Thinking Twice about Joins before Feature Selection 2016 SIGMOD 0.00014226652
809 Optimizing Subgraph Queries by Combining Binary and Worst-Case Optimal Joins 2019 VLDB 0.00013874588
860 Aggregation and Ordering in Factorised Databases 2013 VLDB 0.00013560445
1,058 Graphflow: An Active Graph Database 2017 SIGMOD 0.00012378784
1,245 Palimpzest: Optimizing AI-Powered Analytics with Declarative Query Processing 2025 CIDR 0.00011507415
1,757 Velox: Meta's Unified Execution Engine 2022 VLDB 9.8166984e-05
1,824 Photon: A Fast Query Engine for Lakehouse Systems 2022 SIGMOD 9.6734544e-05
2,126 Kuzu* Graph Database Management System 2023 CIDR 9.1329991e-05
2,392 FDB: A Query Engine for Factorised Relational Databases 2012 VLDB 8.6404947e-05
2,809 Text2SQL is Not Enough: Unifying AI and Databases with TAG 2025 CIDR 8.0994951e-05
3,357 Columnar Storage and List-based Processing for Graph Database Management Systems 2021 VLDB 7.4904874e-05
3,622 Robust Join Processing with Diamond Hardened Joins 2024 VLDB 7.2465862e-05
3,684 ThalamusDB: Approximate Query Processing on Multi-Modal Data 2024 SIGMOD 7.2033959e-05
4,045 Logical and Physical Optimizations for SQL Query Execution over Large Language Models 2025 SIGMOD 6.9394654e-05
4,553 Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries 2024 CIDR 6.6346951e-05
5,469 Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine 2024 SIGMOD 6.2073056e-05
5,508 LMFAO: An Engine for Batches of Group-By Aggregates 2020 VLDB 6.1922654e-05
5,529 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.18591e-05
6,439 DuckPGQ: Bringing SQL/PGQ to DuckDB 2023 VLDB 5.8787285e-05
6,585 JoinBoost: Grow Trees Over Normalized Data Using Only SQL 2023 VLDB 5.8350362e-05
6,999 DuckPGQ: Efficient Property Graph Queries in an analytical RDBMS 2023 CIDR 5.7291934e-05
8,074 Parachute: Single-Pass Bi-Directional Information Passing 2025 VLDB 5.4929961e-05
Previous Page 1 / 1 Next

Semantically Similar Papers