Detailed Course Outline
Oracle NoSQL Database: Overview
- Course Objectives
- Key Features
- Benefits of Using Oracle NoSQL Database
- Supported Data Types
- How Does the Oracle NoSQL Database Work?
- Oracle NoSQL Database Components
- Partitions and Key Value Pairs
- Performance and Throughput
Planning An Installation
- KVStore Analysis: Tasks
- Understanding Storage Capacity and Throughput Capacity
- Using InitialCapacityPlanning Spreadsheet
- Application Requirements
- Hardware Requirements
- Performance Requirements: Estimating Workload
- Performance Requirements: Estimating Throughput
- Configuration Requirements
Deploying a KVStore
- Creating Directories
- Extracting Software
- Verifying the Installation
- Configuring the Replication Nodes
- Using the makebootconfig Utility
- Starting the Admin CLI
- Configuring KVStore
- Creating a Data Center/Zone
Modifying a KVStore
- Reasons to modify a cluster
- Increasing a clusters capacity
- Increasing a clusters replication factor
- Steps to modify a cluster
Securing the Configuration
- Security Overview
- Performing a secure installation using makebootconfig
- Secure an existing installation using securityconfig
- Security.xml Parameters
- Encrypting Data
- Configuring Authentication
- Default Security Policies
- Security Guidelines
Disaster Recovery
- Fixing Hardware Failures
- Verifying a KVStore
- Verify Command
- Hardware Failures: Overview
- Network Failure
- Recovering from Network Failure
- Detecting Storage Device Failures
- Replacing a Failed Storage Device
Monitoring a KVStore
- Introducing KVStore Parameters
- Changing Parameters Using CLI
- Changing Parameters Using Admin Console
- Setting Replication Node Policy
- Best Practice: Set Optimal JE Cache Size
- Best Practice: JVM
- Best Practice: Set Optimal Java Heap Size
- General Monitoring
Managing a KVStore
- Backup Process
- Using Snapshots
- Recovery Process
- Using a Load Program
- Upgrading the Software
Schema Design
- Importance of Schema Design
- Schema Design Options in ONDB
- Key-Value Data Model
- Table Data Model: Overview
- Designing Parent Tables
- Table Field Data Types
- Keys and Indexes for Table Data Model
- Defining Child Tables
Application Specific Requirements
- Understanding the Write and Read Process
- Consistency Policy: Definition
- Applying Consistency
- Default Consistency
- Types of Consistency Polices
- Predefined Consistency Policies
- Time-based Consistency Policy
- Version-based Consistency Policy
Creating Tables
- Creating Tables: Overview
- Data Definition Language Commands
- Using Create Table
- Using Check Constraint
- Creating a Table from Java Application
- Introducing TableAPI
- Executing a DDL Command
- Creating a Table from CLI
Writing Data To Tables
- Using the TableAPI
- TableAPI Methods for Write Operations
- Writing Rows to Tables: Steps
- Constructing Handles
- Creating Row Object, Adding Fields, and Writing Records
- Write Method Definitions
- Creating the Row Object
- Using the Row Object
Retrieving Table Data
- Reading a Table: Overview
- Retrieving Table Data
- Retrieving Single Row
- Retrieving Multiple Rows
- Retrieving Child Tables
- Iterating A Table
- Using MultiRowOptions
- Specifying Ranges
Manipulating Data Stored in Key-Value Model
- Structure of a Record: Review
- Creating a Key Component: Overview
- Creating Key Components
- Creating a Value Component: Overview
- Creating a Value
- Retrieving Records: Overview
- Writing Key-Value Pair to KVStore
- Deleting Records
Configuring Consistency
- Consistency: Review
- Viewing the Default Consistency
- Creating Consistency Policies: Overview
- Using a Pre-defined Consistency
- Creating a Time Based Consistency
- Creating a Version Based Consistency
- Changing a Default Consistency
Configuring Durability
- Durability: Review
- Viewing Default Durability
- Creating Durability Policies: Overview
- Setting a Synchronization-based Durability Policy
- Setting an Acknowledgement-based Durability Policy
- Creating a New Durability Policy
- Changing the Default Durability
Creating Transactions
- What is a Transactional Operation?
- Points to Remember
- Process
- TableOperationFactory: Methods
- Executing Operation Syntax
Handling Large Objects
- Introducing Large Objects
- Oracle NoSQL APIs for Large Objects
- Large Objects Storage
- Creating Large Object Keys
- Creating Key for Table API Users
- Storing Large Objects: API Overview
- Retrieve Large Objects: API Overview
- Deleting Large Objects: API Overview
Accessing a Secure Store
- Secure KVStore: Overview
- Security Features
- Obtaining a Handle to Secure Store
- Security Parameters
- Specifying Security Properties
- Security Constants
Handling Exceptions
- Understanding Exceptions
- Oracle NoSQL Database Exceptions
- Handling RequestTimeoutException
- Methods that Throw RequestTimeoutException
- RequestLimitException
- RequestLimitConfig
- FaultException
- ContingencyException