Digital Technologies Research and Applications

For Fuzzy Classification of Databases with Fuzzy Classification Query Language

Seyfali Mahini (Islamic Azad University, Khoy Branch, Khoy, Iran)

Abstract


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

Full Text:

PDF

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.




DOI: https://doi.org/10.54963/dtra.v1i2.34

Refbacks

  • There are currently no refbacks.


Copyright (c) 2022 The author(s)

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