Re: Mixing OO and DB

From: Patrick May <pjm_at_spe.com>
Date: Tue, 04 Mar 2008 16:24:55 -0500
Message-ID: <m263w2kwrc.fsf_at_spe.com>


"Brian Selzer" <brian_at_selzer-software.com> writes:
> "Patrick May" <pjm_at_spe.com> wrote in message news:m2bq5xylnc.fsf_at_spe.com...
>> One common denormalization technique is to eliminate a join by
>> adding columns to one table that replicate data in another table
>> that has a one-to-many relationship with the table being
>> denormalized. The business logic shouldn't have to change just
>> because the schema does.
>
> Why denormalize when you could just use a materialized view?

     Materialized views are not always available and may not provide significant performance benefits if the data is being updated frequently and the clients need the absolute latest values.

Regards,

Patrick



S P Engineering, Inc. | Large scale, mission-critical, distributed OO
                       | systems design and implementation.
          pjm_at_spe.com  | (C++, Java, Common Lisp, Jini, middleware, SOA)
Received on Tue Mar 04 2008 - 22:24:55 CET

Original text of this message