|
Sanjay Agrawal Resume: [Word format]
|
|
![[my picture]](sagrawal.jpg)
Projects (Product
and Research)
·
Conference Management
Toolkit 2.0(CMT) (Aug 2006 – present)
http://cmt.research.microsoft.com/cmt/
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. Since 2006, I have been
primarily responsible for design and managing development of CMT. 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.
·
Richer
Search techniques on MSN live (Aug 2006 – present)
http://research.microsoft.com/dmx/Data_Exploration
The
emphasis is to identify techniques to enhance the user search experience. As
part of the project I have worked on techniques to perform efficient entity
extraction on documents, and how it can be leveraged to provide users with much
richer search experience.
·
Autoadmin
(Feb 1999 –Aug 2006)
http://www.research.microsoft.com/dmx/autoadmin
The
goal of the project is to make databases self tuning and administering. As part
of this project I have worked on Database physical design tuning technologies
in Microsoft SQL Server (SQL Server 2005 and SQL Server 2000). I worked with
other group members towards the research, design, and planning of this product
across different releases of SQL Server.
v Database Tuning Advisor
(DTA)
DTA is currently shipped as a
part of the SQL server 2005 and 2008 release. As part of 2005 release of this
tool, in addition to the core development of the tool, I worked on algorithms
including integration of horizontal partitioning as part of physical design
selection. I developed techniques to enable scaling of the tool to large
workloads and complex databases.
v Index Tuning Wizard (ITW)
ITW is part
of SQL server 7.0 and 2000 release. ITW was the first tool in the industry to
provide automatic index and indexed view recommendations for relational
databases while leveraging history of database usage. I worked on design and
development of core techniques that we used to integrate index and indexed view
selection.
·
DBXplorer:
Extending keyword search to databases (Apr 2000 – Dec 2003)
http://research.microsoft.com/dmx/Data_Exploration
The
objective of the project is to extend the universal “keyword search” paradigm
to databases. The project mixes the powerful keyword search with navigational
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.
Research Publications
- Agrawal
S., Chakrabarti K., Chaudhuri S., and Ganti V. , Scalable
Ad-hoc Entity Extraction from Text Collections. Proceedings of the 34th
International Conference on Very Large Databases, Auckland, New Zealand,
2008.
- 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]
20 Patents in the area of physical database design,
ranking of query results and search over databases.
Professional Activities
- Memberships: IEEE, ACM SIGMOD.
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