[main] SQL instead of XQuery

[Dmitry Turin <dev3os@narod.ru>]

noah,

nuic> SQL is great for querying and updating it. ...
nuic> policy documents are encoded as some kind of smart template,
nuic> so that a join in a language like XQuery can automatically create the
nuic> policy documents tailored for each customer.

Join of language like SQL can create tailored documents too via Web Service, e.g.
http://msdn2.microsoft.com/en-us/library/aa226553(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa226534(SQL.80).aspx
So there is no advantages of XQuery (let's make comparison
characteristic during all time, instead to agitate for only one technology).

nuic> SQL and relational are cleaner (not to say
nuic> having decades of deployment and training investment)

You are saying, that SQL is cleaner than XQuery,
relational is cleaner than xml's specifications,
but no XML/XQuery require more time and investment, but SQL requires ??

nuic> firms store lists of customers in
nuic> relational (probably), but the contracts, legal decisions, etc. are all
nuic> documents.

  If documents have regularized form (i.e. satisfied to some template),
then they can be easy entered into rational engine
(and even automatically: slides #7-9 in http://sql50.euro.ru/sql5.11.1.ppt ).
 If documents have not regularazed form, you will write separate
XQuery-request for each separate document ??
 So non advantage to store document in XML.

  SQL with my proposal can also read xml-documents from local
filesystem and remote Web-servers (slides #119).
  So non advantages of XQuery.

---

nuic> The point is that what makes XML so valuable is not just that it can do
nuic> documents, but that it can do these combined document/data applications.

Necessity to combine code and data into one script (like in Perl)
does not exist, right ?

nuic> It's the
nuic> combination of data and documents in a uniform model that's powerful.

I have read attentively your description of request, have imagined it
both in XQuery and SQL form, and have found, that both of forms are
equally powerfull [or not powerfull, depending of point of view :) ].



Dmitry Turin
HTML6     (6. 5.3)  http://html60.euro.ru
SQL5      (5.11.1)  http://sql50.euro.ru
Unicode7  (7. 2.1)  http://unicode70.euro.ru
Computer2 (2. 0.2)  http://computer20.euro.ru