Article:		Storing XML in Relational Databases
Subject:		Storing XML in Relational Databases
Date:		2003-08-23 08:17:52
From:		Igor Dayen
Response to: Storing XML in Relational Databases
Thanks for feedback and suggestions very much. I agree that the market of native XML databases has been evolved substantially for the past couple of years; you may be interested in checking Ronald Bourret's product directory http://www.rpbourret.com/xml/XMLDatabaseProds.htm for details. As it is stated in the reference above, Tamino's powerful import facilities allow "individual XML documents to be composed of data from multiple, heterogeneous sources, such as the native XML data store, relational databases, and the file system". It is also worth to note that XML support in RDBMS incorporates now some features attributed to native XML databases. Oracle 9i, for example, introduced XMLType, which allows applying XPath expressions and indexes towards XML documents. Regards, Igor Dayen, ObjectCentric Solutions Inc.

Previous Message

Up

Next Message

• Storing XML in Relational Databases
  2004-08-23 23:38:02 query
  
  I need to convert Access table into XML format for onward submission to Middleware. Appreciate your urgent help.
  
  
  • Storing XML in Relational Databases
    2004-08-24 19:09:57 Igor Dayen
    
    Here are a couple of options you may consider:
    (a) export from Access into flat file
    with further conversion into XML using
    custom-made parsing solution or
    using a vendor tool
    (you may check for CredibleXML, see
    http://www.crediblexml.com/);
    (b) export from Access into MS SQL Server
    and generate XML out of SQL Server table with
    use of FOR XML syntax.
    Igor Dayen