{"id":"https://openalex.org/W4406461395","doi":"https://doi.org/10.1109/bigdata62323.2024.10825883","title":"EVOLVE: Evaluation of Language-to-SQL Validity and Effectiveness - A Detailed Review Framework for Complex Text-to-SQL Queries","display_name":"EVOLVE: Evaluation of Language-to-SQL Validity and Effectiveness - A Detailed Review Framework for Complex Text-to-SQL Queries","publication_year":2024,"publication_date":"2024-12-15","ids":{"openalex":"https://openalex.org/W4406461395","doi":"https://doi.org/10.1109/bigdata62323.2024.10825883"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata62323.2024.10825883","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata62323.2024.10825883","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE International Conference on Big Data (BigData)","raw_type":"proceedings-article"},"type":"review","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/A5002357067","display_name":"Raghu Katikeri","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Raghu Katikeri","raw_affiliation_strings":["State Street Corporation,Artificial Intelligence Group,Hyderabad,India"],"affiliations":[{"raw_affiliation_string":"State Street Corporation,Artificial Intelligence Group,Hyderabad,India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5115905143","display_name":"Alok Nook Raj Pepakayala","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Alok Nook Raj Pepakayala","raw_affiliation_strings":["State Street Corporation,Artificial Intelligence Group,Hyderabad,India"],"affiliations":[{"raw_affiliation_string":"State Street Corporation,Artificial Intelligence Group,Hyderabad,India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5115905144","display_name":"Lokesh Kuncham","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Lokesh Kuncham","raw_affiliation_strings":["State Street Corporation,Artificial Intelligence Group,Hyderabad,India"],"affiliations":[{"raw_affiliation_string":"State Street Corporation,Artificial Intelligence Group,Hyderabad,India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5115905145","display_name":"Rachita Barla","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Rachita Barla","raw_affiliation_strings":["State Street Corporation,Artificial Intelligence Group,Hyderabad,India"],"affiliations":[{"raw_affiliation_string":"State Street Corporation,Artificial Intelligence Group,Hyderabad,India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5115905146","display_name":"Kasula Tarun","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kasula Tarun","raw_affiliation_strings":["State Street Corporation,Artificial Intelligence Group,Hyderabad,India"],"affiliations":[{"raw_affiliation_string":"State Street Corporation,Artificial Intelligence Group,Hyderabad,India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114240093","display_name":"S. Charan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sai Charan","raw_affiliation_strings":["State Street Corporation,Artificial Intelligence Group,Hyderabad,India"],"affiliations":[{"raw_affiliation_string":"State Street Corporation,Artificial Intelligence Group,Hyderabad,India","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5017240349","display_name":"Amit Vaid","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Amit Vaid","raw_affiliation_strings":["State Street Corporation,Artificial Intelligence Group,Bengaluru,India"],"affiliations":[{"raw_affiliation_string":"State Street Corporation,Artificial Intelligence Group,Bengaluru,India","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5002357067"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.0778,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.88703202,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"1999","last_page":"2004"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9925000071525574,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9925000071525574,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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.9865999817848206,"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.9857000112533569,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8613283038139343},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7846367359161377},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.7122898697853088},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5057613849639893},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.49660879373550415},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.46057888865470886},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.43472516536712646},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.42106425762176514},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4112318754196167},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3518095910549164},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.08969226479530334},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.08307456970214844}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8613283038139343},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7846367359161377},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.7122898697853088},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5057613849639893},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.49660879373550415},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.46057888865470886},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.43472516536712646},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.42106425762176514},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4112318754196167},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3518095910549164},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.08969226479530334},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.08307456970214844}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/bigdata62323.2024.10825883","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata62323.2024.10825883","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE International Conference on Big Data (BigData)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6399999856948853,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W2890431379","https://openalex.org/W3176472386","https://openalex.org/W4375869868","https://openalex.org/W4385570661","https://openalex.org/W4389519120","https://openalex.org/W4391833078","https://openalex.org/W4394839102","https://openalex.org/W4398234583","https://openalex.org/W4399116870","https://openalex.org/W4404351611","https://openalex.org/W6737564900","https://openalex.org/W6851928915","https://openalex.org/W6855469472","https://openalex.org/W6857320562","https://openalex.org/W6859909457","https://openalex.org/W6861190020","https://openalex.org/W6862530910","https://openalex.org/W6864811613","https://openalex.org/W6869527054","https://openalex.org/W6876150574"],"related_works":["https://openalex.org/W638381921","https://openalex.org/W2912795851","https://openalex.org/W2340883001","https://openalex.org/W3209496184","https://openalex.org/W1890845846","https://openalex.org/W2738342198","https://openalex.org/W2240099544","https://openalex.org/W1520902996","https://openalex.org/W2512476881","https://openalex.org/W2282090486"],"abstract_inverted_index":{"EVOLVE":[0],"provides":[1],"a":[2,124],"thorough":[3],"exploration":[4],"of":[5,43,50,76,82,99,110,127,132],"the":[6,41,46,62,80,97,108],"methodology":[7],"and":[8,26,48,91,120],"strategic":[9],"approach":[10,131],"employed":[11],"in":[12,106],"appraising":[13],"text-to-sql":[14,60],"for":[15,36],"enterprise-scale":[16],"applications.":[17],"It":[18],"delves":[19],"into":[20],"our":[21,94,128],"unique":[22],"tactics,":[23],"evaluative":[24],"measures":[25],"iterative":[27],"enhancement":[28],"processes":[29],"aimed":[30],"at":[31],"steadily":[32],"augmenting":[33],"text-to-sql\u2019s":[34],"proficiency":[35],"robust":[37],"SQL":[38],"generation.":[39],"With":[40],"advent":[42],"big":[44,111],"data,":[45],"complexity":[47],"volume":[49],"database":[51],"queries":[52,86],"have":[53],"exponentially":[54],"increased.":[55],"Navigating":[56],"this":[57],"intricate":[58],"landscape,":[59],"revolutionizes":[61],"querying":[63],"process":[64],"by":[65],"enabling":[66],"Non-SQL":[67],"experts":[68],"to":[69,87],"use":[70],"natural":[71],"language":[72],"queries.":[73,113],"This":[74],"ease":[75],"accessibility,":[77],"however,":[78],"underscores":[79],"criticality":[81],"accurately":[83],"evaluating":[84],"these":[85,117],"ensure":[88],"their":[89],"correctness":[90],"efficacy.":[92],"Thus,":[93],"study":[95],"emphasizes":[96],"development":[98],"appropriate":[100],"validation":[101],"metrics,":[102,121],"which":[103],"are":[104],"essential":[105],"handling":[107],"complexities":[109],"data":[112],"By":[114],"focusing":[115],"on":[116],"novel":[118],"methodologies":[119],"we":[122],"present":[123],"holistic":[125],"view":[126],"rigorous":[129],"evaluation":[130],"text-to-sql.":[133]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}