Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex

• 1
  Business case
• 2
  Dell EMC PowerFlex
• 3
  Oracle Big Data SQL
• 4
  Document purpose
• 5
  Audience
• 6
  Deployment workflow
• 7
  We value your feedback

• 1
  Overview
• 2
  Logical architecture

• 1
  Hardware components
• 2
  Data center requirements

• 1
  Phase I: Infrastructure design and deployment
• 2
  PowerFlex Hardware components
• 3
  PowerFlex software components
• 4
  Flexible deployment options
• 5
  Deploying the PowerFlex hyperconverged infrastructure
• 6
  Configuring ESXi hosts
• 7
  Creating the VMs

• 1
  Overview
• 2
  VM networking
• 3
  Network design

• 1
  Phase II: Storage design
• 2
  Database application storage design
• 3
  VM operating system data store and hard disks design
• 4
  For VM hosting Oracle: Operating system devices and Oracle ASM disk group design

• 1
  Phase III: Oracle 19c database design and deployment
• 2
  Deploying an Oracle 19c Standalone Server with Oracle Linux 7.6 on vSphere 7
• 3
  Creating the Oracle 19c Standalone PROD database

• 1
  Introduction
• 2
  Configuring the Cloudera Manager Server
• 3
  Configuring Cloudera Hadoop from Cloudera Manager Server

• 1
  Introduction
• 2
  Configuring Big Data SQL on Hadoop clusters
• 3
  Configuring Big Data SQL on the Oracle Database host

• 1
  Introduction
• 2
  Configuring Oracle NOSQL

• 1
  Microsoft SQL Server design and deployment
• 2
  Microsoft SQL Server database layer best practices

• 1
  Oracle Gateways design and deployment

• 1
  Generate and load data
• 2
  Installing and loading TPCH data using DBGEN
• 3
  Cleaning the data
• 4
  Loading TPCH data in Oracle NoSQL
• 5
  Loading TPCH data in Hadoop
• 6
  Loading TPCH data into the Oracle database
• 7
  Loading TPCH Schema on Microsoft SQL Server
• 8
  Creating Oracle external tables pointing to Oracle NoSQL kvstore
• 9
  Creating Oracle external tables pointing to HDFS
• 10
  Accessing Microsoft SQL Server tables using Oracle Gateways
• 11
  Data virtualization with Big Data SQL

• 1
  Dell Technologies documentation
• 2
  VMware documentation
• 3
  Oracle documentation
• 4
  Cloudera documentation

• 1
  Appendix A
• 2
  Linux kernel parameters for the Oracle database
• 3
  Initialization parameter settings for the Oracle database