{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,10,30]],"date-time":"2024-10-30T14:22:38Z","timestamp":1730298158402,"version":"3.28.0"},"reference-count":14,"publisher":"IEEE","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2017,6]]},"DOI":"10.1109\/snpd.2017.8022723","type":"proceedings-article","created":{"date-parts":[[2017,8,31]],"date-time":"2017-08-31T16:39:37Z","timestamp":1504197577000},"page":"199-205","source":"Crossref","is-referenced-by-count":9,"title":["SQL antipatterns detection and database refactoring process"],"prefix":"10.1109","author":[{"given":"Poonyanuch","family":"Khumnin","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Twittie","family":"Senivongse","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"263","reference":[{"key":"ref10","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-06773-5_8"},{"key":"ref11","first-page":"2209","article-title":"A workflow for database refactoring","volume":"10","author":"domingues","year":"2014","journal-title":"Int J Innov Comput Inf Control"},{"key":"ref12","doi-asserted-by":"publisher","DOI":"10.1109\/MS.2015.131"},{"key":"ref13","doi-asserted-by":"publisher","DOI":"10.1109\/SCAM.2013.6648199"},{"key":"ref14","doi-asserted-by":"publisher","DOI":"10.1109\/SISY.2012.6339502"},{"journal-title":"Refactoring Databases Evolutionary Database Design","year":"2006","author":"ambler","key":"ref4"},{"key":"ref3","article-title":"SQL Antipatterns: Avoiding the Pitfalls of Database Programming","author":"karwin","year":"2010","journal-title":"The Pragmatic Bookshelf"},{"key":"ref6","first-page":"1","article-title":"Automatic detection of bad smells in code: An experimental assessment","volume":"11","author":"fontana","year":"2012","journal-title":"J Object Technol"},{"journal-title":"Microsoft Transact-SQL","year":"2017","key":"ref5"},{"key":"ref8","doi-asserted-by":"publisher","DOI":"10.1145\/2541348.2541357"},{"key":"ref7","doi-asserted-by":"publisher","DOI":"10.1109\/WCRE.2013.6671299"},{"key":"ref2","doi-asserted-by":"publisher","DOI":"10.1145\/2915970.2915984"},{"journal-title":"Refactoring Improving the Design of Existing Code","year":"1999","author":"fowler","key":"ref1"},{"journal-title":"Integrating Code Smells Detection with Refactoring Tool Support","year":"2012","author":"nongpong","key":"ref9"}],"event":{"name":"2017 18th IEEE\/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel\/Distributed Computing (SNPD)","start":{"date-parts":[[2017,6,26]]},"location":"Kanazawa, Japan","end":{"date-parts":[[2017,6,28]]}},"container-title":["2017 18th IEEE\/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel\/Distributed Computing (SNPD)"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx7\/8013514\/8022642\/08022723.pdf?arnumber=8022723","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2017,9,11]],"date-time":"2017-09-11T19:11:12Z","timestamp":1505157072000},"score":1,"resource":{"primary":{"URL":"http:\/\/ieeexplore.ieee.org\/document\/8022723\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017,6]]},"references-count":14,"URL":"https:\/\/doi.org\/10.1109\/snpd.2017.8022723","relation":{},"subject":[],"published":{"date-parts":[[2017,6]]}}}