Reduce Storage Usage With Advanced Compression Techniques
Sign in

Reduce storage usage with Advanced Compression techniques

Sr IT Operation Lead Technical
Oracle Database 11g provides advanced compression techniques to further reduce storage requirements. Using Oracle Advanced Compression, an option to Oracle Database 11g, all data in a table can be compressed using a continuous table compression capability that achieves a 2-4 times compression ratio with little performance impact on OLTP or Data Warehousing workloads. This compression technology replaces duplicate values in a table with a single value, and continuously adapts to data changes over time, so compression ratios are always maintained. Assuming a model where 5% of the data in a system is active, with the remaining 95% historical, a 10:1 reduction in storage costs can be realized with the partitioning and compression capabilities in Oracle Database 11g Release 2, resulting in substantially reduced need for future storage purchases, and with the same or even increased performance of the applications. In addition, the savings cascade through the enterprise, as backups and copies of the databases also use less storage.

 

With Oracle Database 11g Release 2, the Exadata Storage Servers in the Sun Oracle  database Machine also enable new hybrid columnar compression technology that provides up to a 10 times compression ratio, with corresponding improvements in query performance. And, for pure historical data, a new archival level of hybrid columnar compression can be used that provides up to 50 times compression ratios.

start_blog_img