This section describes how we configured Oracle Big Data SQL to access ONDB, Cloudera Hadoop, and Microsoft SQL Server. For information about the installation steps for these data management systems and how data was loaded, see the Oracle Big Data SQL on PowerFlex Design Guide.

After the Oracle Big Data SQL platform was running, we populated the data sources with data from the TPC-H benchmark data generation tool. The TPC-H benchmark models a decision support workload characterized by long running ad hoc queries using data selected from mixture of large and medium-sized tables. We used a scale factor of 3,000 with the dbgen toolkit to generate approximately 3.5 TB of data across eight tables. The following table shows placement of the tables across the data management applications, table name, approximate data size, and indicates the size of the table:

Table 12.           Decision support tables across data sources