About: Balkan GeoTourism Database System
Team members
- Bora Alili - 231504
- Esra Bekjiri - 231521
- Marko Smilevski - 231557
- Fisnik Mamuti - 231508
Short description
This project aims to design and optimize a geospatial tourism database system focused on tourist destinations in the Balkan region. The goal of the system is to organize and manage geographically referenced tourism data and support personalized route generation for visitors exploring multiple locations across Balkan countries.
The database will store information about tourism-related entities such as countries, cities, attractions, natural landmarks, restaurants, hotels, and events. Each location will include geographic coordinates that allow spatial queries and distance calculations. Additionally, the system will store user preferences, reviews, and travel routes in order to support personalized recommendations and route planning.
Detailed description
The project involves designing an Entity-Relationship model and implementing a relational schema using a spatially enabled database system such as PostgreSQL with PostGIS. Special attention will be given to spatial data modeling, indexing strategies, and query optimization techniques that improve the performance of location-based searches and route generation.
The system will allow users to search for attractions, filter destinations based on interests or distance, and generate optimized travel routes between multiple locations. Additionally, the project will analyze the performance of different indexing and query strategies to demonstrate how database optimization techniques improve efficiency and scalability.
The system also includes functionality for managing transportation and bookings, such as flight and bus reservations, as well as hotel accommodations. Additionally, role-based access control is implemented to differentiate between different types of users within the system. These features extend the system beyond simple tourism data storage into a more complete travel management platform.
Who is the system intended for?
The system is intended for tourism platforms or companies that provide travel planning services. These organizations would own and maintain the database in order to offer structured and optimized tourism data to users.
What problems does it solve?
It solves the problem of fragmented tourism data and inefficient route planning by centralizing geographically structured information and enabling fast and optimized queries.
Types of users
- Tourists (end users searching and planning trips)
- Administrators (managing data)
- Business owners (hotels, restaurants, event organizers)
How is it different from existing solutions?
Unlike many existing tourism systems, this project emphasizes geospatial optimization, efficient querying, and personalized route generation using advanced database techniques.
Application type
The system is designed as a web-based application, with possible extension to mobile platforms.
