Object .vs. Relational

From: Matthew Fuller <matthewlf_at_my-deja.com>
Date: Mon, 06 Nov 2000 23:05:16 GMT
Message-ID: <8u7df6$4mh$1@nnrp1.deja.com>

I did some searching on the board for this subject and only found old messages with few responses. I'm hoping there's some more enlightened folks out there now.

Does anyone have any input on Object .vs. Relational database structure in Oracle? Code being developed in our shop is OO (Java). Current database architecture is "Object Relational" as we are using that methodology along with the Spatial Data Option. Am considering migrating to a fully object model.

After digging through documentation I have the following perceptions (please correct or confirm):
- Performance will not be "too" much different. It would seem that
Oracle is storing Object tables similar to relational tables (both have "rowids", both can be indexed, etc.). I have to believe that the way Oracle really physically stores and accesses the data is not that much different after you get past the different coding techniques.
- Design/Development may be faster, and should at least be more
cohesive since both code and DB are in the same methodology.
- Learning curve for DBAs and Admins that are strictly "relational"
will have to be overcome, but this should be reasonably easy for my group.

Am I missing anything?

TIA. Matt.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 06 2000 - 17:05:16 CST