Re: DDBMS with postgresql.

From: Serge <sogono(at)voila(dot)fr>
To: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-novice-owner(at)postgresql(dot)org
Subject: Re: DDBMS with postgresql.
Date: 2011-03-09 06:34:53
Message-ID: 20492061.80111299652493100.JavaMail.www@wwinf4629
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> Hi,
>
> > What I mean is that a same database (or just some tables) is "cut"
> > into parts, and each of those parts are located in different places.
> >
> > For instance, a table TestTable(id int8 not null, first varchar(10),
> > second varchar(15), primary key(id)) exists on site A and on site B.
> > Rows are inserted into site A table; different rows are inserted
> > into site B table.
> > When a query is done on that table from one of those sites (like
> > "select * from TestTable;"), the result is the list of all rows from
> > TestTable of site A together with all rows from TestTable of site B,
> > as if it was a single local table.
> >
> > Another example is that a table TestTable exists on site A, a table
> > OtherTable exists on site B, and relationship exists between those
> > tables via, let's say, foreign key. Local queries using both tables
> > should be possible.
> >
> > This explanation may not be very clear, please tell me if that is the
> > case.
> May be you could have a look at hadoopDB?
> http://hadoopdb.sourceforge.net/guide/
> It can use PostgreSQL
> Regards,
> Jayadevan

Thanks a lot, I will check that.

Best regards,

Serge.

____________________________________________________

Suivez toute l'actualité en photos de l'émission Danse avec les stars et retrouvez les dernières dépêches sur : http://people.voila.fr/evenementiel/danse-avec-les-stars/danse-avec-les-stars-en-photos/

Browse pgsql-novice by date

  From Date Subject
Next Message JORGE MALDONADO 2011-03-09 17:15:46 Cannot install pgAgent on Windows
Previous Message Jayadevan M 2011-03-09 03:23:40 Re: DDBMS with postgresql.