Skip to Content
avatar image
Former Member

xml-support in maxdb

Hello,

does MaxDB offer XML-support ?

Regards

Michael

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jul 29, 2004 at 03:00 PM

    Hi Michael,

    the bad news first: There is no data type 'XML' of any kind. So there is no way to query XML data with SQL.

    MaxDB supports the storage of XML-Documents via its WebDAV interface. Using that you're able to store XML-Documents as LOB.

    The XML Indexing Engine of MaxDB provides the means to define XML Indexes. These indexes are defined by using XPath 1.0 expressions, that is you define the tags/data that should be used for indexing the document. The XML Indexing Engine would extract these data and store it as WebDAV properties of the document. Via the WebDAV GUI a quick search using these index values (WebDAV properties) is provided. Anyway there is no programming interface to perform this kind of search. You'd rather have to know the WebDAV table schema to write the proper SQL for a search along the WebDAV properties.

    Hope this will give you an idea.

    Cheers,

    Daniel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2004 at 11:28 AM

    Hi Michael

    Well there is always a possibility to insert xml data into a database.

    Look at this site:

    www.xmlsoftware.com under technial -> conversion tools ... there are some free and some comercial apps which can translate xml into the database and the other way arround.

    regards

    Matthias

    Add comment
    10|10000 characters needed characters exceeded