SQL instead of XQuery

[Dmitry Turin <dev3os@narod.ru>]

Michael,

>> we are refusing to 'alter table' ?
MK> Yes, I think users of relational systems often refuse to "alter
MK> table". ...  many data base adminstrators will be very
MK> reluctant to move the nationality data into a new table because of the
MK> effect on existing applications

I'm agreed about effect on existing application - but i'm implying all time,
that we are making comparison of XML and relational situation
(instead of discussing of only one of them). If we move to XML
databases, effect on existing application remains (non-triviality is
not disappear !).

MK> XML is far more flexible in this regard.

Describe this flexibility, please, in light of said by me above.

MK> I believe that Bill Kent referred to this as a "one-to-one-and-a-bit"
MK> relationship (usually single-valued, occasionally multi-valued). They are
MK> very common, and very hard to handle properly in relational systems.

Can you write several 'create table' with FK, that i shall understand you.
Or write identical xml-tree.

MK> It's also much easier to hold properties-of-properties

What is this 'properties-of-properties' in terms of 'create table' or
xml-tree. Write, please.



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