Re: Extending my question. Was: The relational model and relational algebra - why did SQL become the industry standard?
Date: Tue, 18 Feb 2003 09:50:50 -0800
"Bob Badour" <bbadour_at_golden.net> wrote in message
> "Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message
> I disagree. What it says actually depends on the full predicate--internal
> and external--and not on whether Item represents a set or a multiset. To
> anglophone human eyes, it looks like it says Milk is an Item.
My typo, again. In multiset model we have
Soda (no pun intended:-)
whereas, in set model
Now, the first entry in the multiset model tells that there is at least one Milk container, while the first entry in the set model tells us that there are exactly 2 containers. The set model has more precision, here, granted.
> Are you saying that a set-based relational dbms with full support for
> domains would not allow the user to freely transform data among
Please, write down a query that transforms
in pure relational syntax. Now, the same, please, without explode/recursion
> The distinction [between physical and logical] is an important one.
> You do yourself a disservice by losing sight of it.
There are limitations of every model. The question always is if the goals that one wishes to achieve warrant changing the model. Received on Tue Feb 18 2003 - 18:50:50 CET