{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,6]],"date-time":"2026-03-06T01:26:50Z","timestamp":1772760410064,"version":"3.50.1"},"reference-count":28,"publisher":"Springer Science and Business Media LLC","issue":"10","license":[{"start":{"date-parts":[[2019,1,21]],"date-time":"2019-01-21T00:00:00Z","timestamp":1548028800000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Computing"],"published-print":{"date-parts":[[2019,10]]},"DOI":"10.1007\/s00607-019-00702-x","type":"journal-article","created":{"date-parts":[[2019,1,21]],"date-time":"2019-01-21T00:31:56Z","timestamp":1548030716000},"page":"1431-1456","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":13,"title":["Schema evolution and foreign keys: a study on usage, heartbeat of change and relationship of foreign keys to table activity"],"prefix":"10.1007","volume":"101","author":[{"ORCID":"https:\/\/orcid.org\/0000-0003-0085-6776","authenticated-orcid":false,"given":"Panos","family":"Vassiliadis","sequence":"first","affiliation":[]},{"given":"Michail-Romanos","family":"Kolozoff","sequence":"additional","affiliation":[]},{"given":"Maria","family":"Zerva","sequence":"additional","affiliation":[]},{"given":"Apostolos V.","family":"Zarras","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2019,1,21]]},"reference":[{"key":"702_CR1","volume-title":"Statistics in a nutshell\u2014a desktop quick reference","author":"S Boslaugh","year":"2012","unstructured":"Boslaugh S (2012) Statistics in a nutshell\u2014a desktop quick reference. O\u2019Reilly, Sebastopol"},{"key":"702_CR2","doi-asserted-by":"publisher","first-page":"132","DOI":"10.1007\/978-3-642-16373-9_10","volume-title":"Conceptual Modeling \u2013 ER 2010","author":"Anthony Cleve","year":"2010","unstructured":"Cleve A, Brogneaux A, Hainaut J (2010) A conceptual approach to database applications evolution. In: 29th International conference on conceptual modeling (ER 2010), Vancouver, BC, Canada, November 1\u20134, 2010, pp 132\u2013145"},{"key":"702_CR3","doi-asserted-by":"publisher","first-page":"113","DOI":"10.1016\/j.scico.2013.11.025","volume":"97","author":"A Cleve","year":"2015","unstructured":"Cleve A, Gobert M, Meurice L, Maes J, Weber JH (2015) Understanding database schema evolution: a case study. Sci Comput Program 97:113\u2013121","journal-title":"Sci Comput Program"},{"key":"702_CR4","unstructured":"Curino C, Moon HJ, Tanca L, Zaniolo C (2008) Schema evolution in wikipedia: toward a web information system benchmark. In: Proceedings of ICEIS 2008, Citeseer"},{"issue":"1","key":"702_CR5","doi-asserted-by":"publisher","first-page":"73","DOI":"10.1007\/s00778-012-0302-x","volume":"22","author":"C Curino","year":"2013","unstructured":"Curino C, Moon HJ, Deutsch A, Zaniolo C (2013) Automating the database schema evolution process. VLDB J 22(1):73\u201398","journal-title":"VLDB J"},{"key":"702_CR6","unstructured":"Decan A, Goeminne M, Mens T (2015) On the interaction of relational database access technologies in open source java projects. In: Post-proceedings of the 8th seminar on advanced techniques and tools for software evolution, Mons, Belgium, July 6\u20138, 2015, pp 26\u201335"},{"key":"702_CR7","unstructured":"Decan A, Goeminne M, Mens T (2017) On the interaction of relational database access technologies in open source java projects. CoRR abs\/1701.00416. \n                    arXiv:1701.00416"},{"issue":"1","key":"702_CR8","doi-asserted-by":"publisher","first-page":"73","DOI":"10.1016\/j.datak.2009.08.008","volume":"69","author":"J Garc\u00eda-Garc\u00eda","year":"2010","unstructured":"Garc\u00eda-Garc\u00eda J, Ordonez C (2010) Extended aggregations for databases with referential integrity issues. Data Knowl Eng 69(1):73\u201395","journal-title":"Data Knowl Eng"},{"key":"702_CR9","doi-asserted-by":"publisher","first-page":"63","DOI":"10.1007\/978-3-319-23135-8_5","volume-title":"Advances in Databases and Information Systems","author":"Kai Herrmann","year":"2015","unstructured":"Herrmann K, Voigt H, Behrend A, Lehner W (2015) Codel: a relationally complete language for database evolution. In: 19th East European conference on advances in databases and information systems (ADBIS 2015), Poitiers, France, September 8\u201311, 2015, pp 63\u201376"},{"issue":"2","key":"702_CR10","doi-asserted-by":"publisher","first-page":"77","DOI":"10.1002\/smr.344","volume":"19","author":"HH Kagdi","year":"2007","unstructured":"Kagdi HH, Collard ML, Maletic JI (2007) A survey and taxonomy of approaches for mining software repositories in the context of software evolution. J Softw Maint 19(2):77\u2013131","journal-title":"J Softw Maint"},{"key":"702_CR11","doi-asserted-by":"publisher","first-page":"88","DOI":"10.1016\/j.is.2018.04.001","volume":"76","author":"H K\u00f6hler","year":"2018","unstructured":"K\u00f6hler H, Link S (2018) SQL schema design: foundations, normal forms, and normalization. Inf Syst 76:88\u2013113","journal-title":"Inf Syst"},{"key":"702_CR12","unstructured":"Lin DY, Neamtiu I (2009) Collateral evolution of applications and databases. In: Proceedings of the joint international and annual ERCIM workshops on principles of software evolution (IWPSE) and software evolution (Evol) workshops, IWPSE-Evol \u201909, pp 31\u201340"},{"key":"702_CR13","doi-asserted-by":"publisher","first-page":"182","DOI":"10.1007\/978-3-642-41924-9_17","volume-title":"Conceptual Modeling","author":"Petros Manousis","year":"2013","unstructured":"Manousis P, Vassiliadis P, Papastefanatos G (2013) Automating the adaptation of evolving data-intensive ecosystems. In: Proceedings of 32th international conference on conceptual modeling (ER 2013), Hong-Kong, China, November 11\u201313, 2013, pp 182\u2013196"},{"key":"702_CR14","doi-asserted-by":"crossref","unstructured":"Meurice L, Ruiz FJB, Weber JH, Cleve A (2014) Establishing referential integrity in legacy information systems\u2014reality bites! In: 30th IEEE international conference on software maintenance and evolution, Victoria, BC, Canada, September 29\u2013October 3, 2014, pp 461\u2013465","DOI":"10.1109\/ICSME.2014.74"},{"key":"702_CR15","doi-asserted-by":"crossref","unstructured":"Meurice L, Nagy C, Cleve A (2016) Static analysis of dynamic database usage in java systems. In: Proceedings of 28th international conference on advanced information systems engineering , CAiSE 2016, Ljubljana, Slovenia, June 13\u201317, 2016, pp 491\u2013506","DOI":"10.1007\/978-3-319-39696-5_30"},{"issue":"10","key":"702_CR16","first-page":"1082","volume":"8","author":"T Papenbrock","year":"2015","unstructured":"Papenbrock T, Ehrlich J, Marten J, Neubert T, Rudolph J, Sch\u00f6nberg M, Zwiener J, Naumann F (2015) Functional dependency discovery: an experimental evaluation of seven algorithms. PVLDB 8(10):1082\u20131093","journal-title":"PVLDB"},{"key":"702_CR17","doi-asserted-by":"crossref","unstructured":"Qiu D, Li B, Su Z (2013) An empirical analysis of the co-evolution of schema and code in database applications. In: Proceedings of the 2013 9th joint meeting on foundations of software engineering, ESEC\/FSE 2013, pp 125\u2013135","DOI":"10.1145\/2491411.2491431"},{"issue":"1","key":"702_CR18","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 (1993) Quantifying schema evolution. Inf Softw Technol 35(1):35\u201344","journal-title":"Inf Softw Technol"},{"key":"702_CR19","doi-asserted-by":"crossref","unstructured":"Skoulis I, Vassiliadis P, Zarras A (2014) Open-source databases: within, outside, or beyond Lehman\u2019s laws of software evolution? In: 26th International conference on advanced information systems engineering (CAiSE 2014), Thessaloniki, Greece, June 16\u201320, 2014","DOI":"10.1007\/978-3-319-07881-6_26"},{"key":"702_CR20","doi-asserted-by":"publisher","first-page":"363","DOI":"10.1016\/j.is.2015.03.009","volume":"53","author":"I Skoulis","year":"2015","unstructured":"Skoulis I, Vassiliadis P, Zarras AV (2015) Growing up with stability: How open-source relational databases evolve. Inf Syst 53:363\u2013385","journal-title":"Inf Syst"},{"issue":"2","key":"702_CR21","doi-asserted-by":"publisher","first-page":"197","DOI":"10.1145\/7474.7475","volume":"18","author":"TJ Teorey","year":"1986","unstructured":"Teorey TJ, Yang D, Fry JP (1986) A logical design methodology for relational databases using the extended entity-relationship model. ACM Comput Surv 18(2):197\u2013222","journal-title":"ACM Comput Surv"},{"key":"702_CR22","doi-asserted-by":"publisher","first-page":"18","DOI":"10.1007\/978-3-319-66854-3_2","volume-title":"Model and Data Engineering","author":"Panos Vassiliadis","year":"2017","unstructured":"Vassiliadis P (2017) Schema evolution and gravitation to rigidity: a tale of calmness in the lives of structured data. In: Proceedings of 7th international conference model and data engineering\u2014MEDI 2017, Barcelona, Spain, October 4\u20136, 2017, pp 18\u201323"},{"key":"702_CR23","doi-asserted-by":"publisher","first-page":"333","DOI":"10.1007\/978-3-319-59536-8_21","volume-title":"Advanced Information Systems Engineering","author":"Panos Vassiliadis","year":"2017","unstructured":"Vassiliadis P, Zarras AV (2017) Survival in schema evolution: putting the lives of survivor and dead tables in counterpoint. In: 29th International conference on advanced information systems engineering (CAiSE 2017), Essen, Germany, June 12\u201316, 2017, pp 333\u2013347"},{"key":"702_CR24","doi-asserted-by":"publisher","first-page":"453","DOI":"10.1007\/978-3-319-25264-3_34","volume-title":"Conceptual Modeling","author":"Panos Vassiliadis","year":"2015","unstructured":"Vassiliadis P, Zarras AV, Skoulis I (2015) How is life for a table in an evolving relational schema? Birth, death and everything in between. In: Proceedings of 34th international conference on conceptual modeling (ER 2015), Stockholm, Sweden, October 19\u201322, 2015, pp 453\u2013466"},{"key":"702_CR25","doi-asserted-by":"publisher","first-page":"106","DOI":"10.1007\/978-3-319-69904-2_9","volume-title":"Conceptual Modeling","author":"Panos Vassiliadis","year":"2017","unstructured":"Vassiliadis P, Kolozoff M, Zerva M, Zarras AV (2017a) Schema evolution and foreign keys: birth, eviction, change and absence. In: Proceedings of 36th international conference on conceptual modeling (ER 2017), Valencia, Spain, November 6\u20139, 2017, pp 106\u2013119"},{"key":"702_CR26","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 AV, Skoulis I (2017b) Gravitating to rigidity: patterns of schema evolution\u2014and its absence\u2014in the lives of tables. Inf Syst 63:24\u201346","journal-title":"Inf Syst"},{"key":"702_CR27","doi-asserted-by":"crossref","unstructured":"Wu S, Neamtiu I (2011) Schema evolution analysis for embedded databases. In: Proceedings of the 2011 IEEE 27th international conference on data engineering workshops, ICDEW \u201911, pp 151\u2013156","DOI":"10.1109\/ICDEW.2011.5767627"},{"issue":"1","key":"702_CR28","first-page":"805","volume":"3","author":"M Zhang","year":"2010","unstructured":"Zhang M, Hadjieleftheriou M, Ooi BC, Procopiuc CM, Srivastava D (2010) On multi-column foreign key discovery. PVLDB 3(1):805\u2013814","journal-title":"PVLDB"}],"container-title":["Computing"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s00607-019-00702-x\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s00607-019-00702-x.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s00607-019-00702-x.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,1,20]],"date-time":"2020-01-20T19:21:05Z","timestamp":1579548065000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s00607-019-00702-x"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019,1,21]]},"references-count":28,"journal-issue":{"issue":"10","published-print":{"date-parts":[[2019,10]]}},"alternative-id":["702"],"URL":"https:\/\/doi.org\/10.1007\/s00607-019-00702-x","relation":{},"ISSN":["0010-485X","1436-5057"],"issn-type":[{"value":"0010-485X","type":"print"},{"value":"1436-5057","type":"electronic"}],"subject":[],"published":{"date-parts":[[2019,1,21]]},"assertion":[{"value":"9 March 2018","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"10 January 2019","order":2,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"21 January 2019","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}