Hybrid Columnar Compression (HCC)

Oracle has introduced a new data storage technology in Exadata V2 called Hybrid Columnar Compression. This method uses a “compression unit” that is made of several rows; it is physically stored in compressed “column vectors” in multiple blocks of storage.

There are two flavors of columnar compression that are optimized for “QUERY” (warehouse compression better for executing queries) and “ARCHIVE” (best data storage for archive compression)

Each of the QUERY and ARCHIVE come with another modifier to set the “LOW” or “HIGH” compression mode.

This technical white paper gives an overview of the new technology.

This article on Oracle Magazine may also be useful in understanding this new feature.

More data can be stored in “less” space. Good!

Advertisements

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


%d bloggers like this: