[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: XML Schema: Getting lookup tables from DB

• To: "Long, Craig Z" <craig.long@e...>, <xml-dev@l...>
• Subject: Re: XML Schema: Getting lookup tables from DB
• From: "Rick Jelliffe" <ricko@a...>
• Date: Fri, 31 May 2002 14:14:39 +1000
• References: <1093E8BAEB6AD411997300508BDF0A7C0A1155BC@USHEM204>

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.

Cheers
Rick Jelliffe

----- Original Message ----- 
From: "Long, Craig Z" <craig.long@e...>
To: <xml-dev@l...>
Sent: Friday, May 31, 2002 6:50 AM
Subject:  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>
> 
>

• References:
  • XML Schema: Getting lookup tables from DB
    • From: "Long, Craig Z" <craig.long@e...>

• Prev by Date: Re: Different Validation in XML Spy 4.2, 4.3 and 4.4
• Next by Date: Re: The sky is falling! XML's dirty secret! Go back! It's a trap!
• Previous by thread: Re: XML Schema: Getting lookup tables from DB
• Next by thread: Re: XML Schema: Getting lookup tables from DB
• Index(es):
  • Date
  • Thread