MCD Fellowship, University of Texas at Austin, 1988-1990.
S. Mehrotra, H. F. Korth, and A. Silberschatz. Concurrency Control in Hierarchical Multidatabase Systems”. Selected by Program Committee of the VLDB International Conference, 1994 as one of the best papers submitted to the conference. Invited to submit to the VLDB Journal.
Best Paper Award Nomination, J. Kothari, and S. Mehrotra Neighborhoods: A framework for enabling web-based synchronous collaboration and hierarchical Navigation. Proceedings of the 29th Hawaiian International Conference in System Sciences 1996.
CAREER Award, NSF Information and Data Management Program, Information and Intelligent Systems Division, 1998.
C. W. Gear Outstanding Junior Faculty Award based on Research Contributions, Department of Computer Science, University of Illinois at Urbana-Champaign, 1998.
Most cited paper from T-CSVT 1998. Seventh most cited paper in the history of the journal. (over 1500 citations in Google Scholar) Yong Rui, Thomas S. Huang, Michael Ortega, and Sharad Mehrotra, Relevance Feedback: A Power Tool in Interactive Content-Based Image Retrieval, IEEE Trans. on Circuits and Systems for Video Technology , Special Issue on Segmentation, Description, and Retrieval of Video Content, pp. 644-655, Vol. 8, No. 5, Sept, 1998.
Best Paper Award for the paper entitled Locally Adaptive Dimensionality Reduction for Indexing Large Time Series Databases, SIGMOD Conference, 2001. Paper selected from 290 submissions of which 44 were selected for publication. Invited to submit to Transactions on Database Systems.
Best Paper Award for the paper entitled Efficient Execution of Aggregation Queries over Encrypted Databases, DASFAA Conference, 2004.
Outstanding Graduate Student Mentor Award, School of Information & Computer Science, UCI, 2005
Best Student Paper Award, IEEE Workshop on Multimodal Sentient Computing: Sensors, Algorithms and Systems (WMSC 2007) held in conjunction with IEEE CVPR (Computer Vision and Pattern Recognition) 2007
SIGMOD Test of Time Award 2012 for the paper entitled Executing SQL over Encrypted Data in the Database-Service-Provider Model
Best Paper Award for the paper A Unified Framework for Context Assisted Face Clustering.” ACM International Conference on Multimedia Retrieval, 2013.
DASFAA 10 year best paper award, 2013 for the paper entitled: "Efficient Record Linkage in Large Data Sets” that appeared in DASFAA 2003.
DASFAA 10 year best paper award, 2014 for the paper entitled: "Efficient Execution of Aggregation Queries over Encrypted Relational Databases” that appeared in DASFAA 2004.
2014 Mention in OC Register. (http://www.ocregister.com/articles/award-604025-psychoanalytic-irvine.html)
Board of Trustees, VLDB Endowment, 2016 – 2022.
Dean’s award for excellence in Research, School of Computer Science, UCI, 2016
Listed amongst Most Influential Scholar on Aminer (https://aminer.org) , 2016
Dean’s award for Graduate Student Mentoring, School of Computer Science, UCI, 2018
Best Paper Award, in 37th IEEE International Symposium on Reliable Distributed Systems (SRDS) for a paper entitled: "Enabling State Estimation for Fault Identification in Water Distribution Systems under Large Disasters".
Distinguished Poster Award, ACM Codaspy, 2019.
Best Paper Award, IEEE NCA for the paper entitle “"IoT Notary:Sensor Data Attestation in Smart Environments" was awarded Best Paper Award in IEEE NCA 2019
Best Paper Award, in IEEE International Conference on Smart Computing (SMARTCOMP), 2020 for the paper entitled: "REAM: Resource Efficient Adaptive Monitoring of Community Spaces at the Edge Using Reinforcement Learning”. 2020
Fellow of the IEEE, 2021
Fellow of the AAIA, 2021
Chancellor Professor of Computer Science, 2021
Key Architect of the TIPPERS software that won the Naval Information Warfare Systems Command (NAVWAR) Innovation Award, 2021
Best Paper Award IEEE PERCOM 2022 for the paper entitled. SmartSPEC: Customizable Smart Space Datasets via Event-Driven Simulations Andrew Chio, Daokun Jiang, Peeyush Gupta, Georgios Bouloukakis, Roberto Yus, Sharad Mehrotra and Nalini Venkatasubramanian
Fellow of the ACM, 2023