Re: Is relational theory irrelevant? (was Re: Dreaming About Redesigning SQL)
Date: Fri, 14 Nov 2003 14:47:00 -0500
Message-ID: <6oidnZwKgZJQryii4p2dnA_at_golden.net>
"Mikito Harakiri" <mikharakiri_at_iahu.com> wrote in message
news: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.
What advantage would these numbers have over the current ORDER BY functionality? Considering that the ORDER BY would still be required to guarantee the results come out in the order desired, I would consider ORDER BY the required feature.
> 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.
Certainly, any actual process involves the conceptual and the physical. What advantage to the logical model does the rank offer that is not offered by other logical constructs that already exist? Received on Fri Nov 14 2003 - 20:47:00 CET