图像数据库VS文件系统 [英] Images in database vs file system

查看:227
本文介绍了图像数据库VS文件系统的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我们已经来了,我们将建立一个整个后端的CMS系统,将我们整个外网和内网供电与一个包的项目。这个问题我一直在试图寻找一个答案是,这是更好?存储图像的数据库(SQL Server 2005),所以我们可以有诚信,单个复制计划等或存放在文件系统上。

We have a project coming up where we will be building a whole backend CMS system that will power our entire extranet and intranet with one package. The question I have been trying to find an answer to is which is better: storing images in the database (SQL Server 2005) so we may have integrity, single replication plan, etc OR storing on the file system?

一个问题,我们有是,我们有多个服务器负载均衡,需要有在任何时候都相同的数据。截至目前,我们有SQL复制照顾这一点,但文件复制似乎有点艰难。我们有另一个问题是,我们希望有相同图像的多个决议,我们不知道,如果创建和存储在文件系统上的每个版本将是最好的或者动态地拉动和创造,我们想要求的分辨率的图像。

One issue we have is that we have multiple servers load balanced that require to have the same data at all times. As of now we have SQL replication taking care of that but file replication seems to be a little tougher. Another concern we have is that we would like to have multiple resolutions of the same image, we are not sure if creating and storing each version on the file system would be best or maybe dynamically pulling and creating the resolution image we would like upon request.

我们的担忧是有以下几点:

Our concerns are the with the following:


  • 数据完整性

  • 数据复制

  • 多种分辨率

  • 数据库的速度VS文件系统

  • 数据库的开销负载VS文件系统

  • 数据管理和备份

有没有人有类似的情况或者有什么会建议任何输入?在此先感谢您的帮助!

Does anyone have a similar situation or have any input on what would be recommended? Thanks in advance for the help!

推荐答案

有由Microsoft Research发布的一个很好的研究论文叫做的为BLOB或不BLOB 他们看着各种各样的变数和影响。

There was a nice research paper published by Microsoft Research called To Blob or not to Blob where they looked at all sorts of variables and impacts.

他们最终发现:


  • 高达256 KB的大小,斑点被存储在数据库中的效率比在文件系统

  • 1 MB的和较大时,文件系统是更有效的

  • 在这之间是一个胜负难料

由于该论文发表后,SQL Server 2008中还增加了FILESTREAM属性,这使得存储在文件系统中的东西,但事务性控制下,成为现实。强烈建议你检查出来!

Since that paper was published, SQL Server 2008 has also added the FILESTREAM attribute which makes storing stuff in the file system, but under transactional control, a reality. Highly recommended you check that out!

这篇关于图像数据库VS文件系统的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆