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_at_attbi_s02>


Jan:

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

  1. the dbms has to optimize the inefficient storage and can't in this instance, and
  2. 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 Tue Apr 20 2004 - 00:19:23 CEST

Original text of this message