Re: Primary and Foreign Keys
[Ronald Bourret] > > 6) Leave the key value out of the XML document. This requires that > nesting is used to indicate key relationships and makes sense when: (a) > key values are generated by the database, and (b) the data is being > transferred to a different database. Such values not guaranteed to be > unique in the second database. > I almost included this thought in my post, but didn't because it occurred to me that even if you nested a child entity within a parent, you might still need to refer to it from somewhere else rather than duplicate its data. So it seemed that eliminating the ID and nesting could be orthogonal. A case-by-case decision, methinks. Cheers, Tom P
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