Acta Informatica Pragensia 2013, 2(2), 25-38 | DOI: 10.18267/j.aip.216806
Flexible data queries
- Faculty of Economic Informatics, University of Economics in Bratislava, Dolnozemská cesta 1, 852 35 Bratislava, Slovak Republic
The Structured Query Language (SQL) has been established as a standard for querying relational databases. However, users face the problem how to define their requirements for data by the exact query conditions. This work examines advantages of fuzzy queries, which provide a better representation of the user requirements by expressing imprecise conditions through linguistic terms. Further, the paper discusses solving empty and overabundant answer problems, revealing similarities in database entities and applying preferences in query conditions. Finally, paper discusses practical realisations of fuzzy queries.
Keywords: Fuzzy logic, SQL, Benefits of fuzzy queries
Received: October 18, 2013; Revised: December 18, 2013; Accepted: December 28, 2013; Published: December 31, 2013 Show citation
References
- BOSC, P., PIVERT, O. SQLf Query Functionality on Top of a Regular Relational Database Management System. In Knowledge Management in Fuzzy Databases. Physica Publisher, Heidelberg, pp. 171-190, 2000.
Go to original source...
- BOSC, P., HADJALI, A., PIVERT, O., SMITS, G. Trimming Plethoric Answers to Fuzzy Queries: An Approach Based on Predicate Correlation. In Computational Intelligence for Knowledge-Based Systems Design. Springer, Heidelberg, volume 6178, pp. 595-604, 2010.
Go to original source...
- BOSC, P. HADJALI, A., PIVERT, O. Empty versus overabundant answers to flexible relational queries. Fuzzy Sets and Systems. Vol. 159, No, 12, 2008, pp. 1450-1467.
Go to original source...
- COX, E.: Fuzzy modeling and genetic algorithms for data mining and exploration. Morgan Kaufman, San Francisco, 2005. ISBN-10: 0121942759.
- DETYNIECKI M. Fundamentals on Aggregation Operators. In AGOP International Summer School on Aggregation Operators, Asturias, 2001. [cited 2013-7-7]. Available from:http://www-poleia.lip6.fr/~marcin/papers/Detynieck_AGOP_01.pdf
- GALINDO J., URRUTIA A., PIATTINI M. Fuzzy databases: Modeling, Design and Implementation. Idea Group Publishing Inc., Hershey, 2006. ISBN 1-59140-324-3
Go to original source...
- HUDEC, M.Fuzzy database queries in official statistics: Perspective of using linguistic terms in query conditions. Statistical Journal of the IAOS (in press).
- HUDEC, M. Exploration of applying fuzzy logic for official statistics. Conference of New Techniques and Technologies for Statistic. European Commission, Brussels, 2011. [cited 2013-5-10]. Available from: http://www.cros-portal.eu/content/ps1-poster-9-ntts-2011-s1
- HUDEC, M. An Approach to Fuzzy Database Querying, Analysis and Realisation. Computer Science and Information Systems, Vol. 6, No. 2, 2009, pp. 127-140.
Go to original source...
- HUDEC, M., SUDZINA, F. Construction of fuzzy sets and applying aggregation operators for fuzzy queries. 14th International Conference on Enterprise Information Systems, Wroclaw, Poland, ICEIS, 2012, Proceedings volume 1, pp. 253-257.
- CHAMBERLIN, D., BOYCE R.SEQUEL: A Structured English Query Language. In ACM SIGMOD Workshop on Data Description, Access and Control, Ann Arbor, USA, 1974, pp. 249-264.
- KACPRZYK J., PASI G., VOJTÁŠ P., ZADROZNY S. Fuzzy querying: Issues and perspectives. Kybernetika, Vol. 36, No. 6, 2000, pp. 605-616.
- KLIR G., YUAN B. Fuzzy sets and fuzzy logic, theory and applications. Prentice Hall, New Jersey, 1995. ISBN-10: 0131011715.
Go to original source...
- KĽÚČIK, M, HUDEC, M., JURIOVÁ, J. Final report on the case study results on usage of IT tools and procedures developed for data collection (Soft computing tools for Official Statistics). Deliverable 5.2, Blue-ETS Project, 2012. [cited 2013-03-10]. Available from: http://www.blue-ets.istat.it/index.php?id=7&tx_wfqbe_pi1[showpage][1]=2
- MCNEILL F.M., THRO E. Fuzzy logic - a practical approach. Academic Press Inc., Boston. 1994. ISBN-10: 0124859658
Go to original source...
- RADOJEVIĆ, D. Interpolative realization of Boolean algebra as a consistent frame for gradation and/or fuzziness. In Forging New Frontiers: Fuzzy Pioneers II Studies in Fuzziness and Soft Computing. Springer-Verlag, Berlin / Heidelberg, pp. 295-318, 2008.
Go to original source...
- SMITS, G., PIVERT, O., GIRAULT, T. (2013). ReqFlex: Fuzzy Queries for Everyone. The VLDB Endowment, Riva del Garda, Italy, Vol. 6, No. 12. pp. 1206-1209, 2013.
Go to original source...
- URRUTIA, A., PAVESI, L. Extending the capabilities of database queries using fuzzy logic. Proceedings of the Collecter-LatAm Conference, Santiago, Chile, 2004. [cited 2011-5-10]. Available from: http://www.collecter.org/archives/2004_October/06.pdf.
- WANG, T.C., LEE, H.D., CHEN, C.M. Intelligent Queries based on Fuzzy Set Theory and SQL. Joint Conference on Information Science, Salt Lake City, USA, 2007.pp. 1426-1433.
Go to original source...
- ZADEH L.A. From computing with numbers to computing with words - from manipulation of measurements to manipulation of perceptions. International Journal of Applied Mathematics and Computer Science, Vol. 12, No. 3, 2002, pp. 307-324.
Go to original source...
- ZADEH L. A. Fuzzy sets. Information and Control, Vol. 8, 1965, pp. 338-353.
Go to original source...
- ZADROŻNY S., DE TRÉ G., DE CALUWE R. KACPRZYK J. An overview of fuzzy approaches to flexible database querying, In Fuzzy Information Processing in Databases, IGI Global, London, pp. 34-54, 2008.
Go to original source...
- ZIMMERMANN, H-J. Fuzzy Set Theory: And Its Applications. Kluwer Academic Publishers, London, 2001. ISBN-10: 0792374355.
Go to original source...
This is an open access article distributed under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits use, distribution, and reproduction in any medium, provided the original publication is properly cited. No use, distribution or reproduction is permitted which does not comply with these terms.