Re: DDBMS with postgresql. - Mailing list pgsql-novice

From Serge
Subject Re: DDBMS with postgresql.
Date
Msg-id 20492061.80111299652493100.JavaMail.www@wwinf4629
Whole thread Raw
In response to DDBMS with postgresql.  (sogono@voila.fr)
List 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/




pgsql-novice by date:

Previous
From: Jayadevan M
Date:
Subject: Re: DDBMS with postgresql.
Next
From: JORGE MALDONADO
Date:
Subject: Cannot install pgAgent on Windows