{"id":"https://openalex.org/W4394007011","doi":"https://doi.org/10.48550/arxiv.2404.02933","title":"NL2KQL: From Natural Language to Kusto Query","display_name":"NL2KQL: From Natural Language to Kusto Query","publication_year":2024,"publication_date":"2024-04-03","ids":{"openalex":"https://openalex.org/W4394007011","doi":"https://doi.org/10.48550/arxiv.2404.02933"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2404.02933","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2404.02933","pdf_url":"https://arxiv.org/pdf/2404.02933","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2404.02933","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5113258509","display_name":"Xinye Tang","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Tang, Xinye","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020751192","display_name":"Amir H. Abdi","orcid":"https://orcid.org/0000-0002-3169-4477"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Abdi, Amir H.","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5076799188","display_name":"Jeremias Eichelbaum","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Eichelbaum, Jeremias","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109700044","display_name":"Mahan Das","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Das, Mahan","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101044074","display_name":"Alex Klein","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Klein, Alex","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5095094615","display_name":"Nihal Irmak Pakis","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Pakis, Nihal Irmak","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5095094616","display_name":"William Blum","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Blum, William","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079601649","display_name":"Daniel Mace","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mace, Daniel L","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5095094617","display_name":"Tanvi Raja","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Raja, Tanvi","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092513649","display_name":"Namrata Padmanabhan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Padmanabhan, Namrata","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5102672701","display_name":"Ye Xing","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xing, Ye","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":11,"corresponding_author_ids":["https://openalex.org/A5113258509"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"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.9769999980926514,"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.9769999980926514,"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.9767000079154968,"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.5348284244537354},{"id":"https://openalex.org/keywords/natural","display_name":"Natural (archaeology)","score":0.4771672785282135},{"id":"https://openalex.org/keywords/rdf-query-language","display_name":"RDF query language","score":0.46277961134910583},{"id":"https://openalex.org/keywords/linguistics","display_name":"Linguistics","score":0.4179956316947937},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.37445735931396484},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2574484944343567},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.2081894874572754},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.15415579080581665},{"id":"https://openalex.org/keywords/philosophy","display_name":"Philosophy","score":0.12549564242362976},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.0746857225894928},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.049795448780059814}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5348284244537354},{"id":"https://openalex.org/C2776608160","wikidata":"https://www.wikidata.org/wiki/Q4785462","display_name":"Natural (archaeology)","level":2,"score":0.4771672785282135},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.46277961134910583},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.4179956316947937},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.37445735931396484},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2574484944343567},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2081894874572754},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.15415579080581665},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.12549564242362976},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.0746857225894928},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.049795448780059814},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2404.02933","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2404.02933","pdf_url":"https://arxiv.org/pdf/2404.02933","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2404.02933","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2404.02933","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2404.02933","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2404.02933","pdf_url":"https://arxiv.org/pdf/2404.02933","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4394007011.pdf","grobid_xml":"https://content.openalex.org/works/W4394007011.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W2382290278","https://openalex.org/W2478288626","https://openalex.org/W4391913857","https://openalex.org/W2350741829","https://openalex.org/W2530322880"],"abstract_inverted_index":{"Data":[0],"is":[1,13,26,39,179,193,200],"growing":[2],"rapidly":[3],"in":[4,9,124],"volume":[5],"and":[6,53,114,121,163,181,199],"complexity.":[7],"Proficiency":[8],"database":[10,31,147],"query":[11,32,43,161,167],"languages":[12],"pivotal":[14],"for":[15,45,55,133,185],"crafting":[16],"effective":[17],"queries.":[18,81,126],"As":[19],"coding":[20],"assistants":[21],"become":[22],"more":[23],"prevalent,":[24],"there":[25],"significant":[27],"opportunity":[28],"to":[29,73,79,97,205],"enhance":[30],"languages.":[33],"The":[34,82],"Kusto":[35],"Query":[36,116],"Language":[37],"(KQL)":[38],"a":[40,111,131,145],"widely":[41],"used":[42,184],"language":[44,70,76],"large":[46,69,135],"semi-structured":[47],"data":[48,57],"such":[49],"as":[50],"logs,":[51],"telemetries,":[52],"time-series":[54],"big":[56],"analytics":[58],"platforms.":[59],"This":[60,191],"paper":[61],"introduces":[62],"NL2KQL":[63,84],"an":[64,155],"innovative":[65],"framework":[66,85,177],"that":[67],"uses":[68],"models":[71],"(LLMs)":[72],"convert":[74],"natural":[75],"queries":[77],"(NLQs)":[78],"KQL":[80,125],"proposed":[83],"includes":[86],"several":[87],"key":[88],"components:":[89],"Schema":[90],"Refiner":[91,117],"which":[92,105,118,141],"narrows":[93],"down":[94],"the":[95,102,115,173,182,194],"schema":[96],"its":[98,197,207],"most":[99],"pertinent":[100],"elements;":[101],"Few-shot":[103],"Selector":[104],"dynamically":[106],"selects":[107],"relevant":[108],"examples":[109],"from":[110],"few-shot":[112],"dataset;":[113],"repairs":[119],"syntactic":[120],"semantic":[122],"errors":[123],"Additionally,":[127],"this":[128],"study":[129],"outlines":[130],"method":[132],"generating":[134],"datasets":[136,183],"of":[137,157,175,196],"synthetic":[138],"NLQ-KQL":[139],"pairs":[140],"are":[142,187],"valid":[143],"within":[144],"specific":[146],"contexts.":[148],"To":[149],"validate":[150],"NL2KQL's":[151],"performance,":[152],"we":[153],"utilize":[154],"array":[156],"online":[158],"(based":[159,165],"on":[160,166],"execution)":[162],"offline":[164],"parsing)":[168],"metrics.":[169],"Through":[170],"ablation":[171],"studies,":[172],"significance":[174],"each":[176],"component":[178],"examined,":[180],"benchmarking":[186],"made":[188],"publicly":[189],"available.":[190],"work":[192],"first":[195],"kind":[198],"compared":[201],"with":[202],"available":[203],"baselines":[204],"demonstrate":[206],"effectiveness.":[208]},"counts_by_year":[],"updated_date":"2026-03-25T23:56:10.502304","created_date":"2024-04-06T00:00:00"}