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.
