Home › Blogs › Christoph C. Cemper's blog
Projects & Management

Refactoring With Relational Databases

<< Best Practice for Software Development Projects | Typical Project Life >>
Sun, 09/14/2003 - 13:23 — Christoph C. Cemper

Refactoring With Relational Databases and Refactoring Challenge Thirteen and Refactoring SQL provide some great entrypoints

for getting into the question that a lot of XP-freaks could not answer to my satisfaction so far… Refactoring for database-bound systems (including a continous change of the ER-model, test-data, archiving/versioning of the DB,etc…).

One must admit that thinking of changing some simple text-files (Java-source or whatever) is a hell lot easier from the technical viewpoint than changing databases, according configuration data, etc… isn't it? I guess this is one of the real challenges in a real project…

Average rating
 
 
 
 
 
(0 votes)

Comments

Tue, 11/04/2003 - 12:45 — Gilles Philippart (not verified)

Refactoring With Relational Databases

I guess one acceptable solution would be to :

- version database creation scripts (to be able to build from scratch)
- version and migration scripts from version n to n+1.

Of course it would be difficult to provide a 'reverse refactoring changes' solution.

/Gilles Philippart

Similar entries

  • Refactoring PL/SQL

    utPLsql

  • Process of Database Refactoring

    Database Refactoring

  • Rivals IBM and BEA team on new Java Appserver specs

    BEA, IBM team on new Java specs and hope to provide more consistency across their application servers with three new specifications – most important the Service Data Objects (SDO) aiming to provide a simple, unified programming model for data access…

  • Have a Little Respect for SQL Databases

    Jack's article Have a Little Respect for SQL Databases adresses the often running discussions between OO nerds and database nerds both not realizing that a combination of technologies to utilize their respective advantages makes a success. And I agree…

  • OR-Mapping for Python

    Matt found some interesting OR-Mapping framework for Python: ModelingFramework looks interesting: “The Modeling framework intends to fill the gap between the python object world and relational databases. It relies on a model, based on Entity-Relationship Modelling, that describes how the…