I am originally from Chandannagar, a sweet little town approximately 30 kms north of Kolkata. Chandannagar was one of the oldest French colonies in India. It is hugely popular for the "Jagadhatri Puja" festival held one month after the "Durga Puja". Every year thousands of people come to watch the city lit with its world famous lights. Here are some photos from previous years. [images taken randomly from internet]
I did my Bachelor of Engineering in Information Technology from Bengal Engineering and Science University, Shibpur popularly known as "Shibpur B E College". BESU is the 2nd oldest engineering institute in India (after IIT Roorkee).
Currently I am in the final semester of my 21 year long academic life. Phew! My areas of interest span Database Systems, Program Analysis and Computer Networks, though my main concetration is in Database. Presently I am working with Prof. S Sudarshan, co-author of the famous database book Database System Concepts.
In most of the times when I do not study I play FIFA on my 5-years old laptop :) I love Music, of all genres. I like to meet people and make friends. I don't want to brag about it but I played for my local academy in a state level cricket tournament (CAB U-13 Cricket).
My primary concentration is on Application of Program Analysis in Database Applications. Currently working on Hibernate system. Here is a link to the page that describes my project best.
Bengal Engineering and Science University, Shibpur
2011
82
Higher Secondary(+2)
Kanailal Vidyamandir (WBCHSE)
2007
86
Madhyamik(10)
Kanailal Vidyamandir (WBBSE)
2005
87
*Not Final CPI
Where Can You Find Me!
During office hours I am mostly in my lab, SIC 212, KReSIT bldg. Or at least I plan to be there. Otherwise you can look for me in Sysad Room, Old CSE bldg, ground floor. If I am not at either of these places, then I am definitely at B-311, H-14.
Labs and Lectures
I am not taking any courses in the spring semester but I do have some labs to conduct/assist as part of my sysad duties. I might as well sit-through a few courses. I have not yet decided.
Autumn 2013 Calendar
Masters Thesis Project
Currently I am working with Prof. S Sudarshan on the project titled Holistic Optimization of Database Application. The aim of this project is to combine the techniques of Query optimization and Compiler optimization/Program Analysis to improve the perfomrance of applications that use Hibernate Object Relational Mapping tool.
This project has been going on for quite some time now, and we have developped a program analysis/transformation tool called DBridge. This tool analyzes a java program (which uses JDBC APIs), identifies opportunities for optimizations and automatically transform the program to incorporates the optimizations. So, my main task is to expand the applicability of this tool adding necessary support for optimizing programs which does not use JDBC but use ORMs such as Hibernate. More about the project can be found in here.
Other Projects and Seminars
Conditional Dependency Analysis in Database Application
In this project, we (it was done in pair, though most of the work was done by my partner :)) extracted the dependency between the dynamically constructed query and the request parameters of a given servel program. We also identified the correctness of the query thus constructed and the conditions under which it is exectuted. This project is kind of prequel to my MTP.
Query String Analysis for Servlet Programs
This project is an extension of the above project. We extracted the mapping between fields of an object and the query attributes. Eliminated unnecessary attributes from query based on the program's need. For each query parameter, found out which request parameter it is dependent on and under what conditions.
Periodic Materialized View Maintenance in PostgreSQL
Added support for user defined materialized views in PostgreSQL 9.1.2. Used logs of all transactions to automatically update the materialized view after a certain user defined period.
Location and Activity Sensing Using Smartphones | Masters' Seminar
Presented a comparative analysis of recent location sensing technologies used in smartphones to determine accurate geographical location of the user.
Minor Projects
Performance Comparison of Mobile Adhoc Network Protocols (AODV, DSDV, DSR)
Modification of Routing Information Protocol (Shortest route calculation based on link cost, instead of hop-counts)
SQL Injection: Vulnerabilities, Attacks and Defenses, 2nd Order Inject Attacks.