{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,15]],"date-time":"2026-03-15T02:33:53Z","timestamp":1773542033619,"version":"3.50.1"},"publisher-location":"New York, NY, USA","reference-count":40,"publisher":"ACM","license":[{"start":{"date-parts":[[2020,5,31]],"date-time":"2020-05-31T00:00:00Z","timestamp":1590883200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"DOI":"10.13039\/100014718","name":"National Science Foundation","doi-asserted-by":"publisher","award":["IIS-1908984,IIS-1850342"],"award-info":[{"award-number":["IIS-1908984,IIS-1850342"]}],"id":[{"id":"10.13039\/100014718","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2020,6,11]]},"DOI":"10.1145\/3318464.3389754","type":"proceedings-article","created":{"date-parts":[[2020,5,29]],"date-time":"2020-05-29T17:12:33Z","timestamp":1590772353000},"page":"2331-2345","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":20,"title":["SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns"],"prefix":"10.1145","author":[{"given":"Prashanth","family":"Dintyala","sequence":"first","affiliation":[{"name":"Georgia Institute of Technology, Atlanta, GA, USA"}]},{"given":"Arpit","family":"Narechania","sequence":"additional","affiliation":[{"name":"Georgia Institute of Technology, Atlanta, GA, USA"}]},{"given":"Joy","family":"Arulraj","sequence":"additional","affiliation":[{"name":"Georgia Institute of Technology, Atlanta, GA, USA"}]}],"member":"320","published-online":{"date-parts":[[2020,5,31]]},"reference":[{"key":"e_1_3_2_2_1_1","unstructured":"Andi Albrecht. 2019. sqlparse: A non-validating SQL parser module for Python. https:\/\/github.com\/andialbrecht\/sqlparse.  Andi Albrecht. 2019. sqlparse: A non-validating SQL parser module for Python. https:\/\/github.com\/andialbrecht\/sqlparse."},{"key":"e_1_3_2_2_2_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDEW.2015.7129584"},{"key":"e_1_3_2_2_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/2568225.2568259"},{"key":"e_1_3_2_2_4_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2016.2553039"},{"key":"e_1_3_2_2_5_1","volume-title":"Myers","author":"Cheung Alvin","year":"2013","unstructured":"Alvin Cheung , Owen Arden , Samuel Madden , Armando Solar-Lezama , and Andrew C . Myers . 2013 a. StatusQuo: Making Familiar Abstractions Perform Using Program Analysis. In Proc. of CIDR. Alvin Cheung, Owen Arden, Samuel Madden, Armando Solar-Lezama, and Andrew C. Myers. 2013a. StatusQuo: Making Familiar Abstractions Perform Using Program Analysis. In Proc. of CIDR."},{"key":"e_1_3_2_2_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/2894749"},{"key":"e_1_3_2_2_7_1","first-page":"48","article-title":"Using Program Analysis to Improve Database Applications","volume":"37","author":"Cheung Alvin","year":"2014","unstructured":"Alvin Cheung , Samuel Madden , Armando Solar-Lezama , Owen Arden , and Andrew C Myers . 2014 . Using Program Analysis to Improve Database Applications . IEEE Data Eng. Bull. , Vol. 37 , 1 (2014), 48 -- 59 . Alvin Cheung, Samuel Madden, Armando Solar-Lezama, Owen Arden, and Andrew C Myers. 2014. Using Program Analysis to Improve Database Applications. IEEE Data Eng. Bull., Vol. 37, 1 (2014), 48--59.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_3_2_2_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/2499370.2462180"},{"key":"e_1_3_2_2_9_1","unstructured":"Digital Equipment Corporation. 1992. SQL-92 Standard. https:\/\/www.contrib.andrew.cmu.edu\/ shadow\/sql\/sql1992.txt.  Digital Equipment Corporation. 1992. SQL-92 Standard. https:\/\/www.contrib.andrew.cmu.edu\/ shadow\/sql\/sql1992.txt."},{"key":"e_1_3_2_2_10_1","unstructured":"Ember Crooks. 2013. Why low cardinality indexes negatively impact performance. https:\/\/www.ibm.com\/developerworks\/data\/library\/techarticle\/dm-1309cardinal\/index.html.  Ember Crooks. 2013. Why low cardinality indexes negatively impact performance. https:\/\/www.ibm.com\/developerworks\/data\/library\/techarticle\/dm-1309cardinal\/index.html."},{"key":"e_1_3_2_2_11_1","volume-title":"Raluca Ada Popa, Nirmesh Malviya, Eugene Wu, Sam Madden, Hari Balakrishnan, and Nickolai Zeldovich.","author":"Curino Carlo","year":"2011","unstructured":"Carlo Curino , Evan PC Jones , Raluca Ada Popa, Nirmesh Malviya, Eugene Wu, Sam Madden, Hari Balakrishnan, and Nickolai Zeldovich. 2011 . Relational cloud: A database-as-a-service for the cloud. (2011). Carlo Curino, Evan PC Jones, Raluca Ada Popa, Nirmesh Malviya, Eugene Wu, Sam Madden, Hari Balakrishnan, and Nickolai Zeldovich. 2011. Relational cloud: A database-as-a-service for the cloud. (2011)."},{"key":"e_1_3_2_2_12_1","volume-title":"Data scientist. Harvard business review","author":"Davenport Thomas H","year":"2012","unstructured":"Thomas H Davenport and DJ Patil . 2012. Data scientist. Harvard business review , Vol. 90 , 5 ( 2012 ), 70--76. Thomas H Davenport and DJ Patil. 2012. Data scientist. Harvard business review, Vol. 90, 5 (2012), 70--76."},{"key":"e_1_3_2_2_13_1","volume-title":"SQLCheck: Automated Detection and Diagnosis of SQL Anti-patterns. SIGMOD","author":"Dintyala Prashanth","year":"2020","unstructured":"Prashanth Dintyala , Arpit Narechania , and Joy Arulraj . 2020. SQLCheck: Automated Detection and Diagnosis of SQL Anti-patterns. SIGMOD , Vol. abs\/ 2004 .10232 ( 2020 ). arxiv: 2004.10232 https:\/\/arxiv.org\/abs\/2004.10232 Prashanth Dintyala, Arpit Narechania, and Joy Arulraj. 2020. SQLCheck: Automated Detection and Diagnosis of SQL Anti-patterns. SIGMOD, Vol. abs\/2004.10232 (2020). arxiv: 2004.10232 https:\/\/arxiv.org\/abs\/2004.10232"},{"key":"e_1_3_2_2_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882926"},{"key":"e_1_3_2_2_15_1","unstructured":"Hermes Center for Transparency and Digital Human Rights. 2019. GlobaLeaks. https:\/\/www.globaleaks.org\/.  Hermes Center for Transparency and Digital Human Rights. 2019. GlobaLeaks. https:\/\/www.globaleaks.org\/."},{"key":"e_1_3_2_2_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/152610.152611"},{"key":"e_1_3_2_2_17_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453975"},{"key":"e_1_3_2_2_18_1","unstructured":"E Iee. 1990. Ieee standard glossary of software engineering terminology. (1990).  E Iee. 1990. Ieee standard glossary of software engineering terminology. (1990)."},{"key":"e_1_3_2_2_19_1","unstructured":"Cunningham & Cunningham Inc. 2014. C2 Wiki. http:\/\/wiki.c2.com\/?AntiPatternsCatalog.  Cunningham & Cunningham Inc. 2014. C2 Wiki. http:\/\/wiki.c2.com\/?AntiPatternsCatalog."},{"key":"e_1_3_2_2_20_1","unstructured":"Facebook Inc. 2019 a. ReactJS. https:\/\/reactjs.org.  Facebook Inc. 2019 a. ReactJS. https:\/\/reactjs.org."},{"key":"e_1_3_2_2_21_1","unstructured":"GitHub Inc. 2019 b. GitHub. https:\/\/github.com.  GitHub Inc. 2019 b. GitHub. https:\/\/github.com."},{"key":"e_1_3_2_2_22_1","unstructured":"Stitch Inc. 2018. The State of Data Science. https:\/\/www.stitchdata.com\/resources\/the-state-of-data-science\/.  Stitch Inc. 2018. The State of Data Science. https:\/\/www.stitchdata.com\/resources\/the-state-of-data-science\/."},{"key":"e_1_3_2_2_23_1","unstructured":"Stack Exchange Inc. 2010. StackOverflow Wiki. https:\/\/stackoverflow.com\/questions\/346659\/what-are-the-most-common-sql-anti-patterns.  Stack Exchange Inc. 2010. StackOverflow Wiki. https:\/\/stackoverflow.com\/questions\/346659\/what-are-the-most-common-sql-anti-patterns."},{"key":"e_1_3_2_2_24_1","unstructured":"Kaggle. 2020. Kaggle. https:\/\/kaggle.com.  Kaggle. 2020. Kaggle. https:\/\/kaggle.com."},{"key":"e_1_3_2_2_25_1","unstructured":"Bill Karwin. 2010. SQL antipatterns: avoiding the pitfalls of database programming .Pragmatic Bookshelf.  Bill Karwin. 2010. SQL antipatterns: avoiding the pitfalls of database programming .Pragmatic Bookshelf."},{"key":"e_1_3_2_2_26_1","volume-title":"Unbundling transaction services in the cloud. arXiv preprint arXiv:0909.1768","author":"Lomet David","year":"2009","unstructured":"David Lomet , Alan Fekete , Gerhard Weikum , and Mike Zwilling . 2009. Unbundling transaction services in the cloud. arXiv preprint arXiv:0909.1768 ( 2009 ). David Lomet, Alan Fekete, Gerhard Weikum, and Mike Zwilling. 2009. Unbundling transaction services in the cloud. arXiv preprint arXiv:0909.1768 (2009)."},{"key":"e_1_3_2_2_27_1","unstructured":"Pallets. 2019. Python-Flask. http:\/\/flask.palletsprojects.com\/en\/1.1.x.  Pallets. 2019. Python-Flask. http:\/\/flask.palletsprojects.com\/en\/1.1.x."},{"key":"e_1_3_2_2_28_1","unstructured":"PostgreSQL. 2014. Postgres Query Parsing. https:\/\/wiki.postgresql.org\/wiki\/Query_Parsing.  PostgreSQL. 2014. Postgres Query Parsing. https:\/\/wiki.postgresql.org\/wiki\/Query_Parsing."},{"key":"e_1_3_2_2_29_1","unstructured":"PostgreSQL. 2019. Constraints in PostgreSQL. https:\/\/www.postgresql.org\/docs\/current\/ddl-constraints.html#DDL-CONSTRAINTS-CHECK-CONSTRAINTS.  PostgreSQL. 2019. Constraints in PostgreSQL. https:\/\/www.postgresql.org\/docs\/current\/ddl-constraints.html#DDL-CONSTRAINTS-CHECK-CONSTRAINTS."},{"key":"e_1_3_2_2_30_1","unstructured":"Python Software Foundation. 2019. Python. https:\/\/www.python.org.  Python Software Foundation. 2019. Python. https:\/\/www.python.org."},{"key":"e_1_3_2_2_31_1","unstructured":"Python Software Foundation. 2019. PyPi. https:\/\/pypi.org.  Python Software Foundation. 2019. PyPi. https:\/\/pypi.org."},{"key":"e_1_3_2_2_32_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2014.2334302"},{"key":"e_1_3_2_2_33_1","volume-title":"Database Management Systems 3 ed.)","author":"Ramakrishnan Raghu","unstructured":"Raghu Ramakrishnan and Johannes Gehrke . 2003. Database Management Systems 3 ed.) . McGraw-Hill, Inc. , New York, NY, USA . Raghu Ramakrishnan and Johannes Gehrke. 2003. Database Management Systems 3 ed.). McGraw-Hill, Inc., New York, NY, USA."},{"key":"e_1_3_2_2_34_1","volume-title":"Beautiful data: the stories behind elegant data solutions .\" O'Reilly Media","author":"Segaran Toby","unstructured":"Toby Segaran and Jeff Hammerbacher . 2009. Beautiful data: the stories behind elegant data solutions .\" O'Reilly Media , Inc .\". Toby Segaran and Jeff Hammerbacher. 2009. Beautiful data: the stories behind elegant data solutions .\" O'Reilly Media, Inc.\"."},{"key":"e_1_3_2_2_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183519.3183529"},{"key":"e_1_3_2_2_36_1","unstructured":"SQLAlchemy. 2019. SQLAlchemy. https:\/\/www.sqlalchemy.org\/.  SQLAlchemy. 2019. SQLAlchemy. https:\/\/www.sqlalchemy.org\/."},{"key":"e_1_3_2_2_37_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2016.09.009"},{"key":"e_1_3_2_2_38_1","doi-asserted-by":"publisher","DOI":"10.14778\/2876473.2876479"},{"key":"e_1_3_2_2_39_1","doi-asserted-by":"publisher","DOI":"10.1145\/3132847.3132954"},{"key":"e_1_3_2_2_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/3180155.3180194"}],"event":{"name":"SIGMOD\/PODS '20: International Conference on Management of Data","location":"Portland OR USA","acronym":"SIGMOD\/PODS '20","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3318464.3389754","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3318464.3389754","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T22:38:44Z","timestamp":1750199924000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3318464.3389754"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,5,31]]},"references-count":40,"alternative-id":["10.1145\/3318464.3389754","10.1145\/3318464"],"URL":"https:\/\/doi.org\/10.1145\/3318464.3389754","relation":{},"subject":[],"published":{"date-parts":[[2020,5,31]]},"assertion":[{"value":"2020-05-31","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}