X

Learn how businesses like yours can begin to optimize for today and plan for tomorrow with Cloud-Ready IT Infrastructure

Store 10x More Data with Exadata Hybrid Columnar Compression

Maywun Wong
Director, Product Marketing

With the pictures, texts, videos, messages, memes, and more, consumers are consuming more data than ever before.  IDC confirms that there will be a 10-fold rise in worldwide data by 2025, and the “meteoric rise of data will provide immeasurable opportunities for companies to gain advantage in the market.”  In order to take advantage of these opportunities, how can companies like yours best manage all of that data? 

Exadata is the answer.  Among many of the great capabilities in Exadata is the ability to store and access 10 times more data than before with Exadata Hybrid Columnar Compression (HCC)!

Before we talk about how HCC works, let’s take a step back and review how data was stored before HCC was implemented. Before Hybrid Columnar Compression, data was stored in Row or Columnar format with limited storage savings when the database was compressed.

However, storing data in rows and columns format only limits the amount of storage savings achieved and could negatively impact database performance. 

In contrast, Oracle’s HCC technology organizes data by combining row and columnar methods for storing data.  The database compression gets the benefits of columnar storage, and avoids performance shortcomings.

The compression unit stores a set of hybrid columnar compressed rows. When data is loaded, column values for a set of rows are grouped together and compressed. After the column data for a set of rows has been compressed, it is stored in a compression unit.

Now Exadata can save on cache space and reduces input/output requests, resulting in improved performance.   That means you can keep more data in Exadata smart Flash Cache.

For the data that is not needed as frequently, data warehouses can store significant amounts of data for your company.  Exadata's warehouse compression provides significant storage savings with a 10:1 compression ratio, 5x above the industry average! 

Finally, to maximize storage savings, Exadata HCC has the Smart Scan technology, which reduces the amount of data sent from storage to the database server.  It offloads much of the scan activities to the Exadata storage. With the improved Scan technology and Warehouse Compression, you need less storage required and eliminate the need to increase the number of disk drives and related hardware to meet performance objectives.

One question that comes up often is about managing historical data.  Exadata includes Archive Compression which provides significant storage savings with HCC technology.  Archive Compression is optimized to maximize storage savings, typically achieving a compression ratio of 15:1.

With the exploding data volume growth, IT Managers must efficiently manage their data storage and access methods.  Exadata's HCC provides a robust set of compression features while reducing infrastructure costs and improving application performance.  With Hybrid Columnar Compression on Exadata, you'll get the highest levels of data compression, significant cost savings, and strong performance improvements for your data.

Want to learn more?  Check out the Exadata page for more information about Exadata’s capabilities or chat with a specialist for more technical questions.

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.