Take the 2-minute tour ×

I have interview for an internship with company that wants to implement document management system and they are considering on the first place open source solutions, their top choice being Alfresco, but decision is still not final, part of my work there would be to investigate is Alfresco the best solution.

What I have seen from project description, is that they would implement Alfresco with MySQL database, and not to use DBMS just for document metadata and indexing, but they actually want to store documents inside. By company profile, type of documents would be mostly PDF and .doc, not images.

I have researched a bit, and I have read all the topics here related to storing files into the database, not to duplicate a question. So from what I understand, storing BLOBS is generally not recomendable, and by the profile of the company and their legal obligations with archiving, I see they will have to store larger amount of docs.

I would like to be ready as much as I can for the interview and that is why I would like your opinion on these questions:

  1. What will be your reasons for deciding to store documents into the DBMS, (especially having in mind that you are installing Alfresco, which stores files in the FS)???

  2. Do you have any experiences with storing documents into the MySQL database specifically???

All the help is very much appreciated, I am really excited about interview and really want this internship, so this is one of things i really want to understand before!!

Thank you!!!!

share|improve this question
An internship where you do that much research beforehand for the interview alone so you can set up a DMS for them? Now that must be an attractive employer... I hope it's not unpaid. –  Pekka 웃 Apr 11 '10 at 9:48
(Related) stackoverflow.com/questions/3748/… –  Pekka 웃 Apr 11 '10 at 9:49
(Related) stackoverflow.com/questions/154707/… –  Pekka 웃 Apr 11 '10 at 9:50
Thank you Pekka for the links I am onto them, I see there are many answers. Yeah company is attractive and it is paid fairly, but the most important I really have great interest for this project :) –  Julia Apr 11 '10 at 10:02
add comment

1 Answer

up vote 2 down vote accepted

From my experience with Alfresco, this is going to take a lot of customization of the Alfresco repository. I wouldn't go there myself. But if had to, I would answer your questions like this:

  1. Reasons for storing documents into the DBMS instead of the file could be:

    • use of DBMS backup/security tools to copy/save/backup the documentation around, and this one is probably a good one:
    • access to these documents could be easier from other applications. I mean, if you're rewriting the storage service anyway, then you can rewrite it so that you store some of the metadata in the new database structure too. This would create some redundancy, but it would make the documents accessible from other systems without having to depend on Alfresco.
  2. I have some experience with applications that use DBMS as storage - the application was used to store the incoming invoices, so that those could be approved, disputed or sent for payment or whatever. It had decent LAN performances, but the company had really good bandwidth. On the remote locations, though, it was a bit lagged as the documents were transfered back and forth.

share|improve this answer
Thanks for the reply! So, I started the internship few weeks ago, and from what I see about the company the reason why they want to store the docs in the db is like you said...backups and security, because the company is doing some sensitive financial stuff. And it will be accessed mostly from the LAN within the building. Huh, looking forward to that customization... :/ –  Julia May 22 '10 at 20:07
add comment

Your Answer


