{"id":"https://openalex.org/W2767336637","doi":"https://doi.org/10.1109/tkde.2017.2772252","title":"Cleaning Antipatterns in an SQL Query Log","display_name":"Cleaning Antipatterns in an SQL Query Log","publication_year":2017,"publication_date":"2017-11-10","ids":{"openalex":"https://openalex.org/W2767336637","doi":"https://doi.org/10.1109/tkde.2017.2772252","mag":"2767336637"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2017.2772252","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2017.2772252","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","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/A5080280661","display_name":"Natalia Arzamasova","orcid":"https://orcid.org/0000-0002-3824-9691"},"institutions":[{"id":"https://openalex.org/I102335020","display_name":"Karlsruhe Institute of Technology","ror":"https://ror.org/04t3en479","country_code":"DE","type":"education","lineage":["https://openalex.org/I102335020","https://openalex.org/I1305996414"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Natalia Arzamasova","raw_affiliation_strings":["Karlsruhe Institute of Technology (KIT), Karlsruhe, Germany"],"raw_orcid":"https://orcid.org/0000-0002-3824-9691","affiliations":[{"raw_affiliation_string":"Karlsruhe Institute of Technology (KIT), Karlsruhe, Germany","institution_ids":["https://openalex.org/I102335020"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033950182","display_name":"Martin Sch\u00e4ler","orcid":"https://orcid.org/0000-0003-1671-6508"},"institutions":[{"id":"https://openalex.org/I102335020","display_name":"Karlsruhe Institute of Technology","ror":"https://ror.org/04t3en479","country_code":"DE","type":"education","lineage":["https://openalex.org/I102335020","https://openalex.org/I1305996414"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Martin Schaler","raw_affiliation_strings":["Karlsruhe Institute of Technology (KIT), Karlsruhe, Germany"],"raw_orcid":"https://orcid.org/0000-0003-1671-6508","affiliations":[{"raw_affiliation_string":"Karlsruhe Institute of Technology (KIT), Karlsruhe, Germany","institution_ids":["https://openalex.org/I102335020"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049768806","display_name":"Klemens B\u00f6hm","orcid":"https://orcid.org/0000-0002-1706-1913"},"institutions":[{"id":"https://openalex.org/I102335020","display_name":"Karlsruhe Institute of Technology","ror":"https://ror.org/04t3en479","country_code":"DE","type":"education","lineage":["https://openalex.org/I102335020","https://openalex.org/I1305996414"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Klemens Bohm","raw_affiliation_strings":["Karlsruhe Institute of Technology (KIT), Karlsruhe, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Karlsruhe Institute of Technology (KIT), Karlsruhe, Germany","institution_ids":["https://openalex.org/I102335020"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5080280661"],"corresponding_institution_ids":["https://openalex.org/I102335020"],"apc_list":null,"apc_paid":null,"fwci":1.5351,"has_fulltext":false,"cited_by_count":19,"citation_normalized_percentile":{"value":0.85852568,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"30","issue":"3","first_page":"421","last_page":"434"},"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.9993000030517578,"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.9993000030517578,"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.9991999864578247,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9908000230789185,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/code-refactoring","display_name":"Code refactoring","score":0.8288974165916443},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8205640316009521},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7872359156608582},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4703781008720398},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.43992850184440613},{"id":"https://openalex.org/keywords/null","display_name":"Null (SQL)","score":0.4219781458377838},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3277750611305237},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3031960129737854},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2616371810436249},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.22471055388450623},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.1815570890903473},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.0870613157749176}],"concepts":[{"id":"https://openalex.org/C152752567","wikidata":"https://www.wikidata.org/wiki/Q116877","display_name":"Code refactoring","level":3,"score":0.8288974165916443},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8205640316009521},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7872359156608582},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4703781008720398},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.43992850184440613},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.4219781458377838},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3277750611305237},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3031960129737854},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2616371810436249},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.22471055388450623},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.1815570890903473},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0870613157749176}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tkde.2017.2772252","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2017.2772252","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":24,"referenced_works":["https://openalex.org/W78698729","https://openalex.org/W1487083903","https://openalex.org/W1535654799","https://openalex.org/W1633900197","https://openalex.org/W1649645444","https://openalex.org/W1991718349","https://openalex.org/W1994189501","https://openalex.org/W2022785566","https://openalex.org/W2037828101","https://openalex.org/W2057035276","https://openalex.org/W2062666593","https://openalex.org/W2099966806","https://openalex.org/W2132516581","https://openalex.org/W2135406884","https://openalex.org/W2144788252","https://openalex.org/W2153887189","https://openalex.org/W2157532207","https://openalex.org/W2282583353","https://openalex.org/W2394811972","https://openalex.org/W2397554829","https://openalex.org/W2400869242","https://openalex.org/W2494745915","https://openalex.org/W2787379525","https://openalex.org/W2952551828"],"related_works":["https://openalex.org/W2382973082","https://openalex.org/W4312632526","https://openalex.org/W2086783690","https://openalex.org/W2389720334","https://openalex.org/W151494989","https://openalex.org/W4320473518","https://openalex.org/W1488984669","https://openalex.org/W3210031882","https://openalex.org/W4388053677","https://openalex.org/W2155838697"],"abstract_inverted_index":{"Today,":[0],"many":[1],"scientific":[2],"data":[3],"sets":[4],"are":[5,21],"open":[6],"to":[7,16,52,84,95,106,151],"the":[8,19,29,37,76,100,110,119,123,133,152],"public.":[9],"For":[10],"their":[11],"operators,":[12],"it":[13],"is":[14],"important":[15],"know":[17],"what":[18],"users":[20],"interested":[22],"in.":[23],"In":[24],"this":[25],"paper,":[26],"we":[27,117,137],"study":[28,99],"problem":[30],"of":[31,40,75,102,112,122],"extracting":[32],"and":[33,87,94,105,159],"analyzing":[34],"patterns":[35,86],"from":[36],"query":[38,92],"log":[39,121],"a":[41,62,81],"database.":[42],"We":[43,79],"focus":[44],"on":[45,65,71],"design":[46],"errors":[47],"(antipatterns),":[48],"which":[49],"typically":[50],"lead":[51],"unnecessary":[53],"SQL":[54,77,91,120],"statements.":[55],"Such":[56],"antipatterns":[57,88,113,155],"do":[58],"not":[59],"only":[60],"have":[61,138],"negative":[63],"effect":[64],"performance.":[66],"They":[67],"also":[68],"introduce":[69],"bias":[70],"any":[72,160],"subsequent":[73],"analysis":[74],"log.":[78],"propose":[80],"framework":[82],"designed":[83],"discover":[85],"in":[89,114],"arbitrary":[90],"logs":[93],"clean":[96],"antipatterns.":[97,141],"To":[98],"usefulness":[101],"our":[103],"approach":[104],"reveal":[107],"insights":[108],"regarding":[109],"existence":[111],"real-world":[115],"systems,":[116],"examine":[118],"SkyServer":[124],"project,":[125],"containing":[126],"more":[127],"than":[128],"40":[129],"million":[130],"queries.":[131],"Among":[132],"top":[134],"15":[135],"patterns,":[136],"found":[139],"six":[140],"This":[142],"result":[143],"as":[144,146],"well":[145],"other":[147,161],"ones":[148],"gives":[149],"way":[150],"conclusion":[153],"that":[154],"might":[156],"falsify":[157],"refactoring":[158],"downstream":[162],"analyses.":[163]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}