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 >
New, new…? No, not really new, XQuery Update (W3C standard/draft 2011) was already implemented in 220.127.116.11.0, but is now officially also announced. Besides the XQuery Full Text support (XQFT for short, W3C standard/draft 2011), this is one of the big new features in Oracle 12c. With this update XQuery functionality, the XQuery standard is further expanded in a mature query language for XML (/unstructured) information.
Now also in Oracle 12c, this has immediate consequences for following, implementing a XQuery standard across the board. The following features, functions have now been given the status “deprecated” (most of them introduced in Oracle version 10.2) for updating XML data:
All Oracle SQL functions for updating XML data are deprecated. Oracle recommends that you use XQuery Update instead. These are the deprecated XML updating functions:
updateXML insertChildXML insertChildXMLbefore insertChildXMLafter insertXMLbefore insertXMLafter appendChildXML deleteXML
Although being signaled “deprecated”, be aware that they are still supported, but Oracle move to a position that the new XQuery Update functionality will be the basis for further More >
Hierbij nog dank voor allen die aanwezig waren bij de weer gevulde, informatieve & gezellige avond tijdens “Hotsos Revisited 2013″.
Wij presentatoren hebben genoten van het ambiance. Hier ook nog voor degenen die graag het nog een keer willen nalezen het presentatie materiaal van Toon, Jacco, Gerwin, Frits en mij…
Presentatie materiaal in alfabetische volgorde:
- Marco Gralike – Creating Structure in Unstructured Data (pdf-3,6MB)
- Gerwin Hendriksen – “Method GAPP” Used to Mine OEM 12c Repository and AWR Data (pdf-7,6MB)
- Frits Hoogland – About Multiblock Reads (pdf-4,3MB)
- Toon Koppelaars – SQL Plan Management (pdf-3,1MB)
- Jacco Landlust – Lessons Learned while Pushing the Limits of SecureFiles (pdf-1,1MB)
Hopelijk zien we jullie misschien weer tijdens de Masterclass over Oracle storage “Understanding storage met Oracle ACE Director James Morle” en anders hopelijk tot een volgende keer bij AMIS in Nieuwegein.
Van 15 tot en met 19 april geeft Luc Bors de 5-daagse ADF 11g training op het kantoor van AMIS in Nieuwegein. In 5 dagen leer je de basis van Oracle ADF 11g. De training bestaat basis uit presentatie, demonstratie en hands on, doorspekt met best practices en voorbeelden uit de dagelijkse praktijk. Schrijf snel in via deze link.
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 >