Multi-Dimensional Data Modelling for a Tourism Destination Data Warehouse
Published 1 January 2013
Wolfram Höpken, Matthias Fuchs, Gerhard Höll, Dimitri Keil, Maria Lexhagen
Citations25
Generate an AI Snapshot to get a quick, structured summary of this paper.
Study Snapshot
ObjectiveStudy objective
MethodsResearch methodology
PopulationPopulation studied
Sample sizeSample sizes
OutcomesStudy outcomes here
ResultsStudy results comes here
LimitationsResearch study limitations comes here
A concise AI-generated summary of the paper will appear here once you click Generate AI Snapshot.
TL;DR
The prototypical implementation of the DMIS focussing on the data warehouse and OLAP functionalities for customer feedback processes proved the suitability and effectiveness of the proposed overall architecture.
Abstract
Information and communication technologies (ICTS) play a crucial role to increase the knowledge base of destination stakeholders. Organisational learning and managerial effectiveness can particularly be enhanced by applying methods of business intelligence (BI). Although huge amounts of data are available in tourism destinations these valuable knowledge sources typically remain unused. The described problem is solved by conceptualizing, prototypically implementing and testing a novel destination management information system (DMIS) that applies methods of BI and data warehousing for the leading Swedish ski destination, Åre. As being a central DMIS component, the destination-wide data warehouse (DW), its underlying multi-dimensional data model, the technical architecture, as well as critical implementation issues are discussed. Finally, the prototypical implementation of the DMIS focussing on the data warehouse and OLAP functionalities for customer feedback processes proved the suitability and effectiveness of the proposed overall architecture.
Keywords
Social SciencesBusiness, Management and Accounting
Apress eBooksBuilding a Data Warehouse
2,647 Citations2008Vincent Rainardi
This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking.
The Data Warehouse Lifecycle Toolkit
701 Citations2009Ralph Kimball, Margy Ross +3 more
This second edition of The Data Warehouse Lifecycle Toolkit again sets the standard in data warehousing for the next decade.
Journal of Travel ResearchThe “Pull” of Tourism Destinations: A Means-End Investigation
622 Citations2002David B. Klenosky
Tourism ManagementDeterminants of tourism success for DMOs & destinations: An empirical examination of stakeholders' perspectives
606 Citations2009Tom Bornhorst, J. R. Brent Ritchie +1 more
Journal of Travel ResearchVacationers and eWOM: Who Posts, and Why, Where, and What?
518 Citations2010Fred Bronner, Robert de Hoog
International Journal of Cooperative Information SystemsTHE DIMENSIONAL FACT MODEL: A CONCEPTUAL MODEL FOR DATA WAREHOUSES
471 Citations1998Matteo Golfarelli, Dario Maio +1 more
This paper formalizes a graphical conceptual model for data warehouses, called Dimensional Fact model, and proposes a semi-automated methodology to build it from the pre-existing schemes describing the enterprise relational database.
Tourism ManagementKnowledge transfer and management in tourism organisations: An emerging research agenda
428 Citations2008Gareth Shaw, Allan Williams
Transportation ScienceAirline Yield Management with Overbooking, Cancellations, and No-Shows
345 Citations1999Janakiram Subramanian, Shaler Stidham +1 more
A Markov decision process (dynamic programming) model for airline seat allocation on a single-leg flight with multiple fare classes, which exploits the equivalence to a problem in the optimal control of admission to a queueing system, which has been well studied in the queueing-control literature.
ACM SIGMOD RecordResearch issues in data stream association rule mining
286 Citations2006Nan Jiang, Le Gruenwald
There exist emerging applications of data streams that require association rule mining, such as network traffic monitoring and web click streams analysis, which raises new issues that need to be considered when developing association rulemining techniques for stream data.
Data & Knowledge EngineeringA UML profile for multidimensional modeling in data warehouses
276 Citations2005Sergio Luján‐Mora, Juan Trujillo +1 more
This paper presents an extension of the Unified Modeling Language (UML) using a UML profile defined by a set of stereotypes, constraints and tagged values to elegantly represent main MD properties at the conceptual level and uses the Object Constraint Language (OCL) to specify the constraints attached to the defined stereotypes.
Journal of Travel ResearchDestination Benchmarking: An Indicator-System’s Potential for Exploring Guest Satisfaction
245 Citations2004Matthias Fuchs, Klaus Weiermair
Tourism ManagementA framework for an industry supported destination marketing information system
179 Citations2002Robin Ritchie, J. R. Brent Ritchie
Classification of Customer Reviews based on Sentiment Analysis
133 Citations2012Dietmar Gräbner, Markus Zanker +2 more
The evaluation of the classification on test data shows that the proposed system performs better compared to a predefined baseline: if a customer review is classified as good or bad the classification is correct with a probability of about 90%.
Tourism ManagementKnowledge map for tourist destinations—needs and implications
101 Citations2004Sungsoo Pyo
Tourism ManagementTourist market segmentation with linear and non-linear techniques
100 Citations2003Jonathan Bloom
The predictive ability of the BP neural network model appears to be superior to that of MLR static filter and logistic regression models and suitable for deployment in segmenting tourist markets.
Journal of Travel ResearchKnowledge Discovery in Database for Tourist Destinations
95 Citations2002Sungsoo Pyo, Muzaffer Uysal +1 more
The knowledge discovery in database with data mining is a useful tool for the destination management, and more hospitality enterprises and tourist destinations will adopt it in the future, including operational issues, applications, and data mining.
International Journal of Contemporary Hospitality ManagementRoom occupancy rate forecasting: a neural network approach
86 Citations1998Rob Law
Experimental results indicate that using neural networks to forecast room occupancy rates outperforms multiple regression and naive extrapolation, two commonly used forecasting approaches.
Tourism ManagementForecasting tourism demand: a cubic polynomial approach
85 Citations2003Fong-Lin Chu
Cornell Hotel and Restaurant Administration QuarterlyData mining for hotel firms: Use and limitations
83 Citations2003Vincent P. Magnini
Journal Of Vacation MarketingConceptualizing and evaluating the functions of destination marketing systems
81 Citations2007Youcheng Wang, Shirley Monnette Russo
The analysis of the applications in the four components of DMS seems to suggest that destination marketing systems are still in the preliminary stages of development, showing a hierarchical progression of usage and sophistication.
International Journal of Contemporary Hospitality ManagementA data mining approach to developing the profiles of hotel customers
81 Citations2002Hokey Min, Hyesung Min +1 more
Data mining techniques are proposed to help hotels understand their customers’ preferences and the ways to interact with the customers in order to develop a viable customer retention strategy.
Journal of Air Transport ManagementPredicting air travelers’ no-show and standby behavior using passenger and directional itinerary information
56 Citations2004Laurie A. Garrow, Frank S. Koppelman
This is the first study of airline travelers’ no-show and standby behavior based on passenger and directional outbound/inbound itinerary data and benefits of using passenger data to improve forecasting accuracy and support a broad range of managerial decisions.
Journal of Travel & Tourism MarketingData Mining Techniques and Applications for Tourism Internet Marketing
50 Citations2002Ignacio Olmeda, Pauline J. Sheldon
The potential uses of Data Mining techniques in Tourism Internet Marketing and electronic customer relationship management and the challenges in implementing these and other techniques are addressed.
The knowledge destination — a customer information-based destination management information system
36 Citations2011Wolfram Höpken, Matthias Fuchs +2 more
A knowledge-based destination management information system (DMIS) that supports value creation through enhanced decision making and deduces new insights about the applicability of data mining techniques and related models at tourist destinations depending on the type of tourism data and concrete problem characteristics at hand.
Information Technology & TourismINTELLIGENT ONE-STOP-SHOP TRAVEL RECOMMENDATIONS USING AN ADAPTIVE NEURAL NETWORK AND CLUSTERING OF HISTORY
36 Citations2003Manolis Wallace, Ilias Maglogiannis +3 more
This article explains why existing recommender systems are not adequate to provide for efficient personalization of interaction in the area of travel services, as they cannot support the user in all the phases of travel planning, and proposes a new scheme to overcome the identified difficulties.
Web Usage Mining in Tourism — A Query Term Analysis and Clustering Approach
29 Citations2010Arthur Pitman, Markus Zanker +2 more
By considering a leading Swedish destination gateway, it is demonstrated how query term analysis in combination with session clustering can be utilized to effectively explore the information needs of website users.
HMD Praxis der WirtschaftsinformatikData Mining im Tourismus
17 Citations2009Matthias Fuchs, Wolfram Höpken
Journal of Quality Assurance in Hospitality & TourismTowards Using Knowledge Discovery Techniques in Database Marketing for the Tourism Industry
16 Citations2002Vincent Cho, Paul Leung
The common techniques in data mining, including decision tree classifiers, regression analysis, induction programming logic, and probabilistic rules are introduced, which can help to promote niche markets in tourism.
Reference Model Of An Electronic Tourism Market
16 Citations2000Wolfram Höpken
The reference model presented in this paper provides an open specification of electronic tourism markets based on a uniform language with standardized building blocks as vocabulary and enables the description of specific models in a form understandable for all communication partners and supports the interoperability on different concrete communication levels.
Data Mining im Tourismus : Theoretische Grundlagen und Anwendungen in der Praxis
11 Citations2009Matthias Fuchs, Wolfram Höpken
Semantic Online Tourism Market Monitoring
8 Citations2010Norbert Walchhofer, Milan Hronský +3 more
The paper describes the SEMAMO prototype implementation and exemplifies the functionality and utility of the approach in the domain of e-tourism, with a focus on the type of reports and visualisations the software, albeit not completely finished yet, can already deliver based on real-world data.
Journal of Hospitality & Leisure MarketingA Primer on Siftware
8 Citations1999Michael L. Kasavana, Bonnie J. Knutson
A primer for understanding siftware and for gaining a better appreciation of its potential in hospitality marketing is presented.
International Journal of Computer and Communication TechnologyExtending Uml for Multidimensional Modeling in Data Warehouse
5 Citations2013Bakul Dhawan, Anjana Gosain
An extension of the Unified Modeling Language (UML) using a UML profile for multidimensional databases that represents the main multidimensional properties at the conceptual level such as the many-to-many relationships between facts and dimensions, degenerate dimensions, multiple and alternative path classification hierarchies, and non-strict and complete hierarchies and aggregate fact table.