xml stored as text
We are using a similar system (xml stored as text) to
add 'web service' reach to an existing application messaging
The proprietary object is converted to an xml document and sent to
a web service which uses ADO to store it as a text string into a
very simple database.
Drawback: You cannot (easily) query for the document by its contents, only
by its primary key.
So, if you need to be able to construct a new document listing, say, all
buyers of strawberry jam, then holding the inward xml files as a single text
stream is not so good. If you had shredded the inward xml into relationships
you would be in a position to do this.
Horses Courses Bourses
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL