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

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

• From: "David Lee" <dlee@calldei.com>
• To: "'John Cowan'" <cowan@mercury.ccil.org>, "'Liam R E Quin'" <liam@w...>
• Date: Sun, 2 Oct 2011 14:54:46 -0400

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@calldei.com
http://www.xmlsh.org


-----Original Message-----
From: John Cowan [mailto:cowan@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@lists.xml.org; talk@x...
Subject: Re:  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@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@lists.xml.org
subscribe: xml-dev-subscribe@lists.xml.org
List archive: http://lists.xml.org/archives/xml-dev/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php

• References:
  • JDBC in an XQuery world (?)
    • From: "David Lee" <dlee@calldei.com>
  • Re: [xquery-talk] JDBC in an XQuery world (?)
    • From: Liam R E Quin <liam@w3.org>
  • Re: Re: [xquery-talk] JDBC in an XQuery world (?)
    • From: John Cowan <cowan@mercury.ccil.org>