Hi,
Basically I have two questions.
I investigate means of implementing WebDAV interface for EMC ATMOS storage. There will be billion(s) of files with thousands simultanous reads and probably hundreds creations/deletions. The problem is with COPY/MOVE/DELETE operations. If the structure is stored in ATMOS (using namespace interface which identifies files by full path), then as far as I see in order to COPY/MOVE/DELETE a folder I need to perform COPY/MOVE/DELETE individually on every file/folder inside it. This can take a long time.
Have someone solved this problem before and how?
One way is to store structure in Oracle cluster and use object interface in ATMOS (which basically identifies files by ID). The table with the structure will look like (ParentItemId, ItemID, Name, Created, Modified) and probably some other fields. There will be billion(or a couple of billions) of records in it. I estimate total size to be about 150GB without indexes. So presumably we will have hundreds simultaneous insertions/deletions in pretty independent areas of the index and thousands simultaneous reads.
I'm not expert in Oracle, so can someone please share experience if this is a viable solution? (I mean will it be possible to have reads/writes to occur in about 0.1s, 1s ?). Does it depend on configuration?
Thanks.