|
Sanjay Agrawal |
|
![[my picture]](sagrawal.jpg)
Projects (Product
and Research)
The Conference Management Service (CMT) 2.0 is a conference management service sponsored by Microsoft Research, and uses the latest Microsoft technologies. It is capable of handling the complex workflow of an academic conference including paper submission, reviewing, bidding and online publishing.
The emphasis is to identify techniques to enhance the user search experience. Supplement search with flexible ways to query and browse data, includes approximate answers and ranking of result sets.
The goal of the project is to make databases self tuning and administering. The tool is currently shipped as a part of the SQL server release.
The objective of the project is to extend the universal “keyword search”. The project mixes the powerful keyword search with browsing capabilities to provide users with a seamless way to navigate data that resides in relational databases, without having to know the underlying schema. Challenges include approximate answers and ranking of result sets to provide an IR like interface to databases.
Product
Contributions
CMT
2.0
I am responsible
for the development of CMT 2.0. My role here includes design, and development
of CMT 2.0. The project involves
planning the software development life cycle, setting milestones for the
deliverables and leading the team to achieve the deliverables in a timely and
responsible manner.
Database tuning technologies in Microsoft SQL Server (SQL Server 2005
and SQL Server 2000).
As part of the
autoadmin research and development team, I was responsible for the following
products that get shipped with SQL Server. I worked with other group members
towards the research, design, and planning of this product across different
releases of SQL Server. I received ship-it awards for the following:
·
Database Tuning Advisor in SQL Server 2005.
·
Index Tuning Wizard in SQL Server 2000.
15+ Patents in
the area of physical database design, ranking of query results and search over
databases.
Research Publications
- Agrawal
S., Chu E., and Narasayya
V. , Automated Physical Design Tuning: Workload as a Sequence. Proceedings
of the ACM SIGMOD, Chicago, USA, 2006.
- Agrawal
S., Chaudhuri S.,
Kollar L., Marathe A., Narasayya
V., and Syamala M.
, Database Tuning Advisor for Microsoft SQL Server 2005. Proceedings of
the 30th International Conference on Very Large Databases (VLDB04),
Toronto, Canada, 2004. pdf
version
- Agrawal
S., Narasayya V.
and Yang B. , Integrating Vertical and Horizontal Partitioning Into
Automated Physical Database Design. ACM Sigmod, Paris, France, 2004.
pdf
version
- Agrawal
S., Chaudhuri S.,
Abhinandan Das, and Narasayya
V., Automating Layout of Relational Databases. Proceedings of 19th
International Conference on Data Engineering, Bangalore, India, 2003. pdf
version
- Agrawal
S., Chaudhuri S.,
Das G. and Aristides
Gionis , Automated Ranking of Database Query Results. CIDR, 2003. pdf
version
- Agrawal
S., Chaudhuri S.
and Das G., DBXplorer: A System For Keyword-Based Search Over
Relational Databases. Proceedings of the 18th Intl.
Conference on Data Engineering (ICDE2002), San Jose, CA, pp. 5-16. [pdf
version]
- Agrawal S., Chaudhuri S., Kollar
L., and Narasayya V.
Index Tuning Wizard for Microsoft SQL Server 2000.White paper
- Agrawal S., Chaudhuri S. and Narasayya V.,
Automated Selection of Materialized Views and Indexes for SQL Databases. Proceedings
of the 26th International Conference on Very Large Databases (VLDB00),
Cairo, Egypt, 2000, pp. 496-505, 2000. [pdf
version]
- Persistent
Client-Server Database Sessions, Proceedings of the EDBT Conference,
Lake Constance, Germany, March 2000 (with Roger Barga, David Lomet, Thomas
Baby). [MS
Word .331 MB]
Professional Activities
- Memberships: IEEE, ACM SIGMOD.
Other Links
- My
Resume in [Word
format]
- Some
Photos
Contact Info:
Microsoft Research,
One Microsoft Way, Microsoft Corp.,
Redmond, WA 98052 USA
Telephone (425) 705 3507 Fax (425) 936 7329 Email
sagrawal@microsoft.com