Sorry if this is an OT.

So after years of using strictly relational databases, I've begun to
consider an alternative. Object databases seem compelling, especially
since the data in the project I'm mostly involved in is highly
hierarchical. So the questions:
1) When would you recommend ODBMS, and when RDBMS?
2) Which ODBMS would you recommend?
3) The application I work on is single user desktop application. The
data resides on the user's computer. Is there any ODBMS suitable for
this (something like equivalent to MSDE, Access, etc.). Is there any
"lightweight" object database suitable for this, or would you recommend
something else instead?

Thanks,
Sasa

On Oct 31, 3:44 pm, Sasa <sasa... (AT) gmail (DOT) com> wrote:
A. So if your data is hierarchical, then when don't you consider a
Hierarchical DBMS?
B. OODMBS has no theoritical basis yet. AFAIK.
C. There are lots of relational databases, that would suit your needs.
Even in a single user application.

Ed

You should check out http://www.odbms.org/ which provides a collection
of free materials on object database technology.

One of the primary reasons for choosing an oodb is to avoid the
impedence mismatch between the language you are developing your
application in and the storage model for the data.

GemStone Systems provides two object database solutions, which provide
transparent persistence for Smalltalk
(http://www.gemstone.com/products/smalltalk/index.php) and Java
(http://facetsodb.com)

Sasa wrote:

DBD is an experimental database that I have been developing. It handles
lists, tables, multi-rooted / bi-directional hierarchies, graphs,
networks, etc. It is extremely light. If you would like to post your
data (or email me directly), I can create a dbd database that you can
compare with other solutions.

Below are some hierarchal examples:
www.dbfordummies.com/example/ex006.asp
www.dbfordummies.com/example/ex007.asp
www.dbfordummies.com/example/ex010.asp
www.dbfordummies.com/example/ex012.asp