Schema Evolution and Table Biographies: Studying the lives of tables

In this line of research, the object of study is shifted from the entire schema to individual tables. In our stydy we explore how evolution-related properties, like the possibility of deletion, life duration, or the amount of updates that a table undergoes, are related to observable table properties like the number of attributes or the version of birth of a table.

Publications

Fanis Giachos, Nikos Pantelidis, Christos Batsilas, Apostolos V. Zarras, Panos Vassiliadis. Parallel lives diagrams for co-evolving communities and their application to schema evolution. Companion Proceedings of the 42nd International Conference on Conceptual Modeling (ER 2023): ER Forum, 7th SCME, Project Exhibitions, Posters and Demos, and Doctoral Consortium. Lisbon, Portugal, November 6-9, 2023.

Visualization techniques on the paraller lives of evolving tables in a relational schema [Local folder of the paper]

Panos Vassiliadis, Apostolos V. Zarras. Schema Evolution Survival Guide for Tables: Avoid Rigid Childhood and You’re En Route to a Quiet Life. Journal on Data Semantics, Volume 6, Issue 4, December 2017, pp 221–241, ISSN: 1861-2040, DOI: 10.1007/s13740-017-0083-x.

Long Version of the CAiSE 2017 paper [Local page with highlights, papers, presentations, data, code and results]

Panos Vassiliadis, Apostolos Zarras. Survival in schema evolution: putting the lives of survivor and dead tables in counterpoint. 29th International Conference on Advanced Information Systems Engineering (CAiSE 2017), 12-16 June 2017, Essen, Germany.

[Local page with highlights, papers, presentations, data, code and results]

Panos Vassiliadis , Apostolos V. Zarras , Ioannis Skoulis. Gravitating to Rigidity: Patterns of Schema Evolution -and its Absence- in the Lives of Tables. Information Systems, Volume 63, January 2017, Pages 24-46, ISSN 0306-4379, doi:10.1016/j.is.2016.06.010.

Long v. of ER 2015 paper [Local page with highlights, papers, presentations, data, code and results]

Panos Vassiliadis, Apostolos Zarras, Ioannis Skoulis. How is Life for a Table in an Evolving Relational Schema? Birth, Death & Everything in Between. 34th International Conference on Conceptual Modeling (ER 2015). 19-22 October 2015, Stockholm, Sweden.

[Local page with highlights, papers, presentations, data, code and results]

Watchlist

Highlights of Information Systems 2017
Highlights of CAiSE 2017: Electrolysis
Keynote talk at DATA 2016


Schema Evolution and Gravitation to Rigidity: a tale of calmness in the lives of structured data: a keynote talk at the 7th International Conference on Model and Data Engineering (MEDI 2017), October 4-6, 2017 - Barcelona. [Click here for a 5-pages paper]