Re: Pizza Example

From: Bill H <wphaskett_at_THISISMUNGEDatt.net>
Date: Mon, 19 Apr 2004 22:19:23 GMT
Message-ID: <LfYgc.170735$K91.431908@attbi_s02>

Jan:

If I understand you correctly, the logical view is irrelevant because:

the dbms has to optimize the inefficient storage and can't in this instance, and
the obvious, the pizza has two specific kinds of cheeses, is a sloppy model.

Am I missing something here? :-)

Bill

> > So, if "the Pizza has Mozzarella and Parmesan cheese" is stored as:
> >
> > Pizza Mozzarella
> > Parmesan
>
> Indeed, but you did make certain query-optimizations impossible. Never
> mind that what you are advocating is basically sloppy data modelling.
Received on Mon Apr 19 2004 - 17:19:23 CDT