Concepedia

Subquery Optimization

Subquery Optimization is a query processing technique that enhances the efficiency of database retrieval by transforming and restructuring nested subqueries into equivalent, less costly forms through logical equivalences, pushdowns, or materialization strategies.

54

Publications

3.1K

Citations

121

Authors

51

Institutions

Publications per year

2017–2026

4

Parents

Publications

54

Efficient and extensible algorithms for multi query optimization

Prasan Roy, S. Seshadri, S. Sudarshan et al. · ACM SIGMOD Record · 2000 · 409 citations

, , +10

Predicate migration

Joseph M. Hellerstein, Michael Stonebraker · 1993 · 274 citations

, , +16

Efficient and extensible algorithms for multi query optimization

Prasan Roy, S. Seshadri, S. Sudarshan et al. · 2000 · 226 citations

, , +10

Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers

Umeshwar Dayal · Very Large Data Bases · 1987 · 188 citations

, , +15

Global analytics in the face of bandwidth and regulatory constraints

Ashish Vulimiri, Carlo Curino, P. Brighten Godfrey et al. · Networked Systems Design and Implementation · 2015 · 165 citations

, , +17

1–5 of 54

Authors

121

  1. SS
    S. Sudarshan

    Indian Institute of Technology Bombay, India

    6 publications · 787 citations

    6

    h-index

  2. CG
    César Galindo-Legaria

    Microsoft (United States), United States

    3 publications · 181 citations

    3

    h-index

  3. SC
    Sophie Cluet

    Institut national de recherche en sciences et technologies du numérique, France

    3 publications · 173 citations

    3

    h-index

  4. GM
    Guido Moerkotte

    University of Mannheim, Germany

    3 publications · 145 citations

    3

    h-index

  5. MJ
    Milind Joshi

    Microsoft (United States), United States

    3 publications · 181 citations

    3

    h-index

1–5 of 121

Institutions

51

  1. Indian Institute of Technology Bombay

    Mumbai, India

    5 h-index

    10 publications

    1.4K citations

  2. Microsoft (United States)

    Redmond, United States

    4 h-index

    10 publications

    812 citations

  3. University of California, Berkeley

    Berkeley, United States

    3 h-index

    6 publications

    792 citations

  4. University of Wisconsin–Madison

    Madison, United States

    3 h-index

    4 publications

    443 citations

  5. Institute of Computer Science

    Warsaw, Poland

    2 h-index

    3 publications

    70 citations

  6. University of Louisville

    Louisville, United States

    2 h-index

    4 publications

    66 citations

  7. Polish Academy of Sciences

    Warsaw, Poland

    2 h-index

    3 publications

    70 citations

  8. Microsoft Research (India)

    Bengaluru, India

    2 h-index

    3 publications

    49 citations

1–8 of 51

Venues

  1. Very Large Data Bases

    Conference · 5 publications · 335 citations

    5

    h-index

  2. ACM SIGMOD Record

    5 publications · 552 citations

    5

    h-index

  3. Proceedings of the VLDB Endowment

    PVLDB · 3 publications · 128 citations

    3

    h-index

  4. ACM Transactions on Database Systems

    TODS · 2 publications · 61 citations

    2

    h-index

  5. MADOC (University of Mannheim)

    Repository · 1 publications · 36 citations

    1

    h-index

1–5