Database Refactoring

Well, after long time no? I was very busy in last few weeks. Guess wut? Enjoying my first project leading experience :) I think we did well and we delivered first part (admin) of the application to the customer on time. It was an e-commerce web application. Little bit complex one. There were lots of technical stuffs that I experienced on the way but hadn’t got time to post. All the members of my team gave me a tremendous support and they did well although some guys are new to asp.net. Thanks guys!

Anyway when I took over the project some parts had started to develop. Since I don’t like to do things in improper way there were lot of refactorings in the codes went there. And in the databases also.
Here are some useful links on database refactoring.

http://www.agiledata.org/essays/databaseRefactoringCatalog.html

http://www.databaserefactoring.com/catalog/

Well, if u r thinking wut the heck of this database refactoring see below wut they say.

* A refactoring is a small change to your code which improves its design without changing its semantics.
* A database refactoring is a small change to your database schema (the table structures, data itself, stored procedures, and triggers) which improves its design without changing its semantics.
* Database refactoring is a technique which supports evolutionary development processes.