Re: New DB2 v9 Adapter for SLIDE

Hello Zeus,

I am not sure whether I can test the adapter because I do not know  
how I could gain access to a DB2 database. (Do they only run on IBM  
mainframes ?). I am working on Mac with OSX.

I should have a look at your code. If it looks good, I can check it  
in. Is it in a bugzilla issue ? I have had a quick look at my list of  
issues and did not find it.

Best regards,

Antoine

On Feb 25, 2007, at 4:27 PM, Zeus Courtois wrote:

> Hi Antoine,
>
> I submitted a new adapter last Wednesday, that was developed in  
> conjunction with a colleague, Rafael Coss.
>
> This adapter uses the XML capabilities of DB2 v9, as you may  
> already know: DB2 has the capability of defining the datatype of a   
> database-column as XML.  Just as you would define it to be VARCHAR  
> or INTEGER.
>
> The adapter is somewhat a combination of the existing DB2 v8  
> adapter and the File Store adapter, where the metadata is formed  
> into an XML doc and stored in DB2.
>
> The advantage of this is that the database schema was reduced from  
> 15 tables to only 2!!!  Where one table stores the metadata and the  
> other stores the actual documents.
>
> Moreover, not all documents are stored as BLOBs as before.  Now XML  
> documents--determined by the mimetype--will be stored as XML!
>
> The advantage is that the metadata and the XML documents may now be  
> queried through XQueries (W3C Standard) and SQL/XML which is on its  
> way to becoming a standard.
>
> The XML documents may also be indexed to make queries run faster  
> taking advantage of IBM DB2 performance, robustness and reliability.
>
> The adapter also has a major enhancement:  You can expose documents  
> through WebDAV.
> Ex: If you had documents stored in a certain table other than the  
> SLIDE Default Table, then through the use of a store procedure  
> (which was provided) you can create the metadata and make it point  
> to that file.  The file will not be moved from your original  
> table!  You can now view it through the explorer or any WebDAV  
> enabled application.  You may also modify the exposed file and save  
> it back!
>
> I provided a README file with more details.
>
> Do you think this can be a part of SLIDE adapters? Would you like  
> to test it?
>
> Let me know what you think,
>
> Thanks,
>
> Zeus Courtois.
>
>
>
>
> Looking for earth-friendly autos?
> Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.