Oracle Hybrid Columnar Compression Support for ZFS Storage Appliances and Pillar

Oracle Corp. announced Hybrid Columnar Compression, pioneered in Oracle Exadata, is now supported on Oracle’s Sun ZFS Storage appliances and Pillar Axiom Storage Systems.

                               Hybrid Columnar Comparisons

With this announcement, Oracle is bringing the storage efficiency of Hybrid Columnar Compression to customers using Oracle’s NAS and SAN systems to manage the lifecycle of data using in-database archiving for OLTP databases and data warehouses, with 10x to 50x compression for most datasets.

Using Hybrid Columnar Compression in these environments, customers can achieve 3x to 5x reductions in their storage footprints, energy usage and cost by replacing existing EMC Corp‘s and NetApp Inc.‘s SAN and NAS storage with Oracle storage solutions.

For a 1PB Oracle data warehouse with networked storage, NAS or SAN, Oracle Storage with Hybrid Columnar Compression delivering 16:1 compression would require only 60TB of capacity while an EMC VNX 5700 with 3:1 database compression would require 334TB of usable capacity and cost over $800,000 – more than 7 times the equivalent Oracle storage system.

Hybrid Columnar Compression for Sun ZFS Storage appliances and Pillar Axiom Storage Systems is enabled in an update to Oracle Database 11g Release 2 that was released and demonstrated at Oracle OpenWorld in San Francisco, October 2-6, 2011.

"Oracle helps maximize our customers’ IT investments through innovation and integration, and the extension of Hybrid Columnar Compression support to our Sun ZFS Storage appliance and Pillar Axiom NAS and SAN solutions combines both of these efforts," said Phil Bullinger, senior vice president of storage, Oracle. "The choice is clear, no matter what architectural strategy you use for your Oracle data warehouses or database archives, the most efficient choice for storage also comes from Oracle."

"Hybrid Columnar Compression gives our Oracle Database 11g Release 2 customers unique cost and efficiency advantages in their database environments," said Juan Loaiza, senior vice president of Systems Technologies, Oracle. "Customers can now implement transparent in-database archiving using Oracle’s Exadata, NAS, or SAN storage and achieve industry leading storage efficiencies."