[Paper Review] Destination Information Management System for Tourist

Shafi’i Muhammad Abdulhamid, Gana Usman|arXiv (Cornell University)|Feb 6, 2014

Educational Games and Gamification7 references3 citations

TL;DR

This paper proposes a Destination Information Management System (DIMS) for tourists in Niger State, Nigeria, using Java Applet, HTML, PHP, JavaScript, and MySQL to integrate front-end and back-end components. The system enables efficient tourist information retrieval and navigation, with testing across two MySQL servers confirming its functional effectiveness and scalability for real-world deployment in tourism sites.

ABSTRACT

The use of information and communication technology in our day to day activities is now unavoidable. In tourism developments, destination information and management systems are used to guide visitors and provide information to both visitors and management of the tour sites. In this paper, information and navigation system was designed for tourists, taking some Niger state of Nigeria tourism destinations into account. The information management system was designed using Java Applet (NetBeans IDE 6.1), Hypertext MarkUp Language (HTML), Personal Home Page (PHP), Java script and MySQL as the back-end integration database. Two different MySQL servers were used, the MySQL query browser and the WAMP5 server to compare the effectiveness of the system developed.

Motivation & Objective

• To address the lack of centralized, accessible, and interactive tourist information systems in Niger State, Nigeria.
• To design a web-based system that integrates real-time information and navigation for tourists visiting key heritage and cultural sites.
• To evaluate system performance and reliability using dual MySQL server configurations (WAMP5 and MySQL Query Browser).
• To enhance tourist experience through structured, searchable, and user-friendly access to destination data.
• To provide a scalable, low-cost IT solution for tourism site management in developing regions with limited digital infrastructure.

Proposed method

• The system was developed using NetBeans IDE 6.1 for Java Applet integration and HTML for front-end presentation.
• Server-side logic was implemented using PHP, with dynamic content generation and form handling.
• Client-side interactivity was enabled through JavaScript for real-time validation and responsive UI elements.
• A relational database model was designed using MySQL, with data stored across two separate servers for comparative performance evaluation.
• The system architecture follows a three-tier model: presentation (HTML/JavaScript), business logic (PHP), and data storage (MySQL).
• Data integration and system testing were performed using the WAMP5 and MySQL Query Browser environments to assess stability and query efficiency.

Experimental results

Research questions

• RQ1 How can a centralized, web-based information system improve tourist access to destination data in underdeveloped tourism regions?
• RQ2 What is the performance difference between using WAMP5 and MySQL Query Browser as backend servers for a tourist information system?
• RQ3 To what extent can a low-cost, open-source technology stack support reliable and scalable tourist information management?
• RQ4 How effective is the integration of multiple web technologies (HTML, PHP, JavaScript, MySQL) in delivering a functional and responsive tourist information system?
• RQ5 Can such a system reduce information asymmetry and improve visitor satisfaction at cultural and historical sites in Niger State?

Key findings

• The system successfully integrated all required components—HTML, PHP, JavaScript, and MySQL—into a functional, interactive interface for tourist information access.
• Performance testing showed that the WAMP5 server environment provided faster query response times and better stability compared to the MySQL Query Browser.
• The dual-server comparison confirmed the system's scalability and adaptability to different deployment environments.
• User testing indicated improved navigation efficiency and reduced time to access key tourist site details.
• The system demonstrated robustness and maintainability, supporting future expansion to additional tourist sites in Niger State.
• The use of open-source technologies significantly reduced development and deployment costs, making the system viable for resource-constrained regions.