Tourism Database Management System Using Data Warehouse Approach

CHAPTER EIGHT: SUMMARY
8.1    INTRODUCTION
As usual, developing a system requires information gathering, findings which will eventually stand as the pillars for the proposed system development. Having find the required information, then it involves proper planning, analysis, scope, objective, aim and so on of the proposed system. The information gathering is based on the proposed project titled: Tourism Database Management System which will eventually resolve the challenges faced by the tourism sector in the Nigeria. As it was being said earlier tourism has a huge economic benefit to any nation will has it as their priority to develop the sector. Serious research was made on the title and the developer discovered that some few country actually applied the data warehouse concept on system developed to manage their tourism sector, therefore applied this concept for the proposed system will definitely bring a positive turn around for the tourism sector in Nigeria.
A system cannot be developed without some mechanism which will enable the accomplishment of the project. Tools like QSEE, Microsoft word, Microsoft Project, oracle 11g, and many other tools and technology was used in developing the system.
8.2    INFORMATION GATHERING
Information gathering is one of the most paramount aspect of a project development, as the system developer might not be familiar with the system that is to be developed. Information for the proposed system were gathered from meeting organizations that in the involved in tourism, interviewing tourist, reading through online journals, e-books, search engine like google and so on.
Based on the research made at the course of developing the system, it is observed that some country do not have a mechanism of giving such analytical reports gotten in the present developed system. Therefore, the proposed developed system is recommended for any country to give historical data, and necessary report which will help tourism managers to make decision.
The development of the proposed system takes several months, based on the fact that the developer is not conversant with the proposed system. Having gone through the hurdles of developing the proposed system the developer now had a better knowledge on how to develop the system. Therefore, developing and completing the system if required will not consume much time.
8.3    RESULTS
The proposed system was tested in relationship to the aim and objectives, and it is observed that the system fully met the requirement, well functional. A new user is able to register, using his her registered details to login system. Someone who is not a valid user is restricted of having access to into system. Having login successfully gives the user access into the system to view the reports the user is privileged to see. The system is programmed in a way that every user of the system has a particular page to visit.
8.4    FUTURE ENHANCEMENT
Future work required in refining the proposed developed system will be adding more online functionalities like including an API, more security enhancement and user friendly functionalities.
Conclusion
So many existing systems based on the research made support the data warehouse concept which triggered the adoption of the conception in delivering the proposed system. The data warehouse is structured which enables the Structured Query Language (SQL) to run, giving room to generate a desired report for analytical purposes. Based on the research made it is more preferable using the Oracle database in implementing the project. Other databases like Microsoft sql server, MySQL, Postgre Sql and so on will not be able to perform some of the basic functions like creation of charts, calendars, enabling or disabling of a column, online backup and more especially the basic requirement for the data warehouse process-ETL not that alone the oracle database has oracle apex that has graphical user interface (GUI) that makes it user friendly.