[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Primary and Foreign Keys

  • From: "Bullard, Claude L (Len)" <clbullar@i...>
  • To: "Thomas B. Passin" <tpassin@h...>, xml-dev <xml-dev@l...>
  • Date: Sun, 22 Jul 2001 13:02:43 -0500

foreign keys in xml
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!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.