Abstract
This paper describes a preference query language based on SQL, which captures preferences modeled by means of symbolic scores expressed in a linguistic manner. The high expressivity of this language is emphasized, and it is shown that some connections between the preference criteria considered and Boolean conditions make it possible to take advantage of the optimization mechanisms offered by classical DBMSs when it comes to query processing.
This is a preview of subscription content, log in via an institution to check access.
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
Agrawal, R., Wimmers, E.L.: A framework for expressing and combining preferences. In: Proc. of SIGMOD 2000, pp. 297–306 (2000)
Bőrzsőnyi, S., Kossmann, D., Stocker, K.: The skyline operator. In: Proc. of ICDE 2001, pp. 421–430 (2001)
Bosc, P., Pivert, O.: SQLf: a relational database language for fuzzy querying. IEEE Trans. on Fuzzy Systems 3, 1–17 (1995)
Bruno, N., Chaudhuri, S., Gravano, L.: Top-k selection queries over relational databases: mapping strategies and performance evaluation. ACM Transactions on Database Systems 27, 153–187 (2002)
Chan, C.Y., Jagadish, H.V., Tan, K.L., Tung, A.K.H., Zhang, Z.: Finding k-dominant skylines in high dimensional space. In: Proc. of SIGMOD 2006, pp. 503–514 (2006)
Chaudhuri, S., Gravano, L.: Evaluating top-k selection queries. In: Proc. of the VLDB 1999, pp. 399–410 (1999)
Chomicki, J.: Preference formulas in relational queries. ACM Transactions on Database Systems 28, 1–40 (2003)
Dubois, D., Prade, H.: Weighted minimum and maximum operations in fuzzy set theory. Information Sciences, 205–210 (1986)
Dubois, D., Prade, H.: Using fuzzy sets in flexible querying: Why and how? In: Proc. of FQAS 1996, pp. 89–103 (1996)
Fagin, R.: Fuzzy queries in multimedia database systems. In: Proc. of PODS 1998, pp. 1–10 (1998)
HadjAli, A., Kaci, S., Prade, H.: Database Preferences Queries – A Possibilistic Logic Approach with Symbolic Priorities. In: Hartmann, S., Kern-Isberner, G. (eds.) FoIKS 2008. LNCS, vol. 4932, pp. 291–310. Springer, Heidelberg (2008)
Kießling, W., Köstler, G.: Preference SQL — design, implementation, experiences. In: CAiSE 2002 and VLDB-WS 2002, pp. 990–1001 (2002)
Lin, X., Yuan, Y., Zhang, Q., Zhang, Y.: Selecting stars: the k most representative skyline operator. In: Proc. of ICDE 2007, pp. 86–95 (2007)
Pivert, O., Bosc, P.: Fuzzy Preference Queries to Relational Databases. Imperial College Press, London (2012)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Pivert, O., Smits, G. (2012). On a Preference Query Language That Handles Symbolic Scores. In: Morzy, T., Härder, T., Wrembel, R. (eds) Advances in Databases and Information Systems. ADBIS 2012. Lecture Notes in Computer Science, vol 7503. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-33074-2_22
Download citation
DOI: https://doi.org/10.1007/978-3-642-33074-2_22
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-33073-5
Online ISBN: 978-3-642-33074-2
eBook Packages: Computer ScienceComputer Science (R0)