Skip to main content

Bipolar Queries: A Way to Enhance the Flexibility of Database Queries

  • Chapter
Advances in Data Management

Part of the book series: Studies in Computational Intelligence ((SCI,volume 223))

Abstract

In many real life scenarios the use of standard query languages may be ineffective due to the difficulty to express the real user requirements (information needs). The use of fuzzy logic helps to fight this ineffectiveness making it possible to model and properly process linguistic terms in queries. This way a user may express his or her requirements in a more intuitive and flexible way. Recently another dimension of such a flexibility attracted the attention of many researchers. Namely, it is now widely advocated that by specifying his or her requirements the user is usually having in mind both negative and positive preferences. Thus, a combination of an intuitive appeal of natural language terms in queries with a bipolar nature of preferences seems to be a next promising step in enhancing the flexibility of queries.We look at various ways of how to understand bipolarity in database querying, propose fuzzy counterparts of some crisp approaches and study their properties.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 129.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 169.99
Price excludes VAT (USA)
  • Durable hardcover 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

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Benferhat, S., Dubois, D., Kaci, S., Prade, H.: Bipolar possibility theory in preference modeling: Representation, fusion and optimal solutions. Information Fusion 7(1), 135–150 (2006)

    Google Scholar 

  2. Bordogna, G., Pasi, G.: Linguistic aggregation operators of selection criteria in fuzzy information retrieval. International Journal of Intelligent Systems 10(2), 233–248 (1995)

    Article  Google Scholar 

  3. Bosc, P., Pivert, O.: Discriminated answers and databases: fuzzy sets as a unifying expression means. In: Proceedings of the IEEE International Conference on Fuzzy Systems (FUZZ-IEEE), San Diego, USA, pp. 745–752 (1992)

    Google Scholar 

  4. Bosc, P., Pivert, O.: An approach for a hierarchical aggregation of fuzzy predicates. In: Proceedings of the Second IEEE International Conference on Fuzzy Systems (FUZZ-IEEE 1993), San Francisco, USA, pp. 1231–1236 (1993)

    Google Scholar 

  5. Bosc, P., Pivert, O.: SQLf: A relational database language for fuzzy querying. IEEE Transactions on Fuzzy Systems 3(1), 1–17 (1995)

    Article  MathSciNet  Google Scholar 

  6. Chomicki, J.: Querying with intrinsic preferences. In: Jensen, C.S., Jeffery, K., Pokorný, J., Šaltenis, S., Bertino, E., Böhm, K., Jarke, M. (eds.) EDBT 2002. LNCS, vol. 2287, pp. 34–51. Springer, Heidelberg (2002)

    Chapter  Google Scholar 

  7. Chomicki, J.: Preference formulas in relational queries. ACM Transactions on Database Systems 28(4), 427–466 (2003)

    Article  Google Scholar 

  8. Dubois, D., Fargier, H., Prade, H.: Refinement of the maximin approach to decision-making in fuzzy environment. Fuzzy Sets and Systems (81), 103–122 (1996)

    Google Scholar 

  9. Dubois, D., Prade, H.: Using fuzzy sets in flexible querying: why and how? In: Andreasen, T., Christiansen, H., Larsen, H. (eds.) Flexible Query Answering Systems, pp. 45–60. Kluwer Academic Publishers, Dordrecht (1997)

    Google Scholar 

  10. Dubois, D., Prade, H.: Bipolarity in flexible querying. In: Andreasen, T., Motro, A., Christiansen, H., Larsen, H.L. (eds.) FQAS 2002. LNCS (LNAI), vol. 2522, pp. 174–182. Springer, Heidelberg (2002)

    Google Scholar 

  11. Dubois, D., Prade, H.: Handling bipolar queries in fuzzy information processing. In: Galindo [14], pp. 97–114

    Google Scholar 

  12. Dubois, D., Prade, H.: An introduction to bipolar representations of information and preference. International Journal of Intelligent Systems 23(8), 866–877 (2008)

    Article  MATH  Google Scholar 

  13. Fodor, J., Roubens, M.: Fuzzy Preference Modelling and Multicriteria Decision Support. Series D: System Theory, Knowledge Engineering and Problem Solving. Kluwer Academic Publishers, Dordrecht (1994)

    MATH  Google Scholar 

  14. Galindo, J. (ed.): Handbook of Research on Fuzzy Information Processing in Databases. Information Science Reference, New York (2008)

    Google Scholar 

  15. Kacprzyk, J., Zadrożny, S.: Computing with words in intelligent database querying: standalone and internet-based applications. Information Sciences 134(1-4), 71–109 (2001)

    Article  MATH  Google Scholar 

  16. Lacroix, M., Lavency, P.: Preferences: Putting more knowledge into queries. In: Proceedings of the 13 International Conference on Very Large Databases, Brighton, UK, pp. 217–225 (1987)

    Google Scholar 

  17. Lietard, L., Rocacher, D., Tbahriti, S.E.: Towards an extended SQLf: Bipolar query language with preferences. International Journal of Applied Mathematics and Computer Sciences 4(1), 58–63 (2008)

    Google Scholar 

  18. Mesiar, R., Thiele, H.: On T-Quantifiers and S-Quantifiers. In: Novak, V., Perfilieva, I. (eds.) Discovering the World with Fuzzy Logic, pp. 310–326. Physica-Verlag, Heidelberg (2000)

    Google Scholar 

  19. Ṡwitalski, Z.: Choice functions associated with fuzzy preference relations. In: Kacprzyk, J., Roubens, M. (eds.) Non-Conventional Preference Relations in Decision Making, pp. 106–118. Springer, Berlin (1988)

    Google Scholar 

  20. Yager, R.: Fuzzy sets and approximate reasoning in decision and control. In: Proceedings of the IEEE International Conference on Fuzzy Systems (FUZZ-IEEE), San Diego, USA, pp. 415–428 (1992)

    Google Scholar 

  21. Yager, R.: Higher structures in multi-criteria decision making. International Journal of Man-Machine Studies 36, 553–570 (1992)

    Article  Google Scholar 

  22. Yager, R.: Fuzzy logic in the formulation of decision functions from linguistic specifications. Kybernetes 25(4), 119–130 (1996)

    Article  MATH  MathSciNet  Google Scholar 

  23. Zadrożny, S.: Bipolar queries revisited. In: Torra, V., Narukawa, Y., Miyamoto, S. (eds.) MDAI 2005. LNCS (LNAI), vol. 3558, pp. 387–398. Springer, Heidelberg (2005)

    Google Scholar 

  24. Zadrożny, S., De Tre, G., De Caluwe, R., Kacprzyk, J.: An overview of fuzzy approaches to flexible database querying. In: Galindo [14], pp. 34–53

    Google Scholar 

  25. Zadrożny, S., Kacprzyk, J.: Bipolar queries and queries with preferences. In: Proceedings of the 17th International Conference on Database and Expert Systems Applications (DEXA 2006), pp. 415–419. IEEE Computer Society, Krakow (2006)

    Chapter  Google Scholar 

  26. Zadrożny, S., Kacprzyk, J.: Bipolar queries using various interpretations of logical connectives. In: Melin, P., Castillo, O., Aguilar, L.T., Kacprzyk, J., Pedrycz, W. (eds.) IFSA 2007. LNCS, vol. 4529, pp. 181–190. Springer, Heidelberg (2007)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Zadrożny, S., Kacprzyk, J. (2009). Bipolar Queries: A Way to Enhance the Flexibility of Database Queries. In: Ras, Z.W., Dardzinska, A. (eds) Advances in Data Management. Studies in Computational Intelligence, vol 223. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-02190-9_3

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-02190-9_3

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-02189-3

  • Online ISBN: 978-3-642-02190-9

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics