Re: Select whole "Objects"

"jlaffer" <jerry_at_everymail.net> wrote in message news:1140525403.781317.219830_at_g43g2000cwa.googlegroups.com...
> Thanks alot for all your input.
>
> Using binds or not is not really relevant for the problem (probably we
> wont, as the statements will be completely different and have to be
> parsed anyway).
>
> I agree that the thing i want can be compared to Business Objects (or
> other data object middleware). The problem that occured trying to use
> something like this was that it seemed not possible to "model" the
> pretty complex queries i need to get even one "object" (there are
> decodes, exists, lags/leads and such included). Sadly, as i said
> before, i am not allowed to change anything in the data sctructure to
> simplify this.
>
> Nevertheless, we finally decided to implement the following:
> As some of you suggested, the employee is a sub-object of company.
> So, in the configuration of my reporting module, i define all these
> objects and supply queries that represent the. Further i define the
> connection (columns) that should be used to link one object to the
> other (just like in Business Objects, i suppose).
>
> Any time the user uses one of the Subobjects columns (either for
> filtering the data or to display a subobjects column), the whole
> subselect is inserted into the FROM or WHERE clause.
> This is pretty similar tho what i tried to do first (and described in
> my example).. i just simplified the configuration so you get the
> "object" and "subobject" feeling and (marginally) reduced set of
> possibilities for the user.
>
> Surprisingly the performance is well and everything works fine.
>
> Many thanks,
> jlaffer
>

Now try to scale. Received on Tue Feb 21 2006 - 20:35:44 CST