Alain,
we currently employ views with Entities tied to them
(via container-managed persistence). this technique works
very well and eliminates the need for complex joins. we do
not use them for inserting or updating, only queries. this
is not a limitation with the technique, we have other
things going on behind the scenes that would complicate
the situation upon committing the transaction.
cheers,
bob
_____
Bob Cleaves, IP Support Systems, Qwest Communications 303.226.6539(ph)
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
303.285.0195 (fax)
> -----Original Message-----
> From: Alain Rogister [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 29, 1999 7:25 AM
> To: [EMAIL PROTECTED]
> Subject: Entity beans and RDBMS views
>
>
> Hi,
>
> Has anyone experimented with the idea of mapping entity beans
> with RDBMS
> views ?
>
> Imagine that you want to produce summary reports about the contents of
> several large database tables. You'd like to do this through entity
> beans for a number of good reasons like making security checks at the
> entity level and adding some business logic. But if you end up coding
> complex in-memory navigations between entity instances, it's easy to
> imagine horror scenarios involving massively inefficient use of the
> RDBMS.
>
> What about defining a number of (materialized ?) views that would let
> the RDBMS take care of the query processing ? Instead of
> coding complex
> navigations, you'd create "aggregate" entity beans mapped against
> summary views. Did anyone try this ? I'm thinking mostly of read-only
> views, but updatable views would also be interesting in some
> scenarios.
>
> Alain.
> --
> Alain Rogister
> Ubiquity s.a.
> http://www.ubiquity.be
>
> ==============================================================
> =============
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body
> of the message "signoff EJB-INTEREST". For general help,
> send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
