Database Connection - Weekly Report

Last week, we distributed the responsibilities of each member using Trac. This week, my duty was to establish the database connection.

Firstly, I compiled some data about some famous landmarks including Anıtkabir, the Sheraton Hotel and the Eiffel Tower. In accordance with the entity relationship diagram we presented in the detailed design report, I populated some tables in the database which had already been created before. Now, the Location table holds GPS and compass information, the Imageinfo table contains information about the images and the images themselves, and Has_location table maps the locations with image infos. The SendPicture servlet is now capable of receiving latitude and longitude info of the image from the client and after querying the database using these values, responding to the client successfully with the image description found.

Tolga AKIN
Department of Computer Engineering
Middle East Technical University