-
Tourism Database Management System Using Data Warehouse Approach
-
-
-
Figure 3.9
From the above figure 7 the creation of the trigger enables the user to know the total number of crimes in a region. Whenever the user input data into region table with the creation of the trigger it automatically calculate the number crimes committed in the region.
3.3 ETL (EXTRACTION, TRANSFORMATION AND LOADING)
One important aspect of the data warehouse concept is the ETL. Extraction-Transformation and Loading (ETL) devices are bits of tools like the oracle 11g in charge of the extraction of information from a few sources, their cleaning, customization and insertion into data warehouse. ETL development occurs on the entering data from information sources that must be adjusted and designed before being embedded into the desired, aimed DW. Data Cleaning goes for finding and extracting copy records, identifying conflicting, wrong information, and control wellsprings of mistakes found in information (Hendawi and El-Shishiny, 2016).
The various databases like MySQL, MS SQL Server, Postgre SQL, IBM DB2 and SAP could run sql query on their platform but complex query cannot be executed in most of them. Oracle database like the 11g version has a more unique user friendly interface which allows a more user/system interaction. Using the oracle database allows for the storage of data logically in the form of table-spaces and physically in the form of data files. It also features data dictionary, indexes and clusters which will be helpful in implementing the proposed system (Youssef, 2012).
3.4 CONCLUSION
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.
-
-
-
ABSRACT - [ Total Page(s): 1 ]ABSTRACTTourism as being a great source of revenue in so many countries like Britain, Australia, Malaysia and many other countries. Seeing the viability of the sector in these countries where tourism as served as one of the life wire of the country economy, has stirred other country government to invest vastly in the sector. The tourism sector of the above named countries has served as a source of employment for the citizenry in various capacity.In reflection of the above statement, this thesis ... Continue reading---
CHAPTER SEVEN - [ Total Page(s): 1 ]CHAPTER SEVEN: PRODUCT AND PRODUCT EVALUATION7.1Â Â Â INTRODUCTIONThe expectation of every system developer is to see that the conceptual system is brought to a reality. Therefore, at this phase the system was fully developed. The evaluation of the proposed system was considered in more details in this chapter. This involves the difficulties encountered, the successes in line with the proposed objectives.7.2Â Â Â EVALUATION OF PRODUCTThe evaluation of the product will be based on the objective ... Continue reading---
LIST OF TABLES - [ Total Page(s): 1 ]Lists of TablesTable 5.1Table 5.2Table 5.3Table 5.4Table 5.5Table 5.8.1Table 5.8.2Table 5.8.3Table 5.8.4 ... Continue reading---
LIST OF FIGURES - [ Total Page(s): 1 ]List of figuresFigure 2.1Figure 3.1Figure 3.2Figure 3.3Figure 3.4Figure 3.6Figure 3.7Figure 3.8Â Â Â Figure 3.8Â Â Â Figure 3.9Â Â Â Â Â Â Figure 5.1Â Â Â Â Â Â Â Figure 5.2Â Â Â Â Â Â Â Â Â Figure 5.3Â Â Â Â Â Â Â Â Â Figure 5.4Â Â Â Â Â Â Â Â Â Figure 5.5Â Â Â Â Â Â Â Â Â Figure 5.6Â Â Â Â Â Â Â Â Â Figure 5.7Â Â Â Â Â Â Â Â Â Figure 5.8Â Â Â Â Â Â Â Â Â Figure 6.5.2.1Â Â Â Â Â Â Figure 6.5.2.2Â Â Â Â Â Â Figure 6.5.2.5Â Â Â Figure 6.5.2.6Figure 6.5.2.7Â Â Â ... Continue reading---
TABLE OF CONTENTS - [ Total Page(s): 1 ]Table of contentsCHAPTER ONE: INTRODUCTION   1.1 INTRODUCTION   1.2 AIM.   1.3   OBJECTIVES  1.4   PROBLEM STATEMENT   1.5   SCOPE   CHAPTER TWO: LITERATURE REVIEW   2.1   INTRODUCTION   2.2   BACKGROUND STUDY OF TOURISM DEVELOPMENT IN NIGERIA   2.3   THREE TIER DATA WAREHOUSE   2.3.1   BOTTOM TIER   2.3.2   MIDDLE TIER   2.3.3   TOP TIER.   2.4   THE NEEDS OF DATA WAREHOUSE CONCEPT IN TOURISM   2.4.1 ... Continue reading---
LIST OF ABRIVATIONS - [ Total Page(s): 1 ]List of symbols/AbbreviationsS/NÂ Â Â ABBREVIATIONÂ Â Â MEANINGS1Â Â Â OLAPÂ Â Â Online Analytical Processing2Â Â Â ROLAPÂ Â Â Relational online analytical processing3Â Â Â MOLAPÂ Â Â multidimensional online analytical processing4Â Â Â OLTPÂ Â Â online transaction processing5Â Â Â MOTÂ Â Â Ministry of Tourism Malaysia6Â Â Â SQLÂ Â Â Structured Query Language7Â Â Â CSVÂ Â Â comma-separated values8Â Â Â HTMLÂ Â Â Hypertext Markup Language9Â Â Â PDFÂ Â Â Portable document format ... Continue reading---
CHAPTER EIGHT - [ Total Page(s): 1 ]CHAPTER EIGHT: SUMMARY8.1Â Â Â INTRODUCTIONAs 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 ... Continue reading---
CHAPTER ONE - [ Total Page(s): 1 ]CHAPTER ONE: INTRODUCTION1.1Â Â Â INTRODUCTIONTourism is quickly getting to be a standout amongst the most operative and efficient industries on the globe. It has extraordinary positive effects in countries by making work opportunities, by creating or developing infrastructure, and an extremely rich wellspring of wage and income (IPROJECT, 2016).Tourism enhances a country's infrastructural advancement. It makes for provision, for example, great communication and transport system, low-cost and a ... Continue reading---
CHAPTER TWO - [ Total Page(s): 4 ]2.3.1Â Â Â BOTTOM TIERThe bottom level of the architecture is the data warehouse database server. It is the relational database framework. The back end tools and utilities are used to input data into the bottom level. These back-end tools and utilities carry out the Extract, Clean, Load, and refresh functions.2.3.2Â Â Â MIDDLE TIERIn the middle level, we have the OLAP Server that can be actualized in both of theaccompanying ways: ... Continue reading---
CHAPTER FOUR - [ Total Page(s): 2 ]CHAPTER FOUR: PROPOSED METHODOLOGY4.1Â Â Â SYSTEM METHODOLOGYFor any system to be developed it must undergo some processes or stages to become a complete system. So system methodology is a scheme that is employed to structure, plan and control the way toward building up a functional system (Itinfo.am, 2016).There are numerous methodology used in the development of project, amongst others RAD and Agile methodology will be given more consideration in order for the developer to choose and justify ... Continue reading---
CHAPTER FIVE - [ Total Page(s): 11 ] ... Continue reading---
CHAPTER SIX - [ Total Page(s): 7 ]The above data warehouse was gotten after being through the ETL (Extraction, Transformation, and Loading) process. Four hundred and eighty five values where loaded into the fact table. The report met the proposed aim and objectives.Please refer to appendix G for more interfaces.Please refer to appendix B for more testing6.7Â Â Â CONCLUSIONHaving gone through the testing phase, the basic functionality where met. ... Continue reading---
REFRENCES - [ Total Page(s): 1 ]REFERENCEAhmed, M. (2013). Practical steps for using Amazon EC2 IaaS Technology. An introduction to cloud computing concepts, pp.1-4.Blueink.biz. (2016). blueink.biz - Rapid Application Development - An Application Development Technique Using Prototypes, Iterative Customization, and CASE Tools. [online] Available at: http://www.blueink.biz/RapidApplicationDevelopment.aspx [Accessed 23 Aug. 2016].David, G., Sue, H., Christopher, J., Alex, K., Bryn, L., Kuassi, M., David, P. and Christian, S. (201 ... Continue reading---
-
ABSRACT - [ Total Page(s): 1 ]ABSTRACTTourism as being a great source of revenue in so many countries like Britain, Australia, Malaysia and many other countries. Seeing the viability of the sector in these countries where tourism as served as one of the life wire of the country economy, has stirred other country government to invest vastly in the sector. The tourism sector of the above named countries has served as a source of employment for the citizenry in various capacity.In reflection of the above statement, this thesis ... Continue reading---