This article gives a good description of ways in which different database products are implementing XML in their databases. It brings up the point that since there are many different implementations, will there eventually be a standard way to do it?
http://archive.devx.com/xml/articles/dd_dbstandard/dbstandard-1.asp