• To: xml-dev@l...
• Subject: database primary keys in XML Schema
• From: "Markus Seibold" <Markus.Seibold@g...>
• Date: Thu, 12 Feb 2004 20:29:23 +0100 (MET)

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

• Follow-Ups:
  • RE: database primary keys in XML Schema
    • From: "Michael Kay" <michael.h.kay@n...>
  • Re: database primary keys in XML Schema
    • From: "Jeff Greif" <jgreif@a...>
  • Re: database primary keys in XML Schema
    • From: "Tor Helland" <tor@h...>
  • Re: database primary keys in XML Schema
    • From: "Chiusano Joseph" <chiusano_joseph@b...>

• Prev by Date: TEST: ignore
• Next by Date: XMLSpy and <key><keyref>
• Previous by thread: TEST: ignore
• Next by thread: Re: database primary keys in XML Schema
• Index(es):
  • Date
  • Thread