• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Refactoring and Agile Database Design

 
Ranch Hand
Posts: 3404
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Would ADD have an impact on the way Refactoring is done a la Martin Fowler ?
 
author
Posts: 11962
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I wouldn't say so. Fowler's Refactoring discusses refactoring *code*, and most refactorings do not require a change of the database schema (they might produce a "smell", however, which would suggest that the schema could be refactored to support the code better). I might be wrong, of course, and I haven't really put too much effort into thinking about database refactoring and its ripple effects to code.
 
author
Posts: 608
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes, as Martin discusses in his book DB refactoring is significantly harder. Chapter 12 of the ADT book (www.ambysoft.com/agileDatabaseTechniques.html) goes into details. You can also find information at http://www.agiledata.org/essays/databaseRefactoring.html.
- Scott
 
HS Thomas
Ranch Hand
Posts: 3404
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
THanks Scott, that link looks really interesting and revolutionary.
 
Ranch Hand
Posts: 341
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In the Martin's Evolutionary Database Design Article says
"Over the last few years we've developed a number of techniques that
allow a database design to evolve as an application develops. This is a
very important capability for agile methodologies. The techniques rely
on applying continuous integration and automated refactoring to database
development, together with a close collaboration between DBAs and
application developers. The techniques work in both pre-production and
released systems."
 
author
Posts: 14112
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Scott, are there tools like refactoring browsers for databases?
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic