Cart
|
[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: XML Database Decision Tree?
 1. Database Extenders - Oracle, IBM and Microsoft 2. Native XML DBMS that use RDMS technology - B-Bop and several public domain initiatives 3. Native XML DBMS that use proprietary database technology - Software AG, Excelon, Neocore and others Mike Champion gives a pretty good guideline. Let me add a few comments and corrections. In the third paragraph of his response he correctly points out the issue of "referential integrity" that Native XML DBMS does not support. I believe that is true of the category 3 of the classification. Database Extenders and Native DBMS that use RDMS technology support the notion of "referential integrity". Some of them also generate XML from data objects and data objects from XML. B-Bop's Xfinity is one of them. If your application requires you to store and manage a lot of relational tables and some XML documents or lot of XML documents that have relatively fixed DTD/Schema, approach 1 will work for you quite well. If you do not need complicated queries on the XML documents and will use the documents pretty much in its entirety, you can use the CLOB or BLOB approach to store these documents. If you need fragment retrieval and complicated queries on your XML document, you will have to do some mapping and break the XML documents into a set of relational tables. Obviously it would be lot of work when the DTD/Schemas can change or you use a number of them. If you have mixed content, you will have to use the CLOB or BLOB approach. If you do not, you can use the "shredding" approach. If your application requires you to store and manage a lot of relational tables and a lot of XML documents with varying DTD/Schemas and the DTD/Schemas need to be changed frequently, you are better of with the solution offered by category 2. You will use the RDMS for your relational data anyway. You will use the native XML capabilities of these DBMS to store and manage your XML documents. Some of them (like B-Bop Xfinity) provide the notion of "referential integrity" and generation of data objects from XML and vice versa. You also get the performance, reliability, scalability and reuse of DBA expertise that you have with RDMS technology. I will let the representatives of Software AG and Excelon explain under what circumstances their solution will provide you with value. Regards, Soumitra Magick, Brian wrote: A3AA9CEF24D21144A461F10C82A7AAA516BEFE@c..."> 
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! 
Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|
|||||||||
