Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: acceptable way to program

Re: acceptable way to program

From: Tom Dyess <tdyess_at_dysr.com>
Date: Fri, 31 Dec 2004 16:14:08 -0500
Message-ID: <IhjBd.5746$6i.1873@bignews6.bellsouth.net>


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 - 15:14:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US