The Definitive Guide to Berkley DB XML

Description

The Definitive Guide to Berkeley DB XML covers Sleepycat's Berkeley DB XML, an open source embedded XML database. Berkeley DB XML runs on all major operating systems and has support for the most popular programming languages. The book includes tutorials and complete language references for C++, Java, Perl, Python, and PHP.

Berkeley DB XML has the potential to dramatically simplify the development of your application's data tier. With native XML storage, flexible indexing, and the powerful XQuery query language (think SQL for XML), BDB XML provides everything you need for efficient XML management. Combined with Berkeley DB's transactions, logging, and replication, BDB XML is a powerful document storage solution.

Author Danny Brian presents XML basics from the ground up for XML beginners, and covers database installation and configuration, the core concepts behind Berkeley DB XML, a look at application architecture, demonstrations of simple operations (i.e., text queries) to complex (i.e., set computations) using XQuery and FLWOR expressions, document indexing options, and a thorough look at the database APIs. You'll learn tips and tricks that you can immediately apply to your own applications.

 Table of Contents
* A Quick Look at Berkeley DB XML
* The Power of an Embedded XML Database
* Installation and Configuration
* Getting Started
* Environments, Containers, and Documents
* Indexes
* XQuery with BDB XML
* BDB XML with C++
* BDB XML with Python
* BDB XML with Java
* BDB XML with Perl
* BDB XML with PHP
* Managing Databases

CONTENTS:

CHAPTER 1 A Quick Look at Berkeley DB XML
A Complete Example
Creating and Using a Database
Querying a Database
Creating and Querying a Second Database
Metadata
XQuery
Conclusion

CHAPTER 2 The Power of an Embedded XML Database
Database Servers vs Embedded Databases
Architecture Example
Embedded Databases You Might Know
SQLite
Wordnet
Embedded Databases on the Desktop
XML for Data Exchange
XML for Data Storage
Indexing XML
High-Performance XML Databases
BDB XML for Quality Architecture
Conclusion

CHAPTER 3 Installation and Configuration
BDB XML Packages and Layout
Berkeley DB
Xerces C++
Pathan
XQuery
Berkeley DB XML
Installation
Windows
Unix
Building and Using Individual Packages
Unix Variants
Building Bindings
Conclusion

CHAPTER 4 Getting Started
Core Concepts
The Shell
Shell Options
Creating Containers
Adding and Deleting Documents
Querying Containers
Indexing Containers
Using XQuery
Metadata
Transactions
Conclusion

CHAPTER 5 Environments, Containers, and Documents
Environments
Creating and Opening Environments
Additional Environment Configuration
Containers
Creating and Opening Containers
Container Types
Some Container Operations
Documents
Adding Documents
Retrieving a Document
Replacing Documents
Modifying Documents Programmatically
Deleting Documents
Transactions
Validation
Metadata
Conclusion

CHAPTER 6 Indexes
Creating and Manipulating Indexes
Index Nodes
Index Types
Uniqueness
Path Types
Node Types
Key Types
Syntax Types
Managing Indexes
Adding Indexes
Listing Indexes
Deleting and Replacing Indexes
Default Indexes
Index Strategies
Query Plans
Conclusion

CHAPTER 7 XQuery with BDB XML
Trying XQuery
Sample Data
XPath
Expressions
Sequences
A Complete Example
FLWOR Expressions
for
let
where
order by
return
Data Types
Nodes
Atomic Values
Navigation
Comparisons
User Functions
Modules
Some XQuery Tricks
Iteration vs Filtering
Regular Expressions
Querying for Metadata
Querying Multiple Data Sources
Recursion
Reshaping Results
Utilizing Hierarchy
Ranges
Unions, Intersections, and Differences
Indexes and Queries
Query Plans
Node Names and Wildcards
Queries Against Results
Conclusion

CHAPTER 8 BDB XML with C++
Compiling Applications
Class Organization
Errors and Exception Handling
Opening Environments
XmlManager Class
Instantiating XmlManager Objects
Managing Containers
Loading Documents
Preparing and Executing Queries
Using Query Results
Creating Other Objects
Using XmlContainer
Using XmlDocument
Using XmlModify
Using XmlTransaction
BDB XML Event API
Conclusion

CHAPTER 9 BDB XML with Python
Running Applications
Class Organization
Errors and Exception Handling
Environments
XmlManager
Instantiating XmlManager Objects
Managing Containers
Loading Documents
Preparing and Executing Queries
Using Query Results
Creating Other Objects
Using XmlContainer
Using XmlDocument and XmlModify
Transactions
Conclusion

CHAPTER 10 BDB XML with Java
Running Applications
Class Organization
Errors and Exception Handling
Environments
XmlManager
Instantiating XmlManager Objects
Managing Containers
Loading Documents
Preparing and Executing Queries
Using Query Results
Creating Other Objects
Using XmlContainer
Using XmlDocument and XmlModify
Conclusion

CHAPTER 11 BDB XML with Perl
Running Applications
Class Organization
Errors and Exception Handling
Environments
XmlManager
Instantiating XmlManager Objects
Managing Containers
Loading Documents
Preparing and Executing Queries
Using Query Results
Creating Other Objects
Using XmlContainer
Using XmlDocument
Using XmlModify
Conclusion

CHAPTER 12 BDB XML with PHP
Running Applications
Class Organization
Environments
XmlManager
Instantiating XmlManager Objects
Managing Containers
Loading Documents
Preparing and Executing Queries
Using Query Results
Creating Other Objects
Using XmlContainer
Using XmlDocument
Using XmlModify
Conclusion

CHAPTER 13 Managing Databases
Populating Containers
Dumping Containers
Loading Containers
Managing Logs
Detecting Deadlocks
Checkpointing Transactions
Recovery
Debugging Databases
Backup and Restore
Conclusion

APPENDIX A XML Essentials
It's About the Data
XML Building Blocks
Elements
Attributes
Well-Formedness
CDATA
Relationships
Namespaces
Validation
XML Schemas
XPath: the Gist
Paths
Nodes
Document Object Model (DOM)
XPath: the Details
Contexts
Path Operators
Predicates
Operators
Axes
Functions
XML DOM, Continued
Implementation Considerations
Reading and Writing XML
Other XML Technologies
XSLT
SAX
RPC-XML and SOAP
Conclusion

APPENDIX B BDB XML API Reference
Language Notes
DbEnv
DbXml
XmlContainer
XmlContainerConfig
XmlDocument
XmlDocumentConfig
XmlException
XmlIndexLookup
XmlIndexSpecification
XmlInputStream
XmlManager
XmlManagerConfig
XmlMetaDataIterator
XmlModify
XmlQueryContext
XmlQueryExpression
XmlResults
XmlStatistics
XmlTransaction
XmlUpdateContext
XmlValue

APPENDIX C XQuery Reference
Expressions
Functions
Data Types

INDEX