Skip to main content

Preference Specification

  • Living reference work entry
  • First Online:
Encyclopedia of Database Systems
  • 70 Accesses

FormalPara Synonyms

Preference Definition

Definition

Usually, preference relations are formalized as strict partial orders (SPO), which means that a preference relation \(\succ\) satisfies the following properties:

  • irreflexivity: \(\forall x\ (x \not\succ x)\),

  • transitivity: \(\forall x,y,z\ (x\,\succ \,y\,\wedge \,y\,\succ \,z\,\rightarrow \,x\succ z)\).

Additionally, an SPO \(\succ\) is a weak order if \(\forall x,y,z\ (x \succ y \rightarrow x \succ z \vee z \succ y)\), and a total order if \(\forall x,y\ (x \succ y \vee y \succ x \vee x = y)\).

The formal properties of orders capture the nature of preferences in an abstract, application-independent way. It is obvious that irreflexivity should hold: preferring an object over itself seems to violate the basic intuitions behind preference. But transitivity is debatable. On one hand, it captures the rationality of preferences [1, 2]. On the other, transitivity is sometimes violated by preference aggregation in voting scenarios [3]. The...

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

Access this chapter

Institutional subscriptions

Recommended Reading

  1. Fishburn PC. Utility theory for decision making. New York: Wiley; 1970.

    MATH  Google Scholar 

  2. Fishburn PC. Preference structures and their numerical representations. Theor Comput Sci. 1999;217:359–83.

    Article  MathSciNet  MATH  Google Scholar 

  3. Sen AK, Pattanaik PK. Necessary and sufficient conditions for rational choice under majority decision. J Econ Theory. 1969;1:178–202.

    Article  MathSciNet  Google Scholar 

  4. Hansson SO. Preference logic. In: Gabbay D, editor. Handbook of philosophical logic. vol 4. Dordrecht/Boston: Kluwer; 2001.

    Google Scholar 

  5. Brafman RI, Domshlak C. Preference handling – an introductory tutorial. AI Mag. 2009;30(1):58–86.

    Google Scholar 

  6. Stefanidis K, Koutrika G, Pitoura E. A survey on representation, composition and application of preferences in database systems. ACM Trans Database Syst. 2011;36(4):1–45.

    Article  Google Scholar 

  7. Chomicki J. Preference formulas in relational queries. ACM Trans Database Syst. 2003;28(4): 427–66.

    Article  MathSciNet  Google Scholar 

  8. Kießling W. Foundations of preferences in database systems. In: International conference on very large data bases (VLDB), Hong Kong SAR; 2002. p. 311–22.

    Google Scholar 

  9. Kießling W, Köstler G. Preference SQL – design, implementation, experience. In: International conference on very large data bases (VLDB), Hong Kong SAR; 2002. p. 990–1001.

    Google Scholar 

  10. Im H, Park S. Group skyline computation. Inf Sci. 2012;188(0):151–69.

    Article  MathSciNet  MATH  Google Scholar 

  11. Li C, Zhang N, Hassan N, Rajasekaran S, Das G. On skyline groups. In: International conference on information and knowledge management (CIKM), Maui; 2012. p. 2119–23.

    Google Scholar 

  12. Zhang X, Chomicki J. Preference queries over sets. In: IEEE international conference on data engineering (ICDE); 2011. p. 1019–30.

    Google Scholar 

  13. Antony S, Wu P, Agrawal D, El Abbadi A. Aggregate skyline: analysis for online users. In: Symposium on applications and the Internet (SAINT). Piscataway: IEEE; 2009. p. 50–56.

    Google Scholar 

  14. Koutrika G, Ioannidis Y. Personalization of queries in database systems. In: IEEE international conference on data engineering (ICDE), Boston; 2004. p. 597–608.

    Google Scholar 

  15. Arvanitis A, Koutrika G. PrefDB: supporting preferences as first-class citizens in relational databases. IEEE Trans Knowl Data Eng. 2014;26(6):1430–46.

    Article  Google Scholar 

  16. Kießling W, Fischer S, Döring S. COSIMAB2B – sales automation for E-procurement. IEEE Press; 2004. p. 59–68.

    Google Scholar 

  17. Köbberling V. Strength of preference and cardinal utility. Econ Theory. 2006;27:375–91.

    Article  MathSciNet  MATH  Google Scholar 

  18. Mindolin D, Chomicki J. Preference elicitation in prioritized skyline queries. VLDB J. 2011;20(2):157–82. Special issue: selected papers from VLDB 2009.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Jan Chomicki .

Editor information

Editors and Affiliations

Section Editor information

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media LLC

About this entry

Cite this entry

Chomicki, J. (2016). Preference Specification. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_80707-1

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_80707-1

  • Received:

  • Accepted:

  • Published:

  • Publisher Name: Springer, New York, NY

  • Online ISBN: 978-1-4899-7993-3

  • eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering

Publish with us

Policies and ethics