Hybrid Columnar Compression

The Oracle corporation announced in October, 2011 that the technology of hybrid columnar compression Hybrid Columnar Compression introduced in Oracle Exadata for the first time is maintained by storage systems now Oracle ZFS Storage Appliance and Pillar Axiom Storage System Software.

Thanks to it the efficiency of the Hybrid Columnar Compression technology providing a compression ratio from 10 to 50 times for the majority of data sets becomes available to customers who apply the NAS and SAN systems of Oracle to data lifecycle management with archiving directly in the database at online transaction processing (in-database archiving for OLTP) and in data warehouses.

In these environments the Hybrid Columnar Compression technology allows to reduce by 3–5 times the volume of storage systems and also energy consumption and operating costs – due to replacement of the competing storage systems with solutions of Oracle.

"Oracle helps customers to use most effectively IT investments at the expense of innovations and integration and, expanding support of Hybrid Columnar Compression technology on the solutions Sun ZFS Storage Appliance and Pillar Axiom, integrates these opportunities, – Phil Bullinger, the senior vice president of Oracle for storage systems told. – Regardless of what architectural strategy you prefer for data warehouses or archives of Oracle databases, the choice is obvious: the most effective option offers Oracle".

For Oracle data warehouse based on the network device NAS or SAN with a capacity of 1 PB Oracle Storage storage system with the Hybrid Columnar Compression technology providing compression in the ratio 16:1 should have the capacity of only 60 TB while the competing system with compression of database 3:1 needs 334 TB formatted capacities at the cost approximately seven times higher, than for a similar storage system of Oracle.

"The Hybrid Columnar Compression technology will provide to users of Oracle Database 11g Release 2 DBMS unique advantages in terms of cost and efficiency of the environment of databases, – Juan Loaiza, the senior vice president of Oracle for the Systems Technologies direction noted. – Now customers can is transparent to implement archiving directly in the database using the solutions Oracle Exadata, NAS or SAN and to achieve the efficiency of data storage leading in the industry".

For storage systems of Sun ZFS Storage Appliance and Pillar Axiom Storage System implemented in the form of updating to Release 2 Oracle Database 11g DBMS it will be possible to get acquainted with Hybrid Columnar Compression technology in operation at the Oracle OpenWorld conference which is taking place in San Francisco from October 2 to October 6, 2011.