Course Specifics

Course Outline

Big Data and NoSQL Database Overview

  • Defining Big Data
  • Big Data Evolution
  • Introducing NoSQL Database
  • NoSQL Database versus RDBMS
  • Consideration Points Before Opting for NoSQL Database
  • Oracle Big Data Solution
  • HDFS

Oracle NoSQL Database

  • Defining the Oracle NoSQL Database
  • Key Features and Benefits
  • Supported Data Types
  • How Does the Oracle NoSQL Database Work?
  • Components of the Oracle NoSQL Database
  • Partitions and Key Value Pairs
  • Accessing KVStore
  • Introducing KVLite

Designing a Schema

  • Schema Structure
  • What is a Key Component?
  • Identifying the Major Key
  • Identifying the Minor Key
  • How is a Key Stored in the Oracle NoSQL Database?
  • Design Considerations for Key Components
  • What is a Value Component?
  • Types of Value Component

Consistency

  • Understanding the Write and Read Process
  • Understanding Consistency
  • Default Consistency
  • Applying Consistency
  • Predefined Consistency
  • Time Based Consistency
  • Version Based Consistency

Durability

  • Understanding the Write Process
  • Understanding Durability
  • Default Durability
  • Applying Durability
  • Synchronization Based Durability
  • Acknowledgement Based Durability

Credit Card Application and APIs: Overview

  • Credit card approval application
  • Analyzing the Data
  • Designing the Schema
  • Identifying the Key Structure
  • APIs: Overview

Administration: Overview

  • Tasks of the Administrator
  • KVStore Components: Review
  • Replication Nodes, Shards, and Partitions
  • Balancing a KVStore
  • Security
  • Defining Key Terms (Latency, Throughput, Cache)
  • Steps to Deploy a KVStore (Plan, Install, Configure Installation, Configure KVStore)

Planning the Installation

  • Analyze Workload and Identify Hardware Resources, Install storage nodes, Configure Installation
  • Analysis: Tasks
  • Estimating Record Size
  • Estimating Workload
  • Determining Throughput Requirements
  • Determining Store Configuration
  • Determining Cache Size

Setting-up the Oracle NoSQL Database Nodes

  • Prerequisites Checklist
  • KVHOME and KVROOT
  • Installation Steps
  • Creating Directories
  • Extracting Software
  • Verifying the Installation
  • Steps for Configuring the Installation
  • Using the makebootconfig Utility

Configuring and Deploying the KVStore

  • Configuration Tools
  • Introducing Plans
  • States/Life cycle of a Plan
  • Reviewing and Tracking Plans
  • Introducing the Admin Console
  • Configuring KVStore
  • Creating a Data Center
  • Creating a Storage Pool

Store Parameters

  • Introducing KVStore Parameters
  • Parameters List
  • Viewing Parameters
  • Changing Parameters Using CLI
  • Changing Parameters Using Admin Console
  • Setting Admin Parameters
  • Setting Storage Node Parameters
  • Setting Replication Node Parameters

Optimizing KVStore Performance

  • Factors Affecting KVStore Performance
  • Introducing JE Cache Size
  • Estimating JE Cache Size
  • Setting JE Cache Size
  • Introducing Java Heap Size
  • Optimizing Key Size
  • Logging Garbage Collection Activity

Backup and Recovery

  • Backup Process
  • Introducing Snapshots
  • Using Snapshots (commands to create, remove, list, and remove all)
  • Managing Snapshots
  • Methods to Recover KVStore
  • Recovering KVStore: Using a Load Program
  • Recovering KVStore: Using a Snapshot
  • Updating an Existing Deployment

Troubleshooting

  • Verifying a KVStore
  • Monitoring a KVStore
  • Replacing a Failed Storage Node
  • Fixing Incorrect HA Port Ranges

Accessing the KVStore

  • KVStore Handle
  • Creating a KVStore Handle
  • Using KVStoreFactory Class
  • KVStoreFactory Class Definition
  • Using KVStoreConfig Class
  • KVStoreConfig Class Definition
  • Creating a KVStore Handle: Example
  • View KVStore Parameters' Default Values

Creating Key and Value Components

  • Structure of a Record: Review
  • Creating a Key Component: Overview
  • Creating a Major Key Component
  • Creating a Minor Key Component
  • Creating a Key: Examples
  • Creating Value Components: Overview
  • Creating a Value Component
  • Creating Value Components: Examples

Loading Data into a KVStore

  • The Load Process
  • Creating a Load Program
  • Methods Available to Write Records to KVStore
  • Using the put() Method
  • Reviewing a Sample Load Program
  • Identify the Record Structure of the Sample Data
  • Running the Sample Load Program

Retrieving Data from a KVStore

  • Retrieving Records Methods: Overview
  • Using get()
  • get(): Example
  • Using multiGet()
  • mutiGet(): Example
  • Key Range
  • Creating a Key Range
  • Key Depth

Manipulating Data in a KVStore

  • Methods: Overview
  • putIfAbsent(): Use Case
  • Performing a Create Operation
  • putIfPresent(): Use Case
  • Performing an Update Operation
  • Deleting a Single Record
  • Deleting a Single Record: Example
  • Deleting Multiple Records

Handling Exceptions

  • Understanding Exceptions
  • Oracle NoSQL Database Exceptions
  • RequestTimeout Exception
  • Methods that Throw RequestTimeout Exception
  • Handling RequestTimeout Exception
  • RequestLimit Exception
  • Methods that Throw RequestLimit Exception
  • Handling RequestLimit Exception

Configuring Consistency

  • Consistency: Review
  • Viewing the Default Consistency
  • Using Pre-defined Consistencies
  • Over-riding the Default Consistency
  • Changing the Default Consistency
  • Creating Time Based Consistency
  • Creating Version Based Consistency

Configuring Consistency and Durability

  • Durability: Review
  • Viewing the Default Durability
  • Setting Synchronization-based Durability
  • Creating a New Durability Policy
  • Transactional Operation
  • Executing a Transactional Operation
  • OperationFactory: Methods
  • Handling Exceptions

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Scheduled Dates

  • Location
    Cost
    Duration
    Start Date
     
Virtual Class
  • Virtual Class
    1980
    4
    27 Jan 15
  • Virtual Class
    1980
    4
    27 Jan 15
  • Virtual Class
    2460
    4
    27 Jan 15
  • Virtual Class
    2460
    4
    27 Jan 15
  • Virtual Class
    495
    1
    02 Feb 15
  • Virtual Class
    495
    1
    02 Feb 15
  • Virtual Class
    615
    1
    02 Feb 15
  • Virtual Class
    615
    1
    02 Feb 15
  • Virtual Class
    1980
    4
    03 Feb 15
  • Virtual Class
    1980
    4
    03 Feb 15
  • Virtual Class
    2460
    4
    03 Feb 15
  • Virtual Class
    2460
    4
    03 Feb 15
  • Virtual Class
    1980
    4
    05 May 15
  • Virtual Class
    1980
    4
    05 May 15
  • Virtual Class
    2460
    4
    05 May 15
  • Virtual Class
    2460
    4
    05 May 15
  • Virtual Class
    495
    1
    08 Jun 15
  • Virtual Class
    495
    1
    08 Jun 15
  • Virtual Class
    615
    1
    08 Jun 15
  • Virtual Class
    615
    1
    08 Jun 15

Quick Links