Simple Oracle File repository with folder hierarchy
- by Ope
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:
Create, Delete, Exists Folder
CRUD file
Move and potentially Copy file or directory
Access to files and folders with paths like "/root/folder1/folder2/file.xml"
Ability to get all the files and folders in a folder and potentially also the entire directory tree
Tree traversal, getting the parent, all children etc. needs to be fast.
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