And the only thing I'd add to that is that there are really well established patterns for Object-Relational Mapping between the two models, so it usually makes sense to start with an object model (assuming you're coding using OOP principles) and then follow the heuristics for mapping inheritance and relationships to create the relational structure from the object model. Google "object relational mapping" to access great articles on how to do this. Just think be careful of performance considerations. Or you could use an OO db or one of the toolkits that handles OR mapping out of the box . . .
Best Wishes, Peter -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sean Corfield Sent: Friday, February 10, 2006 9:22 PM To: CFCDev@cfczone.org Subject: Re: [CFCDev] OT: Database design On 2/10/06, Phillip Senn <[EMAIL PROTECTED]> wrote: > But isn't this a candidate for Object Oriented design? OO design is not how to create a good database design! You use OO design to create your object model (in memory) and relational design to create your data model (in the database). Often - and, in the case of complex relationalships, usually - the object model and the relational model do not directly match. -- Sean A Corfield -- http://corfield.org/ Got frameworks? "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org