XML pages from Databases

[Livingstone, Stephen]

The marked up data stored relationally is likely the way I we shall go
(ie. store structured columns of XML related data). At least as a
starting point.
I think a combination is best as we shall be looking to seach for
keywords and then be more specific using the marked-up data. We may
possibly use an SP to do some mark up.

All very confusing due to the searching feature which is very important
to us (rather than simply marking up stored data from columns in a db).
We need the system to be pretty eXtensible (which is whay a solo
database structure would probably be out of the question).

I'll let you know how we get on....

Thanks for all your responses,
Steven

Steven Livingstone BSc MSc GradInstP
Corporate Systems Development (TCN)
Royal Bank Of Sctoland.
mailto:livinsb at rbos.co.uk
+44 0131 523 4354 [x24354]

Networking Technical Associates,
Glasgow, Scotland.
mailto:ntw_uk at hotmail.com
+44 07771-957-280


> -----Original Message-----
> From:	Andrew Layman [SMTP:andrewl at microsoft.com]
> Sent:	Monday, January 25, 1999 6:16 PM
> To:	xml-dev-digest at ic.ac.uk
> Subject:	RE: XML pages from Databases
> 
> 
> *** Warning : this message originates from the Internet ****
> 
> 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 at ic.ac.uk
> Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
> To (un)subscribe, mailto:majordomo at ic.ac.uk the following message;
> (un)subscribe xml-dev
> To subscribe to the digests, mailto:majordomo at ic.ac.uk the following
> message;
> subscribe xml-dev-digest
> List coordinator, Henry Rzepa (mailto:rzepa at ic.ac.uk)


This e-mail message is confidential and for use by the addressee only.  If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer.

'Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent.'



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