XML.com has a good review on how various popular relational databases store XML. The methods used currently are a real freak show, I imagine they’ll improve with time.