Article:		Storing XML in Relational Databases
Subject:		Importing a Data Array from XML to DB
Date:		2005-12-04 11:14:16
From:		Igor Dayen
Response to: Importing a Data Array from XML to DB
One thing you may consider is to use XSLT to transform attributes into relevant element-based representation.

Previous Message

Up

Next Message

• Storing .xml files into database
  2007-08-21 04:01:35 santoshlocuz
  
  hello dear,
  i created tree by using dom and 3xml files, i didnt used database interaction for retriving the data. i just simply uses my xml files .but i need to store these xml files in MY SQl database.? how?
  
  
  • Storing .xml files into database
    2007-08-26 01:18:02 John1980
    
    how can I store XML documents efficiently in Databases
    
    

• Importing a Data Array from XML to DB
  2007-08-21 04:00:59 santoshlocuz
  
  hello dear,
  i created tree by using dom and 3xml files, i didnt used database interaction for retriving the data. i just simply uses my xml files .but i need to store these xml files in MY SQl database.? how?
  
  
  • Importing a Data Array from XML to DB
    2007-08-21 19:26:35 Igor Dayen
    
    You may consider:

    
    (a) using CLOBS if processing XML within a database is not significant; database is used as a storage and XML processing is delegated to application code;
    (b) using stored procedures as it suggested in http://rpbouman.blogspot.com/2006/03/importing-xml-data-into-mysql-using.html.

    
    
    MySQL team is considering to add XMLType support in future, see:
    http://forums.mysql.com/read.php?44,155525,157883#msg-157883

    
    Thank you.