Release Notes
Optimize an SC Series array for an Oracle data warehouse
13 Optimizing Dell EMC SC Series Storage for Oracle OLAP Processing | 2009-M-BP-O
Table 1 shows an example of a simple two-tier SC Series storage configuration for a data warehouse. The
capacity tier is ideal for storing a large amount of historical data while the high performance tier is great for
handling the occasional transactions and queries.
A two-tier SC Series storage configuration
Tier type
Storage tier/RAID level
Media
High Performance Tier
T1/R10
T1/R5 or R6
SSDs
Large Capacity Tier
T3/R10
T3/R5 or R6
15K, 10K, or 7K HDDs
Note: The document Understanding RAID with Dell SC Series Storage provides insights on how Dell EMC
implements different RAIDs and storage tiers in an SC Series array.
3.4.2 Dynamic data placement with storage profiles
It is important to understand the different types of data stored in a typical data warehouse and how these data
are used. A typical data warehouse stores three types of data:
• Historical data
o Requires a large amount of storage and long retention time
o Constantly grows over time
o Data is fairly static
o Is read to generate summarized or calculated data
o Updates or new data are added through batch jobs
• Summarized or calculated data
o New data is created by the Extract, Transform, and Load (ETL) process
o Reports are generated by on-demand or scheduled queries
o Data gets refreshed periodically
o Typical reporting and user query response time ranges from several seconds to minutes
• Metadata
o Provides information about other data and schema objects within a database
o Is used by applications to locate and compute data correctly
o Is fairly static until refresh
Data stored in an SC Series array is not permanently tied to a specific storage tier, type, or RAID level. Each
volume has a selected storage profile. The profile dictates which storage tier accepts initial writes and how
Data Progression moves data between tiers and RAID levels to balance performance and storage efficiency.
Note: Storage profiles are predefined based on the available drive types in the array. It is important to review
the storage profiles information in appendix A and in the Dell Storage Manager Administrator’s Guide.