ODC Appreciation Day : HCC compression

When struggling to store your data…

Advertisements

overloaded-vehicles-emgn10

My last minute addition to ODC Appreciation Day – oldie but goodie – Hybrid Columnar Compression. A real game changer when it comes to Data Warehouse systems, allowed us to pack up many times (like > 10x) more data in the same space at the expense of some CPU load. With 4 different levels you can choose how much exactly do you want to trade off the resources. And together with ZFS storage no extra licensing is needed – really best bang for the buck possible.

Looking back I believe it was really the best feature we could have for DWH business…

Author: pewu78

A long time DBA, in a galaxy far far away...

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s