Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex
Introduction
Solution architecture
Solution components
Phase I: Infrastructure design and deployment
Network design
Phase II: Storage design
Phase III: Oracle 19c database design and deployment
Hadoop cluster design and deployment
Configuring Big Data SQL
Oracle NoSQL design and deployment
Microsoft SQL Server design and deployment
Oracle Gateways design and deployment
Generate and load data
References
Appendix A
Generate and load data
Installing and loading TPCH data using DBGEN
Cleaning the data
Loading TPCH data in Oracle NoSQL
Loading TPCH data in Hadoop
Loading TPCH data into the Oracle database
Loading TPCH Schema on Microsoft SQL Server
Creating Oracle external tables pointing to Oracle NoSQL kvstore
Creating Oracle external tables pointing to HDFS
Accessing Microsoft SQL Server tables using Oracle Gateways
Data virtualization with Big Data SQL