{"id":"https://openalex.org/W3197746951","doi":"https://doi.org/10.14778/3476311.3476343","title":"Interactive demonstration of SQLCheck","display_name":"Interactive demonstration of SQLCheck","publication_year":2021,"publication_date":"2021-07-01","ids":{"openalex":"https://openalex.org/W3197746951","doi":"https://doi.org/10.14778/3476311.3476343","mag":"3197746951"},"language":"en","primary_location":{"id":"doi:10.14778/3476311.3476343","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3476311.3476343","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5023595255","display_name":"Arthita Ghosh","orcid":"https://orcid.org/0000-0002-6140-408X"},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Arthita Ghosh","raw_affiliation_strings":["Georgia Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022645992","display_name":"Deven Bansod","orcid":null},"institutions":[{"id":"https://openalex.org/I2252078561","display_name":"Meta (Israel)","ror":"https://ror.org/02388em19","country_code":"IL","type":"company","lineage":["https://openalex.org/I2252078561","https://openalex.org/I4210114444"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Deven Bansod","raw_affiliation_strings":["Facebook, Inc"],"affiliations":[{"raw_affiliation_string":"Facebook, Inc","institution_ids":["https://openalex.org/I2252078561"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078755914","display_name":"Arpit Narechania","orcid":"https://orcid.org/0000-0001-6980-3686"},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Arpit Narechania","raw_affiliation_strings":["Georgia Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092187297","display_name":"Prashanth Dintyala","orcid":"https://orcid.org/0009-0007-0330-3700"},"institutions":[{"id":"https://openalex.org/I4210127875","display_name":"Nvidia (United States)","ror":"https://ror.org/03jdj4y14","country_code":"US","type":"company","lineage":["https://openalex.org/I4210127875"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Prashanth Dintyala","raw_affiliation_strings":["NVIDIA Corporation"],"affiliations":[{"raw_affiliation_string":"NVIDIA Corporation","institution_ids":["https://openalex.org/I4210127875"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5097274684","display_name":"Su Timurturkan","orcid":null},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Su Timurturkan","raw_affiliation_strings":["Georgia Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5060680349","display_name":"Joy Arulraj","orcid":"https://orcid.org/0000-0002-7706-6978"},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Joy Arulraj","raw_affiliation_strings":["Georgia Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology","institution_ids":["https://openalex.org/I130701444"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5023595255"],"corresponding_institution_ids":["https://openalex.org/I130701444"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.14995956,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"14","issue":"12","first_page":"2779","last_page":"2782"},"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.9994000196456909,"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.9994000196456909,"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.9980000257492065,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9919000267982483,"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/toolchain","display_name":"Toolchain","score":0.8638253211975098},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8555123209953308},{"id":"https://openalex.org/keywords/maintainability","display_name":"Maintainability","score":0.7647033929824829},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6707464456558228},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.505516767501831},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4980735778808594},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4935113191604614},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.4223915636539459},{"id":"https://openalex.org/keywords/software-design-pattern","display_name":"Software design pattern","score":0.41758063435554504},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3391724228858948},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.29643744230270386},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.20789748430252075},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.19553929567337036}],"concepts":[{"id":"https://openalex.org/C2777062904","wikidata":"https://www.wikidata.org/wiki/Q545406","display_name":"Toolchain","level":3,"score":0.8638253211975098},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8555123209953308},{"id":"https://openalex.org/C160713754","wikidata":"https://www.wikidata.org/wiki/Q1389965","display_name":"Maintainability","level":2,"score":0.7647033929824829},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6707464456558228},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.505516767501831},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4980735778808594},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4935113191604614},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.4223915636539459},{"id":"https://openalex.org/C146054899","wikidata":"https://www.wikidata.org/wiki/Q181156","display_name":"Software design pattern","level":3,"score":0.41758063435554504},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3391724228858948},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.29643744230270386},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20789748430252075},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.19553929567337036}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/3476311.3476343","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3476311.3476343","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:repository.hkust.edu.hk:1783.1-145992","is_oa":false,"landing_page_url":"http://repository.hkust.edu.hk/ir/Record/1783.1-145992","pdf_url":null,"source":{"id":"https://openalex.org/S4306401796","display_name":"Rare & Special e-Zone (The Hong Kong University of Science and Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I200769079","host_organization_name":"Hong Kong University of Science and Technology","host_organization_lineage":["https://openalex.org/I200769079"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Conference paper"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1544010666","https://openalex.org/W1969548135","https://openalex.org/W2148167495","https://openalex.org/W2236986911","https://openalex.org/W2399620389","https://openalex.org/W2524766217","https://openalex.org/W2794933251","https://openalex.org/W2808642230","https://openalex.org/W3020616315","https://openalex.org/W3100791781"],"related_works":["https://openalex.org/W2013037783","https://openalex.org/W2909413202","https://openalex.org/W1999008563","https://openalex.org/W4385243142","https://openalex.org/W2561644314","https://openalex.org/W2794118724","https://openalex.org/W2912135124","https://openalex.org/W4206450104","https://openalex.org/W2883257033","https://openalex.org/W2019460074"],"abstract_inverted_index":{"We":[0,126,141],"will":[1,127,142],"demonstrate":[2,128],"a":[3,7,73,150],"prototype":[4],"of":[5,21,109,146,153],"sqlcheck,":[6],"holistic":[8],"toolchain":[9],"for":[10,29,41,89],"automatically":[11],"finding":[12],"and":[13,47,107,111,116,138,155],"fixing":[14],"anti-patterns":[15,57,64,93,148],"in":[16,58,149],"database":[17,120],"applications.":[18,35,49,140],"The":[19],"advent":[20],"modern":[22],"database-as-a-service":[23],"platforms":[24],"has":[25],"made":[26],"it":[27,37],"easy":[28],"developers":[30,42,53,132],"to":[31,43,71,78,118,122,133],"quickly":[32],"create":[33,134],"scalable":[34],"However,":[36],"is":[38,51],"still":[39],"challenging":[40],"design":[44,66,84,121],"performant,":[45,136],"maintainable,":[46,137],"accurate":[48,139],"This":[50],"because":[52],"may":[54],"unknowingly":[55],"introduce":[56],"the":[59,119,144],"application's":[60],"SQL":[61],"statements.":[62],"These":[63],"are":[65,69],"decisions":[67],"that":[68,129],"intended":[70],"solve":[72],"problem,":[74],"but":[75],"often":[76],"lead":[77],"other":[79],"problems":[80],"by":[81],"violating":[82],"fundamental":[83],"principles.":[85],"sqlcheck":[86,130],"leverages":[87],"techniques":[88],"automatically:":[90],"(1)":[91],"detecting":[92],"with":[94],"high":[95],"accuracy,":[96],"(2)":[97],"ranking":[98],"them":[99],"based":[100],"on":[101,104],"their":[102],"impact":[103],"performance,":[105],"maintainability,":[106],"accuracy":[108],"applications,":[110],"(3)":[112],"suggesting":[113],"alternative":[114],"queries":[115,154],"changes":[117],"fix":[123],"these":[124,147],"anti-patterns.":[125],"enables":[131],"more":[135],"show":[143],"prevalence":[145],"large":[151],"collection":[152],"databases":[156],"collected":[157],"from":[158],"open-source":[159],"repositories.":[160]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}