HECATAEUS: Regulating Schema Evolution

HECATAEUS is an open-source software tool for enabling impact prediction, what-if analysis, and regulation of relational database schema evolution. We follow a graph theoretic approach and represent database schemas and database constructs, like queries and views, as graphs. Our tool enables the user to create hypothetical evolution events and examine their impact over the overall graph before these are actually enforced on it. It also allows definition of rules for regulating the impact of evolution via (a) default values for all the nodes of the graph and (b) simple annotations for nodes deviating from the default behavior. Finally, HECATAEUS includes a metric suite for evaluating the impact of evolution events and detecting crucial and vulnerable parts of the system. I. MOTIVATION Database-centric systems are continuously evolving environments, where design constructs are added, removed or updated due to changes to system specifications and initial requirements. Hence, database sche...

• Type: Conference
• Year: 2010
• Where: ICDE
• Authors: George Papastefanatos, Panos Vassiliadis, Alkis Simitsis, Yannis Vassiliou
• Keywords: Database, Database Schema, Database Schema Evolution, Evolution Events, ICDE 2010