Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Extending my question. Was: The relational model and relational algebra - why did SQL become the industry standard?

Re: Extending my question. Was: The relational model and relational algebra - why did SQL become the industry standard?

From: Lauri Pietarinen <lauri.pietarinen_at_atbusiness.com>
Date: 12 Mar 2003 21:45:06 -0800
Message-ID: <e9d83568.0303122145.4e5f3158@posting.google.com>


jan.hidders_at_REMOVE.THIS.ua.ac.be (Jan Hidders) wrote in message news:<3e6da66b.0_at_news.ruca.ua.ac.be>...
> >>So, what is your point exactly?
> >>
> >If nobody needs them (bags) why support them? Even if the cost is zero?
>
> I'm not convinced that bags are never needed. There's a reason that
> mathematicians introduced it; they needed it to model certain things. What
> about Petri nets, for example? And if you are then going to simulate them
> with sets then the cost might become negative because the set-based
> optimizer might miss certain optimizations that would have been easier to
> spot for a bag-based optimizer.

Boy! What foresight by Chamberline et al for them to use bags instead of (just) sets in SQL back in 1975 against Codd's advice! Or was is just a happy coincidence. Think, if we had adhered to Codd's original ideas we would now be stuck!

regards,
Lauri Pietarinen Received on Wed Mar 12 2003 - 23:45:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US