Category: SQL, XML/SQL, XPath, XQuery

March 18

In the year that XML celebrates his 10th anniversary, Oracle announces to make the XQuilla XQuery engine available under the open source Apache 2.0 license. Via official sources, the following was stated:

  • Oracle is making the XQuilla XQuery engine available under the open source Apache 2.0 license – furthering the adoption of XQuery and XML for application areas including Service-Oriented Architecture (SOA) and Enterprise Content Management.
  • The XQilla XQuery engine, an implementation of the XQuery 1.0 standard published by the W3C, enables developers to query XML data, similar to SQL for relational data.
  • The XQilla project is hosted on SourceForge, where an active community collaborates to further the technology.

XQilla ProjectOracle is one of the contributors, developers, of the XQilla source base. Although XQilla has its source foundation in Pathan, XQilla has been developed and improved considerably from the Pathan code base. The XQuilla Engine 2.0 (and higher) will be available under the Apache license; XQuilla 1.1 is still under SleepyCat license.

What is XQilla? As stated here:

XQilla is an XQuery and XPath 2.0 implementation written in C++ and based on Xerces-C. It implements the DOM 3 XPath API, as well as having it’s own more powerful API. It conforms to the both the XQuery and Path 2.0 W3C recommendations.

February 20

Just a small post here as a reminder how it can be applied: the use of namespaces in conjunction with the XMLQuery operator. A question came up on the OTN XMLDB Forum based on XMLQuery. After building a correct example XML file I needed the namespace reference within XMLQuery and it wasn’t easy to find so here, as a reminder, the comprised version.

See also post “Xquery Error – ORA19276” as a reference.

February 15

The processes going on as mentioned in post “Saving XML data directly to disk” got me thinking so I started testing. Why did the processes take 100% CPU time…? To be honest I still don’t know for sure (I suspect the assembling of the XML instance), because I am unsure if I didn’t mix up apples with oranges after all. I suspect there is maybe still an NLS conversion thing going on. I found the whole exercise interesting, also because it gave me a little bit more insight in the internals.

Follow me on my tracing adventure.