Contents

Introduction

Key Metrics – What Really Matters

Total Storage Cost

Compression Ratio

Performance

Oracle Database and IBM DB2

The Starting Point – Data Storage Efficiency Before Compression

Compression Algorithm

Index Compression

Compression of Unstructured Data

Network Traffic Compression

Example – Impact on SAP Tables

Oracle Database and Microsoft SQL Server

Oracle Database and Teradata

Number of Values

Creation of Dictionary

Data Type Support

Other Differences

Oracle Database and Hardware Based Compression

Compression Granularity

Read Performance

Need for Decompression

Cascading Benefits

Conclusion

Oracle Whitepapers - Oracle Database Compression: A Competitive Overview Index