{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T07:19:32Z","timestamp":1740122372332,"version":"3.37.3"},"reference-count":64,"publisher":"Springer Science and Business Media LLC","issue":"3","license":[{"start":{"date-parts":[[2023,4,21]],"date-time":"2023-04-21T00:00:00Z","timestamp":1682035200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"},{"start":{"date-parts":[[2023,4,21]],"date-time":"2023-04-21T00:00:00Z","timestamp":1682035200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"funder":[{"DOI":"10.13039\/100008247","name":"University of Otago","doi-asserted-by":"crossref","id":[{"id":"10.13039\/100008247","id-type":"DOI","asserted-by":"crossref"}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Empir Software Eng"],"published-print":{"date-parts":[[2023,5]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:p>A key function of a software system is its ability to facilitate the manipulation of data, which is often implemented using a flavour of the Structured Query Language (SQL). To develop the data operations of software (i.e, creating, retrieving, updating, and deleting data), developers are required to excel in writing and combining both SQL and application code. The problem is that writing SQL code in itself is already challenging (e.g., SQL anti-patterns are commonplace) and combining SQL with application code (i.e., for SQL development tasks) is even more demanding. Meanwhile, we have little empirical understanding regarding the characteristics of SQL development tasks. Do SQL development tasks typically need more code changes? Do they typically have a longer time-to-completion? Answers to such questions would prepare the community for the potential challenges associated with such tasks. Our results obtained from 20 Apache projects reveal that SQL development tasks have a significantly longer time-to-completion than SQL-unrelated tasks and require significantly more code changes. Through our qualitative analyses, we observe that SQL development tasks require more spread out changes, effort in reviews and documentation. Our results also corroborate previous research highlighting the prevalence of SQL anti-patterns. The software engineering community should make provision for the peculiarities of SQL coding, in the delivery of safe and secure interactive software.<\/jats:p>","DOI":"10.1007\/s10664-023-10295-x","type":"journal-article","created":{"date-parts":[[2023,4,21]],"date-time":"2023-04-21T12:02:17Z","timestamp":1682078537000},"update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["Studying the characteristics of SQL-related development tasks: An empirical study"],"prefix":"10.1007","volume":"28","author":[{"given":"Daniel Alencar da","family":"Costa","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Natalie","family":"Grattan","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Nigel","family":"Stanger","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sherlock A.","family":"Licorish","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2023,4,21]]},"reference":[{"key":"10295_CR1","doi-asserted-by":"crossref","unstructured":"Annamaa A, Breslav A, Kabanov J, Vene V (2010) An interactive tool for analyzing embedded SQL queries. In: Asian symposium on programming languages and systems, Springer, pp 131\u2013138","DOI":"10.1007\/978-3-642-17164-2_10"},{"key":"10295_CR2","unstructured":"ASF (2019) Community-led development \u201dthe Apache way\u201d https:\/\/www.apache.org\/foundation\/. Accessed 10 Jan 2022"},{"key":"10295_CR3","doi-asserted-by":"crossref","unstructured":"Bachmann A, Bernstein A (2009) Software process data quality and characteristics: a historical view on open and closed source projects. In: Proceedings of the joint international and annual ERCIM workshops on principles of software evolution (IWPSE) and software evolution (Evol) workshops, pp 119\u2013128","DOI":"10.1145\/1595808.1595830"},{"issue":"2","key":"10295_CR4","doi-asserted-by":"publisher","first-page":"27","DOI":"10.3316\/QRJ0902027","volume":"9","author":"GA Bowen","year":"2009","unstructured":"Bowen GA (2009) Document analysis as a qualitative research method. Qual R J 9(2):27\u201340. https:\/\/doi.org\/10.3316\/QRJ0902027","journal-title":"Qual R J"},{"issue":"4","key":"10295_CR5","doi-asserted-by":"publisher","first-page":"589","DOI":"10.1080\/2159676X.2019.1628806","volume":"11","author":"V Braun","year":"2019","unstructured":"Braun V, Clarke V (2019) Reflecting on reflexive thematic analysis. Qual Res Sport Exerc Health 11(4): 589\u2013597","journal-title":"Qual Res Sport Exerc Health"},{"issue":"3","key":"10295_CR6","doi-asserted-by":"publisher","first-page":"328","DOI":"10.1080\/14780887.2020.1769238","volume":"18","author":"V Braun","year":"2020","unstructured":"Braun V, Clarke V (2020) One size fits all? What counts as quality practice in (reflexive) thematic analysis? Qual Res Psychol 18(3):328\u2013352. https:\/\/doi.org\/10.1080\/14780887.2020.1769238","journal-title":"Qual Res Psychol"},{"key":"10295_CR7","doi-asserted-by":"crossref","unstructured":"Chen TH, Shang W, Jiang ZM, Hassan AE, Nasser M, Flora P (2014) Detecting performance anti-patterns for applications developed using object-relational mapping. In: Proceedings of the 36th international conference on software engineering, pp 1001\u20131012","DOI":"10.1145\/2568225.2568259"},{"issue":"12","key":"10295_CR8","doi-asserted-by":"publisher","first-page":"1148","DOI":"10.1109\/TSE.2016.2553039","volume":"42","author":"TH Chen","year":"2016","unstructured":"Chen TH, Shang W, Jiang ZM, Hassan AE, Nasser M, Flora P (2016) Finding and evaluating the performance impact of redundant data access for applications that are developed using object-relational mapping frameworks. IEEE Trans Softw Eng 42(12):1148\u20131161","journal-title":"IEEE Trans Softw Eng"},{"issue":"6","key":"10295_CR9","doi-asserted-by":"publisher","first-page":"3","DOI":"10.1145\/2499370.2462180","volume":"48","author":"A Cheung","year":"2013","unstructured":"Cheung A, Solar-Lezama A, Madden S (2013) Optimizing database-backed applications with query synthesis. ACM SIGPLAN Notices 48(6):3\u201314","journal-title":"ACM SIGPLAN Notices"},{"issue":"3","key":"10295_CR10","doi-asserted-by":"publisher","first-page":"494","DOI":"10.1037\/0033-2909.114.3.494","volume":"114","author":"N Cliff","year":"1993","unstructured":"Cliff N (1993) Dominance statistics: ordinal analyses to answer ordinal questions. Psychol Bull 114(3):494","journal-title":"Psychol Bull"},{"issue":"4","key":"10295_CR11","doi-asserted-by":"publisher","first-page":"213","DOI":"10.1037\/h0026256","volume":"70","author":"J Cohen","year":"1968","unstructured":"Cohen J (1968) Weighted kappa: nominal scale agreement provision for scaled disagreement or partial credit. Psychol Bull 70(4):213","journal-title":"Psychol Bull"},{"key":"10295_CR12","doi-asserted-by":"crossref","unstructured":"da Costa DA, Abebe SL, McIntosh S, Kulesza U, Hassan AE (2014) An empirical study of delays in the integration of addressed issues. In: 2014 IEEE international conference on software maintenance and evolution, IEEE, pp 281\u2013290","DOI":"10.1109\/ICSME.2014.50"},{"issue":"7","key":"10295_CR13","doi-asserted-by":"publisher","first-page":"641","DOI":"10.1109\/TSE.2016.2616306","volume":"43","author":"DA da Costa","year":"2016","unstructured":"da Costa DA, McIntosh S, Shang W, Kulesza U, Coelho R, Hassan AE (2016) A framework for evaluating the results of the SZZ approach for identifying bug-introducing changes. IEEE Trans Softw Eng 43(7): 641\u2013657","journal-title":"IEEE Trans Softw Eng"},{"key":"10295_CR14","doi-asserted-by":"crossref","unstructured":"de Almeida Filho FG, Martins ADF, da Silva Vinuto T, Monteiro JM, de Sousa IP, de Castro Machado J, Rocha LS (2019) Prevalence of bad smells in PL\/SQL projects. In: 2019 IEEE\/ACM 27Th international conference on program comprehension (ICPC), IEEE, pp 116\u2013121","DOI":"10.1109\/ICPC.2019.00025"},{"key":"10295_CR15","doi-asserted-by":"crossref","unstructured":"Dintyala P, Narechania A, Arulraj J (2020) SQLCheck: automated detection and diagnosis of SQL anti-patterns. In: Proceedings of the 2020 ACM SIGMOD international conference on management of data, pp 2331\u20132345","DOI":"10.1145\/3318464.3389754"},{"key":"10295_CR16","doi-asserted-by":"crossref","unstructured":"Edmundson A, Holtkamp B, Rivera E, Finifter M, Mettler A, Wagner D (2013) An empirical study on the effectiveness of security code review. In: International symposium on engineering secure software and systems, Springer, pp 197\u2013212","DOI":"10.1007\/978-3-642-36563-8_14"},{"key":"10295_CR17","doi-asserted-by":"crossref","unstructured":"Eessaar E (2015) On query-based search of possible design flaws of SQL databases. In: Innovations and advances in computing, informatics, systems sciences, networking and engineering, Springer, pp 53\u201360","DOI":"10.1007\/978-3-319-06773-5_8"},{"key":"10295_CR18","doi-asserted-by":"publisher","unstructured":"Faroult S, Robson P (2006) The Art of SQL. https:\/\/doi.org\/10.1604\/9780596008949","DOI":"10.1604\/9780596008949"},{"key":"10295_CR19","doi-asserted-by":"publisher","unstructured":"Gaspar D, Coric I (2017) Bridging relational and NoSQL databases. https:\/\/doi.org\/10.4018\/978-1-5225-3385-6.ch001","DOI":"10.4018\/978-1-5225-3385-6.ch001"},{"key":"10295_CR20","doi-asserted-by":"crossref","unstructured":"Giger E, Pinzger M, Gall H (2010) Predicting the fix time of bugs. In: Proceedings of the 2nd international workshop on recommendation systems for software engineering, pp 52\u201356","DOI":"10.1145\/1808920.1808933"},{"key":"10295_CR21","doi-asserted-by":"crossref","unstructured":"Gousios G (2013) The GHTorent dataset and tool suite. In: 2013 10th Working Conference on Mining Software Repositories (MSR). Accessed 10 March 2022. IEEE, pp 233\u2013236","DOI":"10.1109\/MSR.2013.6624034"},{"issue":"6","key":"10295_CR22","doi-asserted-by":"publisher","first-page":"77","DOI":"10.1145\/2345156.2254075","volume":"47","author":"G Jin","year":"2012","unstructured":"Jin G, Song L, Shi X, Scherpelz J, Lu S (2012) Understanding and detecting real-world performance bugs. ACM SIGPLAN Notices 47 (6):77\u201388","journal-title":"ACM SIGPLAN Notices"},{"key":"10295_CR23","doi-asserted-by":"crossref","unstructured":"Kalliamvakou E, Gousios G, Blincoe K, Singer L, German DM, Damian D (2014) The promises and perils of mining GitHub. In: Proceedings of the 11th working conference on mining software repositories, pp 92\u2013101","DOI":"10.1145\/2597073.2597074"},{"key":"10295_CR24","doi-asserted-by":"crossref","unstructured":"Kamei Y, Matsumoto S, Monden A, Matsumoto K, Adams B, Hassan AE (2010) Revisiting common bug prediction findings using effort-aware models. In: 2010 IEEE international conference on software maintenance, IEEE, pp 1\u201310","DOI":"10.1109\/ICSM.2010.5609530"},{"issue":"1","key":"10295_CR25","first-page":"1","volume":"28","author":"P Kampstra","year":"2008","unstructured":"Kampstra P (2008) Beanplot: a boxplot alternative for visual comparison of distributions. J Stat Softw 28(1):1\u20139","journal-title":"J Stat Softw"},{"key":"10295_CR26","doi-asserted-by":"crossref","unstructured":"Karampatsis RM, Sutton C (2020) How often do single-statement bugs occur? The manysstubs4j dataset. In: Proceedings of the 17th international conference on mining software repositories, pp 573\u2013577","DOI":"10.1145\/3379597.3387491"},{"key":"10295_CR27","unstructured":"Karwin B (2010) SQL antipatterns: avoiding the pitfalls of database programming. Pragmatic Bookshelf"},{"key":"10295_CR28","doi-asserted-by":"crossref","unstructured":"Kononenko O, Rose T, Baysal O, Godfrey M, Theisen D, De Water B (2018) Studying pull request merges: a case study of Shopify\u2019s active merchant. In: Proceedings of the 40th international conference on software engineering: software engineering in practice, pp 124\u2013133","DOI":"10.1145\/3183519.3183542"},{"issue":"260","key":"10295_CR29","doi-asserted-by":"publisher","first-page":"583","DOI":"10.1080\/01621459.1952.10483441","volume":"47","author":"WH Kruskal","year":"1952","unstructured":"Kruskal WH, Wallis WA (1952) Use of ranks in one-criterion variance analysis. J Am Stat Assoc 47(260):583\u2013621","journal-title":"J Am Stat Assoc"},{"key":"10295_CR30","doi-asserted-by":"publisher","unstructured":"Lohr SL (2009) Sampling: design and analysis. Brooks\/Cole. https:\/\/doi.org\/10.1604\/9780495105275","DOI":"10.1604\/9780495105275"},{"key":"10295_CR31","doi-asserted-by":"crossref","unstructured":"Lyu Y, Li D, Halfond WG (2018) Remove rats from your code: automated optimization of resource inefficient database writes for mobile applications. In: Proceedings of the 27th ACM SIGSOFT international symposium on software testing and analysis, pp 310\u2013321","DOI":"10.1145\/3213846.3213865"},{"key":"10295_CR32","doi-asserted-by":"crossref","unstructured":"Lyu Y, Alotaibi A, Halfond WG (2019) Quantifying the performance impact of SQL antipatterns on mobile applications. In: 2019 IEEE international conference on software maintenance and evolution (ICSME), IEEE, pp 53\u201364","DOI":"10.1109\/ICSME.2019.00015"},{"key":"10295_CR33","unstructured":"Mason T, Lawrence R (2005) Dynamic database integration in a JDBC driver. In: Seventh international conference on enterprise information systems (ICEIS), vol 1. Miami, USA, pp 326-333"},{"issue":"2","key":"10295_CR34","doi-asserted-by":"publisher","first-page":"143","DOI":"10.11613\/BM.2013.018","volume":"23","author":"ML McHugh","year":"2013","unstructured":"McHugh ML (2013) The chi-square test of independence. Biochemia medica 23(2):143\u2013149","journal-title":"Biochemia medica"},{"key":"10295_CR35","doi-asserted-by":"publisher","unstructured":"Melton J, Simon AR (1992) Understanding the New SQL: A Complete Guide. https:\/\/doi.org\/10.1604\/9781558602458","DOI":"10.1604\/9781558602458"},{"key":"10295_CR36","doi-asserted-by":"crossref","unstructured":"Mende T, Koschke R (2010) Effort-aware defect prediction models. In: 2010 14Th european conference on software maintenance and reengineering, IEEE, pp 107\u2013116","DOI":"10.1109\/CSMR.2010.18"},{"issue":"08","key":"10295_CR37","doi-asserted-by":"publisher","first-page":"79","DOI":"10.1109\/MC.2012.273","volume":"45","author":"T Mens","year":"2012","unstructured":"Mens T (2012) On the complexity of software systems. IEEE Comput Archit Lett 45(08):79\u201381","journal-title":"IEEE Comput Archit Lett"},{"issue":"4","key":"10295_CR38","doi-asserted-by":"publisher","first-page":"4","DOI":"10.1109\/MITP.2008.64","volume":"10","author":"KW Miller","year":"2008","unstructured":"Miller KW, Voas J (2008) Computer scientist, software engineer, or IT professional: which do you think you are? IT Professional 10(4):4\u20136","journal-title":"IT Professional"},{"key":"10295_CR39","doi-asserted-by":"crossref","unstructured":"Muse BA, Rahman MM, Nagy C, Cleve A, Khomh F, Antoniol G (2020) On the prevalence, impact, and evolution of SQL code smells in data-intensive systems. In: Proceedings of the 17th international conference on mining software repositories (MSR 2020), ACM Press, pp 327\u2013338","DOI":"10.1145\/3379597.3387467"},{"key":"10295_CR40","doi-asserted-by":"crossref","unstructured":"Nagy C, Cleve A (2015) Mining Stack Overflow for discovering error patterns in SQL queries. In: 2015 IEEE international conference on software maintenance and evolution (ICSME), IEEE, pp 516\u2013520","DOI":"10.1109\/ICSM.2015.7332505"},{"key":"10295_CR41","doi-asserted-by":"crossref","unstructured":"Nagy C, Cleve A (2018) SQLInspect: a static analyzer to inspect database usage in Java applications. In: Proceedings of the 40th international conference on software engineering: companion proceeedings, pp 93\u201396","DOI":"10.1145\/3183440.3183496"},{"key":"10295_CR42","doi-asserted-by":"crossref","unstructured":"Nagy C, Meurice L, Cleve A (2015) Where was this SQL query executed? a static concept location approach. In: 2015 IEEE 22Nd international conference on software analysis, evolution, and reengineering (SANER), IEEE, pp 580\u2013584","DOI":"10.1109\/SANER.2015.7081881"},{"key":"10295_CR43","doi-asserted-by":"crossref","unstructured":"Neto EC, da Costa DA, Kulesza U (2018) The impact of refactoring changes on the SZZ algorithm: an empirical study. In: 2018 IEEE 25Th international conference on software analysis, evolution and reengineering (SANER), IEEE, pp 380\u2013390","DOI":"10.1109\/SANER.2018.8330225"},{"key":"10295_CR44","unstructured":"O\u2019Leary Z (2017) The essential guide to doing your research project (Third). SAGE Publications Ltd. ISBN: 1473952085"},{"issue":"4","key":"10295_CR45","doi-asserted-by":"publisher","first-page":"2897","DOI":"10.1007\/s10664-020-09825-8","volume":"25","author":"P Pickerill","year":"2020","unstructured":"Pickerill P, Joshua JH, Miros\u0142aw O, Micha\u0142 M, Miroslaw S (2020) Phantom: curating github for engineered software projects using time-series clustering. Empir Softw Eng 25(4):2897\u20132929","journal-title":"Empir Softw Eng"},{"issue":"3","key":"10295_CR46","doi-asserted-by":"publisher","first-page":"263","DOI":"10.1145\/310663.310667","volume":"8","author":"A Podgurski","year":"1999","unstructured":"Podgurski A, Masri W, McCleese Y, Wolff FG, Yang C (1999) Estimation of software reliability by stratified sampling. ACM Trans Softw Eng Methodol (TOSEM) 8(3):263\u2013283","journal-title":"ACM Trans Softw Eng Methodol (TOSEM)"},{"key":"10295_CR47","doi-asserted-by":"crossref","unstructured":"Posnett D, Hindle A, Devanbu P (2011) Got issues? do new features and code improvements affect defects?. In: 2011 18Th working conference on reverse engineering, IEEE, pp 211\u2013215","DOI":"10.1109\/WCRE.2011.33"},{"key":"10295_CR48","doi-asserted-by":"crossref","unstructured":"Rahman MM, Roy CK (2014) An insight into the pull requests of GitHub. In: Proceedings of the 11th working conference on mining software repositories, pp 364\u2013367","DOI":"10.1145\/2597073.2597121"},{"key":"10295_CR49","doi-asserted-by":"crossref","unstructured":"Rigby PC, Hassan AE (2017) What can OSS mailing lists tell us? a preliminary psychometric text analysis of the Apache developer mailing list. In: Fourth international workshop on mining software repositories (MSR\u201907: ICSE workshops 2007), IEEE, pp 23\u201323","DOI":"10.1109\/MSR.2007.35"},{"key":"10295_CR50","doi-asserted-by":"crossref","unstructured":"Rith J, Lehmayr PS, Meyer-Wegener K (2014) Speaking in tongues: SQL access to noSQL systems. In: Proceedings of the 29th annual ACM symposium on applied computing, pp 855\u2013857","DOI":"10.1145\/2554850.2555099"},{"issue":"7","key":"10295_CR51","doi-asserted-by":"publisher","first-page":"984","DOI":"10.1287\/mnsc.1060.0554","volume":"52","author":"JA Roberts","year":"2006","unstructured":"Roberts JA, Hann IH, Slaughter SA (2006) Understanding the motivations, participation, and performance of open source software developers: a longitudinal study of the Apache projects. Manag Sci 52(7):984\u2013999","journal-title":"Manag Sci"},{"issue":"3\/4","key":"10295_CR52","doi-asserted-by":"publisher","first-page":"591","DOI":"10.2307\/2333709","volume":"52","author":"SS Shapiro","year":"1965","unstructured":"Shapiro SS, Wilk MB (1965) An analysis of variance test for normality (complete samples). Biometrika 52(3\/4):591\u2013611","journal-title":"Biometrika"},{"key":"10295_CR53","doi-asserted-by":"crossref","unstructured":"Shepperd M (2014) Cost prediction and software project management. Softw Proj Manag Chang World, pp 51\u201371","DOI":"10.1007\/978-3-642-55035-5_3"},{"key":"10295_CR54","doi-asserted-by":"crossref","unstructured":"Usman M, Mendes E, Weidt F, Britto R (2014) Effort estimation in agile software development: a systematic literature review. In: Proceedings of the 10th international conference on predictive models in software engineering, pp 82\u201391","DOI":"10.1145\/2639490.2639503"},{"key":"10295_CR55","doi-asserted-by":"crossref","unstructured":"Van Der Veen E, Gousios G, Zaidman A (2015) Automatically prioritizing pull requests. In: 2015 IEEE\/ACM 12Th working conference on mining software repositories, IEEE, pp 357\u2013361","DOI":"10.1109\/MSR.2015.40"},{"issue":"2","key":"10295_CR56","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/3433928","volume":"30","author":"B Vandehei","year":"2021","unstructured":"Vandehei B, da Costa DA, Falessi D (2021) Leveraging the defects life cycle to label affected versions and defective classes. ACM Trans Softw Eng Methodol (TOSEM) 30(2):1\u201335","journal-title":"ACM Trans Softw Eng Methodol (TOSEM)"},{"key":"10295_CR57","unstructured":"Walenstein A (2002) Cognitive support in software engineering tools: a distributed cognition framework. Ph.D. thesis, Citeseer"},{"issue":"4","key":"10295_CR58","doi-asserted-by":"publisher","first-page":"14","DOI":"10.1145\/1276933.1276935","volume":"16","author":"G Wassermann","year":"2007","unstructured":"Wassermann G, Gould C, Su Z, Devanbu P (2007) Static checking of dynamically generated queries in database applications. ACM Trans Softw Eng Methodol (TOSEM) 16(4):14\u2013es","journal-title":"ACM Trans Softw Eng Methodol (TOSEM)"},{"key":"10295_CR59","doi-asserted-by":"crossref","unstructured":"Weiss C, Premraj R, Zimmermann T, Zeller A (2007) How long will it take to fix this bug?. In: Fourth international workshop on mining software repositories (MSR\u201907: ICSE workshops 2007), IEEE, pp 1\u20131","DOI":"10.1109\/MSR.2007.13"},{"issue":"3","key":"10295_CR60","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/2738037","volume":"24","author":"PA Whigham","year":"2015","unstructured":"Whigham PA, Owen CA, Macdonell SG (2015) A baseline model for software effort estimation. ACM Trans Softw Eng Methodol (TOSEM) 24(3):1\u201311","journal-title":"ACM Trans Softw Eng Methodol (TOSEM)"},{"key":"10295_CR61","volume-title":"Statistical methods in the atmospheric sciences","author":"DS Wilks","year":"2011","unstructured":"Wilks DS (2011) Statistical methods in the atmospheric sciences, 3rd edn. Academic Press, New York","edition":"3rd edn."},{"key":"10295_CR62","doi-asserted-by":"crossref","unstructured":"Yatish S, Jiarpakdee J, Thongtanunam P, Tantithamthavorn C (2019) Mining software defects: should we consider affected releases?. In: 2019 IEEE\/ACM 41St international conference on software engineering (ICSE), IEEE, pp 654\u2013665","DOI":"10.1109\/ICSE.2019.00075"},{"issue":"1","key":"10295_CR63","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/2693208.2693239","volume":"40","author":"M Yilmaz","year":"2015","unstructured":"Yilmaz M, O\u2019Connor RV, Clarke P (2015) Software development roles: a multi-project empirical investigation. ACM SIGSOFT Softw Eng Notes 40 (1):1\u20135","journal-title":"ACM SIGSOFT Softw Eng Notes"},{"issue":"4","key":"10295_CR64","doi-asserted-by":"publisher","first-page":"2140","DOI":"10.1007\/s10664-019-09696-8","volume":"24","author":"G Zhao","year":"2019","unstructured":"Zhao G, da Costa DA, Zou Y (2019) Improving the pull requests review process using learning-to-rank algorithms. Empir Softw Eng 24(4):2140\u20132170","journal-title":"Empir Softw Eng"}],"container-title":["Empirical Software Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10664-023-10295-x.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s10664-023-10295-x\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10664-023-10295-x.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,5,26]],"date-time":"2023-05-26T21:03:22Z","timestamp":1685135002000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s10664-023-10295-x"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,4,21]]},"references-count":64,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2023,5]]}},"alternative-id":["10295"],"URL":"https:\/\/doi.org\/10.1007\/s10664-023-10295-x","relation":{},"ISSN":["1382-3256","1573-7616"],"issn-type":[{"type":"print","value":"1382-3256"},{"type":"electronic","value":"1573-7616"}],"subject":[],"published":{"date-parts":[[2023,4,21]]},"assertion":[{"value":"24 January 2023","order":1,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"21 April 2023","order":2,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}],"article-number":"69"}}