@so_is_thisNov 03.2006 — #I don't know that I'd store fully formed XML documents in a database. That would be a waste of space. I would unload the data from its XML structure and store just the data -- in a normalized format -- into a relational database. Such relational data can certainly then be extracted and formed into an XML document, again, for transmission purposes.
@NogDogNov 03.2006 — #I'll put it slightly differently:
A relational database is an excellent way to store data, making it easy and fast to retrieve, sort, and filter the data in many different ways.
XML can be a useful way to output data that you retrieve from a database in order to make that retrieved data portable and usable by any application or user agent which knows how to read and parse XML.
@so_is_thisNov 03.2006 — #Keeping all of your data in an XML document for local reference purposes is like using a fork to eat soup -- certain tools are designed to perform certain functions better than other tools. A relational database is the best tool for local storage of data. XML documents are the best tool for porting that data between platforms.