Re: Please help me decide

George,

Try the following related Oracle features (all included as part of every version of the database - not an additional $ option) - all is Oracle8i, currently available:

1. Java in the database, RMI, CORBA, EJB
2. Java triggers
3. BLOB stored in line
4. BFILE (equivalent to a R/O BLOB stored in the file system externally)
5. Text based indexing of any CHAR, LOB, BFILE file (called intermedia text)
6. iFS: ability to store any document in the file system (version & ACL controlled)
   • iFS parses document going in, renders document coming out in appropriate fmt
   • iFS can make the oracle db look like a Windows disk in Win/Explorer
7. XML support (parsers, XML Schema, XSLT, etc.)

(Oracle9i database is being launched during Oracle Open World in Germany, june 18-21; I expect to see a lot of improvement in the above and a lot of additional features)

Information on all of these features, including Oracle's documentation, sample code, discussion groups, is all available at http://technet.oracle.com

Hope this helps
/Hans

"George I. Develekos" wrote:

> Hi to all,
>
> 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 or
> 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?
>
> Please advise!
>
> Thanks,
>
> G.I.Develekos
Received on Sat Jul 21 2001 - 13:02:07 CDT