Re: Mixing OO and DB

From: Bob Badour <>
Date: Fri, 29 Feb 2008 15:25:23 -0400
Message-ID: <47c85c25$0$4056$>

Eric wrote:

> On 2008-02-29, Patrick May <> wrote:

>>frebe <> writes:
>>>> I tried to be very clear with what I was saying. In the large
>>>>OO systems that I've worked on, there was no problem with
>>>>proliferation of finder methods in practice.
>>>In applications there problem with proliferation of finder methods
>>>doesn't exists, the find methods have to be very simple, like
>>>"select * from employee where id=?". Otherwise the problem do
>> Not true. The state of each element in the set of root objects
>>may be constructed from complex queries over multiple tables. The
>>objects reached from those root objects may be lazily loaded, again
>>with complex queries. Regardless of the complexity of those queries,
>>there is typically no proliferation of finder methods.

Define "complex queries". Are we talking about a query language as expressive as the relational algebra? As expressive as the relational algebra + recursion? Or something a lot less complex than that?

My experience of what some folks consider "complex" is laughable.

[snip] Received on Fri Feb 29 2008 - 20:25:23 CET

Original text of this message