Re: Mixing OO and DB
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Fri, 29 Feb 2008 15:25:23 -0400
Message-ID: <47c85c25$0$4056$9a566e8b_at_news.aliant.net>
>>frebe <frebe73_at_gmail.com> 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
>>>exists.
>>
>> 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.
Date: Fri, 29 Feb 2008 15:25:23 -0400
Message-ID: <47c85c25$0$4056$9a566e8b_at_news.aliant.net>
Eric wrote:
> On 2008-02-29, Patrick May <pjm_at_spe.com> wrote: >
>>frebe <frebe73_at_gmail.com> 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
>>>exists.
>>
>> 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