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
About speaker
Tim Gorman, author
Tim Gorman has worked in IT on relational databases since 1984, as an Oracle application developer since 1990, and as an Oracle DBA since 1993.
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 @HrOUG_2014Follow 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
