XML Content

I will update this page, from time to time, with all the relevant XML(DB) posts I have made in the past on this website. This way, XML content will be easier to find while searching on topic. I hope you will enjoy reading them.

Page was updated on 03 December, 2014.

HTH

😉

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

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
• HOWTO: Partition Binary XML based on a Virtual Column
• Oracle OTN SAX Loader Example
• Demonstrating XML Equi-Partitioning by Reference Based On XMLDB Manual Examples
• HOWTO: Partition Binary XML, XMLType Storage
• Oracle 11gR2 – XML Data Partitioning
• HOWTO: Shred Binary XML Documents Directly into a Default Database Table
• External Views (XML based)
• Oracle 12c: Export by View
• Using Database In-Memory Column Store with Complex Datatypes
• Loading XML documents into an Oracle database (1)
• Loading XML documents into an Oracle database (2)

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
• Structured XMLIndex (Part 1) – Rules of Numb
• Structured XMLIndex (Part 2) – Howto build a structured XMLIndex
• Structured XMLIndex (Part 3) – Building Multiple XMLIndex Structures
• HOWTO: XML Partitioning and Multiple XMLIndex Structures
• Oracle 12c: XMLIndex Support for Hash Partitioning
• HOWTO: Create a Structured XMLIndex, using the In-Memory Column Store

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
• Creating an alert log via XML/SQL
• When is an XQuery Statement too Long?
• HOWTO: Handle Complex XML Schemas (Part 1)
• Common XQuery mistakes applied in XML DB
• HOWTO: Count all Rows in all Tables – The XMLDB Way
• HOWTO: Convert from W3C XML DateTime format to Oracle Timezone
• Oracle XMLDB Sample Code
• HOWTO: Consume Anydata via XMLType (and back)
• XMLTYPE datatype and ORA-22992
• OOW 2012 – XQuery Update (HOL)
• HOWTO: Viewing XML data in V_$CELL_% storage cell SYS views
• Oracle 12c: XQuery Update
• Getting started with XQuery Update Facility 1.0
• Oracle 12c: XQuery Full Text
• String Aggregation of “Huge” Strings via XML
• HOWTO: Validate XML content against an XML Schema

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
• HOWTO: Consume Webservices via PL/SQL
• Oracle XDB DAD List (DBMS_EPG)
• XFILES (Part 6) – XFiles for APEX EA 0.1 – Available for Download
• XFILES (Part 5) – How to Open Up the XML DB Repository for APEX ?
• XFILES (Part 4) – The Supporting XDB Utility Packages Needed
• XFILES (Part 3) – The APEX Look and Feel
• XFILES (Part 2) – APEX Newbie Enhancement Requests
• XFILES (Part 1) – In Remembrance of Carl Backstrom
• HOWTO: Mount your Database as File System via WebDAV under Linux
• Part of the Puzzle: Oracle XMLDB NFS Functionality
• HOWTO: Reset the admin password for the stand-alone APEX Listener
• HOWTO: Implement Versioning via Oracle XMLDB
• The Oracle XMLDB “anonymous” user account
• HOWTO: XDB Repository Events – An Introduction
• HOWTO: Using the Oracle XMLDB Repository to Automatically Shred Windows Office Documents
• HOWTO: Oracle Shared Server Setup

Security

• Oracle 11g Security – XMLDB is here to stay
• DBMS_XDB.SETLISTENERLOCALACCESS
• APEX Lockdown: Securing the XDB Protocol Server
• HOWTO: Do a clean XML DB installation
• APEX, XDB Protocol Adapter Security, Using an Apache Reverse Proxy

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
• ORA-31098: Internal event to turn on XDB tracing
• HOWTO: Trace “ORA-19022: Unoptimized XML construct”
• Oracle 11.2.0.2 – Small but important changes
• XMLDB Whitepapers and Tooling about Design, Performance and Selectivity
• Oracle XMLDB Pragma – Cheat sheet

JSON

• Oracle OpenWorld: JSON Support in the Oracle 12c Database (upcoming new feature)
• Oracle Database 12.1.0.2.0 – Native JSON Support
• Oracle Database 12.1.0.2.0 – Getting started with JSON Path Expressions

Oracle XBRL Extention

• Oracle XBRL Extension Ready for Download

Tools

• C based XML tools in your $ORACLE_HOME
• Oracle OTN Developer Day VirtualBox Appliance

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
• Oracle 11g Release 2 New XMLDB Features
• Oracle SQL Developer 2.1 EA Release – XMLDB Features
• Oracle XML(DB) Use Cases
• Why Design If You Have to Uphold the “Coding Granny Argument”
• Whitepaper: Current Support of XML by the “Big Three”
• Ramblings 2.0
• Chainsaw Marco 🙂
• Oracle XMLDB LinkedIn Group
• Oracle Enterprise Manager Cloud Control 12.1 – Agent Installation, Issues and Solutions
• Basisregistraties Adressen en Gebouwen – Het importeren van Kadaster BAG data in een Oracle Database
• Oracle 12c: Oracle XMLDB is now Mandatory!
• Oracle 12c: PGA_AGGREGATE_LIMIT
• Technology preview – Oracle XQuery for Hadoop (New Big Data Connector)
• ORA-14696: MAX_STRING_SIZE migration is incomplete for pluggable database
• Oracle Database 12.1.0.2.0 – Turning ON the In-Memory Database option
• Oracle Database 12.1.0.2.0 – Turning OFF the In-Memory Database option

OTN Forum Threads

• OTN – XMLDB FAQ (Mark Drake)
• OTN – XMLDB (Page on this site; Special interest threads on OTN)