Re: acceptable way to program

Yes, I would agree with the relational database. ORDB are mainly hype and usually promoted by coders that have never had to write a report or mine data effectively.

The next question would be where to store the images. BLOB or files. Both approaches have their downfalls.

BLOBS are good because you have a centralized location for all your data (Oracle DB) but that problem is your exports will quickly get huge and will become a DBA nightmare (having to export a table at a time).

Keeping your files on the filesystem requires two storage mechanisms, the DB and the filesystem. It's additional overhead to backup the files every night, but overall, this is the approach with the least hastle overall.

"thufir" <thufir.hawat_at_mail.com> wrote in message news:1104486694.500378.197850_at_z14g2000cwz.googlegroups.com...
> <http://directory.google.com/Top/Computers/Programming/Languages/Java/Databases_and_Persistence/Database_Management_Systems_-_DBMS/Object-Relational/>
>
> <http://objectstyle.org/cayenne/>
>
> <http://www-306.ibm.com/software/data/cloudscape/>
>
> <http://www.hibernate.org/>
>
> in no particular order :)
>
> note that the term "object-relational mapping" is what you're after,
> probably.
>
> --Thufir
>
Received on Fri Dec 31 2004 - 22:14:08 CET