Re: The IDS, the EDS and the DBMS
Date: Mon, 6 Sep 2004 21:57:53 -0400
Message-ID: <VdOdnfsd7_tUiKDcRVn-vg_at_comcast.com>
"Lauri Pietarinen" <lauri.pietarinen_at_atbusiness.com> wrote in message news:e9d83568.0409061256.5c59df3f_at_posting.google.com...
> I think one of the most outstanding features of SQL-DBMS'es (and
> naturally RDBMS'es) is the concept of view merging.
Once again, I'm goin gto lead you back to DEC Rdb. DEC Rdb added view merging somewhere around version 3.1, in about 1987. Just outstanding engineering.
But even if the RDBMS does view merging the wrong way, the cost is typically not worse than 3 for 1.
Many of the shops that rule out views "for performance reasons" are living with performance hits of 10 for 1 because they won't defragment their disks, or hits of 30 for 1 because their index design is just so lousy.
In other words, a lot of the people who discard the power of relational operations "for performance reasons" are penny wise and pound foolish. Received on Tue Sep 07 2004 - 03:57:53 CEST