Schema Evolution: Gravitation to Rigidity is the fundamental law

Schema Evolution: Gravitation to Rigidity is the fundamental law

Schema Evolution Video Collection

There is a schema evolution channel in YouTube with commentaries of our papers.

Schema Evolution Publications (Timeline)

Panos Vassiliadis. Profiles of Schema Evolution in Free Open Source Software Projects.37th IEEE International Conference on Data Engineering (ICDE '21), Chania, Crete, Greece, 19-22 April 2021.
Local page of the paper


Konstantinos Dimolikas, Apostolos V. Zarras, Panos Vassiliadis. A study on the effect of a table's involvement in foreign keys to its schema evolution. 39th International Conference on Conceptual Modeling (ER 2020), Nov. 3-6, 2020, Vienna.

Evolution of Foreign Keys at the Topological Level[Local page with the paper, video presentation and other material]

An 8' teaser video with just the key highlights, and a lengthier, full-fledged presentation of the paper

Panos Vassiliadis, Michail-Romanos Kolozoff, Maria Zerva, Apostolos V. Zarras. Schema evolution and foreign keys: a study on usage, heartbeat of change and relationship of foreign keys to table activity. Computing, Volume 101, Issue 10, pp 1431–1456, October 2019. 2019.

Long version of the ER'17 paper. [Official page by Springer] [Open by Springer (only for online reading)] [Local copy and supplementary material]

Panos Vassiliadis, Michail-Romanos Kolozoff, Maria Zerva, Apostolos V. Zarras. Schema Evolution and Foreign Keys: Birth, Eviction, Change and Absence. 36th International Conference on Conceptual Modeling (ER 2017), pp. 106-119, Nov. 6th-9th, 2017, Valencia Spain.

Evolution of Foreign Keys at the Macro Level[Local page with the paper, video presentation and other material]


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]


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]
Highlights of CAiSE 2017: Electrolysis


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]
Highlights of Information Systems 2017


Ioannis Skoulis, Panos Vassiliadis, Apostolos V. Zarras. Growing up with stability: How open-source relational databases evolve. Information Systems, Volume 53, October - November 2015, Pages 363 - 385. doi:10.1016/j.is.2015.03.009.

Long v. of CAiSE 2014 [Local page with highlights, papers, presentations, data, code and results]

Ioannis Skoulis, Panos Vassiliadis, Apostolos Zarras. Open-Source Databases: Within, Outside, or Beyond Lehman's Laws of Software Evolution?. 26th International Conference on Advanced Information Systems Engineering (CAiSE 2014). 16-20 June 2014, Thessaloniki, Hellas.

Macroscopic study of schema behavior[Local page with highlights, papers, presentations, data, code and results]

Summaries

Panos Vassiliadis. Schema Evolution and Gravitation to Rigidity: a tale of calmness in the lives of structured data. 7th International Conference on Model and Data Engineering (MEDI 2017), October 4-6, 2017 - Barcelona.

[A paper from a keynote talk at MEDI 2017. Plz., visit the Talks page for the talk slides and any other info].

Petros Manousis, Panos Vassiliadis, Apostolos V. Zarras, George Papastefanatos. Schema Evolution for Databases and Data Warehouses. In: Zimányi E., Abelló A. (eds) Business Intelligence. eBISS 2015. Lecture Notes in Business Information Processing, vol 253., pp. 1-31, Springer.

[A talk at the eBISS school in 2015, accompanied by a Chapter in Lecture Notes in BIP. The chapter (local copy here) surveys related work and the related research results in the area of schema evolution. Plz., visit the Talks page for the talk slides and any other info].

Schema evolution for relational databases: a keynote talk at the 5th International Conference on Data Management Technologies and Applications (DATA 2016), July 24 - July 26, Lisbon, Portugal [click here to watch the video of the talk at vimeo]