ARC01: XML vs RDB

• doborsh

  Newbie

  Points: 9

  More actions

  May 14, 2007 at 4:21 pm

  #195728

  Imagine you are creating a MySpace size website. About 170 Million users. Do you use a relational database to hold members edited pages or do you store all of this shtuff in XML on the webserver?  Over time these pages will not be edited that often so XML seems to look good to me.

  Now what about something we are all tired of... eCommerce? Would you make just the product catalog XML and use the Rdb only for order processing? Would you store it all in the Rdb and produce the XML from that... say daily and then have the web serve those XML pages?

  I am trying to get an architectural grip of how XML and Rdb fit into high volume websites today...  or should I do it the old way and put it all in the Rdb.

  Thank you

     

• cutespn

  SSCommitted

  Points: 1669

  More actions

  May 16, 2007 at 3:51 pm

  #706951

  Other approach would be use the xml data type feature in SQL Server 2005 to store the XML documents.

  
  
  
  
  
  

  Regards,
  Sudheer