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: Pizza Example

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:

  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 Mon Apr 19 2004 - 17:19:23 CDT

Original text of this message

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