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

Re: XML vs relational database

  • From: "Ken North" <kennorth@s...>
  • To: "Sylvain LOISEAU" <sylvain.loiseau@w...>,"Jim Melton" <jim.melton@a...>
  • Date: Thu, 16 Aug 2007 10:08:59 -0700

Re:  XML vs relational database
Sylvain Lousieu wrote:
>For instance, one can ask for a structural property of the tree, in
>XPath, say the name of an element, by (1) referring to this element
>by its position and (2) using local-name() :
>local-name(./children[1]). In a relational algebra model, there is
>no order of the field, if I understand correctly. I see no other way
>of adressing a field than by its name.


Jim Melton wrote:

>>the call-level interface (CLI, of which ODBC is
>>an implementation) defined in 9075-3:2003 (soon to be 2008) defines
>>an API to get the same information without having to do all those
>>annoying SELECTs ;^)

>>It is true that in the relational model of data, attributes (columns)
>>have no order with a relation (table).  However, in the SQL model,
>>columns are, in fact, ordered.  In spite of that, the SQL standard
>>strongly(!) discourages code that depends on the sequence of columns
>>within a table.

SQL/CLI and JDBC provide metadata about a database and query result sets. For 
operating with a column of a result set (rowset), a JDBC program can, for 
example, access it by name or ordinal position.  In some early drivers, 
accessing a column by index was less prone to errors than accessing it by name.

But a core concept of SQL database technology has been to free applications from 
navigational logic and details of the physical data model. The idea is to 
provide operations at a logical level, using a database engine that optimizes 
queries and produces a plan for physical access to the data.

If physical data independence and operating at a logical level had been prime 
directives during the development of the XML specs, we might be talking about 
nested sets (which preserve order) as the XML document model.









[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]


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.