Three Types Of Table Compression (Part 1)

Track

-

Date and time

Thursday, 16. October 2014., 16:00

Room

Hall 1 Main

Duration

60'

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

Lecture details

Type: Workshop
Level of difficulty: Expert
Experience Level: Advanced
Desirable listeners function: Developers , End user , System Analist , Designer
Group of activity: DBA

About speaker

HrOUG.hr

The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.

Follow us on Twitter

Keep yourself up to date with all updates!

Follow us on Facebook

Connect 360

Povežite se putem novog servisa za umrežavanje i upoznajte nove poslovne kontakte!

Partners

Big Sponsors

Silver Sponsors

Bronze Sponsors

Media Partner

Media Sponsors