{"id":"https://openalex.org/W2783017957","doi":"https://doi.org/10.1007/978-3-319-71008-2_31","title":"Translation of Natural Language Queries to SQL that Involve Aggregate Functions, Grouping and Subqueries for a Natural Language Interface to Databases","display_name":"Translation of Natural Language Queries to SQL that Involve Aggregate Functions, Grouping and Subqueries for a Natural Language Interface to Databases","publication_year":2018,"publication_date":"2018-01-01","ids":{"openalex":"https://openalex.org/W2783017957","doi":"https://doi.org/10.1007/978-3-319-71008-2_31","mag":"2783017957"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-319-71008-2_31","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-319-71008-2_31","pdf_url":null,"source":{"id":"https://openalex.org/S2764461748","display_name":"Studies in computational intelligence","issn_l":"1860-949X","issn":["1860-949X","1860-9503"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319965","host_organization_name":"Springer Nature","host_organization_lineage":["https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Computational Intelligence","raw_type":"book-chapter"},"type":"book-chapter","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":[{"id":"https://openalex.org/I177400693","display_name":"Instituto Tecnol\u00f3gico de Ciudad Madero","ror":"https://ror.org/04cymm537","country_code":"MX","type":"education","lineage":["https://openalex.org/I1302736544","https://openalex.org/I177400693","https://openalex.org/I4210090124","https://openalex.org/I4405258672"]}],"countries":["MX"],"is_corresponding":true,"raw_author_name":"Rodolfo A. Pazos R.","raw_affiliation_strings":["Instituto Tecnol\u00f3gico de Ciudad Madero, Ciudad Madero, Mexico"],"affiliations":[{"raw_affiliation_string":"Instituto Tecnol\u00f3gico de Ciudad Madero, Ciudad Madero, Mexico","institution_ids":["https://openalex.org/I177400693"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059136655","display_name":"Andres A. Verastegui","orcid":null},"institutions":[{"id":"https://openalex.org/I177400693","display_name":"Instituto Tecnol\u00f3gico de Ciudad Madero","ror":"https://ror.org/04cymm537","country_code":"MX","type":"education","lineage":["https://openalex.org/I1302736544","https://openalex.org/I177400693","https://openalex.org/I4210090124","https://openalex.org/I4405258672"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Andres A. Verastegui","raw_affiliation_strings":["Instituto Tecnol\u00f3gico de Ciudad Madero, Ciudad Madero, Mexico"],"affiliations":[{"raw_affiliation_string":"Instituto Tecnol\u00f3gico de Ciudad Madero, Ciudad Madero, Mexico","institution_ids":["https://openalex.org/I177400693"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079496769","display_name":"Jos\u00e9 A. Mart\u00ednez F.","orcid":null},"institutions":[{"id":"https://openalex.org/I177400693","display_name":"Instituto Tecnol\u00f3gico de Ciudad Madero","ror":"https://ror.org/04cymm537","country_code":"MX","type":"education","lineage":["https://openalex.org/I1302736544","https://openalex.org/I177400693","https://openalex.org/I4210090124","https://openalex.org/I4405258672"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 A. Mart\u00ednez F.","raw_affiliation_strings":["Instituto Tecnol\u00f3gico de Ciudad Madero, Ciudad Madero, Mexico"],"affiliations":[{"raw_affiliation_string":"Instituto Tecnol\u00f3gico de Ciudad Madero, Ciudad Madero, Mexico","institution_ids":["https://openalex.org/I177400693"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012122073","display_name":"Mart\u00edn Carpio","orcid":"https://orcid.org/0000-0002-1191-2676"},"institutions":[{"id":"https://openalex.org/I4210128463","display_name":"Instituto Tecnol\u00f3gico de Le\u00f3n","ror":"https://ror.org/02zmh8h66","country_code":"MX","type":"education","lineage":["https://openalex.org/I4210128463"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Martin Carpio","raw_affiliation_strings":["Instituto Tecnol\u00f3gico de Le\u00f3n, Le\u00f3n, Mexico"],"affiliations":[{"raw_affiliation_string":"Instituto Tecnol\u00f3gico de Le\u00f3n, Le\u00f3n, Mexico","institution_ids":["https://openalex.org/I4210128463"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049578379","display_name":"Juana Gaspar H.","orcid":null},"institutions":[{"id":"https://openalex.org/I177400693","display_name":"Instituto Tecnol\u00f3gico de Ciudad Madero","ror":"https://ror.org/04cymm537","country_code":"MX","type":"education","lineage":["https://openalex.org/I1302736544","https://openalex.org/I177400693","https://openalex.org/I4210090124","https://openalex.org/I4405258672"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Juana Gaspar H.","raw_affiliation_strings":["Instituto Tecnol\u00f3gico de Ciudad Madero, Ciudad Madero, Mexico"],"affiliations":[{"raw_affiliation_string":"Instituto Tecnol\u00f3gico de Ciudad Madero, Ciudad Madero, Mexico","institution_ids":["https://openalex.org/I177400693"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5109842105"],"corresponding_institution_ids":["https://openalex.org/I177400693"],"apc_list":null,"apc_paid":null,"fwci":2.1709,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.85950142,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"431","last_page":"448"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9674000144004822,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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.9674000144004822,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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.9142000079154968,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8251216411590576},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7848488092422485},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.7177240252494812},{"id":"https://openalex.org/keywords/interface","display_name":"Interface (matter)","score":0.6387391090393066},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.6064329147338867},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5290155410766602},{"id":"https://openalex.org/keywords/natural-language-user-interface","display_name":"Natural language user interface","score":0.517806887626648},{"id":"https://openalex.org/keywords/natural","display_name":"Natural (archaeology)","score":0.4855365753173828},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.45277833938598633},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.28783118724823}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8251216411590576},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7848488092422485},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.7177240252494812},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.6387391090393066},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.6064329147338867},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5290155410766602},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.517806887626648},{"id":"https://openalex.org/C2776608160","wikidata":"https://www.wikidata.org/wiki/Q4785462","display_name":"Natural (archaeology)","level":2,"score":0.4855365753173828},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.45277833938598633},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.28783118724823},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"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/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0},{"id":"https://openalex.org/C157915830","wikidata":"https://www.wikidata.org/wiki/Q2928001","display_name":"Bubble","level":2,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-3-319-71008-2_31","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-319-71008-2_31","pdf_url":null,"source":{"id":"https://openalex.org/S2764461748","display_name":"Studies in computational intelligence","issn_l":"1860-949X","issn":["1860-949X","1860-9503"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319965","host_organization_name":"Springer Nature","host_organization_lineage":["https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Computational Intelligence","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16","score":0.4699999988079071}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":3,"referenced_works":["https://openalex.org/W2096979215","https://openalex.org/W2172083664","https://openalex.org/W2343568937"],"related_works":["https://openalex.org/W1994489643","https://openalex.org/W2112751186","https://openalex.org/W2161924541","https://openalex.org/W1968262010","https://openalex.org/W3036268427","https://openalex.org/W3158218201","https://openalex.org/W1550490297","https://openalex.org/W2151818261","https://openalex.org/W2183574112","https://openalex.org/W2159231020"],"abstract_inverted_index":null,"counts_by_year":[{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}