Oracle Berkeley DB XML 2.0: Developer Workshop R3

The Berkeley DB XML Developers' Workshop course provides the software engineer with an introductory walk-through of Berkeley XML DB. The course provides students the ability to install, create, access and administer an embeddable, reliable, high performance data manager for XML data and documents. The Workshop will cover the Berkeley XML DB product reviewing significant components, features and functionality. The Workshop will include application development tips, and performance tuning suggestions.

Learn To:

• Install Oracle Berkeley DB XML
• Use Oracle Berkeley DB XML Shell and API
• Use Oracle Berkeley DB XML Indexes

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

• Developer
• Support Engineer
• Technical Consultant
• Java Developer

Course Topics Introduction

• Berkeley DB XML Overview
• The Storage Advantage
• API Overview and Style
• Container Management, Configuration and Administration
• Putting Documents into a Container
• Document Management
• Transactions
• Exception Handling

The Command-Line Shell Interface

• BDB XML Concepts and the Shell
• Invoking the Shell
• Container Basics: Shell
• Storage Type Comparison
• Node and Document Indexing
• Putting XML Files from Disk
• BDB XML Configurables in the Shell
• Verbose Debug Output

XQuery

• Introduction to XQuery
• When to Use XQuery Instead of SQL
• XQuery Context Nodes
• XPath 2.0 Sampler
• User-Defined Functions

Executing Queries

• Query Execution and Handling
• Results Handling
• Control Over Query Configuration
• Query Parsing and Execution

Namespaces

• Namespaces: Introduction
• Namespace Prefixes
• Mapping Prefixes in the Document
• Three Types of Namespaces
• Introduction to Namespace APIs
• XQuery Namespace API in C++

Metadata

• What Is Metadata?
• Metadata in the DBXML Shell
• DBXML Command to Set Metadata
• Accessing Metadata in Queries
• Metadata: C++ APIs

Modify

• Modifying Documents: Overview
• Order of Presentation
• Moving Nodes
• Map of DBXML Shell to API Calls
• Comparison of DBXML Shell Versus API
• More About Parameters

Indexing

• BDB XML Indexing
• Index Strategies
• Path, Node, and Key Type
• Specifying an Index Strategy
• Improving Indexing by Partitioning
• Query Speed with and without an Index
• Default Indexes
• Using Query Plans

Indexing using BDB XML API

• C++ Indexing Interfaces Overview
• Adding Indexes
• Deleting and Replacing Indexes
• Finding Nodes in an Index
• Iteration over Indexes

Course Objectives

• Explain Container management objects
• Introduce Berkeley DB XML
• Utilize Exception handling
• Use the Berkeley DB XML Shell
• Create and Open Containers
• Gain background information for XQuery and XPath
• Use the Shell to compile and execute queries
• Describe how to set a User-Defined function
• Identify Key Classes necessary to run compile using the Berkeley DB XML API
• Identify Key Classes necessary to run Queries using the Berkeley DB XML API
• Modify XML documents using the shell and API
• Explain the various index types
• Describe and use Namespaces
• Describe and use Prefixes
• Use Namespaces and Prefixes in the Berkeley DB XML Shell and API
• Understand the definition and usage of Metadata