TY - GEN
T1 - Systematic Translation of Fuzzy Semantic Model (FSM) RETRIEVE Queries to Standard ANSI SQL for Enhanced RDBMS Interoperability
AU - Brahmia, Zouhaier
AU - Ben Ahmed Daho, Asmaa
AU - Chakhar, Salem
AU - Younsi, Fatima-Zohra
PY - 2025/11/30
Y1 - 2025/11/30
N2 - The Fuzzy Semantic Model (FSM) provides a high-level RETRIEVE query language for managing data uncertainty, utilizing explicit Degree of Membership (d.o.m.) constraints for both entities and attributes. However, FSM's adoption is limited by its incompatibility with standard SQL, unlike prior fuzzy solutions that require proprietary extensions or lack the capacity for semantic structural mapping. We propose a systematic, phase-based algorithm for the complete translation of FSM RETRIEVE into standard ANSI SQL. Our algorithm formalizes two key mappings: (i) d.o.m. constraints (global and partial) are translated into crisp SQL predicates on dedicated columns; and (ii) complex attribute navigation (path expressions) is resolved into optimal primary key-foreign key joins. The resulting standard SQL queries ensure the preservation of FSM's integrity and allow FSM applications
AB - The Fuzzy Semantic Model (FSM) provides a high-level RETRIEVE query language for managing data uncertainty, utilizing explicit Degree of Membership (d.o.m.) constraints for both entities and attributes. However, FSM's adoption is limited by its incompatibility with standard SQL, unlike prior fuzzy solutions that require proprietary extensions or lack the capacity for semantic structural mapping. We propose a systematic, phase-based algorithm for the complete translation of FSM RETRIEVE into standard ANSI SQL. Our algorithm formalizes two key mappings: (i) d.o.m. constraints (global and partial) are translated into crisp SQL predicates on dedicated columns; and (ii) complex attribute navigation (path expressions) is resolved into optimal primary key-foreign key joins. The resulting standard SQL queries ensure the preservation of FSM's integrity and allow FSM applications
KW - Fuzzy Database
KW - Query Translation
KW - Fuzzy Semantic Model
KW - Standard SQL
KW - Object-Relational Mapping
M3 - Conference contribution
T3 - Springer Lecture Notes in Networks & Systems
BT - The 7th International Conference on Artificial Intelligence and Smart Environments (ICAISE'2025). November, 06-08 2025, Hammamet, Tunisia.
PB - Springer
ER -