Re: Mixing OO and DB

From: Patrick May <>
Date: Tue, 04 Mar 2008 16:24:55 -0500
Message-ID: <>

"Brian Selzer" <> writes:
> "Patrick May" <> wrote in message
>> 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.



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

Original text of this message