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: 3vl 2vl and NULL

Re: 3vl 2vl and NULL

From: Marshall Spight <marshall.spight_at_gmail.com>
Date: 16 Feb 2006 10:38:27 -0800
Message-ID: <1140115107.587185.237360@g43g2000cwa.googlegroups.com>


dawn wrote:
>
> Once
> you normalize the data, your solution is no better than the average SQL
> implementation so you lose the charm

Wait-- are you saying you *advocate* denormalization? Can you clarify this please?

> I'm trying to convince
> "the industry" to adopt more flexible (dare I say "agile") data models
> and related tools.

Can you be specific about the features of the model you want, the kind of operations supported on the model, the problems with SQL that these problems will solve, and how to use the new model and operations/tools to solve those problems?

Note that I am not asking for "proof" of anything. Proof of cost/benefit is not possible and I suggest you abandon that search. Instead I am simply asking for examples. Sort of like, here's a problem I had once, and it was solved with MV like this, and see how much harder the SQL version of this solution is? Even the last is optional.

My big frustration with your quest is that for all the messages you post, I still really don't know anything *specific* you think would be beter with MV than with SQL.

Marshall Received on Thu Feb 16 2006 - 12:38:27 CST

Original text of this message

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