• 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
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

Refactoring Databases? Too late!

 
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'd like to have this book for free, but refactoring database seems too late for SDLC or a project. If the project finished or applications running well,my opinion is that it is the last step to change database schema and keep away from it as possible as you can.

Your comments are welcome.

Thanks.
 
author
Posts: 14112
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You are right that refactoring doesn't make sense if you know that you will never again have to touch the system.

But as long as a system is used, there are needs to change it. If you don't make refactoring part of your daily work, those changes will become harder and harder to do.
 
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Moreover, agility is a well recognized term in software project.
 
blacksmith
Posts: 979
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Jason,

I agree that you shouldn't touch the
database if everything is working fine.

Alternatively if some changes are
needed to accomodate new insights,
or solve a problem, I guess that
looking at the list of refactorings
might bring you to ideas you would
probably not consider at first.

It would be interesting though to
see some statistics that compare
the use/need of code refactorings
vs database refactorings, since the
database is in practice a static
element in the whole picture on
which the intrisically dynamic code
operates.

Gian
[ July 27, 2006: Message edited by: Gian Franco Casula ]
 
Ranch Hand
Posts: 308
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
when i remember from books and articles that 60% of the costs are bound to maintenance, refactoring practices (and the whole project organization around it: build management, unit tests etc.) are a very valuable (but often undermined) thing.

in some cases (e.g. shorter life-cycle software) 60% is maybe too high, but i think it is very rare that after software-system delivery your team is never going to touch the code again.
 
author
Posts: 608
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I recently ran a survey for Dr. Dobb's Journal (www.ddj.com) regarding the current state of data management. The results will appear in the November issue, which will be available online for free, and I can't reveal the exact numbers here. The short story is that the current state is really, really bad. Traditional data professionals have pretty much given up and don't have any sort of coherent, viable strategy for evolving and/or fixing their database schemas, even though the vast majority admit that data is a considered to be a corporate asset (no surprise there) and that their production databases have design and/or quality problems. They're really lucky that people expectations of them are very low, something that has clearly come out of the survey, otherwise I doubt that they'd keep their jobs.

- Scott
 
It is an experimental device that will make my mind that most powerful force on earth! More powerful than this tiny ad!
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter
reply
    Bookmark Topic Watch Topic
  • New Topic