UCM and 11g DB SecureFiles

howto:  


David Roe writes HERE about the advantages of tapping the potential of  Oracle's 11g Database SecureFiles capabilities within Universal Content Management.  He's also got some great tips on settig up the SecureFiles system for storing UCM managed files.  Also see Bex's take on UOA and secure files here.


If you're using UCM 10.1.3.3.2 or earlier, you can configure Oracle UCM to leverage SecureFiles technology with the File Store Provider capability.   Remember, File Store Provider is OOTB with Oracle UCM.  It is the rules engine that directs the content bits to their new home.  There can be an entire neighborhood with FSP directing content traffic to their homes, dorms and temporary (cache) locations.  Some content  - especially small file size web content IMHO - should still go into/onto the file system or at least a filesystem based cache.  Fortunately, that's not a problem for FSP. 


Here is a File Store Provider to SecureFiles setup sample (that I've not verified):


1.  On your Content Server instance, install and enable the FileStoreProvider component.
2.  Configure FileStoreProvider to create a JDBC storage rule as desired.
3.  Upon restart of Content Server, FileStoreProvider will create the table to store files.
4.  Log into the database instance for Content Server
5.  Drop the filestorage table created by FileStoreProvider (which uses Basic LOBs)
6.  Recreate the filestorage table to leverage SecureFiles.  Here is a *sample* CREATE script:


CREATE TABLE filestorage (
DID number(38),
DRENDITIONID VARCHAR2(30),
DLASTMODIFIED TIMESTAMP(6),
DFILESIZE NUMBER(38),
DISDELETED VARCHAR2(1),
BFILEDATA BLOB,
CONSTRAINT PK_FILESTORAGE
PRIMARY KEY (DID, DRENDITIONID)) LOB(BFILEDATA) STORE AS SECUREFILE
TABLESPACE <YOUR TABLESPACE NAME>;


7. That's it!



You can leverage other SecureFiles capabilities like compression, deduplication and encryption be setting the appropriate flags in the CREATE TABLE script.  Additional information about SecureFiles technology can be found on OTN HERE.

Comments:

So is there any official oracle documentation on how to get secure files to work? Does oracle really expects its customers to rely on David Roes blog to configure its next generation file storage option?

Posted by Dan on November 10, 2009 at 01:11 AM CST #

Hi Dan Yes there is official, public, Oracle documentation on how to use the database for storing UCM content. The official UCM documentation library is located here: http://download-west.oracle.com/docs/cd/E10316_01/ouc.htm Please find the "File Store Provider Installation and Administration Guide" on that page. This will have all the configuration you need. Cheers!

Posted by billy.cripe on November 11, 2009 at 04:13 AM CST #

Post a Comment:
Comments are closed for this entry.
About

Enterprise 2.0 and Content Management

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today