Re: Please help me decide

hi there!

"George I. Develekos" schrieb:
> We're in the early designing stages for a knowledge management system
> that will model knowledge items as XML files containing text fields as
 

> well as BLOBs. The XML elements will be stored in a DBMS. Intelligent
> rule-based retrieval and management in general must be supported. The
> number of stored items will be in the thousands, but their size may be
> in the Megs. Access to the database will be through the WWW, most
> probably via JDBC, and will not be frequent. The OS will be WNT/2000 o
 r
> Solaris.
>
 

> The million-dollar question now is: what DBMS should we go for?
> Relational, OO or OR? And in vendor-specific terms, Oracle? DB2?
> MS-SQL-Server?

well... i know that newer versions of the big databases (oracle, sybase etc.) do contain support for special binaray formats (office documents etc.). depending the type of content you want to store these might be a good choice for you if you need indexing this binary content.

generally speaking are oodb's better at recursive structrures (i.e. graphs) which must be navigated. if you are more query oriented i would favour relational db's.

i know this is not too much of a help but maybe some points to consider and direct further research. (i hop you have the time for this.)

regards

        robert

-- 

Robert Klemme
Software Engineer
-------------------------------------------------------------
myview technologies GmbH & Co. KG
Riemekestra e 160 ~ D-33106 Paderborn ~ Germany
E-Mail: mailto:robert.klemme_at_myview.de
Telefon: +49/5251/69090-321 ~ Fax: +49/5251/69090-399
-------------------------------------------------------------