{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,15]],"date-time":"2026-03-15T02:33:52Z","timestamp":1773542032796,"version":"3.50.1"},"publisher-location":"Cham","reference-count":23,"publisher":"Springer International Publishing","isbn-type":[{"value":"9783030576714","type":"print"},{"value":"9783030576721","type":"electronic"}],"license":[{"start":{"date-parts":[[2020,1,1]],"date-time":"2020-01-01T00:00:00Z","timestamp":1577836800000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2020,1,1]],"date-time":"2020-01-01T00:00:00Z","timestamp":1577836800000},"content-version":"vor","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2020]]},"DOI":"10.1007\/978-3-030-57672-1_14","type":"book-chapter","created":{"date-parts":[[2020,8,11]],"date-time":"2020-08-11T09:31:47Z","timestamp":1597138307000},"page":"176-189","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":4,"title":["Automating Detection of Occurrences of PostgreSQL Database Design Problems"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0000-0001-5972-3412","authenticated-orcid":false,"given":"Erki","family":"Eessaar","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2020,8,12]]},"reference":[{"key":"14_CR1","unstructured":"Riaz, M., Mendes, E., Tempero, E.D.: Maintainability predictors for relational database-driven software applications: results from a survey. In: SEKE, pp. 420\u2013425 (2011)"},{"key":"14_CR2","doi-asserted-by":"publisher","first-page":"158","DOI":"10.1016\/j.jss.2017.12.034","volume":"138","author":"T Sharma","year":"2018","unstructured":"Sharma, T., Spinellis, D.: A survey on software smells. J. Syst. Softw. 138, 158\u2013173 (2018). https:\/\/doi.org\/10.1016\/j.jss.2017.12.034","journal-title":"J. Syst. Softw."},{"key":"14_CR3","doi-asserted-by":"publisher","unstructured":"Yamashita, A., Moonen, L.: Do developers care about code smells? An exploratory survey. In: 20th Working Conference on Reverse Engineering, pp. 242\u2013251. IEEE (2013). https:\/\/doi.org\/10.1109\/WCRE.2013.6671299","DOI":"10.1109\/WCRE.2013.6671299"},{"key":"14_CR4","volume-title":"Clean Code. A Handbook of Agile Software Craftsmanship","author":"RC Martin","year":"2009","unstructured":"Martin, R.C.: Clean Code. A Handbook of Agile Software Craftsmanship. Pearson Education, London (2009)"},{"key":"14_CR5","unstructured":"Karwin, B.: SQL Antipatterns. Avoiding the Pitfalls of Database Programming. The Pragmatic Bookshelf (2010)"},{"key":"14_CR6","doi-asserted-by":"publisher","unstructured":"Fernandes, E., Oliveira, J., Vale, G., Paiva, T., Figueiredo, E.: A review-based comparative study of bad smell detection tools. In: Proceedings of the 20th International Conference on Evaluation and Assessment in Software Engineering, pp. 1\u201312. ACM (2016). https:\/\/doi.org\/10.1145\/2915970.2915984","DOI":"10.1145\/2915970.2915984"},{"key":"14_CR7","doi-asserted-by":"publisher","unstructured":"Blaha, M.: A retrospective on industrial database reverse engineering projects - part 2. In: Proceedings Eighth Working Conference on Reverse Engineering, pp. 147\u2013153. IEEE (2001). https:\/\/doi.org\/10.1109\/WCRE.2001.957818","DOI":"10.1109\/WCRE.2001.957818"},{"key":"14_CR8","doi-asserted-by":"publisher","unstructured":"Weber, J.H., Cleve, A., Meurice, L., Ruiz, F.J.B.: Managing technical debt in database schemas of critical software. In: Sixth International Workshop on Managing Technical Debt, pp. 43\u201346. IEEE (2014). https:\/\/doi.org\/10.1109\/MTD.2014.17","DOI":"10.1109\/MTD.2014.17"},{"key":"14_CR9","unstructured":"Catalog of Database Refactorings. http:\/\/www.agiledata.org\/essays\/databaseRefactoringCatalog.html. Accessed 21 Dec 2019"},{"key":"14_CR10","series-title":"Lecture Notes in Electrical Engineering","doi-asserted-by":"publisher","first-page":"53","DOI":"10.1007\/978-3-319-06773-5_8","volume-title":"Innovations and Advances in Computing, Informatics, Systems Sciences, Networking and Engineering","author":"E Eessaar","year":"2015","unstructured":"Eessaar, E.: On query-based search of possible design flaws of SQL databases. In: Sobh, T., Elleithy, K. (eds.) Innovations and Advances in Computing, Informatics, Systems Sciences, Networking and Engineering. LNEE, vol. 313, pp. 53\u201360. Springer, Cham (2015). https:\/\/doi.org\/10.1007\/978-3-319-06773-5_8"},{"key":"14_CR11","series-title":"Lecture Notes in Electrical Engineering","doi-asserted-by":"publisher","first-page":"179","DOI":"10.1007\/978-3-319-06764-3_23","volume-title":"New Trends in Networking, Computing, E-learning, Systems Sciences, and Engineering","author":"E Eessaar","year":"2015","unstructured":"Eessaar, E., Voronova, J.: Using SQL queries to evaluate the design of SQL databases. In: Elleithy, K., Sobh, T. (eds.) New Trends in Networking, Computing, E-learning, Systems Sciences, and Engineering. Lecture Notes in Electrical Engineering, vol. 312, pp. 179\u2013186. Springer, Cham (2015). https:\/\/doi.org\/10.1007\/978-3-319-06764-3_23"},{"key":"14_CR12","doi-asserted-by":"publisher","unstructured":"Khumnin, P., Senivongse, T.: SQL antipatterns detection and database refactoring process. In: 18th IEEE\/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel\/Distributed Computing (SNPD), pp. 199\u2013205. IEEE (2017). https:\/\/doi.org\/10.1109\/SNPD.2017.8022723","DOI":"10.1109\/SNPD.2017.8022723"},{"key":"14_CR13","doi-asserted-by":"publisher","unstructured":"Sharma, T., Fragkoulis, M., Rizou, S., Bruntink, M., Spinellis, D.: Smelly relations: measuring and understanding database schema quality. In: Proceedings of the 40th International Conference on Software Engineering: Software Engineering in Practice, pp. 55\u201364. ACM (2018). https:\/\/doi.org\/10.1145\/3183519.3183529","DOI":"10.1145\/3183519.3183529"},{"key":"14_CR14","doi-asserted-by":"publisher","unstructured":"Delplanque, J., Etien, A., Auverlot, O., Mens, T., Anquetil, N., Ducasse, S.: CodeCritics applied to database schema: Challenges and first results. In: 2017 IEEE 24th International Conference on Software Analysis, Evolution and Reengineering (SANER), pp. 432\u2013436. IEEE (2017). https:\/\/doi.org\/10.1109\/SANER.2017.7884648","DOI":"10.1109\/SANER.2017.7884648"},{"issue":"6","key":"14_CR15","doi-asserted-by":"publisher","first-page":"71","DOI":"10.1109\/MS.2015.131","volume":"32","author":"G Vial","year":"2015","unstructured":"Vial, G.: Database refactoring: lessons from the trenches. IEEE Softw. 32(6), 71\u201379 (2015). https:\/\/doi.org\/10.1109\/MS.2015.131","journal-title":"IEEE Softw."},{"key":"14_CR16","unstructured":"Factor, P.: SQL Code Smells. Redgate. http:\/\/assets.red-gate.com\/community\/books\/sql-code-smells.pdf. Accessed 29 Dec 2019"},{"key":"14_CR17","unstructured":"Sonarsource PL\/SQL rules. https:\/\/rules.sonarsource.com\/plsql. Accessed 21 Dec 2019"},{"key":"14_CR18","unstructured":"sp_Blitz\u00ae \u2013 SQL Server Takeover Script. https:\/\/www.brentozar.com\/blitz\/. Accessed 21 Dec 2019"},{"issue":"4","key":"14_CR19","first-page":"477","volume":"7","author":"M Piattini","year":"2001","unstructured":"Piattini, M., Calero, C., Sahraoui, H.A., Lounis, H.: Object-relational database metrics. L\u2019Objet 7(4), 477\u2013496 (2001)","journal-title":"L\u2019Objet"},{"key":"14_CR20","doi-asserted-by":"publisher","first-page":"42","DOI":"10.1109\/52.268955","volume":"11","author":"OI Lindland","year":"1994","unstructured":"Lindland, O.I., Sindre, G., Solvberg, A.: Understanding quality in conceptual modeling. IEEE Softw. 11, 42\u201349 (1994). https:\/\/doi.org\/10.1109\/52.268955","journal-title":"IEEE Softw."},{"key":"14_CR21","doi-asserted-by":"publisher","first-page":"37","DOI":"10.2307\/23043488","volume":"35","author":"MK Sein","year":"2011","unstructured":"Sein, M.K., Henfridsson, O., Purao, S., Rossi, M., Lindgren, R.: Action design research. MIS Q. 35, 37\u201356 (2011). https:\/\/doi.org\/10.2307\/23043488","journal-title":"MIS Q."},{"key":"14_CR22","volume-title":"SQL and Relational Theory. How to Write Accurate SQL Code","author":"CJ Date","year":"2011","unstructured":"Date, C.J.: SQL and Relational Theory. How to Write Accurate SQL Code, 2nd edn. O\u2019Reilly, Sebastopol (2011)","edition":"2"},{"key":"14_CR23","series-title":"Advances in Intelligent Systems and Computing","doi-asserted-by":"publisher","first-page":"269","DOI":"10.1007\/978-3-319-91186-1_28","volume-title":"Software Engineering and Algorithms in Intelligent Systems","author":"E Eessaar","year":"2019","unstructured":"Eessaar, E., K\u00e4osaar, E.: On finding model smells based on code smells. In: Silhavy, R. (ed.) CSOC2018 2018. AISC, vol. 763, pp. 269\u2013281. Springer, Cham (2019). https:\/\/doi.org\/10.1007\/978-3-319-91186-1_28"}],"container-title":["Communications in Computer and Information Science","Databases and Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-57672-1_14","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2021,4,24]],"date-time":"2021-04-24T07:57:24Z","timestamp":1619251044000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-030-57672-1_14"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020]]},"ISBN":["9783030576714","9783030576721"],"references-count":23,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-57672-1_14","relation":{},"ISSN":["1865-0929","1865-0937"],"issn-type":[{"value":"1865-0929","type":"print"},{"value":"1865-0937","type":"electronic"}],"subject":[],"published":{"date-parts":[[2020]]},"assertion":[{"value":"12 August 2020","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"DB&IS","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"International Baltic Conference on Databases and Information Systems","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Tallinn","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Estonia","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2020","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"16 June 2020","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"19 June 2020","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"14","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"dbis2020","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"https:\/\/dbis.ttu.ee\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Single-blind","order":1,"name":"type","label":"Type","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"EasyChair","order":2,"name":"conference_management_system","label":"Conference Management System","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"52","order":3,"name":"number_of_submissions_sent_for_review","label":"Number of Submissions Sent for Review","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"21","order":4,"name":"number_of_full_papers_accepted","label":"Number of Full Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"1","order":5,"name":"number_of_short_papers_accepted","label":"Number of Short Papers Accepted","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"40% - The value is computed by the equation \"Number of Full Papers Accepted \/ Number of Submissions Sent for Review * 100\" and then rounded to a whole number.","order":6,"name":"acceptance_rate_of_full_papers","label":"Acceptance Rate of Full Papers","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"3.05","order":7,"name":"average_number_of_reviews_per_paper","label":"Average Number of Reviews per Paper","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"2.2","order":8,"name":"average_number_of_papers_per_reviewer","label":"Average Number of Papers per Reviewer","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"Yes","order":9,"name":"external_reviewers_involved","label":"External Reviewers Involved","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}},{"value":"The conference was held virtually due to the COVID-19 pandemic.","order":10,"name":"additional_info_on_review_process","label":"Additional Info on Review Process","group":{"name":"ConfEventPeerReviewInformation","label":"Peer Review Information (provided by the conference organizers)"}}]}}