Home > Oracle Advanced Compression
Oracle Advanced Compression:
Reduce Storage, Reduce Costs, Increase Performance
Bill Hodak
Principal Product Manager
2
The following is intended to outline
our general product direction. It is intended for information purposes
only, and may not be incorporated into any contract. It is not a commitment
to deliver any material, code, or functionality, and should not be relied
upon in making purchasing decisions.
The development, release, and timing of any features or functionality
described for Oracle��s products remains at the sole discretion of
Oracle.
3
Agenda
4
Challenges
5
Oracle Advanced Compression Option
Relational Data Compression
Unstructured Data Compression
Backup Data Compression
Network Data Compression
6
Oracle Advanced Compression Option
Relational Data Compression
Unstructured
Data Compression
Backup
Data Compression
Network
Data Compression
7
Table Compression
8
OLTP Table Compression
9
OLTP Table Compression Process
Initially Uncompressed
Block
Compressed Block
Partially Compressed
Block
Compressed Block
Empty
Block
Legend
Header Data
Free Space
Uncompressed Data
Compressed Data
10
Block-Level
Batch Compression
11
OLTP Table Compression
Smith
John
3
Doe
Jane
4
Doe
Jane
2
Doe
John
1
LAST_NAME
FIRST_NAME
ID
Employee Table
Initially Uncompressed
Block
INSERT INTO EMPLOYEE
VALUES (5, ��Jack��, ��Smith��);
COMMIT;
1•John•Doe 2•Jane• Doe 3•John•Smith 4• Jane • Doe
Free Space
Header
12
OLTP Table Compression
Block
John=|Doe=|Jane=|Smith=
Header
Doe
Jane
4
Smith
John
3
Smith
Jack
5
Doe
Jane
2
Doe
John
1
LAST_NAME
FIRST_NAME
ID
Employee Table
1•John•Doe 2•Jane• Doe 3•John•Smith 4• Jane • Doe
Free Space
1•• 2•• 3•• 4 • • 5•Jack•
Free Space
Compressed Block
Local
Symbol Table
13
Table Compression Syntax
OLTP Table Compression Syntax:
CREATE TABLE emp (
emp_id NUMBER
, first_name VARCHAR2(128)
, last_name VARCHAR2(128)
) COMPRESS
FOR OLTP;
Direct Load Compression Syntax (default):
CREATE TABLE emp (
emp_id NUMBER
, first_name VARCHAR2(128)
, last_name VARCHAR2(128)
) COMPRESS
[BASIC];
14
Table Compression Advisor
Estimate Potential
Storage Savings
* http://www.oracle.com/technology/products/database/compression/compression-advisor.html
15
Monitoring Table Compression
16
<Insert Picture
Here>
Table Compression Results
17
Oracle��s Internal E-Business Suite
DB
18
Oracle��s Internal Beehive Email
DB
19
SAP R/3, BW, Leading Global Company
20
Real Networks
21
CERN
22
Oracle Advanced Compression Option
Relational
Data Compression
Unstructured Data Compression
Backup
Data Compression
Network
Data Compression
23
Introduction to SecureFiles
24
SecureFiles Deduplication
Secure Hash
25
SecureFiles Compression
26
SecureFiles Compression Syntax
Compression Syntax
CREATE TABLE t1 (a CLOB)
LOB(a) STORE AS SECUREFILE (
COMPRESS
CACHE
);
Deduplication Syntax
CREATE TABLE t1 (a CLOB)
LOB(a) STORE AS SECUREFILE (
DEDUPLICATE
CACHE
);
27
Oracle Advanced Compression Option
Relational
Data Compression
Unstructured
Data Compression
Backup Data Compression
Network
Data Compression
28
Data Pump Compression
29
Advanced Compression
New in
Oracle Database 11g Release 2
30
Backup Compression Syntax
Data Pump Syntax
PROMPT>
expdp hr DIRECTORY=dpump_dir1 DUMPFILE=hr_comp.dmp COMPRESSION=ALL
FAST RMAN Backup Compression Configuration
RMAN>
configure compression algorithm 'MEDIUM';
RMAN Backup Compression Syntax
RMAN> BACKUP
AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
31
<Insert Picture
Here>
RMAN Compression Results
32
RMAN Compression Overview
33
Backup Compression Results
Backup Size
Comparison
GB
Compression reduced backup
size by 6x
34
Backup Compression
Backup Speed Comparison
Slow I/O (Tape)
Time (Seconds)
11g Compression
is almost 2.5x
faster than 10g
Compression
35
Backup Compression
Backup Speed Comparison
Fast I/O (Disk)
Time (Seconds)
11g Compression
is almost 2.5x
faster than 10g
Compression
36
Oracle Advanced Compression Option
Relational
Data Compression
Unstructured
Data Compression
Backup
Data Compression
Network Data Compression
37
Network Compression
Data Guard
Redo Transport Services
LOG_ARCHIVE_DEST_3='SERVICE=denver SYNC COMPRESSION=ENABLE|[DISABLE]'
38
Redo Transport Compression
Validation performed
by CTC in collaboration with Oracle Japan Grid Center
2X
Compression !
5X
Compression !
http://www.ctc-g.co.jp/en/
39
Summary
40
Open World Sessions
Oracle��s Hybrid Columnar Compression: The Next-Generation Compression Technology [ S311358 ]
Tuesday 13:00 | Moscone
South | Room 102
Oracle Advanced Compression in Oracle Database 11g Release 2: Value/Performance [S307442 ]
Thursday 09:00 | Moscone South | Room 102
Oracle Advanced Compression: Stories from the Most Trusted Source – Customers! [ S311359 ]
Thursday 12:00 | Moscone
South | Room 104
The Oracle Advanced Compression Experience – Hands on Lab [S311813]
Thursday 15:00 | Marriott Hotel | Golden Gate B2
41
For More Information
search.oracle.com
advanced compression
Or
OTN: http://www.oracle.com/technology/products/database/compression/index.html
42
43
44
Real World Table Compression Tests
45
Table Compression Test Results
Storage Utilization
MB
More than 70% Storage Savings
46
Table Compression Test Results
Table Scan Performance
Time
(seconds)
Compression is 2.5x Faster
47
Table Compression Test Results
Index Range Scan Performance
Time
(seconds)
No Performance Impact on
Index Scans
48
Table Compression Test Results
DML Performance
Time (seconds)
Compression
has less than 3% overhead
Note: DML Workload comprises equal number of INSERT, UPDATE and DELETE statements. Performance overhead may be higher for INSERT only or UPDATE only workload
49
<Insert Picture
Here>
Competitive Analysis
50
Competitive Analysis – DB2
- More compression overhead
- Transactional compression
- Minimal compression overhead
- Batched compression
- None
Unstructured data compression and de-duplication
(SecureFiles)
Some decompression overhead
Zero decompression overhead
Table/partition level compression dictionary
Block level compression
- New data may not be compressed / offline rebuild symbol table
- Max 4K values per table
- Adaptive / dynamic compression
- Unlimited compression values
IBM DB2
Oracle
51
Competitive Analysis – DB2
52
Competitive Analysis – Teradata
None
Unstructured data compression and de-duplication
(SecureFiles)
- More compression overhead
- Transactional compression
- Minimal compression overhead
- Batched compression
None
Backup compression
Limited data type support
All data types supported
- Admin must define compression values
- Max 255 compression values
- Dynamic compression values
- Unlimited values
Field level compression
Block level compression
Teradata
Oracle
53
Competitive Analysis –
Hardware Based Compression
Benefits limited to specific hardware
environment
Benefits automatically cascade to all
environments
No memory benefits - data needs to be
decompressed
Improved memory efficiency - data stays
compressed in memory
Data updates are very expensive
Batched algorithm for minimal compression
overhead
Poor read performance – significant
decompression overhead
Improved read performance in several
cases – no decompression overhead
No fine grained compression -compress
at file level
Fine grained compression – compress
at tablespace, table or partition level
Generic compression algorithm -deficient
for databases
Database specific compression algorithm
Hardware Compression
Oracle
54
Competitive Analysis
0
1000
2000
3000
4000
5000
6000
Size, MB
Oracle No
Compress
Competition No
Compress
Oracle
Compress
Competition
Compress
Compression: Oracle
vs Competition
Top 10 Tables in an ERP Application
All Rights Reserved Powered by Free Document Search and Download
Copyright © 2011