Re: New DB2 v9 Adapter for SLIDE

[Antoine Levy-Lambert <an...@gmx.de>]

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.

Re: New DB2 v9 Adapter for SLIDE

[Martin van den Bemt <ml...@mvdb.net>]

I have a vmware image which I use to test ddlutils stuff (with almost all databases present).
Although I think writing a new adapter for every database is kind of cumbersome, so we probably need
to have a look at that, especially when alternatives exist that can do this job for us :)

Mvgr,
Martin

Antoine Levy-Lambert wrote:
> 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.
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org

RE: New DB2 v9 Adapter for SLIDE

[Michael Oliver <ol...@alariussystems.com>]

Antoine,

I am reviewing and will be testing the DB2 adapter and will check it in
along with the Derby adapter I already wrote, not need to do double work,
but it you want to also review, we can compare notes. 


Michael Oliver
Cell: 518-378-6154
Skype: MikeOliverAZ
Phone:702-866-9034

-----Original Message-----
From: Antoine Levy-Lambert [mailto:antoine@gmx.de] 
Sent: Sunday, February 25, 2007 1:36 PM
To: Zeus Courtois
Cc: Slide Developers Mailing List
Subject: 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.