For my and your convenience, I have updated my “XML Content” page so it is a little bit easier to find the XML posts.
I pinpointed in 2008 much more on performance, internals and how to setup an benchmarking environment and that is reflected in most of the topics regarding XML. In short, I hope you’ll enjoy reading them.
I hope it eventually will make a useful list.
😎
Concepts and Design
- Why XML Does and Doesn’t Fit the Real World
- XML Data – To be stored or not to be stored, and beyond…
- XML Relational Database Ramblings…
General
- 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 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
- HOWTO: Load Really Big XML Files
- Oracle OTN SAX Loader Example
- Demonstrating XML Equi-Partitioning by Reference Based On XMLDB Manual Examples
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 and 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
- About the XML(DB) W3C DateTime format while converting Java DateTime
- Using XMLDIFF for Database Change Management
- HOWTO: Avoid Conversion of Escape Codes
- HOWTO: Validate XML data
APEX, Native Database Webservices and Protocol Server
- 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
- HOWTO: Create a Native Database Web Service
- Storing your Scripts in the XMLDB Repository
- Quering RSS Feeds The XMLDB Way
- Using SQL*Plus as a Webbrowser, RSS feeder, Google Map data provider and more…
Security
- Oracle 11g Security – XMLDB is here to stay
- DBMS_XDB.SETLISTENERLOCALACCESS
- APEX Lockdown: Securing the XDB Protocol Server
Performance, Troubleshooting and Internals
- XMLDB Internals: Non-recursive statement used during “SQL*Plus XQuery” statement
- XMLDB Internals: Oracle XMLDB Related “Events”
- Setting Up an XMLDB Performance “Baseline” Environment (Part 01)
- Setting Up an XMLDB Performance “Baseline” Environment (Part 02)
- XMLDB Performance: Collection Iterator Pickler Fetch
- XMLDB Performance: Binary XML Storage Models
- XMLDB Performance: Environment, Set-up, Procedure
- XMLDB Performance: The Side Effects of a Simple “count(*)”
- XMLDB Performance: Useful Resource Advice while using DBMS_XMLDOM
HTH
Marco
