Skip to main content
SpringerLink
Log in
Book cover

Information and Communication Technologies in Tourism 2013 pp 157–169Cite as

Multi-Dimensional Data Modelling for a Tourism Destination Data Warehouse

  • Conference paper
  • First Online:

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.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   169.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   219.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  • Back, A., Enkel, E. & V. Krogh, G. (2007). Knowledge networks for business, Springer, NY.

    Google Scholar 

  • Bloom, J.Z. (2004) Tourist market segmentation with linear and non-linear techniques. Tourism Management, 25(6): 723–733.

    Article  Google Scholar 

  • Bornhorst, T., Ritchie, J.R. & Sheehan, L. (2010). Determinants for DMO & destination success: an empirical examination, Tourism Management, 31(5): 572–589.

    Article  Google Scholar 

  • Bronner, F. & Hoog, R. (2011). Vacationers and eWOM: who posts, and why, where, and what? Journal of Travel Research, 50(1): 15–26.

    Article  Google Scholar 

  • 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.

    Article  Google Scholar 

  • Chu, F.L. (2004). Forecasting tourism demand: a cubic polynomial approach. Tourism Management, 25(2): 209–218.

    Article  Google Scholar 

  • Dhawan, B., & Gosain, A. (2009). Extending UML for multidimensional modeling in data warehouse. Int. Journal of Computer & Communication Technology, 2(7): 59–64.

    Google Scholar 

  • 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.

    Article  Google Scholar 

  • Fuchs, M. & Weiermair, K. (2004). Destination benchmarking - an indicator-system’s potential for exploring guest satisfaction. Journal of Travel Research, 42 (3): 212–225.

    Article  Google Scholar 

  • Fuchs, M. & Höpken, W. (2009). Data mining in tourism (In German: „Data Mining im Tourismus“), Praxis der Wirtschaftsinformatik, 270(12): 73–81.

    Article  Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Article  Google Scholar 

  • Golfarelli, D. M., & Rizzi, S. (1998). The Dimensional Fact Model: A Conceptual Model for Data Warehouses. Bologna: University of Bologna.

    Article  Google Scholar 

  • 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.

    Chapter  Google Scholar 

  • 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.

    Chapter  Google Scholar 

  • Inmon, W.H. (2002). Building the data warehouse. Wiley & Sons, New York.

    Google Scholar 

  • Jiang, N., Gruenwald, L. (2006). Research issues in data stream association rule mining. SIGMOD, 35(1): 14–19.

    Article  Google Scholar 

  • 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.

    Article  Google Scholar 

  • Kasper, W., Vela, M. (2011). Sentiment analysis for hotel reviews. Computational Linguistics-Applications Conference (pp. 45–52), Katowice, Poland, 10/2011.

    Google Scholar 

  • Kimball, R. (1997). A dimensional manifesto, DBMS, August: 58–70.

    Google Scholar 

  • Kimball, R., Ross, M., Thronthwaite, W., Mundy, J., Becker, B. (2008). The data warehouse lifecycle toolkit. 2nd Edition, Indianapolis, Indiana, Wiley.

    Google Scholar 

  • Law, R (1998) Room occupancy rate forecasting—A neural network approach. International Journal of Contemporary Hospitality Management, 10(6): 234–239.

    Article  Google Scholar 

  • 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.

    Article  Google Scholar 

  • 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.

    Article  Google Scholar 

  • 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.

    Article  Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Article  Google Scholar 

  • 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.

    Chapter  Google Scholar 

  • Pyo, S., Uysal, M. & Chang, H. (2002). Knowledge discovery in databases for tourist destinations. Journal of Travel Research, 40(4): 396–403.

    Article  Google Scholar 

  • Pyo, S. (2005). Knowledge map for tourist destinations. Tourism Management, 26(4): 583–594.

    Article  Google Scholar 

  • 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.

    Article  Google Scholar 

  • Shaw, G. & Williams, A. (2009). Knowledge transfer and management in tourism organisations. Tourism Management, 30(3): 325–335.

    Article  Google Scholar 

  • Smith, B. C., Leimkuhler, J. F., Darrow, R. M. (1992). Yield Management at American Airlines, Interfaces, 22(1): 8–31.

    Google Scholar 

  • Subramanian, J., Stidham, S., Lautenbacher, C. J. (1999). Airline yield management with overbooking, cancellations, and no-shows. Transportation Science, 33(2): 147–167.

    Article  Google Scholar 

  • Vlahogianni, E.I., Karlaftis, M.G. (2010). Advanced computational approaches for predicting tourist arrivals, Evans, T. (ed.). Nonlinear Dynamics (pp. 309–324), InTech, Vienna.

    Google Scholar 

  • 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.

    Chapter  Google Scholar 

  • 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.

    Article  Google Scholar 

  • Wang, Y. & Russo, S.M. (2007). Conceptualizing and evaluating the functions of destination marketing systems. Journal of Vacation Marketing, 13(3): 187–203.

    Article  Google Scholar 

  • 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.

    Google Scholar 

Download references

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

  1. European Tourism Research Institute (ETOUR), Mid-Sweden University, Sundsvall, Sweden

    Wolfram Höpken, Matthias Fuchs, Dimitri Keil & Maria Lexhagen

  2. Business Informatics Group, University of Applied Sciences Ravensburg-Weingarten, Weingarten, Germany

    Wolfram Höpken & Gerhard Höll

Authors
  1. Wolfram Höpken
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Matthias Fuchs
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Gerhard Höll
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Dimitri Keil
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Maria Lexhagen
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Wolfram Höpken .

Editor information

Editors and Affiliations

  1. , Faculty of Communication Sciences, Università della Svizzera italiana, Via Giuseppe Buffi 13, Lugano, 6904, Switzerland

    Lorenzo Cantoni

  2. , College of Merchandising,, University of North Texas, Union Circle 1155, Denton, 76203-1100, Texas, USA

    Zheng (Phil) Xiang

Rights and permissions

Reprints 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

Publish with us

Policies and ethics

Search

Navigation