Data Center Tech Blog
Prasad Venkatachar

Technical Marketing Manager, SanDisk Enterprise Storage Solutions

Summary: Retaining a strong customer base means listening to trends and making timely decisions. Prasad Venkatachar looks at how flash helps expand business agility for Oracle Data Warehousing

All organizations desire to build a strong, loyal customer base, but only few actually succeed in achieving this. A loyal customer base is the lifeblood of a successful business. Employing the right strategies and swift decision making for customer management is critical. For effective decision making, organizations have to churn through large volumes of data generated by customers who use their systems, social media applications, feedback mechanisms and surveys. These decisions are most effective if they can take place at the same speed as the data is generated, as it helps organizations respond quickly to critical customer requirements or concerns.

Many customer-related business decisions need to be proactively managed, and the data warehouse systems supported to take these business decisions have to be optimally designed to handle and process massive amounts of data at greater speeds to deliver improved customer service in a competitive market.

Expanding Business Agility with Flash Storage

Business Agility Adapt to Market Change

Figure 1: Business Agility Adapt to Market Change

Business agility requires decision making at the speed of an opportunity. Opportunity is in the form of customer interests, trends, likes and dislikes of a product. This information should be captured and analyzed in data warehouse at the same speed as the data gets generated. For example, businesses want to be alerted about and tap into:

  1. A list of customers who might having a problem with products being shipped, and their feedback and/or complaints
  2. A list of customers whose products shipped after the committed date

The emergence of flash storage has provided a momentum for organizations to achieve better business agility. Flash has created a plethora of business benefits that were simply not possible with the performance of traditional hard disk drives.

Recently I wrote about how the speed of operation and low latency of flash storage directly complements Oracle 12c database backup operations. Flash can also deliver a high performance platform for data warehousing that is magnitudes faster when compared to hard disk drives. It thereby helps to process volumes of data in a short amount of time. In this blog post I want to share details on performance benefits of SanDisk® Optimus SSDs and how they can benefit Oracle 12c data warehouse workloads.

Testing SanDisk Optimus SSDs for Oracle Data Warehouse

Our testing configuration consists of a Supermicro server with Red hat 6.5 operating system, Oracle 12cR1 database employed and optimized at all layers (server/storage/OS/database) to setup high performance platform. We ensured that best practices for setting up Oracle 12C database on Red hat 6.5 were implemented. Only database storage is switched between SanDisk SSDs and HDDs and all the other testing configuration settings remained consistent to provide a uniform testing environment.

Figure 2: Oracle 12c Data Warehouse Testing with Optimus SSD vs HDD

Oracle 12c Data Warehouse Testing with Optimus SSD vs HDD

The primary objective of this testing was to identify the advantages associated with deploying SSDs for Oracle database 12c data warehouse workloads. The popular HammerDB tool is used for populating database sizes from 100GB, 300GB to 1TB. Industry standard data warehouse queries ran from HammerDB and then response and performance results were captured for reporting. An upcoming white paper will provide a detailed description of the testing environment setup and configuration.

Using SanDisk Optimus SAS SSDs

Databases such as Oracle provide storage for many of new workloads such as Cloud, Big Data/Analytics, Mobility and Social Media. These applications must deliver optimized performance to support timely business results. SanDisk holds a rich portfolio of solid-state drives (SSDs) that are tailored to meet particular workload needs.

We chose SanDisk Optimus SAS SSDs for our testing as this family of SSDs address a wide range of enterprise storage and server applications, and particularly support high performance for applications and databases, while providing consistent quality of service (QoS).

Their wide range of storage capacities, spanning from 200GB to 4TB (Optimus MAX SSD), enables more flexibility for IT deployments.

Testing Results:

I would like to emphasize few key points based on the test results as you can see in figure 3 (for all the folks interested in our complete analysis please stay tuned for Oracle Data Warehouse white paper)

  1. SanDisk SSDs delivers over 2X performance benefit over HDDs running complex data warehouse queries.
  2. SanDisk SSDs provide 50% faster parallel query performance over HDDs.
  3. SanDisk SSDs offer consistent 50% performance benefit over HDDs as we scaled database size from 100GB to 1TB as shown in figure 4 below.

 

Performance Comparison For Various Database Sizes

Figure 3: Oracle 12c Data Warehouse Testing Results

Data Warehouse Parallel Query Performance

Figure 4: Oracle 12c Data Warehouse Parallel Execution Testing Results

Conclusion

Building a loyal customer base is very essential to businesses and this requires business agility to accommodate the change in customer perceptions, trends and their interests. Organizations are storing high volumes of data in data warehouses. And these warehouse sizes are increasing exponentially.

Our test results showed SanDisk SSDs deliver faster business results. It provides exceptional performance for Oracle Data Warehousing in handling high volumes of data at great speeds. It’s worth noting that the Mean Time Between Failures (MTBF) for the SanDisk Optimus disks is high—2.5 Million Hours MTBF—with a warranty period of five years.

Optimus drives are also protected by SanDisk’s Guardian technology platform, which provides FlashGuard, DataGuard and EverGuard capabilities that increase the durability, recoverability and prevention of data loss and corruption, making sure customers see better ROI on their purchase.

If you’d like to learn more about database administration with SSDs or have questions, contact me at
Prasad.Venkatachar@sandisk.com , or join the conversation on Twitter with @SanDiskDataCtr. I look forward to seeing you at Oracle OpenWorld – see SanDisk’s full list of activities here: sndk.co/OOW2014

Hyperscale Databases: Testing Oracle NoSQL Using SanDisk® CloudSpeed SSDs vs. HDDs

Unlock Opportunity at Oracle OpenWorld - SanDisk® in Booth #1429

subscribe blog