Vivek Narasayya
PRINCIPAL RESEARCHER
.
Research Interests
- Physical database design
- Performance monitoring, diagnostics and tuning of databases
- Query optimization
Professional Activities
- Program Committee:
- ACM SIGMOD 2003, ACM SIGMOD 2008 (Industrial track)
- ACM CIKM 2004
- Clean DB Workshop 2007
- COMAD 2009
- DBTest 2010
- IEEE ICDE 2002
- SMDB 2008
- PVLDB 2008-2010
- VLDB 2006 (Core DB track)
- National Science Foundation (NSF) Panelist
- National Academy of Sciences (NAS) Panelist: Committee on State Voter Registration Databases, 2007.
- National Academy of Engineering (NAE), Frontiers of Engineering Symposium Attendee, 2008.
Invited Talks
- Vivek Narsayya. SQL Server Query Optimizer, and Reflections on Query Optimization. May 2010, Stanford University.
- Surajit Chaudhuri, Vivek Narasayya. "Self-Tuning Database Systems: A Decade of Progress". VLDB 2007, Vienna, Austria. Invited Talk for 10-year Best Paper Award.
- Vivek Narasayya. "Recent Advances in Self-Tuning Database Systems". Keynote talk at International Workshop on Automated Performance Tuning (iWAPT) 2007, Tokyo, Japan.
- Vivek Narasayya. "Microsoft SQL Server Query Optimizer". May 2007, Stanford University.
- Vivek Narasayya. "AutoAdmin: Towards Self-Tuning Databases". Nov 2002, Nov 2003, Stanford University.
Publications
2012
- Jiexing Li, Arnd Christian König, Vivek Narasayya, and Surajit Chaudhuri, Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques, in 38th International Conference on Very Large Databases, Very Large Data Bases Endowment Inc., 28 August 2012
- Arnd Christian König, Bolin Ding, Surajit Chaudhuri, and Vivek Narasayya, A Statistical Approach Towards Robust Progress Estimation, in 38th International Conference on Very Large Databases, Very Large Data Bases Endowment Inc., January 2012
2011
- Nicolas Bruno, Surajit Chaudhuri, Arnd Christian König, Vivek Narasayya, Ravi Ramamurthy, and Manoj Syamala, AutoAdmin Project at Microsoft Research: Lessons Learned, in Bulletin of the IEEE Computer Society Technical Committee on Data Engineering, IEEE Computer Society, December 2011
2010
- surajit chaudhuri, Hongrae Lee, and vivek narasayya, Variance Aware Optimization of Parameterized Queries, in ACM SIGMOD, Association for Computing Machinery, Inc., 7 June 2010
- Vivek Narasayya and Manoj Syamala, Workload Driven Index Defragmentation, in International Conference on Data Engineering (ICDE), IEEE, 1 March 2010
- Stratos Idreos, Raghav Kaushik, Vivek Narasayya, and Ravi Ramamurthy, Estimating the Compression Fraction of an Index Using Sampling, in International Conference on Data Engineering (ICDE), IEEE, 1 March 2010
- Surajit Chaudhuri, Leo Giakoumakis, Vivek Narasayya, and Ravi Ramamurthy, Rule Profiling for Query Optimizers and their Implications, in International Conference of Data Engineering (ICDE), IEEE, 1 March 2010
2009
- Hicham Elmongui, Vivek Narasayya, and Ravi Ramamurthy, A Framework for Testing Query Transformation Rules, Association for Computing Machinery, Inc., 29 June 2009
- Arjun Dasgupta, Vivek Narasayya, and Manoj Syamala, A Static Analysis Framework for Database Applications, in International Conference on Data Engineering (ICDE), IEEE, April 2009
2008
- Surajit Chaudhuri, Vivek Narasayya, and Ravi Ramamurthy, A Pay-As-You-Go Framework for Query Execution Feedback, in VLDB, Very Large Data Bases Endowment Inc., August 2008
- Surajit Chaudhuri, Vivek Narasayya, and Ravi Ramamurthy, Diagnosing Estimation Errors in Page Counts using Execution Feedback, in 24th International Conference on Data Engineering, IEEE Computer Society, April 2008
2007
- Surajit Chaudhuri and Vivek Narasayya, Self-Tuning Database Systems: A Decade of Progress., in VLDB, Very Large Data Bases Endowment Inc., September 2007
- Surajit Chaudhuri, Vivek Narasayya, and Manoj Syamala, Bridging the Application and DBMS Profiling Divide for Database Application Developers, in VLDB, Very Large Data Bases Endowment Inc., September 2007
2006
- Sanjay Agrawal, Eric Chu, and Vivek Narasayya, Automating Physical Database Design: Workload as a Sequence, in SIGMOD, Association for Computing Machinery, Inc., June 2006
- Sanjay Agrawal, Nicolas Bruno, Surajit Chaudhuri, and Vivek Narasayya, AutoAdmin: Self-Tuning Database Systems Technology, in Data Engineering Bulletin, IEEE Computer Society, 2006
2005
- Zhimin Chen and Vivek Narasayya, Efficient Computation of Multiple Group-By Queries, in SIGMOD, Association for Computing Machinery, Inc., June 2005
2004
- Sanjay Agrawal, Surajit Chaudhuri, Lubor Kollar, Arun Marathe, Vivek Narasayya, and Manoj Syamala, Database Tuning Advisor for Microsoft SQL Server 2005, in VLDB, Very Large Data Bases Endowment Inc., August 2004
- Surajit Chaudhuri, Vivek Narasayya, and Ravi Ramamurthy, Estimating Progress of Execution for SQL Queries, in SIGMOD, Association for Computing Machinery, Inc., June 2004
- Sanjay Agrawal, Vivek Narasayya, and Beverly Yang, Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design, in SIGMOD, Association for Computing Machinery, Inc., June 2004
- Surajit Chaudhuri, Arnd Christian König, and Vivek Narasayya, SQLCM: A Contiuous Monitoring Framework for Relational Database Engines, in 20th International Conference on Data Engineering, Institute of Electrical and Electronics Engineers, Inc., March 2004
2003
- Surajit Chaudhuri, Prasanna Ganesan, and Vivek Narasayya, Primitives for Workload Summarization and Implications for SQL , in VLDB, Very Large Data Bases Endowment Inc., September 2003
- Sanjay Agrawal, Surajit Chaudhuri, Abhinandan Das, and Vivek Narasayya, Automating Layout of Relational Databases, in 19th International Conference on Data Engineering, IEEE Computer Society, 2003
2002
- Surajit Chaudhuri, Vivek Narasayya, and Sunita Sarawagi, Efficient Evaluation of Queries with Mining Predicates, in 18th International Conference on Data Engineering, IEEE Computer Society, March 2002
- Surajit Chaudhuri, Vivek Narasayya, and Sunita Sarawagi, Efficient Evaluation of Queries with Mining Predicates, in Proceedings of 18th International Conference on Data Engineering, IEEE Computer Society, 2002
2001
- Surajit Chaudhuri, Gautam Das, and Vivek Narasayya, A Robust, Optimization-Based Approach for Approximate Answering of Aggregate Queries, in SIGMOD, Association for Computing Machinery, Inc., May 2001
- Surajit Chaudhuri, Gautam Das, Mayur Datar, Rajeev Motwani, and Vivek Narasayya, Overcoming Limitations of Sampling for Aggregation Queries, in 17th International Conference on Data Engineering, IEEE Computer Society, April 2001
2000
- Surajit Chaudhuri, Vivek Narasayya, and Sanjay Agrawal, Automated Selection of Materialized Views and Indexes for SQL Databases., in VLDB, Very Large Data Bases Endowment Inc., September 2000
- Surajit Chaudhuri and Vivek Narasayya, Automating Statistics Management for Query Optimizers, in 16th International Conference on Data Engineering, IEEE Computer Society, March 2000
1999
- Surajit Chaudhuri, Rajeev Motwani, and Vivek Narasayya, On Random Sampling over Joins, in SIGMOD, Association for Computing Machinery, Inc., June 1999
- Surajit Chaudhuri and Vivek Narasayya, Index Merging, in 15th International Conference on Data Engineering, IEEE Computer Society, April 1999
Parting 'Shot'
Reality is an illusion caused by caffeine deficiency.
Collaborators
Sanjay Agrawal
Venky Ganti
Vivian Zhang



