File Library


Tips and Techniques for Refactoring Database Schemas
Topic: Kscope14 Recordings
Owner: Dominic Delmolino
Date: 2014-05-29
Subtopic: The Database

DBAs supporting projects using ORMs like ActiveRecord, Hibernate, MyBatis and others often have difficulty in making schema changes without breaking application code. This is particularly evident in projects that use continuous integration as every database change triggers re-compliation of the application code. "Breaking the build" by making database changes can make DBAs frustrated and non-productive. In this presentation, DBAs will learn about refactoring techniques that can "keep builds green" and applications from being sensitive to physical schema changes. Common refactoring options and ways to reduce the tight-coupling of ORMs to physical schema objects will be discussed. By the end of the presentation, DBAs will understand how to participate in an Agile development project using continuous integration without having to resort to outside processes. DBAs will be able to fully participate in the agile development process.


Download File   ddelmolino.refactoringdatabases.pdf
Download File   Tips and Techniques for Refactoring Database Schemas-DB.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database


Click here to see the Full Techincal Resource Database