RE: Blob & Ifile
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 May 2004 15:36:38 -0500
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@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hamid Alavi
Sent: Wednesday, May 26, 2004 3:26 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Blob & Ifile
Yes it is , sorry for the typo
-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS@xxxxxxxxxxxxx]
Sent: Wednesday, May 26, 2004 1:12 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Blob & Ifile
Hamid
Isn't this an Oracle BFILE?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
