Skip to main content
Springer Nature Link
Log in

Flexible Division Queries Based on RL-Instances

  • Conference paper
  • First Online:
Information Processing and Management of Uncertainty in Knowledge-Based Systems (IPMU 2022)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 1602))

  • 829 Accesses

Abstract

In this paper we discuss on performing flexible division queries in crisp relational databases using gradual restrictions on the values of attributes. Our approach is based on using fuzzy sets for representing the restrictions and a recently proposed approach for computing and representing the result, based on the paradigm of Representations by Levels. We show some examples of usual division query patterns with SQL based on the NOT EXISTS operator.

Authors appear in alphabetical order. All authors have participated in conceptualization and research tasks. P. Córdoba-Hidalgo carried out most of the implementation tasks under the supervision of her advisors N. Marín and D. Sánchez.

This work has been partially supported by the Andalusian Government and the European Regional Development Fund - ERDF (Fondo Europeo de Desarrollo Regional - FEDER) under grants B-TIC-145-UGR18 and P18-RT-1765, BIGDATAMED. Analisis de Datos en Medicina: de las Historias Clínicas al Big Data.

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

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

Notes

  1. 1.

    We shall use the term instance to refer to relation instances from now on.

  2. 2.

    In this paper, logical expressions are those expressions of first order logic based on the use of conjunction, disjunction, negation, and comparison operators in the domains of attributes, as commonly employed in relational database queries.

  3. 3.

    www.oracle.com.

References

  1. Bosc, P., Pivert, O.: On diverse approaches to bipolar division operators. Int. J. Intell. Syst. 26(10), 911–929 (2011)

    Article  Google Scholar 

  2. Bosc, P., Pivert, O., Rocacher, D.: Tolerant division queries and possibilistic database querying. Fuzzy Sets Syst. 160(15), 2120–2140 (2009)

    Article  MathSciNet  Google Scholar 

  3. Córdoba-Hidalgo, P., Marín, N., Sánchez, D.: RL-instances: an alternative to conjunctive fuzzy sets of tuples for flexible querying in relational databases. Fuzzy Sets Syst. https://doi.org/10.1016/j.fss.2022.03.022

  4. Cornelis, C., der Donck, C.V., Kerre, E.E.: Sinha-Dougherty approach to the fuzzification of set inclusion revisited. Fuzzy Sets Syst. 134(2), 283–295 (2003)

    Article  MathSciNet  Google Scholar 

  5. Dubois, D., Prade, H.: Gradual elements in a fuzzy set. Soft Comput. 12, 165–175 (2008)

    Article  Google Scholar 

  6. Dubois, D., Prade, H.: Semantics of quotient operators in fuzzy relational databases. Fuzzy Sets Syst. 78(1), 89–93 (1996)

    Article  MathSciNet  Google Scholar 

  7. Galindo, J., Medina, J.M., Garrido, M.C.: Fuzzy division in fuzzy relational databases: an approach. Fuzzy Sets Syst. 121(3), 471–490 (2001)

    Article  MathSciNet  Google Scholar 

  8. Marín, N., Molina, C., Pons, O., Vila, M.A.: An approach to solve division-like queries in fuzzy object databases. Fuzzy Sets Syst. 196, 47–68 (2012)

    Article  MathSciNet  Google Scholar 

  9. Sánchez, D., Delgado, M., Vila, M.A., Chamorro-Martínez, J.: On a non-nested level-based representation of fuzziness. Fuzzy Sets Syst. 192(1), 159–175 (2012)

    Article  MathSciNet  Google Scholar 

  10. Yager, R.R.: Fuzzy quotient operators for fuzzy relational databases. In: Proceedings IFES 1991, pp. 289–296 (1991)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department Computer Science and Artificial Intelligence, University of Granada, Granada, Spain

    Patricia Córdoba-Hidalgo, Nicolás Marín & Daniel Sánchez

Authors
  1. Patricia Córdoba-Hidalgo
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Nicolás Marín
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Daniel Sánchez
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Daniel Sánchez .

Editor information

Editors and Affiliations

  1. University of Milano-Bicocca, Milan, Italy

    Davide Ciucci

  2. University of Oviedo, Oviedo, Spain

    Inés Couso

  3. University of Cádiz, Cádiz, Spain

    Jesús Medina

  4. University of Warsaw, Warsaw, Poland

    Dominik Ślęzak

  5. University of Perugia, Perugia, Italy

    Davide Petturiti

  6. Sorbonne Université, Paris, France

    Bernadette Bouchon-Meunier

  7. Iona College, New Rochelle, NY, USA

    Ronald R. Yager

Rights and permissions

Reprints and permissions

Copyright information

© 2022 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Córdoba-Hidalgo, P., Marín, N., Sánchez, D. (2022). Flexible Division Queries Based on RL-Instances. In: Ciucci, D., et al. Information Processing and Management of Uncertainty in Knowledge-Based Systems. IPMU 2022. Communications in Computer and Information Science, vol 1602. Springer, Cham. https://doi.org/10.1007/978-3-031-08974-9_26

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-08974-9_26

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-08973-2

  • Online ISBN: 978-3-031-08974-9

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics