Re: What're the differences betwen OO database and relational databases?

From: Dan Star <danstar_at_engman-taylor.com>
Date: Fri, 28 Sep 2001 10:04:49 -0500
Message-ID: <3bb49376$0$42876$272ea4a1_at_news.execpc.com>


Leandro Guimarăes Faria Corsetti Dutra wrote:
>
> soda wrote:
>
> > I only learn relational databases at school, Object Oriented database
>
> That's because relational is the only game in theory.
>
> > was virtually unknown then. I've tried to find out but it would be
>
> It's still unknown know. It's so ill-defined it seems no two authors can agree
> on its fundamental concepts.
>
> > easier to ask you folks what you think. Does OO database goes faster?
>
> Only for application-specific databases.
>
> > Easier to maintain? Can I design OO database and use them in MySQL?
>
> Much harder to maintain, since you have pointers all over the place.
>
> MySQL can't do even SQL properly, much less relation -- don't try to bend it
> over backwards to the network model.
>
> "Network model?", I hear you ask. Yes, OODB is just the network model under a
> new name, and fitted to *some* OO programming idea -- it's not "the" because
> even when restricted to programming OO gets no consensus on fundamentals; when
> it's extended to DBMSs it breaks completely.
>
> > Thank you for reading my silly questions?
>
> You are welcome, just be sure to do your homework. Get yourself and
>
> read "Foundation for Future Database Systems: The Third Manifesto", 2nd edition,
>
> by Chris J Date and Hugh Darwen; but before that make sure you've already read
>
> "An Introduction to Database Systems", 6th or 7th editions, by Chris J Date.
>
> You can find more info about these titles and other relevant ones at
> http://dbdebunk.com./
>
> By the way, OO is a physical model and relational is a logical one, so only
> relational is pertinent to a "theory" forum. Asbestos up!
>

I have never understood the OODMs for two reasons: 1) depends which author you read, and 2) why would someone design a database based upon one view 9or a few) of the data?

Dan Received on Fri Sep 28 2001 - 17:04:49 CEST

Original text of this message