Cart
[Home] [By Thread] [By Date] [Recent Entries]
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>
|
