Balkan GeoTourism Database System

Short description

This project focuses on designing and optimizing a geospatial tourism database system for the Balkan region. The system will store and manage geographically referenced data about tourist destinations such as cities, attractions, natural landmarks, restaurants, hotels, and events. Each entity will include spatial coordinates to enable location-based queries and distance calculations.

The database will support features such as searching for destinations, filtering locations based on user preferences, and generating optimized travel routes across multiple countries. Additionally, the system will store user interactions such as reviews, preferences, and saved routes in order to provide personalized recommendations.

The implementation will use PostgreSQL with PostGIS for spatial data handling. Special focus will be given to indexing strategies and query optimization techniques.

Team members

Bora Alili - 231504 Esra Bekjiri - 231521 Marko Smilevski - 231557 Fisnik Mamuti - 231508

Course

Advanced Databases 2025/2026 Summer

Supervision

Assistant Milan Todorovikj

Content

Phase	Link	Status	Date
P0	AboutProject	completed	20.04.2026
P1	RelationalModel	completed	20.04.2026
P2	DatabaseCreation	started	20.04.2026
P3	QueryOptimization	not started
P4	DatabaseProgramming	not started
P5	optional	not started