Hostname: page-component-78c5997874-s2hrs Total loading time: 0 Render date: 2024-11-18T07:44:03.108Z Has data issue: false hasContentIssue false
  • English
  • Français

Formalising PFSQL queries using ŁΠ fuzzy logic†

Published online by Cambridge University Press:  14 December 2011

ALEKSANDAR PEROVIĆ ,
ALEKSANDAR TAKAČI  and
SRDJAN ŠKRBIĆ
ALEKSANDAR PEROVIĆ
Affiliation:
Faculty of Transportation and Traffic Engineering, University of Belgrade, Serbia Email: pera@sf.bg.ac.rs
ALEKSANDAR TAKAČI
Affiliation:
Faculty of Technology, University of Novi Sad, Serbia Email: stakaci@tf.uns.ac.rs
SRDJAN ŠKRBIĆ
Affiliation:
Faculty of Science, University of Novi Sad, Serbia Trg Dositeja Obradovića 3, 21000 Novi Sad, Serbia Email: shkrba@uns.ac.rs
Get access Rights & Permissions [Opens in a new window]

Abstract

Using the concept of a generalised priority constraint satisfaction problem, we previously found a way to introduce priority queries into fuzzy relational databases. The results were PFSQL (Priority Fuzzy Structured Query Language) together with a database independent interpreter for it. In an effort to improve the performance of the resolution of PFSQL queries, the aim of the current paper is to formalise PFSQL queries by obtaining their interpretation in an existing fuzzy logic. We have found that the ŁΠ logic provides sufficient elements. The SELECT line of PFSQL queries is semantically a formula of some fuzzy logic, and we show that such formulas can be naturally expressed in a conservative extension of the ŁΠ logic. Furthermore, we prove a theorem that gives the PSPACE containment for the complexity of finding a model for a given ŁΠ logic formula.

Type
Paper
Information
Mathematical Structures in Computer Science , Volume 22 , Issue 3 , June 2012 , pp. 533 - 547
Copyright
Copyright © Cambridge University Press 2011

Access options

Get access to the full version of this content by using one of the access options below. (Log in options will check for institutional or personal access. Content may require purchase if you do not have access.)

References

Buckles, B. and Petry, F. (1982) A Fuzzy representation of data for relational databases. Fuzzy Sets and Systems 7 (3)213–226.CrossRefGoogle Scholar
Chaudhry, N., Moyne, J. and Rundensteiner, E. (1994) A design methodology for databases with uncertain data. Proceedings 7th International Conference on Scientific and Statistical Database Management 32–41.CrossRefGoogle Scholar
Chen, G. Q. and Kerre, E. E. (1998) Extending ER/EER concepts towards fuzzy conceptual data modelling. Proceedings IEEE International Conference on Fuzzy Systems 1320–1325.Google Scholar
Galindo, J., Medina, J. and Aranda, M. (1999) Querying fuzzy relational databases through fuzzy domain calculus. International Journal of Intelligent Systems 14 (4)375–411.3.0.CO;2-K>CrossRefGoogle Scholar
Galindo, J., Medina, J., Cubero, J. and Garcia, M. (2001) Relaxing the universal quantifier of the division in fuzzy relational databases. International Journal of Intelligent Systems 16 (6)713–742.CrossRefGoogle Scholar
Galindo, J., Urrutia, A. and Piattini, M. (2006) Fuzzy databases: modelling design and implementation. IDEA Group.CrossRefGoogle Scholar
Cintula, P., Hájek, P. and Horčik, R. (2007) Formal systems of fuzzy logic and their fragments. Annals of Pure and Applied Logic 150 40–65.CrossRefGoogle Scholar
Esteva, F., Godo, L., Hájek, P. and Navara, M. (2000) Residuated fuzzy logics with an involutive negation. Archive for Mathematical Logic 39 (2)103–124.CrossRefGoogle Scholar
Esteva, F., Godo, L. and Montagna, F. (2001) The ŁΠ and ŁΠ logics: two complete fuzzy logics joining Łukasiewicz and Product Logics. Archive for Mathematical Logic 40 (1)39–67.CrossRefGoogle Scholar
Godo, L., Esteva, F. and Hajek, P. (2000) Reasoning about probability using fuzzy logic. Neural Network World 10 (5)811–824.Google Scholar
Godo, L. and Marchioni, E. (2006) Coherent conditional probability in a fuzzy logic setting. Logic Journal of the IGPL 14 (3)457–481.CrossRefGoogle Scholar
Hájek, P. (1998) Metamathematics of fuzzy logic, Kluwer academic publishers.CrossRefGoogle Scholar
Hájek, P., Godo, L. and Esteva, F. (1995) Fuzzy logic and probability. Proceedings 11th UAI 237–244.Google Scholar
Hájek, P., Godo, L. and Esteva, F. (1996) A complete many-valued fuzzy logic with product conjunction. Archive for Mathematical Logic 35 (3)191–208.CrossRefGoogle Scholar
Hudec, M. (2009) An approach to fuzzy database querying, analysis and realization. Computer Science and Information Systems 6 (2)127–140.CrossRefGoogle Scholar
Luo, X., Lee, J., Leung, H. and Jennings, N. (2003) Prioritized fuzzy constraint satisfaction problems: axioms, instantiation and validation. Fuzzy Sets and Systems 136 (2)151–188.CrossRefGoogle Scholar
Marchioni, E. and Montagna, F. (2008) On triangular norms and uninorms definable in ŁΠ. International Journal of Approximate Reasoning 47 (2)179–201.CrossRefGoogle Scholar
Medina, J. M., Pons, O. and Vila, M. A. (1994) GEFRED: a generalized model of fuzzy relational databases. Information Sciences 76 (1-2)87–109.CrossRefGoogle Scholar
Škrbić, S. and Takači, A. (2008) On development of fuzzy relational database applications. Proceedings 12th IPMU 268–273.Google Scholar
Škrbić, S. and Racković, M. (2009) PFSQL: a fuzzy SQL language with priorities. Proceedings of PSU-UNS International Conference on Engineering Technologies, Novi Sad, Serbia 58–63.Google Scholar
Škrbić, S., Racković, M. and Takači, A. (2011) Towards the methodology for development of fuzzy relational database applications. Computer Science and Information Systems 8 (1)27–40.CrossRefGoogle Scholar
Takači, A., Perović, A. and Jovanović, A. (2008) Measuring uncertainty with priority based logic. Proceedings 12th IPMU 1490–1496.Google Scholar
Takači, A. (2005) Schur-concave triangular norms: characterization and application in PFCSP. Fuzzy Sets and Systems 155 (1)50–64.CrossRefGoogle Scholar
Takači, A. and Škrbić, S. (2005) How to implement FSQL and priority queries. Proceedings 3rd Serbian–Hungarian Joint Symposium on Intelligent Systems, Subotica, Serbia 261–267.Google Scholar
Takači, A. and Škrbić, S. (2007) Measuring the similarity of different types of fuzzy sets in FRDB. Proceedings EUSFLAT-LFA, Ostrava, Czech Republic 247–252.Google Scholar
Takači, A. and Škrbić, S. (2008) Data model of FRDB with different data types and PFSQL. In: Galindo, J. (ed.) Handbook of Research on Fuzzy Information Processing in Databases, Information Science Reference 407–434.CrossRefGoogle Scholar
Zvieli, A. and Chen, P. (1986) ER modelling and fuzzy databases. Proceedings of the 2nd International Conference Data Engineering 320–327.Google Scholar