{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,15]],"date-time":"2026-05-15T15:44:18Z","timestamp":1778859858986,"version":"3.51.4"},"reference-count":58,"publisher":"Springer Science and Business Media LLC","issue":"4","license":[{"start":{"date-parts":[[2022,3,19]],"date-time":"2022-03-19T00:00:00Z","timestamp":1647648000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2022,3,19]],"date-time":"2022-03-19T00:00:00Z","timestamp":1647648000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Software Qual J"],"published-print":{"date-parts":[[2022,12]]},"DOI":"10.1007\/s11219-022-09586-1","type":"journal-article","created":{"date-parts":[[2022,3,19]],"date-time":"2022-03-19T07:02:51Z","timestamp":1647673371000},"page":"885-916","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["Using artificial neural networks to provide guidance in extending PL\/SQL programs"],"prefix":"10.1007","volume":"30","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-6100-9514","authenticated-orcid":false,"given":"Ersin","family":"Ersoy","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hasan","family":"S\u00f6zer","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2022,3,19]]},"reference":[{"key":"9586_CR1","doi-asserted-by":"crossref","unstructured":"Abdeen, H., Ducasse, S., Sahraoui, H., & Alloui, I. (2009). Automatic package coupling and cycle minimization. In: Proceedings of the 16th Working Conference on Reverse Engineering, pp. 103\u2013112.","DOI":"10.1109\/WCRE.2009.13"},{"key":"9586_CR2","doi-asserted-by":"crossref","unstructured":"Alt\u0131n\u0131\u015f\u0131k, M., Ersoy, E., & S\u00f6zer, H. (2017). Evaluating software architecture erosion for PL\/SQL programs. In: Proceedings of the 11th European Conference on Software Architecture: Companion Proceedings, pp. 159\u2013165. ACM.","DOI":"10.1145\/3129790.3129811"},{"key":"9586_CR3","doi-asserted-by":"crossref","unstructured":"Alt\u0131n\u0131\u015f\u0131k, M., & S\u00f6zer, H. (2016). Automated procedure clustering for reverse engineering PL\/SQL programs. In: Proceedings of the 31st ACM\/SIGAPP Symposium on Applied Computing, pp. 1440\u20131445.","DOI":"10.1145\/2851613.2851781"},{"key":"9586_CR4","unstructured":"Bales, D. (2002). Java programming with Oracle JDBC. O\u2019Reilly Media, Inc."},{"key":"9586_CR5","doi-asserted-by":"crossref","unstructured":"Bavota, G., Lucia, A. D., Marcus, A., & Oliveto, R (2013). Using structural and semantic measures to improve software modularization. Empirical Software Engineering 18(5), 901\u2013932.","DOI":"10.1007\/s10664-012-9226-8"},{"key":"9586_CR6","unstructured":"Bergstra, J., & Bengio, Y. (2012). Random search for hyper-parameter optimization. Journal of Machine Learning Research 13,\u00a0281\u2013305."},{"key":"9586_CR7","doi-asserted-by":"crossref","unstructured":"Boser, B. E., Guyon, I. M., & Vapnik, V. N. (1992). A training algorithm for optimal margin classifiers. In: Proceedings of the fifth annual workshop on Computational learning theory, pp. 144\u2013152. ACM.","DOI":"10.1145\/130385.130401"},{"issue":"3","key":"9586_CR8","first-page":"233","volume":"25","author":"T Callo","year":"2013","unstructured":"Callo, T., America, P., & Avgeriou, P. (2013). A top-down approach to construct execution views of a large software-intensive system. Journal of Software: Evolution and Process, 25(3), 233\u2013260.","journal-title":"Journal of Software: Evolution and Process"},{"key":"9586_CR9","doi-asserted-by":"crossref","unstructured":"Chaparro, O., Aponte, J., Ortega, F., & Marcus, A. (2012). Towards the automatic extraction of structural business rules from legacy databases. In: Proceedings of the 19th Working Conference on Reverse Engineering, pp. 479\u2013488.","DOI":"10.1109\/WCRE.2012.57"},{"key":"9586_CR10","doi-asserted-by":"crossref","unstructured":"Chen, C., Alfayez, R., Srisopha, K., Boehm, B., & Shi, L. (2017). Why is it important to measure maintainability, and what are the best ways to do it? In: Proceedings of the 39th International Conference on Software Engineering Companion, p. 377\u2013378.","DOI":"10.1109\/ICSE-C.2017.75"},{"key":"9586_CR11","unstructured":"Chester, D. L. (1990). Why two hidden layers are better than one. In: Proceedings of the international joint conference on neural networks, 1,\u00a0\u00a0pp. 265\u2013268"},{"issue":"3","key":"9586_CR12","first-page":"273","volume":"20","author":"C Cortes","year":"1995","unstructured":"Cortes, C., & Vapnik, V. (1995). Support-vector networks. Machine learning, 20(3), 273\u2013297.","journal-title":"Support-vector networks. Machine learning"},{"key":"9586_CR13","doi-asserted-by":"crossref","unstructured":"Cox, D. R. (1958). The regression analysis of binary sequences. Journal of the Royal Statistical Society. Series B (Methodological),\u00a0pp. 215\u2013242","DOI":"10.1111\/j.2517-6161.1958.tb00292.x"},{"key":"9586_CR14","unstructured":"Deb, K. (2001). Multi-objective optimization using evolutionary algorithms, vol. 16. John Wiley & Sons."},{"issue":"2","key":"9586_CR15","doi-asserted-by":"publisher","first-page":"182","DOI":"10.1109\/4235.996017","volume":"6","author":"K Deb","year":"2002","unstructured":"Deb, K., Pratap, A., Agarwal, S., & Meyarivan, T. (2002). A fast and elitist multiobjective genetic algorithm: Nsga-ii. IEEE transactions on evolutionary computation, 6(2), 182\u2013197.","journal-title":"IEEE transactions on evolutionary computation"},{"issue":"4","key":"9586_CR16","doi-asserted-by":"publisher","first-page":"573","DOI":"10.1109\/TSE.2009.19","volume":"35","author":"S Ducasse","year":"2009","unstructured":"Ducasse, S., & Pollet, D. (2009). Software architecture reconstruction: A process-oriented taxonomy. IEEE Transactions on Software Engineering, 35(4), 573\u2013591.","journal-title":"IEEE Transactions on Software Engineering"},{"key":"9586_CR17","doi-asserted-by":"crossref","unstructured":"Ersoy, E., Kaya, K., Alt\u0131n\u0131\u015f\u0131k, M., & S\u00f6zer, H. (2016). Using hypergraph clustering for software architecture reconstruction of data-tier software. In: European Conference on Software Architecture, pp. 326\u2013333. Springer","DOI":"10.1007\/978-3-319-48992-6_24"},{"key":"9586_CR18","unstructured":"Fausett, L.V. (1994). Fundamentals of Neural Networks: Architectures, Algorithms, and Applications. Prentice-Hall."},{"key":"9586_CR19","doi-asserted-by":"crossref","unstructured":"Garcia, J., Popescu, D., Edwards, G., & Medvidovic, N. (2009). Toward a catalogue of architectural bad smells. In: Proceedings of the International Conference on the Quality of Software Architectures, pp. 146\u2013162.","DOI":"10.1007\/978-3-642-02351-4_10"},{"key":"9586_CR20","doi-asserted-by":"crossref","unstructured":"Gardikiotis, S.K., Malevris, N., & Konstantinou, T. (2004). A structural approach towards the maintenance of database applications. In: Proceedings of the International Database Engineering and Applications Symposium, pp. 277\u2013282.","DOI":"10.1109\/IDEAS.2004.1319801"},{"issue":"4","key":"9586_CR21","doi-asserted-by":"publisher","first-page":"1360","DOI":"10.1214\/08-AOAS191","volume":"2","author":"A Gelman","year":"2008","unstructured":"Gelman, A., Jakulin, A., Pittau, M. G., Su, Y. S., et al. (2008). A weakly informative default prior distribution for logistic and other regression models. The Annals of Applied Statistics, 2(4), 1360\u20131383.","journal-title":"The Annals of Applied Statistics"},{"issue":"4","key":"9586_CR22","first-page":"e1916","volume":"30","author":"A Ghannem","year":"2018","unstructured":"Ghannem, A., Kessentini, M., Hamdi, M. S., & El Boussaidi, G. (2018). Model refactoring by example: A multi-objective search based software engineering approach. Journal of Software: Evolution and Process, 30(4), e1916.","journal-title":"Journal of Software: Evolution and Process"},{"key":"9586_CR23","unstructured":"Gulesir, G. (2008). Evolvable behavior specifications using context-sensitive wildcards. Ph.D. thesis, University of Twente."},{"key":"9586_CR24","doi-asserted-by":"crossref","unstructured":"Guo, G., Atlee, J., & Kazman, R. (1999). A software architecture reconstruction method. In: Proceedings of the First Working Conference on Software Architecture, pp. 15\u201334. Deventer, The Netherlands, The Netherlands.","DOI":"10.1007\/978-0-387-35563-4_2"},{"key":"9586_CR25","doi-asserted-by":"crossref","unstructured":"Habringer, M., Moser, M., & Pichler, J. (2014). Reverse engineering PL\/SQL legacy code: An experience report. In: Proceedings of the IEEE International Conference on Software Maintenance and Evolution, pp. 553\u2013556.","DOI":"10.1109\/ICSME.2014.93"},{"key":"9586_CR26","volume-title":"Machine learning in action","author":"P Harrington","year":"2012","unstructured":"Harrington, P. (2012). Machine learning in action. Shelter Island, NY: Manning Publications Co."},{"issue":"15","key":"9586_CR27","doi-asserted-by":"publisher","first-page":"911","DOI":"10.1016\/S0950-5849(02)00128-3","volume":"44","author":"A Heiat","year":"2002","unstructured":"Heiat, A. (2002). Comparison of artificial neural network and regression models for estimating software development effort. Information and software Technology, 44(15), 911\u2013922.","journal-title":"Information and software Technology"},{"key":"9586_CR28","unstructured":"Henderson, K. (2000). The guru\u2019s guide to Transact-SQL. Addison-Wesley Professional."},{"key":"9586_CR29","unstructured":"Ho, T. K. (1995). Random decision forests. In: Document analysis and recognition. Proceedings of the third international conference on 1, 278\u2013282. IEEE."},{"key":"9586_CR30","unstructured":"Idri, A., Khoshgoftaar, T. M., & Abran, A. (2002). Can neural networks be easily interpreted in software cost estimation? In: Fuzzy Systems, 2002. FUZZ-IEEE\u201902. Proceedings of the 2002 IEEE International Conference on,\u00a02, 1162\u20131167. IEEE."},{"issue":"2","key":"9586_CR31","doi-asserted-by":"publisher","first-page":"670","DOI":"10.1007\/s10664-016-9442-8","volume":"22","author":"M Kessentini","year":"2017","unstructured":"Kessentini, M., Mansoor, U., Wimmer, M., Ouni, A., & Deb, K. (2017). Search-based detection of model level changes. Empirical Software Engineering, 22(2), 670\u2013715.","journal-title":"Empirical Software Engineering"},{"key":"9586_CR32","unstructured":"Kohavi, R., et\u00a0al. (1995). A study of cross-validation and bootstrap for accuracy estimation and model selection. In: Ijcai, 14, 1137\u20131145. Montreal, Canada."},{"key":"9586_CR33","unstructured":"Laser, M., Medvidovic, N., Le, D., & Garcia, J. (2020). ARCADE: an extensible workbench for architecture recovery, change, and decay evaluation. In: Proceedings of the 28th ACM Joint Meeting on European Software Engineering Conference and Symposium on the Foundations of Software Engineering, pp. 1546\u20131550."},{"issue":"1","key":"9586_CR34","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1016\/S0378-7206(98)00041-X","volume":"34","author":"A Lee","year":"1998","unstructured":"Lee, A., Cheng, C. H., & Balakrishnan, J. (1998). Software development cost estimation: integrating neural network with cluster analysis. Information & Management, 34(1), 1\u20139.","journal-title":"Information & Management"},{"issue":"2","key":"9586_CR35","doi-asserted-by":"publisher","first-page":"159","DOI":"10.1109\/TSE.2017.2671865","volume":"44","author":"T Lutellier","year":"2018","unstructured":"Lutellier, T., Chollak, D., Garcia, J., Tan, L., Rayside, D., Medvidovic, N., & Kroeger, R. (2018). Measuring the impact of code dependencies on software architecture recovery techniques. IEEE Transactions on Software Engineering, 44(2), 159\u2013181.","journal-title":"IEEE Transactions on Software Engineering"},{"issue":"2","key":"9586_CR36","doi-asserted-by":"publisher","first-page":"529","DOI":"10.1007\/s11219-016-9309-7","volume":"25","author":"U Mansoor","year":"2017","unstructured":"Mansoor, U., Kessentini, M., Maxim, B. R., & Deb, K. (2017). Multi-objective code-smells detection using good and bad design examples. Software Quality Journal, 25(2), 529\u2013552.","journal-title":"Software Quality Journal"},{"issue":"3","key":"9586_CR37","doi-asserted-by":"publisher","first-page":"193","DOI":"10.1109\/TSE.2006.31","volume":"32","author":"B Mitchell","year":"2006","unstructured":"Mitchell, B., & Mancoridis, S. (2006). On the automatic modularization of software systems using the bunch tool. IEEE Transactions on Software Engineering, 32(3), 193\u2013208.","journal-title":"IEEE Transactions on Software Engineering"},{"issue":"2","key":"9586_CR38","doi-asserted-by":"publisher","first-page":"894","DOI":"10.1007\/s10664-016-9426-8","volume":"22","author":"MW Mkaouer","year":"2017","unstructured":"Mkaouer, M. W., Kessentini, M., Cinn\u00e9ide, M. \u00d3., Hayashi, S., & Deb, K. (2017). A robust multi-objective approach to balance severity and importance of refactoring opportunities. Empirical Software Engineering, 22(2), 894\u2013927.","journal-title":"Empirical Software Engineering"},{"key":"9586_CR39","unstructured":"Nelson, M. (2005). A survey of reverse engineering and program comprehension. CoRR abs\/cs\/0503068."},{"key":"9586_CR40","doi-asserted-by":"publisher","first-page":"55","DOI":"10.1016\/j.infsof.2016.11.007","volume":"83","author":"A Ouni","year":"2017","unstructured":"Ouni, A., Kula, R. G., Kessentini, M., Ishio, T., German, D. M., & Inoue, K. (2017). Search-based software library recommendation using multi-objective optimization. Information and Software Technology, 83, 55\u201375.","journal-title":"Information and Software Technology"},{"key":"9586_CR41","unstructured":"Oracle Database. (2019). Online Documentation 11g Release developing and using stored procedures. http:\/\/docs.oracle.com\/cd\/B28359_01\/appdev.111\/b28843\/tdddg_procedures.htm.\u00a0Accessed in Oct 2019."},{"issue":"2","key":"9586_CR42","doi-asserted-by":"publisher","first-page":"332","DOI":"10.7763\/IJCTE.2011.V3.328","volume":"3","author":"G Panchal","year":"2011","unstructured":"Panchal, G., Ganatra, A., Kosta, Y., & Panchal, D. (2011). Behaviour analysis of multilayer perceptronswith multiple hidden neurons and hidden layers. International Journal of Computer Theory and Engineering, 3(2), 332.","journal-title":"International Journal of Computer Theory and Engineering"},{"issue":"12","key":"9586_CR43","doi-asserted-by":"publisher","first-page":"1053","DOI":"10.1145\/361598.361623","volume":"15","author":"DL Parnas","year":"1972","unstructured":"Parnas, D. L. (1972). On the criteria to be used in decomposing systems into modules. Communications of the ACM, 15(12), 1053\u20131058.","journal-title":"Communications of the ACM"},{"key":"9586_CR44","doi-asserted-by":"crossref","unstructured":"Patel, C., Hamou-Lhadj, A., & Rilling, J. (2008). Software clustering using dynamic analysis and static dependencies. In: Proceedings of the 13th European Conference on Software Maintenance and Reengineering, pp. 27\u201336.","DOI":"10.1109\/CSMR.2009.62"},{"key":"9586_CR45","unstructured":"Pedregosa, F., Varoquaux, G., Gramfort, A., Michel, V., Thirion, B., Grisel, O., Blondel, M., Prettenhofer, P., Weiss, R., & Dubourg, V., et\u00a0al. (2011). Scikit-learn.\u00a0Machine learning in python. Journal of machine learning research 12,\u00a02825\u20132830."},{"issue":"2","key":"9586_CR46","doi-asserted-by":"publisher","first-page":"264","DOI":"10.1109\/TSE.2010.26","volume":"37","author":"K Praditwong","year":"2011","unstructured":"Praditwong, K., Harman, M., & Yao, X. (2011). Software module clustering as a multi-objective search problem. IEEE Transactions on Software Engineering, 37(2), 264\u2013282.","journal-title":"IEEE Transactions on Software Engineering"},{"key":"9586_CR47","doi-asserted-by":"crossref","unstructured":"\u00a0Qingshan, L., et al. (2005). Architecture recovery and abstraction from the perspective of processes. In: WCRE, pp. 57\u201366.","DOI":"10.1109\/WCRE.2005.6"},{"issue":"1","key":"9586_CR48","first-page":"81","volume":"1","author":"JR Quinlan","year":"1986","unstructured":"Quinlan, J. R. (1986). Induction of decision trees. Machine learning, 1(1), 81\u2013106.","journal-title":"Induction of decision trees. Machine learning"},{"issue":"2","key":"9586_CR49","doi-asserted-by":"publisher","first-page":"137","DOI":"10.1007\/BF00993275","volume":"15","author":"R Schwanke","year":"1994","unstructured":"Schwanke, R., & Hanson, S. (1994). Using neural networks to modularize software. Machine Learning, 15(2), 137\u2013168.","journal-title":"Machine Learning"},{"key":"9586_CR50","doi-asserted-by":"crossref","unstructured":"Strni\u0161a, R., Sewell, P., & Parkinson, M. (2007). The Java module system: Core design and semantic definition. In: Proceedings of the 22nd Annual ACM SIGPLAN Conference on Object-Oriented Programming Systems, Languages and Applications, p. 499\u2013514.","DOI":"10.1145\/1297105.1297064"},{"key":"9586_CR51","unstructured":"Sun, C., Zhou, J., Cao, J., Jin, M., Liu, C., & Shen, Y. (2005). ReArchJBs: a tool for automated software architecture recovery of javabeans-based applications. In: Proceedings of the 16th Australian Software Engineering Conference, pp. 270\u2013280."},{"issue":"1\u20132","key":"9586_CR52","doi-asserted-by":"publisher","first-page":"167","DOI":"10.1093\/biomet\/54.1-2.167","volume":"54","author":"SH Walker","year":"1967","unstructured":"Walker, S. H., & Duncan, D. B. (1967). Estimation of the probability of an event as a function of several independent variables. Biometrika, 54(1\u20132), 167\u2013179.","journal-title":"Biometrika"},{"key":"9586_CR53","doi-asserted-by":"crossref","unstructured":"Wawer, A., Nielek, R., & Wierzbicki, A. (2014). Predicting webpage credibility using linguistic features. In: Proceedings of the 23rd international conference on world wide web, pp. 1135\u20131140.","DOI":"10.1145\/2567948.2579000"},{"issue":"1","key":"9586_CR54","doi-asserted-by":"publisher","first-page":"149","DOI":"10.1109\/TR.2011.2172031","volume":"61","author":"WE Wong","year":"2012","unstructured":"Wong, W. E., Debroy, V., Golden, R., Xu, X., & Thuraisingham, B. M. (2012). Effective software fault localization using an RBF neural network. IEEE Transactions on Reliability, 61(1), 149\u2013169.","journal-title":"IEEE Transactions on Reliability"},{"issue":"4","key":"9586_CR55","doi-asserted-by":"publisher","first-page":"573","DOI":"10.1142\/S021819400900426X","volume":"19","author":"WE Wong","year":"2009","unstructured":"Wong, W. E., & Qi, Y. (2009). Bp neural network-based effective fault localization. International Journal of Software Engineering and Knowledge Engineering, 19(4), 573\u2013597.","journal-title":"International Journal of Software Engineering and Knowledge Engineering"},{"key":"9586_CR56","doi-asserted-by":"crossref","unstructured":"Xiao, L., Cai, Y., & Kazman, R. (2014). Design rule spaces: A new form of architecture insight. In: Proceedings of the 36th International Conference on Software Engineering, pp. 967\u2013977.","DOI":"10.1145\/2568225.2568241"},{"key":"9586_CR57","unstructured":"Zaccone, G., Karim, M. R., & Menshawy, A (2017). Deep Learning with TensorFlow. Packt Publishing Ltd."},{"issue":"1","key":"9586_CR58","doi-asserted-by":"publisher","first-page":"35","DOI":"10.1016\/S0169-2070(97)00044-7","volume":"14","author":"G Zhang","year":"1998","unstructured":"Zhang, G., Patuwo, B. E., & Hu, M. Y. (1998). Forecasting with artificial neural networks: The state of the art. International journal of forecasting, 14(1), 35\u201362.","journal-title":"International journal of forecasting"}],"container-title":["Software Quality Journal"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s11219-022-09586-1.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s11219-022-09586-1\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s11219-022-09586-1.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,11,24]],"date-time":"2022-11-24T14:52:17Z","timestamp":1669301537000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s11219-022-09586-1"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,3,19]]},"references-count":58,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2022,12]]}},"alternative-id":["9586"],"URL":"https:\/\/doi.org\/10.1007\/s11219-022-09586-1","relation":{},"ISSN":["0963-9314","1573-1367"],"issn-type":[{"value":"0963-9314","type":"print"},{"value":"1573-1367","type":"electronic"}],"subject":[],"published":{"date-parts":[[2022,3,19]]},"assertion":[{"value":"31 January 2022","order":1,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"19 March 2022","order":2,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"16 April 2022","order":3,"name":"change_date","label":"Change Date","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"Update","order":4,"name":"change_type","label":"Change Type","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"The original version of this article was updated to correct the article title.","order":5,"name":"change_details","label":"Change Details","group":{"name":"ArticleHistory","label":"Article History"}},{"order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Declarations"}},{"value":"The authors declare that they have no known competing financial interests or personal relationships that could have appeared to influence the work reported in this paper.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Conflicts of interest"}}]}}