[
Lists Home |
Date Index |
Thread Index
]
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@gmx.net]
> Sent: 12 February 2004 19:29
> To: xml-dev@lists.xml.org
> Subject: [xml-dev] 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>
|
