| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Blob & Ifile
Hamid
I have not used a bfile, but in reviewing it I decided there are three alternatives, which I think you are referring to -- blob (store in db), bfile, separate file system storage, just store a link in Oracle.
A lot depends on how large your binary objects are and how they are queried. And whether the objects will be updated by your application.
Blobs have an integrity advantage since they are part of the database, while separately stored objects (whether bfile or just a link) can get out of sync with the database. This means you may have file objects with no database reference, or database records pointing to an object that is not present.
If you use the file system to store the objects, you better have someone that knows how to design the layout so you get good performance.
In theory, with just using links, rather than a large database server you could have a small database server holding just the data about the binary object and some small file servers holding the actual binary objects. The application could read the database record, get the file link, and then request the object from the file system. Depending on your architecture and query pattern, this might spread the server I/O better.
The only situation I can think where bfile might be useful is if you don't want to use a blob, but want the database to be able to pull out the object in a database query. At least that is my understanding from a quick reading of the documentation.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hamid Alavi
Sent: Wednesday, May 26, 2004 3:26 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Blob & Ifile
Yes it is , sorry for the typo
-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
Sent: Wednesday, May 26, 2004 1:12 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Blob & Ifile
Hamid
Isn't this an Oracle BFILE?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hamid Alavi
Sent: Wednesday, May 26, 2004 1:41 PM
To: 'Oracle-L (E-mail)
Subject: Blob & Ifile
List,
Any body have any kind of example or experience with using BLOB outside of the database & using some link or ifile in the table instead of storing BLOB into the table?
Thanks
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |