← Prev in month ← Prev in thread

database primary keys in XML Schema

From
Markus Seibold <>
To
Date
2004-02-12T19:29:23Z
ID
<>
Thread
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
← Prev in month ← Prev in thread