{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,19]],"date-time":"2026-05-19T07:16:40Z","timestamp":1779175000069,"version":"3.51.4"},"publisher-location":"New York, NY, USA","reference-count":32,"publisher":"ACM","license":[{"start":{"date-parts":[[2018,5,27]],"date-time":"2018-05-27T00:00:00Z","timestamp":1527379200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"name":"Marie Sklodowska-Curie Innovative Training Networks (ITN-EID)","award":["642954"],"award-info":[{"award-number":["642954"]}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2018,5,27]]},"DOI":"10.1145\/3183519.3183529","type":"proceedings-article","created":{"date-parts":[[2018,6,12]],"date-time":"2018-06-12T18:12:32Z","timestamp":1528827152000},"page":"55-64","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":30,"title":["Smelly relations"],"prefix":"10.1145","author":[{"given":"Tushar","family":"Sharma","sequence":"first","affiliation":[{"name":"Athens University of Economics and Business, Athens, Greece"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Marios","family":"Fragkoulis","sequence":"additional","affiliation":[{"name":"Athens University of Economics and Business, Athens, Greece"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Stamatia","family":"Rizou","sequence":"additional","affiliation":[{"name":"Singular Logic, Athens, Greece"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Magiel","family":"Bruntink","sequence":"additional","affiliation":[{"name":"Software Improvement Group, Amsterdam, The Netherlands"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Diomidis","family":"Spinellis","sequence":"additional","affiliation":[{"name":"Athens University of Economics and Business, Athens, Greece"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2018,5,27]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.2012.6405253"},{"key":"e_1_3_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1109\/SCAM.2007.18"},{"key":"e_1_3_2_1_3_1","unstructured":"Frank Buschmann Regine Meunier Hans Rohnert Peter Sommerlad and Michael Stal. 1996. Pattern-Oriented Software Architecture Volume 1: A System of Patterns (1 ed.). Wiley.   Frank Buschmann Regine Meunier Hans Rohnert Peter Sommerlad and Michael Stal. 1996. Pattern-Oriented Software Architecture Volume 1: A System of Patterns (1 ed.). Wiley."},{"key":"e_1_3_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDEW.2015.7129584"},{"key":"e_1_3_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/2568225.2568259"},{"key":"e_1_3_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/2884781.2884796"},{"key":"e_1_3_2_1_7_1","unstructured":"Database smells on StackOverflow 2010. What are the most common SQL anti-patterns? http:\/\/stackoverflow.com\/questions\/346659\/what-are-the-most-common-sql-anti-patterns. (2010). {Online; accessed 12-Oct-2017}.  Database smells on StackOverflow 2010. What are the most common SQL anti-patterns? http:\/\/stackoverflow.com\/questions\/346659\/what-are-the-most-common-sql-anti-patterns. (2010). {Online; accessed 12-Oct-2017}."},{"key":"e_1_3_2_1_8_1","doi-asserted-by":"crossref","unstructured":"Erki Eessaar and Janina Voronova. 2015. Using SQL Queries to Evaluate the Design of SQL Databases. Springer International Publishing 179--186.  Erki Eessaar and Janina Voronova. 2015. Using SQL Queries to Evaluate the Design of SQL Databases. Springer International Publishing 179--186.","DOI":"10.1007\/978-3-319-06764-3_23"},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.2013.37"},{"key":"e_1_3_2_1_10_1","volume-title":"Refactoring: Improving the Design of Existing Programs (1 ed.)","author":"Fowler Martin","year":"1999"},{"key":"e_1_3_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-02351-4_10"},{"key":"e_1_3_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.5555\/2337223.2337275"},{"key":"e_1_3_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.2012.6405300"},{"key":"e_1_3_2_1_14_1","unstructured":"Bill Karwin. 2010. SQL Antipatterns: Avoiding the Pitfalls of Database Programming (1st ed.). Pragmatic Bookshelf.   Bill Karwin. 2010. SQL Antipatterns: Avoiding the Pitfalls of Database Programming (1st ed.). Pragmatic Bookshelf."},{"key":"e_1_3_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1109\/QSIC.2009.47"},{"key":"e_1_3_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1109\/MS.2012.167"},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/2597008.2597144"},{"key":"e_1_3_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/2351676.2351723"},{"key":"e_1_3_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.5555\/942800.943571"},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.2005.63"},{"key":"e_1_3_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2009.50"},{"key":"e_1_3_2_1_22_1","unstructured":"N Munaiah S Kroh C Cabrey and M Nagappan. {n. d.}. Curating GitHub for engineered software projects. ({n. d.}). Preprint available at PeerJ  N Munaiah S Kroh C Cabrey and M Nagappan. {n. d.}. Curating GitHub for engineered software projects. ({n. d.}). Preprint available at PeerJ"},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICSM.2015.7332505"},{"key":"e_1_3_2_1_24_1","unstructured":"Redgate. 2017. 119 SQL Code Smells. http:\/\/assets.red-gate.com\/community\/books\/sql-code-smells.pdf. (2017). {Online; accessed 12-Oct-2017}.  Redgate. 2017. 119 SQL Code Smells. http:\/\/assets.red-gate.com\/community\/books\/sql-code-smells.pdf. (2017). {Online; accessed 12-Oct-2017}."},{"key":"e_1_3_2_1_25_1","unstructured":"Tushar Sharma. 2016. Presentation smells: How not to prepare your conference presentation. http:\/\/xrds.acm.org\/blog\/2016\/06\/presentation-smells-to-avoid-in-conference-presentation\/. (2016). {Online; accessed 12-Oct-2017}.  Tushar Sharma. 2016. Presentation smells: How not to prepare your conference presentation. http:\/\/xrds.acm.org\/blog\/2016\/06\/presentation-smells-to-avoid-in-conference-presentation\/. (2016). {Online; accessed 12-Oct-2017}."},{"key":"e_1_3_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/2901739.2901761"},{"key":"e_1_3_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/2896935.2896938"},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.jss.2017.12.034"},{"key":"e_1_3_2_1_29_1","doi-asserted-by":"crossref","unstructured":"Diomidis Spinellis. 2015. Tools and Techniques for Analyzing Product and Process Data. In The Art and Science of Analyzing Software Data Tim Menzies Christian Bird and Thomas Zimmermann (Eds.). Morgan-Kaufmann 161--212.  Diomidis Spinellis. 2015. Tools and Techniques for Analyzing Product and Process Data. In The Art and Science of Analyzing Software Data Tim Menzies Christian Bird and Thomas Zimmermann (Eds.). Morgan-Kaufmann 161--212.","DOI":"10.1016\/B978-0-12-411519-4.00007-0"},{"key":"e_1_3_2_1_30_1","doi-asserted-by":"crossref","unstructured":"Girish Suryanarayana Ganesh Samarthyam and Tushar Sharma. 2014. Refactoring for Software Design Smells: Managing Technical Debt (1 ed.). Morgan Kaufmann.   Girish Suryanarayana Ganesh Samarthyam and Tushar Sharma. 2014. Refactoring for Software Design Smells: Managing Technical Debt (1 ed.). Morgan Kaufmann.","DOI":"10.1016\/B978-0-12-801397-7.00001-1"},{"key":"e_1_3_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2016.09.009"},{"key":"e_1_3_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10664-013-9250-3"}],"event":{"name":"ICSE '18: 40th International Conference on Software Engineering","location":"Gothenburg Sweden","acronym":"ICSE '18","sponsor":["SIGSOFT ACM Special Interest Group on Software Engineering","IEEE-CS Computer Society"]},"container-title":["Proceedings of the 40th International Conference on Software Engineering: Software Engineering in Practice"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3183519.3183529","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3183519.3183529","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T01:08:11Z","timestamp":1750208891000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3183519.3183529"}},"subtitle":["measuring and understanding database schema quality"],"short-title":[],"issued":{"date-parts":[[2018,5,27]]},"references-count":32,"alternative-id":["10.1145\/3183519.3183529","10.1145\/3183519"],"URL":"https:\/\/doi.org\/10.1145\/3183519.3183529","relation":{},"subject":[],"published":{"date-parts":[[2018,5,27]]},"assertion":[{"value":"2018-05-27","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}