Since a long time, the database has had some versioning capabilities, long before features like “Edition Based Redefinition” in Oracle 11gR2 appeared. This versioning, via XMLDB functionality, is based on its XDB Repository access to the database. The XDB Repository is a file/folder metaphor that acts as a file server. You can enable this functionality
For all those to see and learn what you can do when combining the power of Oracle XMLDB and Oracle APEX an alternative APEX XFILES application is now available for download via http://xace.sourceforge.net. It is based on the combined efforts of Mark Drake and Carl Backstrom to convert the XMLDB XFILES demo application towards APEX. This “XFILES APEX Community Edition”, XACE for short to make a distinction with the more sophisticated official XFILES XMLDB demo application, demonstrates an implementation of versioning based on DBMS_XDB_VERSION and APEX as UI.
Also for Roel Hartman and me, its an exercise to demonstrate what you can learn while “standing on the shoulders of giants”. Also, in the spirit of Carl Backstrom, we want to share our knowledge with the comminity and give “it” back in the hope you will also get excited of these two very powerful options in the Oracle database.
We use this XACE application to help us with our presentation to demonstrate APEX versioning so if you are interested and have the chance see us (and ask questions afterwards) during Kaleidoscope 2011 or (shameless plug here) vote for us on Oracle mix so we are able to present these techniques on Oracle Open World this year as well (“XFILES, The APEX 4 version – The truth is in there“).
The more important below…
Download the XFILES XMLDB source via: http://www.oracle.com/technetwork/database/features/xmldb/index.html (among others webservices, geo location app, version control and more)
You can also download the OTN Developer Days Virtualbox environment to play with a fully installed XMLDB XFILES appl. (example 3 of the “Oracle By Example” XMLDB series).
Last but not least…
If you like it, in the light of the community
…and if you really like the effort done, by the community, donate some of your bucks on “Carl’s Memorial Fund” ! (more info here: http://carlback.blogspot.com/ or under the “donate” link of http://xace.sourceforge.net).
Hope you have some fun with it.
On behalve of…
Roel Hartman and me are currently very busy with our Kaleidoscope 2011 presentation “XFiles, the APEX Version: The Truth is in There…“. During this presentation, we will demonstrate the awesome possibilities you can create when you combine the APEX and XMLDB functionality of the APEX database environment. And as you probably also know, two “no cost options” delivered with your Oracle database. Our first presentation/demo will be on the AMIS Kaleidoscope Preview Sessions on the 14th of June, to test our “setup” and combined presentation for the real thing during Kaleidoscope, in Long Beach, USA, this year.
The demo will demonstrate how to setup database build-in versioning capabilities, based on standard XMLDB functionality, that can be used by or for APEX applications, while making use of the file/folder metaphor of the XDB Repository.
The XDB Repository can, by default, be used to, currently via WebDAV or FTP, drag and drop files into the database. This XMLDB functionality also has default versioning, checkin/out, an repository event mechanism and security functionality / capabilities. So why work, while working with this great development environment called APEX, with version tooling like Subversion, if the XMLDB realm of the database already has these capabilities to provide this by default.
The XFILES demo application is used to demonstrate XMLDB functionality but currently still main AJAX based regarding its GUI. In 2008 an effort was made, for that years Oracle Open World conference, by Carl Backstrom (Oracle APEX) and Mark Drake (Oracle XMLDB) to combine the two environments and switch the XFILES AJAX based GUI for the APEX front-end. Due to circumstances, it didn’t had the proper follow up regarding cleaning up the code and share the ideas…see the XFILES tab on this page for more info on this.
Roel and my efforts, regarding this XFILES APEX version, which is based on current and the work done by Mark en Carl in 2008, is called by us, the XFILES APEX Community Edition (abbreviated to XACE), so we are able to implement some chance management without be mistaken by Mark Drake’s still existing AJAX based XFILES version, currently version 5. This version implements and demonstrates Native Database Web Services via XMLDB in the OTN Development Days Virtualbox environment which can be downloaded via Oracle OTN.
More regarding the XFILES XMLDB application and blog posts can be found via the XFILES menu on this site. Information about Roel and his interests can be found on his personal blog roelhartman.blogspot.com and information about official XFILES Oracle XMLDB application and technology can be found on and via the Oracle XMLDB main page. Last but not least, for interest in Oracle APEX go to the apex.oracle.com site.
To give you a preview of the work done, hereby some updated pictures
Click picture to enlarge
Click picture to enlarge