-
Tourism Database Management System Using Data Warehouse Approach
-
-
-
CHAPTER THREE: REVIEW OF TECHNOLOGIES
3.1 INTRODUCTION
There are numerous databases which are considered for execution of projects like MySQL, SQL server, Oracle, PostgreSQL and so on. The indicated databases have some similarities in functionality. But in this chapter 3, oracle database will be given more consideration based on its uniqueness. It is obvious that the below figure 1, oracle database is more likely used by developers and organizations in implementing projects (Mysql.com, 2016).
In present day world, the current Information Technology (IT) Company is confronted with a huge number of application development languages and tools to decide on in developing any project. In some instances an organization could have different application development items which are being utilized. Establishments that have developed through mergers and acquisitions are confronted with the troublesome issue of overseeing and coordinating a huge gathering of contending application advancement advances that were utilized as a part of ancestor establishment. Innovation empowers business advancement and those establishments that can rapidly convey applications increase upper hand (David et al., 2010).
Software engineers have a decision of languages for making Oracle database-driven applications including Java, Oracle Application Express, C, C++, COBOL, PL/SQL, Visual Basic, C#, PHP, Ruby, Python and Perl. Engineers can pick the language in which they are most proficient or one that is most appropriate for a particular assignment. For instance an application may utilize Java in middle level to make dynamic Web pages, PL/SQL or Java to execute put away techniques in the database, and C++ or Java to actualize computationally serious rationale in the middle level. Oracle Database 11g offers clients the power and satisfaction of the business' driving database conveyed over a wide assortment of the most mainstream application improvement technology (David et al., 2010).
-
-
-
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---