DEVELOPING A PRICE MANAGEMENT DECISION SUPPORT SYSTEM FOR HOTEL BROKERS USING FREE AND OPEN SOURCE TOOLS

Slava Kisilevich, Daniel Keim, Roman Byshko, Michael Tsibelman, Lior Rokach

2011

Abstract

In the Internet age, e-commerce provides customers global reach to a wide variety of products and plays a dominant role in business activity and competition. Competition is especially aggressive in the online travel domain where wholesalers, e.g. brokerage companies, contract through their contract managers with thousands of hotel brands and trade hotel products (usually hotel nights) for travel businesses or end customers. In order to conclude a profitable contract, a contract manager should be able to compare all the particulars of the prospective partner hotel with those of the competing hotels in the target city. Given that the number of contract managers is comparatively small compared to the large number of hotels, the possible knowledge base is limited. Thus, the hotel brokerage companies are only able to bargain with a relatively limited number of hotels, and the contract profitability relies heavily on the contract managers’ expertise and communication skills. In this paper we present a price management decision support system (DSS) for hotel brokers that allows analysis of hotel prices using spatial and non-spatial characteristics, estimation of the objective relative hotel prices, and determination of the profitability of the existing or future contracts. We built our system using free and open source tools including geographic information system and data mining frameworks that allow companies with limited money resources or manpower to implement such a prototype. We show the effectiveness of our tool by covering all the major components of the DSS such as data selection and integration, model management and user interface. We demonstrate our tool on the area of Barcelona, Spain using a real data of 168 hotels provided by one of the travel service providers.

References

  1. Arnott, D. and Pervan, G. (2005). A critical analysis of decision support systems research. Journal of Information Technology, 20(2):67-87.
  2. Arnott, D. and Pervan, G. (2005). A critical analysis of decision support systems research. Journal of Information Technology, 20(2):67-87.
  3. Brusilovsky, D. and Brusilovskiy, E. (2008). White paper: Data mining: The means to competitive advantage. http://www.connectis.ca/download/bis/ bis_data_mining_whitepaper.pdf.
  4. Brusilovsky, D. and Brusilovskiy, E. (2008). White paper: Data mining: The means to competitive advantage. http://www.connectis.ca/download/bis/ bis_data_mining_whitepaper.pdf.
  5. Chen, C. and Rothschild, R. (2010). An application of hedonic pricing analysis to the case of hotel rooms in Taipei. Tourism Economics, 16(3):685-694.
  6. Chen, C. and Rothschild, R. (2010). An application of hedonic pricing analysis to the case of hotel rooms in Taipei. Tourism Economics, 16(3):685-694.
  7. Chiang, W., Chen, J., and Xu, X. (2007). An overview of research on revenue management: current issues and future research. International Journal of Revenue Management, 1(1):97-128.
  8. Chiang, W., Chen, J., and Xu, X. (2007). An overview of research on revenue management: current issues and future research. International Journal of Revenue Management, 1(1):97-128.
  9. Crossland, M., Wynne, B., and Perkins, W. (1995). Spatial decision support systems: An overview of technology and a test of efficacy. Decision Support Systems, 14(3):219-235.
  10. Crossland, M., Wynne, B., and Perkins, W. (1995). Spatial decision support systems: An overview of technology and a test of efficacy. Decision Support Systems, 14(3):219-235.
  11. Densham, P. (1991). Spatial decision support systems. Geographical information systems: Principles and applications, 1:403-412.
  12. Densham, P. (1991). Spatial decision support systems. Geographical information systems: Principles and applications, 1:403-412.
  13. Haklay, M. and Weber, P. (2008). OpenStreetMap: usergenerated street maps. IEEE Pervasive Computing, pages 12-18.
  14. Haklay, M. and Weber, P. (2008). OpenStreetMap: usergenerated street maps. IEEE Pervasive Computing, pages 12-18.
  15. Hall, M., Frank, E., Holmes, G., Pfahringer, B., Reutemann, P., and Witten, I. (2009). The WEKA data mining software: An update. ACM SIGKDD Explorations Newsletter, 11(1):10-18.
  16. Hall, M., Frank, E., Holmes, G., Pfahringer, B., Reutemann, P., and Witten, I. (2009). The WEKA data mining software: An update. ACM SIGKDD Explorations Newsletter, 11(1):10-18.
  17. Hand, D. (1998). Data mining: statistics and more? The American Statistician, 52(2).
  18. Hand, D. (1998). Data mining: statistics and more? The American Statistician, 52(2).
  19. Hung, W., Shang, J., and Wang, F. (2010). Pricing determinants in the hotel industry: Quantile regression analysis. Hospitality Management, 29(3):378-384.
  20. Hung, W., Shang, J., and Wang, F. (2010). Pricing determinants in the hotel industry: Quantile regression analysis. Hospitality Management, 29(3):378-384.
  21. Karacapilidis, N. (2006). An overview of future challenges of decision support technologies. Intelligent Decisionmaking Support Systems, pages 385-399.
  22. Karacapilidis, N. (2006). An overview of future challenges of decision support technologies. Intelligent Decisionmaking Support Systems, pages 385-399.
  23. Kruskal, J. and Wish, M. (1978). Multidimensional scaling. Sage Publications, Inc.
  24. Kruskal, J. and Wish, M. (1978). Multidimensional scaling. Sage Publications, Inc.
  25. Lee, S. and Jang, S. (2010). Room Rates of US Airport Hotels: Examining the Dual Effects of Proximities. Journal of Travel Research.
  26. Lee, S. and Jang, S. (2010). Room Rates of US Airport Hotels: Examining the Dual Effects of Proximities. Journal of Travel Research.
  27. Li, B., Ghose, A., and Ipeirotis, P. G. (2008). Stay elsewhere? improving local search for hotels using econometric modeling and image classification. In 11th International Workshop on Web and Databases (WebDB).
  28. Li, B., Ghose, A., and Ipeirotis, P. G. (2008). Stay elsewhere? improving local search for hotels using econometric modeling and image classification. In 11th International Workshop on Web and Databases (WebDB).
  29. Monty, B. and Skidmore, M. (2003). Hedonic pricing and willingness to pay for bed and breakfast amenities in Southeast Wisconsin. Journal of Travel Research, 42(2):195.
  30. Monty, B. and Skidmore, M. (2003). Hedonic pricing and willingness to pay for bed and breakfast amenities in Southeast Wisconsin. Journal of Travel Research, 42(2):195.
  31. Okabe, A., Boots, B., Sugihara, K., and Chiu, S. (2000). Spatial tessellations: Concepts and applications of Voronoi diagrams. New York: John Wiley & Sons.
  32. Okabe, A., Boots, B., Sugihara, K., and Chiu, S. (2000). Spatial tessellations: Concepts and applications of Voronoi diagrams. New York: John Wiley & Sons.
  33. Rosen, S. (1974). Hedonic prices and implicit markets: product differentiation in pure competition. The Journal of Political Economy, 82(1):34-55.
  34. Rosen, S. (1974). Hedonic prices and implicit markets: product differentiation in pure competition. The Journal of Political Economy, 82(1):34-55.
  35. Shim, J., Warkentin, M., Courtney, J., Power, D., Sharda, R., and Carlsson, C. (2002). Past, present, and future of decision support technology. Decision support systems, 33(2):111-126.
  36. Shim, J., Warkentin, M., Courtney, J., Power, D., Sharda, R., and Carlsson, C. (2002). Past, present, and future of decision support technology. Decision support systems, 33(2):111-126.
  37. Thrane, C. (2007). Examining the determinants of room rates for hotels in capital cities: The Oslo experience. Revenue & Pricing Management, 5(4):315-323.
  38. Thrane, C. (2007). Examining the determinants of room rates for hotels in capital cities: The Oslo experience. Revenue & Pricing Management, 5(4):315-323.
  39. Zielstra, D. and Zipf, A. (2010). A Comparative Study of Proprietary Geodata and Volunteered Geographic Information for Germany. In 13th AGILE International Conference on Geographic Information Science. Guimaraes, Portugal.
  40. Zielstra, D. and Zipf, A. (2010). A Comparative Study of Proprietary Geodata and Volunteered Geographic Information for Germany. In 13th AGILE International Conference on Geographic Information Science. Guimaraes, Portugal.
Download


Paper Citation


in Harvard Style

Kisilevich S., Keim D., Byshko R., Tsibelman M. and Rokach L. (2011). DEVELOPING A PRICE MANAGEMENT DECISION SUPPORT SYSTEM FOR HOTEL BROKERS USING FREE AND OPEN SOURCE TOOLS . In Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 2: ICEIS, ISBN 978-989-8425-54-6, pages 147-156. DOI: 10.5220/0003460701470156


in Harvard Style

Kisilevich S., Keim D., Byshko R., Tsibelman M. and Rokach L. (2011). DEVELOPING A PRICE MANAGEMENT DECISION SUPPORT SYSTEM FOR HOTEL BROKERS USING FREE AND OPEN SOURCE TOOLS . In Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 2: ICEIS, ISBN 978-989-8425-54-6, pages 147-156. DOI: 10.5220/0003460701470156


in Bibtex Style

@conference{iceis11,
author={Slava Kisilevich and Daniel Keim and Roman Byshko and Michael Tsibelman and Lior Rokach},
title={DEVELOPING A PRICE MANAGEMENT DECISION SUPPORT SYSTEM FOR HOTEL BROKERS USING FREE AND OPEN SOURCE TOOLS},
booktitle={Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 2: ICEIS,},
year={2011},
pages={147-156},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003460701470156},
isbn={978-989-8425-54-6},
}


in Bibtex Style

@conference{iceis11,
author={Slava Kisilevich and Daniel Keim and Roman Byshko and Michael Tsibelman and Lior Rokach},
title={DEVELOPING A PRICE MANAGEMENT DECISION SUPPORT SYSTEM FOR HOTEL BROKERS USING FREE AND OPEN SOURCE TOOLS},
booktitle={Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 2: ICEIS,},
year={2011},
pages={147-156},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003460701470156},
isbn={978-989-8425-54-6},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 2: ICEIS,
TI - DEVELOPING A PRICE MANAGEMENT DECISION SUPPORT SYSTEM FOR HOTEL BROKERS USING FREE AND OPEN SOURCE TOOLS
SN - 978-989-8425-54-6
AU - Kisilevich S.
AU - Keim D.
AU - Byshko R.
AU - Tsibelman M.
AU - Rokach L.
PY - 2011
SP - 147
EP - 156
DO - 10.5220/0003460701470156


in EndNote Style

TY - CONF
JO - Proceedings of the 13th International Conference on Enterprise Information Systems - Volume 2: ICEIS,
TI - DEVELOPING A PRICE MANAGEMENT DECISION SUPPORT SYSTEM FOR HOTEL BROKERS USING FREE AND OPEN SOURCE TOOLS
SN - 978-989-8425-54-6
AU - Kisilevich S.
AU - Keim D.
AU - Byshko R.
AU - Tsibelman M.
AU - Rokach L.
PY - 2011
SP - 147
EP - 156
DO - 10.5220/0003460701470156