Picasso Database Query Optimizer Visualizer

©Indian Institute of Science, Bangalore, India

PUBLICATIONS

PAPERS

• Analyzing Plan Diagrams of Database Query Optimizers
  Naveen Reddy and Jayant Haritsa
  Proc. of 31st Intl. Conf. on Very Large Data Bases (VLDB), Trondheim, Norway, September 2005.

• On the Production of Anorexic Plan Diagrams
  Harish D., Pooja Darera and Jayant Haritsa
  Proc. of 33rd Intl. Conf. on Very Large Data Bases (VLDB), Vienna, Austria, September 2007.

• Identifying Robust Plans through Plan Diagram Reduction
  Harish D., Pooja Darera and Jayant Haritsa
  Proc. of 34th Intl. Conf. on Very Large Data Bases (VLDB), Auckland, New Zealand, August 2008.

• Efficiently Approximating Query Optimizer Plan Diagrams
  Atreyee Dey, Sourjya Bhaumik, Harish D. and Jayant Haritsa
  Proc. of 34th Intl. Conf. on Very Large Data Bases (VLDB), Auckland, New Zealand, August 2008.

• On the Stability of Plan Costs and the Costs of Plan Stability
  M. Abhirama, Sourjya Bhaumik, Atreyee Dey, Harsh Shrimal and Jayant Haritsa
  Proc. of 36th Intl. Conf. on Very Large Data Bases (VLDB), Singapore, September 2010.

• The Picasso Database Query Optimizer Visualizer
  Jayant Haritsa
  Proc. of 36th Intl. Conf. on Very Large Data Bases (VLDB), Singapore, September 2010.

• THESES

• Next Generation Relational Query Optimizers
  Naveen Reddy
  ME Thesis, Dept. of Computer Science and Automation, Indian Institute of Science, June 2005.

• Picasso: Design and Implementation of a Database Optimizer Analyzer
  Mohammed Aslam
  ME Thesis, Dept. of Computer Science and Automation, Indian Institute of Science, July 2006.

• Picasso: Analyzing and Characterizing Relational Query Optimizers
  Akshat Nair
  ME Thesis, Dept. of Computer Science and Automation, Indian Institute of Science, July 2006.

• Picasso 1.0: Design and Analysis
  Tarun Ramsinghani
  ME Thesis, Dept. of Computer Science and Automation, Indian Institute of Science, July 2007.

• Reduction of Query Optimizer Plan Diagrams
  Pooja Darera
  MS Thesis, Supercomputer Education & Research Center, Indian Institute of Science, December 2007.

• SIGHT and SEER: Efficient Production and Reduction of Query Optimizer Plan Diagrams
  Harish D
  ME Thesis, Dept. of Computer Science and Automation, Indian Institute of Science, July 2008.

• Efficient Generation of Query Optimizer Plan Diagrams
  Sourjya Bhaumik
  ME Thesis, Dept. of Computer Science and Automation, Indian Institute of Science, June 2009.

• Characterizing Plan Diagram Reduction Quality and Efficiency
  Harsh Shrimal
  ME Thesis, Dept. of Computer Science and Automation, Indian Institute of Science, June 2009.

• Design and Implementation of Picasso 2.0
  Ravi Shetye
  ME Thesis, Dept. of Computer Science and Automation, Indian Institute of Science, July 2009.

• On the Stability of Plan Costs and the Costs of Plan Stability
  M. Abhirama
  ME Thesis, Dept. of Computer Science and Automation, Indian Institute of Science, August 2009.

• Efficiently Approximating Query Optimizer Diagrams
  Atreyee Dey
  MS Thesis, Supercomputer Education & Research Centre, Indian Institute of Science, August 2009.
  
  

· TECHNICAL REPORTS

• Reduction of Query Optimizer Plan Diagrams
  Harish D., P. Darera and J. Haritsa
  Technical Report TR-2007-01, DSL/SERC, Indian Institute of Science, March 2007.

• Robust Plans through Plan Diagram Reduction
  Harish D., P. Darera and J. Haritsa
  Technical Report TR-2007-02, DSL/SERC, Indian Institute of Science, November 2007.

• Efficient Generation of Approximate Plan Diagrams
  A. Dey, S. Bhaumik, Harish D. and J. Haritsa
  Technical Report TR-2008-01, DSL/SERC, Indian Institute of Science, March 2008.

• Stability-conscious Query Optimization
  M. Abhirama, Sourjya Bhaumik, Atreyee Dey, Harsh Shrimal and Jayant Haritsa
  Technical Report TR-2009-01, DSL/SERC, Indian Institute of Science, October 2009.

Documentation Home