CODEWITHSUNDEEP
.netoracle-databasefilesystemsrepository
Ope
Ope

Reputation: 797

Simple Oracle File repository with folder hierarchy

I have an application that stores large amount of files (XML and binary) in folder hierarchies. Currently the main method is storing them in file system or using a legacy CMS, which we want to get rid of.

The CMS supports Oracle and a customer wants to keep the files in Oracle because of enterprise policies (backup etc.)

The question is: Is there a simple implementation of file repository with folder hierarchy for Oracle? What I am looking for is a small .Net component or example code (PL/SQL and/or .Net) that would have the following methods:

I need the implementation in .Net, but if it was just the stored procedures, I could create the .Net calling code. I have pointers to generic articles for creating hierarchies in DB, so if I need to do it from scratch, I know where to start. What I am asking here, is there already an implementation that I could take without doing this from scratch? It seems like such a generic requirement...

If the answer is a CMS, Document management system or such it should be Open Source or at least quite cheap (some hundreds / server) and it should be possible to deploy it XCopy - hopefully only couple of DLL:s. I do not need - or want - a full featured big CMS with dozens of dlls and especially not an msi-installation.

I have tried to google this, but the words "repository", "CMS", "file hierarchy" etc. give so many answers, the searches are pretty much useless.

Thanks, OPe

Upvotes: 0

Views: 288

Answers (1)

Gary Myers
Gary Myers

Reputation: 35401

If you can upgrade to Oracle 11gR2, they've got a whole file system that can just be mounted by a unix client and treated as just another mount point. It even de-duplicates the files for you (ie if the same 100MB file is stored in five directories, the database will just have 100MB for the file and the pointers to it from the directories).

http://www.oracle-base.com/articles/11g/DBFS_11gR2.php

http://ronnyegner.wordpress.com/2009/10/08/the-oracle-database-file-system-dbfs/

http://www.oracle.com/technology/products/database/securefiles/pdf/S311353.pdf

Upvotes: 0

Related Questions