Re: Mixing OO and DB
Date: Tue, 04 Mar 2008 16:24:55 -0500
"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.
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