{"id":"https://openalex.org/W3136692092","doi":"https://doi.org/10.3233/jifs-202551","title":"Fuzzy querying with SQL: Fuzzy view-based approach","display_name":"Fuzzy querying with SQL: Fuzzy view-based approach","alternate_titles":[],"publication_year":2021,"publication_date":"2021-03-23","ids":{"openalex":"https://openalex.org/W3136692092","doi":"https://doi.org/10.3233/jifs-202551","mag":"3136692092"},"language":"en","primary_location":{"id":"doi:10.3233/jifs-202551","doi":"https://doi.org/10.3233/jifs-202551","is_oa":false,"landing_page_url":"https://doi.org/10.3233/jifs-202551","pdf_url":null,"source":{"id":"https://openalex.org/S179157397","display_name":"Journal of Intelligent & Fuzzy Systems","issn_l":"1064-1246","issn":["1064-1246","1875-8967"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core","poland-70","russia-white-list-2"],"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Intelligent &amp; Fuzzy Systems","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W3136692092"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5026276031","display_name":"Rachid Mama","orcid":"https://orcid.org/0000-0002-3996-0063","observed_orcids":["https://orcid.org/0000-0002-3996-0063"]},"institutions":[{"id":"https://openalex.org/I4210088687","display_name":"Universit\u00e9 Ibn Zohr","ror":"https://ror.org/006sgpv47","country_code":"MA","type":"education","lineage":["https://openalex.org/I4210088687"]}],"countries":["MA"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Rachid Mama","raw_affiliation_strings":["Ibn Zohr University, Faculty of Sciences, Information Systems and Vision Laboratory, Agadir, Morocco"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ibn Zohr University, Faculty of Sciences, Information Systems and Vision Laboratory, Agadir, Morocco","institution_ids":["https://openalex.org/I4210088687"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5064529557","display_name":"Mustapha Machkour","orcid":"https://orcid.org/0000-0003-4515-6589","observed_orcids":["https://orcid.org/0000-0003-4515-6589"]},"institutions":[{"id":"https://openalex.org/I4210088687","display_name":"Universit\u00e9 Ibn Zohr","ror":"https://ror.org/006sgpv47","country_code":"MA","type":"education","lineage":["https://openalex.org/I4210088687"]}],"countries":["MA"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Mustapha Machkour","raw_affiliation_strings":["Ibn Zohr University, Faculty of Sciences, Information Systems and Vision Laboratory, Agadir, Morocco"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ibn Zohr University, Faculty of Sciences, Information Systems and Vision Laboratory, Agadir, Morocco","institution_ids":["https://openalex.org/I4210088687"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5026276031"],"corresponding_institution_ids":["https://openalex.org/I4210088687"],"apc_list":{"value":4150,"currency":"USD","value_usd":4150},"apc_paid":null,"fwci":1.0758,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.78797856,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":92,"max":97},"biblio":{"volume":"40","issue":"5","first_page":"9937","last_page":"9948"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9932000041007996,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9932000041007996,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10820","display_name":"Fuzzy Logic and Control Systems","score":0.0026000000070780516,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.0010000000474974513,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/fuzzy-querying","display_name":"fuzzy querying","score":0.9279999732971191},{"id":"https://openalex.org/keywords/fuzzy-predicates","display_name":"fuzzy predicates","score":0.8619999885559082},{"id":"https://openalex.org/keywords/fuzzy-quantifiers","display_name":"fuzzy quantifiers","score":0.9980000257492065},{"id":"https://openalex.org/keywords/query-execution-performance","display_name":"query execution performance","score":0.6700000166893005},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.6069999933242798}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8331139087677002},{"id":"https://openalex.org/C58166","wikidata":"https://www.wikidata.org/wiki/Q224821","display_name":"Fuzzy logic","level":2,"score":0.6664859652519226},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6454054117202759},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.5537183284759521},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5138883590698242},{"id":"https://openalex.org/C2777026412","wikidata":"https://www.wikidata.org/wiki/Q2684591","display_name":"Statement (logic)","level":2,"score":0.5026962757110596},{"id":"https://openalex.org/C148671577","wikidata":"https://www.wikidata.org/wiki/Q5511133","display_name":"Fuzzy set operations","level":4,"score":0.4459196925163269},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.43048563599586487},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4261783957481384},{"id":"https://openalex.org/C127385683","wikidata":"https://www.wikidata.org/wiki/Q1475696","display_name":"Fuzzy classification","level":4,"score":0.4220137298107147},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.38179925084114075},{"id":"https://openalex.org/C42011625","wikidata":"https://www.wikidata.org/wiki/Q1055058","display_name":"Fuzzy set","level":3,"score":0.3719790577888489},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.37070026993751526},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3133309483528137},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.14438432455062866},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07973521947860718},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.3233/jifs-202551","doi":"https://doi.org/10.3233/jifs-202551","is_oa":false,"landing_page_url":"https://doi.org/10.3233/jifs-202551","pdf_url":null,"source":{"id":"https://openalex.org/S179157397","display_name":"Journal of Intelligent & Fuzzy Systems","issn_l":"1064-1246","issn":["1064-1246","1875-8967"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core","poland-70","russia-white-list-2"],"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Intelligent &amp; Fuzzy Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W1923878677","https://openalex.org/W1967596639","https://openalex.org/W1978923950","https://openalex.org/W2022954591","https://openalex.org/W2033072900","https://openalex.org/W2072960837","https://openalex.org/W2074622901","https://openalex.org/W2088860063","https://openalex.org/W2123474039","https://openalex.org/W2126884948","https://openalex.org/W2129398837","https://openalex.org/W2524175677","https://openalex.org/W4230588984"],"related_works":["https://openalex.org/W1005320166","https://openalex.org/W2048795085","https://openalex.org/W4294215074","https://openalex.org/W2965706512","https://openalex.org/W2087409782","https://openalex.org/W2373754315","https://openalex.org/W2105209941","https://openalex.org/W2495958003","https://openalex.org/W196514212","https://openalex.org/W2123474039"],"abstract_inverted_index":{"Nowadays":[0],"several":[1],"works":[2],"have":[3,65],"been":[4],"proposed":[5,66],"that":[6],"allow":[7,78],"users":[8],"to":[9,27,43,57,72,77,80,96,100,106,140,162,166,185],"perform":[10],"fuzzy":[11,30,45,108,130,144,149,151,153,168,190],"queries":[12,86],"on":[13,22],"relational":[14],"databases.":[15],"But":[16],"most":[17,143],"of":[18,36,111,127,174,181,189],"these":[19],"systems":[20],"based":[21],"an":[23,49],"additional":[24],"software":[25],"layer":[26,35],"translate":[28],"a":[29,33,37,60,67,98,129,159,175],"query":[31,131,191],"and":[32,69],"supplementary":[34],"classic":[38],"database":[39],"management":[40],"system":[41],"(DBMS)":[42],"evaluate":[44],"predicates,":[46,109],"which":[47],"induces":[48],"important":[50],"overhead.":[51],"They":[52],"are":[53],"not":[54],"also":[55],"easy":[56,165],"implement":[58],"by":[59],"non-expert":[61],"user.":[62],"Here":[63],"we":[64,157],"simple":[68],"intelligent":[70],"approach":[71,137],"extend":[73],"the":[74,88,102,121,124,187],"SQL":[75],"language":[76],"us":[79,139],"write":[81],"flexible":[82],"conditions":[83],"in":[84,120,171],"our":[85],"without":[87],"need":[89],"for":[90],"translation.":[91],"The":[92,178],"main":[93,179],"idea":[94],"is":[95,184],"use":[97,167],"view":[99],"manipulate":[101],"satisfaction":[103],"degrees":[104],"related":[105],"user-defined":[107],"instead":[110],"calculating":[112],"them":[113],"at":[114],"runtime":[115],"employing":[116],"user":[117],"functions":[118],"embedded":[119],"query.":[122],"Consequently,":[123],"response":[125],"time":[126],"executing":[128],"statement":[132],"will":[133],"be":[134],"reduced.":[135],"This":[136],"allows":[138],"easily":[141],"integrate":[142],"request":[145],"characters":[146],"such":[147],"as":[148],"modifiers,":[150],"quantifiers,":[152],"joins,":[154],"etc.":[155],"Moreover,":[156],"present":[158],"user-friendly":[160],"interface":[161],"make":[163],"it":[164],"linguistic":[169],"values":[170],"all":[172],"clauses":[173],"select":[176],"statement.":[177],"contribution":[180],"this":[182],"paper":[183],"accelerate":[186],"execution":[188],"statements.":[192]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3136692092","counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":2}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2021-03-29T00:00:00"}
