Digital Technologies Research and Applications

Article

For Fuzzy Classification of Databases with Fuzzy Classification Query Language

Downloads

https://doi.org/10.54963/dtra.v1i2.34
Mahini, S. (2022). For Fuzzy Classification of Databases with Fuzzy Classification Query Language. Digital Technologies Research and Applications, 1(2), 44–51. https://doi.org/10.54963/dtra.v1i2.34
Volume 1 Issue 2: September 2022
Copyright (c) 2022 The author(s)
Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Copyright

The authors shall retain the copyright of their work but allow the Publisher to publish, copy, distribute, and convey the work.

License

Digital Technologies Research and Applications (DTRA)  publishes accepted manuscripts under Creative Commons Attribution 4.0 International (CC BY 4.0). Authors who submit their papers for publication by DTRA agree to have the CC BY 4.0 license applied to their work, and that anyone is allowed to reuse the article or part of it free of charge for any purpose, including commercial use. As long as the author and original source are properly cited, anyone may copy, redistribute, reuse, and transform the content.

Authors

Business information systems have extensive databases that are mainly managed in relational databases. What is often missing are automated procedures to analyze these inventories without major restructuring. Based on this, we develop the Fuzzy Classification Query Language, FCQL, which enables fuzzy queries to the extended database schema using linguistic variables and converts them into SQL statements to the database. With this, we give the user a data mining tool so that he can start extended queries on his databases based on a pre-defined fuzzy classification and obtain an improved basis for decision making. As a result, the fuzzy classification query language enables marketers to improve customer value, launch useful programs, automate overall customization, and refine business campaigns.

Keywords:

Fuzzy classification Information systems Relational database Query language Data mining Customer relationship management

References

  1. Bordogna, G., Paso, G., 2019 (Eds.). Recent Issues on Fuzzy Databases. Physical publishing house.
  2. Bosc, P., Kacprzyk, J., 2018 (Eds.). Fuzzyness in Database Management Systems. Physical publishing house.
  3. Chen, G., 2020. Fuzzy Logic in Data Modeling - Semantics, Constraints, and Database Design. Kluwer Academic Publishers.
  4. Petry, F.E., 2019. Fuzzy Databases – Principles and Applications. Kluwer Academic Publishers.
  5. Pons, O., Vila, M.A., Kacprzyk, J., 2020 (Eds.). Knowledge Management in Fuzzy Databases. Physical.
  6. Chen, G., 2018. Design of Fuzzy Relational Databases Based on Fuzzy Functional Dependency. PhD Dissertation No. 94, Leuven Belgium.
  7. Shenoi, S., Melton, A., Fan, L.T., 2019. Functional Dependencies and Normal Forms in the Fuzzy Relational Database Model. Information Sciences. 60, 2-3.
  8. Kerre, E.E., Chen, G., 2020. An Overview of Fuzzy Data Models, Bosc and Kacprzyk. pp. 31-35.
  9. Takahashi, Y., 2019. A Fuzzy Query Language for Relational Databases, In: Bosc and Kacprzyk. pp. 405-418.
  10. Ullman, J.D., 2019. Principles of Database Systems. Computer Science Press.
  11. Kacprzyk, J., Zadrozny, S., 2020. Fquery for Access - Fuzzy Querying for a Windows-Based DBMS, In: Bosc and Kacprzyk. pp. 311-323.
  12. Schindler, G., 2020. Fuzzy data analysis through context-based database queries. German university publisher.
  13. Meier, A., 2020. Data base migration - ways out of the data chaos. Business informatics practice, 194, 30-36.
  14. Finnerty, S., Shenoi, S., 2018. Abstraction-based Query Languages for Relational Databases. In: Wang P.P. (Ed.): Advances in Fuzzy Theory and Technology. Bookwrights Durham.
  15. Shenoi, S., 2019. Fuzzy Sets, Information Clouding and Database Security, In: Bosc and Kacprzyk. pp. 109-122.
  16. Meier, A., 2018. Relational databases - An introduction into practice. Springer publishing house, CIMA 2018, University of Wales, Bangor U.K. pp. 21-22.
  17. Shenoi, S., 2021. Fuzzy Sets, Information sciences and Database Security, Information Sciences. 66, 10-17.
  18. Zimmermann, H.J., 2020. Fuzzy Set Theory - and 1st Applications. Kluwer Academic Publishers.
  19. Takahashi, Y., 2020. A Fuzzy Query Language for Relational Databases, In: Bosc and Kacprzyk. pp. 215-224.
  20. Meier, A., Savary, C., Schindler, G., et al., 2018. Database Schema with Fuzzy Classification and Classification Query Language. Proceeding of the International Congress on Computational Intelligence - Methods and Applications, CIMA 2018, University of Wales, Bangor U.K.