Paper “Three Types Of Table Compression”


Download50
Stock
File Size659.15 KB
Create DateApril 17, 2016
Download
There are several different types of compression available in the Oracle database for compressing table data, and so the question must arise: which should be used, and when, for which purpose? This presentation will discuss all the different types of table data compression in Oracle database (i.e. basic/advanced de-duplication compression and hybrid-columnar compression), as well as some older often-forgotten techniques for fitting more data into less space. The presentation will begin with a brief review of data compression in general, followed by a review of the formats used for storage in database blocks and rows, the latter supported by block dumps. All of this will be a prelude for an knowledgeable discussion of the advantages and disadvantages of each type of table compression in Oracle.

This is the white paper to accompany the presentation slidedeck of the same title.

Author: Tim Gorman

Tim Gorman is a technical consultant for Delphix who enable data virtualization and data masking to increase the agility and security of IT development and testing.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.