[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Primary and Foreign Keys
Umm, I can't seem to get my thinking past the need to be able to say (since I am reverse engineering backwards from the relational model) that the value for this is over there. It is almost as if one needs to denormalize but that seems wasteful. That is why links look attractive. It is true, that the task is to enable a way for them to describe the access and to ensure that the data model doesn't get in the way of different people doing that different ways. That is why the reply to so many requests for ad hoc querying capabilities is to say "buy a copy of MS Access or Crystal Reports and learn to use it with ODBC". Yes, when collecting data, it can stay in the relational database and be collected as XML. So rather than modeling foreign keys, what may be needed are the kinds of co-occurrence relationships one can model as Schematron assertions where values have to be checked and that is indeed a big part of the problem I have to solve. Len http://www.mp3.com/LenBullard Ekam sat.h, Vipraah bahudhaa vadanti. Daamyata. Datta. Dayadhvam.h -----Original Message----- From: Thomas B. Passin [mailto:tpassin@h...] I'm not sure that you have to model foreign keys in xml-schema to deliver this data. If all these different agencies need to access the data, they need to know how to make queries and how to interpret the results of the queries, but they don't necessarily need to know a lot about the data model or database internals. Maybe all this data can stay in relational databases while being returned as xml. To me, the challenge is how to describe the queries so that the user agencies or applications can figure out how to get what they want. I wouldn't want to let anyone have full open access to my databases, most likely. How does this fit in with the task you are asking about?
|
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
|