title: Best way to store XML data into database
body: <p>I have XML file with multiple level of children. Which is best way to store that data into database? To make different table for node and save data with relationship or? What to do if we have 50 different nodes ?</p>
  
  <p><strong>Similar XML</strong></p>
  
  <pre><code>&lt;storage&gt;
     &lt;product description="Cardigan Sweater" product_image="cardigan.jpg"&gt;
        &lt;storage_item gender="Men's"&gt;
           &lt;item_number&gt;QWZ5671&lt;/item_number&gt;
           &lt;price&gt;39.95&lt;/price&gt;
           &lt;size description="Medium"&gt;
              &lt;color image="red_cardigan.jpg"&gt;Red&lt;/color&gt;
              &lt;color image="burgundy_cardigan.jpg"&gt;Burgundy&lt;/color&gt;
           &lt;/size&gt;
           &lt;size description="Large"&gt;
              &lt;color image="red_cardigan.jpg"&gt;Red&lt;/color&gt;
              &lt;color image="burgundy_cardigan.jpg"&gt;Burgundy&lt;/color&gt;
           &lt;/size&gt;
        &lt;/storage_item&gt;
        &lt;storage_item gender="Women's"&gt;
           &lt;item_number&gt;RRX9856&lt;/item_number&gt;
           &lt;price&gt;42.50&lt;/price&gt;
           &lt;size description="Small"&gt;
              &lt;color image="red_cardigan.jpg"&gt;Red&lt;/color&gt;
              &lt;color image="navy_cardigan.jpg"&gt;Navy&lt;/color&gt;
              &lt;color image="burgundy_cardigan.jpg"&gt;Burgundy&lt;/color&gt;
           &lt;/size&gt;
           &lt;size description="Medium"&gt;
              &lt;color image="red_cardigan.jpg"&gt;Red&lt;/color&gt;
              &lt;color image="navy_cardigan.jpg"&gt;Navy&lt;/color&gt;
              &lt;color image="burgundy_cardigan.jpg"&gt;Burgundy&lt;/color&gt;
              &lt;color image="black_cardigan.jpg"&gt;Black&lt;/color&gt;
           &lt;/size&gt;
           &lt;size description="Large"&gt;
              &lt;color image="navy_cardigan.jpg"&gt;Navy&lt;/color&gt;
              &lt;color image="black_cardigan.jpg"&gt;Black&lt;/color&gt;
           &lt;/size&gt;
           &lt;size description="Extra Large"&gt;
              &lt;color image="burgundy_cardigan.jpg"&gt;Burgundy&lt;/color&gt;
              &lt;color image="black_cardigan.jpg"&gt;Black&lt;/color&gt;
           &lt;/size&gt;
        &lt;/storage_item&gt;
     &lt;/product&gt;
  &lt;/storage&gt;
  </code></pre>