Thursday, 16. October 2014., 16:00
Hall 1 Main
There are several different types of compression available in the Oracle database for compressing table data, and so the question must arise: which are most appropriate, and 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 lecture 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.
Three things that attendees can expect to learn:
1. How Oracle stores data in rows and in database blocks
2. How Oracle compresses table data and how each method of compression works over the lifecycle of the data
3. The advantages and disadvantages of the different types of table compression and the situations in which each works best