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:[EMAIL PROTECTED] 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.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
