OraFAQ Forum: General » Into the DB or outside it : here is the question !

Home » Other » General » Into the DB or outside it : here is the question !

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Into the DB or outside it : here is the question ! [message #625571]

Fri, 10 October 2014 08:06

Amine
Messages: 376
Registered: March 2010

Senior Member

Hi experts,
Hope you're good.
I want to discuss with you the option of inserting files into the database. There's people who prefer to insert the files (PDF files, images, ...) into the database (into a Blob column of a table). And I am part of them. I think the closest we are to the database the more options we have to deal with the file. In addition, the file is more secured. We can not copy it by a simple Copy-Paste; it's included into a tablespace which is a part of datafiles set.

Other people prefer to not insert the files into the database. They consider that we don't have to full the DB with such objects.

What did you think in both cases ?

Thanks in advance,

Amine

Report message to a moderator

Re: Into the DB or outside it : here is the question ! [message #625577 is a reply to message #625571]

Fri, 10 October 2014 09:41

Michel Cadot
Messages: 68751
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database Concepts
Chapter 19 Concepts for Database Developers
Section Topics for Database Developers
Subsection Unstructured Data
Paragraph Overview of LOBs

Report message to a moderator

Re: Into the DB or outside it : here is the question ! [message #625581 is a reply to message #625571]

Fri, 10 October 2014 10:08

John Watson
Messages: 8970
Registered: January 2010
Location: Global Village

Senior Member

I would always consider storage outside the database on ACFS file systems. ACFS is (since mid-September) licence free and offers excellent capabilities for sharing, fault tolerance, encryption, snapshots, and replication.

Report message to a moderator

Previous Topic:	Webservice
Next Topic:	Looking for software to track DML operations - auditing, controlling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 20:24:06 CDT 2025