Home > Workload Solutions > SQL Server > Guides > Design Guide—Data Analytics with SQL Server 2022 on Red Hat OpenShift and Dell ObjectScale > Logical architecture
Red Hat OpenShift is the foundation of this solution because one of the major focus areas during the development of this solution was to create a cloud-native data analytics solution that could be location agnostic and provide a consistent user experience across on-premises, public, and hybrid cloud, or edge infrastructure.
In this setup, the Microsoft SQL Server 2022 pod will be scheduled by RHOCP in one of the worker nodes. Apache Spark is also deployed as a pod in RHOCP and used in this solution to convert CSV datasets to delta lake format and to store it in Dell ObjectScale. The PolyBase feature in SQL Server facilitates data virtualization and enables SQL Server instances to query data from Dell ObjectScale storage.
SQL instances use RHODF block storage to store Database files. RHODF delivers persistent block storage for Microsoft SQL Server 2022 and supports database availability requirements. RHODF also provides fault tolerant storage to sustain disk and node level failures.
Dell ObjectScale is a S3 compatible object storage, used in this solution to store and access external delta tables. ObjectScale uses various Erasure Coding (EC) schemes for data protection. EC is a method of data protection in which data is broken into fragments, expanded, and then encoded with redundant data pieces. The data pieces are stored across different locations or storage media. The objective of EC is to enable data that becomes corrupted at some point in the disk storage process to be reconstructed by using information about the data that is stored elsewhere in ObjectScale instance.
MetalLB is a layer 2 load balancer and can be deployed as an Operator in OpenShift, when a service of Type Load Balancer is added to the cluster, MetalLB adds a fault-tolerant external IP address for that service.