Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help - Design metadata layer for dynamic joins

Re: Help - Design metadata layer for dynamic joins

From: nicky <nickyb_at_interfree.it>
Date: Thu, 04 Nov 2004 18:49:30 +0100
Message-ID: <2uv8ecF2fkfrbU1@uni-berlin.de>


AK wrote:

> I need to do create a query dynamically, based on a variable number of
> fields selected by a user.
> - A user can select from a list of hundreds of fields. The fields are
> from various related tables in one Oracle schema.
> - I have to design and build a way to create a query on-the-fly that
> returns the selected fields.
> - To avoid running a query for all the columns if only a subset of
> 1000 columns is selected, the query needs to be built with only those
> tables and joins required for the columns selected. So naturally, this
> involves creating a metadata layer with join information that will
> help create this query on-the-fly.
>
> Are there any standard design patterns for designing and building such
> a metadata layer?
>
> Any examples, tips or reference articles would be appreciated.

look http:\\nickyb.interfree.it Received on Thu Nov 04 2004 - 11:49:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US