MJMilind Joshi

Milind Joshi

*This is an algorithmically generated author record based on publicly available information.

Current Organizations / Institutes

The organizations/institutes from the scholar's latest article


Milind Joshi has a total of 10 co-authors. Here are the top co-authors by number of shared publications:


Latest Publications

  • Open Access

    Bitmap Filtering in the Fabric Data Warehouse

    by Nicolas Bruno, Ernesto Cervantes Juárez, César Galindo-Legaria, Milind Joshi, José Alberto López Magaña, Josep Aguilar Saborit

    Bitmap filtering is a technique used to accelerate queries that contain hash-based joins. Beyond simple select-project-join queries, bitmap filters can also be applied to more complex query patterns, sometimes achieving performance comparable to alternative plans that query engines may not otherwise consider. At the same time, placing bitmap filters as a post-processing step after optimization can result in suboptimal choices. In this paper, we describe how local and distributed bitmap filters are integrated in the Microsoft Fabric Data Warehouse (or Fabric DW). We highlight challenges and solutions in the spaces of optimization, scheduling, and execution. We complement our presentation with an experimental evaluation over synthetic benchmarks and real data workloads that validate our approach.

  • Open Access

    Query Decorrelation in the Fabric Data Warehouse

    by Nicolas Bruno, César Galindo-Legaria, Milind Joshi


  • Open Access

    Unified Query Optimization in the Fabric Data Warehouse

    by Nicolas Bruno, César Galindo-Legaria, Milind Joshi, Esteban Calvo Vargas, Kabita Mahapatra, Sharon Ravindran, Guoheng Chen, Ernesto Cervantes Juárez, Beysim Sezgin

    Over a decade ago, Microsoft introduced Parallel Data Warehouse (PDW), a massively parallel processing system to manage and query large amounts of data. Its optimizer was built by reusing SQL Server's infrastructure with minimal changes, which was an effective approach to bring cost-based query optimization quickly to PDW. Over time, learnings from production as well as architectural changes in the product (such as moving from an appliance form factor to the cloud, separation of compute and storage, and serverless components) required evolving the query optimizer in Fabric DW, the latest offering from Microsoft in the cloud data warehouse space. In this paper we describe the changes to the optimization process in Fabric DW, compare them to the earlier architecture used in PDW, and validate our new approach.