[xquery-talk] [xml-dev] Re: JDBC in an XQuery world (?)

[David Lee]

Syas Liam:

I don't think so.  SQL/XML extends SQL to add XML as a new kind of primitive
SQL data type, like strings, numbers, and dates.  What's needed here is a
way to do ordinary SQL operations over an XDM-based database.
--------------

Exactly.
SQL/XML is the inverse problem as what I'm discussing.

A simplistic mode is to map XML Document <-> SQL Table

However after using MarkLogic and Exist for a while I'm getting to think of 
	collection() <-> table
	XML Document <-> row

Taking this one step further.  Suppose were querying an XML Database (not an
XML Document).

	Xquery Module  <-> table
	XML Result 	<-> row

This lets us model an XQUery module as the equivalent of a relational "View"
and seperate us from the underlying document model.
 By defining a 'contract' for a set of Xquery modules that return a sequence
as their result, (flattening the XML nodes) this might work well.
Takes some thought how to do Insert/Update but along the same lines ...
Xquery modules could be the glue that translates XDM <-> SQL without
imposing a riged binding (fits all == fits none)   of XML <-> SQL\


----------------------------------------
David A. Lee
dlee at calldei.com
http://www.xmlsh.org


-----Original Message-----
From: John Cowan [mailto:cowan at ccil.org] On Behalf Of John Cowan
Sent: Sunday, October 02, 2011 2:43 PM
To: Liam R E Quin
Cc: David Lee; xml-dev at lists.xml.org; talk at x-query.com
Subject: Re: [xml-dev] Re: [xquery-talk] JDBC in an XQuery world (?)


Liam R E Quin scripsit:

> > What if I have (or want) an XQuery database
> > (or would you call that a XML database with an XQuery interface ...?) 
> 
> SQL/XML I think describes enough of a mapping, no?

I don't think so.  SQL/XML extends SQL to add XML as a new kind of primitive
SQL data type, like strings, numbers, and dates.  What's needed here is a
way to do ordinary SQL operations over an XDM-based database.

-- 
How comes city and country to be filled with drones         John Cowan
and rogues, our highways with hackers, and all          cowan at ccil.org
places with sloth and wickedness?           http://www.ccil.org/~cowan
                --W. Blith, Eng. Improver Improved, 1652

_______________________________________________________________________

XML-DEV is a publicly archived, unmoderated list hosted by OASIS
to support XML implementation and development. To minimize
spam in the archives, you must subscribe before posting.

[Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
Or unsubscribe: xml-dev-unsubscribe at lists.xml.org
subscribe: xml-dev-subscribe at lists.xml.org
List archive: http://lists.xml.org/archives/xml-dev/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php