in medical transcription domain we are receiving 300 voice file and further we have to maintain transcript ,editing and super editing file for particular voice file.Right now we storing all the in disc mean we are maintain unique folder structure to store.my question is can we use database to store all file as binary data using jdbc blob data type?.which is the right way please suggest me.
Judge a man by his questions rather than his answers --Voltaire
SCJP 1.5 97%
You can use a database. Ultimately this will just store these files on disk too, though in a differernt format. There is an overhead getting BLOBs in and out of a database, but it has the advantage of being a transactional store. The file system is not transactional, so data loss is possible, plus you will have issues with concurrency.
In addition, the file system is not as easy to access from a distributed environment in a platform agnostic way. You can't write to the file system from an EJB for example.
yes. if i use file system i cannot use EJB because we should not perform I/O operation inside EJB.so can use inputstream and outstream object in ejb if i use database to store file?.why i am asking mean if the file may big out of memory exception will occur when using EJB.