Article:		Storing XML in Relational Databases
Subject:		Importing a Data Array from XML to DB
Date:		2005-11-10 18:28:03
From:		bdrudolph
Response to: Importing a Data Array from XML to DB
I am going to reply to myself as I thought of additional information to provide. I have been able to import either the element data or the attribute data but not both together. Do I need to take a multi step approach to tearing the XML apart and then restructuring it? Again thanks in advance for any advice. Brad

Previous Message

Up

Next Message

• Importing a Data Array from XML to DB
  2005-12-04 11:14:16 Igor Dayen
  
  One thing you may consider is to use XSLT to transform attributes into relevant element-based representation.
  
  
  • 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.

      
      
      
      

• Importing a Data Array from XML to DB
  2005-12-04 11:06:38 Igor Dayen
  
  One thing you may consider is to use XSLT to trasform attributes into relevant element representation.