Σεμινάριο Τμήματος με τίτλο: “Schema evolution for relational databases”, Παναγιώτης Βασιλειάδης
Στο πλαίσιο της διοργάνωσης των σεμιναρίων του τμήματος θα πραγματοποιηθεί την Τρίτη 02/07/2019 και ώρα 12:00 στην αίθουσα Σεμιναρίων του Τμήματος Μηχανικών Η/Υ και Πληροφορικής, ομιλία με τίτλο “Schema evolution for relational databases”. Ομιλητής θα είναι ο Αν. Καθηγητής κ. Παναγιώτης Βασιλειάδης, Τμήμα Μηχανικών Η/Υ & Πληροφορικής, Πανεπιστήμιο Ιωαννίνων.
Like all software systems, databases are subject to evolution as time passes. Apart from the evolution of the content, the internal structure, also known as schema of the database, evolves too. The impact of schema evolution is tremendous as every change to the schema of a database affects the syntactic correctness and the semantic validity of all the surrounding applications and de facto necessitates their maintenance in order to remove errors from their source code. The talk will provide a walk-through on the currently available evidence on the mechanics of schema evolution, based on the study of the version history of free, open-source systems (FOSS) that are built on top of relational databases. We will discuss the main lessons learned from these case studies, organized in three lines of investigation. In the context of the first line of investigation that deals with the evolution of the schema in its entirety we will discuss regularities concerning the growth patterns and the change rate of the involved schemata. In the context of the second line of investigation, that deals with the evolution of individual tables, we will discuss findings on how the change profile of individual tables is related to their structural properties, like schema size (the number of attributes of a table), duration, and, time of birth. In the context of the third line of investigation that deals with the evolution of foreign keys we will discuss how foreign keys evolve along with tables, along with evidence about the mistreatment of foreign keys in several occasions. Open issues for further research will be discussed at the end of the talk.