RDBMS Vs OODBMS

irishguy

I have been given a paper to compare these two dbms's and suggest which one would be better for a particular organization. But I was under the impression that OODBMS'S were just theory at the moment and that there is no actual working examples of these, does anyone one know of any?

QC

There are plenty of OOBMSs available, try googling, you'll find plenty.

irishguy

but there are no commercial products in general use right? its just concept products i cant find any large organisations that actually use them

MrPinK

Oracle is moving in the OO direction. Oracle 9i is an object-relational database, a hybrid of the two.

causal

Only info I had was from an RDMS course a few years ago:

As of late 1999, a new standard, SQL3, was under development.
Key features of the SQL3 standard include support for user defined abstract data types, procedural capabilities in the SQL language, and for object oriented data.

So I did a quick search on SQL 3 which led to http://dbs.uni-leipzig.de/en/lokal/standards.pdf which said:

As you may be aware, SQL3 has been characterized as “object-oriented SQL” and is the foundation for several object-relational database management systems (including Oracle’s ORACLE8, Informix’ Universal Server, IBM’s DB2 Universal Database, and Cloudscape’s Cloudscape, among others). This is widely viewed as a “good thing”, but it has had a downside, too: it took nearly 7 years to develop, instead of the planned 3 or 4.

hth,
causal

Zombrex

PostgreSQL is sort of a hybrid between Relational and OO. It would be probably a good place to start if you wanted to mess around with some concepts of OO Databases... plus it is free and open source

ressem

http://www.intersystems.com have been advertising Cache for yonks, comparing relational db's to tractors in every ddj I remember.
They've got a free single user version for evaluation, and a few biased technical docs on the web site.

damnyanks

What is OODBMS? I'm guessing its object orientated. Why would you use it instead of relational or is it "the next big thing" in the database world?

HaVoC

Main argument against OODBMS I came across was that unless your developing a completely new system, chances are you will have a legacy RDBMS there already so its too much work to change over. With hybrid databases it may be no longer the case though

irishguy

just wondering about it have to do a 'Research paper' on it because my dumbass database lecture couldnt be bothered doing it in class.ill just stick a few things togeather for her

Zombrex

irishguy wrote:

just wondering about it have to do a 'Research paper' on it because my dumbass database lecture couldnt be bothered doing it in class.ill just stick a few things togeather for her

LOL .. sounds about right ... lecture saying "you really need to know this but by god I couldn't be arsed teaching it to you, go do a reseach paper" ... ah takes me back

ressem

Also you have the option of object/relational mapping libraries like Hibernate, so you can stick to your well known relational db and have some of the object oriented db advantages.

mewso

Some good articles (.net orientated but a good intro to odbms):-

http://www.15seconds.com/issue/030407.htm
http://www.15seconds.com/issue/031013.htm

vigos

irishguy wrote:

but there are no commercial products in general use right? its just concept products i cant find any large organisations that actually use them

take a look at Versant and especially the white papers or faq. Versant specialises in OODBMS