Ronald Bourret, rpbourret.com
Date: Thursday, July 25
Time: 2:30pm - 3:15pm
Location: Marina II
One of the most common uses of XML is as a transport for data stored in relational databases. XML-DBMS is middleware for transferring data between XML documents and relational databases. It can be used programmatically or from the command line and is available in both Java and PERL.
This presentation will start with a discussion of the object-relational model behind XML-DBMS, including how this handles mixed content. It then discusses the XML-DBMS mapping language, which allows users to map XML schema to relational schema. The language also includes support for simple transformations, formatting routines, key generation routines, heterogeneous joins, multi-valued properties, and casting of element types.
The presentation concludes with a discussion of how to use XML-DBMS from a Java program as well as from the command line. Features covered include inserting, updating, and deleting records, querying the database and filtering the results (including parameterized queries), transaction support, and hooks for writing custom code.
Participants should have a basic knowledge of XML, relational databases, and Java.
Download presentation file