As I cycled home this evening I was thinking to myself that perhaps a mixed-database environment might be the best approach. I was trying to work out how I would re-engineer our platform given the opportunity, and it’s clear that whilst some areas are ripe for the NoSQL upgrade, others, notably transaction tables, audit logs etc., are much better suited to strongly-typed relational databases.
As with everything I seem to do at the moment, I’m definitely a follower, as no sooner had I fired up my browser than I came across the following: http://johnpwood.net/2009/09/29/using-multiple-database-models-in-a-single-application/
It’s a great article, articulate and intelligent, so go read it…
0 comments:
Post a Comment