{"id":"https://openalex.org/W2032374895","doi":"https://doi.org/10.1145/2588555.2594519","title":"NaLIR","display_name":"NaLIR","publication_year":2014,"publication_date":"2014-06-18","ids":{"openalex":"https://openalex.org/W2032374895","doi":"https://doi.org/10.1145/2588555.2594519","mag":"2032374895"},"language":"en","primary_location":{"id":"doi:10.1145/2588555.2594519","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2594519","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-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/A5100740268","display_name":"Li Fei","orcid":"https://orcid.org/0000-0001-7427-0730"},"institutions":[{"id":"https://openalex.org/I27837315","display_name":"University of Michigan\u2013Ann Arbor","ror":"https://ror.org/00jmfr291","country_code":"US","type":"education","lineage":["https://openalex.org/I27837315"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Fei Li","raw_affiliation_strings":["University of Michigan, Ann Arbor, MI, USA"],"affiliations":[{"raw_affiliation_string":"University of Michigan, Ann Arbor, MI, USA","institution_ids":["https://openalex.org/I27837315"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5087012731","display_name":"H. V. Jagadish","orcid":null},"institutions":[{"id":"https://openalex.org/I27837315","display_name":"University of Michigan\u2013Ann Arbor","ror":"https://ror.org/00jmfr291","country_code":"US","type":"education","lineage":["https://openalex.org/I27837315"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hosagrahar V Jagadish","raw_affiliation_strings":["University of Michigan, Ann Arbor, MI, USA"],"affiliations":[{"raw_affiliation_string":"University of Michigan, Ann Arbor, MI, USA","institution_ids":["https://openalex.org/I27837315"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5100740268"],"corresponding_institution_ids":["https://openalex.org/I27837315"],"apc_list":null,"apc_paid":null,"fwci":10.1486,"has_fulltext":false,"cited_by_count":168,"citation_normalized_percentile":{"value":0.98175297,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"709","last_page":"712"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9997000098228455,"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.9997000098228455,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9976999759674072,"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.8975001573562622},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.7217504978179932},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6846708059310913},{"id":"https://openalex.org/keywords/usable","display_name":"USable","score":0.6474706530570984},{"id":"https://openalex.org/keywords/nesting","display_name":"Nesting (process)","score":0.6045231819152832},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5955554842948914},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5193708539009094},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4926767945289612},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4842100143432617},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.4768482446670532},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.46665334701538086},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.46227627992630005},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.32676637172698975},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.22687679529190063},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.20357590913772583},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.20324596762657166},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.10487237572669983}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8975001573562622},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7217504978179932},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6846708059310913},{"id":"https://openalex.org/C2780615836","wikidata":"https://www.wikidata.org/wiki/Q2471869","display_name":"USable","level":2,"score":0.6474706530570984},{"id":"https://openalex.org/C2776937656","wikidata":"https://www.wikidata.org/wiki/Q2229669","display_name":"Nesting (process)","level":2,"score":0.6045231819152832},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5955554842948914},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5193708539009094},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4926767945289612},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4842100143432617},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.4768482446670532},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.46665334701538086},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.46227627992630005},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32676637172698975},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.22687679529190063},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.20357590913772583},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.20324596762657166},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.10487237572669983},{"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/C191897082","wikidata":"https://www.wikidata.org/wiki/Q11467","display_name":"Metallurgy","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2588555.2594519","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2594519","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6299999952316284,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[{"id":"https://openalex.org/G5391396476","display_name":null,"funder_award_id":"IIS 1250880, IIS 1017296","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"}],"funders":[{"id":"https://openalex.org/F4320337389","display_name":"Division of Information and Intelligent Systems","ror":"https://ror.org/053a2cp42"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W1508977358","https://openalex.org/W1970709149","https://openalex.org/W1995320938","https://openalex.org/W1996791708","https://openalex.org/W2032299694","https://openalex.org/W2077556543","https://openalex.org/W2079372196","https://openalex.org/W2085828533","https://openalex.org/W2095026299","https://openalex.org/W2145618437","https://openalex.org/W2154268919","https://openalex.org/W2157749290","https://openalex.org/W2950584515","https://openalex.org/W6649077761"],"related_works":["https://openalex.org/W2098812463","https://openalex.org/W4247095193","https://openalex.org/W1548279772","https://openalex.org/W2897196530","https://openalex.org/W319014924","https://openalex.org/W2094438898","https://openalex.org/W2406556739","https://openalex.org/W2130043461","https://openalex.org/W2108100349","https://openalex.org/W1983721531"],"abstract_inverted_index":{"In":[0,56,92],"this":[1,57],"demo,":[2],"we":[3,59,94],"present":[4],"NaLIR,":[5,62],"a":[6,19,34,87],"generic":[7],"interactive":[8,100],"natural":[9],"language":[10,23],"interface":[11],"for":[12],"querying":[13],"relational":[14],"databases.":[15],"NaLIR":[16],"can":[17,102],"accept":[18],"logically":[20],"complex":[21,84],"English":[22],"sentence":[24],"as":[25],"query":[26,29],"input.":[27],"This":[28],"is":[30,73],"first":[31],"translated":[32],"into":[33],"SQL":[35],"query,":[36],"which":[37],"may":[38],"include":[39],"aggregation,":[40],"nesting,":[41],"and":[42,50,78],"various":[43],"types":[44],"of":[45,89],"joins,":[46],"among":[47],"other":[48],"things,":[49],"then":[51],"evaluated":[52],"against":[53],"an":[54],"RDBMS.":[55],"demonstration,":[58],"show":[60],"that":[61],"while":[63],"far":[64],"from":[65],"being":[66],"able":[67,79],"to":[68,80],"pass":[69],"the":[70],"Turing":[71],"test,":[72],"perfectly":[74],"usable":[75],"in":[76,86],"practice,":[77],"handle":[81],"even":[82],"quite":[83],"queries":[85],"variety":[88],"application":[90],"domains.":[91],"addition,":[93],"also":[95],"demonstrate":[96],"how":[97],"carefully":[98],"designed":[99],"communication":[101],"avoid":[103],"misinterpretation":[104],"with":[105],"minimum":[106],"user":[107],"burden.":[108]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":23},{"year":2024,"cited_by_count":13},{"year":2023,"cited_by_count":16},{"year":2022,"cited_by_count":8},{"year":2021,"cited_by_count":24},{"year":2020,"cited_by_count":19},{"year":2019,"cited_by_count":24},{"year":2018,"cited_by_count":16},{"year":2017,"cited_by_count":9},{"year":2016,"cited_by_count":8},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":1}],"updated_date":"2026-04-14T08:04:32.555800","created_date":"2016-06-24T00:00:00"}