{"id":"https://openalex.org/W2751366560","doi":"https://doi.org/10.1109/snpd.2017.8022723","title":"SQL antipatterns detection and database refactoring process","display_name":"SQL antipatterns detection and database refactoring process","publication_year":2017,"publication_date":"2017-06-01","ids":{"openalex":"https://openalex.org/W2751366560","doi":"https://doi.org/10.1109/snpd.2017.8022723","mag":"2751366560"},"language":"en","primary_location":{"id":"doi:10.1109/snpd.2017.8022723","is_oa":false,"landing_page_url":"https://doi.org/10.1109/snpd.2017.8022723","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 18th IEEE/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel/Distributed Computing (SNPD)","raw_type":"proceedings-article"},"type":"conference-paper","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/A5054490450","display_name":"Poonyanuch Khumnin","orcid":null},"institutions":[{"id":"https://openalex.org/I158708052","display_name":"Chulalongkorn University","ror":"https://ror.org/028wp3y58","country_code":"TH","type":"education","lineage":["https://openalex.org/I158708052"]}],"countries":["TH"],"is_corresponding":false,"raw_author_name":"Poonyanuch Khumnin","raw_affiliation_strings":["Software Engineering Program Department of Computer Engineering, Faculty of Engineering Chulalongkom University, Bangkok, Thailand"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Software Engineering Program Department of Computer Engineering, Faculty of Engineering Chulalongkom University, Bangkok, Thailand","institution_ids":["https://openalex.org/I158708052"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5000898716","display_name":"Twittie Senivongse","orcid":"https://orcid.org/0000-0002-3822-9199"},"institutions":[{"id":"https://openalex.org/I158708052","display_name":"Chulalongkorn University","ror":"https://ror.org/028wp3y58","country_code":"TH","type":"education","lineage":["https://openalex.org/I158708052"]}],"countries":["TH"],"is_corresponding":false,"raw_author_name":"Twittie Senivongse","raw_affiliation_strings":["Software Engineering Program Department of Computer Engineering, Faculty of Engineering Chulalongkom University, Bangkok, Thailand"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Software Engineering Program Department of Computer Engineering, Faculty of Engineering Chulalongkom University, Bangkok, Thailand","institution_ids":["https://openalex.org/I158708052"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I158708052"],"apc_list":null,"apc_paid":null,"fwci":1.5736,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.83514523,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"10","issue":null,"first_page":"199","last_page":"205"},"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.998199999332428,"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.998199999332428,"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.9976000189781189,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9914000034332275,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/code-refactoring","display_name":"Code refactoring","score":0.8408365845680237},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8063058853149414},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7408844232559204},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.6543819904327393},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.6460533738136292},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5880047678947449},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5523892641067505},{"id":"https://openalex.org/keywords/database-administrator","display_name":"Database administrator","score":0.4762161672115326},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4714449644088745},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.45995771884918213},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4145733714103699},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.32156693935394287},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.29527872800827026},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.2025628387928009},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.08941543102264404}],"concepts":[{"id":"https://openalex.org/C152752567","wikidata":"https://www.wikidata.org/wiki/Q116877","display_name":"Code refactoring","level":3,"score":0.8408365845680237},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8063058853149414},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7408844232559204},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.6543819904327393},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6460533738136292},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5880047678947449},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5523892641067505},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.4762161672115326},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4714449644088745},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.45995771884918213},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4145733714103699},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.32156693935394287},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.29527872800827026},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.2025628387928009},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.08941543102264404},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/snpd.2017.8022723","is_oa":false,"landing_page_url":"https://doi.org/10.1109/snpd.2017.8022723","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 18th IEEE/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel/Distributed Computing (SNPD)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.5899999737739563,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W78698729","https://openalex.org/W132327467","https://openalex.org/W162520817","https://openalex.org/W1892069840","https://openalex.org/W1971984821","https://openalex.org/W1991458579","https://openalex.org/W2005773470","https://openalex.org/W2073792498","https://openalex.org/W2083714857","https://openalex.org/W2153887189","https://openalex.org/W2402199355","https://openalex.org/W2494745915","https://openalex.org/W6669304368","https://openalex.org/W6723483447"],"related_works":["https://openalex.org/W279222092","https://openalex.org/W1979086811","https://openalex.org/W1498264296","https://openalex.org/W561919812","https://openalex.org/W2554350299","https://openalex.org/W1543230276","https://openalex.org/W2005202758","https://openalex.org/W2158626804","https://openalex.org/W2986827327","https://openalex.org/W4281724594"],"abstract_inverted_index":{"SQL":[0,52,147],"antipatterns":[1,53,73,94,129,148,205],"are":[2,6,26],"frequently-made":[3],"missteps":[4],"that":[5,78,146],"commonly":[7],"found":[8,145],"in":[9,50,123,167,179,197],"the":[10,15,20,60,67,86,103,114,116,119,128,131,154,157,160,180,188,198],"design":[11,72],"of":[12,17,22,41,69,118,125,127,136,156,200],"relational":[13],"databases,":[14],"use":[16],"SQL,":[18],"and":[19,54,84,95,159],"development":[21],"database":[23,48,71,87,104,181,189],"applications.":[24],"They":[25],"intended":[27],"to":[28,36,46,58,65,82,101],"solve":[29,59],"certain":[30],"problems":[31],"but":[32,130],"will":[33],"eventually":[34],"lead":[35],"other":[37],"problems.":[38],"The":[39,89],"motivation":[40],"this":[42],"paper":[43],"is":[44,121,144,207],"how":[45,100],"assist":[47],"administrators":[49],"diagnosing":[51],"suggest":[55],"refactoring":[56],"techniques":[57],"antipatterns.":[61],"Specifically,":[62],"we":[63],"attempt":[64],"automate":[66],"detection":[68,149,161],"logical":[70],"by":[74,187],"developing":[75],"a":[76,134,168],"tool":[77,90,120,132,162],"uses":[79],"Transact-SQL":[80],"language":[81],"query":[83],"analyze":[85],"schema.":[88,105],"reports":[91],"on":[92,99,110,153],"potential":[93,176],"gives":[96],"an":[97,107],"instruction":[98],"refactor":[102],"In":[106],"evaluation":[108],"based":[109],"three":[111],"databases":[112,202],"from":[113],"industry,":[115],"performance":[117],"satisfactory":[122],"terms":[124],"recall":[126],"detects":[133],"number":[135],"false":[137],"positives":[138],"which":[139,183],"affect":[140],"its":[141],"precision.":[142],"It":[143],"still":[150],"largely":[151],"depends":[152],"semantics":[155],"data":[158],"should":[163],"rather":[164],"be":[165,194],"used":[166],"semi-automated":[169],"manner,":[170],"i.e":[171],"it":[172],"can":[173],"point":[174],"out":[175],"problematic":[177],"locations":[178],"schema":[182],"require":[184],"further":[185],"diagnosis":[186],"administrators.":[190],"This":[191],"approach":[192],"would":[193],"useful":[195],"especially":[196],"context":[199],"large":[201],"where":[203],"manual":[204],"inspection":[206],"very":[208],"difficult.":[209]},"counts_by_year":[{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}