Query Decorrelation in the Fabric Data Warehouse

Summary: New decorrelation framework for the Microsoft Fabric Data Warehouse, integrated into the query optimizer. Experimental evaluation on a complex TPC-DS benchmark shows faster set-oriented execution of correlated subqueries on distributed Fabric. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 7173
Venue: SIGMOD
Year: 2025
Pagerank: 5.093636e-05
Overall Rank: 10,697 | 26.61%
DOI: 10.1145/3722212.3724448

Incoming Non-self Citations Over Time

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

Authors

1. Nicolas Bruno (Microsoft)
2. César Alejandro Galindo-Legaria (Microsoft)
3. Milind M. Joshi (Microsoft)

BibTeX Citation

@inproceedings{bruno_sigmod25,
        title = {{Query Decorrelation in the Fabric Data Warehouse}},
        author = {Bruno, Nicolas and Galindo-Legaria, César Alejandro and Joshi, Milind M.},
        series = {{SIGMOD} '25},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3722212.3724448},
        url = {https://dl.acm.org/doi/10.1145/3722212.3724448},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
95	Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers	1987	VLDB	0.00034607909
543	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.0001682612
894	Froid: Optimization of Imperative Programs in a Relational Database	2018	VLDB	0.00013367658
1,261	Rewriting Procedures for Batched Bindings	2008	VLDB	0.0001143305
1,362	Execution Strategies for SQL Subqueries	2007	SIGMOD	0.00011032204
1,892	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.5277793e-05
2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB	9.1803718e-05
4,310	On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates	1985	VLDB	6.7677766e-05
5,189	Performance Analysis of a Relational Data Base Management System	1979	SIGMOD	6.3272576e-05
6,015	Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL	2024	CIDR	6.008272e-05
7,055	Unified Query Optimization in the Fabric Data Warehouse	2024	SIGMOD	5.7170734e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	8,721	Accelerate Distributed Joins with Predicate Transfer	2025	SIGMOD
2	2,021	WinMagic : Subquery Elimination Using Window Aggregation	2003	SIGMOD
3	1,022	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB
4	2,302	Correlation Maps: A Compressed Access Method for Exploiting Soft Functional Dependencies	2009	VLDB
5	2,093	Reusing Invariants: A New Strategy for Correlated Queries	1998	SIGMOD
6	1,154	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD
7	2,078	Query Optimization in Microsoft SQL Server PDW	2012	SIGMOD
8	543	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD
9	1,362	Execution Strategies for SQL Subqueries	2007	SIGMOD
10	7,055	Unified Query Optimization in the Fabric Data Warehouse	2024	SIGMOD