{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,26]],"date-time":"2025-03-26T09:35:26Z","timestamp":1742981726515,"version":"3.40.3"},"publisher-location":"Berlin, Heidelberg","reference-count":47,"publisher":"Springer Berlin Heidelberg","isbn-type":[{"type":"print","value":"9783642226298"},{"type":"electronic","value":"9783642226304"}],"license":[{"start":{"date-parts":[[2011,1,1]],"date-time":"2011-01-01T00:00:00Z","timestamp":1293840000000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2011]]},"DOI":"10.1007\/978-3-642-22630-4_5","type":"book-chapter","created":{"date-parts":[[2011,8,8]],"date-time":"2011-08-08T08:35:55Z","timestamp":1312792555000},"page":"130-157","source":"Crossref","is-referenced-by-count":9,"title":["Database Semantics Recovery through Analysis of Dynamic SQL Statements"],"prefix":"10.1007","author":[{"given":"Anthony","family":"Cleve","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jean-Roch","family":"Meurisse","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jean-Luc","family":"Hainaut","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","reference":[{"issue":"1","key":"5_CR1","doi-asserted-by":"publisher","first-page":"82","DOI":"10.1147\/rd.281.0082","volume":"28","author":"M.A. Casanova","year":"1984","unstructured":"Casanova, M.A., De Sa, J.E.A.: Mapping uninterpreted schemes into entity-relationship diagrams: two applications to conceptual schema design. IBM J. Res. Dev.\u00a028(1), 82\u201394 (1984)","journal-title":"IBM J. Res. Dev."},{"key":"5_CR2","first-page":"148","volume-title":"Proceedings of the Fourth International Conference on Entity-Relationship Approach","author":"K.H. Davis","year":"1985","unstructured":"Davis, K.H., Arora, A.K.: A methodology for translating a conventional file system into an entity-relationship model. In: Proceedings of the Fourth International Conference on Entity-Relationship Approach, pp. 148\u2013159. IEEE Computer Society, Washington, DC, USA (1985)"},{"key":"5_CR3","first-page":"305","volume-title":"Proceedings of the Sixth International Conference on Entity-Relationship Approach (ER 1987)","author":"S.B. Navathe","year":"1988","unstructured":"Navathe, S.B., Awong, A.M.: Abstracting relational and hierarchical data with a semantic data model. In: Proceedings of the Sixth International Conference on Entity-Relationship Approach (ER 1987), pp. 305\u2013333. North-Holland Publishing Co., Amsterdam (1988)"},{"key":"5_CR4","first-page":"190","volume-title":"Proceedings of the Tenth International Conference on Data Engineering (ICDE 2004)","author":"P. Johannesson","year":"1994","unstructured":"Johannesson, P.: A method for transforming relational schemas into conceptual schemas. In: Proceedings of the Tenth International Conference on Data Engineering (ICDE 2004), pp. 190\u2013201. IEEE Computer Society, Washington, DC, USA (1994)"},{"key":"5_CR5","doi-asserted-by":"publisher","first-page":"116","DOI":"10.1109\/WCRE.1995.514700","volume-title":"Proceedings of the Second Working Conference on Reverse Engineering (WCRE 1995)","author":"M.R. Blaha","year":"1995","unstructured":"Blaha, M.R., Premerlani, W.J.: Observed idiosyncracies of relational database designs. In: Proceedings of the Second Working Conference on Reverse Engineering (WCRE 1995), p. 116. IEEE Computer Society, Washington, DC, USA (1995)"},{"key":"5_CR6","doi-asserted-by":"publisher","first-page":"9","DOI":"10.1007\/BF00126958","volume":"3","author":"J.L. Hainaut","year":"1996","unstructured":"Hainaut, J.L., Englebert, V., Henrard, J., Hick, J.M., Roland, D.: Database reverse engineering: From requirements to care tools. Automated Software Engineering\u00a03, 9\u201345 (1996)","journal-title":"Automated Software Engineering"},{"key":"5_CR7","doi-asserted-by":"publisher","first-page":"70","DOI":"10.1109\/WCRE.2000.891454","volume-title":"Proceedings of the Seventh Working Conference on Reverse Engineering (WCRE 2000)","author":"K.H. Davis","year":"2000","unstructured":"Davis, K.H., Aiken, P.H.: Data reverse engineering: A historical survey. In: Proceedings of the Seventh Working Conference on Reverse Engineering (WCRE 2000), p. 70. IEEE Computer Society, Washington, DC, USA (2000)"},{"key":"5_CR8","doi-asserted-by":"publisher","first-page":"4","DOI":"10.1109\/WCRE.2009.58","volume-title":"Proceedings of the 16th Working Conference on Reverse Engineering (WCRE 2009)","author":"J.L. Hainaut","year":"2009","unstructured":"Hainaut, J.L.: Legacy and future of data reverse engineering. In: Proceedings of the 16th Working Conference on Reverse Engineering (WCRE 2009), p. 4. IEEE Computer Society, Los Alamitos (2009)"},{"key":"5_CR9","doi-asserted-by":"crossref","first-page":"723","DOI":"10.1007\/978-0-387-39940-9_646","volume-title":"Encyclopedia of Database Systems","author":"J.L. Hainaut","year":"2009","unstructured":"Hainaut, J.L., Henrard, J., Englebert, V., Roland, D., Hick, J.M.: Database reverse engineering. In: Liu, L., \u00d6zsu, M.T. (eds.) Encyclopedia of Database Systems, pp. 723\u2013728. Springer, US (2009)"},{"key":"5_CR10","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"95","DOI":"10.1007\/11877028_4","volume-title":"Generative and Transformational Techniques in Software Engineering","author":"J.-L. Hainaut","year":"2006","unstructured":"Hainaut, J.-L.: The transformational approach to database engineering. In: L\u00e4mmel, R., Saraiva, J., Visser, J. (eds.) GTTSE 2005. LNCS, vol.\u00a04143, pp. 95\u2013143. Springer, Heidelberg (2006)"},{"key":"5_CR11","unstructured":"Hainaut, J.L.: Introduction to database reverse engineering. LIBD Publish (2002), http:\/\/www.info.fundp.ac.be\/~dbm\/publication\/2002\/DBRE-2002.pdf"},{"key":"5_CR12","doi-asserted-by":"publisher","first-page":"777","DOI":"10.1109\/32.57618","volume":"16","author":"V.M. Markowitz","year":"1990","unstructured":"Markowitz, V.M., Makowsky, J.A.: Identifying extended entity-relationship object structures in relational schemas. IEEE Trans. Softw. Eng.\u00a016, 777\u2013790 (1990)","journal-title":"IEEE Trans. Softw. Eng."},{"issue":"5","key":"5_CR13","doi-asserted-by":"publisher","first-page":"42","DOI":"10.1145\/175290.175293","volume":"37","author":"W.J. Premerlani","year":"1994","unstructured":"Premerlani, W.J., Blaha, M.R.: An approach for reverse engineering of relational databases. Commun. ACM\u00a037(5), 42 (1994)","journal-title":"Commun. ACM"},{"issue":"2","key":"5_CR14","doi-asserted-by":"publisher","first-page":"107","DOI":"10.1016\/0169-023X(94)90011-6","volume":"12","author":"R.H.L. Chiang","year":"1994","unstructured":"Chiang, R.H.L., Barron, T.M., Storey, V.C.: Reverse engineering of relational databases: extraction of an eer model from a relational database. Data Knowl. Eng.\u00a012(2), 107\u2013142 (1994)","journal-title":"Data Knowl. Eng."},{"key":"5_CR15","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1016\/S0306-4379(01)00027-8","volume":"27","author":"S. Lopes","year":"2002","unstructured":"Lopes, S., Petit, J.M., Toumani, F.: Discovering interesting inclusion dependencies: application to logical database tuning. Inf. Syst.\u00a027, 1\u201319 (2002)","journal-title":"Inf. Syst."},{"issue":"2","key":"5_CR16","doi-asserted-by":"publisher","first-page":"197","DOI":"10.1007\/s10618-007-0083-9","volume":"16","author":"H. Yao","year":"2008","unstructured":"Yao, H., Hamilton, H.J.: Mining functional dependencies from data. Data Min. Knowl. Discov.\u00a016(2), 197\u2013219 (2008)","journal-title":"Data Min. Knowl. Discov."},{"key":"5_CR17","unstructured":"Pannurat, N., Kerdprasop, N., Kerdprasop, K.: Database reverse engineering based on association rule mining. CoRR abs\/1004.3272 (2010)"},{"key":"5_CR18","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"369","DOI":"10.1007\/3-540-58786-1_91","volume-title":"Entity-Relationship Approach - ER \u201994. Business Modelling and Re-Engineering","author":"J.M. Petit","year":"1994","unstructured":"Petit, J.M., Kouloumdjian, J., Boulicaut, J.F., Toumani, F.: Using queries to improve database reverse engineering. In: Loucopoulos, P. (ed.) ER 1994. LNCS, vol.\u00a0881, pp. 369\u2013386. Springer, Heidelberg (1994)"},{"key":"5_CR19","first-page":"52","volume-title":"Proceedings of the 16th IEEE International Conference on Software Maintenance (ICSM 2000)","author":"G.A. Lucca Di","year":"2000","unstructured":"Di Lucca, G.A., Fasolino, A.R., de Carlini, U.: Recovering class diagrams from data-intensive legacy systems. In: Proceedings of the 16th IEEE International Conference on Software Maintenance (ICSM 2000), p. 52. IEEE Computer Society, Los Alamitos (2000)"},{"key":"5_CR20","unstructured":"Henrard, J.: Program Understanding in Database Reverse Engineering. PhD thesis, University of Namur (2003)"},{"key":"5_CR21","doi-asserted-by":"publisher","first-page":"157","DOI":"10.1109\/WCRE.2006.22","volume-title":"Proceedings of the 13th Working Conference on Reverse Engineering (WCRE 2006)","author":"A. Cleve","year":"2006","unstructured":"Cleve, A., Henrard, J., Hainaut, J.L.: Data reverse engineering using system dependency graphs. In: Proceedings of the 13th Working Conference on Reverse Engineering (WCRE 2006), pp. 157\u2013166. IEEE Computer Society, Washington, DC, USA (2006)"},{"issue":"2","key":"5_CR22","doi-asserted-by":"publisher","first-page":"108","DOI":"10.1145\/129630.129636","volume":"35","author":"J. Choobineh","year":"1992","unstructured":"Choobineh, J., Mannino, M.V., Tseng, V.P.: A form-based approach for database analysis and design. Communications of the ACM\u00a035(2), 108\u2013120 (1992)","journal-title":"Communications of the ACM"},{"key":"5_CR23","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"424","DOI":"10.1007\/11901181_32","volume-title":"Conceptual Modeling - ER 2006","author":"J.F. Terwilliger","year":"2006","unstructured":"Terwilliger, J.F., Delcambre, L.M.L., Logan, J.: The user interface is the conceptual model. In: Embley, D.W., Oliv\u00e9, A., Ram, S. (eds.) ER 2006. LNCS, vol.\u00a04215, pp. 424\u2013436. Springer, Heidelberg (2006)"},{"key":"5_CR24","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"332","DOI":"10.1007\/978-3-642-13094-6_27","volume-title":"Advanced Information Systems Engineering","author":"R. Ramdoyal","year":"2010","unstructured":"Ramdoyal, R., Cleve, A., Hainaut, J.-L.: Reverse engineering user interfaces for interactive database conceptual analysis. In: Pernici, B. (ed.) CAiSE 2010. LNCS, vol.\u00a06051, pp. 332\u2013347. Springer, Heidelberg (2010)"},{"key":"5_CR25","series-title":"IFIP Conference Proceedings","doi-asserted-by":"publisher","first-page":"162","DOI":"10.1007\/978-0-387-35300-5_8","volume-title":"Data Mining and Reverse Engineering: Searching for Semantics, IFIP TC2\/WG2.6 Seventh Conference on Database Semantics (DS-7)","author":"M. Andersson","year":"1998","unstructured":"Andersson, M.: Searching for semantics in cobol legacy applications. In: Data Mining and Reverse Engineering: Searching for Semantics, IFIP TC2\/WG2.6 Seventh Conference on Database Semantics (DS-7). IFIP Conference Proceedings, vol.\u00a0124, pp. 162\u2013183. Chapman & Hall, Boca Raton (1998)"},{"key":"5_CR26","doi-asserted-by":"crossref","first-page":"345","DOI":"10.1109\/WCRE.2001.957841","volume-title":"Proceedings of the 8th Working Conference on Reverse Engineering (WCRE 2001)","author":"S.M. Embury","year":"2001","unstructured":"Embury, S.M., Shao, J.: Assisting the comprehension of legacy transactions. In: Proceedings of the 8th Working Conference on Reverse Engineering (WCRE 2001), p. 345. IEEE Computer Society, Washington, DC, USA (2001)"},{"key":"5_CR27","doi-asserted-by":"publisher","first-page":"448","DOI":"10.1109\/ICSM.2004.1357833","volume-title":"ICSM 2004: Proceedings of the 20th IEEE International Conference on Software Maintenance","author":"D. Willmor","year":"2004","unstructured":"Willmor, D., Embury, S.M., Shao, J.: Program slicing in the presence of a database state. In: ICSM 2004: Proceedings of the 20th IEEE International Conference on Software Maintenance, pp. 448\u2013452. IEEE Computer Society, Washington, DC, USA (2004)"},{"key":"5_CR28","first-page":"451","volume-title":"Proceedings of the 30th international conference on Software engineering (ICSE 2008)","author":"A. Maule","year":"2008","unstructured":"Maule, A., Emmerich, W., Rosenblum, D.S.: Impact analysis of database schema changes. In: Proceedings of the 30th international conference on Software engineering (ICSE 2008), pp. 451\u2013460. ACM Press, New York (2008)"},{"key":"5_CR29","doi-asserted-by":"publisher","first-page":"163","DOI":"10.1109\/SCAM.2007.23","volume-title":"Proceedings of the 7th IEEE International Working Conference on Source Code Analysis and Manipulation (SCAM 2007)","author":"H. Brink van den","year":"2007","unstructured":"van den Brink, H., van der Leek, R., Visser, J.: Quality assessment for embedded sql. In: Proceedings of the 7th IEEE International Working Conference on Source Code Analysis and Manipulation (SCAM 2007), pp. 163\u2013170. IEEE Computer Society, Los Alamitos (2007)"},{"issue":"3","key":"5_CR30","doi-asserted-by":"publisher","first-page":"160","DOI":"10.1016\/j.infsof.2006.11.005","volume":"50","author":"M.N. Ngo","year":"2008","unstructured":"Ngo, M.N., Tan, H.B.K.: Applying static analysis for automated extraction of database interactions in web applications. Inf. Softw. Technol.\u00a050(3), 160\u2013175 (2008)","journal-title":"Inf. Softw. Technol."},{"key":"5_CR31","doi-asserted-by":"crossref","unstructured":"Cleve, A.: Program Analysis and Transformation for Data-Intensive System Evolution. PhD thesis, University of Namur (October 2009)","DOI":"10.1109\/ICSM.2010.5609724"},{"key":"5_CR32","doi-asserted-by":"publisher","first-page":"313","DOI":"10.1145\/503209.503260","volume-title":"ESEC\/FSE-9: Proceedings of the 8th European software engineering conference held jointly with 9th ACM SIGSOFT international symposium on Foundations of software engineering","author":"G. Kiczales","year":"2001","unstructured":"Kiczales, G., Hilsdale, E.: Aspect-oriented programming. In: ESEC\/FSE-9: Proceedings of the 8th European software engineering conference held jointly with 9th ACM SIGSOFT international symposium on Foundations of software engineering, p. 313. ACM, New York (2001)"},{"key":"5_CR33","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"327","DOI":"10.1007\/3-540-45337-7_18","volume-title":"ECOOP 2001 - Object-Oriented Programming","author":"G. Kiczales","year":"2001","unstructured":"Kiczales, G., Hilsdale, E., Hugunin, J., Kersten, M., Palm, J., Griswold, W.G.: An overview of aspectj. In: Lee, S.H. (ed.) ECOOP 2001. LNCS, vol.\u00a02072, pp. 327\u2013353. Springer, Heidelberg (2001)"},{"key":"5_CR34","first-page":"192","volume-title":"Proceedings of the 15th Working Conference on Reverse Engineering","author":"A. Cleve","year":"2008","unstructured":"Cleve, A., Hainaut, J.L.: Dynamic analysis of sql statements for data-intensive applications reverse engineering. In: Proceedings of the 15th Working Conference on Reverse Engineering, pp. 192\u2013196. IEEE Computer Society, Los Alamitos (2008)"},{"key":"5_CR35","doi-asserted-by":"publisher","first-page":"287","DOI":"10.1142\/S0218843095000123","volume":"4","author":"J.M. Petit","year":"1995","unstructured":"Petit, J.M., Toumani, F., Kouloumdjian, J.: Relational database reverse engineering: A method based on query analysis. Int. J. Cooperative Inf. Syst.\u00a04, 287\u2013316 (1995)","journal-title":"Int. J. Cooperative Inf. Syst."},{"key":"5_CR36","series-title":"Lecture Notes in Artificial Intelligence","doi-asserted-by":"publisher","first-page":"430","DOI":"10.1007\/978-3-540-48247-5_54","volume-title":"Principles of Data Mining and Knowledge Discovery","author":"S. Lopes","year":"1999","unstructured":"Lopes, S., Petit, J.M., Toumani, F.: Discovery of \u201cInteresting\u201d data dependencies from a workload of SQL statements. In: \u017bytkow, J.M., Rauch, J. (eds.) PKDD 1999. LNCS (LNAI), vol.\u00a01704, pp. 430\u2013435. Springer, Heidelberg (1999)"},{"issue":"4","key":"5_CR37","doi-asserted-by":"publisher","first-page":"825","DOI":"10.1109\/TKDE.2002.1019216","volume":"14","author":"H.B.K. Tan","year":"2002","unstructured":"Tan, H.B.K., Ling, T.W., Goh, C.H.: Exploring into programs for the recovery of data dependencies designed. IEEE Trans. Knowl. Data Eng.\u00a014(4), 825\u2013835 (2002)","journal-title":"IEEE Trans. Knowl. Data Eng."},{"issue":"6","key":"5_CR38","doi-asserted-by":"publisher","first-page":"379","DOI":"10.1002\/smr.290","volume":"15","author":"H.B.K. Tan","year":"2003","unstructured":"Tan, H.B.K., Zhao, Y.: Automated elicitation of inclusion dependencies from the source code for database transactions. Journal of Software Maintenance\u00a015(6), 379\u2013392 (2003)","journal-title":"Journal of Software Maintenance"},{"issue":"6","key":"5_CR39","doi-asserted-by":"publisher","first-page":"377","DOI":"10.1145\/362384.362685","volume":"13","author":"E.F. Codd","year":"1970","unstructured":"Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM\u00a013(6), 377\u2013387 (1970)","journal-title":"Commun. ACM"},{"key":"5_CR40","unstructured":"Cleve, A., Lemaitre, J., Hainaut, J.L., Mouchet, C., Henrard, J.: The role of implicit schema constructs in data quality. In: Proceedings of the 6th International Workshop on Quality in Databases (QDB 2008), pp. 33\u201340 (2008)"},{"key":"5_CR41","unstructured":"DB-MAIN: The DB-MAIN official website (2011), http:\/\/www.db-main.be"},{"key":"5_CR42","unstructured":"Cohen, W.W., Ravikumar, P., Fienberg, S.E.: A comparison of string distance metrics for name-matching tasks. In: Proceedings of IJCAI-2003 Workshop on Information Integration on the Web (IIWeb-2003), pp. 73\u201378 (2003)"},{"key":"5_CR43","doi-asserted-by":"publisher","first-page":"366","DOI":"10.1145\/267580.267590","volume":"29","author":"H. Zhu","year":"1997","unstructured":"Zhu, H., Hall, P.A.V., May, J.H.R.: Software unit test coverage and adequacy. ACM Comput. Surv.\u00a029, 366\u2013427 (1997)","journal-title":"ACM Comput. Surv."},{"key":"5_CR44","first-page":"98","volume-title":"Proceedings of the 9th European software engineering conference held jointly with 11th ACM SIGSOFT international symposium on Foundations of software engineering. ESEC\/FSE-11","author":"G.M. Kapfhammer","year":"2003","unstructured":"Kapfhammer, G.M., Soffa, M.L.: A family of test adequacy criteria for database-driven applications. In: Proceedings of the 9th European software engineering conference held jointly with 11th ACM SIGSOFT international symposium on Foundations of software engineering. ESEC\/FSE-11, pp. 98\u2013107. ACM, New York (2003)"},{"key":"5_CR45","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"209","DOI":"10.1007\/978-3-540-39671-0_23","volume-title":"Self-Managing Distributed Systems","author":"M. Debusmann","year":"2003","unstructured":"Debusmann, M., Geihs, K.: Efficient and transparent instrumentation of application components using an aspect-oriented approach. In: Brunner, M., Keller, A. (eds.) DSOM 2003. LNCS, vol.\u00a02867, pp. 209\u2013220. Springer, Heidelberg (2003)"},{"key":"5_CR46","doi-asserted-by":"publisher","first-page":"215","DOI":"10.1109\/WCRE.2009.15","volume-title":"Proceedings of the 16th International Working Conference on Reverse Engineering (WCRE 2009)","author":"Y. Yang","year":"2009","unstructured":"Yang, Y., Peng, X., Zhao, W.: Domain feature model recovery from multiple applications using data access semantics and formal concept analysis. In: Proceedings of the 16th International Working Conference on Reverse Engineering (WCRE 2009), pp. 215\u2013224. IEEE Computer Society, Los Alamitos (2009)"},{"key":"5_CR47","first-page":"41","volume-title":"Proceedings of the 11th International Symposium on Web Systems Evolution (WSE 2009)","author":"M. Alalfi","year":"2009","unstructured":"Alalfi, M., Cordy, J., Dean, T.: WAFA: Fine-grained dynamic analysis of web applications. In: Proceedings of the 11th International Symposium on Web Systems Evolution (WSE 2009), pp. 41\u201350. IEEE Computer Society, Los Alamitos (2009)"}],"container-title":["Lecture Notes in Computer Science","Journal on Data Semantics XV"],"original-title":[],"link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-642-22630-4_5","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,6,22]],"date-time":"2020-06-22T03:53:01Z","timestamp":1592797981000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-642-22630-4_5"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2011]]},"ISBN":["9783642226298","9783642226304"],"references-count":47,"URL":"https:\/\/doi.org\/10.1007\/978-3-642-22630-4_5","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2011]]}}}