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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Back, A., Enkel, E. & V. Krogh, G. (2007). Knowledge networks for business, Springer, NY.
Bloom, J.Z. (2004) Tourist market segmentation with linear and non-linear techniques. Tourism Management, 25(6): 723–733.
Bornhorst, T., Ritchie, J.R. & Sheehan, L. (2010). Determinants for DMO & destination success: an empirical examination, Tourism Management, 31(5): 572–589.
Bronner, F. & Hoog, R. (2011). Vacationers and eWOM: who posts, and why, where, and what? Journal of Travel Research, 50(1): 15–26.
Cho, V. & Leung, P. (2002). Knowledge discovery techniques in database marketing for the tourism industry, J. of Quality Assurance in Hospitality & Tourism, 3(3): 109–131.
Chu, F.L. (2004). Forecasting tourism demand: a cubic polynomial approach. Tourism Management, 25(2): 209–218.
Dhawan, B., & Gosain, A. (2009). Extending UML for multidimensional modeling in data warehouse. Int. Journal of Computer & Communication Technology, 2(7): 59–64.
Dell’Erba, M., Fodor, O., Höpken, W., Werthner, H. (2005). Exploiting Semantic Web Technologies for Harmonizing E-Markets. IT & T, 7(3/4): 201–220.
Fuchs, M. & Weiermair, K. (2004). Destination benchmarking - an indicator-system’s potential for exploring guest satisfaction. Journal of Travel Research, 42 (3): 212–225.
Fuchs, M. & Höpken, W. (2009). Data mining in tourism (In German: „Data Mining im Tourismus“), Praxis der Wirtschaftsinformatik, 270(12): 73–81.
Fuchs, M., Chekalina, T. & Lexhagen, M. (2011): Destination Brand Equity Modelling and Measurement—A Summer Tourism Case from Sweden, In: Tsiotsou, R. H. & Goldsmith, R.E (eds.), Strategic Marketing in Tourism Services, Emerald, pp: 95–116.
Garrow, L., Koppelman, F. (2004). Predicting air travelers’ no-show and standby behavior using passenger and directional itinerary information. Journal of Air Transport Management, 10(6): 401–411.
Golfarelli, D. M., & Rizzi, S. (1998). The Dimensional Fact Model: A Conceptual Model for Data Warehouses. Bologna: University of Bologna.
Gräbner, D., Zanker, M., Fliedl, G., Fuchs, M. (2012). Classification of customer reviews based on sentiment analysis. In Fuchs, M., Ricci, F., Cantoni, L. (eds.). Information and Communication Technologies in Tourism, (pp. 460–470). Springer, Wien, New York.
Höpken, W. (2004). Reference Model of an Electronic Tourism Market—Version 1.3. www.rmsig.de/documents/referencemodel.doc.
Höpken, W., Fuchs, M., Keil, D., Lexhagen, M. (2011). The Knowledge Destination—A Customer Information-based Destination Management Information System. In: Law, R., Fuchs, M., Ricci, F. (eds.). Information and Communication Technologies in Tourism, Springer, New York: 417-429.
Inmon, W.H. (2002). Building the data warehouse. Wiley & Sons, New York.
Jiang, N., Gruenwald, L. (2006). Research issues in data stream association rule mining. SIGMOD, 35(1): 14–19.
Kasavana, M.L. & Knutson, B.J (1999). A primer on siftware: warehousing, marting and mining hospitality data for more effective marketing decisions. Journal of Hospitality and Leisure Marketing, 6(1): 83–96.
Kasper, W., Vela, M. (2011). Sentiment analysis for hotel reviews. Computational Linguistics-Applications Conference (pp. 45–52), Katowice, Poland, 10/2011.
Kimball, R. (1997). A dimensional manifesto, DBMS, August: 58–70.
Kimball, R., Ross, M., Thronthwaite, W., Mundy, J., Becker, B. (2008). The data warehouse lifecycle toolkit. 2nd Edition, Indianapolis, Indiana, Wiley.
Law, R (1998) Room occupancy rate forecasting—A neural network approach. International Journal of Contemporary Hospitality Management, 10(6): 234–239.
Lujan-Mora, S., Trujillo, J., & Song, I.-Y. (2006). A UML profile for multidimensional modeling in data warehouses. Data & knowledge engineering, 59(3): 725–769.
Magnini, V., Honeycutt, E. Jr. & Hodge, S. (2003). Data mining for hotel firms: use and limitations. Cornell Hotel and Restaurant Administration Quarterly, 44(Dec.): 94–105.
Min, H., Min., H. & Emam, A (2002). A DM approach to develop the profile of hotel customers, Int. Journal of Contemporary Hospitality Management, 14(6): 274–285.
Morales, D.R., Wang, J. (2008). Passenger name record data mining based cancellation forecasting for revenue management. Innovative Applications of O.R., 202(2): 554–562.
Olmeda, I. & Sheldon, P.J. (2002). Data mining techniques and applications for tourism internet marketing, Journal of Travel & Tourism Marketing, 11(2/3): 1–20.
Pitman, A., Zanker, M., Fuchs, M., Lexhagen, M. (2010). Web usage mining in tourism—a query term analysis and clustering approach. In Gretzel, U., Law, R., Fuchs, M. (eds.). Information and Communication Technologies in Tourism. (pp. 393–403), Springer, NY.
Pyo, S., Uysal, M. & Chang, H. (2002). Knowledge discovery in databases for tourist destinations. Journal of Travel Research, 40(4): 396–403.
Pyo, S. (2005). Knowledge map for tourist destinations. Tourism Management, 26(4): 583–594.
Ritchie, R.J.B. & Ritchie J.R.B. (2002). A Framework for an industry supported destination marketing information system. Tourism Management, 23(5): 439–454.
Shaw, G. & Williams, A. (2009). Knowledge transfer and management in tourism organisations. Tourism Management, 30(3): 325–335.
Smith, B. C., Leimkuhler, J. F., Darrow, R. M. (1992). Yield Management at American Airlines, Interfaces, 22(1): 8–31.
Subramanian, J., Stidham, S., Lautenbacher, C. J. (1999). Airline yield management with overbooking, cancellations, and no-shows. Transportation Science, 33(2): 147–167.
Vlahogianni, E.I., Karlaftis, M.G. (2010). Advanced computational approaches for predicting tourist arrivals, Evans, T. (ed.). Nonlinear Dynamics (pp. 309–324), InTech, Vienna.
Walchhofer, N., Hronsky, M., Pöttler, M., Baumgartner, R., Fröschl, K.A. (2010). Semantic online tourism market monitoring. In Gretzel, U., Law, R., Fuchs, M. (eds.). Information and Communication Technologies in Tourism. (pp. 629–641). Springer, Wien NewYork.
Wallace, M., Maglogiannis, I., Karpouzis, K., Kormentzas, G., Kollias, S. (2004). Intelligent one-stop-shop travel recommendations using an adaptive neural network. Information Technology & Tourism, 6(3): 181–193.
Wang, Y. & Russo, S.M. (2007). Conceptualizing and evaluating the functions of destination marketing systems. Journal of Vacation Marketing, 13(3): 187–203.
Wöber, K.W. (1998). Global statistical sources—TourMIS: an adaptive distributed marketing information system for strategic decision support in national, regional or city tourist offices. Pacific Tourism Review, 2(3): 273–286.
Acknowledgements
This research was financed by KK-Foundation project ‘Engineering the Knowledge Destination’ (no. 20100260; Stockholm, Sweden). The authors would like to thank the managers Lars-Börje Eriksson (Åre Destination AB), Niclas Sjögren-Berg and Anna Wersén (Ski Star Åre), Peter Nilsson and Hans Ericsson (Tott Hotel Åre), and Pernilla Gravenfors (Copperhill Mountain Lodge Åre) for their excellent cooperation.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Höpken, W., Fuchs, M., Höll, G., Keil, D., Lexhagen, M. (2013). Multi-Dimensional Data Modelling for a Tourism Destination Data Warehouse. In: Cantoni, L., Xiang, Z. (eds) Information and Communication Technologies in Tourism 2013. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-36309-2_14
Download citation
DOI: https://doi.org/10.1007/978-3-642-36309-2_14
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-36308-5
Online ISBN: 978-3-642-36309-2
eBook Packages: Business and EconomicsBusiness and Management (R0)