SDSU Department of Computer Science
  
Home Contact Us Undergraduate Student Info Graduate Student Info Faculty & Staff News & Events
News Calendar Problem of the Fortnight

March 2008 Calendar

CS Masters' Thesis Defense

Title: Database Refactoring Implementation
Speaker: Radhikadevi Mookiah
Date: Friday, March 21, 2008
Time: 2:00 p.m.
Location: GMCS 328
Thesis advisor: Dr Carl Eckberg

Abstract:
This thesis uses ?Refactoring Databases Evolutionary Database Design? by Scott W. Ambler and Pramod J. Sadalage book and implements the refactorings listed in it. Thirteen refactorings from this book are implemented. A GUI based tool is implemented to refactor the oracle database. Manual database refactoring is an error prone process. There might be some mistakes while doing this. This tool analyzes all the possible scenarios and does there factoring. It does all the error checking by itself. Java swing is used to implement the GUI part of the tool. The layout manager used here is gridbag layout. This tool uses java.sql.* API methods to do their factoring. Database triggers in java are used to automate the database refactoring.
webmaster@cs.sdsu.edu page counter College of Sciences