Subject Re: [firebird-support] Re: Can SQL be used in two DBs
Author Maurice Ling
Adam wrote:

> --- In, Maurice Ling <beldin79@y...>
> wrote:
> > Hi,
> >
> > This may be OT for the original question. I have a feeling that
> recently
> > there is an increase in support queries for cross-database queries
> (i.e.
> > this type of emails). It brings me to wonder if there is an increasing
> > need for work in this area. At the same time, I do not know if SQL99 or
> > SQL2003 have support for this. However, I can see that with more
> > federated databases, the need for cross-database operations may
> increase.
> >
> Of course there are uses for cross database operations. Particularily
> to balance out loads etc, allowing you to sweep on section of database
> the without impacting the performance of another section. Or
> controlling access to different pieces of information between
> organisations when no common authority is entrusted to manage it.
> The question was simple enough. Can you do this in Firebird right now?
> No. Is there other ways of achieving it? possibly but we dont have
> much information in why they want the cross db query in this case.
I have to say that I am generalizing the idea of cross database
operations. Yes, we do not have much information in this particular case
for cross db queries. But generally speaking on the whole concept of
cross db operations, looking at some of the recent researches in GIS etc
etc on using federated databases and the number of uses you've just
mentioned... Is it a feature that Firebird can consider for future releases?


[Non-text portions of this message have been removed]