From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Dmitry Turin <sql4-en(at)narod(dot)ru> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant |
Date: | 2007-04-24 12:40:52 |
Message-ID: | 462DFAD4.7030001@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Dmitry Turin wrote:
> Good day, Joe.
>
>>>> I would change your examples to use less abstract
>>>> data, like department/employee, customer/product/order/order_line
>
> J> I contend that then you'd find more people
> J> receptive to your ideas or at least able to criticize them from more
> J> concrete viewpoints.
>
> I expected, that you already read
> http://sql4.by.ru/site/sql40/en/author/wave_eng.htm
> (i added output into this paper).
> Case of "department/employee" is "Example 1" on this paper.
I'd not expect people to read lengthy articles on a general-questions
mailing list, but I've skimmed at least as far as example 2.
1. What does it mean for one flight to be contained within another? I
can see how one flight might follow another, but not contained. Do you
not need some new object "flight_chain" or similar?
2. Surely a flight should contain two cities (since it connects two
cities). Alternatively, the <city> needs to indicate to which it's
referring either as <startcity>/<endcity> or <city fromto="start"> or
similar.
3. How am I constructing these queries? The whole point was so I didn't
have to learn SQL, yes? Unfortunately, the syntax for these queries
isn't obvious enough to me that I can see how to write them without some
form of query-builder, or reference manual.
4. How am I using these queries? I'm still not clear what use it is to
have XML without a schema. Let's say I want to build a holiday website.
How does this TML setup avoid me having to write any php/perl/etc?
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Wilkinson, Jim | 2007-04-24 12:45:13 | Re: hi |
Previous Message | Dmitry Turin | 2007-04-24 12:35:03 | Re: Fwd: Re[2]: We all are looped on Internet:request+transport = invariant |