Oracle Berkeley DB Administration: Operations, Troubleshooting, Problem Management
Course duration
4 Days
Course outline
Module 1 Introduction to Berkeley DB
- Berkeley DB Concepts
- Environments
- Key-Data Pairs
- Storing Data
- Duplicate Data
- Replacing and Deleting Entries
- Secondary Keys
- Access Methods
- Selecting Access Methods
- Choosing between BTree and Hash
- Choosing between Queue and Recno
- Database Limits and Portability
- Exception Handling
- Error Returns
- Getting and Using DB
Module 2 Database Environments
- Opening Database Environments
- Closing Database Environments
- Environment Properties
- Opening Databases
- Closing Databases
- Database Properties
- Administrative Methods
- Error Reporting Functions
- Managing Databases in Environments
Module 3 The Direct Persistence Layer
- Direct Persistence Layer First Steps
- Entity Stores
- Opening and Closing Environments and Stores
- Persistent Objects
- Saving and Retrieving Data
Module 4 Working with Indices
- Accessing Indexes
- Accessing Primary Indices
- Accessing Secondary Indices
- Creating Indexes
- Declaring a Primary Indexes
- Declaring Secondary Indexes
- Foreign Key Constraints
Module 5 Saving and Retrieving Objects
- A Simple Entity Class
- Placing Objects in an Entity Store
- Retrieving Objects from an Entity Store
- Retrieving Multiple Objects
- Cursor Initialization
- Working with Duplicate Keys
- Key Ranges
- Join Cursors
- Deleting Entity Objects
- Replacing Entity Objects
Module 6 Database Records
- Using Database Records
- Reading and Writing Database Records
- Writing Records to the Database
- Getting Records from the Database
- Deleting Records
- Data Persistence
- Using the BIND APIs
- Numerical and String Objects
- Serializable Complex Objects
- Custom Tuple Bindings
Module 7 Using Cursors
- Opening and Closing Cursors
- Getting Records Using the Cursor
- Searching for Records
- Working with Duplicate Records
- Putting Records Using Cursors
- Deleting Records Using Cursors
- Replacing Records Using Cursors
Module 8 Database Configuration
- Setting the Page Size
- Overflow Pages
- Locking
- IO Efficiency
- Page Sizing Advice
- Selecting the Cache Size
- BTree Configuration
- Allowing Duplicate Records
- Setting Comparison Functions
Module 9 Transactions Introduction
- Transaction Benefits
- A Note on System Failure
- Application Requirements
- Multi-threaded and Multi-process Applications
- Recoverability
- Performance Tuning
Module 10 Enabling Transactions
- Environments
- File Naming
- Error Support
- Shared Memory Regions
- Security Considerations
- Opening a Transactional Environment and Store or Database
Module 11 Transaction Basics
- Committing a Transaction
- Non-Durable Transactions
- Aborting a Transaction
- Auto Commit
- Nested Transactions
- Transactional Cursors
- Using Transactional DPL Cursors
- Secondary Indices with Transaction Applications
- Configuring the Transaction Subsystem
