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/
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. |