Release Notes

Executive summary
4 Optimizing Dell EMC SC Series Storage for Oracle OLAP Processing | 2009-M-BP-O
Executive summary
Intelligent choices must be made when selecting the hardware for an environment that will service the needs
of a business and expected data growth. When talking about data warehouses, higher host processing
capabilities coupled with high-performing storage solutions such as Dell EMC™ SC Series arrays deliver the
power and throughput necessary to meet the demands of business intelligence and reporting applications that
provide trend analysis, forecasting, and business analytics.
Typical data warehouse systems move large amounts of sequential data in large multi-block read/write I/O
streams and tend to be very read intensive. The I/O streams can also be 100% read-only during periods of
report generation, but then change to an I/O mix during the extract, transform, and load (ETL) stage. SC
Series arrays are an excellent choice for data warehousing because of the Dell™ Fluid Data™ architecture
that keeps the data as dynamic as the organization it supports by placing the right data in the right place at
the right time, regardless of the I/O mix of the application.
SC Series arrays help resolve many of the storage challenges facing IT organizations by providing many
advanced features typically only found in expensive high-end storage. This paper highlights some of these
features and provides guidance on how they can be leveraged to deliver a cost-effective solution for the
demanding performance requirements of Oracle OLAP and DSS deployments.