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

RE: XML into SQL and out again

xml into sql table
Basically, I concur with Joseph.  One can use attributes 
for fields, certainly, and that will produce a compact 
instance.  It will also result in a much simpler schema 
should one have to write one, but the restrictions on 
what one can express in attributes viz a vis types and 
structure also means the schema is not doing very much 
useful work.  It can also limit the use of the instance 
particulary with regards to extensibility.

One can consider the instance also in terms of broader 
contexts.  What I find more and more is that if an XML 
instance is dumped at all from a relational system, the 
odds are good that it isn't being roundtripped back to 
the same system; it is going elsewhere, perhaps to another 
relational system, or even to the browser.  This can mean 
that one has to provide more than the original table did, 
for example, alternative representations of say timestamps, 
personnel numbers, and so on.  In this case, one begins 
to need the structural powers of elements.  I seldom see 
the relational data dumped precisely as it was used in 
the relational table (and one has to account for nulls).

So best practice, meaning, this is not a one off, 
tends to be as Joseph describes it.  Elements are 
generally better.


-----Original Message-----
From: Chiusano Joseph [mailto:chiusano_joseph@b...]

whether to use attribute or element based tagging here..

IMHO, this should not be an "or" type of choice - elements should be
used to represent data, attributes to qualify (modify) metadata. In
terms of english, one may think (in a very basic sense) of attributes as
adjectives, and elements as nouns.

Kind Regards,
Joe Chiusano
Booz | Allen | Hamilton


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.
First Name
Last Name
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.