[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: <key> and <keyref> - predefined values for XML elements
The predefined xml:lang attribute is designed specifically for the language enumeration you mention. As for the country/currency codes, I'm sure that someone from the OASIS UBL TC will soon provide insight into how these are being handled within UBL. Kind Regards, Joe Chiusano Booz | Allen | Hamilton Strategy and Technology Consultants to the World Markus Seibold wrote: > > Hello XML-DEV mailing list, > > I am developing a XML Schema which should function as the interface to a > relational database. I first developed a ERM data model and am trying to derive > the XML Schema from this ERM model right now. > > I came across the following problem: > I want to insert, for example, a country in the database. Therefore, I > declared an element <Country> in my main XML Schema. The country, among others, > has a subelement <language> which represents the official language(s) of the > country. > > How can I assure that the value(s) of language in an instance document can > only be of specific predefined values? > > I already tried the following: I created another XML Schema which is > included in my main Schema. The element <language> in the main schema is of > type="LanguageID": > <Another schema> > <simpleType name="LanguageID"> > <restriction base="string"> > <enumeration value="DE"/> > <enumeration value="EN"/> > <enumeration value="FR"/> > <enumeration value="SP"/> > </restriction> > </simpleType> > </Another schema> > > But here comes my problem: There is a table in the relational database which > stores both LanguageID and LanguageName (i.e., EN and English). The Country > table is related with a m:n relationship to the Language table. > > What I actually want to achieve in my XML Schema is to model this > relationship: > Whenever I insert a country via an XML instance document I want to spedify > the language(s) of this country by representing the foreign key relationship > between the two database tables. > > What is the best approach for representing relationships to master data > (such as languages, currency codes etc.) in XML? > > I though about using <key> and <keyref>. <keyref> can only point to XML > element/attribute content in instance documents, right? So what I had to do is > represent the Language database table as an own XML instance document, right? > > But how can I reference from instance documents based on my main XML Schema > (which contain the <country> element) to another XML instance file (which > contain the languages master data)? I read that XPath is not capable of this? > > Sorry for this massive email but I really have no experience with > representing ERMs in XML Schema and need some 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>
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|