Posts tagged xmldb
People who have attended the UKOUG presentation this year where Mark Drake, Sr. Product Manager XML Technologies / XMLDB, Oracle HQ, and I demonstrated the first principles of the XDB Repository, might have been impressed with its (GEO/KML Spatial, Image EXIF info) capabilities combined with Google Earth. This post will zoom in on how to consume automatically content of Windows Office document (docx).presentations from Marco Gralike
Most (APEX) people know the PL/SQL Gateway functionality of the XDB Protocol Listener, but this is only one very small part of the XDB Repository functionality. To be precise only one “servlet” part of it. Those “servlets” can be based on Java, C or PL/SQL. The PL/SQL Gateway, as it’s name suggests, is based on the PL/SQL part. Another “servlet”, the Native Database Web Service (NDWS), which enables you to create a database SOA endpoint service and more, is based on C code. Beside demonstrating the WebDAV ACL driven security features and database extensibility/interfacing facilities based on the database (no cost option) XMLDB functionality, it also explain one More >
Last Thuesday, Mark Drake, Senior Product Manager and I, delivered a good presentation during UKOUG in Birmingham about how to use your database, via XMLDB functionality, as a file server. The presentation demonstrated as well how you could extent the “standaard” file server (aka your database) functionality with features like, WebDAV driven ACL Security and XDB Repository Events, which enable you to automatically trigger event driven actions based on, for example, file naming, content, creator or others.
You can find the presentation on Slideshare or enjoy it here.UKOUG 2011 – Drag, Drop and other Stuff. Using your Database as a File Server View more presentations from Marco Gralike
During the demonstration in the second half of the presentation, we demonstrated how you can automatically consume the EXIF and KML information embedded in pictures to use it with the Google Earth API. All the code used for this Google Earth demonstration, and more, can be found on the Oracle XMLDB Sample Code page.
Have fun trying it out and if there any questions, post them on the OTN Oracle XMLDB forum.
UKOUG 2011 is nearby and one of the coolest things in Oracle 11g and onwards is, IMHO, a functionality called XDB Repository Events. Most of you probably know that based on XMLDB functionality in the database, the database also can be used in a File server kind of way by enabling the XDB Repository HTTP/FTP or WebDav functionality via DBMS_XDB. XDB Repository Events are a kind of “triggers” that enable you to automatically trigger/do something based on the events triggered in this file/folder environment. For example, it is possible to automatically create duplicate files in the XDB Repository or secure them. Other possibilities are to read the content of such a file and insert that content, on the fly during the copy/paste action, into a relational table.
Most APEX enthousiast know of the PL/SQL Gateway, which is a small part of the functionality that is called the XDB Protocol Listener. Besides PL/SQL support, it also enables you to secure your data, as mentioned, trigger actions based, for example on MIME type, mount your database as a Logical Volume (currently only via WebDAV, eg. DAVFS) of your operating system. The XDB Protocol Listener can support your own solutions based More >
Last day of Oracle Open World and I am currently attending the last presentations. The first presentation, “Oracle XMLDB: A noSQL Approach to Managing all your Unstructured Data”, deals with the no-SQL approach and using Oracle XML DB in the context of using it with “Big Data”, that is unstructured data. The title of the presentation is “a bit” misleading due it reference to noSQL data handling. XML is mostly used in the area’s of structured, data centric, semi-structured an unstructured, that is document centric data. Due to the flexibility of XML, it can be used for bridging those data content forms. Via the XDB repository, xmltype storage and xmlindex, that content can be moved into the XML DB part of the Oracle database, mapped and categorized. You can use repository events to shred and filter this map while the data is going in regarding interfacing via FTP or WebDAV. In all the presentation addressed a lot of already known fact of the XMLDB functionality and not really how to use it with huge amounts of unstructured data.
I just made use of the very cool OTN Virtual Developer Day Database site. In this environment you can follow OTN Developer Day sessions, for example, at home, while making use of all the material available on that site plus the downloadable Virtualbox OTN Developer Day Appliance. Despite you can choose for tracks like Java, .Net, APEX, there is also a database section which handles (as you might expect it from me regarding interest) Oracle XMLDB functionality.
There is a 1 hour webcast available from Mark Drake, Oracle Product Manager, that takes you along all the basics / general overview (basic due too it is too extensive to show it in only an hour) of possibilities of Oracle XMLDB functionality. For convenience there is also a PDF document that has most of the slide info of the webcast. It doesn’t contain the demo’s or extra Virtualbox OTN Developer Day Appliance first steps info, of course, and what to do to reset the training XMLDB environment in this appliance.
This PDF and the webcast starts with the Oracle safeguard (legal disclaimer), with the general product outline slide saying among others that Oracle is not responsible or obliged to actually build-in features More >
The XBRL Extention, a no cost add-on extention on XML-DB targeting the Extensible Business Reporting Language area, is now available for download. This second release ( p12388668_112020_Generic.zip ) of the Oracle XBRL Extension can be downloaded from the Oracle Support site (https://support.oracle.com). Once you have downloaded the file, please follow the instructions in the README.txt file to install the software.
Here are whatâ€™s new in the new in this release:
- New routines createStarSchemaFromFact and createStarSchemaFromHC have been added to PL/SQL package DBMS_ORAXBRLV to retrieve the list of table (view) names of a generated star schema.
- New routine DTS_filelist has been added to PL/SQL package DBMS_ORAXBRL to retrieve a discoverable taxonomy set (DTS).
For more info about the Oracle XBRL Extention see also “Oracle XBRL Extension Ready for Download”.