{"id":"https://openalex.org/W3153008428","doi":"https://doi.org/10.4018/ijdwm.2021040102","title":"Frameworks for Querying Databases Using Natural Language","display_name":"Frameworks for Querying Databases Using Natural Language","publication_year":2021,"publication_date":"2021-04-01","ids":{"openalex":"https://openalex.org/W3153008428","doi":"https://doi.org/10.4018/ijdwm.2021040102","mag":"3153008428"},"language":"en","primary_location":{"id":"doi:10.4018/ijdwm.2021040102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijdwm.2021040102","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},"type":"article","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/A5076999947","display_name":"Syed Ahmad Chan Bukhari","orcid":"https://orcid.org/0000-0002-6517-5261"},"institutions":[{"id":"https://openalex.org/I142823887","display_name":"St. John's University","ror":"https://ror.org/00bgtad15","country_code":"US","type":"education","lineage":["https://openalex.org/I142823887"]},{"id":"https://openalex.org/I2801299839","display_name":"Collins College","ror":"https://ror.org/03rb26y64","country_code":"US","type":"education","lineage":["https://openalex.org/I2801299839"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Syed Ahmad Chan Bukhari","raw_affiliation_strings":["Division of Computer Science, Mathematics and Science, Collins College of Professional Studies, St. John's University, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Division of Computer Science, Mathematics and Science, Collins College of Professional Studies, St. John's University, USA","institution_ids":["https://openalex.org/I2801299839","https://openalex.org/I142823887"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058271263","display_name":"Hafsa Shareef Dar","orcid":"https://orcid.org/0000-0003-4538-6632"},"institutions":[{"id":"https://openalex.org/I99165933","display_name":"University of Gujrat","ror":"https://ror.org/01xe5fb92","country_code":"PK","type":"education","lineage":["https://openalex.org/I99165933"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"Hafsa Shareef Dar","raw_affiliation_strings":["University of Gujrat, Pakistan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Gujrat, Pakistan","institution_ids":["https://openalex.org/I99165933"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027030046","display_name":"M. Ikram Ullah Lali","orcid":"https://orcid.org/0000-0003-2208-5853"},"institutions":[{"id":"https://openalex.org/I3130814776","display_name":"University of Okara","ror":"https://ror.org/02fmg6q11","country_code":"PK","type":"education","lineage":["https://openalex.org/I3130814776"]}],"countries":["PK"],"is_corresponding":false,"raw_author_name":"M. Ikramullah Lali","raw_affiliation_strings":["University of Education Lahore, Pakistan"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Education Lahore, Pakistan","institution_ids":["https://openalex.org/I3130814776"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017876645","display_name":"Fazel Keshtkar","orcid":"https://orcid.org/0000-0002-7022-6238"},"institutions":[{"id":"https://openalex.org/I142823887","display_name":"St. John's University","ror":"https://ror.org/00bgtad15","country_code":"US","type":"education","lineage":["https://openalex.org/I142823887"]},{"id":"https://openalex.org/I2801299839","display_name":"Collins College","ror":"https://ror.org/03rb26y64","country_code":"US","type":"education","lineage":["https://openalex.org/I2801299839"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Fazel Keshtkar","raw_affiliation_strings":["Division of Computer Science, Mathematics and Science, Collins College of Professional Studies, St. John's University, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Division of Computer Science, Mathematics and Science, Collins College of Professional Studies, St. John's University, USA","institution_ids":["https://openalex.org/I2801299839","https://openalex.org/I142823887"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024102795","display_name":"Khalid Mahmood Malik","orcid":"https://orcid.org/0000-0002-7927-3436"},"institutions":[{"id":"https://openalex.org/I177721651","display_name":"Oakland University","ror":"https://ror.org/01ythxj32","country_code":"US","type":"education","lineage":["https://openalex.org/I177721651"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Khalid Mahmood Malik","raw_affiliation_strings":["Computer Science and Engineering Department, Oakland University, USA"],"raw_orcid":"https://orcid.org/0000-0002-7927-3436","affiliations":[{"raw_affiliation_string":"Computer Science and Engineering Department, Oakland University, USA","institution_ids":["https://openalex.org/I177721651"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5002855381","display_name":"Seifedine Kadry","orcid":"https://orcid.org/0000-0002-1939-4842"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Seifedine Kadry","raw_affiliation_strings":["Faculty of Applied Computing and Technology, Noroff University College, Kristiansand, Norway"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Applied Computing and Technology, Noroff University College, Kristiansand, Norway","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5076999947"],"corresponding_institution_ids":["https://openalex.org/I142823887","https://openalex.org/I2801299839"],"apc_list":null,"apc_paid":null,"fwci":1.3998,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.84633456,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"17","issue":"2","first_page":"21","last_page":"38"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9987000226974487,"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"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9987000226974487,"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/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.992900013923645,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.983299970626831,"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/computer-science","display_name":"Computer science","score":0.9158884882926941},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7283273339271545},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.6015135645866394},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.6011769771575928},{"id":"https://openalex.org/keywords/scope","display_name":"Scope (computer science)","score":0.5586745738983154},{"id":"https://openalex.org/keywords/natural-language-user-interface","display_name":"Natural language user interface","score":0.5536627173423767},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5288195013999939},{"id":"https://openalex.org/keywords/interoperability","display_name":"Interoperability","score":0.5199936032295227},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.49718645215034485},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49536287784576416},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.43789252638816833},{"id":"https://openalex.org/keywords/interface","display_name":"Interface (matter)","score":0.41952186822891235},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3534146845340729},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.3436307907104492},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.27510613203048706},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.23348268866539001},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.15000596642494202},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.09024521708488464}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9158884882926941},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7283273339271545},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.6015135645866394},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.6011769771575928},{"id":"https://openalex.org/C2778012447","wikidata":"https://www.wikidata.org/wiki/Q1034415","display_name":"Scope (computer science)","level":2,"score":0.5586745738983154},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.5536627173423767},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5288195013999939},{"id":"https://openalex.org/C20136886","wikidata":"https://www.wikidata.org/wiki/Q749647","display_name":"Interoperability","level":2,"score":0.5199936032295227},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.49718645215034485},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49536287784576416},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.43789252638816833},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.41952186822891235},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3534146845340729},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.3436307907104492},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.27510613203048706},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.23348268866539001},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.15000596642494202},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.09024521708488464},{"id":"https://openalex.org/C129307140","wikidata":"https://www.wikidata.org/wiki/Q6795880","display_name":"Maximum bubble pressure method","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.0},{"id":"https://openalex.org/C157915830","wikidata":"https://www.wikidata.org/wiki/Q2928001","display_name":"Bubble","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/ijdwm.2021040102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijdwm.2021040102","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:17:y:2021:i:2:p:21-38","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJDWM.2021040102","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.7300000190734863}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W1982363712","https://openalex.org/W1996791708","https://openalex.org/W2036935277","https://openalex.org/W2041480186","https://openalex.org/W2046006386","https://openalex.org/W2109070394","https://openalex.org/W2123036291","https://openalex.org/W2145618437","https://openalex.org/W2157157278","https://openalex.org/W2164155814","https://openalex.org/W2169818249","https://openalex.org/W2243052854","https://openalex.org/W2269738476","https://openalex.org/W2337398535","https://openalex.org/W2395796721","https://openalex.org/W2417032668","https://openalex.org/W2751045246","https://openalex.org/W2766718178","https://openalex.org/W2783913357","https://openalex.org/W2793326597","https://openalex.org/W2799420201"],"related_works":["https://openalex.org/W2897196530","https://openalex.org/W2161109697","https://openalex.org/W1620951616","https://openalex.org/W2052826252","https://openalex.org/W2013349486","https://openalex.org/W2031915568","https://openalex.org/W3116557709","https://openalex.org/W2970853428","https://openalex.org/W3036348878","https://openalex.org/W4388525956"],"abstract_inverted_index":{"A":[0],"natural":[1,44,139],"language":[2,26,45,140,147],"interface":[3],"is":[4,103],"useful":[5],"for":[6,47],"a":[7],"wide":[8],"range":[9],"of":[10,23,32,43,59,100,108,115,121,134],"users":[11],"to":[12,142,149],"retrieve":[13],"their":[14],"desired":[15],"information":[16],"from":[17],"databases":[18],"without":[19],"requiring":[20],"prior":[21],"knowledge":[22],"database":[24],"query":[25],"such":[27,35,110],"as":[28,36,111],"SQL.":[29],"The":[30,128],"advent":[31],"user-friendly":[33],"technologies,":[34],"speech-enabled":[37],"interfaces,":[38],"have":[39,78,83],"revived":[40],"the":[41,51,60,76,87,92,98,106,122,132],"use":[42],"technology":[46],"querying":[48],"databases;":[49],"however,":[50],"most":[52],"relevant":[53],"and":[54,67,90,94,124,144],"last":[55,88],"work":[56],"presenting":[57],"state":[58],"art":[61],"was":[62],"published":[63],"back":[64],"in":[65],"2013":[66],"does":[68],"not":[69],"encompass":[70],"several":[71],"advancements.":[72],"In":[73],"this":[74],"paper,":[75],"authors":[77],"reviewed":[79],"47":[80],"frameworks":[81,102,135],"that":[82,131],"been":[84],"developed":[85],"during":[86],"decade":[89],"categorized":[91],"SQL":[93,143],"NoSQL-based":[95],"frameworks.":[96],"Furthermore,":[97],"analysis":[99],"these":[101],"presented":[104],"on":[105,137],"basis":[107],"criteria":[109],"supporting":[112],"language,":[113],"scheme":[114],"heuristic":[116],"rules,":[117],"interoperability":[118],"support,":[119],"scope":[120],"dataset,":[123],"overall":[125],"performance":[126],"score.":[127],"study":[129],"concludes":[130],"majority":[133],"focus":[136],"translating":[138],"queries":[141],"translates":[145],"English":[146],"text":[148],"queries.":[150]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2021-04-26T00:00:00"}