[Info-Ingres] Multi-database table references

[Raghavan]

On Sep 25, 11:51 am, "Roy Hann" <specia... at processed.almost.meat>
wrote:
> "Raghavan" <rajiragha... at gmail.com> wrote in message
>
> news:1190691609.526985.8190 at 22g2000hsm.googlegroups.com...
>
>
>
> > You have identified the problem, yes, I want to just break up one big
> > database into more manageable independent pieces.
>
> OK, so you won't be needing any gateways, which is good.  I still don't know
> if you want to use distributed transactions (i.e. one application
> transaction that affects tables in more than one database).  If that is what
> you want to be able to do, you could look at using Ingres Star, which
> imposes some limitations on what is allowed, and would require a complete
> code audit and probably some changes, or you have to write your own
> two-phase commit coordinator code.  That code isn't so hard to write, but it
> is a chore.  You will also have to get used to tracking down and killing
> failed distributed transactions--although those should be rare.
>
> If you don't need to do distributed transactions but you just need access to
> multiple databases in one application, that can be done.  Depending what
> language your applications are written in, it is more or less easy to open
> and manage multiple database connections.  If you are using ABF/4GL or a 3GL
> like C or Cobol it is deceptively easy-looking but turns out to be a
> complete bear in practice.  If you are using OpenROAD or an OO language it
> might be somewhat easier.
>
> But if you won't need to access multiple databases from one application I
> don't see anything to stop you from just going ahead and breaking the
> database up.
>
> Roy

Hello Roy!

Thanks. We are referring to only INGRES 2006 database with single
instance.
I think we are narrowing down to the problem/solution.
S, We have One huge database with multiple applications (80 odd
applications). I need to club 4-6 related applications to one
database. However, each database will access the tables from some
other database(s) . Scenario will be for select or for insert or for
update.

what I understand is Ingres STAR should suffice to my conditions.  I
hope I am correct.


Kindly advise

Raghavan