Compression Techniques

cdinesh · April 2nd, 2009, 02:52 AM

We are working on a VB.Net solution which will scan critical documents and store the digital version in a SQL Server 2005 database. The format of the documents could be a PDF files or a JPEG. Please suggest good compression techniques for faster storage and retrieval of digital documents.

dparsons · April 2nd, 2009, 08:49 AM

Are you looking for compression technology that will take, say, a jpg and reduce the file size but still keep the file as a jpg or will something like GZip compression work? In the case of the former I am not sure how you would proceed with this, I am sure there is a component out there that provides this type of functionality but you would have to do some searching on google. As far as GZip compression goes, it is really trivial to compress and decompress a file with GZip from .NET. The relevant classes live in System.IO.Compression.

If you want something like TAR or Zip compression you can check out: http://www.icsharpcode.net/OpenSource/SharpZipLib/

hth
-Doug

cdinesh · April 2nd, 2009, 09:05 AM

Thanks. I need to compress and store the compressed format as Binary in SQL Server. Let me try with GZip.