I once started this website because of the steep learning curve regarding XMLDB functionality. After one year of existence the following posts were written by mean , for me as a notepad to remember what I have learned and or checked, tested or figured out and to pass it on to all those who are interested in XMLDB functionality as well.
I hope these posts, this list provided here, will be of help, to make those first steps or help designing a working and performing XMLDB environment. There is still a lot to describe and learn and hopefully I have time to cover these in the second year to come.
Have fun reading.
😎
Concepts & Design
- Why XML Does and Doesn’t Fit the Real World
- XML Data – To be stored or not to be stored, and beyond…
XML Storage
- Oracle 11g – XMLType Storage Options
- Just an example of creating XMLType Tables
- Virtual Columns and Binary XML (Storage) Schema Validation
- Encoding and Validation of Binary XML Storage of XML Schema-Based Data
- About Moving, DeDuplication, SecureFile Storage and Encryption of Binary XMLType Tables
- HOWTO: Saving and Storing XML Data – A Tuning Adventure
- HOWTO: Saving XML data directly to disk
- HOWTO: The Four Create Table statements for XML Binary Storage
- HOWTO: Create XMLType Table for Binary XML Usage
- HOWTO: Manually create a XMLType table (OR / Schema based)
- HOWTO: Move a XMLType column (based on CLOB storage) to different tablespace
XML Indexing
- XMLIndex (part 1) – The Concepts
- XMLIndex (Part 2) – XMLIndex Path Subsetting
- XMLIndex (Part 3) – XMLIndex Syntax Dissected
- XMLIndex Performance and Fuzzy XPath Searches
XQuery, Xpath, XSQL & XML Schemata
- The use of namespaces within XMLTable or the table(xmlsequence(extract()) constuct
- Select within UpdateXML
- How to be stupid – Learning from your Mistakes (aka Referencing Namespaces)
- About Table(XMLSequence()) and XMLTable
- Mastering XML DB – Unexpected side effect of updateXML
- Mastering XML DB – COUNT and SUM
- Brilliant use of XML in the relational database
- dbms_xmlschema.PURGESCHEMA feature…
- HOWTO: Namespace use with XMLQuery
- HOWTO: Selecting XML data directly from your local disk
- HOWTO: Query via Xpath position function
- HOWTO: Compile a XML Schema in XMLDB
- HOWTO: Create DDL statements from XML
APEX, Native Database Webservices & Protocol Server
- Oracle 11g Security – XMLDB is here to stay
- DBMS_XDB.SETLISTENERLOCALACCESS
- Oracle 11g – How to enable native WSDL services
- Registering non-default XMLDB HTTP/WebDAV and FTP ports on a non-default Oracle Listener port
- APEX installation via the Oracle Protocol Server (listener)
- Small introduction to SQL*Net debugging [client side]
- Oracle 11g: Peeking into Protocol Server functionality – orarep and DBMS_REPORT
- HOWTO: Enable the Protocol Server (Listener)
- HOWTO: Resurrect your xdbconfig file when it gets corrupted
General & Whitepapers
- HOWTO: Installing XMLDB functionality
- Does patch 10.2.0.4.0 matter…?
- Almost forgotten XMLDB whitepapers and presentations
- New XMLDB whitepapers and presentations were added on OTN
- XFILES – XMLDB Content Management Example Application and More…
- Oracle 11g – My top 10 new XMLDB features
- XML Relational Database Ramblings…
OTN Forum Threads
From time to time this kind of content will be updated on the “XML Content” page.
See the “XML Content” link in the main menu.
