Thursday TechTips: Hadoop 1.01 and Compression Codecs

I have been playing around with the compression codecs with Hadoop 1.01 over the last few months and wanted to provide quick tech tips on compression codecs and Hadoop.  The key piece of advice is for you to get Tom White’s (@tom_e_white) Hadoop: The Definitive Guide.  It is easily the must-have guide for Hadoop novices to experts. The key fundamentals concerning compression codecs is that not all codecs are immediately available within Hadoop. Some of them are native to Hadoop (one needs to remember to compile the native libraries) while others need to be extracted for their source and compiled…

Rate this:

Procedure used for applying Database Compression

A very handy SQL Server 2008 data compression procedure was posted by my collegue Juergen Thomas with his extensive background in SAP.  He propped up an excellent blog post about data compression at: Procedure used for applying Database Compression to Microsoft SAP ERP system. What is interesting here is that he had created a procedure that would go through and compress all of the tables and indexes within your database using various options (online, batch, schemas, etc.) so that way you didn’t have to write your own statements to individually go through each table and compress them yourselves.  It’s a…

Rate this: