Abstract
Personalized and context-aware information filtering poses a major challenge for the development of meaningful location-based recommendation services, and even more for complex mobile apps for planning outdoor activities. To this end search engine technology has to be extended by sophisticated preference handling capabilities for large amounts of application data, which is typically stored in relational geo-databases like PostGIS. In this paper we propose to employ the Preference SQL query language with its Best-Matches-Only query model as one key enabling technology. Moreover, we introduce a novel location-based preference constructor for querying such geo-databases. We further demonstrate how this extended Preference SQL system can be integrated with an existing commercial web platform for planning outdoor activities such as hiking or mountain bike tours. By performing personalized and context-aware query composition, employing a preference repository attached with social networks and using online information like weather conditions, best matching tour recommendations can be computed with one single query and delivered to mobile smart phones. We are highly confident that forthcoming practical use case evaluations will show the effectiveness and efficiency of our approach for a wide range of application scenarios.
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
Adomavicius G, Tuzhilin A (2005) Toward the Next Generation of Recommender Systems: A Survey of the State-of-the-Art and Possible Extensions. In IEEE Transactions on Knowledge and Data Engineering, vol. 17, no. 6, pp. 734–749.
Brafman R, Domshlak C (2009) Preference Handling: An Introductory Tutorial. In AI Magazine, vol. 30, no. 1, pp. 58–86, Menlo Park, CA, USA.
Chomicki J (2003) Preference Formulas in Relational Queries. In ACM Transactions on Database Systems (TODS), vol. 28, no. 4, pp. 427–466, New York, NY, USA.
Cohen W, Schapire R, Singer Y (1999) Learning to Order Things. In Journal of Artificial Intelligence Research, vol. 10, pp. 243–270.
Facebook (2011) [Online] Available: http://www.facebook.com [15 May 2011]
Hafenrichter B, Kießling W (2005) Optimization of Relational Preference Queries. In Proceedings of the 16th Australasian Database Conference (ADC), pp. 175–184, Darlinghurst, Australia.
Hanani U, Shapira B, Shoval P(2001) Information Filtering: Overview of Issues, Research and Systems. In User Modeling and User-Adapted Interaction, vol. 11, no. 3, pp. 203–259.
Hoffmann K, Bateson J (2008): Services Marketing: Concepts, Strategies & Cases, South-Western Cengage Learning, Mason, OH, USA.
Holland S, Kießling W (2004) Situated Preferences and Preference Repositories for Personalized Database Applications In Proceedings of the 23rd International Conference on Conceptual Modeling (ER), pp. 511–523, Shanghai, China.
Kießling W (2002) Foundations of Preferences in Database Systems. In Proceedings of the 28th International Conference on Very Large Data Bases (VLDB), pp. 311–322, Hong Kong, China.
Kießling W, Endres M, Wenzel F (2011) The Preference SQL System – An Overview. In Bulletin of the IEEE Computer Society Technical Committee on Data Engineering, vol. 34, no.2, pp. 11–18.
Mokbel M, Levandoski J (2009): Toward Context and Preference-Aware and Location-based Services. In Proceedings of the 8th International ACM Workshop on Data Engineering for Wireless and Mobile Access, Providence, RI, USA.
Nivala A, Sarjakoski T, Laakso K, Itäranta J, Kettunen P (2008) User Requirements for Location-Based Services to Support Outdoor Activities, in Gartner G, Rehrl K (Eds), Location Based Services and TeleCartography II, LNG&C Springer, pp. 167–184.
Outdooractive (2011) [Online] Available: http://www.outdooractive.com [15 May 2011]
Poslad S, Laamanen H, Malaka R, Nick A, Buckle P, Zipf A (2001): Crumpet: Creation of User Friendly Mobile services Personalized for Tourism. In Proceedings of the 2nd International Conference on 3G Mobile Communication Technologies, pp. 28–32, London, UK.
PostGIS Spatial Database Extension (2011) [Online] Available: http://postgis.refractions.net/ [15 May 2011]
Preference SQL Reference (2011) [Online]Available: http://trial.preferencesql.com [15 May 2011]
Preisinger T, Kießling W (2007) The Hexagon Algorithm for Evaluating Pareto Preference Queries. In Proceedings of the 3rd Multidisciplinary Workshop onAdvances in Preference Handling (M-PREF in conjunction with VLDB ’07), Vienna, Austria.
Sacco G (2009). The Model. In Sacco G, Tzitzikas Y (Eds) Dynamic Taxonomies and Faceted Search. Springer, pp. 1–19.
Stefanidis K, Koutrika G, Pitoura E (2011) A Survey on Representation, Composition and Application of Preferences in Database Systems. In ACM Transactions on Database Systems (TODS), vol. 36, no. 3, New York, NY, USA.
Tryfonopoulus C, Koubarakis M, Drougas Y (2009) Information Filtering and Query Indexing for an Information Retrieval Model. In ACM Transactions on Information Systems, volume 27, issue 2.
van den Eijkel G, Lankhorst M, Bijlsma M, van Kranenburg H. (2001): Personalization of next-generation mobile services, Position paper Wireless World Research Forum, Munich, Germany.
Williams M, Halvatzaras D, McIntosh N, Mehrmann L, Pascottol R (2002): Role of a Personal Assistant in Delivering Personalized Context-Aware Services to Young People, In Proceedings of the IST Mobile Communications Summit 2002, pp. 513–517, Thessaloniki, Greece.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Wenzel, F., Soutschek, M., Kießling, W. (2012). A Preference SQL Approach to Improve Context-Adaptive Location-Based Services for Outdoor Activities. In: Gartner, G., Ortag, F. (eds) Advances in Location-Based Services. Lecture Notes in Geoinformation and Cartography. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-24198-7_13
Download citation
DOI: https://doi.org/10.1007/978-3-642-24198-7_13
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-24197-0
Online ISBN: 978-3-642-24198-7
eBook Packages: Earth and Environmental ScienceEarth and Environmental Science (R0)