Publications

For online copies, please visit my page on DBLP, ACM Digital Library or Google Scholar (also gives citation counts).

Books (Edited Conference Proceedings)

1. Prasan Roy and Aparna S. Varde (eds.): Proceedings of the Second Ph.D. Workshop in CIKM (PIKM 2008), Napa Valley, California, USA, ACM 2008
2. Laks V.S. Lakshmanan, Prasan Roy, and Anthony K.H. Tung (eds.), Proceedings of the 13th International Conference on Management of Data (COMAD 2006), Tata McGraw-Hill, 2007

Book Chapters

3. Prasan Roy and S. Sudarshan, Multi-Query Optimization, Invited chapter, Encyclopedia of Database Systems, Özsu, M. Tamer; Liu, Ling (Eds.) 2009

Refereed Journal Publications

4. Mukesh K. Mohania, Manish Bhide, Prasan Roy, Venkatesan T. Chakaravarthy, and Himanshu Gupta: Context Oriented Information Integration. T. Large-Scale Data and Knowledge-Centered Systems 1: 289-326 (2009)
5. P. Mittal, M. Kumar, M. Mohania, M. Nair, N. Batra, P. Roy, A. Saronwala, and L. Yagnik, A Framework for e-Governance Solutions, Invited paper, IBM Systems
Journal (Special Issue on IBM Research in Asia), Vol. 48, No. 5/6, 2004
6. Nilesh Dalvi, Sumit Sanghai, Prasan Roy and S. Sudarshan, Pipelining in Multi-Query Optimization, Invited paper, Journal of Computing and Systems Sciences (special issue on 2001 ACM Symposium on Principles of Database Systems (PODS)), Vol. 66, No. 4, 2003
7. Prasan Roy, S. Seshadri, Avi Silberschatz, S. Sudarshan and S. Ashwin, Garbage Collection in Object Oriented Databases Using Transactional Cyclic Reference Counting, Invited paper, VLDB Journal (special issue on the 23rd International Conference on Very Large Data Bases), Vol. 7, No. 3, 1998

Refereed Conference Publications (Research)

8. Manish Bhide, Venkatesan T. Chakaravarthy, Krithi Ramamritham, Prasan Roy: Keyword Search over Dynamic Categorized Information. ICDE 2009: 258-269
9. Venkatesan T. Chakaravarthy, Himanshu Gupta, Prasan Roy, Mukesh K. Mohania: Efficient techniques for document sanitization. CIKM 2008: 843-852
10. Prasan Roy, Mukesh K. Mohania: SCORE: Symbiotic Context Oriented Information Retrieval. Invited Paper, APWeb/WAIM 2007: 30-38
11. V. Chakaravarthy, H. Gupta, P. Roy and M. Mohania, Efficiently Linking Text Documents with Relevant Structured Information, Intl Conference on Very Large Data Bases (VLDB), Seoul, Korea, September 2006
12. Prasan Roy, Mukesh Mohania, Bhuvan Bamba and Shree Raman, Towards Automatic Association of Relevant Unstructured Content with Structured Query Results, ACM Conference on Information and Knowledge Management (CIKM), Bremen, Germany, October 2005 Won the Best Interdisciplinary Paper Award
13. Bhuvan Bamba, Prasan Roy and Mukesh Mohania, OSQR: Overlapping Clustering of Query Results, ACM Conference on Information and Knowledge Management (CIKM), Bremen, Germany, October 2005 (Poster)
14. Shariq Rizvi, Alberto O. Mendelzon, S. Sudarshan and Prasan Roy, Extending Query Rewriting Techniques for Fine-Grained Access Control, ACM SIGMOD Conference on Management of Data, Paris, France, June 2004
15. Maya Ramanath, Juliana Freire, Jayant R. Haritsa and Prasan Roy, Searching for Efficient XML-to-Relational Mappings, First International XML Database Symposium, XSym 2003
16. Juliana Freire, Jayant Haritsa, Maya Ramanath, Prasan Roy and Jerome Simeon, StatiX: Making XML Count, ACM SIGMOD Conference on Management of Data, Madison, WI, June 2002
17. Phil Bohannon, Juliana Freire, Prasan Roy and Jerome Simeon, From XML Schema to Relations: A Cost-Based Approach to XML Storage, IEEE Intl Conference on Data Engineering (ICDE), San Jose, CA, March 2002
18. Nilesh Dalvi, Sumit Sanghai, Prasan Roy and S. Sudarshan, Pipelining in Multi-Query Optimization, ACM Symposium on Principles of Database Systems (PODS), Santa Barbara, CA, May 2001 Ranked as one of the top five papers in conference.
19. Hoshi Mistry, Prasan Roy, K. Ramamritham and S. Sudarshan, Materialized View Selection and Maintenance using Multi-Query Optimization, ACM SIGMOD Conference on Management of Data, Santa Barbara, CA, May 2001
20. Prasan Roy, S. Seshadri, S. Sudarshan and Siddhesh Bhobe, Efficient and Extensible Algorithms for Multi-Query Optimization, ACM SIGMOD Conference on Management of Data, Dallas, TX, May 2000
21. S. Ashwin, Prasan Roy, S. Seshadri, Avi Silberschatz and S. Sudarshan, Garbage Collection in Object Oriented Databases Using Transactional Cyclic Reference Counting, Intl Conference on Very Large Data Bases (VLDB), Athens, Greece, August 1997. Ranked as one of the top five papers in the conference.

Refereed Conference Publications (Industrial)

22. Manish Bhide, Ajay Gupta, Rahul Gupta, Prasan Roy, Mukesh K. Mohania, Zenita Ichhaporia: LIPTUS: associating structured and unstructured information in a banking environment. SIGMOD Conference 2007: 915-924
23. L. Mignet, J. Basak, M. Bhide, P. Roy, S. Roy, V. S. Sengar, R. R. Vatsavai, M. Reitcher, T. Steinbach, D. V. S. Ravikant and S. Vadapalli, DB2 Performance Expert - A generic analysis framework, Intl Conference on Extending Database Technology (EDBT), Munich, Germany, March 2006

Demonstrations

24. Manish Bhide, V. Chakravarthy, Ajay Gupta, Himanshu Gupta, Mukesh K. Mohania, Kriti Puniyani, Prasan Roy, Sourashis Roy, Vibhuti S. Sengar: Enhanced Business Intelligence using EROCS. ICDE 2008: 1616-1619
25. P. Bohannon, J. Freire, J. R. Haritsa, M. Ramanath, P. Roy, J. Siméon, Bridging the XML Relational Divide with LegoDB. IEEE Intl Conference on Data Engineering (ICDE), Bangalore, India, March 2003
26. P. Bohannon, J. Freire, J. R. Haritsa, M. Ramanath, P. Roy, J. Siméon, LegoDB: Customizing Relational Storage for XML Documents, Intl Conference on Very Large Data Bases (VLDB), Hong Kong, China , August 2002

Technical Reports

27. Prasan Roy, K. Ramamritham, S. Seshadri, Pradeep Shenoy and S. Sudarshan, Don't Trash your Intermediate Results, Cache 'em, Technical Report, Dept. of Computer Science and Engineering, IIT-Bombay, 2000

Thesis

28. Prasan Roy, Multi-Query Optimization and Applications, Ph.D. Thesis, Dept. of Computer Science and Engineering, IIT-Bombay, December 2000
29. Prasan Roy, Optimization of DAG-structured Query Evaluation Plans, M.Tech. Thesis, Dept. of Computer Science and Engineering, IIT-Bombay, January 1998