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: Eric Kaun <ekaun_at_yahoo.com>
Date: Tue, 20 Apr 2004 13:47:13 GMT
Message-ID: <BR9hc.10111$576.2284@newssvr31.news.prodigy.com>


"Bill H" <wphaskett_at_THISISMUNGEDatt.net> wrote in message news:1a0hc.1963$GR.264088_at_attbi_s01...
> The main difference between a Pick dbms query
> optimization (PQO) and an RDBMS query optimization (RQO) is the PQO is
> accomplished by the application developer and the RQO is accomplished by
> pretty sophisticated RDBMS designer methodologies.
>
> The RQO is much more complex because it is designed to be a lot of things
to
> a lot of people, while the PQO is much simpler because the application
> developer usually knows the data access requirements (they designed them)
> and can incorporate optimization into the application.

  1. That's more work the developer has to do
  2. In a company of any size, and any level of turnover at all, that's just not true. No developer knows all of the data access requirements. And even with stable staff, they change, and a relational design will accomodate that change better. Theoretically. :-)
Received on Tue Apr 20 2004 - 08:47:13 CDT

Original text of this message

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