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

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!

-- 
  _
/ \ Leandro Guimarães Faria Corsetti Dutra           +55 (11) 246 96 07
\ / http://homepage.mac.com./leandrod/     BRASIL    +55 (43) 322 89 71
  X  http://tutoriald.sourceforge.net./     mailto:lgcdutra_at_terra.com.br
/ \ Campanha fita ASCII, contra correio HTML    mailto:leandrod_at_mac.com