{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,8]],"date-time":"2026-10-08T11:35:57Z","timestamp":1791459357232,"version":"4.3.4"},"reference-count":83,"publisher":"Institute of Electrical and Electronics Engineers (IEEE)","issue":"6","license":[{"start":{"date-parts":[[2023,6,1]],"date-time":"2023-06-01T00:00:00Z","timestamp":1685577600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/ieeexplore.ieee.org\/Xplorehelp\/downloads\/license-information\/IEEE.html"},{"start":{"date-parts":[[2023,6,1]],"date-time":"2023-06-01T00:00:00Z","timestamp":1685577600000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-029"},{"start":{"date-parts":[[2023,6,1]],"date-time":"2023-06-01T00:00:00Z","timestamp":1685577600000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-037"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["IIEEE Trans. Software Eng."],"published-print":{"date-parts":[[2023,6,1]]},"DOI":"10.1109\/tse.2023.3253700","type":"journal-article","created":{"date-parts":[[2023,3,7]],"date-time":"2023-03-07T18:57:15Z","timestamp":1678215435000},"page":"3376-3390","source":"Crossref","is-referenced-by-count":6,"title":["SLocator: Localizing the Origin of SQL Queries in Database-Backed Web Applications"],"prefix":"10.1109","volume":"49","author":[{"ORCID":"https:\/\/orcid.org\/0000-0001-8956-730X","authenticated-orcid":false,"given":"Wei","family":"Liu","sequence":"first","affiliation":[{"name":"Software PErformance, Analysis, and Reliability (SPEAR) Lab, Concordia University, Montreal, QC, Canada"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-4027-0905","authenticated-orcid":false,"given":"Tse-Hsun","family":"Chen","sequence":"additional","affiliation":[{"name":"Software PErformance, Analysis, and Reliability (SPEAR) Lab, Concordia University, Montreal, QC, Canada"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"263","reference":[{"key":"ref13","doi-asserted-by":"publisher","DOI":"10.1145\/2597008.2597788"},{"key":"ref57","doi-asserted-by":"publisher","DOI":"10.1145\/1376815.1376819"},{"key":"ref12","doi-asserted-by":"publisher","DOI":"10.1109\/ICSME.2014.40"},{"key":"ref56","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2018.00233"},{"key":"ref15","doi-asserted-by":"publisher","DOI":"10.1145\/2970276.2970359"},{"key":"ref59","doi-asserted-by":"publisher","DOI":"10.1145\/2950290.2950303"},{"key":"ref14","first-page":"921","article-title":"AmaLgam+: Composing rich information sources for accurate bug localization","volume":"28","author":"wang","year":"2016","journal-title":"Journal of Software: Evolution and Process"},{"key":"ref58","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2019.2913381"},{"key":"ref53","article-title":"Eager fetching is a code smell when using JPA and hibernate","year":"2021"},{"key":"ref52","article-title":"JAX-RS: Java API for restful web services","year":"2013"},{"key":"ref11","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE.2012.6227210"},{"key":"ref55","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2018.2831214"},{"key":"ref10","doi-asserted-by":"publisher","DOI":"10.1109\/SANER.2015.7081881"},{"key":"ref54","doi-asserted-by":"publisher","DOI":"10.1007\/s10664-015-9402-8"},{"key":"ref17","doi-asserted-by":"publisher","DOI":"10.1145\/3395363.3397356"},{"key":"ref16","doi-asserted-by":"publisher","DOI":"10.1145\/3213846.3213856"},{"key":"ref19","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE-SEIP52600.2021.00028"},{"key":"ref18","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2021.3071473"},{"key":"ref51","article-title":"Usage statistics of site elements for websites","year":"2022"},{"key":"ref50","doi-asserted-by":"publisher","DOI":"10.1109\/32.877846"},{"key":"ref46","doi-asserted-by":"publisher","DOI":"10.1109\/ICPC.2011.48"},{"key":"ref45","doi-asserted-by":"publisher","DOI":"10.1109\/SANER50967.2021.00034"},{"key":"ref48","doi-asserted-by":"publisher","DOI":"10.1007\/s10664-020-09823-w"},{"key":"ref47","doi-asserted-by":"publisher","DOI":"10.1109\/ASE.2011.6100144"},{"key":"ref42","doi-asserted-by":"publisher","DOI":"10.1109\/ISSRE.2014.39"},{"key":"ref41","doi-asserted-by":"publisher","DOI":"10.1145\/3460319.3464818"},{"key":"ref44","doi-asserted-by":"publisher","DOI":"10.1109\/ICSME.2014.39"},{"key":"ref43","doi-asserted-by":"publisher","DOI":"10.1145\/2635868.2661678"},{"key":"ref49","doi-asserted-by":"publisher","DOI":"10.1109\/SANER50967.2021.00024"},{"key":"ref8","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.2016.2553039"},{"key":"ref7","article-title":"Hibernate debugging - finding the origin of a query","author":"cavalheiro","year":"2022"},{"key":"ref9","article-title":"Hibernate show real SQL","year":"2021"},{"key":"ref4","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE.2019.00104"},{"key":"ref3","article-title":"Java development research report: Landscape 2014","year":"2014"},{"key":"ref6","doi-asserted-by":"publisher","DOI":"10.1145\/2568225.2568259"},{"key":"ref5","doi-asserted-by":"publisher","DOI":"10.1145\/2889160.2889228"},{"key":"ref82","article-title":"Lockmodetype","year":"2015"},{"key":"ref81","article-title":"An innodb deadlock example","year":"2020"},{"key":"ref40","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-17164-2_10"},{"key":"ref83","article-title":"How do lockmodetype.pessimistic_read and lockmodetype.pessimistic_write work in jpa and hibernate","author":"mihalcea","year":"2019"},{"key":"ref80","article-title":"Deadlocks in innodb","year":"0"},{"key":"ref35","article-title":"Modeling and analysis of SQL queries in PHP systems","author":"anderson","year":"2018"},{"key":"ref79","article-title":"The slow query log","year":"2020"},{"key":"ref34","doi-asserted-by":"publisher","DOI":"10.1016\/j.scico.2022.102778"},{"key":"ref78","article-title":"Spring framework","year":"2021"},{"key":"ref37","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-59536-8_32"},{"key":"ref36","first-page":"491","article-title":"Static analysis of dynamic database usage in Java systems","author":"meurice","year":"2016","journal-title":"Advanced Information Systems Engineering"},{"key":"ref31","first-page":"101","author":"keith","year":"2018","journal-title":"Pro JPA 2 in Java EE 8 An In-Depth Guide to Java Persistence APIs"},{"key":"ref75","article-title":"MySQL server logs","year":"2020"},{"key":"ref30","article-title":"JSR 338: Java persistence API, version 2.2","year":"2017"},{"key":"ref74","article-title":"The aspectj project","author":"foundation","year":"2021"},{"key":"ref33","doi-asserted-by":"publisher","DOI":"10.1145\/2491411.2491412"},{"key":"ref77","article-title":"The general query log","year":"2020"},{"key":"ref32","doi-asserted-by":"publisher","DOI":"10.1109\/QSIC.2004.1357967"},{"key":"ref76","article-title":"Error reporting and logging","year":"2020"},{"key":"ref2","doi-asserted-by":"publisher","DOI":"10.1145\/3180155.3180194"},{"key":"ref1","first-page":"165","article-title":"An Empirical Study on the Practice of Maintaining Object-Relational Mapping Code in Java Systems","author":"chen","year":"2016","journal-title":"2016 IEEE\/ACM 13th Conference on Mining Software Repositories (MSR)"},{"key":"ref39","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE.2004.1317486"},{"key":"ref38","doi-asserted-by":"publisher","DOI":"10.1145\/3183440.3183496"},{"key":"ref71","year":"2022"},{"key":"ref70","article-title":"Multilingual easy-to-customize open source CMS made by Java","year":"2022"},{"key":"ref73","article-title":"Apache JMeter","author":"foundation","year":"2021"},{"key":"ref72","year":"2022"},{"key":"ref24","doi-asserted-by":"publisher","DOI":"10.1007\/s10664-020-09882-z"},{"key":"ref68","article-title":"Broadleafcommerce - enterprise ecommerce framework based on spring","year":"2022"},{"key":"ref23","doi-asserted-by":"publisher","DOI":"10.1145\/1735971.1736038"},{"key":"ref67","year":"2022"},{"key":"ref26","doi-asserted-by":"publisher","DOI":"10.1109\/ICC.2015.7249470"},{"key":"ref25","article-title":"Logging","year":"2018"},{"key":"ref69","year":"2022"},{"key":"ref20","doi-asserted-by":"publisher","DOI":"10.1145\/3132847.3132954"},{"key":"ref64","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3064037"},{"key":"ref63","doi-asserted-by":"publisher","DOI":"10.1109\/ICSE.2019.00076"},{"key":"ref22","doi-asserted-by":"publisher","DOI":"10.1145\/1453101.1453146"},{"key":"ref66","year":"2022"},{"key":"ref21","doi-asserted-by":"publisher","DOI":"10.1109\/ICSME46990.2020.00016"},{"key":"ref65","article-title":"A sample spring-based application","year":"2022"},{"key":"ref28","article-title":"Online appendix\/replication package for “SLocator: Localizing the origin of SQL queries in database-backed web applications","year":"2021"},{"key":"ref27","first-page":"415","article-title":"Learning to log: helping developers make informed logging decisions","author":"zhu","year":"2015","journal-title":"Proceedings of the International Conference on Software Engineering ICSE'94"},{"key":"ref29","article-title":"Improving the performance of database-centric applications through program analysis","author":"chen","year":"2016"},{"key":"ref60","doi-asserted-by":"publisher","DOI":"10.1145\/2851553.2851576"},{"key":"ref62","doi-asserted-by":"publisher","DOI":"10.1109\/SCAM52516.2021.00035"},{"key":"ref61","doi-asserted-by":"publisher","DOI":"10.1145\/3338906.3338970"}],"container-title":["IEEE Transactions on Software Engineering"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx7\/32\/10149541\/10061567.pdf?arnumber=10061567","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,6,14]],"date-time":"2023-06-14T17:22:01Z","timestamp":1686763321000},"score":1,"resource":{"primary":{"URL":"https:\/\/ieeexplore.ieee.org\/document\/10061567\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,6,1]]},"references-count":83,"journal-issue":{"issue":"6"},"URL":"https:\/\/doi.org\/10.1109\/tse.2023.3253700","relation":{},"ISSN":["0098-5589","1939-3520","2326-3881"],"issn-type":[{"value":"0098-5589","type":"print"},{"value":"1939-3520","type":"electronic"},{"value":"2326-3881","type":"electronic"}],"subject":[],"published":{"date-parts":[[2023,6,1]]}}}