Query Optimization

출판물

자료 보기:

- Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server
  
  Kukjin Lee, Anshuman Dutt, Vivek Narasayya, Surajit Chaudhuri
  
  PVLDB | September 2023, 제 16 권(11): pp. 2871-2883
  
  Publication
- Leveraging query logs and machine learning for parametric query optimization
  
  Kapil Vaidya, Anshuman Dutt, Vivek Narasayya, Surajit Chaudhuri
  
  VLDB 2022 | November 2021
  
  Publication
- Pre-training Summarization Models of Structured Datasets for Cardinality Estimation
  
  Yao Lu, Srikanth Kandula, Arnd Christian König, Surajit Chaudhuri
  
  VLDB | November 2021
  
  Publication
- DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems
  
  Bailu Ding, Surajit Chaudhuri, Johannes Gehrke, Vivek Narasayya
  
  VLDB 2022 | October 2021
  
  Publication
- Data-induced predicates for sideways information passing in query optimizers
  
  Srikanth Kandula, Laurel Orr, Surajit Chaudhuri
  
  The VLDB Journal | August 2021
  
  Publication
- Efficiently Approximating Selectivity Functions using Low Overhead Regression Models
  
  Anshuman Dutt, Chi Wang, Vivek Narasayya, Surajit Chaudhuri
  
  46th International Conference on Very Large Data Bases (VLDB 2020) | August 2020
  
  Publication
- Pushing Data-Induced Predicates Through Joins in Big-Data Clusters
  
  Srikanth Kandula, Laurel Orr, Surajit Chaudhuri
  
  VLDB | August 2020
  
  Best Paper Runner-Up
  
  Publication 프로젝트
- Bitvector-aware Query Optimization for Decision Support Queries
  
  Bailu Ding, Surajit Chaudhuri, Vivek Narasayya
  
  ACM SIGMOD/PODS International Conference on Management of Data (SIGMOD 2020) | June 2020
  
  Publication
- Bitvector-aware Query Optimization for Decision Support Queries (extended version)
  
  Bailu Ding, Surajit Chaudhuri, Vivek Narasayya
  
  MSR-TR-2020-8 | April 2020
  
  글쓴이 Microsoft
  
  Publication
- Selectivity Estimation for Range Predicates using Lightweight Models
  
  Anshuman Dutt, Chi Wang, Azade Nazi, Srikanth Kandula, Vivek Narasayya, Surajit Chaudhuri
  
  45th International Conference on Very Large Data Bases (VLDB 2019) | August 2019
  
  DOI Publication
- Plan Stitch: Harnessing the Best of Many Plans
  
  Bailu Ding, Sudipto Das, Wentao Wu, Surajit Chaudhuri, Vivek Narasayya
  
  Proceedings of the VLDB Endowment (VLDB 2018) | July 2018
  
  Publication 프로젝트
- Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees
  
  Anshuman Dutt, Vivek Narasayya, Surajit Chaudhuri
  
  International Conference on Management of Data (SIGMOD) | May 2017
  
  출판
- Variance Aware Optimization of Parameterized Queries
  
  Surajit Chaudhuri, Vivek Narasayya, Hongrae Lee
  
  ACM SIGMOD | June 2010
  
  ACM SIGMOD
  
  출판 프로젝트
- Rule Profiling for Query Optimizers and their Implications
  
  Surajit Chaudhuri, Leo Giakoumakis, Vivek Narasayya, Ravi Ramamurthy
  
  International Conference of Data Engineering (ICDE) | March 2010
  
  출판
- Interactive Plan Hints for Query Optimization
  
  Nicolas Bruno, Surajit Chaudhuri, Ravi Ramamurthy
  
  SIGMOD | June 2009
  
  Publication
- Power Hints for Query Optimization
  
  Nicolas Bruno, Surajit Chaudhuri, Ravi Ramamurthy
  
  Proceedings of the International Conference on Data Engineering (ICDE) | January 2009
  
  Publication 프로젝트
- A Pay-As-You-Go Framework for Query Execution Feedback
  
  Surajit Chaudhuri, Vivek Narasayya, Ravi Ramamurthy
  
  VLDB | August 2008
  
  출판 프로젝트
- Robust Cardinality and Cost Estimation for Skyline Operator
  
  Surajit Chaudhuri, Nilesh Dalvi, Raghav Kaushik
  
  ICDE | January 2006
  
  출판
- Conditional Selectivity for Statistics on Query Expressions
  
  Nicolas Bruno, Surajit Chaudhuri
  
  SIGMOD | January 2004
  
  Publication 프로젝트
- A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries
  
  Surajit Chaudhuri, Gautam Das, Vivek Narasayya
  
  MSR-TR-2001-37 | May 2001
  
  Technical Report UU-CS-2001-35, Departement of Computer Science, Universiteit Utrecht
  
  출판 출판
- STHoles: A Multidimensional Workload-Aware Histogram
  
  Nicolas Bruno, Surajit Chaudhuri, Luis Gravano
  
  MSR-TR-2001-36 | March 2001
  
  글쓴이 Microsoft
  
  Publication 프로젝트
- Accurate Query Optimization by Sub-plan Memoization
  
  Ashraf Aboulnaga, Surajit Chaudhuri
  
  MSR-TR-1999-102 | December 1999
  
  출판 출판
- On Random Sampling over Joins
  
  Surajit Chaudhuri, Rajeev Motwani, Vivek Narasayya
  
  SIGMOD | June 1999
  
  출판
- Random Sampling for Histogram Construction: How Much is Enough?
  
  Surajit Chaudhuri, Rajeev Motwani, Vivek Narasayya
  
  SIGMOD | June 1998
  
  출판 출판 프로젝트
- An Overview of Query Optimization in Relational Systems (paper)
  
  Surajit Chaudhuri
  
  January 1998
  
  Proceedings of 1998 ACM PODS
  
  출판
- An Overview of Query Optimization in Relational Systems (slides)
  
  Surajit Chaudhuri
  
  Proceedings of 1998 ACM PODS | January 1998
  
  출판

- Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server
  
  Kukjin Lee, Anshuman Dutt, Vivek Narasayya, Surajit Chaudhuri
  
  PVLDB | September 2023, 제 16 권(11): pp. 2871-2883
  
  Publication
- Leveraging query logs and machine learning for parametric query optimization
  
  Kapil Vaidya, Anshuman Dutt, Vivek Narasayya, Surajit Chaudhuri
  
  VLDB 2022 | November 2021
  
  Publication
- Pre-training Summarization Models of Structured Datasets for Cardinality Estimation
  
  Yao Lu, Srikanth Kandula, Arnd Christian König, Surajit Chaudhuri
  
  VLDB | November 2021
  
  Publication
- DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems
  
  Bailu Ding, Surajit Chaudhuri, Johannes Gehrke, Vivek Narasayya
  
  VLDB 2022 | October 2021
  
  Publication
- Data-induced predicates for sideways information passing in query optimizers
  
  Srikanth Kandula, Laurel Orr, Surajit Chaudhuri
  
  The VLDB Journal | August 2021
  
  Publication
- Efficiently Approximating Selectivity Functions using Low Overhead Regression Models
  
  Anshuman Dutt, Chi Wang, Vivek Narasayya, Surajit Chaudhuri
  
  46th International Conference on Very Large Data Bases (VLDB 2020) | August 2020
  
  Publication
- Pushing Data-Induced Predicates Through Joins in Big-Data Clusters
  
  Srikanth Kandula, Laurel Orr, Surajit Chaudhuri
  
  VLDB | August 2020
  
  Best Paper Runner-Up
  
  Publication 프로젝트
- Bitvector-aware Query Optimization for Decision Support Queries
  
  Bailu Ding, Surajit Chaudhuri, Vivek Narasayya
  
  ACM SIGMOD/PODS International Conference on Management of Data (SIGMOD 2020) | June 2020
  
  Publication
- Bitvector-aware Query Optimization for Decision Support Queries (extended version)
  
  Bailu Ding, Surajit Chaudhuri, Vivek Narasayya
  
  MSR-TR-2020-8 | April 2020
  
  글쓴이 Microsoft
  
  Publication
- Selectivity Estimation for Range Predicates using Lightweight Models
  
  Anshuman Dutt, Chi Wang, Azade Nazi, Srikanth Kandula, Vivek Narasayya, Surajit Chaudhuri
  
  45th International Conference on Very Large Data Bases (VLDB 2019) | August 2019
  
  DOI Publication
- Plan Stitch: Harnessing the Best of Many Plans
  
  Bailu Ding, Sudipto Das, Wentao Wu, Surajit Chaudhuri, Vivek Narasayya
  
  Proceedings of the VLDB Endowment (VLDB 2018) | July 2018
  
  Publication 프로젝트
- Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees
  
  Anshuman Dutt, Vivek Narasayya, Surajit Chaudhuri
  
  International Conference on Management of Data (SIGMOD) | May 2017
  
  출판
- Rule Profiling for Query Optimizers and their Implications
  
  Surajit Chaudhuri, Leo Giakoumakis, Vivek Narasayya, Ravi Ramamurthy
  
  International Conference of Data Engineering (ICDE) | March 2010
  
  출판
- Interactive Plan Hints for Query Optimization
  
  Nicolas Bruno, Surajit Chaudhuri, Ravi Ramamurthy
  
  SIGMOD | June 2009
  
  Publication
- Power Hints for Query Optimization
  
  Nicolas Bruno, Surajit Chaudhuri, Ravi Ramamurthy
  
  Proceedings of the International Conference on Data Engineering (ICDE) | January 2009
  
  Publication 프로젝트
- Conditional Selectivity for Statistics on Query Expressions
  
  Nicolas Bruno, Surajit Chaudhuri
  
  SIGMOD | January 2004
  
  Publication 프로젝트
- Data-induced predicates for sideways information passing in query optimizers
  
  Srikanth Kandula, Laurel Orr, Surajit Chaudhuri
  
  The VLDB Journal | August 2021
  
  Publication
- Pushing Data-Induced Predicates Through Joins in Big-Data Clusters
  
  Srikanth Kandula, Laurel Orr, Surajit Chaudhuri
  
  VLDB | August 2020
  
  Best Paper Runner-Up
  
  Publication 프로젝트
- Selectivity Estimation for Range Predicates using Lightweight Models
  
  Anshuman Dutt, Chi Wang, Azade Nazi, Srikanth Kandula, Vivek Narasayya, Surajit Chaudhuri
  
  45th International Conference on Very Large Data Bases (VLDB 2019) | August 2019
  
  DOI Publication
- Pre-training Summarization Models of Structured Datasets for Cardinality Estimation
  
  Yao Lu, Srikanth Kandula, Arnd Christian König, Surajit Chaudhuri
  
  VLDB | November 2021
  
  Publication
- Efficiently Approximating Selectivity Functions using Low Overhead Regression Models
  
  Anshuman Dutt, Chi Wang, Vivek Narasayya, Surajit Chaudhuri
  
  46th International Conference on Very Large Data Bases (VLDB 2020) | August 2020
  
  Publication
- Variance Aware Optimization of Parameterized Queries
  
  Surajit Chaudhuri, Vivek Narasayya, Hongrae Lee
  
  ACM SIGMOD | June 2010
  
  ACM SIGMOD
  
  출판 프로젝트
- STHoles: A Multidimensional Workload-Aware Histogram
  
  Nicolas Bruno, Surajit Chaudhuri, Luis Gravano
  
  MSR-TR-2001-36 | March 2001
  
  글쓴이 Microsoft
  
  Publication 프로젝트
- Accurate Query Optimization by Sub-plan Memoization
  
  Ashraf Aboulnaga, Surajit Chaudhuri
  
  MSR-TR-1999-102 | December 1999
  
  출판 출판
- Rule Profiling for Query Optimizers and their Implications
  
  Surajit Chaudhuri, Leo Giakoumakis, Vivek Narasayya, Ravi Ramamurthy
  
  International Conference of Data Engineering (ICDE) | March 2010
  
  출판
- A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries
  
  Surajit Chaudhuri, Gautam Das, Vivek Narasayya
  
  MSR-TR-2001-37 | May 2001
  
  Technical Report UU-CS-2001-35, Departement of Computer Science, Universiteit Utrecht
  
  출판 출판
- On Random Sampling over Joins
  
  Surajit Chaudhuri, Rajeev Motwani, Vivek Narasayya
  
  SIGMOD | June 1999
  
  출판
- Random Sampling for Histogram Construction: How Much is Enough?
  
  Surajit Chaudhuri, Rajeev Motwani, Vivek Narasayya
  
  SIGMOD | June 1998
  
  출판 출판 프로젝트
- An Overview of Query Optimization in Relational Systems (slides)
  
  Surajit Chaudhuri
  
  Proceedings of 1998 ACM PODS | January 1998
  
  출판
- An Overview of Query Optimization in Relational Systems (paper)
  
  Surajit Chaudhuri
  
  January 1998
  
  Proceedings of 1998 ACM PODS
  
  출판
- A Pay-As-You-Go Framework for Query Execution Feedback
  
  Surajit Chaudhuri, Vivek Narasayya, Ravi Ramamurthy
  
  VLDB | August 2008
  
  출판 프로젝트
- Robust Cardinality and Cost Estimation for Skyline Operator
  
  Surajit Chaudhuri, Nilesh Dalvi, Raghav Kaushik
  
  ICDE | January 2006
  
  출판

- Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server
  
  Kukjin Lee, Anshuman Dutt, Vivek Narasayya, Surajit Chaudhuri
  
  PVLDB | September 2023, 제 16 권(11): pp. 2871-2883
  
  Publication
- Data-induced predicates for sideways information passing in query optimizers
  
  Srikanth Kandula, Laurel Orr, Surajit Chaudhuri
  
  The VLDB Journal | August 2021
  
  Publication
- On Random Sampling over Joins
  
  Surajit Chaudhuri, Rajeev Motwani, Vivek Narasayya
  
  SIGMOD | June 1999
  
  출판
- Random Sampling for Histogram Construction: How Much is Enough?
  
  Surajit Chaudhuri, Rajeev Motwani, Vivek Narasayya
  
  SIGMOD | June 1998
  
  출판 출판 프로젝트
- An Overview of Query Optimization in Relational Systems (slides)
  
  Surajit Chaudhuri
  
  Proceedings of 1998 ACM PODS | January 1998
  
  출판
- Leveraging query logs and machine learning for parametric query optimization
  
  Kapil Vaidya, Anshuman Dutt, Vivek Narasayya, Surajit Chaudhuri
  
  VLDB 2022 | November 2021
  
  Publication
- Pre-training Summarization Models of Structured Datasets for Cardinality Estimation
  
  Yao Lu, Srikanth Kandula, Arnd Christian König, Surajit Chaudhuri
  
  VLDB | November 2021
  
  Publication
- DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems
  
  Bailu Ding, Surajit Chaudhuri, Johannes Gehrke, Vivek Narasayya
  
  VLDB 2022 | October 2021
  
  Publication
- Efficiently Approximating Selectivity Functions using Low Overhead Regression Models
  
  Anshuman Dutt, Chi Wang, Vivek Narasayya, Surajit Chaudhuri
  
  46th International Conference on Very Large Data Bases (VLDB 2020) | August 2020
  
  Publication
- Pushing Data-Induced Predicates Through Joins in Big-Data Clusters
  
  Srikanth Kandula, Laurel Orr, Surajit Chaudhuri
  
  VLDB | August 2020
  
  Best Paper Runner-Up
  
  Publication 프로젝트
- Bitvector-aware Query Optimization for Decision Support Queries
  
  Bailu Ding, Surajit Chaudhuri, Vivek Narasayya
  
  ACM SIGMOD/PODS International Conference on Management of Data (SIGMOD 2020) | June 2020
  
  Publication
- Selectivity Estimation for Range Predicates using Lightweight Models
  
  Anshuman Dutt, Chi Wang, Azade Nazi, Srikanth Kandula, Vivek Narasayya, Surajit Chaudhuri
  
  45th International Conference on Very Large Data Bases (VLDB 2019) | August 2019
  
  DOI Publication
- Plan Stitch: Harnessing the Best of Many Plans
  
  Bailu Ding, Sudipto Das, Wentao Wu, Surajit Chaudhuri, Vivek Narasayya
  
  Proceedings of the VLDB Endowment (VLDB 2018) | July 2018
  
  Publication 프로젝트
- Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees
  
  Anshuman Dutt, Vivek Narasayya, Surajit Chaudhuri
  
  International Conference on Management of Data (SIGMOD) | May 2017
  
  출판
- Variance Aware Optimization of Parameterized Queries
  
  Surajit Chaudhuri, Vivek Narasayya, Hongrae Lee
  
  ACM SIGMOD | June 2010
  
  ACM SIGMOD
  
  출판 프로젝트
- Rule Profiling for Query Optimizers and their Implications
  
  Surajit Chaudhuri, Leo Giakoumakis, Vivek Narasayya, Ravi Ramamurthy
  
  International Conference of Data Engineering (ICDE) | March 2010
  
  출판
- Interactive Plan Hints for Query Optimization
  
  Nicolas Bruno, Surajit Chaudhuri, Ravi Ramamurthy
  
  SIGMOD | June 2009
  
  Publication
- Power Hints for Query Optimization
  
  Nicolas Bruno, Surajit Chaudhuri, Ravi Ramamurthy
  
  Proceedings of the International Conference on Data Engineering (ICDE) | January 2009
  
  Publication 프로젝트
- A Pay-As-You-Go Framework for Query Execution Feedback
  
  Surajit Chaudhuri, Vivek Narasayya, Ravi Ramamurthy
  
  VLDB | August 2008
  
  출판 프로젝트
- Robust Cardinality and Cost Estimation for Skyline Operator
  
  Surajit Chaudhuri, Nilesh Dalvi, Raghav Kaushik
  
  ICDE | January 2006
  
  출판
- Conditional Selectivity for Statistics on Query Expressions
  
  Nicolas Bruno, Surajit Chaudhuri
  
  SIGMOD | January 2004
  
  Publication 프로젝트
- A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries
  
  Surajit Chaudhuri, Gautam Das, Vivek Narasayya
  
  MSR-TR-2001-37 | May 2001
  
  Technical Report UU-CS-2001-35, Departement of Computer Science, Universiteit Utrecht
  
  출판 출판
- STHoles: A Multidimensional Workload-Aware Histogram
  
  Nicolas Bruno, Surajit Chaudhuri, Luis Gravano
  
  MSR-TR-2001-36 | March 2001
  
  글쓴이 Microsoft
  
  Publication 프로젝트
- Accurate Query Optimization by Sub-plan Memoization
  
  Ashraf Aboulnaga, Surajit Chaudhuri
  
  MSR-TR-1999-102 | December 1999
  
  출판 출판
- Bitvector-aware Query Optimization for Decision Support Queries (extended version)
  
  Bailu Ding, Surajit Chaudhuri, Vivek Narasayya
  
  MSR-TR-2020-8 | April 2020
  
  글쓴이 Microsoft
  
  Publication
- An Overview of Query Optimization in Relational Systems (paper)
  
  Surajit Chaudhuri
  
  January 1998
  
  Proceedings of 1998 ACM PODS
  
  출판