Posts tagged xmldb
One of my colleagues had an interesting challenge. In an Oracle Database he has a table that contains an XMLType column. The column contains XML documents with people collections. This data is retrieved and transformed inside the database using an XSLT stylesheet, to a format – for example XHTML – that can be served directly to an end user in a browser. However, the XMLType contains a country code element where the displayed data should show the name of the country. There is a lookup table that contains the country data; this table can be used to enrich the data in the XMLType. The question now was: what is the best moment in the processing pipeline (query => transform => output) to perform this enrichment. The definition of ‘best’ should include performance, scalability, programming effort and (infrastructural) complexity.
One of the options we discussed was enriching in the first stage of the pipeline, as part of the retrieval step. This would be done using an XQuery operation against the XMLType, producing another [enriched] XMLType that would be fed into the XSLT transformation. This article shows how that could be done. Using the experienced insights of my colleague Marco More >
XMLIndex support for Hash Partitioning is now also supported in Oracle 12c. In Oracle 11 there was already support for RANGE and LIST partitioning, but not yet for HASH partitioning. Some examples for the later two: (more…)
New in Oracle 12c and one of the big new features in XMLDB is the XQuery Full Text functionality and, as mentioned in the post about XQuery Update, is the official W3C standard to handle unstructured pieces of XML content. The XQuery Full Text and XQuery Full Text Index extends the XQuery XMLDB language to efficiently and XML aware handle unstructured content in XML. So finally in Oracle 12c, we are able to handle “structured”, “semi-structured” and “unstructured” content, XML aware and based on standards, across the board with regards to XML content.XQuery Full Text FTSelection / Match
The following “Full Text FTSelection Operators” are supported:
- FTAnd (ftand)
- FTMildNot (not in)
- FTOr (ftor)
- FTOrder (ordered)
- FTUnaryNot (ftnot)
- FTWindow (window)
The following “XQuery Full Text Match Options” are supported:
- FTStemOption (stemming, no stemming)
The default behavior specified in the XQuery and XPath Full Text 1.0 Recommendation is used for each unsupported match option, with the following exceptions:
- FTLanguage (unsupported) – The language used is the language defined by the default lexer, which means the language that was used when the database was More >
Is this one of my highlights? No not really, but it is a remarkable one. Oracle XMLDB functionality is now mandatory and can not be uninstalled. As mentioned in the new feature section of the Oracle XMLDB Developers Guide for Oracle 12c:
Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it, and there is no option not to include it when you create Oracle Database. It is automatically installed when you create a new database or (if not existing already) when you upgrade an existing database to Oracle Database 12c Release 1 (18.104.22.168).
…and a bit further on… (more…)
Hereby, for those who want another look or for people to share, my presentation content “Creating Structure in Unstructured Data” given during the Hotsos 2013 Symposium on Monday morning.
It has been a while that I have been attending Hotsos, although that is how it feels. In 2011 I flew to Hotsos to see, among others presentations from Maria Colgan, but I ended up being sick the whole week while learning on my hotel room to enjoy American TV. In 2012 I skipped Hotsos (10th year anniversary) thinking my schedule was too full with international presentations, but alas, that agenda cleared up expectantly, so in the end I missed out on some big conferences as a presenter and/or attendee.Hotsos?
You don’t know the Hotsos Symposium? The Hotsos Symposium is, in my honest opinion, is one of the most interesting best symposiums/conferences out there, when you goal is learning all about (Oracle) performance. This yearly happening takes place in Irving, Texas, in an Hotel on an isolated location somewhere nearby a highway some miles from Dallas downtown. When I read that Maria Colgan would do the Hotsos Training Day (an extra symposium option), without even seeing the rest of the symposium agenda, I knew I had to attend. Maria is a very natural gifted speaker and with her comfy way of addressing (difficult) problems and solutions, she nowadays easily attracts the same More >