For me and those who are interested, just like the year before , hereby an attempt to find all XMLDB related presentations, workshops and other events during Oracle Open World 2009. I will try to add info, time and days later on (and/or you might here as well) if I find them and/or if they …
Monthly Archive: June 2009
Jun 27 2009
Oracle posted a press release about their involvement and commitment for UBMatrix XBRL technologies last Wednesday saying (among others): “To help publicly held companies facilitate the preparation, publishing and automatic exchange of financial statements in XBRL (eXtensible Business Reporting Language), Oracle will embed UBmatrix, Inc.’s leading XBRL technology into Oracle’s Enterprise Performance Management (EPM) System, …
Jun 22 2009
Jun 22 2009
Als trainer, coach, presentator vraag je je soms wel eens af wat men er nou echt van vond. Meestal krijg je incomplete antwoorden hierop en/of is het moeilijk de waarde in te schatten vanwege het missen van een context. Daarom is het erg “cool” dat men dan via via, een artikel opstuurt of terug vind …
Jun 18 2009
You like or know Richard Foote?. There is another guy out there, called Marcelo Ochoa and he is building it (= an index =) from scratch via ODCI (The Oracle Data Cartridge Interface). If you want to know how you could build them on your own or how the Lucene Domain Index works based on …
Jun 17 2009
JavaOne has ended, ODTUG is about to start. The energy on Oracle Mix is now also increasing due to the fact that people get into the who or what to vote for… …and then for me the first Oracle Open World results were send via email…so I accepted… Still no idea how I will make …
Jun 17 2009
I wondered, for a long time, if it were possible to shred automatically XML documents, via Binary XML XMLType storage, the same way as you are able with Object Relational XMLType storage since the Oracle 126.96.36.199.0 version (the first officially supported XMLDB database version).
Based on “standard” object relational storage you need the following requirements and/or take the following steps:
- Annotate an XML Schema with the XDB namespace and xdb:annotations to your liking
- Register this XML Schema in the XDB Repository
- During registration automatically generate the needed types and tables (based on your xdb:annotations)
- An XML document(s) that validates properly, is valid, against your registered XML Schema.
If done properly, drag & dropping your XML documents via for example WebDAV via the enable protocol server, will cause the XDB functionality to check and validate the given XML documents against the registered XML Schema and insert the content automatically in the generated table(s). This mechanism also works via the FTP protocol functionality off the XDB Protocol Server.
I never got it really to work, at least the mechanism was fuzzy to me. Sometimes it did work as expected, sometimes it didn’t. What I didn’t realize, is that I most of the time use XML documents with multiple namespace references. Until one of my students during an XMLDB training, hit a small bug (8473369), regarding using duplicate namespaces in the “wrong” order. XQuery statement don’t have the problem, XML/SQL does, so I reported it via an Service Request. This made me wonder… Would I have the same issue with the namespace references in the registered XML Schema and the XML document. I still have to check the W3C Official XML Namespace Recommendation regarding this issue though…
Jun 15 2009
If you have seen Anjo’s Kolk’s cool “Oracle Interface for Google Visualization API (external data source interface)” blog post, which partly based on the Oracle XMLDB Protocol Adapter functionality, then be aware that direct access off this functionality via the internet is at your own risk. Of course this also counts for the OTN article given here: Creating Oracle Database-backed iGoogle Gadgets.
If you enable HTTP access via, for example, the XDB Protocol Server via the following DBMS_XDB call: