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: