-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I see Werner's point and maybe I was not explicit enough in this regard. I agree to storing XML in an RDBMS is an awful idea.
What I meant was that the system imports XML data in *normalized* SQL tables. The underlying data structures and standards easily map to a relational model and that is exactly the object of the exercise : - - normalizing the data, - - being able to check it for consistency and possible errors, - - being able to consistently 'export' it, or sub-sets of it, to any number of formats, - - run ad hoc queries on it http://www.ducis.net/images/miri/dm_maindata_f.png I do not doubt that any number of NoSQL systems are capable of handling various formats and would in some specific areas do better than an RDBMS. I argue that using an RDBMS offers the same, if not more, flexibility while requiring less code tied to the specific data-platform/technology. I also argue that supporting a maintenance app on a RDBMS basis (user management, transactions, logs,...) would be a lot simpler and again would require a lot less technology-specific (extra) code. This, I think, translates to a maintenance system that is easier -- less specific -- to maintain and easier to adapt to future requirements with regard to data formats and technologies. Regards, esjr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (MingW32) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJQ/9DTAAoJEOxywXcFLKYcfVsH/Rc7Cabdxeo62GCwNOvS4RsJ JxwPJnC064gLeSvnm0eeM+hVvnO9Vt+QkTfLYqOE0B4HBxuudMm+MLaGNYSYZfr5 lhwpccilnqnmKvioK0/Cqxv9UsyV//KUnIxV7l3kMTEQQozLaMCD5v9SRo9kbo6b D4YRPcD2sfHIgTLnQawexOkpV9jhWHS09goc3ebX+rtsgjo5wKHogf7BY2fwsCc1 KNX22BKeeXa1ZGEH+B5zVgiic6WS4+YQa8wgPWS2D9XlyWgd0TPOo5ybyNhp6lUI hr2TaPo0L2ZOI52aHdriXzPWualllWN4vEUcNDTlzoxgqEA1jZ+O1fi6G4JMbbU= =ZoAr -----END PGP SIGNATURE-----
