OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: [xml-dev] XML Schema: Getting lookup tables from DB

[ Lists Home | Date Index | Thread Index ]

Here is how to do it.

1) Make a CGI script (or equiv) which queries the database and returns
the answer in the form of a simple type definition in XML Schema language.

2) In your schema, include that document first.  Schemas are composed
of resources, and that resource can just as easily be dynamically generated
as being some static file.

3) Check through your application for caching effects. If your validator
caches the schema, the updating the database will not flow through to the
program. If your intranet caches the resource, updating the database will
also not flow through to the program.  That may be good, it may be bad,
depending on your requirements.

You can also do this kind of thing using Schematron and the document()
function.  In that case, you don't even need to present the database data
in the form of a schema: any kind of XML would do.

Rick Jelliffe

----- Original Message ----- 
From: "Long, Craig Z" <craig.long@eds.com>
To: <xml-dev@lists.xml.org>
Sent: Friday, May 31, 2002 6:50 AM
Subject: [xml-dev] XML Schema: Getting lookup tables from DB

> XML_Dev,
> I have a schema file that will validate large lookup tables.  I'm wanting to
> include another .XSD in my main .XSD that will grab the lookup table
> information.  For example: States are identified by two characters i.e. HI =
> Hawaii,  instead of enumerating these state codes I want to get them from a
> data base.  The state codes are easy, my issue would be codes that identify
> many organizations that may change often -- can this be done using XML
> Schema?
> Regards,
> /**
>  *
>  * @author Craig
>  * @Developer
>  * @Ever Vigilant!!!
>  * 
>  */
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
> The list archives are at http://lists.xml.org/archives/xml-dev/
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://lists.xml.org/ob/adm.pl>


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS