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

Re: database primary keys in XML Schema

• To: <xml-dev@l...>
• Subject: Re: database primary keys in XML Schema
• From: "Tor Helland" <tor@h...>
• Date: Fri, 13 Feb 2004 16:21:45 +0100
• Organization: helland.org
• References: <000b01c3f22b$a88bde00$6401a8c0@pcukmka> <7036.1076679915@w...>

> But what if I want to add some cities at a later point?
> My idea was to design my schema in a way that it allows the city element
to
> be declared as document root. Doing so, I can insert only cities (using
the
> same XML Schema as for inserting all three parts together).
> But how can I tell the parser/RDBMS which country/state the cities to be
> inserted belong to?
> One idea I had was to add a attribute to the city element in order to
> specifiy the RDBMS primary key for country. But the XML document creater
must know
> the RDBMS key in advance then ...

IMHO this is not an xml problem. You need to identify the city's "owner" by
something other than its primary key. I guess you have a unique index in the
db on the state table, specifying uniqueness on the combination [state name
or abbreviation + country key].

Or you could look up the state in the db, get its key, and then setup the
xml document.

-tor

• References:
  • RE: database primary keys in XML Schema
    • From: "Michael Kay" <michael.h.kay@n...>
  • RE: database primary keys in XML Schema
    • From: "Markus Seibold" <Markus.Seibold@g...>

• Prev by Date: XslBricks: Rapid XSL Stylesheet Development Library
• Next by Date: Re: Patent Spam (was Re: US Patent 6,687,897)
• Previous by thread: RE: database primary keys in XML Schema
• Next by thread: XMLSpy and <key><keyref>
• Index(es):
  • Date
  • Thread