Advanced Compression with Database 11g Release 2 helps you manage more data in a cost-effective manner. With data volumes, on average, tripling every two years, Oracle Advanced Compression delivers compression rates of 2-4x across all types of data and applications. Read this white paper to learn more about how Oracle Advanced Compression can help you reduce the disk space and costs of managing large data volumes.
An Oracle White Paper September 2009
Advanced Compression with
Oracle Database 11g Release 2
Oracle White Paper - Advanced Compression with Oracle Database 11g Release 2
Introduction ......................................................................................... 3
Oracle Advanced Compression .......................................................... 3
Compression for Table Data ............................................................... 4
OLTP Table Compression............................................................... 4
Compression for File Data .................................................................. 7
SecureFiles Deduplication .............................................................. 7
SecureFiles Compression ............................................................... 8
Compression for Backup Data ............................................................ 8
Recovery Manager Compression.................................................... 9
Data Pump Compression ................................................................ 9
Compression for Network Traffic....................................................... 10
Conclusion ........................................................................................ 11 Oracle White Paper - Advanced Compression with Oracle Database 11g Release 2
Introduction Enterprises are experiencing an explosion in the volume of data required to effectively run their businesses. This trend in data growth can be attributed to several key factors. Recent changes in the regulatory landscape, such as Sarbanes-Oxley and HIPAA, are contributing to this trend by mandating that enterprises retain large amounts of information for long periods of time. Mass distribution of rich and multimedia content over the Internet, made possible through advancements in broadband technologies, also contribute to the growth in overall data volume. Further fueling the exponential trend in data growth is the advent of Web 2.0, with collaborative applications that encourage enormous amounts of user-generated content. Various estimates indicate that data volume is almost doubling every 2-3 years.
This sudden explosion in data volume presents a daunting management challenge for IT administrators. First and foremost are the spiraling storage costs: even though the cost per MB of storage has been declining dramatically in the last few years, the enormous growth in the volume of data that needs to be retained online makes storage one of the biggest cost elements of most IT budgets. In addition, application scalability and performance must continue to meet the demands of the business - even as data volumes explode.
Oracle Database 11g introduces the Advanced Compression Option to help customers cope with these challenges. Innovations in Oracle compression technologies help customers reduce the resources and costs of managing large data volumes. The introduction of these exciting new technologies comes at an opportune time as terabyte-sized databases, once considered a novelty, are becoming prevalent in enterprise data centers.
Oracle Advanced Compression
The Oracle Database 11g Advanced Compression Option introduces a comprehensive set of compression capabilities to help customers maximize resource utilization and reduce costs. It allows IT administrators to significantly reduce their overall database storage footprint by enabling compression for all types of data - be it relational (table), unstructured (file), or backup data. Although storage cost savings are often seen as the most tangible benefit of compression,
3 Oracle White Paper - Advanced Compression with Oracle Database 11g Release 2
innovative technologies included in the Advanced Compression Option are designed to reduce resource requirements and technology costs for all components of your IT infrastructure, including memory and network bandwidth.
Compression for Table Data
Oracle has been a pioneer in database compression technology. Oracle Database 9i introduced Basic Table Compression several years ago that compressed data that was loaded using bulk load operations. Oracle Database 11g Release 1 introduced a new feature called OLTP Table Compression that allows data to be compressed during all types of data... [download for more]
