Tuesday, 24 August 2010

Model-based Database Prototyping

If there's one software project idea that keeps coming back to taunt me, it's this: rapid database prototyping. I got hooked on database modelling with a relatively obscure approach called Object Role Modelling. The industry standard is either creating database tables directly or Entity Relationship modelling, which is pretty much the same thing. My Big Idea is to use ORM to draw domain object relationships, then have the program transform it into mock-up database tables as well as prototype user interface code.

None of that is too groudbreaking, and you could do it fairly easily with existing tools. The next step is to modify the domain model and have the tools update the prototype code while retaining as much test data as possible. That's not so easy, but it's also not impossible. I could probably manage it with data dumps, new scripts and manually-written data migration, though I imagine that would get tedious. Given what exists already, perhaps all I need is an assistant tool for data migration between different database schemas.

Mokalus of Borg

PS - If that makes any sense.
PPS - Data migration isn't so easy.

No comments: