New XML(DB) related whitepapers available from Ken Atkins


During OPP 2007, two presentations by Ken Atkins where given regarding XML(DB) items, featues and best practices. My collegae Alex Nuijten was also attending, and presenting, and hinted me regarding Ken’s presentation whitepapers.

Ken’s presentation handsouts can be found here:

Wednesday: Getting XML Data into and out of Oracle
Thursday: Storing and Manipulating XML in the Database

Topics discussed and presented by Ken:

Ken Atkins: Getting XML Data into and out of Oracle

XML is very powerful as a method of transporting data between different applications or databases. Because of this, PL/SQL developers are often faced with the task of creating XML documents from data in normalized Oracle tables, or of storing the data in XML documents back into normalized Oracle tables. This session will present various tools and techniques that are available to the PL/SQL developer to read, write, and manipulate XML documents with the express purpose of getting the XML information into and out of standard Oracle tables. Multiple approaches will be discussed, including XDK (XML Developer’s Toolkit), XML DB, and XMLType methods. Useful examples of every technique will be presented and discussed. The focus of this session is on translating between XML documents and the database, not on storing, manipulating, or validating the XML. Those topics will be covered in another session.

Ken Atkins: Storing and Manipulating XML in the Database

In some application designs, you may have a need to store XML as XML in the database and manipulate it there. This session will present how to do this using various PL/SQL XML manipulation tools that are available in Oracle, such as the XDK (XML Developer’s Toolkit), XML DB, and the XMLType Oracle Type. Various methods of storing the XML in the database will be presented, including CLOBs, XMLType columns, and XML tables. Methods for querying the data directly from the XML in each of these cases will be presented. Storing XML Schemas in the database and using these schemas to validate XML documents will also be covered. Useful examples of every technique will be presented and discussed.

Not much XMLDB related information is published, yet, on the internet, therefore hereby a small post from me about new available information.


About Author

Marco Gralike, working for AMIS Services BV as a Principal Oracle Database Consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like Operating System Administration and Application Servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance. He is an Oracle XMLDB enthusiast ever since. He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco is a member of the OakTable network and an Oracle ACE Director (specialization Oracle XMLDB).


  1. Hi! I’m also interested in this two presentations. Unfortunately the links are not working anymore, so it would be great if you could send me the two files!
    Thanks in advance!!