使用 Alfresco CMS 时将文档存储到 DBMS 的原因是什么
我面试了一家想要实施文档管理系统的公司的实习生，他们正在考虑首先考虑开源解决方案，他们的首选是 Alfresco，但决定仍然不是最终的，我的工作的一部分是要调查的是露天是最好的解决方案。
我从项目描述中看到的是，他们将使用 MySQL 数据库来实现 Alfresco，而不是仅使用 DBMS 来存储文档元数据和索引，但他们实际上希望将文档存储在其中。根据公司简介，文档类型主要是 PDF 和 .doc，而不是图像。
我进行了一些研究，并且阅读了此处与将文件存储到数据库相关的所有主题，而不是重复问题。因此，据我了解，存储 BLOBS 通常是不推荐的，并且根据公司的概况及其归档的法律义务，我认为他们将不得不存储大量文档。
我希望为面试做好尽可能多的准备，这就是为什么我想了解您对这些问题的意见：
您决定将文档存储到 DBMS 的原因是什么（特别是考虑到这一点）您正在安装 Alfresco，它将文件存储在 FS 中）？？？
您有专门将文档存储到MySQL数据库中的经验吗？？？
非常感谢所有的帮助，我对面试感到非常兴奋，并且非常想要这次实习，所以这是我之前真正想了解的事情之一！
谢谢你！！！！
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:
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)???
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!!!!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
根据我使用 Alfresco 的经验，这需要对 Alfresco 存储库进行大量定制。我自己不会去那里。但如果必须的话，我会这样回答你的问题：
将文档存储到 DBMS 而不是文件中的原因可能是：
这可能是一个不错的：
我对使用 DBMS 作为存储的应用程序有一些经验 - 该应用程序用于存储传入的发票，以便可以批准、争议或发送付款或其他任何内容。
它具有不错的 LAN 性能，但该公司的带宽非常好。不过，在远程位置，由于文档来回传输，它有点滞后。
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:
Reasons for storing documents into the DBMS instead of the file could be:
and this one is probably a good one:
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.