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

RE: database primary keys in XML Schema

• To: "'Markus Seibold'" <Markus.Seibold@g...>,<xml-dev@l...>
• Subject: RE: database primary keys in XML Schema
• From: "Michael Kay" <michael.h.kay@n...>
• Date: Fri, 13 Feb 2004 12:19:40 -0000
• Importance: Normal
• In-reply-to: <11009.1076614163@w...>
• Reply-to: <michael.h.kay@n...>

Your XML schema describes constraints on a single document. A single
document probably corresponds to a "business object" held in your
database. The XML Schema cannot describe constraints that apply across
documents. Perhaps this is where your difficulty lies.

Michael Kay

> -----Original Message-----
> From: Markus Seibold [mailto:Markus.Seibold@g...] 
> Sent: 12 February 2004 19:29
> To: xml-dev@l...
> Subject:  database primary keys in XML Schema
> 
> 
> Hello everybody,
> 
> I am developing a XML Schema which should function as an 
> interface to a relational database. I have problems with how 
> to design the primary keys in XML Schema.
> 
> 1.) When I insert data via XML instance documents the first 
> time, I cannot specify a primary key in my XML instance 
> document because the database automatically creates an 
> auto-increment key. Correct?
> 
> 2.) What if I, for example, want to insert a city in a 
> geography database (the database has a Country and a City 
> table; 1:n relationship). When inserting a city, how can I 
> specify to which country the city belongs? I needed to know 
> the database primary key for the country, wouldn't I and add 
> this key as an attribute to the city in my instance document? 
> What other solutions do exist?
> 
> This issue cost me alot of time so far and I would really 
> appreciate any help!
> 
> Thanks a lot, Markus
> 
> 
> -----------------------------------------------------------------
> 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>

• Follow-Ups:
  • RE: database primary keys in XML Schema
    • From: "Markus Seibold" <Markus.Seibold@g...>

• References:
  • database primary keys in XML Schema
    • From: "Markus Seibold" <Markus.Seibold@g...>

• Prev by Date: RE: XML inside another XML
• Next by Date: RE: US Patent 6,687,897
• Previous by thread: Re: database primary keys in XML Schema
• Next by thread: RE: database primary keys in XML Schema
• Index(es):
  • Date
  • Thread