{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,27]],"date-time":"2025-03-27T04:05:27Z","timestamp":1743048327137,"version":"3.40.3"},"publisher-location":"Cham","reference-count":122,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783031360596"},{"type":"electronic","value":"9783031360602"}],"license":[{"start":{"date-parts":[[2023,1,1]],"date-time":"2023-01-01T00:00:00Z","timestamp":1672531200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2023,1,1]],"date-time":"2023-01-01T00:00:00Z","timestamp":1672531200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2023]]},"DOI":"10.1007\/978-3-031-36060-2_11","type":"book-chapter","created":{"date-parts":[[2023,10,5]],"date-time":"2023-10-05T17:04:18Z","timestamp":1696525458000},"page":"281-314","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Mining, Analyzing, and Evolving Data-Intensive Software Ecosystems"],"prefix":"10.1007","author":[{"given":"Csaba","family":"Nagy","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Michele","family":"Lanza","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Anthony","family":"Cleve","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2023,10,6]]},"reference":[{"doi-asserted-by":"crossref","unstructured":"Abdelhedi, F., Brahim, A., Rajhi, H., Ferhat, R., Zurfluh, G.: Automatic extraction of a document-oriented NoSQL schema. In: Int. Conf. Enterprise Information Systems (2021)","key":"11_CR1","DOI":"10.5220\/0010433501920199"},{"doi-asserted-by":"publisher","unstructured":"Afonso, A., da Silva, A., Conte, T., Martins, P., Cavalcanti, J., Garcia, A.: LESSQL: dealing with database schema changes in continuous deployment. In: IEEE 27th Int. Conf. Software Analysis, Evolution and Reengineering (SANER 2020), pp. 138\u2013148 (2020). https:\/\/doi.org\/10.1109\/SANER48275.2020.9054796","key":"11_CR2","DOI":"10.1109\/SANER48275.2020.9054796"},{"doi-asserted-by":"publisher","unstructured":"Albarak, M., Bahsoon, R.: Database design debts through examining schema evolution. In: International Workshop on Managing Technical Debt (MTD), pp. 17\u201323 (2016). https:\/\/doi.org\/10.1109\/MTD.2016.9","key":"11_CR3","DOI":"10.1109\/MTD.2016.9"},{"doi-asserted-by":"crossref","unstructured":"Albarak, M., Bahsoon, R.: Prioritizing technical debt in database normalization using portfolio theory and data quality metrics. In: International Conference on Technical Debt (TechDebt), pp. 31\u201340. ACM, New York (2018). https:\/\/doi.org\/10.1145\/3194164.3194170","key":"11_CR4","DOI":"10.1145\/3194164.3194170"},{"unstructured":"Alger, K.W., Daniel Coupal, D.: Building with patterns: the polymorphic pattern (2022). https:\/\/www.mongodb.com\/developer\/products\/mongodb\/polymorphic-pattern\/. Accessed 15 Apr 2023","key":"11_CR5"},{"key":"11_CR6","volume-title":"Modeling and analysis of SQL queries in PHP systems","author":"D Anderson","year":"2018","unstructured":"Anderson, D.: Modeling and analysis of SQL queries in PHP systems. Master\u2019s thesis, East Carolina University (2018)"},{"doi-asserted-by":"publisher","unstructured":"Anderson, D., Hills, M.: Query construction patterns in PHP. In: International Conference on Software Analysis, Evolution and Reengineering (SANER), pp. 452\u2013456 (2017). https:\/\/doi.org\/10.1109\/SANER.2017.7884652","key":"11_CR7","DOI":"10.1109\/SANER.2017.7884652"},{"doi-asserted-by":"publisher","unstructured":"Anderson, D., Hills, M.: Supporting analysis of SQL queries in PHP AiR. In: International Working Conference on Source Code Analysis and Manipulation (SCAM), pp. 153\u2013158 (2017). https:\/\/doi.org\/10.1109\/SCAM.2017.23","key":"11_CR8","DOI":"10.1109\/SCAM.2017.23"},{"doi-asserted-by":"crossref","unstructured":"Andreasen, E., M\u00f8ller, A.: Determinacy in static analysis for jQuery. In: Conference on Object-Oriented Programming Systems, Languages, and Applications (OOPSLA), pp. 17\u201331 (2014). https:\/\/doi.org\/10.1145\/2660193.2660214","key":"11_CR9","DOI":"10.1145\/2660193.2660214"},{"doi-asserted-by":"crossref","unstructured":"Annamaa, A., Breslav, A., Kabanov, J., Vene, V.: An interactive tool for analyzing embedded SQL queries. In: Asian Symposium on Programming Languages and Systems (APLAS). Lecture Notes in Computer Science, vol. 6461, pp. 131\u2013138. Springer, Berlin (2010)","key":"11_CR10","DOI":"10.1007\/978-3-642-17164-2_10"},{"doi-asserted-by":"publisher","unstructured":"Ardig\u00f2, S., Nagy, C., Minelli, R., Lanza, M.: Visualizing data in software cities. In: Working Conference on Software Visualization (VISSOFT), NIER\/TD, pp. 145\u2013149. IEEE, Piscataway (2021). https:\/\/doi.org\/10.1109\/VISSOFT52517.2021.00028","key":"11_CR11","DOI":"10.1109\/VISSOFT52517.2021.00028"},{"doi-asserted-by":"crossref","unstructured":"Ardig\u00f2, S., Nagy, C., Minelli, R., Lanza, M.: M3triCity: visualizing evolving software & data cities. In: International Conference on Software Engineering (ICSE), pp. 130\u2013133. IEEE, Piscataway (2022). https:\/\/doi.org\/10.1145\/3510454.3516831","key":"11_CR12","DOI":"10.1145\/3510454.3516831"},{"issue":"3","key":"11_CR13","doi-asserted-by":"publisher","first-page":"421","DOI":"10.1109\/TKDE.2017.2772252","volume":"30","author":"N Arzamasova","year":"2018","unstructured":"Arzamasova, N., Sch\u00e4ler, M., B\u00f6hm, K.: Cleaning antipatterns in an SQL query log. Trans. Knowl. Data Eng. 30(3), 421\u2013434 (2018)","journal-title":"Trans. Knowl. Data Eng."},{"issue":"4","key":"11_CR14","doi-asserted-by":"publisher","first-page":"497","DOI":"10.1007\/s00778-018-0532-7","volume":"28","author":"MA Baazizi","year":"2019","unstructured":"Baazizi, M.A., Colazzo, D., Ghelli, G., Sartiani, C.: Parametric schema inference for massive JSON datasets. VLDB J. 28(4), 497\u2013521 (2019). https:\/\/doi.org\/10.1007\/s00778-018-0532-7","journal-title":"VLDB J."},{"doi-asserted-by":"crossref","unstructured":"Balogh, G., Beszedes, A.: CodeMetropolis\u2014code visualisation in MineCraft. In: International Working Conference on Source Code Analysis and Manipulation (SCAM), pp. 136\u2013141. IEEE, Piscataway (2013)","key":"11_CR15","DOI":"10.1109\/SCAM.2013.6648194"},{"doi-asserted-by":"crossref","unstructured":"Benats, P., Gobert, M., Meurice, L., Nagy, C., Cleve, A.: An empirical study of (multi-) database models in open-source projects. In: International Conference on Conceptual Modeling (ER), pp. 87\u2013101. Springer, Berlin (2021)","key":"11_CR16","DOI":"10.1007\/978-3-030-89022-3_8"},{"doi-asserted-by":"crossref","unstructured":"Bertin, J.: Graphische Semiologie, 2nd edn. Walter de Gruyter (1974)","key":"11_CR17","DOI":"10.1515\/9783110834901"},{"unstructured":"Beyer, D., Lewerentz, C.: CrocoPat: a tool for efficient pattern recognition in large object-oriented programs. Tech. Rep. I-04\/2003, Institute of Computer Science, Brandenburgische Technische Universit\u00e4t Cottbus (2003)","key":"11_CR18"},{"doi-asserted-by":"crossref","unstructured":"Brahim, A.A., Ferhat, R.T., Zurfluh, G.: Model driven extraction of NoSQL databases schema: Case of MongodB. In: Int. Joint Conf. on Knowledge Discovery, Knowledge Engineering and Knowledge Management, pp. 145\u2013154 (2019). https:\/\/doi.org\/10.5220\/0008176201450154","key":"11_CR19","DOI":"10.5220\/0008176201450154"},{"unstructured":"Brass, S., Goldberg, C.: Detecting logical errors in SQL queries. In: Workshop on Foundations of Databases (2004)","key":"11_CR20"},{"issue":"5","key":"11_CR21","doi-asserted-by":"publisher","first-page":"630","DOI":"10.1016\/j.jss.2005.06.028","volume":"79","author":"S Brass","year":"2006","unstructured":"Brass, S., Goldberg, C.: Semantic errors in SQL queries: A quite complete list. J. Syst. Softw. 79(5), 630\u2013644 (2006). https:\/\/doi.org\/10.1016\/j.jss.2005.06.028","journal-title":"J. Syst. Softw."},{"unstructured":"Card, S.K., Mackinlay, J.D., Shneiderman, B. (eds.): Readings in Information Visualization\u2014Using Vision to Think. Morgan Kaufmann (1999)","key":"11_CR22"},{"doi-asserted-by":"crossref","unstructured":"Chen, T.H., Shang, W., Jiang, Z.M., Hassan, A.E., Nasser, M., Flora, P.: Detecting performance anti-patterns for applications developed using object-relational mapping. In: International Conference on Software Engineering (ICSE), pp. 1001\u20131012. ACM, New York (2014). https:\/\/doi.org\/10.1145\/2568225.2568259","key":"11_CR23","DOI":"10.1145\/2568225.2568259"},{"doi-asserted-by":"publisher","unstructured":"Cherry, B., Benats, P., Gobert, M., Meurice, L., Nagy, C., Cleve, A.: Static analysis of database accesses in mongodb applications. In: International Conference on Software Analysis, Evolution and Reengineering (SANER), pp. 930\u2013934. IEEE, Piscataway (2022). https:\/\/doi.org\/10.1109\/SANER2022.2022.00111","key":"11_CR24","DOI":"10.1109\/SANER2022.2022.00111"},{"doi-asserted-by":"crossref","unstructured":"Christensen, A.S., M\u00f8ller, A., Schwartzbach, M.I.: Precise analysis of string expressions. In: International Conference on Static Analysis (SAS), pp. 1\u201318. Springer, Berlin (2003)","key":"11_CR25","DOI":"10.1007\/3-540-44898-5_1"},{"doi-asserted-by":"publisher","unstructured":"Clark, S.R., Cobb, J., Kapfhammer, G.M., Jones, J.A., Harrold, M.J.: Localizing SQL faults in database applications. In: International Conference on Automated Software Engineering (ASE), pp. 213\u2013222. ACM, New York (2011). https:\/\/doi.org\/10.1109\/ASE.2011.6100056","key":"11_CR26","DOI":"10.1109\/ASE.2011.6100056"},{"doi-asserted-by":"crossref","unstructured":"Cleve, A., Gobert, M., Meurice, L., Maes, J., Weber, J.: Understanding database schema evolution: a case study. Sci. Comput. Program. 97, 113\u2013121 (2015). https:\/\/doi.org\/10.1016\/j.scico.2013.11.025. Special Issue on New Ideas and Emerging Results in Understanding Software","key":"11_CR27","DOI":"10.1016\/j.scico.2013.11.025"},{"doi-asserted-by":"publisher","unstructured":"Cleve, A., Hainaut, J.L.: Dynamic analysis of SQL statements for data-intensive applications reverse engineering. In: Working Conference on Reverse Engineering (WCRE), pp. 192\u2013196 (2008). https:\/\/doi.org\/10.1109\/WCRE.2008.38","key":"11_CR28","DOI":"10.1109\/WCRE.2008.38"},{"unstructured":"Curino, C.A., Tanca, L., Moon, H.J., Zaniolo, C.: Schema evolution in Wikipedia: toward a web information system benchmark. In: International Conference on Enterprise Information Systems (ICEIS) (2008)","key":"11_CR29"},{"doi-asserted-by":"crossref","unstructured":"de Almeida Filho, F.G., Martins, A.D.F., Vinuto, T.d.S., Monteiro, J.M., de Sousa, \u00cd.P., de Castro Machado, J., Rocha, L.S.: Prevalence of bad smells in PL\/SQL projects. In: International Conference on Program Comprehension (ICPC), pp. 116\u2013121. IEEE, Piscataway (2019)","key":"11_CR30","DOI":"10.1109\/ICPC.2019.00025"},{"doi-asserted-by":"publisher","unstructured":"de Jong, M., van Deursen, A., Cleve, A.: Zero-downtime sql database schema evolution for continuous deployment. In: International Conference on Software Engineering: Software Engineering in Practice Track (ICSE-SEIP), pp. 143\u2013152. IEEE, Piscataway (2017). https:\/\/doi.org\/10.1109\/ICSE-SEIP.2017.5","key":"11_CR31","DOI":"10.1109\/ICSE-SEIP.2017.5"},{"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: International Conference on Software Analysis, Evolution and Reengineering (SANER), pp. 432\u2013436 (2017). https:\/\/doi.org\/10.1109\/SANER.2017.7884648","key":"11_CR32","DOI":"10.1109\/SANER.2017.7884648"},{"doi-asserted-by":"crossref","unstructured":"Dimolikas, K., Zarras, A.V., Vassiliadis, P.: A study on the effect of a table\u2019s involvement in foreign keys to its schema evolution. In: International Conference on Conceptual Modeling (ER), pp. 456\u2013470. Springer, Berlin (2020)","key":"11_CR33","DOI":"10.1007\/978-3-030-62522-1_34"},{"unstructured":"Faroult, S., L\u2019Hermite, P.: Refactoring SQL Applications. O\u2019Reilly Media (2008)","key":"11_CR34"},{"unstructured":"Faroult, S., Robson, P.: The Art of SQL. O\u2019Reilly Media (2006)","key":"11_CR35"},{"doi-asserted-by":"crossref","unstructured":"Favre, J.M.: GSEE: a generic software exploration environment. In: International Workshop on Program Comprehension (ICPC), pp. 233\u2013244. IEEE, Piscataway (2001)","key":"11_CR36","DOI":"10.1109\/WPC.2001.921734"},{"doi-asserted-by":"crossref","unstructured":"Feldthaus, A., Sch\u00e4fer, M., Sridharan, M., Dolby, J., Tip, F.: Efficient construction of approximate call graphs for JavaScript IDE services. In: International Conference on Software Engineering (ICSE), pp. 752\u2013761. IEEE, Piscataway (2013)","key":"11_CR37","DOI":"10.1109\/ICSE.2013.6606621"},{"doi-asserted-by":"publisher","unstructured":"Foidl, H., Felderer, M., Biffl, S.: Technical debt in data-intensive software systems. In: 45th Euromicro Conference on Software Engineering and Advanced Applications (SEAA 2019), pp. 338\u2013341 (2019). https:\/\/doi.org\/10.1109\/SEAA.2019.00058","key":"11_CR38","DOI":"10.1109\/SEAA.2019.00058"},{"key":"11_CR39","doi-asserted-by":"publisher","first-page":"13","DOI":"10.1016\/j.is.2018.02.007","volume":"75","author":"E Gallinucci","year":"2018","unstructured":"Gallinucci, E., Golfarelli, M., Rizzi, S.: Schema profiling of document-oriented databases. Inf. Syst. 75, 13\u201325 (2018). https:\/\/doi.org\/10.1016\/j.is.2018.02.007","journal-title":"Inf. Syst."},{"doi-asserted-by":"crossref","unstructured":"Gobert, M., Nagy, C., Rocha, H., Demeyer, S., Cleve, A.: Challenges and perils of testing database manipulation code. In: International Conference on Advanced Information Systems Engineering (CAiSE), pp. 229\u2013245. Springer, Berlin (2021)","key":"11_CR40","DOI":"10.1007\/978-3-030-79382-1_14"},{"key":"11_CR41","doi-asserted-by":"publisher","first-page":"102105","DOI":"10.1016\/j.is.2022.102105","volume":"111","author":"M Gobert","year":"2023","unstructured":"Gobert, M., Nagy, C., Rocha, H., Demeyer, S., Cleve, A.: Best practices of testing database manipulation code. Inform. Syst. 111, 102105 (2023). https:\/\/doi.org\/10.1016\/j.is.2022.102105","journal-title":"Inform. Syst."},{"doi-asserted-by":"crossref","unstructured":"Goeminne, M., Decan, A., Mens, T.: Co-evolving code-related and database-related changes in a data-intensive software system. In: Software Evolution Week (CSMR\/WCRE) (2014)","key":"11_CR42","DOI":"10.1109\/CSMR-WCRE.2014.6747193"},{"doi-asserted-by":"publisher","unstructured":"Goeminne, M., Mens, T.: Towards a survival analysis of database framework usage in Java projects. In: International Conference on Software Maintenance and Evolution (ICSME), pp. 551\u2013555. IEEE, Piscataway (2015). https:\/\/doi.org\/10.1109\/ICSM.2015.7332512","key":"11_CR43","DOI":"10.1109\/ICSM.2015.7332512"},{"unstructured":"Goldberg, C.: Do you know SQL? About semantic errors in database queries. Tech. rep., Higher Education Academy (2008)","key":"11_CR44"},{"doi-asserted-by":"crossref","unstructured":"G\u00f3mez, P., Casallas, R., Roncancio, C.: Automatic schema generation for document-oriented systems. In: Database and Expert Systems Applications, pp. 152\u2013163. Springer, Berlin (2020)","key":"11_CR45","DOI":"10.1007\/978-3-030-59003-1_10"},{"doi-asserted-by":"publisher","unstructured":"Gould, C., Su, Z., Devanbu, P.: JDBC Checker: A static analysis tool for SQL\/JDBC applications. In: International Conference on Software Engineering (ICSE), pp. 697\u2013698 (2004). https:\/\/doi.org\/10.1109\/ICSE.2004.1317494","key":"11_CR46","DOI":"10.1109\/ICSE.2004.1317494"},{"doi-asserted-by":"publisher","unstructured":"Gould, C., Su, Z., Devanbu, P.: Static checking of dynamically generated queries in database applications. In: International Conference on Software Engineering (ICSE), pp. 645\u2013654 (2004). https:\/\/doi.org\/10.1109\/ICSE.2004.1317486","key":"11_CR47","DOI":"10.1109\/ICSE.2004.1317486"},{"doi-asserted-by":"crossref","unstructured":"Gu\u00e9h\u00e9neuc, Y.G.: Ptidej: A flexible reverse engineering tool suite. In: 2007 IEEE International Conference on Software Maintenance, pp. 529\u2013530. IEEE, Piscataway (2007)","key":"11_CR48","DOI":"10.1109\/ICSM.2007.4362684"},{"doi-asserted-by":"crossref","unstructured":"Imam, A.A., Basri, S., Ahmad, R., Watada, J., Gonz\u00e1lez-Aparicio, M.T.: Automatic schema suggestion model for NoSQL document-stores databases. J. Big Data 5 (2018)","key":"11_CR49","DOI":"10.1186\/s40537-018-0156-1"},{"doi-asserted-by":"publisher","unstructured":"Ireland, C., Bowers, D., Newton, M., Waugh, K.: A classification of object-relational impedance mismatch. In: International Conference on Advances in Databases, Knowledge, and Data Applications, pp. 36\u201343 (2009). https:\/\/doi.org\/10.1109\/DBKDA.2009.11","key":"11_CR50","DOI":"10.1109\/DBKDA.2009.11"},{"doi-asserted-by":"crossref","unstructured":"Jensen, S.H., M\u00f8ller, A., Thiemann, P.: Type analysis for JavaScript. In: Static Analysis, pp. 238\u2013255. Springer, Berlin (2009)","key":"11_CR51","DOI":"10.1007\/978-3-642-03237-0_17"},{"unstructured":"Karwin, B.: SQL Antipatterns: Avoiding the Pitfalls of Database Programming. Pragmatic Programmers (2010)","key":"11_CR52"},{"doi-asserted-by":"crossref","unstructured":"Kashyap, V., Dewey, K., Kuefner, E.A., Wagner, J., Gibbons, K., Sarracino, J., Wiedermann, B., Hardekopf, B.: JSAI: a static analysis platform for JavaScript. In: International Symposium on Foundations of Software Engineering (FSE), pp. 121\u2013132. ACM, New York (2014). https:\/\/doi.org\/10.1145\/2635868.2635904","key":"11_CR53","DOI":"10.1145\/2635868.2635904"},{"doi-asserted-by":"publisher","unstructured":"Khumnin, P., Senivongse, T.: SQL antipatterns detection and database refactoring process. In: ACIS International Conference on Software Engineering, Artificial Intelligence, Networking, and Parallel\/Distributed Computing (SNPD), pp. 199\u2013205 (2017). https:\/\/doi.org\/10.1109\/SNPD.2017.8022723","key":"11_CR54","DOI":"10.1109\/SNPD.2017.8022723"},{"doi-asserted-by":"crossref","unstructured":"Knight, C., Munro, M.C.: Virtual but visible software. In: International Conference on Information Visualization (IV), pp. 198\u2013205. IEEE, Piscataway (2000)","key":"11_CR55","DOI":"10.1109\/IV.2000.859756"},{"doi-asserted-by":"crossref","unstructured":"Langelier, G., Sahraoui, H., Poulin, P.: Visualization-based analysis of quality for large-scale software systems. In: International Conference on Automated Software Engineering (ASE), pp. 214\u2013223. ACM, New York (2005)","key":"11_CR56","DOI":"10.1145\/1101908.1101941"},{"key":"11_CR57","doi-asserted-by":"publisher","first-page":"108","DOI":"10.1007\/BFb0017737","volume-title":"Software Process Technology","author":"MM Lehman","year":"1996","unstructured":"Lehman, M.M.: Laws of software evolution revisited. In: C. Montangero (ed.) Software Process Technology, pp. 108\u2013124. Springer, Berlin (1996)"},{"doi-asserted-by":"publisher","unstructured":"Li, B., Poshyvanyk, D., Grechanik, M.: Automatically detecting integrity violations in database-centric applications. In: International Conference on Program Comprehension (ICPC), pp. 251\u2013262 (2017). https:\/\/doi.org\/10.1109\/ICPC.2017.37","key":"11_CR58","DOI":"10.1109\/ICPC.2017.37"},{"doi-asserted-by":"crossref","unstructured":"Li, D., Lyu, Y., Wan, M., Halfond, W.G.J.: String analysis for java and android applications. In: Joint European Software Engineering Conference and Symposium on the Foundations of Software Engineering (ESEC\/FSE), pp. 661\u2013672. ACM, New York (2015). https:\/\/doi.org\/10.1145\/2786805.2786879","key":"11_CR59","DOI":"10.1145\/2786805.2786879"},{"doi-asserted-by":"crossref","unstructured":"Lin, D.Y., Neamtiu, I.: Collateral evolution of applications and databases. In: Joint Int\u2019l Workshop on Principles of software evolution and ERCIM software evolution workshop, pp. 31\u201340. ACM, New York (2009). https:\/\/doi.org\/10.1145\/1595808.1595817","key":"11_CR60","DOI":"10.1145\/1595808.1595817"},{"doi-asserted-by":"publisher","unstructured":"Lyu, Y., Gui, J., Wan, M., Halfond, W.G.J.: An empirical study of local database usage in Android applications. In: International Conference on Software Maintenance and Evolution (ICSME), pp. 444\u2013455 (2017). https:\/\/doi.org\/10.1109\/ICSME.2017.75","key":"11_CR61","DOI":"10.1109\/ICSME.2017.75"},{"doi-asserted-by":"crossref","unstructured":"Madsen, M., M\u00f8ller, A.: Sparse dataflow analysis with pointers and reachability. In: Static Analysis, pp. 201\u2013218. Springer, Berlin (2014)","key":"11_CR62","DOI":"10.1007\/978-3-319-10936-7_13"},{"doi-asserted-by":"crossref","unstructured":"Manousis, P., Zarras, A., Vassiliadis, P., Papastefanatos, G.: Extraction of embedded queries via static analysis of host code. In: Advanced Information Systems Engineering (CAiSE), pp. 511\u2013526. Springer, Berlin (2017)","key":"11_CR63","DOI":"10.1007\/978-3-319-59536-8_32"},{"doi-asserted-by":"publisher","unstructured":"Marashdeh, Z., Suwais, K., Alia, M.: A survey on SQl injection attack: detection and challenges. In: International Conference on Information Technology (ICIT), pp. 957\u2013962 (2021). https:\/\/doi.org\/10.1109\/ICIT52682.2021.9491117","key":"11_CR64","DOI":"10.1109\/ICIT52682.2021.9491117"},{"doi-asserted-by":"crossref","unstructured":"Marcus, A., Feng, L., Maletic, J.I.: 3D representations for software visualization. In: ACM Symposium on Software Visualization, p. 27. IEEE, Piscataway (2003)","key":"11_CR65","DOI":"10.1145\/774833.774837"},{"doi-asserted-by":"crossref","unstructured":"Marinescu, C.: Applications of automated model\u2019s extraction in enterprise systems. In: International Conference on Software Technologies (ICSOFT), pp. 254\u2013261. SCITEPRESS (2019)","key":"11_CR66","DOI":"10.5220\/0007916102540261"},{"doi-asserted-by":"crossref","unstructured":"Maule, A., Emmerich, W., Rosenblum, D.: Impact analysis of database schema changes. In: International Conference on Software Engineering (ICSE), pp. 451\u2013460 (2008). https:\/\/doi.org\/10.1145\/1368088.1368150","key":"11_CR67","DOI":"10.1145\/1368088.1368150"},{"unstructured":"McKnight: NoSQL Evaluator\u2019s Guide (2014)","key":"11_CR68"},{"doi-asserted-by":"publisher","unstructured":"Meurice, L., Cleve, A.: DAHLIA: a visual analyzer of database schema evolution. In: Software Evolution Week\u2014IEEE Conference on Software Maintenance, Reengineering, and Reverse Engineering (CSMR-WCRE), pp. 464\u2013468. IEEE, Piscataway (2014). https:\/\/doi.org\/10.1109\/CSMR-WCRE.2014.6747219","key":"11_CR69","DOI":"10.1109\/CSMR-WCRE.2014.6747219"},{"doi-asserted-by":"publisher","unstructured":"Meurice, L., Cleve, A.: DAHLIA 2.0: A visual analyzer of database usage in dynamic and heterogeneous systems. In: Working Conference on Software Visualization (VISSOFT), pp. 76\u201380. IEEE, Piscataway (2016). https:\/\/doi.org\/10.1109\/VISSOFT.2016.15","key":"11_CR70","DOI":"10.1109\/VISSOFT.2016.15"},{"doi-asserted-by":"publisher","unstructured":"Meurice, L., Cleve, A.: Supporting schema evolution in schema-less NoSQL data stores. In: International Conference on Software Analysis, Evolution and Reengineering (SANER), pp. 457\u2013461 (2017). https:\/\/doi.org\/10.1109\/SANER.2017.7884653","key":"11_CR71","DOI":"10.1109\/SANER.2017.7884653"},{"doi-asserted-by":"crossref","unstructured":"Meurice, L., Goeminne, M., Mens, T., Nagy, C., Decan, A., Cleve, A.: Analyzing the evolution of database usage in data-intensive software systems. In: Software Technology: 10 Years of Innovation, pp. 208\u2013240. Wiley, London (2018). https:\/\/doi.org\/10.1002\/9781119174240.ch12","key":"11_CR72","DOI":"10.1002\/9781119174240.ch12"},{"doi-asserted-by":"publisher","unstructured":"Meurice, L., Nagy, C., Cleve, A.: Detecting and preventing program inconsistencies under database schema evolution. In: International Conference on Software Quality, Reliability & Security (QRS), pp. 262\u2013273. IEEE, Piscataway (2016). https:\/\/doi.org\/10.1109\/QRS.2016.38","key":"11_CR73","DOI":"10.1109\/QRS.2016.38"},{"doi-asserted-by":"crossref","unstructured":"Meurice, L., Nagy, C., Cleve, A.: Static analysis of dynamic database usage in Java systems. In: International Conference on Advanced Information Systems Engineering (CAiSE), pp. 491\u2013506. Springer, Berlin (2016). https:\/\/doi.org\/10.1007\/978-3-319-39696-5%5C_30","key":"11_CR74","DOI":"10.1007\/978-3-319-39696-5_30"},{"key":"11_CR75","doi-asserted-by":"publisher","first-page":"16","DOI":"10.1109\/MC.2020.3007297","volume":"53","author":"D Milojicic","year":"2020","unstructured":"Milojicic, D.: The edge-to-cloud continuum. IEEE Ann. History Comput. 53, 16\u201325 (2020)","journal-title":"IEEE Ann. History Comput."},{"doi-asserted-by":"crossref","unstructured":"Mior, M.J.: Automated schema design for NoSQL databases. In: 2014 SIGMOD PhD Symposium, pp. 41\u201345. ACM, New York (2014). https:\/\/doi.org\/10.1145\/2602622.2602624","key":"11_CR76","DOI":"10.1145\/2602622.2602624"},{"unstructured":"Mori, M., Noughi, N., Cleve, A.: Mining SQL execution traces for data manipulation behavior recovery. In: International Conference on Advanced Information Systems Engineering (CAiSE) (2014)","key":"11_CR77"},{"doi-asserted-by":"crossref","unstructured":"Muse, B.A., Nagy, C., Cleve, A., Khomh, F., Antoniol, G.: FIXME: synchronize with database an empirical study of data access self-admitted technical debt. Empirical Softw. Eng. 27(6) (2022). https:\/\/doi.org\/10.1007\/s10664-022-10119-4","key":"11_CR78","DOI":"10.1007\/s10664-022-10119-4"},{"doi-asserted-by":"crossref","unstructured":"Muse, B.A., Rahman, M., Nagy, C., Cleve, A., Khomh, F., Antoniol, G.: On the prevalence, impact, and evolution of SQL code smells in data-intensive systems. In: International Conference on Mining Software Repositories (MSR), pp. 327\u2013338. ACM, New York (2020). https:\/\/doi.org\/10.1145\/3379597.3387467","key":"11_CR79","DOI":"10.1145\/3379597.3387467"},{"doi-asserted-by":"publisher","unstructured":"Nagy, C., Cleve, A.: Static code smell detection in SQL queries embedded in Java code. In: International Working Conference on Source Code Analysis and Manipulation (SCAM), pp. 147\u2013152. IEEE, Piscataway (2017). https:\/\/doi.org\/10.1109\/SCAM.2017.19","key":"11_CR80","DOI":"10.1109\/SCAM.2017.19"},{"doi-asserted-by":"crossref","unstructured":"Nagy, C., Cleve, A.: SQLInspect: A static analyzer to inspect database usage in Java applications. In: International Conference on Software Engineering (ICSE), pp. 93\u201396 (2018). https:\/\/doi.org\/10.1145\/3183440.3183496","key":"11_CR81","DOI":"10.1145\/3183440.3183496"},{"issue":"3","key":"11_CR82","doi-asserted-by":"publisher","first-page":"160","DOI":"10.1016\/j.infsof.2006.11.005","volume":"50","author":"MN Ngo","year":"2008","unstructured":"Ngo, M.N., Tan, H.B.K.: Applying static analysis for automated extraction of database interactions in web applications. Inform. Softw. Technol. 50(3), 160\u2013175 (2008). https:\/\/doi.org\/10.1016\/j.infsof.2006.11.005","journal-title":"Inform. Softw. Technol."},{"doi-asserted-by":"crossref","unstructured":"Noughi, N., Mori, M., Meurice, L., Cleve, A.: Understanding the database manipulation behavior of programs. In: International Conference on Program Comprehension (ICPC), pp. 64\u201367. ACM, New York (2014). https:\/\/doi.org\/10.1145\/2597008.2597790","key":"11_CR83","DOI":"10.1145\/2597008.2597790"},{"doi-asserted-by":"crossref","unstructured":"Panas, T., Berrigan, R., Grundy, J.: A 3D metaphor for software production visualization. In: IV 2003, p. 314. IEEE Computer Society (2003)","key":"11_CR84","DOI":"10.1109\/IV.2003.1217996"},{"doi-asserted-by":"crossref","unstructured":"Panas, T., Epperly, T., Quinlan, D., Saebjornsen, A., Vuduc, R.: Communicating software architecture using a unified single-view visualization. In: International Conference on Engineering Complex Computer Systems (ECCS), pp. 217\u2013228. IEEE, Piscataway (2007)","key":"11_CR85","DOI":"10.1109\/ICECCS.2007.20"},{"doi-asserted-by":"publisher","unstructured":"Pfahler, F., Minelli, R., Nagy, C., Lanza, M.: Visualizing evolving software cities. In: Working Conference on Software Visualization (VISSOFT), pp. 22\u201326 (2020). https:\/\/doi.org\/10.1109\/VISSOFT51673.2020.00007","key":"11_CR86","DOI":"10.1109\/VISSOFT51673.2020.00007"},{"doi-asserted-by":"crossref","unstructured":"Qiu, D., Li, B., Su, Z.: An empirical analysis of the co-evolution of schema and code in database applications. In: Joint Meeting on Foundations of Software Engineering (ESEC\/FSE), pp. 125\u2013135. ACM, New York (2013). https:\/\/doi.org\/10.1145\/2491411.2491431","key":"11_CR87","DOI":"10.1145\/2491411.2491431"},{"issue":"5","key":"11_CR88","doi-asserted-by":"publisher","first-page":"1487","DOI":"10.1287\/mnsc.2015.2196","volume":"62","author":"N Ramasubbu","year":"2016","unstructured":"Ramasubbu, N., Kemerer, C.F.: Technical debt and the reliability of enterprise software systems: a competing risks analysis. Manag. Sci. 62(5), 1487\u20131510 (2016). https:\/\/doi.org\/10.1287\/mnsc.2015.2196","journal-title":"Manag. Sci."},{"issue":"3","key":"11_CR89","doi-asserted-by":"publisher","first-page":"299","DOI":"10.1006\/jvlc.1995.1017","volume":"6","author":"SP Reiss","year":"1995","unstructured":"Reiss, S.P.: An engine for the 3D visualization of program information. J. Vis. Lang. Comput. 6(3), 299\u2013323 (1995)","journal-title":"J. Vis. Lang. Comput."},{"doi-asserted-by":"crossref","unstructured":"Ringlstetter, A., Scherzinger, S., Bissyand\u00e9, T.F.: Data model evolution using object-NoSQL mappers: folklore or state-of-the-art? In: International Workshop on BIG Data Software Engineering, pp. 33\u201336 (2016)","key":"11_CR90","DOI":"10.1145\/2896825.2896827"},{"doi-asserted-by":"crossref","unstructured":"Scherzinger, S., De Almeida, E.C., Ickert, F., Del Fabro, M.D.: On the necessity of model checking NoSQL database schemas when building SaaS applications. In: International Workshop on Testing the Cloud (TTC). ACM, New York (2013)","key":"11_CR91","DOI":"10.1145\/2489295.2489297"},{"doi-asserted-by":"crossref","unstructured":"Scherzinger, S., Sidortschuck, S.: An empirical study on the design and evolution of NoSQL database schemas. In: International Conference on Conceptual Modeling (ER), pp. 441\u2013455. Springer, Berlin (2020)","key":"11_CR92","DOI":"10.1007\/978-3-030-62522-1_33"},{"doi-asserted-by":"publisher","unstructured":"Shao, S., Qiu, Z., Yu, X., Yang, W., Jin, G., Xie, T., Wu, X.: Database-access performance antipatterns in database-backed web applications. In: International Conference on Software Maintenance and Evolution (ICSME), pp. 58\u201369. IEEE, Piscataway (2020). https:\/\/doi.org\/10.1109\/ICSME46990.2020.00016","key":"11_CR93","DOI":"10.1109\/ICSME46990.2020.00016"},{"doi-asserted-by":"crossref","unstructured":"Sharma, T., Fragkoulis, M., Rizou, S., Bruntink, M., Spinellis, D.: Smelly relations: measuring and understanding database schema quality. In: International Conference on Software Engineering: Software Engineering in Practice (ICSE-SEIP), pp. 55\u201364. ACM, New York (2018). https:\/\/doi.org\/10.1145\/3183519.3183529","key":"11_CR94","DOI":"10.1145\/3183519.3183529"},{"issue":"1","key":"11_CR95","doi-asserted-by":"publisher","first-page":"35","DOI":"10.1016\/0950-5849(93)90027-Z","volume":"35","author":"D Sj\u00f8berg","year":"1993","unstructured":"Sj\u00f8berg, D.: Quantifying schema evolution. Inform. Softw. Technol. 35(1), 35\u201344 (1993). https:\/\/doi.org\/10.1016\/0950-5849(93)90027-Z","journal-title":"Inform. Softw. Technol."},{"doi-asserted-by":"crossref","unstructured":"Skoulis, I., Vassiliadis, P., Zarras, A.: Open-source databases: within, outside, or beyond Lehman\u2019s laws of software evolution? In: International Conference on Advanced Information Systems Engineering (CAiSE). LNCS, vol. 8484, pp. 379\u2013393. Springer, Berlin (2014). https:\/\/doi.org\/10.1007\/978-3-319-07881-6%5C_26","key":"11_CR96","DOI":"10.1007\/978-3-319-07881-6_26"},{"doi-asserted-by":"crossref","unstructured":"Sonoda, M., Matsuda, T., Koizumi, D., Hirasawa, S.: On automatic detection of SQL injection attacks by the feature extraction of the single character. In: International Conference on Security of Information and Networks (SIN), pp. 81\u201386. ACM, New York (2011). https:\/\/doi.org\/10.1145\/2070425.2070440","key":"11_CR97","DOI":"10.1145\/2070425.2070440"},{"doi-asserted-by":"crossref","unstructured":"Spadini, D., Aniche, M., Bacchelli, A.: PyDriller: Python framework for mining software repositories. In: Joint European Software Engineering Conference and Symposium on the Foundations of Software Engineering (ESEC\/FSE), pp. 908\u2013911. ACM (2018). https:\/\/doi.org\/10.1145\/3236024.3264598","key":"11_CR98","DOI":"10.1145\/3236024.3264598"},{"key":"11_CR99","volume-title":"Software Visualization\u2014Programming as a Multimedia Experience","author":"JT Stasko","year":"1998","unstructured":"Stasko, J.T., Brown, M.H., Domingue, J.B., Price, B.A.: Software Visualization\u2014Programming as a Multimedia Experience. MIT Press, Cambridge (1998)"},{"doi-asserted-by":"crossref","unstructured":"Steinbr\u00fcckner, F., Lewerentz, C.: Representing development history in software cities. In: International Symposium on Software Visualization, pp. 193\u2013202. ACM, New York (2010). https:\/\/doi.org\/10.1145\/1879211.1879239","key":"11_CR100","DOI":"10.1145\/1879211.1879239"},{"doi-asserted-by":"publisher","unstructured":"Stonebraker, M., Deng, D., Brodie, M.L.: Database decay and how to avoid it. In: Proc. Big Data, pp. 7\u201316 (2016). https:\/\/doi.org\/10.1109\/BigData.2016.7840584","key":"11_CR101","DOI":"10.1109\/BigData.2016.7840584"},{"unstructured":"Stonebraker, M., Deng, D., Brodie, M.L.: Application-database co-evolution: a new design and development paradigm. In: New England Database Day (2017)","key":"11_CR102"},{"unstructured":"Storey, M.A., Best, C., Michaud, J.: SHriMP views: an interactive and customizable environment for software exploration. In: International Workshop on Program Comprehension (IWPC) (2001)","key":"11_CR103"},{"doi-asserted-by":"crossref","unstructured":"Storey, M.A., Wong, K., M\u00fcller, H.: How do program understanding tools affect how programmers understand programs? In: Working Conference on Reverse Engineering (WCRE), pp. 12\u201321. IEEE, Piscataway (1997)","key":"11_CR104","DOI":"10.1109\/WCRE.1997.624572"},{"unstructured":"St\u00f6rl, U., Klettke, M., Scherzinger, S.: NoSQL schema evolution and data migration: State-of-the-art and opportunities. In: International Conference on Extending Database Technology (EDBT), pp. 655\u2013658 (2020). https:\/\/doi.org\/10.5441\/002\/edbt.2020.87","key":"11_CR105"},{"doi-asserted-by":"crossref","unstructured":"Sun, K., Ryu, S.: Analysis of JavaScript programs: challenges and research trends. ACM Comput. Surv. 50(4) (2017)","key":"11_CR106","DOI":"10.1145\/3106741"},{"unstructured":"Tufte, E.: Envisioning Information. Graphics Press (1990)","key":"11_CR107"},{"unstructured":"Tufte, E.: Visual Explanations. Graphics Press (1997)","key":"11_CR108"},{"unstructured":"Tufte, E.: The Visual Display of Quantitative Information, 2nd edn. Graphics Press (2001)","key":"11_CR109"},{"doi-asserted-by":"publisher","unstructured":"van den Brink, H., van der Leek, R., Visser, J.: Quality assessment for embedded SQL. In: International Working Conference on Source Code Analysis and Manipulation (SCAM), pp. 163\u2013170 (2007). https:\/\/doi.org\/10.1109\/SCAM.2007.23","key":"11_CR110","DOI":"10.1109\/SCAM.2007.23"},{"unstructured":"Van Den Brink, H.J., van der Leek, R.: Quality metrics for SQL queries embedded in host languages. In: European Conference on Software Maintenance and Reengineering (CSMR) (2007)","key":"11_CR111"},{"doi-asserted-by":"crossref","unstructured":"Vassiliadis, P., Zarras, A.V., Skoulis, I.: How is life for a table in an evolving relational schema? Birth, death and everything in between. In: International Conference on Conceptual Modeling (ER), pp. 453\u2013466. Springer, Berlin (2015)","key":"11_CR112","DOI":"10.1007\/978-3-319-25264-3_34"},{"key":"11_CR113","doi-asserted-by":"publisher","first-page":"24","DOI":"10.1016\/j.is.2016.06.010","volume":"63","author":"P Vassiliadis","year":"2017","unstructured":"Vassiliadis, P., Zarras, A.V., Skoulis, I.: Gravitating to rigidity: Patterns of schema evolution, and its absence in the lives of tables. Inform. Syst. 63, 24\u201346 (2017). https:\/\/doi.org\/10.1016\/j.is.2016.06.010","journal-title":"Inform. Syst."},{"doi-asserted-by":"publisher","unstructured":"Vincur, J., Navrat, P., Polasek, I.: VR City: Software analysis in virtual reality environment. In: Int. Conf. Software Quality, Reliability and Security, pp. 509\u2013516. IEEE, Piscataway (2017). https:\/\/doi.org\/10.1109\/QRS-C.2017.88","key":"11_CR114","DOI":"10.1109\/QRS-C.2017.88"},{"unstructured":"Ware, C.: Information Visualization: Perception for Design, 2nd edn. Morgan Kaufmann (2004)","key":"11_CR115"},{"issue":"4","key":"11_CR116","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.: Static checking of dynamically generated queries in database applications. Trans. Softw. Eng. Methodol. 16(4), 14 (2007). https:\/\/doi.org\/10.1145\/1276933.1276935","journal-title":"Trans. Softw. Eng. Methodol."},{"doi-asserted-by":"publisher","unstructured":"Weber, J.H., Cleve, A., Meurice, L., Bermudez Ruiz, F.J.: Managing technical debt in database schemas of critical software. In: International Workshop on Managing Technical Debt, pp. 43\u201346 (2014). https:\/\/doi.org\/10.1109\/MTD.2014.17","key":"11_CR117","DOI":"10.1109\/MTD.2014.17"},{"doi-asserted-by":"crossref","unstructured":"Wettel, R., Lanza, M.: Visualizing software systems as cities. In: International Workshop on Visualizing Software for Understanding and Analysis (VISSOFT), pp. 92\u201399. IEEE, Piscataway (2007)","key":"11_CR118","DOI":"10.1109\/VISSOF.2007.4290706"},{"doi-asserted-by":"crossref","unstructured":"Wettel, R., Lanza, M.: CodeCity: 3D visualization of large-scale software. In: International Conference on Software Engineering (ICSE), pp. 921\u2013922. ACM, New York (2008)","key":"11_CR119","DOI":"10.1145\/1370175.1370188"},{"doi-asserted-by":"crossref","unstructured":"Yeole, A.S., Meshram, B.B.: Analysis of different technique for detection of SQL injection. In: International Conference & Workshop on Emerging Trends in Technology (ICWET), pp. 963\u2013966. ACM, New York (2011). https:\/\/doi.org\/10.1145\/1980022.1980229","key":"11_CR120","DOI":"10.1145\/1980022.1980229"},{"doi-asserted-by":"crossref","unstructured":"Young, P., Munro, M.: Visualising software in virtual reality. In: International Workshop on Program Comprehension (IWPC), pp. 19\u201326. IEEE, Piscataway (1998)","key":"11_CR121","DOI":"10.1109\/WPC.1998.693276"},{"key":"11_CR122","volume-title":"Live visualization of database behavior for large software landscapes: the RACCOON approach","author":"C Zirkelbach","year":"2019","unstructured":"Zirkelbach, C., Hasselbring, W.: Live visualization of database behavior for large software landscapes: the RACCOON approach. Tech. rep., Department of Computer Science, Kiel University (2019)"}],"container-title":["Software Ecosystems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-031-36060-2_11","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,10,30]],"date-time":"2024-10-30T03:42:16Z","timestamp":1730259736000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-031-36060-2_11"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023]]},"ISBN":["9783031360596","9783031360602"],"references-count":122,"URL":"https:\/\/doi.org\/10.1007\/978-3-031-36060-2_11","relation":{},"subject":[],"published":{"date-parts":[[2023]]},"assertion":[{"value":"6 October 2023","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}}]}}