Re: [SQL] object oriented vs relational DB

2002-10-18 Thread Marten Feldtmann
Josh Berkus schrieb: I've looked into OODBMS for my business. However, I've kept from using any in production for one simple reason: lack of a standard. There is no international standard for OODBMS, meaning that each OODBMS is its own animal and databases are not at all portable between dif

Re: [SQL] object oriented vs relational DB

2002-10-17 Thread Richard Huxton
On Thursday 17 Oct 2002 4:03 pm, Josh Berkus wrote: > Charles, > > > as far as I aware, constantly evolving schema is not one of > > relational databases > > strengths." > > All of the above issues are easily solvable by a SQL expert. "You > show me somebody preaching about the 'limitations' of r

Re: [SQL] object oriented vs relational DB

2002-10-17 Thread Josh Berkus
Charles, > ".is perhaps evolving its schema _more_ now that sequencing is > finished and annotation is really picking up speed, you should not > think that > the changes are going to get less ! You will have to deal with > problems like > genes that get renamed but you still need the old name

[SQL] object oriented vs relational DB

2002-10-17 Thread Charles Hauser
Perhaps a mistake to ask this here (heresy I suspect) but I would be interested in the perspectives of people who make a living at this. Background: I am a molecular biologist trying to build a database containing genomic data, strain details, community info (people, publications etc). Every