Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-27 Thread Bob Badour
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Anthony W. Youngman wrote: > > >In article <[EMAIL PROTECTED]>, Anthony W. Youngman > ><[EMAIL PROTECTED]> writes > > But it does seem strange indexing on a composite field > >like that ... > > > But why does it seem

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-27 Thread Bob Badour
"Christopher Browne" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Anthony W. Youngman" <[EMAIL PROTECTED]> wrote: > > In article <[EMAIL PROTECTED]>, Marshall Spight > > <[EMAIL PROTECTED]> writes > >>Unless one has data independence, one does not have > >>this option; one will be

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-27 Thread Bob Badour
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Anthony W. Youngman wrote: > > >In article <[EMAIL PROTECTED]>, Lauri Pietarinen >[EMAIL PROTECTED]> writes > > > >>Anthony W. Youngman wrote: > >>>In article <[EMAIL PROTECTED]>, Lauri Pietarinen > >>><[EMAIL PROTE

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Bob Badour
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Anthony W. Youngman wrote: > > >In article <[EMAIL PROTECTED]>, Lauri Pietarinen > ><[EMAIL PROTECTED]> writes > > > > > >>>Okay. Give me a FORMULA that returns a time in seconds for your query. > >>> > >>>Let's assume

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Bob Badour
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Anthony W. Youngman wrote: > > >In article <[EMAIL PROTECTED]>, Lauri Pietarinen > ><[EMAIL PROTECTED]> writes > > > > > >>So in your opinion, is the problem > >> > >>1) SQL is so hard that the average programmer will

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Bob Badour
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Bob Badour wrote: > > >"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message > >news:[EMAIL PROTECTED] > > > >>I could now denormalise OrderD

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-23 Thread Bob Badour
"Marshall Spight" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Bob Badour" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > > > All physical structures will bias performance for some operations and > > against o

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-23 Thread Bob Badour
"Lauri Pietarinen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Anthony W. Youngman wrote: > > >In article <[EMAIL PROTECTED]>, Lauri Pietarinen > ><[EMAIL PROTECTED]> writes > > > > > >>Anthony W. Youngman wrote: > >> > >> > >> > >>>Fine. But MV *doesn't* *need* much of a cache.

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-18 Thread Bob Badour
obody seems to have been prepared to explain the MV model in adequate > theoretical terms as to allow the gentle readers to compare the theory > behind it with the other theories out there. > > I'm afraid that does not reflect very well on either those lauding MV > or those trashi

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-14 Thread Bob Badour
"Dawn M. Wolthuis" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thank you, Seun, for asking your question with a bit of logic and not > gut-reaction emotional baggage (and for also asking a question of me > off-list so I could ramble). I'll try to make this more suscinct. With al

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-14 Thread Bob Badour
"Mike Preece" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > [EMAIL PROTECTED] (Dawn M. Wolthuis) wrote in message news:<[EMAIL PROTECTED]>... > > Bob Badour" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... >

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-14 Thread Bob Badour
With all due respect, Dawn, you are an idiot. "Dawn M. Wolthuis" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Good question. Although I would want to move away from relational > databases too, if there is an RDBMS and one wants to query it, what > would I aim for? If you look at

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-14 Thread Bob Badour
[EMAIL PROTECTED] ("Dann Corbit") wrote in message news:<[EMAIL PROTECTED]>... > > -Original Message- > > From: Seun Osewa [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 03, 2003 11:52 AM > > To: [EMAIL PROTECTED] > > Subject: [HACKERS] Dreaming About Redesigning SQL > > > > > > Hi,

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Bob Badour
"Anthony W. Youngman" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > In article <[EMAIL PROTECTED]>, Lee Fesperman > <[EMAIL PROTECTED]> writes > >If you don't care for mathematical principles, there's always ad-hoc database > >models. > >Check out Pick, OO and XML databases.