Re: Is relational theory irrelevant? (was Re: Dreaming About Redesigning SQL)
Date: Fri, 14 Nov 2003 10:36:43 -0800
Message-ID: <Eq9tb.20$6v2.129_at_news.oracle.com>
"Bob Badour" <bbadour_at_golden.net> wrote in message
news:OcWdnXtfjYBSpCmiRVn-vg_at_golden.net...
> "Mikito Harakiri" <mikharakiri_at_iahu.com> wrote in message
> > I would like to have
> > an extra column that has integers numbers in it. Those numbers have to
be
> > calculated from the values in the "symantically valid columns". SQL with
> > analytical extensions (window functions) generates such enumerating
column
> > easily. How about other languages: RA, RC, Datalog, and D4?
>
> If you had quota queries, what need would you have for these numbers?
Thes numbers would help to the query front end to arrange query results in order. A user would focus his attention on the row ranked #1 first, them perhaps perform some physical action depending on the row value, next shift his focus to row #2, and so on. Doing the procedure in the out of order might be less optimal.
The process, therefore, involves the state of the user mind and the time. Both of which have nothing to do with logical properties, of course. Received on Fri Nov 14 2003 - 19:36:43 CET