Thursday 12 May 2016

Oracle Secure Files

Organizations need to efficiently and securely manage all data


Mainstream DBs support LOBs for storing file data inside DB – performance is a concern for many users


Before moving to Unstructured Data and Hadoop we can check how Semi-structured data like LOB are handled in Oracle Database








Conventional LOB are known as Basic File from Oracle 11g onwards


In Oracle 11.1 onwards there are two types of LOB


  • Basic Files
  • Secure Files
The Basic File Lobs' where created for mostly " write once, read many times“ operations and its expensive to handle frequent updates



What is Secure Files


Oracle Secure Files helps in consolidated secure management of Data .
Introduced with Oracle Database 11g Release 1 Similar to Lobs' but much faster with more capabilities


.