DBridge: A Holistic Optimizer
DBridge is a tool to optimize database/web service access by performing optimizations that span across the boundaries of the application and the data source. This involves bringing together ideas from traditional database query optimization, program analysis and compiler optimization, in order to optimize database applications, bridging the gap between the query language and the programming language.
Check out the follow on project
LaFP: Lazy Fat Pandas on a Diet
Publications
-
Cobra: A Framework for Cost Based Rewriting of Database Applications .pdf
K. Venkatesh Emani and S. Sudarshan
IEEE International Conf. On Data Engineering (ICDE), 2018 -
Test Data Generation for Database Applications .pdf
Pooja Agrawal, Bikash Chandra, K. Venkatesh Emani, Neha Garg, and S. Sudarshan
Demo, IEEE International Conf. On Data Engineering (ICDE), 2018 -
DBridge: Translating Imperative Code to SQL .pdf
K. Venkatesh Emani, Tejas Deshpande, Karthik Ramachandra, and S. Sudarshan
Demo, ACM Int'l Conf. on Management of Data (SIGMOD) 2017 -
Extracting Equivalent SQL from Imperative Code in Database Applications .pdf
K. Venkatesh Emani, Karthik Ramachandra, Subhro Bhattacharya, and S. Sudarshan
ACM Int'l Conf. on Management of Data (SIGMOD) 2016 -
Program Transformations for Asynchronous and Batched Query Submission .pdf
Karthik Ramachandra, Mahendra Chavan, Ravindra Guravannavar and S. Sudarshan
IEEE Trans. on Knowledge and Data Engineering (TKDE) 2015 -
Database-Aware Program Optimization via Static Analysis .pdf
Karthik Ramachandra and Ravindra Guravannavar
IEEE Data Eng. Bull. 2014 -
Decorrelation of User Defined Function Invocations in Queries .pdf
Varun Simhadri, Karthik Ramachandra, Arun Chaitanya, Ravindra Guravannavar, and S. Sudarshan
ICDE 2014 -
Holistic Optimization of Database Applications
Karthik Ramachandra
Ph.D Thesis 2014 -
Program Analysis and Transformation for Holistic Optimization of Database Applications .pdf .pptx
Karthik Ramachandra, Ravindra Guravannavar and S. Sudarshan
ACM SIGPLAN Workshop on State of the Art in Program Analysis (SOAP) 2012, held in conjunction with PLDI 2012 -
Holistic Optimization by Prefetching Query Results .pdf .pptx
Karthik Ramachandra and S. Sudarshan
SIGMOD 2012 -
DBridge: A Program Rewrite Tool for Set-Oriented Query Execution .pdf
Mahendra Chavan, Ravindra Guravannavar, Karthik Ramachandra and S. Sudarshan
Demo, ICDE 2011 -
Program Transformations for Asynchronous Query Submission .pdf .pptx
Mahendra Chavan, Ravindra Guravannavar, Karthik Ramachandra and S. Sudarshan
ICDE 2011 -
Optimization and Evaluation of Nested Queries and Procedures .pdf
Ravindra Guravannavar
Ph.D Thesis, 2009 -
Rewriting Procedures for Batched Bindings .pdf .ppt
Ravindra Guravannavar and S. Sudarshan
VLDB 2008
Talks and Posters
- SIGMOD 2012 poster (pdf): Holistic Optimization by Prefetching Query Results
- Microsoft Research TechVista 2012 poster: Holistic Optimization Of Database Applications
- Talk at Microsoft Research (video): Program Transformations for Holistic Query Optimization
- Yahoo KSC 2011 Student summit poster (ppt): Holistic Optimization Of Database Applications
- ICDE 2011 poster (pdf): DBridge: A Program Rewrite Tool for Set-Oriented Query Execution
People
- S Sudarshan, IIT Bombay
- Ravindra Guravannavar, IIT Bombay (currently an Independent Consultant)
- Karthik Ramachandra, IIT Bombay (currently with Microsoft Gray Systems Lab)
- K Venkatesh Emani, IIT Bombay
- Tejas Deshpande, IIT Bombay
- Tarun Jain, IIT Bombay (currently with Intel)
- Mahendra Chavan, IIT Bombay (currently with Sybase)
- Prabhas Samanta, IIT Bombay (currently with Sybase)