如何在 Oracle 中存储 TIFF 文件? [英] How do I store TIFF files in Oracle?

问题描述

我有一个 ASP.NET 应用程序(vb.net 代码隐藏)，由于它在一个服务器共享中存储 TIFF 文件，因此存在严重的性能问题.现在有超过一百万个 .TIF 文件！该应用程序使用 Oracle 数据库表中的相应行跟踪财产的扫描图像.我们认为最好将图像本身存储在新的 Oracle 表中.如何才能做到这一点?

I have an ASP.NET application (vb.net codebehind) that has serious performance problems because of its storage of TIFF files in one server share. There are over a million .TIF files there now! The application tracks the scanned images of property with a corresponding row in an Oracle database table. We have this idea that it might be better to store the images themselves in a new Oracle table. How can this be done?

我们正在考虑的替代解决方案是按状态将服务器共享拆分为多个文件夹(OH 文件夹、WV 文件夹、VA 文件夹等).从长远来看，数据库选项似乎更有意义，但是我们怎么做呢?TIFF 可以存储在 BLOB 列中，然后使用 .NET 提取回 TIFF 格式吗?有人知道怎么做吗?

The alternative solution we are thinking of is to split up the server share into multiple folders by State (an OH folder, a WV folder, a VA folder, etc.) Seems like the database option might make more sense long-term, but how do we do it? Can a TIFF be stored in a BLOB column and then extracted back into TIFF format using .NET? Anyone know how?

推荐答案

是的，您可以以 Oracle 的 BLOB 数据类型存储 TIFF 文件.

Yes, you can store a TIFF file in Oracle's BLOB data type.

查看此链接以使用 ADO.NET 获取 BLOB 字段内容.

Check out this link to get BLOB field contents with ADO.NET.

这篇关于如何在 Oracle 中存储 TIFF 文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！