{"id":"https://openalex.org/W3014888006","doi":"https://doi.org/10.13053/cys-24-1-3313","title":"Algorithm for Processing Queries that Involve Boolean Columns for a Natural Language Interface to Databases","display_name":"Algorithm for Processing Queries that Involve Boolean Columns for a Natural Language Interface to Databases","publication_year":2020,"publication_date":"2020-03-30","ids":{"openalex":"https://openalex.org/W3014888006","doi":"https://doi.org/10.13053/cys-24-1-3313","mag":"3014888006"},"language":"en","primary_location":{"id":"doi:10.13053/cys-24-1-3313","is_oa":false,"landing_page_url":"https://doi.org/10.13053/cys-24-1-3313","pdf_url":null,"source":{"id":"https://openalex.org/S61446325","display_name":"Computaci\u00f3n y Sistemas","issn_l":"1405-5546","issn":["1405-5546","2007-9737"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319599","host_organization_name":"National Polytechnic Institute","host_organization_lineage":["https://openalex.org/P4310319599"],"host_organization_lineage_names":["National Polytechnic Institute"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computaci\u00f3n y Sistemas","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/A5109842105","display_name":"Rodolfo A. Pazos R.","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Rodolfo A. Pazos R.","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079496769","display_name":"Jos\u00e9 A. Mart\u00ednez F.","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jos\u00e9 A. Mart\u00ednez F.","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038764404","display_name":"Juan Javier Gonz\u00e1lez Barbosa","orcid":"https://orcid.org/0000-0002-3699-4436"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"J. Javier Gonzalez B.","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5064568374","display_name":"Andr\u00e9s A. Ver\u00e1stegui O.","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Andr\u00e9s A. Ver\u00e1stegui O.","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5109842105"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.03391652,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"24","issue":"1","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9994999766349792,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.9994999766349792,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9961000084877014,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9958999752998352,"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.7468516826629639},{"id":"https://openalex.org/keywords/boolean-conjunctive-query","display_name":"Boolean conjunctive query","score":0.6345778107643127},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.586354672908783},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5730219483375549},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.546345591545105},{"id":"https://openalex.org/keywords/natural-language-user-interface","display_name":"Natural language user interface","score":0.47095662355422974},{"id":"https://openalex.org/keywords/boolean-data-type","display_name":"Boolean data type","score":0.4644498825073242},{"id":"https://openalex.org/keywords/boolean-expression","display_name":"Boolean expression","score":0.4368163049221039},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3883568048477173},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.37985387444496155},{"id":"https://openalex.org/keywords/boolean-function","display_name":"Boolean function","score":0.3616366386413574},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.35885846614837646},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2998715043067932},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.2865867018699646},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.22742292284965515},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.21510735154151917},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.16600504517555237},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.14513996243476868}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7468516826629639},{"id":"https://openalex.org/C24755975","wikidata":"https://www.wikidata.org/wiki/Q4943354","display_name":"Boolean conjunctive query","level":5,"score":0.6345778107643127},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.586354672908783},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5730219483375549},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.546345591545105},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.47095662355422974},{"id":"https://openalex.org/C7342684","wikidata":"https://www.wikidata.org/wiki/Q520777","display_name":"Boolean data type","level":2,"score":0.4644498825073242},{"id":"https://openalex.org/C158465420","wikidata":"https://www.wikidata.org/wiki/Q1979515","display_name":"Boolean expression","level":3,"score":0.4368163049221039},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3883568048477173},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.37985387444496155},{"id":"https://openalex.org/C187455244","wikidata":"https://www.wikidata.org/wiki/Q942353","display_name":"Boolean function","level":2,"score":0.3616366386413574},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35885846614837646},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2998715043067932},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2865867018699646},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.22742292284965515},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.21510735154151917},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.16600504517555237},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.14513996243476868},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.13053/cys-24-1-3313","is_oa":false,"landing_page_url":"https://doi.org/10.13053/cys-24-1-3313","pdf_url":null,"source":{"id":"https://openalex.org/S61446325","display_name":"Computaci\u00f3n y Sistemas","issn_l":"1405-5546","issn":["1405-5546","2007-9737"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319599","host_organization_name":"National Polytechnic Institute","host_organization_lineage":["https://openalex.org/P4310319599"],"host_organization_lineage_names":["National Polytechnic Institute"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computaci\u00f3n y Sistemas","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","score":0.8199999928474426,"id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W37244022","https://openalex.org/W1978744359","https://openalex.org/W2165382777","https://openalex.org/W2172083664","https://openalex.org/W2343568937"],"related_works":["https://openalex.org/W91170459","https://openalex.org/W2329785533","https://openalex.org/W1620951616","https://openalex.org/W855579326","https://openalex.org/W2001465863","https://openalex.org/W2013349486","https://openalex.org/W2068300101","https://openalex.org/W4237975385","https://openalex.org/W2095222504","https://openalex.org/W2901081291"],"abstract_inverted_index":{"In":[0,116],"the":[1,4,17,34,70,83,100],"last":[2],"decades,":[3],"use":[5],"of":[6,19,28,99,163],"natural":[7,20,38],"language":[8,21,39],"interfaces":[9],"to":[10,41],"databases":[11,32],"(NLIDBs)":[12],"has":[13,22,104,109],"increased":[14],"exponentialy;":[15],"unfortunately,":[16],"complexity":[18],"limited":[23],"their":[24,144],"effectiveness.":[25],"The":[26,59,131,150],"presence":[27],"Boolean":[29,44,66,127,141],"columns":[30,75,128,142],"in":[31,82,94,147],"increases":[33],"difficulty":[35],"for":[36,61,73,122,159],"translating":[37,160],"queries":[40,63,124],"SQL.":[42],"A":[43,97],"column":[45,48],"is":[46,68,79,129,156],"a":[47,119,148],"that":[49,64,69,106,125,138,154],"can":[50],"only":[51],"store":[52],"two":[53],"possible":[54],"values:":[55],"true/false,":[56],"yes/no,":[57,77],"1/0.":[58],"problem":[60,86,108],"processing":[62,123],"involve":[65,126],"columns,":[67],"search":[71],"value":[72],"these":[74],"(true/false,":[76],"1/0)":[78],"not":[80,110],"explicit":[81],"queries.":[84,164],"This":[85],"makes":[87],"NLIDBs":[88,103],"generate":[89],"erroneous":[90],"translations":[91],"as":[92],"shown":[93,105],"experimental":[95,151],"tests.":[96],"survey":[98],"literature":[101],"on":[102],"this":[107,117,161],"been":[111],"identified,":[112],"much":[113],"less":[114],"addressed.":[115],"article,":[118],"new":[120],"algorithm":[121,132],"presented.":[130],"uses":[133],"syntactic":[134],"and":[135,143],"semantic":[136],"information":[137],"facilitates":[139],"detecting":[140],"implicit":[145],"values":[146],"query.":[149],"tests":[152],"show":[153],"it":[155],"highly":[157],"effective":[158],"type":[162]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-03-08T08:50:53.379069","created_date":"2025-10-10T00:00:00"}