UCM and 11g DB SecureFiles
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.
