Home > Storage > Unity XT > Virtualization, Cloud & Applications > Dell Unity XT: Oracle Database Best Practices > OLAP or DSS workloads
Unlike an OLTP workload, an online analytic processing (OLAP) or decision support system (DSS) workload typically has a relatively low volume of transactions. Most of the activities involve complex queries and aggregates a large dataset. The volume of data tends to grow steadily over time and is kept available for a longer time. OLAP workloads generally have large sequential reads or writes.
The primary goal of designing a storage system that services this type of workload is to optimize the I/O throughput. The design needs to consider all components in the entire I/O path between the hosts and the drives in the Dell Unity system. For best throughput, consider using:
To meet high throughput requirements, multiple HBAs may be required on the server, the array, or both.