Tourism Database Management System Using Data Warehouse Approach

  ABSTRACT

Tourism 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 will be centric on the proposal for developing a tourism database management system using warehouse approach for the Nigeria government. The system will be developed basically to give reports related to the tourism sector.

Table of contents

CHAPTER ONE: INTRODUCTION12

1.1 INTRODUCTION12

1.2 AIM13

1.3 OBJECTIVES13

1.4 PROBLEM STATEMENT14

1.5 SCOPE14

CHAPTER TWO: LITERATURE REVIEW15

2.1 INTRODUCTION15

2.2 BACKGROUND STUDY OF TOURISM DEVELOPMENT IN NIGERIA16

2.3 THREE TIER DATA WAREHOUSE17

2.3.1 BOTTOM TIER18

2.3.2 MIDDLE TIER18

2.3.3 TOP TIER19

2.4 THE NEEDS OF DATA WAREHOUSE CONCEPT IN TOURISM19

2.4.1 CHARACTERISTICS OF DATA WAREHOUSE19

2.4.1.1 SUBJECT ORIENTED WITH19

2.4.1.2 UNIFIED:19

2.4.1.3 TIME VARIATION20

2.4.1.4 NONVOLATILE:20

2.5 CLOUD COMPUTING20

2.6 BIG DATA COMPUTING21

2.7 DATA WAREHOUSE IN EGYPTIAN TOURISM22

2.7.1 ANALYSIS OF DATA SOURCES22

2.8 DATA WAREHOUSE IN CHINA TOURISM23

2.9 DATA WAREHOUSE IN ROMANIAN TOURISM24

CHAPTER THREE: REVIEW OF TECHNOLOGIES26

3.1 INTRODUCTION26

3.2 Oracle Database 11g26

3.2.1 ORACLE APPLICATION EXPRESS27

3.2.2 INTERACTIVE REPORT29

3.2.3 FLASH CHARTS31

3.2.4 DYNAMIC ACTION32

3.2.5 TRIGGER32

3.3 ETL (EXTRACTION, TRANSFORMATION AND LOADING)33

3.4 CONCLUSION34

CHAPTER FOUR: PROPOSED METHODOLOGY35

4.1 SYSTEM METHODOLOGY35

4.1.1 REQUIREMENTS PLANNING PHASE36

4.1.1.1 PROPOSED SYSTEM REQUIREMENTS37

4.1.2 USER DESIGN PHASE38

4.1.3 CONSTRUCTION PHASE38

4.1.4 IMPLEMENTATION PHASE38

CHAPTER FIVE:  PRODUCT DESIGN39

5.1 INTRODUCTION39

5.2 ENTITY RELATIONSHIP DIAGRAM (ERD)39

5.3 USE CASE DIAGRAM40

5.3 STAR SCHEMA41

5.4. DATA FLOW DIAGRAM (level 1 diagram)42

5.4.1. STAFF DATAFLOW DIAGRAM42

5.4.2 TRAVELER DATA FLOW DIAGRAM43

5.4.3 ADMIN DATAFLOW DIAGRAM44

5.5 CONTEXT DIAGRAM45

5.6 ACTIVITY DIAGRAM FOR TRAVELER, STAFF AND ADMIN46

5.7 DATA DICTIONARY FOR ENTITY RELATIONSHIP DIAGRAM47

5.8 STAR SCHEMA DATA DICTIONARY50

CHAPTER SIX:  PRODUCT IMPLEMENTATION AND TESTING52

6.1 INTRODUCTION52

6.2 THE CONSTRUCTIVE PHASE OF THE PROPOSED SYSTEM52

6.3 REQUIRED PLAN FOR THE PROPOSED SYSTEM52

6.4 THE SYSTEM DEVELOPMENT ENVIROMENT52

6.4.1 HARDWARE52

6.4.2 SOFTWARE REQUIRED FOR THE PROPOSED SYSTEM DEVELOPMENT53

6.5 IMPLEMENTATION OF THE PRODUCT54

6.5.1 PROPOSED SYSTEM INTERFACE54

6.5.2 The login page55

6.5.3 Valid user login page55

6.5.4 Home page56

6.5.5 Graphical analysis on traveler56

6.5.6 Graphical analysis on transportation57

6.5.7 Graphical analysis on location57

6.5.8 Graphical analysis on accommodation58

6.5.9 Historical data (data warehouse)58

6.6 Testing of product59

6.7 CONCLUSION59

CHAPTER SEVEN: PRODUCT AND PRODUCT EVALUATION60

7.1 INTRODUCTION60

7.2 EVALUATION OF PRODUCT60

CHAPTER EIGHT: SUMMARY61

8.1 INTRODUCTION61

8.2 INFORMATION GATHERING61

8.3 RESULTS62

8.4 FUTURE ENHANCEMENT62

REFERENCE62

Lists of Tables

Table 5.1

Table 5.2

Table 5.3

Table 5.4

Table 5.5

Table 5.8.1

Table 5.8.2

Table 5.8.3

Table 5.8.4

List of figures

Figure 2.1----------------------------------------------------------------------------------18

Figure 3.1----------------------------------------------------------------------------------26

Figure 3.2----------------------------------------------------------------------------------27

Figure 3.3----------------------------------------------------------------------------------29

Figure 3.4----------------------------------------------------------------------------------30

Figure 3.6----------------------------------------------------------------------------------30

Figure 3.7-------------------------------------------------------------------------------------------31

Figure 3.8-------------------------------------------------------------------------------------------31

Figure 3.8-------------------------------------------------------------------------------------------32

Figure 3.9 ----------------------------------------------------------------------------------33

Figure 5.1-----------------------------------------------------------------------------------39

Figure 5.2-----------------------------------------------------------------------------------40

Figure 5.3-----------------------------------------------------------------------------------41

Figure 5.4-----------------------------------------------------------------------------------42

Figure 5.5-----------------------------------------------------------------------------------43

Figure 5.6-----------------------------------------------------------------------------------44

Figure 5.7-----------------------------------------------------------------------------------45

Figure 5.8-----------------------------------------------------------------------------------46

Figure 6.5.2.1------------------------------------------------------------------------------55

Figure 6.5.2.2------------------------------------------------------------------------------56

Figure 6.5.2.5------------------------------------------------------------------------------57

Figure 6.5.2.6-----------------------------------------------------------------------------58

Figure 6.5.2.7-----------------------------------------------------------------------------58

List of symbols/Abbreviations

S/N

ABBREVIATIONS

MEANING

1

OLAP

Online Analytical Processing

2

ROLAP

Relational online analytical processing

3

MOLAP

multidimensional online analytical processing

4

OLTP

online transaction processing

5

MOT

Ministry of Tourism Malaysia

6

SQL

Structured Query Language

7

CSV

comma-separated values

8

HTML

Hypertext Markup Language

9

PDF

Portable document format

10

RTF

Rich Text Format