xml-dev - RE: XML pages from Databases

[Andrew Layman <andrewl@microsoft.com>]

David Livingstone asks for advice on creating XML pages from a database,
particularly on how the data should be stored, as tables of data or as
marked-up text.

It really depends on how you intend to use the data, and what your
processing load is.  For example, if you want to access the data from a
variety of angles, with transactional protection, and a heavy workload, then
you need a database and you need to store the data relationally.  If you
only need to retrieve the marked up text, then you could store that as
string fields in a database.  Or you can take a hybrid approach, with some
parts accessible relationally and others stored as marked-up text. (For some
good examples of the latter approach, see the excellent slide show Oracle
marketing has prepared at http://www.oracle.com/xml/.)

--Andrew Layman


xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo@ic.ac.uk the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo@ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa@ic.ac.uk)