60 likes | 329 Views
HECATAEUS: A What-If Analysis Tool for Database Schema Evolution. George Papastefanatos 1 , Fotini Anagnostou 1 Panos Vassiliadis 2 , Yannis Vassiliou 1 (1) National Technical University of Athens {gpapas,yv}@dbnet . ece . ntua . gr (2) University of Ioannina pvassil@cs.uoi.gr.
E N D
HECATAEUS: A What-If Analysis Tool for Database Schema Evolution George Papastefanatos1, Fotini Anagnostou1 Panos Vassiliadis2, Yannis Vassiliou1 (1) National Technical University of Athens {gpapas,yv}@dbnet.ece.ntua.gr (2) University of Ioannina pvassil@cs.uoi.gr CSMR’08, Athens, April 2008
HECATAEUS at a glance • Graph representation of database schema, views and queries • Graph annotation with policies for regulating database schema evolution • What-if analysis for evolution scenarios – highlight impact • Graph metrics for design quality wrt evolution CSMR‘08, Athens, April 2008
Creating Scenarios Annotating with policies Creating Events CSMR‘08, Athens, April 2008
Highlight Impact CSMR‘08, Athens, April 2008
System Architecture XML , Graph Viewer Import / jpeg Export DDL files Graph Visualization Scenarios SQL scripts Evolution Manager DB Schema representation Metric Manager Workload representation Parser Evolution Semantics Create Validate DB Workload Schema DB Catalog CSMR‘08, Athens, April 2008