Category: Binary-, CLOB-, Object Relational Storage

November 21

This is a bummer and then again it is not. I am thinking lately a lot about how to bring the conceptual XML(DB) world into the Oracle Relational world, or in other words “what is needed to make XML fast – given an Oracle database 11g atmosphere”. One my ramblings was: OK given the XML free format, how do I a create an environment that’s very high selective based on indexing and or breaking up XML fragments in physical segments (therefore hopefully being more selective) that can be handled more easily by the Oracle Optimizer (even given items like, creation solutions for, XML deficiencies like data redundancy etc).

Anyway…

Searching the internet I came up with this excellent (it helped me one step further in my exploring brain matter path) link regarding indexing called:

  • Shweta Agrawal: Indexing XML in Oracle (IT620 course project) – April 8, 2003

What’s more, and this brings me back awfully close to home (Holland / Amsterdam), I looked up the used references by Shweta Agrawal. One of them was called:

November 5

Tomorrows presentation at AMIS, will be my first test run for my UKOUG presentation in December, Birmingham. It took me a while to get the red herring from my braincells onto a Powerpoint presentation. To be honest, I am still not really pleased with it. It lacks some coherency, but I almost now for sure that it will be there when I start of and introduce my audience into the wonderful (sometimes confusing) world of XMLDB.

I will address a lot of DBA viewpoints on to the matter.

Read more…

October 24

Learned yesterday an important lesson on the Oracle OTN XMLDB forum. A question was asked why a count via a full table scan was quicker than the same example while using an XMLIndex. “XMLIndex performance regarding // (any descendant))”. The poster used the // xpath expression to do his search.

As in most cases nowadays it is important to keep your statistics in order. An XMLIndex is not an “index” as such, it is an logical index / domain index, specially designed for use with XMLDB / XML data.

Read more…