Category: RDBMS
June 25

Quering RSS Feeds The XMLDB Way

Actually this is old stuff (2006), but it got lost in a comment section. I think this can still be useful to some and I also post this here for prosperity.

Somewhere in 2006 my colleague Lucas Jellema wrote a post on the AMIS Technology site about querying rss feeds from the database. My colleague Anton Scheffer and I commented on that article with our XMLDB functionality mindset. Later on in 2007 Lucas wrote another useful post called “Querying RSS feeds in SQL…“. Peter Wolf commented that he had also written a very nice blog post about using XMLDB functionality while Integrating Yahoo Pipes into APEX.

I think this is still useful stuff to a lot of us, although you should keep in mind that the table(xmlsequence(extract())) construct will be, in time, out lived by the XMLTABLE function. Also XMLTABLE supports XPath V2, the table(xmlsequence(extract())) doesn’t. The XMLTABLE function is available from Oracle database version 10.2.

Read the postQuering RSS Feeds The XMLDB Way
June 4

Internals, Presenting, Portugal and Championchips

A small blog post silence but I did a lot; or not, I guess that would depend on your definition 😉 one and a half weeks ago, or is it already two, I was very busy with “fun” XMLDB stuff, that is, trying to figure out some peaces that are not in a manual.

Internals

I was trying to figure out some internals regarding XMLDB domain indexes, like the hierarchic index, nowadays referred to as the Path Index and the domain XMLIndex index. Going through a lot of $ORACLE_HOME\rdbms\admin scripts, I found out that those two very important XMLDB domain indexes (one dedicated for the XMLDB repository and one for XMLType Binary XML / CLOB storage support in 11g) are based on the ODCI, aka Oracle Data Cartridge Interface, aka the Oracle Extensible Architecture. When I have a better overview, insight into this matter, I will dedicate a post on this.

Read the postInternals, Presenting, Portugal and Championchips
May 14

XML Posts After One Year

I once started this website because of the steep learning curve regarding XMLDB functionality. After one year of existence the following posts were written by mean , for me as a notepad to remember what I have learned and or checked, tested or figured out and to pass it on to all those who are interested in XMLDB functionality as well.

I hope these posts, this list provided here, will be of help, to make those first steps or help designing a working and performing XMLDB environment. There is still a lot to describe and learn and hopefully I have time to cover these in the second year to come.

Have fun reading.

😎

Read the postXML Posts After One Year