Panos Vassiliadis, Alexandros Karakasidis
This paper presents a set of patterns on how schema evolution takes place over time in Free Open-Source Systems that are built on top of relational databases. To come up with these timing patterns, we have studied 151 projects of a public dataset of schema histories, with duration more than 12 months. The eight timing patterns of schema evolution are largely grouped in 3 families: (a) the family of limited and focused-in-time change, whose members differ only on when the change happens (early, middle or late life of a project), (b) the family of regular updates, whose members differ in the frequency of change, and (c) the family of middle or late initiation of change, whose members differ in the initiation of schema maintenance as well as the frequency of change.
Panos Vassiliadis, Alexandros Karakasidis. Time-Related Patterns of Schema Evolution. 28th International Conference on Extending Database Technology (EDBT 2025), pp: 310-323, Barcelona, Spain, March 25-28, 2025
[Local copy ] [OpenProceedings]
[Schema Biographies: research on Schema Evolution]
All data and code are found at the Schema Evolution Datasets repository, and in particular, data sets, code, and extra material for this paper.