乐胖代购免代理版

{"id":"https://openalex.org/W3114457612","doi":"https://doi.org/10.1145/3430984.3431046","title":"ACL-SQL: Generating SQL Queries from Natural Language","display_name":"ACL-SQL: Generating SQL Queries from Natural Language","publication_year":2020,"publication_date":"2020-12-28","ids":{"openalex":"https://openalex.org/W3114457612","doi":"https://doi.org/10.1145/3430984.3431046","mag":"3114457612"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/3430984.3431046","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-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/A5010096373","display_name":"Ronak Kaoshik","orcid":null},"institutions":[{"id":"https://openalex.org/I27674431","display_name":"Indian Institute of Technology Gandhinagar","ror":"https://ror.org/0036p5w23","country_code":"IN","type":"funder","lineage":["https://openalex.org/I27674431"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Ronak Kaoshik","raw_affiliation_strings":["Indian Institute of Technology Gandhinagar, India"],"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Gandhinagar, India","institution_ids":["https://openalex.org/I27674431"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015908756","display_name":"Rohit Patil","orcid":"https://orcid.org/0000-0002-2214-1811"},"institutions":[{"id":"https://openalex.org/I27674431","display_name":"Indian Institute of Technology Gandhinagar","ror":"https://ror.org/0036p5w23","country_code":"IN","type":"funder","lineage":["https://openalex.org/I27674431"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Rohit Patil","raw_affiliation_strings":["Indian Institute of Technology Gandhinagar, India"],"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Gandhinagar, India","institution_ids":["https://openalex.org/I27674431"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037078690","display_name":"Rishi Prakash","orcid":null},"institutions":[{"id":"https://openalex.org/I27674431","display_name":"Indian Institute of Technology Gandhinagar","ror":"https://ror.org/0036p5w23","country_code":"IN","type":"funder","lineage":["https://openalex.org/I27674431"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Prakash R","raw_affiliation_strings":["Indian Institute of Technology Gandhinagar, India"],"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Gandhinagar, India","institution_ids":["https://openalex.org/I27674431"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081239346","display_name":"Shaurya Agarawal","orcid":"https://orcid.org/0000-0003-0939-5291"},"institutions":[{"id":"https://openalex.org/I27674431","display_name":"Indian Institute of Technology Gandhinagar","ror":"https://ror.org/0036p5w23","country_code":"IN","type":"funder","lineage":["https://openalex.org/I27674431"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Shaurya Agarawal","raw_affiliation_strings":["Indian Institute of Technology Gandhinagar, India"],"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Gandhinagar, India","institution_ids":["https://openalex.org/I27674431"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101640007","display_name":"Naman Jain","orcid":"https://orcid.org/0009-0004-4262-0555"},"institutions":[{"id":"https://openalex.org/I27674431","display_name":"Indian Institute of Technology Gandhinagar","ror":"https://ror.org/0036p5w23","country_code":"IN","type":"funder","lineage":["https://openalex.org/I27674431"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Naman Jain","raw_affiliation_strings":["Indian Institute of Technology Gandhinagar, India"],"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Gandhinagar, India","institution_ids":["https://openalex.org/I27674431"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100746900","display_name":"Mayank Singh","orcid":"https://orcid.org/0000-0001-8757-2623"},"institutions":[{"id":"https://openalex.org/I27674431","display_name":"Indian Institute of Technology Gandhinagar","ror":"https://ror.org/0036p5w23","country_code":"IN","type":"funder","lineage":["https://openalex.org/I27674431"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Mayank Singh","raw_affiliation_strings":["Indian Institute of Technology Gandhinagar, India"],"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Gandhinagar, India","institution_ids":["https://openalex.org/I27674431"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.51,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.587037,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":76,"max":79},"biblio":{"volume":null,"issue":null,"first_page":"423","last_page":"423"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9985,"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.9985,"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/T11719","display_name":"Data Quality and Management","score":0.9964,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.995,"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/data-definition-language","display_name":"Data definition language","score":0.670631},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.5781021},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5657887},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.53027046},{"id":"https://openalex.org/keywords/null","display_name":"Null (SQL)","score":0.467148}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8916731},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.87150216},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.72861767},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.670631},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5781021},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5657887},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.5540428},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5471347},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.53027046},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.467148},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.46338925},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42458346},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.36566794},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.11642638},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.11151782},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/3430984.3431046","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality education","score":0.75,"id":"https://metadata.un.org/sdg/4"}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":3,"referenced_works":["https://openalex.org/W2890431379","https://openalex.org/W2896457183","https://openalex.org/W3016611451"],"related_works":["https://openalex.org/W650213220","https://openalex.org/W4388053677","https://openalex.org/W3097122560","https://openalex.org/W2974218799","https://openalex.org/W2373982268","https://openalex.org/W2340883001","https://openalex.org/W20807724","https://openalex.org/W1980548249","https://openalex.org/W1592149428","https://openalex.org/W151494989"],"abstract_inverted_index":{"Relational":[0],"databases":[1],"are":[2,36,95],"prevalent":[3],"in":[4,51],"handling":[5],"large":[6],"and":[7,68,84,93],"complex":[8,60],"databases;":[9],"however,":[10],"writing":[11],"the":[12,26,46,70],"SQL":[13,34],"queries":[14,40,61],"can":[15,85],"be":[16,86],"a":[17,57,73],"tedious":[18],"task":[19,27],"for":[20,24,88],"databases.":[21],"Recent":[22],"studies":[23],"automating":[25],"of":[28,48],"translating":[29],"natural":[30],"language":[31],"text":[32],"to":[33,39,65],"query":[35],"not":[37],"robust":[38],"having":[41],"multi-table":[42],"dependencies.":[43],"Also,":[44],"considering":[45],"lack":[47],"such":[49],"research":[50],"scientific":[52],"domain,":[53],"we":[54],"introduce":[55],"ACL-SQL,":[56],"dataset":[58,71,92],"with":[59],"depending":[62],"on":[63,72],"up":[64],"five":[66],"tables":[67],"benchmark":[69],"simple":[74],"approach.":[75],"Evaluation":[76],"shows":[77],"that":[78],"our":[79],"approach":[80],"is":[81],"reasonably":[82],"precise":[83],"adopted":[87],"practical":[89],"applications.":[90],"The":[91],"codes":[94],"available":[96],"at":[97],"https://github.com/rohitshantarampatil/sql-nlp.":[98]},"abstract_inverted_index_v3":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W3114457612","counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3}],"updated_date":"2025-03-24T22:10:52.106389","created_date":"2021-01-05"}