{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T10:16:07Z","timestamp":1740132967598,"version":"3.37.3"},"reference-count":25,"publisher":"Institute of Electrical and Electronics Engineers (IEEE)","issue":"3","license":[{"start":{"date-parts":[[2018,3,1]],"date-time":"2018-03-01T00:00:00Z","timestamp":1519862400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/ieeexplore.ieee.org\/Xplorehelp\/downloads\/license-information\/IEEE.html"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["IEEE Trans. Knowl. Data Eng."],"published-print":{"date-parts":[[2018,3,1]]},"DOI":"10.1109\/tkde.2017.2772252","type":"journal-article","created":{"date-parts":[[2017,11,10]],"date-time":"2017-11-10T19:20:42Z","timestamp":1510341642000},"page":"421-434","source":"Crossref","is-referenced-by-count":13,"title":["Cleaning Antipatterns in an SQL Query Log"],"prefix":"10.1109","volume":"30","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-3824-9691","authenticated-orcid":false,"given":"Natalia","family":"Arzamasova","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-1671-6508","authenticated-orcid":false,"given":"Martin","family":"Schaler","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Klemens","family":"Bohm","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"263","reference":[{"key":"ref10","doi-asserted-by":"publisher","DOI":"10.1109\/MCSE.2014.34"},{"key":"ref11","doi-asserted-by":"publisher","DOI":"10.1109\/MCSE.2014.32"},{"key":"ref12","first-page":"1369","article-title":"QFix: Diagnosing errors through query histories","year":"2017","journal-title":"Proc SIGMOD '17"},{"key":"ref13","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2005.06.028"},{"journal-title":"On Query-Based Search of Possible Design Flaws of SQL Databases","year":"2014","author":"eessaar","key":"ref14"},{"key":"ref15","doi-asserted-by":"publisher","DOI":"10.1145\/2568225.2568259"},{"key":"ref16","doi-asserted-by":"publisher","DOI":"10.1145\/2889160.2889228"},{"key":"ref17","doi-asserted-by":"publisher","DOI":"10.1145\/2602576.2602579"},{"key":"ref18","doi-asserted-by":"publisher","DOI":"10.1145\/1958746.1958755"},{"key":"ref19","doi-asserted-by":"publisher","DOI":"10.1145\/350391.350420"},{"journal-title":"J2EE AntiPatterns","year":"2003","author":"dudney","key":"ref4"},{"journal-title":"Design Patterns Elements of Reusable Object-Oriented Software","year":"1995","author":"gamma","key":"ref3"},{"key":"ref6","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1921048"},{"journal-title":"Refactoring Improving the Design of Existing Code","year":"1999","author":"fowler","key":"ref5"},{"key":"ref8","first-page":"875","article-title":"Context-aware query suggestion by mining click-through","author":"cao","year":"0","journal-title":"Proc ACM SIGKDD Int Conf Knowl Discov Data Min"},{"key":"ref7","doi-asserted-by":"publisher","DOI":"10.1561\/1500000013"},{"journal-title":"Antipatterns Refactoring Software Architectures and Projects in Crisis","year":"1998","author":"brown","key":"ref2"},{"article-title":"SkyServer traffic report—The first five\n years","year":"2006","author":"singh","key":"ref9"},{"article-title":"Identifying user interests within the data\n space – A case study with SkyServer","year":"0","author":"nguyen","key":"ref1"},{"journal-title":"Pattern-Oriented Software Architecture A System of Patterns","year":"1996","author":"buschmann","key":"ref20"},{"key":"ref22","doi-asserted-by":"publisher","DOI":"10.1145\/1868294.1868310"},{"key":"ref21","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.1998.738528"},{"journal-title":"SQL Antipatterns Avoiding the Pitfalls of Database Programming","year":"2010","author":"karwin","key":"ref24"},{"key":"ref23","first-page":"1","article-title":"Abstract Syntax Tree Implementation Idioms","author":"jones","year":"2003","journal-title":"Proc 10th Conf Pattern Languages of Programs"},{"journal-title":"SQL Design Patterns Expert Guide to SQL Programming","year":"2007","author":"burleson","key":"ref25"}],"container-title":["IEEE Transactions on Knowledge and Data Engineering"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx7\/69\/8280528\/08103787.pdf?arnumber=8103787","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,1,12]],"date-time":"2022-01-12T16:26:23Z","timestamp":1642004783000},"score":1,"resource":{"primary":{"URL":"http:\/\/ieeexplore.ieee.org\/document\/8103787\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018,3,1]]},"references-count":25,"journal-issue":{"issue":"3"},"URL":"https:\/\/doi.org\/10.1109\/tkde.2017.2772252","relation":{},"ISSN":["1041-4347"],"issn-type":[{"type":"print","value":"1041-4347"}],"subject":[],"published":{"date-parts":[[2018,3,1]]}}}