UKOUG 2011: Using your Database as a Fileserver

Read Time:2 Minute, 30 Second

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 on PL/SQL (like REST WebServices), but also C or Java based methods, and, out-of-the-box, Native Database Web Services (SOAP support) or direct XML content access via other “servlets” like the “ORADB/DBUriServlet” servlet method.

During UKOUG this year, Mark Drake (Senior Product Manager) and me, will demonstrate some of the cool things you can do with your database while acting as a file server for all your content. I will introduce, within half an hour, the audience to the concepts needed (XDB Repository, XDB Events, Extending your and database default methods) to extend your database functionality not only with file server capabilities but also go beyond that concept and enable it with automatic handling as needed (content consumption, version handling of content, securing content, detecting file properties and storing automatically extra file info, etc, etc).

Mark will spend the last half hour in demonstrating how you can create on these concepts a Google Map API content system that automatically picks up your photographs that are dropped in the XDB Repository (aka your database), then read it’s file properties (EXIF) and shows you the location on a Google World Map (via GIS/KML based info embedded in the picture) were the picture was actually taken. People who are using Apple/Mac OS, might recognize this functionality as “Places” in “iPhoto 11“.

…and yes, this was a shameless plug for our/my presentation during UKOUG…

…but then again, this is, is really cool stuff, so be there or be square on Tuesday morning…

Related Posts

😉

About Post Author

Marco Gralike

Marco Gralike, working for AMIS Services BV as a Principal Oracle Database Consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like Operating System Administration and Application Servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance.He is an Oracle XMLDB enthusiast ever since. He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco is a member of the OakTable network and an Oracle ACE Director (specialization Oracle XMLDB).

info@amis.nl

http://blog.gralike.com