Oracle Berkeley DB 4.0: Developer Workshop R5

The Berkeley DB Developers' Workshop provides the software engineer with a detailed walk-through of Berkeley DB database, from installation, to elementary database operations, to transactional protections. Database opens, database reads and writes, cursor operations, environments, secondary indices, multiple threads of control, and transaction usage, backup, recovery are all described in detail. The goal of the Berkeley DB Developers' Workshop is to introduce the participant to developing applications using Berkeley DB. Enhance your understanding through the quiz questions and hands-on labs on Berkeley DB.

Learn to:

• Install Oracle Berkeley DB
• Administer Oracle Berkeley DB
• Configure Oracle Berkeley DB
• Program Berkeley DB in C

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Audience

• Application Developers
• Developer
• J2EE Developer
• Support Engineer
• Technical Consultant
• Java Developer

Course Topics Introduction to Concepts

• Handles and Objects
• Environments
• Key/Data Pairs
• How BDB Uses Keys
• Cursors and Transactions
• Indexes

Basic API Usage

• Creating and Configuring a Database
• Error Returns
• Inserting/Replacing Records
• Retrieving Records
• Deleting Records
• Key/Data Pair Memory Management
• Aligning Key or Data in Memory
• Partial Key/Data Pairs

Access Methods

• Access Methods: B-Tree and Hash
• Access Methods: Queue and Recno
• Duplicate Records
• Recno-Specific Configuration

Database Management

• Emptying a Database
• Removing a Database
• Renaming a Database
• Verifying a Database

Cursors

• Cursors
• Retrieving the First Record
• Iteration
• Positioning by Key, Data, and Range
• Deleting Data by Using a Cursor
• Updating Data by Using a Cursor

Bulk Retrieval Sequences Environments

• Berkeley DB Environments
• Naming Database Environments
• File Locations
• Underlying Physical Files
• Flags to Enable Subsystems
• Other Common Open Flags
• Database Open in an Environment
• Utilities and Database Environment Statistics

Concurrent Data Store (CDS)

• Concurrent Data Store
• Architecting DS/CDS Applications

Transactional Data Store Part 1: Overview

• Transactions and Transactional Applications
• Transactional APIs
• Anatomy of a Transactional Application
• Create/Open/Recover Environment
• Create/Open Database
• Transaction Operations and Differences
• Transactional Cursors
• Transaction Configuration

Transactions Part 2: Locking and Deadlock

• Locking in Transactions
• Lock-Free Reads: Snapshot Isolation
• Locking Configuration
• Deadlocks
• How BDB Detects Deadlocks
• Applications and Deadlocks
• Application Handling of Deadlocks
• Debugging Application Hangs

Transactions Part 3: Checkpointing, Logging, and Recovery

• Controlling Checkpoints
• Logging Configuration
• Database Backups: Standard and Hot
• Disk I/O Integrity Guarantees
• Recovery
• Kinds of Recovery and Recovery Procedures
• Maintaining a Hot Standby
• Transactional, Single and Multiprocess Applications

Replication by Using the Replication Manager

• Berkeley DB: High Availability
• HA Architecture
• Application Responsibilities
• Synchronous Replication
• Improving HA Performance
• In-Memory Replication
• Using Client-to-Client and Delayed Synchronization
• Building a Replicated Application

Building, Configuring, and Upgrading Berkeley DB

• Building BDB on POSIX Systems
• Configuring and Building for Windows
• Berkeley DB Version Information
• Upgrading for a Patch Release
• Upgrading Nontransactional Applications
• Upgrading Transactional Applications

Indexes

• Secondary Index
• New APIs
• Database Association
• Secondary Database Callback Function
• Database Joins
• Simple Versus Composite Key Values

Utilities

• Utilities
• Dump, Load Utilities
• Verifying a Database
• Statistics Printer

Tips

• Extracting Information
• Debug Logging
• Compile-Time Diagnostics
• Recovering Databases
• Examining Databases
• Overview of db_stat
• Key Log Concepts

SQL Queries Expressed as DB Code

• SQL and Berkeley DB: Similarities and Differences
• Sample Databases
• Mapping SQL into C
• Add a Record (SQL Insert)
• Equality and Inequality Search
• Searching and Sorting on a Secondary Index
• Multiple Qualifiers (Boolean AND)
• Query to Find a Range of Values

Course Objectives

• Install Berkeley DB
• Configure Berkeley DB
• Add, modify, delete records in Berkeley DB
• Program Berkeley DB in C
• Perform Backup and recovery
• Define and describe transactional applications
• Describe transaction configuration
• Define and describe secondary index
• Describe database joins
• Configure the Debug BDB build
• Tune the Berkeley DB